4.0L OHV & SOHC V6 Tech General discussion of 4.0L OHV and SOHC V6 Ford Ranger engines.

Mileage calculating excel sheet

Thread Tools
 
Search this Thread
 
  #1  
Old 08-24-2006
NHBubba_Revisited's Avatar
Member
Thread Starter
Join Date: Jun 2004
Location: Somewhere, XYZ
Posts: 4,351
Likes: 0
Received 0 Likes on 0 Posts
Mileage calculating excel sheet

Here is a spreadsheet I have worked up that calculates MPG and a bunch of other handy stats if you keep a fuel log. I cleared out all but the first ~25 or so entries. ($1.479! Anybody remember when fuel was that cheap?!) The only problem is that I don't know how to make formulas automatically go to the end of the sheet, so as you add data you need to update the formulas to include the new data too. Kinda sux, but I don't know enough about excel to do any better..

Anyhow, someone at ORR asked for it, so I figured I'd post it here too.

I keep a paper & pen log-book in my truck. Every few weeks, months, or whever I feel the urge I bring it into the house and add the new data as needed.

http://www.blckout.com/nhbubba/Misc/...0-%20Blank.xls
 
  #2  
Old 08-24-2006
Join Date: Oct 2004
Location: Coal Region, MTC to be exact...heart of the coal region.
Posts: 2,232
Likes: 0
Received 4 Likes on 4 Posts
i keep a spreadsheet like that but not as complex. i have been keeping it for over a year and my have prices changed.
 
  #3  
Old 08-24-2006
NHBubba_Revisited's Avatar
Member
Thread Starter
Join Date: Jun 2004
Location: Somewhere, XYZ
Posts: 4,351
Likes: 0
Received 0 Likes on 0 Posts
Yes. One lovely statistic from my fuel log: In the time I've been working my current gig, gas prices have gone from $1.089/gal to $3.099/gal, a spread of 184%!

In that same time my pay has increased aproximately 11%.. And my boss wonders why I gave notice last Monday AM!?!
 
  #4  
Old 08-24-2006
fx4me's Avatar
Member
Join Date: May 2005
Location: CA
Posts: 1,507
Likes: 0
Received 1 Like on 1 Post
man you fill up a lot! haha

i have one i started when i got my truck, but not nearly as fancy as yours. but i also include dates that i did mods that might 'help' my mpgs to see if they really do anything.
 
  #5  
Old 08-24-2006
Strider0O0's Avatar
Member
Join Date: Jul 2004
Location: Philadelphia, PA
Posts: 3,588
Likes: 0
Received 0 Likes on 0 Posts
i need to put one together.

right now, my spreadsheet is in my center console, lol. i always use one card i have for gas.. so all receipts go right from the gas pump right into the console... it's getting tough, whenever i pop it open to push another in, they all jump out like they're spring loaded or something, lol.
 
  #6  
Old 08-24-2006
NHBubba_Revisited's Avatar
Member
Thread Starter
Join Date: Jun 2004
Location: Somewhere, XYZ
Posts: 4,351
Likes: 0
Received 0 Likes on 0 Posts
Huh? Back then I filled up maybe every 5-7 days.. once a week. Considering the truck was my new 'toy' for that time.. that ain't bad at all.

Now I fill up every other day! (60 mile each way, 5 days/week)

As dad says: That's life in the big city!
 
  #7  
Old 08-24-2006
fx4me's Avatar
Member
Join Date: May 2005
Location: CA
Posts: 1,507
Likes: 0
Received 1 Like on 1 Post
I guess I shoudl have said that you fill up a lot compared to me. I only fill up about 2 times a month...
 
  #8  
Old 08-24-2006
gatorblue92's Avatar
RF Veteran
Join Date: Jun 2004
Location: Delaware
Posts: 8,238
Likes: 0
Received 2 Likes on 2 Posts
i fill up weekly... getting pricy which is why i was driving the benz more lately till it broke yesterday... that excel sheet is pretty good though
 
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
rangrdangr_4x4
General Ford Ranger Discussion
8
01-29-2010 01:22 PM
VentureCrew35
Suspension Tech
7
11-20-2007 06:27 PM
kb8398
2.3L & 2.5L I4 Tech
4
05-12-2007 01:28 PM
THE EDGE
Suspension Tech
8
11-10-2005 06:17 PM



Quick Reply: Mileage calculating excel sheet



All times are GMT -6. The time now is 08:27 PM.