MPG Calculations ....

Kinky

MB Enthusiast
Joined
Apr 23, 2003
Messages
1,316
Location
Berkshire
Car
All sorts of odds n sods
Now some of us are unfortunate (or perhaps fortunate in some cases) to not have a dash display teslling us avg MPG, overall MPG, etc ... and therefore we have to resort to manual calculations (using the good old trusty Lotus 1-2-3.

However - Depending on which way I caculate my data I get different results - either 23.33 or 22.97 MPG which differ again from on-line MPG calc tools.

So - my question - do we have any folks here who could very reliably tell me what my MPG is (without resorting to an on-line tool).

I have a spreadsheet I can send with all relevant data if need be.

many thanks in advance,
 
OP
OP
Kinky

Kinky

MB Enthusiast
Joined
Apr 23, 2003
Messages
1,316
Location
Berkshire
Car
All sorts of odds n sods
hummm .... I'm doing all that.

At fill-up time:

Take the number of litres, then divide that 0.22 for gallons

Then add the cost and price per litre.

I then take my current mileage minus my last fill-up mileage divided by the number of gallons.

From the data above I also work out miles per litre, cost per mile and litres per 100kms.

Still not convinced. I'm basing my cost per mile on the cost of the previous fill-up (as that's the actual fuel I used).

I'll have a play.
 

jimmy

MB Enthusiast
Joined
Aug 8, 2002
Messages
2,316
Location
Northamptonshire
Car
Discovery 3 TDV6, Discovery 300TDi - Plaything!
Originally posted by Kinky
Depending on which way I caculate my data I get different results - either 23.33 or 22.97 MPG which differ again from on-line MPG calc tools.

I have a spreadsheet I can send with all relevant data if need be.

:eek: :eek:

Wow!!
 
OP
OP
Kinky

Kinky

MB Enthusiast
Joined
Apr 23, 2003
Messages
1,316
Location
Berkshire
Car
All sorts of odds n sods
I'll mail it to you if you want

just not absolutely 100% confident with it.
 

Flyer

MB Enthusiast
Joined
Oct 16, 2002
Messages
1,638
Location
Houston, Texas
Car
Ford Mustang GT
Here's my Excel spreadsheet. I can send you the original if it would be of any use? (although it's not polished)

mileage.gif


Cheers

Andrew
 
Last edited:
OP
OP
Kinky

Kinky

MB Enthusiast
Joined
Apr 23, 2003
Messages
1,316
Location
Berkshire
Car
All sorts of odds n sods
Andrew - that would be really cool if you could.

As a test I can drop your numbers into my file and see if I get the same results as you.

If not - then I'll just switch to that other product that's not 1-2-3.

You can mail it to krankenhoffen@hotmail.com

That will be very much appreciated. Thank you.
 

Flyer

MB Enthusiast
Joined
Oct 16, 2002
Messages
1,638
Location
Houston, Texas
Car
Ford Mustang GT
Check your mailbox (and ignore the DIV/0 errors!!)

Let us know how you get on.


Cheers

Andrew
 

Michael

New Member
Joined
May 29, 2003
Messages
22
Location
Buckinghamshire
Car
380SL / A160
Hi,

I'm curious.

I keep an eye on my MPG on my SL (3.8 V8 ) but only roughly. As for the A160, only enough to make sure that something hasn't gone drasticly wrong.

Here I see that you are concerned by the possibility of being point something of a mile adrift.

Is this an unhealthy obsession :crazy: or is there something more to it ?

That said I'm already thinking the spread sheet would be quite cool. Uh oh........:eek:

Cheers,
Michael.
 
Last edited:

fuzzer

MB Enthusiast
Joined
Jun 1, 2002
Messages
7,939
Location
Glasgow
Car
F25 X3 20d SE
I had an A160 Auto . That did about 19-23 MPG ..

I had a problem with it starting , whatever they did at the workshop

1 . Made the car fly

2. started really really well


Hehe , that car was like a go-cart , it handled like nothing else :D
 

Michael

New Member
Joined
May 29, 2003
Messages
22
Location
Buckinghamshire
Car
380SL / A160
We have the 'clutchless' version.

Took some getting used to but good fun none the less. I think of it as dogem car rather than a go-cart but I know what you mean.

Love the sunroof too.

We do a little better on the MPG though.

Cheers,
Michael.
 

Sp!ke

Administrator
Joined
Jun 2, 2002
Messages
11,968
Location
West London
Car
SL500 & The Fart Car
Fuzzer scribbled

I had an A160 Auto . That did about 19-23 MPG ..

Jeepers, thats a terrible figure for a modern 1.6 engined little hatchback. Is that normal?
 

fuzzer

MB Enthusiast
Joined
Jun 1, 2002
Messages
7,939
Location
Glasgow
Car
F25 X3 20d SE
It did about 34 on the motorway.

I get crap MPG on all my cars because they spend their entire life in the city centre. Just a posing mobile really..:bannana: :bannana:
 

fuzzer

MB Enthusiast
Joined
Jun 1, 2002
Messages
7,939
Location
Glasgow
Car
F25 X3 20d SE
Whats towing it to get that MPG ?:D
 

Steve Riley

Member
Joined
Apr 26, 2003
Messages
51
Location
Blackburn
Car
Merc 190E
Does anyone actually still use the MPG figures?
All I do is put £X amount of fuel in when the light comes on. when it comes on again, put more fuel in and then calculate how many miles I got for my money. So the new acronym would be MP£.
It still amuses me that although we drive german cars and love 'em to bits, we still do our damnedest to convert MPL to MPG, lol
 

Michael

New Member
Joined
May 29, 2003
Messages
22
Location
Buckinghamshire
Car
380SL / A160
Agreed Steve.

I too calculate how far my £50 gets me, but to make the conversation relevant to most, you have to convert to MPG, despite purchasing litres :confused: :D

Cheers,
Michael.
 

Flyer

MB Enthusiast
Joined
Oct 16, 2002
Messages
1,638
Location
Houston, Texas
Car
Ford Mustang GT
Jim: File sent. Far from perfect I know. I did one years ago for my Corrado which was *much* better. Spent loads of time on it, but lost it in a hard drive failure :mad:

Kinky: I've noticed an error in the averaging function (out by 0.5 gallons), so if you want a revised one, let me know.

(And yes it does matter :D )

Cheers

Andrew
 
OP
OP
Kinky

Kinky

MB Enthusiast
Joined
Apr 23, 2003
Messages
1,316
Location
Berkshire
Car
All sorts of odds n sods
Andrew - could you send me the revised one please?

To be honest we're not that far out between us. I took your file and plugged my numbers into it - and there are some differences. I'm more suspect of my 123 calculations.

What I will do (when I get the time) - is dump my 123 data in Excel (seperate to your file) and see if I get the same results!.

As an FYi -

My results tell me that:

1. My MPG is 24.42 (yours says 24.63)
2. My MPL is 5.37 (yours says 5.42)
3. My cost per mile is 14p
4. My L/100kms is 11.64

In addition - your data also tells me ...
5. My cost per gallon in £3.45
 
Last edited:

Users who are viewing this thread

Top Bottom