mileage speadsheet

[mattc]

As the title says. Does anyone have an excel speadsheet they could send to me via PM and email please?

I am too thick to create my own

 

[NoodlerUK]

What do you want the spreadsheet to do?

 

[mattc]

Fair point

I want to log litres purchased, cost, distance between refuelling, price per mile. Nothing to extraordinary.

I know some of you chaps keep these sort of records on an ongoing basis and I want to track my useage

matt

 

[renault12ts]

There you go, you've done it yourself.

Open an empty spread sheet and put each of those things at the top of a separate column...and hey presto.

When you try to close it, you will be asked if you want to save it...yes...then you will be asked to give it a title.

You can have as many columns as you like.

 

[wemorgan]

There are also various online places that will do this for you

MPG and Cost Calculator and Tracker - Spritmonitor.de
Fuelly | Share and Compare Real World MPG

 

[mr. shr]

You can have as many columns as you like.

As long as you don't want more than 256.

 

[renault12ts]

As long as you don't want more than 256.

Smart ass.

 

[mattc]

There you go, you've done it yourself.

Open an empty spread sheet and put each of those things at the top of a separate column...and hey presto.

When you try to close it, you will be asked if you want to save it...yes...then you will be asked to give it a title.

You can have as many columns as you like.

yes..preferably one with the SUMS already running in the background

 

[Shude]

I created a new spreadsheet when I bought my new car at the end of November last year.

The column headings are as follows:

Date | Station | Grade | Litres | PPL | Total | Distance | MPG | km/l | g/km | l/100km | est. range

I manually enter the date, station, grade, litres, total and distance, the PPL MPG km/l g/km, l/100km and estimated range are calculated for me. I suppose it could do more, I did consider writing a formula for pence per mile but it confused me (the fuel economy and price for fuel are actually on separate receipts/events if you think about it).

 

[Spinal]

There are a few android apps that'll do ti for you... I remember seeing one that used the gps to calculate miles travelled automaticallyl...