Joined
·
2,226 Posts
About a year ago I started getting anal about recording all kinds of statistics about my cars. So when I bought my Mo, it was no exception. I'm keeping track of everything that I can think of to keep track of.
Below is a screenshot of my "Gas Statistics" Excel spreadsheet. Starts with the very first tank of gas that I ever put into the Mo from day one. The only thing I don't have is what type of fuel was in the tank when I took delivery at 8 miles on the clock!
I'll be switching to synthetic oil at my next oil change in another 1000 miles or so, continuing with Premium gas. Then, probably at the following oil change, I'll switch over to regular gas. Just curious as to what will happen.
Some explanation about these numbers:
1) I like driving fast and hard, so consider these "spirited driving" numbers.
2) Most miles so far should be considered city miles, although I have mixed in a bit of highway as well.
3) "Auto MPG" is what the onboard computer calculates (reset each fillup). MPG is what Excel calculates as ColumnF/ColumnD.
4) "AVG MPG" is calculated using "MPG" and is a running average over time.
5) "MPG % DIFF" is calculated as ((G/J)1)*100, so it is essentially "how far off is the onboard MPG calculation" (Row 7 & 8 are a little off, I think the pump didn't fill up the tank completely on that fillup, so those two lines should probably be averaged out).
6) "AVG SPEED" is what the onboard trip computer calculates (reset each fillup).
I manually enter numbers up to Column H, the rest are calculated cells.
Enjoy!
Below is a screenshot of my "Gas Statistics" Excel spreadsheet. Starts with the very first tank of gas that I ever put into the Mo from day one. The only thing I don't have is what type of fuel was in the tank when I took delivery at 8 miles on the clock!
I'll be switching to synthetic oil at my next oil change in another 1000 miles or so, continuing with Premium gas. Then, probably at the following oil change, I'll switch over to regular gas. Just curious as to what will happen.
Some explanation about these numbers:
1) I like driving fast and hard, so consider these "spirited driving" numbers.
2) Most miles so far should be considered city miles, although I have mixed in a bit of highway as well.
3) "Auto MPG" is what the onboard computer calculates (reset each fillup). MPG is what Excel calculates as ColumnF/ColumnD.
4) "AVG MPG" is calculated using "MPG" and is a running average over time.
5) "MPG % DIFF" is calculated as ((G/J)1)*100, so it is essentially "how far off is the onboard MPG calculation" (Row 7 & 8 are a little off, I think the pump didn't fill up the tank completely on that fillup, so those two lines should probably be averaged out).
6) "AVG SPEED" is what the onboard trip computer calculates (reset each fillup).
I manually enter numbers up to Column H, the rest are calculated cells.
Enjoy!
Attachments

77.6 KB Views: 1,677