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.

 

Increase the column width to 10.5. Right click the E column and select column width.

 

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.

 

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)

 

Thanks, will give that a try later.
It would be cool to add columns for tires, wheels, alignments, oil changes, ect.

 

If you PM me your email address I'll add the columns and sum them for you. I work with excel all day. (Accounting)

 

PM sent, thanks.

 

True master of the Spread Sheet



had to go there....lol

 

Or this guy: