Mileage calculating excel sheet - Ranger-Forums - The Ultimate Ford Ranger Resource


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

Reply
 
LinkBack Thread Tools Search this Thread
  #1  
Old 08-24-2006
Member
Thread Starter
 
Join Date: Jun 2004
Location: Somewhere, XYZ
Posts: 4,351
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
Reply With Quote
  #2  
Old 08-24-2006
optikal illushun's Avatar
Member
 
Join Date: Oct 2004
Location: Coal Region, MTC to be exact...heart of the coal region.
Posts: 2,232
i keep a spreadsheet like that but not as complex. i have been keeping it for over a year and my have prices changed.
Reply With Quote
  #3  
Old 08-24-2006
Member
Thread Starter
 
Join Date: Jun 2004
Location: Somewhere, XYZ
Posts: 4,351
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!?!
Reply With Quote
  #4  
Old 08-24-2006
fx4me's Avatar
Member
 
Join Date: May 2005
Location: CA
Posts: 1,507
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.
Reply With Quote
  #5  
Old 08-24-2006
Strider0O0's Avatar
Member
 
Join Date: Jul 2004
Location: Philadelphia, PA
Posts: 3,588
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.
Reply With Quote
  #6  
Old 08-24-2006
Member
Thread Starter
 
Join Date: Jun 2004
Location: Somewhere, XYZ
Posts: 4,351
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!
Reply With Quote
  #7  
Old 08-24-2006
fx4me's Avatar
Member
 
Join Date: May 2005
Location: CA
Posts: 1,507
I guess I shoudl have said that you fill up a lot compared to me. I only fill up about 2 times a month...
Reply With Quote
  #8  
Old 08-24-2006
gatorblue92's Avatar
RF Veteran
 
Join Date: Jun 2004
Location: Delaware
Posts: 8,238
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
Reply With Quote
Reply

Related Topics
Thread Thread Starter Forum Replies Last Post
Who is familiar with Excel? rangrdangr_4x4 General Ford Ranger Discussion 8 01-29-2010 02:22 PM
Calculating Suspension Travel VentureCrew35 Suspension Tech 7 11-20-2007 07:27 PM
calculating gas mileage kb8398 2.3L & 2.5L I4 Tech 4 05-12-2007 02:28 PM
Alignment Sheet, Need Cam Kit, Pic of sheet inside THE EDGE Suspension Tech 8 11-10-2005 07:17 PM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -6. The time now is 07:01 AM.


We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.