Fuel Calculator Excel sheet

Not sure if this is useful to anyone but I've created an excel spreadsheet which takes 4 inputs (date, fuel cost, fuel price and mileage reading) and works out:
Miles Per Day
Fuel litres
Gallons
MPG
MPL
Remaining L (when you filled up)
Miles Remaining (when you filled up)
Pence Per Mile
Miles Per Tank

and also averages most of the above, from the averages it works out what your flashing and solid light reserves should be and when your next service should be due.


Yes I know its excessively geeky and probably I'm the only one interested enough but just in case I thought I'd put it up here.
Sadly you need office 2007 to make proper use of the averages, it might work with the office 2007 filters available from Microsoft but I'm not sure and can't test that at the moment.

Here's the link if anyone wants to try it out, its populated with sample data to give you an idea of how it works.
http://www.brettnet.co.uk/gallery2/T.../fuelcalc.xlsx

not geeky at all, very useful, recommend it to anyone...
i use fuel-s.s for my truck and bike

Rommel would be proud of us!

[Spiderman]

hmmm cant open that with excel but i'd be interested in trying it out.

[mr.anderson]

My dad does this with his car.

Approx figures:
In his Land Cruiser (4x4, yes, semi necessary in SA) done 170 000km (110 000mi) in 7 years and put over 60 000l of fuel into it. Wowzers, imagine what that would have been in pounds.

Failry random in the grand scheme, but actually quite handy info to have in many respects, especially when it comes to servicing etc.

If you have an older version of excel this might help you open it:
http://www.microsoft.com/downloads/d...displaylang=en
Least i'm not alone in my fuel curiosity

[RingDing]

That's not geeky at all! I have one just the same. I have all the fill up information since I bought the bike brand new over two years ago. So I can tell you that over the last 14500 miles I've averaged 55.6mpg. I also have all service, insurance, tax costs in to work out my pence per mile and use it to predict my next service date. Also plots average monthly mpg against average monthly temp, which shows an interesting correlation.

I love spreadsheets me, and anyone else who does is a friend of mine!