This is the spreadsheet I am using to track miles and data. Improve it if you like, I did not intend on making it to user friendly.

 

Read it now!

 

I changed the formulas to avoid displaying the zeros on unused lines.

 

Here's mine. I just insert a new line when I fill it up, and change the range on the graph to include the new data. It shows very well the seasonal changes in economy from mild months to very cold and very hot months. I'm in Utah, where summer can be over 100 for weeks straight, and winter can be teens or colder for weeks straight.

 

thanks guys, as a new owner I think these will both come in handy.

 

Attached is my spreadsheet for tracking the gas mileage of my Saturn Hybrid Vue.

Some of my features include:

• I compute a rolling 3 tank average. This average smooths out the highs and lows that may occur from fillup to fillup.
• I run a scenario that compares my Hybrid Vue to a Non Hybrid Vue. I computed a 5 mpg increase with the Hybrid over the Regular Vue. That figures then generates cost savings based upon mpg and price per gallon. I could change that difference and compute a new cost savings.
• I count up tanks over 30mpg, 32 mpg, 34mpg and 36mpgs and compute the % of time I hit these marks.
• I also count up tanks over 500 miles and compute %.
• I computer Summer Gas mpg and Winter Gas mpg. Summer for me runs 3/1 to 10/31 and Winter is 11/1 to 2/28
• I also chart MPG over time with a regression line.
• I also keep track of brand and location of gas.
• I also have up and down arrows for the tank mpg based upon my lifetime mpg.
• I also computer cost per mile - based upon gas only.
• I also summarize my gallons saved.

You may ask why do all this? Well, I enjoy it and it only takes a few minutes for each tank entry once I got the layout setup. By the way, I am consistantly adding new features to the spreadsheet. Enjoy!

Saturn Hybrid Vue

Saturn Gas Stats.xls

 

Braden, Many thanks for the spreadsheet.

The dates highlighted in red indicate two partial fillups occurred, hence the reason the total gallons exceed the 12.3 gallon capacity of the Civic Hybrid.

 

Glad you could use it!

 

Thanks for the guide. I'll be using this from now on. Too bad, that I've had the car for a bout 2 months now, so my first 4 full tanks won't be included.

 

I have an spreadsheet that I've been using but - I do not have a graph. Could someone help me? I would like to have a graph showing the data. Thanks. Bruce