Kriesel
Well-known member
I thought I'd throw this out there to anyone that may want a spreadsheet for tracking fuel mileage and stuff... I've shared this on other forums in the past as well. I started this thread in the tool section of GJ since this kinda falls into the tool category in my opinion.
I've had this spreadsheet built for a long time now, and have updated it now and then. There are a couple pages/tabs inside it, and it does fuel mileage, gear ratios, tire sizes, speed corrections, simulated 1/4 miles times, blah blah blah, lots of math, blah... I've left my own vehicle in the spreadsheet as an example of how it works. Delete all the info that's there in yellow boxes, and put in your own.
Let me know if you have any suggestions to improve it.
Some historical conversation about it can be seen here:
http://forums.tdiclub.com/showthread.php?t=243038
File can be downloaded from Google Box here (copy/paste the link if you can't click on it... Doesn't seem to re-direct correctly from GJ to Box.com):
Standard spreadsheet (MPG) in .xlsx format:
https://app.box.com/s/1ou0a91otg36rie2zyfl
Standard spreadsheet (MPG) in .xls format (had issues in the past with .xlsx in Linux):
https://app.box.com/s/5js0iwtkme30g1rx78bo
Metric spreadsheet (L/100km) in .xlsx format:
https://app.box.com/s/ry2ofmh8oczvu9hirird
Metric spreadsheet (L/100km) in .xls format (had issues in the past with .xlsx in Linux):
https://app.box.com/s/tczf731zfmr54gn3s782
I recently switched my personal version of my spreadsheet to a google sheets document, and in the process I needed to modify some things to make it work correctly compared to excel. Click the link, and it will allow you to view it within your google drive. In order to edit it make a copy on your own drive, and it will then be your own copy. You should then be able to delete the first one, and use the one you copied as your own. Again, as with other versions, change any of the text in yellow boxes to your own, as I've left some data there for an example.
So, here is a Google Sheets version:
https://docs.google.com/spreadsheets/d/1rkmSZGEmEIh8LXOkHPtb4C6GWZlSiAx_0nRgVFUEiG0/edit?usp=sharing
I've had this spreadsheet built for a long time now, and have updated it now and then. There are a couple pages/tabs inside it, and it does fuel mileage, gear ratios, tire sizes, speed corrections, simulated 1/4 miles times, blah blah blah, lots of math, blah... I've left my own vehicle in the spreadsheet as an example of how it works. Delete all the info that's there in yellow boxes, and put in your own.
Let me know if you have any suggestions to improve it.
Some historical conversation about it can be seen here:
http://forums.tdiclub.com/showthread.php?t=243038
File can be downloaded from Google Box here (copy/paste the link if you can't click on it... Doesn't seem to re-direct correctly from GJ to Box.com):
Standard spreadsheet (MPG) in .xlsx format:
https://app.box.com/s/1ou0a91otg36rie2zyfl
Standard spreadsheet (MPG) in .xls format (had issues in the past with .xlsx in Linux):
https://app.box.com/s/5js0iwtkme30g1rx78bo
Metric spreadsheet (L/100km) in .xlsx format:
https://app.box.com/s/ry2ofmh8oczvu9hirird
Metric spreadsheet (L/100km) in .xls format (had issues in the past with .xlsx in Linux):
https://app.box.com/s/tczf731zfmr54gn3s782
I recently switched my personal version of my spreadsheet to a google sheets document, and in the process I needed to modify some things to make it work correctly compared to excel. Click the link, and it will allow you to view it within your google drive. In order to edit it make a copy on your own drive, and it will then be your own copy. You should then be able to delete the first one, and use the one you copied as your own. Again, as with other versions, change any of the text in yellow boxes to your own, as I've left some data there for an example.
So, here is a Google Sheets version:
https://docs.google.com/spreadsheets/d/1rkmSZGEmEIh8LXOkHPtb4C6GWZlSiAx_0nRgVFUEiG0/edit?usp=sharing
Last edited: