I made an excel spreadsheet to calculate mpg and record trips.
It has US and Canadian Tabs depending on where you live. Also it has correction table in it so if your speedo is out and you don't have it re-calibrated in EFI or another program, you can just put the % difference in and it wiil correct your distance travelled and mpg for you. If the numbers are accurate, leave it at 100%.
ONLY INPUT DATA INTO THE BLUE CELLS
The conversions are in US Gal not Imperial. If you buy fuel in the states it's 3.88liter/gal anyhow so may as well calculate it that way all the time IMO. If you want to change it to 4.54liter/gal for Canada, change the formula in Column E in the Canadian Tab so that the end of it is 4.54 instead of 3.88 (=IF(C7=0,"",C7/3.88).
Any issues with it please post it up and I will work on fixing it but in my test runs it seemed to work fine for me.
It has US and Canadian Tabs depending on where you live. Also it has correction table in it so if your speedo is out and you don't have it re-calibrated in EFI or another program, you can just put the % difference in and it wiil correct your distance travelled and mpg for you. If the numbers are accurate, leave it at 100%.
ONLY INPUT DATA INTO THE BLUE CELLS
The conversions are in US Gal not Imperial. If you buy fuel in the states it's 3.88liter/gal anyhow so may as well calculate it that way all the time IMO. If you want to change it to 4.54liter/gal for Canada, change the formula in Column E in the Canadian Tab so that the end of it is 4.54 instead of 3.88 (=IF(C7=0,"",C7/3.88).
Any issues with it please post it up and I will work on fixing it but in my test runs it seemed to work fine for me.
Last edited:
