Fuel consumption app/spreadsheet template wanted

blue.peter

For some years, I've been tracking my fuel consumption on a phone app. However, that app is no longer supported and doesn't work properly with the latest version of Android.

Wanted: an app or spreadsheet template that'll work on my Windows 11 PC. (I use LibreOffice, in case it's relevant.)

I'll want to input date, mileage at refuelling, fuel bought in litres and cost, and have it calculate consumption in miles per imperial gallon, both since last refuelling and cumulative. There's no need for anything that tracks maintenance costs as well - I've got that covered elsewhere.

I expect that I could write a spreadsheet to do it, but I'm sure that (a) someone else has already done it and (b) theirs will be slicker than anything I could produce.

Any offers, please? I'm willing to pay for something suitable, but free is better.

k12479

Here you go. Make sure the Cumulative sums (E2 to E10, B2 to B10) are extended to capture the full data

Stubod

I use a spreadsheet I am happy to share...but can't find a way to attach it to a post...???

blue.peter

k12479 said:

Here you go. Make sure the Cumulative sums (E2 to E10, B2 to B10) are extended to capture the full data

Thanks. That doesn't quite work for me, unfortunately. It might well be quicker for me to write my own than to adapt yours to my way of working.

henry24

Why would you need to know?

TooManyPoints

This is one I made earlier. Works OK for me. The red figures are the ones you input. Unfortunately no idea how to get it to you if you want it.

 https://ibb.co/qgkptPn

blue.peter

This is what I've managed so far. It'd do, but I'd like something slicker. For example dialog boxes to enter data, and automatically copying formulae down into the newly-created line would be nice - much the sort of thing that AceMoney does when I record my spending. I believe that spreadsheets can be written with such dialog boxes, but I haven't the faintest idea how to do it.

And the formula that I've written to get the cumulative mpg looks far more complicated than the one that @k12479 uses. That's because I didn't understand theirs - either they know things I don't, or their spreadsheet works more efficiently than mine. Probably the former, I'd guess. Anyway, mine looks like this for the highlighted cell:

=(B16-$B$3)/(SUM($C$4:C16)/4.54609).

k12479

£0.85/litre   22 mpg

My miles are the amount driven since last filling up, yours is the total vehicle mileage. Both are fine.

Newer versions of Excel are smart enough to spot the pattern and copy formulas automatically as the next line is populated. Not sure about Libreoffice. Personally I'd just drag the formula cells down for the next 10/20 lines and let them show a zero division error until that line gets filled with data.

blue.peter

k12479 said:

£0.85/litre   22 mpg

Yes. Thirsty car, that was. But lovely to drive. And the maintenance costs were low. (3.0 litre Audi A4 quattro. Petrol, not diesel.)

k12479 said:

Newer versions of Excel are smart enough to spot the pattern and copy formulas automatically as the next line is populated. Not sure about Libreoffice.

Ah, I see. No, LibreOffice doesn't do that.

Shedman

Have you looked at Fuelly.  Not an app but via a browser and very simple to use and its free.  You can set UK units (e.g. enter fuel in litres but have mileage in MPG) - www.fuelly.com. I've been using it for around 10 years and find it very handy.

blue.peter

Shedman said:

Have you looked at Fuelly.  Not an app but via a browser and very simple to use and its free.  You can set UK units (e.g. enter fuel in litres but have mileage in MPG) - www.fuelly.com. I've been using it for around 10 years and find it very handy.

No, I wasn't aware of it. Thank you. I'll take a look. But it doesn't sound as if it's for me - I'd prefer to hold my data locally, not on the web.