I have been working on a detailed Excel sheet layout, with calculations for many different options. Once I get this more finished I can make it available for those that may want to import data from here and be able to do more with the information.
It should be pointed out, that this is by NO means meant to take away from here! Just a way to get more out of your entries, track more info, and provide nearly all the calculations for you. As it is now, I update this site with my 3 vehicles every single time I fillup, but I also use my own spreadsheet.
Its a work in progress yet. There are a lot of calculations going, and I keep revamping and trimming so it takes some work. Once I finalize the import setup, auto calc setup, and some walk through VB scripts I will put up a trial version or two within the next month. (I work on it in my spare time) At the moment this is done in US measurements only, though I use KM and L conversions for my Canada version Caravan.
Here is a screenshot of the totals page, which gives me some useful info:
http://art.cariboucomputers.com/beretta/mpgcalc.jpg
All figures in red are calculated. Data is pulled from other sheets, each with their own vehicle track. They are then totaled and shown here. Each vehicle page has a summary section similar to this.
Any interest, let me know. If you have something similar you wish to share or offer suggestions of things to add, by all means do so!
Thanks!
__________________