[Dropped] Spreadsheet for monthly income/expenses

annchris · Post by **annchris** » Sat May 08, 2021 8:57 am

Wonder if you can direct me to a manual regarding auto sum and subtract. I have Window 365, but really don't like it. I have looked on google for tutorials, but I find them confusing. What a need is a spread sheet that I can enter monthly income subtract monthly bills, and have a running total . What I had with wordexcell is. I would put and amount, subtract an amount and it would give me a total, and so forth. I hope that I have made my shelf understood. Kind regards Ann

edit this topic's initial post · Post by **Villeroy** » Sat May 08, 2021 9:46 am

Whatever you have in Excel, open it with OpenOffice Calc, then save it in Calc's native format (*.ods) and continue working with that.

annchris · Post by **annchris** » Sat May 08, 2021 10:44 am

Thank you or your prompt reply this is what I get I have open it in Office cal and saved it in your suggestion and I get this
3,000.00
-299.99
2,700.01
-700.00 postage
-700.00

It doesn't deduct the 700.00 postage from the balance 2,700.01.

I don't know what I'm doing wrong
Kind regards Ann

edit this topic's initial post · Post by **Villeroy** » Sat May 08, 2021 10:48 am

How to attach a document here

Post by **RoryOF** » Sat May 08, 2021 10:51 am

It would be helpful if you would upload the small sample sheet to the Forum; listing the data as you did does not allow us see the internal structure/data types, which a sample sheet would do. The upload tab is below the Submit button on Post Reply and Full Editor screens.

It is probable that if you have -700.00 postage in one cell, it is all text, and text has a numeric value of zero.

Post by **RoryOF** » Sat May 08, 2021 11:09 am

A predefined budget spreadsheet for Calc may be downloaded from
https://templates.openoffice.org/en/tem ... preadsheet

This may be over-complex for your needs.

edit this topic's initial post · Post by **Villeroy** » Sat May 08, 2021 11:59 am

Works for me.
I put the cell cursor below the -700
-700.00 postage
hit the "auto sum" button left of the formula bar and get
4700,02 below the -700

Post by **RoryOF** » Sat May 08, 2021 12:06 pm

That is an incorrect sum, Villeroy. It the running total is 2700.01, then applying -700 (postage) and -700 (next line), the answer should be 1300.01.

annchris · Post by **annchris** » Sat May 08, 2021 12:42 pm

I have done spread sheet for you to look at of how I would like to do with spread sheet. POSTREPLY button (or click the Full Editor button ) But I can't see anything that lets me attach the spread sheet for you to see. I'm sorry I'm really struggling with this spree sheet. in Excel that I used to use before, I just entered a balance then all I had to do is insert an amount to add, or a minus amount and just click on the Autosum button. Kind regards Ann

Post by **RoryOF** » Sat May 08, 2021 1:07 pm

Click on "Post Reply" button, go down to "Upload Attachment" tab below the Submit button, click on "Select File" and select the file to upload, then click on "Add the file" button.

OpenOffice is not Excel; they work quite similarly, but there are differences.

annchris · Post by **annchris** » Sat May 08, 2021 1:47 pm

The extension is not allowed.
Your message contains too few characters.

I'm sorry when I download the file it tells me this, thank you for being so helpful, being more 80 than 70 modern technology doesn't come easy

Post by **RoryOF** » Sat May 08, 2021 1:54 pm

Simply tag your file .ods.zip or .xls.zip and enter some text in the message for the posting "Here is a sample file" or similar.

annchris · Post by **annchris** » Sat May 08, 2021 2:05 pm

Here is the file for you

Post by **robleyd** » Sat May 08, 2021 2:11 pm

No file attached; you may have missed a step in RoryOF's instructions, possibly the clicking on the Add file button?

See How to upload a file which has some images which may help you.

annchris · Post by **annchris** » Sat May 08, 2021 2:30 pm

I'm sorry don't know what is happening It is telling me the extension is not allowed. Thank you for your help anyway

Post by **robleyd** » Sat May 08, 2021 2:37 pm

What is the extension of the file you are trying to upload - e.g. .xlsx, .ods, ??? Or, what type of file is it?

edit this topic's initial post · Post by **Villeroy** » Sat May 08, 2021 2:39 pm

OK; create a new spreadsheet, save it in Calc's native ods format.
Dump your data in column A and put this into any cell besides column A: =SUM(A1:A1048576) whcih sums up all numbers in A.

What is the extension of the file you are trying to upload - e.g. .xlsx, .ods, ??? Or, what type of file is it?

Windows users do not see any file name extension. They know nothing about it. Since 26 years they fumble around with a desktop system which relies massively on file name extensions while hiding them away from its users.

annchris · Post by **annchris** » Sat May 08, 2021 3:31 pm

Thank you I'm getting out of my comfort zone. Thanks for tryin to help me I really appreciate it. I shall have to do it manually

edit this topic's initial post · Post by **Villeroy** » Sat May 08, 2021 5:12 pm

annchris wrote:Thank you I'm getting out of my comfort zone. Thanks for tryin to help me I really appreciate it. I shall have to do it manually

Preferably with pan and paper.

annchris · Post by **annchris** » Sat May 08, 2021 6:52 pm

Not pan and paper, I shall go back to Microsoft. Once again thank you for your help

[Dropped] Spreadsheet for monthly income/expenses

[Dropped] Spreadsheet for monthly income/expenses

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spread sheets

Re: Spreadsheet for monthly income/expenses