* MPG Calculations Spreadsheet * (with stars!)

mr tommo · 19 Jun 2011 at 23:53

EDIT : Updated 16th September 2019

Editable spreadsheet to compare mileages against mpg for both Petrol and Diesel Cars.

Find this useful to refer back to when considering a new car or comparing costings on diesel vs petrol.

Link to spreadsheet : Feel free to amend the fuel prices to suit you :

https://docs.google.com/spreadsheets/d/1SsaTPh4fepc3zn4XA34PujOHW4nKOgBdYLXyd00NMVY/edit?usp=sharing

Jonnycoupe · 19 Jun 2011 at 23:57

Column doesn't go far enough to the right

mr tommo · 19 Jun 2011 at 23:58

*** MPG Calculations Spreadsheet *** (with stars!) (for real cars)

Jonnycoupe · 19 Jun 2011 at 23:59

69MPG average over 167k is real enough

Wizardskills · 20 Jun 2011 at 00:00

mr tommo said:
I can't find somewhere to upload that wont compress the spreadsheet but this is the best size I can get at the moment.

Nice, it really shows how little the differences are. You could always put it on Google Docs as an uneditable spreadsheet? It think Google docs will import an xls file.

mattyprice4004 · 20 Jun 2011 at 00:03

Get it online, I like this.

mr tommo · 20 Jun 2011 at 00:06

Wizardskills said:
Nice, it really shows how little the differences are. You could always put it on Google Docs as an uneditable spreadsheet? It think Google docs will import an xls file.

Ok will give that a go now. Just wanted it as an imagefile so people didn't have to click to access.

griffo_001 · 20 Jun 2011 at 00:08

Jonnycoupe said:
Column doesn't go far enough to the right

Or to the left

mr tommo · 20 Jun 2011 at 00:11

Updated OP with link to Google Docs spreadsheet

If anyone would actually like more MPG figures left or right you can do it yourself now

Frozennova · 20 Jun 2011 at 07:56

I did this origonally but now use the fuel log on my android phone

Participant · 20 Jun 2011 at 11:02

Very good, now why not have the formulae pointing at a couple of source cells with the fuel prices in them, so you just have to plug the current fuel price in and it recalculates itself. Now you know about absolute and relative cell references and sensitivity analysis, i.e. how much difference does a 10p rise in fuel make to someone doing 10k miles per annum at 35 mpg.

mr tommo · 20 Jun 2011 at 12:05

That's a good point don't know why I didn't think of that. Will sort that out tonight if I get chance.

realscot · 20 Jun 2011 at 12:20

No collum for 26?

mr tommo · 20 Jun 2011 at 12:52

No sorry was going to go up in increments of 2 but the spreadsheet was getting a little big for a Sunday night

Can add it in later if you want?

BennyC · 20 Jun 2011 at 13:21

Thanks for putting this together.

Philz0r · 20 Jun 2011 at 17:30

thanks for this. pretty cool

Django x2 · 20 Jun 2011 at 18:40

Columns don't go down far enough either

saitrix · 20 Jun 2011 at 19:22

Why don't people just work it out? It isn't that hard.

annual mileage / mpg = number of gallons per year

gallons * 4.55 = number of litres per year

litres * price per litre = total year cost

Participant · 20 Jun 2011 at 19:41

saitrix said:
Why don't people just work it out? It isn't that hard.

People do

.

Adam · 20 Jun 2011 at 19:47

saitrix said:
Why don't people just work it out? It isn't that hard.

annual mileage / mpg = number of gallons per year

gallons * 4.55 = number of litres per year

litres * price per litre = total year cost

Alright Carol Vorderman. Spreadsheets are easier, fact!