How is everyone calculating there MPG so accuratly? - Page 2 - PeachParts Mercedes-Benz Forum

Hatterasguy · #16 06-22-2008, 07:55 PM

Just lie and say it gets 35mpg no matter how much you floor it around town.

Bens lover · #17 06-22-2008, 08:31 PM

lol!!

#18 06-22-2008, 08:44 PM

If you bought your car on eBay you should know it gets 35-45mpg, 60mpg if you use GreenBenz's hydrogen system.

MPG measurement is easy but it won't work if you partially fill the tank.

Cervan · #19 06-22-2008, 10:25 PM

I dont trust the odometers, i simply calculate how many miles it is from my house to my job and back (assuming that i go nowhere else,) Fill my car up to the brim and when i run out ill know how many MPG im getting.

pimpernell · #20 06-23-2008, 01:07 PM

Quote:

Originally Posted by EricSP

I have been reading alot of threads dealing with MPG there car gets. How are people calculating there MPG so accurately?

I have a scangauge that taps into the OBD port, and it covers in real time about 15 different engine and electrical functions. It also has a trip computer, and fuel usage option. Along with that, and other methods spoken about by the other posters, I am able to see exactly what my milage is.

ichbineinekrous · #21 06-23-2008, 05:00 PM

Quote:

Originally Posted by anghrist

Yep, fill to top, record odometer, lather-rinse-repeat. But it really makes a difference how you handle the data after the fact.

I use Excel to input in the amount as recorded on the fuel receipt along with the odometer reading. I calculate the "instant" MPG for each tank and then use a three point moving average to give me an average MPG over the last three fill-ups. This helps to give a more reliable figure. I also calculate an average for the entire length of ownership of the car for an overall average.

Other figures:

Price/mile fuel $0.15
Operational Cost/mile (fuel plus maintenance/mile) $0.41
Savings per fill-up versus my last car (VW GTI GLS 5-sp)
Projected fuel cost/month
Projected next fill-up date.

I plot to show performance over time on most of these values.

You don't happen to have this in an excel spreadsheet that you'd be willing to share do you? I, for one, will give full credit to the author if I ever pass it on.

#22 06-23-2008, 07:13 PM

Quote:

Originally Posted by ichbineinekrous

You don't happen to have this in an excel spreadsheet that you'd be willing to share do you? I, for one, will give full credit to the author if I ever pass it on.

Here you go. I hope it works, I keep my sheet in Appleworks and exported it to Excel. It includes an automatic chart, total miles traveled, total gallons consumed, average $/gallon, total fuel costs and average MPG.

EricSP · #23 06-23-2008, 09:14 PM

The one thing I don't understand is everyone isn't driving there car until it runs out of fuel.

Is everyone waiting until it sounds different or bogs out?

#24 06-23-2008, 09:33 PM

No need. The tank is a fixed volume, as long as you fill to the same point you can go any distance.

Cervan · #25 06-24-2008, 03:22 AM

Quote:

Originally Posted by EricSP

The one thing I don't understand is everyone isn't driving there car until it runs out of fuel.

Is everyone waiting until it sounds different or bogs out?

i actually drive it until i cannot drive anymore, i just keep a spare jug in the tank and pull over to the side, remmeber where i am and then continue on.