Recording Fuel usage

johnk68

Hi, does anyone have or know of a decent excel spreadsheet that I am able to record my fuel usage(total costs, mpg etc) ?

Thanks

Carrot007

Yes an excel spreaheet would do fine.

Why look for one, just create one for your own needs. You know what you want to record.

johnk68

Carrot007 wrote: »

Yes an excel spreaheet would do fine.

Why look for one, just create one for your own needs. You know what you want to record.

I tried but then failed miserably

DoaM

I've got one that I've used for years (and tweaked over time). It is very easy - below is a basic version:

A1 = Date
B1 - Miles
C1 - Litres
D1 - Gallons
E1 - MPG

A2 - Enter date of fill up
B2 - Enter miles travelled since last fill up
C2 - Enter litres of this fill up
D2 - =IF(C2>0,C2/4.54609,"")
E2 - =IF(C2>0,B2/D2,"")

Repeat above for rows 3, 4, 5 etc. at each fill up.

jimjames

If Excel is too hard why not try one of the fuel apps or online like Fuelly or FuelLog/Fuelio

maninthestreet

https://www.fuelly.com

scaredofdebt

I built a website to track this type of thing as well as other costs, repairs, servicing etc. It includes a reminder for MOT, Insurance, Tax etc, if anyone wants to try it out (it's free) just PM me.

worried_jim

maninthestreet wrote: »

https://www.fuelly.com

Used this for five years and recommend.

johnk68

maninthestreet wrote: »

https://www.fuelly.com

Have ended up using this website and downloading the 'acar' app that syncs with it.

Thanks for your help:beer:

Ectophile

I used to use a pencil and paper. And a calculator. It was a lot easier to write things down just after I'd filled up.