Excel Gas Mileage Log - anyone have it?
#1
Excel Gas Mileage Log - anyone have it?
Does anyone here have the Excel Gas mileage file from f150.net here? Thought I might try it, but the link is dead on their page. If anyone has it and can send it to me, I would be very grateful.
DJOHN101@columbus.rr.com
Also, what do you think of the program? Is it worth playing around with it?
Thanks everyone!!
DJOHN101@columbus.rr.com
Also, what do you think of the program? Is it worth playing around with it?
Thanks everyone!!
#2
It's not hard to make your own...
Column A:
Date
B:
Mileage
C:
Gallons
D:
Price/gal
E:
Cost
F:
MPG
In excel you type it like this:
=(Bx - Bx-1)/Cx where x is your current row, so if you were at row 25, it would look like so: =(B25-B24)/C25
You have to do this everytime...I havent found a way to have excel do it automatically. You could create a macro but I havent done it.
G:
Other notes (oil changes, balance/rotate tires, etc)
It's nothing fancy, but it gets the job done.
What does the one from f150.net look like? Anything special about it?
Column A:
Date
B:
Mileage
C:
Gallons
D:
Price/gal
E:
Cost
F:
MPG
In excel you type it like this:
=(Bx - Bx-1)/Cx where x is your current row, so if you were at row 25, it would look like so: =(B25-B24)/C25
You have to do this everytime...I havent found a way to have excel do it automatically. You could create a macro but I havent done it.
G:
Other notes (oil changes, balance/rotate tires, etc)
It's nothing fancy, but it gets the job done.
What does the one from f150.net look like? Anything special about it?
#3