Who here is a master of spread sheets?
05-16-2007, 03:04 PM
#1
Who here is a master of spread sheets?
A member here made me a fuel/mpg tracker before I got the FJ.
http://www.pnw4runners.com/fj/fjc_mpg_maint.xls
There is an error another guy told me on cell F42 for the Union 76 entry of $50.
It is causing the total cost I have spent so far on gas to malfunction.
If you erase the entries back to it, the total price pops back up again.
What could be wrong with it?
I even entered in a new entry and it still does it.
http://www.pnw4runners.com/fj/fjc_mpg_maint.xls
There is an error another guy told me on cell F42 for the Union 76 entry of $50.
It is causing the total cost I have spent so far on gas to malfunction.
If you erase the entries back to it, the total price pops back up again.
What could be wrong with it?
I even entered in a new entry and it still does it.
05-16-2007, 03:31 PM
#3
Thou surely art a master of the spread sheet 
I found doing it to column E instead fixed it.
I increased it from 7.5 something up to 10, and that fixed it.
I guess they do not auto correct themselves when a higher numerical value is computed.
Thank you very much!
The revised one is now uploaded in its place.
Now if only the darn maintenance tab worked so you can tally up tune up parts and more.
I found doing it to column E instead fixed it.
I increased it from 7.5 something up to 10, and that fixed it.
I guess they do not auto correct themselves when a higher numerical value is computed.
Thank you very much!
The revised one is now uploaded in its place.
Now if only the darn maintenance tab worked so you can tally up tune up parts and more.
05-16-2007, 03:54 PM
#4
Registered User
Join Date: Feb 2006
Location: Bay Area, CA
Posts: 37
Likes: 0
Received 0 Likes
on
0 Posts
Hey I finally get my first productive post!
You could have also highlighted the entire sheet and changed the font size to 5 or 6. But that would have made it a little harder to read.
I did not see a column for parts cost on the maintenance tab. To add one, right click a column then select add column. If you want it to sum, highlight the cells you want to sum plus one empty cell, then click the sum button (it's the funky sideways M looking one on the toolbar next to the undo button). Or use the formula
=sum(cell:cell)
You could have also highlighted the entire sheet and changed the font size to 5 or 6. But that would have made it a little harder to read.
I did not see a column for parts cost on the maintenance tab. To add one, right click a column then select add column. If you want it to sum, highlight the cells you want to sum plus one empty cell, then click the sum button (it's the funky sideways M looking one on the toolbar next to the undo button). Or use the formula
=sum(cell:cell)
Trending Topics
Thread
Thread Starter
Forum
Replies
Last Post
kawazx636
The Classifieds GraveYard
34
10-06-2021 03:03 PM
