Joined
·
920 Posts
I have been using an Excel file to track MPG and service records for a long time. It contains 3 worksheets:
I don't have a lot of data yet since my truck is still fairly new but I am currently averaging 15.2 MPG over 2009 total miles, which isn't bad since I only had about 40% highway driving so far and I have been racing around and manually shifting a good bit during the last 500 miles. It was good to see that the Tundra AFE is nearly dead on with the actual MPG as calculated by my gas receipt data. It is important to compare the MPG to Average Speed since speed is one of the biggest factors in fuel economy. If you are hauling a load or towing then make a note in the worksheet to explain the anomaly. If you haven't changed anything but your MPG takes a sharp dive then you might have a bad tank of gas or possibly a more serious service problem.
I have included screen shots from the file below and you can download it here if you want to use it for your own truck. You can also copy the worksheets and then modify them to track another vehicle in the same file, like I do for my wife's RAV4.
Enjoy.
Tundra MPG:
Tundra Chart:
Tundra SVC:
- Tundra MPG - the data entered from my gas receipts
- Tundra Chart - visual trend of MPG compared to Average Speed
- Tundra SVC - a log of all service records
I don't have a lot of data yet since my truck is still fairly new but I am currently averaging 15.2 MPG over 2009 total miles, which isn't bad since I only had about 40% highway driving so far and I have been racing around and manually shifting a good bit during the last 500 miles. It was good to see that the Tundra AFE is nearly dead on with the actual MPG as calculated by my gas receipt data. It is important to compare the MPG to Average Speed since speed is one of the biggest factors in fuel economy. If you are hauling a load or towing then make a note in the worksheet to explain the anomaly. If you haven't changed anything but your MPG takes a sharp dive then you might have a bad tank of gas or possibly a more serious service problem.
I have included screen shots from the file below and you can download it here if you want to use it for your own truck. You can also copy the worksheets and then modify them to track another vehicle in the same file, like I do for my wife's RAV4.
Enjoy.
Tundra MPG:

Tundra Chart:

Tundra SVC:
