Excel Gas Mileage Log - anyone have it?

Thread Tools
 
Search this Thread
 
  #1  
Old 03-04-2004, 12:59 AM
Engine391's Avatar
Senior Member
Thread Starter
Join Date: Feb 2004
Location: The Buckeye State!!!!!
Posts: 113
Likes: 0
Received 0 Likes on 0 Posts
Question 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!!
 
  #2  
Old 03-04-2004, 02:05 AM
Johngs's Avatar
Senior Member
Join Date: Sep 2003
Location: Aggieland, TX
Posts: 3,053
Likes: 0
Received 0 Likes on 0 Posts
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?
 
  #3  
Old 03-04-2004, 03:05 AM
Engine391's Avatar
Senior Member
Thread Starter
Join Date: Feb 2004
Location: The Buckeye State!!!!!
Posts: 113
Likes: 0
Received 0 Likes on 0 Posts
It is kind of hard to see, because the screenshot is so small, but it is basically the same as what you just mentioned. Here is the link:

Gas Log
 
  #4  
Old 03-04-2004, 03:36 AM
Johngs's Avatar
Senior Member
Join Date: Sep 2003
Location: Aggieland, TX
Posts: 3,053
Likes: 0
Received 0 Likes on 0 Posts
Yep, not much different than mine:

 
  #5  
Old 03-04-2004, 06:51 AM
petersde's Avatar
Senior Member
Join Date: Sep 2003
Location: Friendswood, Texas
Posts: 293
Likes: 0
Received 0 Likes on 0 Posts
Engine391...

Check your email. I've sent the one I use. It also provides a mileage performance and trend graph:

Graph

Dave
 



Quick Reply: Excel Gas Mileage Log - anyone have it?



All times are GMT -4. The time now is 01:57 PM.