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.

Attached Files

CamryTracker.xls (20.5 KB, 102 views)

Read it now!

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

Attached Files

CamryTracker_v2.xls (33.0 KB, 30 views)

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.

Attached Files

Honda Stats.xls (23.5 KB, 59 views)

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

http://test5477.blogspot.com

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.

Attached Files

2007 Honda Civic Hybrid.xls (42.5 KB, 20 views)

1978 Plymouth Horizon - 165,527 miles, still the longest lasting
1985 Dodge Daytona - 62,500 miles and the transmission gave out
1991 Mazda Protoge - A very good car
1997 Ford Contour - This one saved my life in a driver side impact accident
2000 Pontiac Grand Am - I have a bulls eye painted somewhere, this one was rear-ended
2004 Civic Hybrid - My first Honda, My first Hybrid, ran 88,300 miles before the tax rebates came calling
2007 Civic Hybrid - Going strong and a joy to drive
___________________________________________

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

Attached Files

Gas Mileage.xls (23.0 KB, 15 views)

When I drive the car


When Wife drives the car