View Single Post
Old Jun 14, 2014 | 01:34 AM
  #22  
dojj's Avatar
dojj
Resident Wrestling Legend
20 Year Member
Liked
Loved
Community Favorite
iTrader: (3)
 
Joined: May 2003
Posts: 50,018
Likes: 259
From: Little India
Default

Originally Posted by Glenn_
How do you work out mpg people.
i've got a spreadsheet for my fuel usage for both cars

along the top it says:

date - mileage - distance covered - fuel used (litres) - fuel used (gallons) - cost per litre - litres/mile - total cost - mpg

the date is obvious, when you fill up
the mileage is the total mileage on the odometer
the program then works out the miles covered since the last fill up
then i input how many litres of fuel i put in
the program then coverts this to gallons
then i input the cost per litre of fuel
and by using maths, the program then spits out how much it's cost me per mile and how much the mpg was
the last 3 fill ups on the mondeo worked out to be 16.71 mpg, 22.68mpg and 20.33 mpg
only started to do the fiesta this past week and that was 21.07 mpg (but it's all stop start and 1 mile there and 1 mile back type of stuff)

over the course of a few months you should be able to see a decent pattern forming, and if you start to add in where you filled up and what you put into it, it may also show you which fuel is best for economy too
Reply