Excel Gas Mileage Log - anyone have it?

Thread Tools
 
Search this Thread
 
Old Mar 4, 2004 | 12:59 AM
  #1  
Engine391's Avatar
Thread Starter
|
Senior Member
Joined: Feb 2004
Posts: 113
Likes: 0
From: The Buckeye State!!!!!
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!!
 
Reply
Old Mar 4, 2004 | 02:05 AM
  #2  
Johngs's Avatar
Senior Member
Joined: Sep 2003
Posts: 3,053
Likes: 0
From: Aggieland, TX
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?
 
Reply
Old Mar 4, 2004 | 03:05 AM
  #3  
Engine391's Avatar
Thread Starter
|
Senior Member
Joined: Feb 2004
Posts: 113
Likes: 0
From: The Buckeye State!!!!!
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
 
Reply
Old Mar 4, 2004 | 03:36 AM
  #4  
Johngs's Avatar
Senior Member
Joined: Sep 2003
Posts: 3,053
Likes: 0
From: Aggieland, TX
Yep, not much different than mine:

 
Reply
Old Mar 4, 2004 | 06:51 AM
  #5  
petersde's Avatar
Senior Member
Joined: Sep 2003
Posts: 293
Likes: 0
From: Friendswood, Texas
Engine391...

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

Graph

Dave
 
Reply




All times are GMT -4. The time now is 01:58 AM.