[Dropped] Spreadsheet for monthly income/expenses

Discuss the spreadsheet application

[Dropped] Spreadsheet for monthly income/expenses

Postby 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
Openoffice 4.1-7
annchris
 
Posts: 8
Joined: Sat May 08, 2021 8:39 am

Re: Spread sheets

Postby 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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29708
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Spread sheets

Postby 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
Openoffice 4.1-7
annchris
 
Posts: 8
Joined: Sat May 08, 2021 8:39 am

Re: Spread sheets

Postby Villeroy » Sat May 08, 2021 10:48 am

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29708
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Spread sheets

Postby 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.
Apache OpenOffice 4.1.10 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32534
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spread sheets

Postby RoryOF » Sat May 08, 2021 11:09 am

A predefined budget spreadsheet for Calc may be downloaded from
https://templates.openoffice.org/en/template/personal-budget-spreadsheet

This may be over-complex for your needs.
Apache OpenOffice 4.1.10 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32534
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spread sheets

Postby 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
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29708
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Spread sheets

Postby 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.
Apache OpenOffice 4.1.10 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32534
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spread sheets

Postby 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
Openoffice 4.1-7
annchris
 
Posts: 8
Joined: Sat May 08, 2021 8:39 am

Re: Spread sheets

Postby 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.
Apache OpenOffice 4.1.10 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32534
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spread sheets

Postby 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
Openoffice 4.1-7
annchris
 
Posts: 8
Joined: Sat May 08, 2021 8:39 am

Re: Spread sheets

Postby 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.
Apache OpenOffice 4.1.10 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32534
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spread sheets

Postby annchris » Sat May 08, 2021 2:05 pm

Here is the file for you
Openoffice 4.1-7
annchris
 
Posts: 8
Joined: Sat May 08, 2021 8:39 am

Re: Spread sheets

Postby 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.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.4.6.2 (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3953
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Spread sheets

Postby 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
Openoffice 4.1-7
annchris
 
Posts: 8
Joined: Sat May 08, 2021 8:39 am

Re: Spread sheets

Postby 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?
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.4.6.2 (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3953
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Spread sheets

Postby 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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29708
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Spread sheets

Postby 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
Openoffice 4.1-7
annchris
 
Posts: 8
Joined: Sat May 08, 2021 8:39 am

Re: Spread sheets

Postby 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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29708
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Spreadsheet for monthly income/expenses

Postby 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
Openoffice 4.1-7
annchris
 
Posts: 8
Joined: Sat May 08, 2021 8:39 am


Return to Calc

Who is online

Users browsing this forum: FJCC and 15 guests