Gas Milage Worksheet - Ranger-Forums - The Ultimate Ford Ranger Resource


General Ford Ranger Discussion General discussion of the Ford Ranger that does not fit in any other sub-forum.

Reply
 
LinkBack Thread Tools Search this Thread
  #1  
Old 01-04-2005
Member
Thread Starter
 
Join Date: May 2004
Location: McKinney, TX
Posts: 2,123
Gas Milage Worksheet

Excel Worksheet, what I use to calculate my gas milage. Share yours if you got something different/better...
Reply With Quote
  #2  
Old 01-04-2005
solodos's Avatar
Member
 
Join Date: Jun 2004
Location: NOVA (Northern Virginia)
Posts: 361
mine is almost exctly the same but i added in the correction fo rbiugger tires

and i dont have averages, i may have to add that
Reply With Quote
  #3  
Old 01-04-2005
eXtremePC's Avatar
Member
 
Join Date: Sep 2004
Location: St. Peters, MO
Posts: 355
a calculator
Reply With Quote
  #4  
Old 01-04-2005
Bigwill41's Avatar
Member
 
Join Date: Jun 2004
Location: Navasota, Texas
Posts: 4,659
I don't have software for this :(
Reply With Quote
  #5  
Old 01-04-2005
Member
 
Join Date: Jun 2004
Location: Somewhere, XYZ
Posts: 4,351
That's a cool sheet. I have a modified version of a sheet Swoops posted some time ago on GE. If someone would be willing to post it I'd be willing to email it to them..
Reply With Quote
  #6  
Old 01-05-2005
WholesaleMN.com's Avatar
Member
 
Join Date: Jun 2004
Location: Blaine, Minnesota
Posts: 246
I just use the calculator on my Cell phone. :) it works. but is really hard to post it on here.
Reply With Quote
  #7  
Old 01-05-2005
Rand's Avatar
Member
 
Join Date: Jun 2004
Location: Barberton,Ohio
Posts: 1,189
If anyone wants a good office program.
www.openoffice.org
it opens all microshaft office stuff and its free :)

(that file works perfect in it)

Rand
Reply With Quote
  #8  
Old 01-05-2005
Swoop1156's Avatar
Member
 
Join Date: May 2004
Location: Hanover, Maryland
Posts: 1,965
Quote:
Originally Posted by NHBubba
That's a cool sheet. I have a modified version of a sheet Swoops posted some time ago on GE. If someone would be willing to post it I'd be willing to email it to them..
Would you mind sending that to me? I remember I made a fairy decent one back in the day, but I don't have it anymore. I will also, in turn, host it for you!

Michael, your's looks nice, just like mine, only different.
Reply With Quote
  #9  
Old 01-05-2005
FoMoCoFiddy's Avatar
Member
 
Join Date: May 2004
Location: Smackdownville Tx
Posts: 4,508
Quote:
Originally Posted by Swoop1156
just like mine, only different.

Same difference huh?

Way to contradict your own statement.. Oxymoron? lol :D
Reply With Quote
  #10  
Old 01-05-2005
Member
Thread Starter
 
Join Date: May 2004
Location: McKinney, TX
Posts: 2,123
The only thing I don't like about mine is the cost per mile calc on each line. It calculates the # of miles you report on the next fillup divided by the previous # of gallons. This works OK, until you have a partial fillup before a long trip, and that results in my .42 cents per mile one time, and $0.03 the next time. But the overall average at the top is 100% accurate.
Reply With Quote
  #11  
Old 01-05-2005
Member
 
Join Date: Jun 2004
Location: Somewhere, XYZ
Posts: 4,351
I'll have to take a closer look when I find a sec, but every sheet I've ever used requires you to either ride the tank down to a specified point every fillup and divide the miles driven since the last fillup divided by the amount pumped at the PREVIOUS fillup (how far you got on that gas) OR to fillup to a given point every time and divide the miles driven by the quantity pumped at THIS fillup (how much gas you used on the last segment). Personally I prefer the latter as it's impossible (in my experience) to find a gas station immediately at the same point in every tank.

I haven't entered the figures in yet, but this last weekend I did some poor tank management. I ended up on empty while up in the resort area where I ski. Usually I buy as little as I can, including fuel up there because it's a good 10-20% more expensive. Unfortunately I needed fuel badly, so I pumped $10 worth just to get back to civilization. I will now have a large dip and a large spike in my MPG figures. I figure it averages out in the long run, but it will effect things in the short term..

I've yet to figure a way around this..
Reply With Quote
  #12  
Old 01-06-2005
Rand's Avatar
Member
 
Join Date: Jun 2004
Location: Barberton,Ohio
Posts: 1,189
All you have to do is fill the tank every time. and it will be 100% accurate.
Since I drive 67miles a day JUST for work... thats every 3 days lol.

The other thing you can do is average the last 3-5 times and you will get a much more accurate number if you like to just toss in 10$ or whatever

sometimes you pull your hair out trying to design a perfect spreadsheet..
its frustrating lol.

Rand

Last edited by Rand; 01-06-2005 at 05:55 AM.
Reply With Quote
  #13  
Old 01-06-2005
Member
 
Join Date: Jun 2004
Location: Somewhere, XYZ
Posts: 4,351
100% uh? If so why do you get more accurate figures if you average several fillups? Accuracy is a relative thing. It's tuff to know you are really filling the tank to the same level EACH time. My figures always varry a bit. I cound on the long term averages being most telling..
Reply With Quote
  #14  
Old 01-06-2005
Member
 
Join Date: Jun 2004
Location: Somewhere, XYZ
Posts: 4,351
Quote:
Originally Posted by Swoop1156
Would you mind sending that to me? I remember I made a fairy decent one back in the day, but I don't have it anymore.
Found it! Now I just need your email. Drop me a PM. .. Fair warning though, I have modified it a bit. Gone is your little information block w/ all the averages and long-term data in one spot. Added is maintenence info. Oh, and I added your sheet as a new sheet in the excel file that had the sheet I kept for my '99 (the first ~34k miles anyhow).
Reply With Quote
  #15  
Old 01-06-2005
Member
Thread Starter
 
Join Date: May 2004
Location: McKinney, TX
Posts: 2,123
I don't think there is any reliable way to empty a tank to the same level each and every time before fillup. That only affects calculations for each fillup, which doesn't mean much anyway. What's most important is the lifetime averages. A few spikes here and there are ok.
Reply With Quote
Reply

Related Topics
Thread Thread Starter Forum Replies Last Post
gas milage on a 3.0 snake109 2.9L & 3.0L V6 Tech 28 10-30-2006 02:52 AM
Incredibly low gas milage spec_ops57 General Ford Ranger Discussion 13 04-07-2006 08:10 AM
How can I improve my gas milage?? 2002Ranger4x4 General Ford Ranger Discussion 22 02-22-2006 08:36 PM
Gas Milage Dude 2.9L & 3.0L V6 Tech 11 08-29-2005 01:33 AM
gas milage too low stillrolling Ranger-Forums Office 32 06-24-2005 10:07 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 09:47 PM.


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.