Where do I get a Spread Sheet to do the following?

Hi everyone


I have a mid-2012 MacBook Pro, and I need a Spreadsheet to do the following:


1) At the top, I need about 10 columns that I can assign a different name to each column(Date, Amex, Advanta, Discover, Chase, MasterCard, etc).

2) I want to put the date at the beginning of every row, and then go to the appropriate column, and put a number in (5/16/17 Discover $245.00, Advanta $288.32, MasterCard $566.32, etc.

3) I want each column to keep a running total somewhere at the bottom.


When I'm through putting in all my numbers, ideally I would want no space between the last entry in the column and the running total for that column.


Lastly, I don't want to spend too much money, as this is truly a one time thing.


Any suggestions will be gladly appreciated


Thanks,
Jerry

If you have a Gmail account, use Google Sheets. You can also use Numbers on your Mac which is the spreadsheet app from Apple.

Hi RazOrEdge


So there is a Template already made that will have multiple columns that I can put the name of each Credit Card at the top of each column, and every input on a row (except the Date column) will have a running total of the row at the bottom?

If so, will Google Sheets have that Template already made?

Thanks!
Jerry

digiplay said:

Lastly, I don't want to spend too much money, as this is truly a one time thing.

Click to expand...

If you can't find anything already made that fits your needs...make your own spreadsheet. From what you describe needing...it's a fairly elementary spreadsheet to setup.

- Nick

Hi Mr. Nick

But I have NEVER made ANY Spreadsheet, so how will it be a fairly elementary to setup a spreadsheet up if I have no idea how to do so?


That's why I asked if there is one that is setup already so that all I have to do is write a name at the top of each column, and put date on the first column, and then put a number in the correct CC column.

That being said, what the heck do I do, I have to have this done before Monday (a 15 year tally of Credit Card charges to about 6 different Credit Cards)?


As an aside, I did it the old fashioned way, and I have all the info on paper already (except the total for each Credit Card), but the person who wants these numbers wants all the info in a spreadsheet format, and he wants me to email him a spreadsheet.


But as I initially said, I have NEVER made ANY Spreadsheet

Thanks,
Jerry

What you want is very simple to do..open up Numbers and you'll see the rows and columns. Type the names you want on top.

Enter the information you want on each row and then at the bottom of each column, use the formula "=SUM(B2:B30)" assuming you have 29 rows of data. If you have more or less, change the B30 to be less or more. Once you've gotten the first column done, move the selection cursor over that total column and hit CMD+c to copy and then move to the next column (C) and hit CMD+v to paste it and the formula will automatically update to C and repeat this for every column and it will automatically update.

Now THAT I can do

Thank you (and everyone else as well)!!!!!!

Jerry

digiplay said:

But I have NEVER made ANY Spreadsheet, so how will it be a fairly elementary to setup a spreadsheet up if I have no idea how to do so?

Click to expand...

The reason why I said this sort of thing is elementary...is that it's probably one of the first lesson's you are taught in a class working with spreadsheets. If you & I were sitting at the same computer...I could probably show you what to do in only 5-10 minutes. Most of the work & time is the data entry for the 15 year tally of the credit card charges.

Of course now you're in a time crunch (Monday) to get this done. Would have been nice if you had the chance to open a spreadsheet app and mess around with it in the last 15 years (before having a time crunch). Knowing how to use word processing & spreadsheet apps are two very common computing skills almost everyone should be able to do. I've been using spreadsheet & word processing apps since the mid-1980's...and I am not a computing professional.

Almost everyone from the minimum wage worker to presidents of large corporations should know how to use spreadsheet & word processig apps. After you get this project done...I would highly recommend "playing around with" a spreadsheet app.

In any case...you should be able to find a pre-made spreadsheet that fits your needs somewhere on the internet. By the way...if you've never made any spreadsheets before...and therefore may not be familiar with using a spreadsheet app. What spreadsheet app are you going to be using for this project...and how are you going to go about entering the data if you've never worked with a spreadsheet before?

- Nick

Stop the Presses!

My MBP is used for recording Music (LPX), I have 10.8.5, and EVERYTHING works fine as it is, thank you very much

That being said, I tried to download it and got the following Message:

Numbers can’t be installed on “Mac” because OS X version 10.12 or later is required.


Crap, what do I do now?


Thanks,
Jerry

digiplay said:

Now THAT I can do

Click to expand...

That's what I meant by "elementary"! I think that the person that wants this data...simply want's it to be in a digital format (and entered into a spreadsheet)...so that they don't have to use a lot of time entering all the 15 years of data themselves.

