Spending on motoring.

[Jocko]

I am a week away from my first year as a Honda Jazz owner. Everything I have spent on it has been logged in a spreadsheet. I also keep a diary of what I have done to the car and also for logging journeys other than the day to day taxiing of Mrs Jocko.
Every year end I top off with fuel and then do a year end audit. I tabulate cost/mile, average weekly running expenses, average weekly mileage and such like. I have done this for years (it is just so much easier using a computer).
Anyone else as anal?

[peteo48]

Yes !

I have always kept a detailed record of my fuel consumption manually using the brim to brim method. I used to log this in a book but I now use Fuelly.com - there are other sites that do a similar thing. It gives you graphs and pie charts - I love a good pie chart!

I also keep a record of all maintenance and repairs in an accounts book.

[Jocko]

I first started with a notebook and pen back in 1978. I'd just bought a 3 year old FIAT 126. I've recorded every car and bike since. Back in 1997 I moved over to using the computer, with my Vauxhall Cavalier 2.0i CD.

[John Ratsey]

I've always kept a record of the fuel. That's how I discovered that my Austin A35 gave around 36mpg irrespective of how it was driven (and with a 5 gallon tank it needed frequent refuelling). However, I've only got about 15 years of records in a spreadsheet and haven't seen the previous paper logs recently.

[jazzway]

I love my spreadsheets, for everything.    

Here a screenshot of the maintenance overview, it's linked to a list with every part changed, installed, when, where and the costs, plus it's linked to the fuel consumption list.

[Jocko]

My paper logs had to go. I had no room to bring them with me when I left the family home. They might still be there but all I have now is the past 20 years on computer. First fill up, back in 1997, cost 66.7p/litre. Cavalier had 90K miles on it when I bought it and I did a further 90K before giving it to my nephew. I did 82.5K with my Volvo (as you can see I soon get tired of my cars!). Think the Jazz will see me out. Next July I have to reapply for my licence! I remember when I got the first computer licence, back in 1973, and it said it expired in 2018. Never believed that would ever come round.

[peteo48]

Loving the spread sheets Jazzway. My IT skills are not the best but I'm tempted to drag myself into the 21st century!

[jazzway]

Loving the spread sheets Jazzway. My IT skills are not the best but I'm tempted to drag myself into the 21st century!

Thanks!
With my work in the IT business it is maybe a little easier, but i am by no means a spreadsheet specialist. I am happy to help you if you want! This spreadsheet is in iOS Numbers, btw.

The reason i made it is that our brother in law maintains our car (he owns an independent garage) and he encouraged me to order the parts myself to save us some costs. The spreadsheet 'warns' me in time to order stuff, which i order for a part in the UK. I print out a complete calendar year list of maintenance, work and other parts (lamps, tires, etc.) and that goes into the service booklet of the car.

[madasafish]

I use Fuelly .Much simpler.

https://www.fuelly.com/driver/madasafish/jazz?fu=5188302

[Jocko]

I use Fuelly too, but only for my petrol and not for any other costs.
Checked your link but it just said
Error
There was a problem accessing this vehicle

[jazzway]

The spreadsheet is more than a fuel/costs calculator like Fuelly and Spritmonitor. I also use Spritmonitor.

I use Fuelly too, but only for my petrol and not for any other costs.
Checked your link but it just said
Error
There was a problem accessing this vehicle

I thought you used Spritmonitor, like me?

[Jocko]

I use both. Spritmonitor lets me post here. Fuelly allows lots of info in signature which doesn't work here.

[RichardA]

I've been keeping a spreadsheet for years of my fuel log. I did briefly use a phone app but the records went a bit wonky if I didn't update for a while. (can't remember the name of app, but it was a free Android-based app).

I added the mpg readout column to the spreadsheet to compare the trip computer with the spreadsheet calculations. The From column was to see if there was any difference in using branded or super unleaded over supermarket unleaded.

[attachment deleted by admin]

[Jocko]

Surprisingly similar to me, Richard.

[peteo48]

I'm massively impressed with your mpg Jocko. Of late I've been averaging 40 or slightly less. What type of motoring do you do? I have to say I do a lot of short journeys and relatively little motorway or other trunk road type work.