Convenient Fuel Economy Spreadsheet for MS Excel

[JayDee]

EDIT: 5/6/05 Added a graph to the spreadsheet to reflect MPG.

Well I got bored this afternoon and put all of my fill-ups into a spread sheet form.

The sheet keeps track of individual fill-ups, with gallons pumped, miles driven, and MPG fields.

The sheet automatically outputs OVERALL averages for: MPG, Miles Per Tank, Gallons Per Fill-Up, Worst MPG, Best MPG.

Hope somebody finds this useful!

JD

[VShortt]

Originally Posted by JayDee

Well I got bored this afternoon and put all of my fill-ups into a spread sheet form.

The sheet keeps track of individual fill-ups, with gallons pumped, miles driven, and MPG fields.

The sheet automatically outputs OVERALL averages for: MPG, Miles Per Tank, Gallons Per Fill-Up, Worst MPG, Best MPG.

Hope somebody finds this useful!

JD

I'll give it a whirl simply because you were kind enough to generate the spreadsheet. Thanks for your efforts.

[Gig'em]

Yeah, thanks. I'm going to give it a try.

[bradward]

I've Taken your spreadsheet and added to it including a chart with MPG trendlines and a Moving average for your Fuel economy.

The information for my Titan is included but can easily be replaced by your own info.

hope someone gets some use from this.

[JayDee]

NICE work! I'm going to modify mine to include a few of your fields.

Thanks
JD

[SuperT]

Thanks JayDee, after spending the day on the phone with Microsoft and Cisco, I can appreciate someone who put in some formulas to make a spreadsheet work!

[HavockWK]

Thanks dudes! I have been considring oe of these, but I suffer from TriKKy's signature.

[p_bratton]

Here's my total from 4/04 to present

Average MPG 14.07
Average Miles per Tank 250.60
Average Gallons per Fill-up 17.77
Lowest MPG 12.40
Highest MPG 17.97

[Pot Hole]

I've been tracking my mpg from the second fill-up to-date. I'm already on the second page of a legal pad. This program will be sweet, and allow me to see trends much easier.

Thanks guys!

[JayDee]

I added a simple line graph that charts your MPG vs. Tank Number. If anything it looks cool.



I suspect that if you write some comments out to the side of each tank, such as "Vacation, all hiway miles", or "Towed 7500lb trailer" you'll be able to come back and say "ohhh that's why my mileage was bad that tank."

[TriKKy]

Originally Posted by HavockWK

Thanks dudes! I have been considring oe of these, but I suffer from TriKKy's signature.

It's a ***** ain't it. I would have replied sooner but you know.....bah, Ill finish my response later.

[JayDee]

Updated Excel gas mileage spreadsheet!

Here are some screenshots:




Check it out...

http://www.redrockfabrication.com/ti...tanmileage.xls

[skytop]

Thanks JayDee!

[pistonpete]

Thanks JayDee and bradward....

I have been wanting to do something like this for awhile but never got around to it. Your efforts are definitely appreciated.