Of course revisit this thread if you run into any issue's.

Good luck Jerry,

- Nick

digiplay said:

Numbers can’t be installed on “Mac” because OS X version 10.12 or later is required.

Crap, what do I do now?

Click to expand...

Try downloading & using the free app called "Open Office". It contains a spreadsheet app...and the download works with OS 10.7 and higher:

https://www.openoffice.org/download/index.html

- Nick

pigoo3 said:

What spreadsheet app are you going to be using for this project...and how are you going to go about entering the data if you've never worked with a spreadsheet before?

- Nick

Click to expand...

That's why I asked my initial question, I have no idea which spreadsheet to use.

As far as entering the data, that why I said what I wanted to do (put a different CC at the top of each columns/put a date on the first row of each column, and then simply type a number on the corresponding column row).

pigoo3 said:

Try downloading & using the free app called "Open Office". It contains a spreadsheet app...and the download works with OS 10.7 and higher:

https://www.openoffice.org/download/index.html

- Nick

Click to expand...

And use the same running total formula?

digiplay said:

That's why I asked my initial question, I have no idea which spreadsheet to use.

Click to expand...

That wasn't the question I asked. I asked "What spreadsheet application" you were going to use? This is a totally different question from what sort of spreadsheet you were going to use. You need to have a spreadsheet application first...before working with a spreadsheet.

Some common spreadsheet apps are:

- Apple's "Number's"
- Microsoft's "Excel"
- "Open Office" that I mentioned above.

- Nick

digiplay said:

And use the same running total formula?

Click to expand...

Almost all spreadsheet applications work the same way. What you need to do is very simple & easy...so yes...Open Office, Numbers, or Excel will work the same way.

- Nick

Nick, I'm 99% there

I downloaded Open Office, named the first column (A) Date, the second column (B) Advanta, and the third column (C) Discover.

On the first row, I put a date, and as a test, put $44,22 on the Advanta column.

On the second row, I put a different date, and put $100.00 on the Advanta column.

I then went to row 29 of column B (the Advanta column), and attempted to paste "=SUM(B2:B30)" to the Advanta column, but I get Err522.

What am I doing wrong?


Added today at 03:34 AM:

I pasted the formula at the bottom of the date column (column A), and it puts the correct total of column B on the bottom of column A.

I copy and paste the formula to the next column, it gives the correct total, but one column to the left, not the correct column.

Also, if I input $100.00, it reads back as $100. How do I make it keep the extra 0's?

Lastly, I'm sure I will email the finished spreadsheet as a pdf, but the person I'm sending it to only has a PC.

Will he be able to open it (it says the file is an ods)?

Last questions tonight

1) Will a PC be able to open an ods file created n my Mac?
2) My brother has a HP Computer. Would it be better to do a spreadsheet on it.
3) He uses the HP just for surfing the net, so he won't have Excel, Word, etc. on it. Is there a free spreadsheet for PCs, or possibly a free Excel software that I can use for my aforementioned one task of documenting Credit Card charges?

Thanks in advance,

Jerry

ods files are an open document format that Open Office uses to save spreadsheets in.

1. A PC should be able to open the files
2. Probably not necessary for the kind of simple spreadsheet you are describing. It should work fine without being created on a PC.
3. There is a version of Open Office for the PC. The spreadsheet module is called Calc. You can find the download at http://www.openoffice.us.com

If the person you will be sending the file to does not need to edit the information, sending a PDF will be fine. If they have Excel or a similar spreadsheet, they should be able to edit the file.

digiplay said:

Nick, I'm 99% there


I then went to row 29 of column B (the Advanta column), and attempted to paste "=SUM(B2:B30)" to the Advanta column, but I get Err522.

What am I doing wrong?

Click to expand...

Your formula includes the row you entered the formula in, as well as the next row. The "ending cell" in that kind of (summation) formula must be at least one row above the row the formula is entered in. So, in your case, in row 29 "=SUM(B2:B28) will work.

It's kind of basic, but you COULD use tables in Word to do the same thing, if you are familiar with Word. Or even if you have it written out by hand you could scan it and use Adobe Acrobat to copy and paste it into a Word table or a spreadsheet, then just correct the scanning errors rather than typing in the whole thing.

If it was my project, I would use Adobe Acrobat and scan the written copy then Excel, but since you are unfamiliar with spreadsheets if you know Word, you could try that too.

EDIT: sorry a little late since you have already started with OpenOffice.