a couple of people have asked me for the file and instead of hosting it i'll just email it out
here's a screenshot of it:
this one is mine & i have it set up like this so i can track it over the course of the loan i took out on it. it also has a metric conversion page to it. basicaly it was made for my girlfriend who lives in a metric country & is doing trend analysis & statistcal stuff, but hey, if you like seeing your metric numbers go for it (put the currency conversion rate to 1 so it doesnt throw the numbers off). it also doesnt have a per tank MPG check, only total averages, BUT you can put on in pretty easily. use the formula =(D2-D3)/A2 to get the avg for the fuel you bought on your last tank. i dont know if this has anything to do with it & dont really intend on checking it out but i always fill my tank when i gas up so if someone only buys say 20 in gas i duno how it'll effect the averaging. IE say you buy 20 in gas one trip to the pump & then only 10 for instance. if anyone wants some help with this spreadsheet or has an idea for another spreadsheet i'd be more than happy to make one (if i can =p)