Tony Raine

For the last few years, I have kept up with my fuel usage. I have also enjoyed having Excel do all the work for me. Since I see a lot of threads asking about fuel mileage, I figured I would share my method.

When I had my explorer, I kept track of every fill-up for over 2 years. I need to dig that up and share it as well. I had more info on it calculated for me, I'm keeping this one pretty basic for now.

While initial setup can take a little time (and playing with colors/fonts), once you are done, entering it is very easy. I just write my trip OD mileage for every fill-up on my receipt, although I am thinking about changing it to actual OD mileage. Once I have a few in the glovebox, I enter it in on the computer. Just a click on a desktop shortcut, a minute or 2, and I'm done.

Here is a screen shot of my excel file for every fill-up since I have owned this truck. I only enter what is in yellow. The black boxes show the formula for that column. I just use the grey column for little notes I think are important.



if thats too small to read, click the thumbnail for a full version

Lenn

Impressive... I wish I had a firm Excel grasp. It can come in sooo handy.

shotgun

Very nice. I do the same thing (engineer with OCD), but I cheated...

http://www.vertex42.com/ExcelTemplat...alculator.html

Tony Raine

Thank you! Excel intimidated me at first, but now stuff like this is easy for me. Just jump into the program and start playing with it. the help files show how to enter the formulas. I could even write up a step-by-step with screen shots, but that will take awhile (I'm very detail-oriented).

mustangGT90210

I wish I had a fancy way of showing how I consistently get 17mpg... Nice work!

Tony Raine

but you can! different borders, tons of colors for text and backgrounds, different fonts...... the combinations are endless


I just like to keep track of that stuff, I guess I'm just OCD. It helps me budget out how much money to spend on fuel during the different seasons. Also, a large discrepancy in MPG can help alert me of potential engine/transmission problems. plus its just neat to look at

and, every time there is a thread asking about mpg, I can just link here


btw, these number may not even be 100% accurate. my truck has larger than stock tires, but not by much. its not hard to go back in and change the formula though, once i figure out the % the speedometer is off.

yes, i have an edge on the way, so i'll just be accurate from there on out.

CrashTECH

I was going to use excel, but I don't know that it is worth the effort. Right now Fuelly gives me everything I need: http://www.fuelly.com/driver/crashtech/f150

They have a mobile version that lets you log fuel ups from your smartphone. The only thing I recently used Excel for as far as fuel and stuff goes is I used it to help me gauge how long it would take me to earn back money I invest in eFans and UDP, etc. I don't plan on modding for MPG, because that is silly, but as a side benefit it helps to know when it will pay for itself.

Tony Raine

thats a pretty cool site, never knew it even existed. yeah, i don't mod for mpg either, but i like to get the best possible for my setup. my chart does flash into my mind every time i think about flooring the gas petal, though....

bikerboy

i am getting 13.5 mpUS gallon, and that is about the best i have seen so far, hopefully it will get better in the summer, with summer gas.

its a 2006 f-150 screw FX4 short box, with 50 000 miles on it.

although i will say my old 98 scab 4x4offroad with 4.6 was about the same on gas..

Tony Raine

Thats actually pretty darn good for Canada in the winter