Club 80-90 Forums

good to know your getting the same as me Tom

Clive,you keep saying that it should be recorded by the Odo. I checked my trip meter against mine over a distance of around 480k and it was within 2/10 of a kilometer. Can some be way out?

I really do have trouble making a point Tom don't I...

Its not the accuracy, its the method .. (which is what the science of experiment is about)

My point is and always has been, that trip readings are single (spot) readings and do not necessarily constitute a 'continuous' record so errors can occur.

Rather than 20 trips of 4 to 500 miles, a continuous record of fillups Versus odo readings covering 10,000 miles

I would be very cautious about plotting consumption against mileage like this...



..if the data came to me in the form of trip readings vs fillup fuel, whereas this ^ is a continuous mileage record without interruption, that shows what really happens over the longer term, and also where any mistake, either accidental, methodological or recording error can usually be spotted a mile away.. if a mistake is made with individual trip readings, you cannot see the 'gap' in the mileage, or indeed how that figure slots into the rest (before, after, a different vehicle even )

The trip can be used as well for a spot check, but that's all they are, spot checks... alongside that keep a continuous oodo going, then it really doesn't matter if you forget to record a fillup mileage~ as long as you have the litres that went in, its all, total fuel over total mileage)

What you want is a long term record that can not only tell you what the real (practical) mpg is but also use it to spot when things are not right, when it starts falling for no reason.

After all, just look at the massive variation of Tdi mpgs in these forums, some coming out at 25 ish over many thousands of miles and others talking about 80mph in the same sentence as 40 mpg for a tripped reading... until a proper METHOD is established and CONSISTENT results returned over a reasonable period and distance, best to post with caution

NB. Note there are 3 curves which tell the same story but in a different way:
Blue - Spot (fillup2fillup) Equiv. to the tripped spot mpg. See how they're scatty varying from 30 to 13 in the data above
Yellow - 3-mean averaged (smoothed) takes out most click fillup errors
Pink - Consumption to date (actual realised mpg to date, usually goes slowly down maybe making my point

that graph is great. i wonder if there is some sort of program where you can enter this info and it will plot a graph for you?
Are you recording my figures somewhere Clive?

lloydy wrote:good to know your getting the same as me Tom

I'm running .23 nozzles and I get 70mph at 3100rpm.

If you look back at your figures do you now think you have been getting up and over 40 MPG?

That graph is great. i wonder if there is some sort of program where you can enter this info and it will plot a graph for you?

It's already downloadable Lloyd and has been for about 3 years! That's why I automated it and ask that data be recorded in this particular way, it does all the work for you

It should still work automatically, if you follow the destructions..

Goto this Wiki page, I've done a version for both km and mile odometers...

https://club8090.co.uk/wiki/Fu ... unofficial

I have an admission to make though. I have forgotten the password I locked all the code up with

but if it works for you OK, there's no need for that

I can help out with advice though if it doesn't plot automatically. The main thing is to realise the first odo reading doesn't need fuel, of course it's the initial datum when first brimmed, actual quantity doesn't matter, call it data point zero

i dont think i have been saying i've been getting over 40mpg, only for the two fill ups mentioned, other than that i have said i was getting 30mpg

The reason for that? I don't know, could have been driving slower, so less rpm?
At @62mph i am 3200. I really dont know why those mpg figures were so high. And so far i have only done a couple fills and neither of those was that good of a refill, so these might increase over the next couple times i fuel up.

HarryMann wrote:

That graph is great. i wonder if there is some sort of program where you can enter this info and it will plot a graph for you?

It's already downloadable Lloyd and has been for about 3 years! That's why I automated it and ask that data be recorded in this particular way, it does all the work for you

It should still work automatically, if you follow the destructions..

Goto this Wiki page, I've done a version for both km and mile odometers...

https://club8090.co.uk/wiki/Fu ... unofficial

I have an admission to make though. I have forgotten the password I locked all the code up with

but if it works for you OK, there's no need for that

I can help out with advice though if it doesn't plot automatically. The main thing is to realise the first odo reading doesn't need fuel, of course it's the initial datum when first brimmed, actual quantity doesn't matter, call it data point zero

cheers! i'll have a look

NB. Download and Save As, not Open of course, so run it off your own machine...

Done! i'll keep on top of that

Dont need to brim it every time lloydy; just start and end of trips if you want mpg for that journey. Otherwise every now and again will give you accurate figures when you can be bothered since the last time.

Heres the raw data from May 2010 to date for you Clive

FUEL RECORDS
Odometer (km) Trip Distance Date Fill Amount Price per Unit Total Price Partial Fill MPG
214918 214918 29 May 2010 67.83 1.189 80.65 Brimmed
215388 470 31 May 2010 40.07 1.249 50.05 Partial 24.3829
215622 234 12 Jun 2010 41.49 1.199 49.75 Brimmed 24.3829
216219 597 3 Jul 2010 68.28 1.199 81.87 Brimmed 24.6985
216615 396 6 Jul 2010 38.65 1.179 45.57 Brimmed 28.9424
217193 578 8 Jul 2010 60 1.3 78 Partial 28.1792
217621 428 9 Jul 2010 44 1.092 48.05 Partial 28.1792
218284 663 11 Jul 2010 40.36 1.239 50.01 Partial 28.1792
218608 324 16 Jul 2010 61 8.35 509.35 Partial 28.1792
219078 470 19 Jul 2010 48.33 7.91 382.29 Partial 28.1792
219504 426 21 Jul 2010 39.66 1.119 44.38 Partial 28.1792
220192 688 23 Jul 2010 32.29 1.2391 40.01 Partial 28.1792
220522 330 24 Jul 2010 62.44 0.989 61.75 Partial 28.1792
220907 385 25 Jul 2010 40.4 1.099 44.4 Partial 28.1792
221319 412 2 Aug 2010 43.07 1.149 49.49 Brimmed 28.1792
221801 482 30 Aug 2010 25 1.249 31.22 Partial 24.9106
222114 313 23 Sep 2010 25 1.189 29.73 Partial 24.9106
222184 70 3 Oct 2010 41 1.209 49.57 Partial 24.9106
222654 470 3 Apr 2011 50.01 1.389 69.46 Partial 24.9106
223073 419 25 Apr 2011 40.01 1.489 59.57 Partial 24.9106
223492 419 2 May 2011 59.22 1.419 84.03 Partial 24.9106
223796 304 19 May 2011 34.38 1.379 47.41 Partial 24.9106
223797 1 19 May 2011 6.38 1.379 8.8 Brimmed 24.9106
224402 605 31 May 2011 16:46 66.14 1.389 91.87 Brimmed 25.8393
225040 638 7 Jul 2011 13:09 60.06 1.339 80.42 Partial 26.1278
225449 409 13 Aug 2011 17:59 30.02 1.479 44.4 Partial 26.1278
225634 185 14 Aug 2011 21:36 44.45 1.369 60.85 Brimmed 26.1278
226173 539 19 Aug 2011 15:39 21.14 1.419 30 Partial 24.4259
226388 215 21 Aug 2011 19:28 60 1.399 83.94 Partial 24.4259
226671 283 28 Aug 2011 12:28 38.23 1.369 52.34 Partial 24.4259
227286 615 11 Sep 2011 16:10 15 1.379 20.68 Partial 24.4259
227405 119 30 Sep 2011 21:00 17.74 1.409 25 Partial 24.4259
227536 131 18 Oct 2011 18:40 17.74 1.409 25 Partial 24.4259
227593 57 23 Oct 2011 12:03 58.97 1.389 81.91 Brimmed 24.4259
227870 277 25 Oct 2011 11:39 32.73 1.288 42.16 Brimmed 24.1459
228192 322 29 Oct 2011 11:12 39.4 1.269 50 Partial 22.2329
228732 540 19 Dec 2011 20:41 21.3 1.409 30.01 Partial 22.2329
228795 63 15 Jan 2012 10:41 50.4 1.389 70.01 Partial 22.2329
229274 479 15 Jan 2012 19:47 13.54 1.479 20.03 Partial 22.2329
229407 133 26 Jan 2012 08:55 21 1.429 30.01 Partial 22.2329
229554 147 14 Mar 2012 18:11 27.41 1.459 39.99 Partial 22.2329
229680 126 5 Apr 2012 19:16 59.22 1.459 86.4 Brimmed 22.2329
230190 510 6 Apr 2012 15:53 19.32 1.553 30 Partial 25.2811
230414 224 8 Apr 2012 09:34 50.02 1.449 72.48 Partial 25.2811
230756 342 10 Apr 2012 13:31 52.09 1.553 80.9 Brimmed 25.2811
231230 474 6 May 2012 12:06 50 1.439 71.95 Partial 24.2767
231652 422 3 Jun 2012 12:04 55.3 1.369 75.71 Brimmed 24.2767
232136 484 6 Jun 2012 17:08 50 1.389 69.45 Partial 26.7089
232672 536 27 Jun 2012 14:10 58.81 1.339 78.75 Partial 26.7089
233168 496 29 Jun 2012 18:00 53.13 1.379 73.27 Brimmed 26.7089
233577 409 8 Jul 2012 13:07 44.3 1.329 58.87 Brimmed 26.3409
234174 597 10 Jul 2012 14:34 54.01 1.57 84.8 Partial 29.0382
234701 527 12 Jul 2012 10:43 50 1.41 70.5 Partial 29.0382
235190 489 13 Jul 2012 11:25 54.47 1.47 80.07 Brimmed 29.0382
235796 606 15 Jul 2012 08:02 55.3577 1.37 75.84 Partial 30.4036
236468 672 17 Jul 2012 13:36 47.7 1.5315 73.05 Partial 30.4036
236823 355 19 Jul 2012 11:38 39.2157 1.53 60 Partial 30.4036
237324 501 20 Jul 2012 12:35 57.98 1.59 92.19 Brimmed 30.4036
237961 637 22 Jul 2012 18:19 64.48 1.389 89.56 Brimmed 28.1854
238557 596 5 Aug 2012 55.01 1.389 76.41 Partial 27.1647
238844 287 8 Aug 2012 15:33 37.73 1.379 52.03 Brimmed 27.1647
239368 524 12 Aug 2012 14:10 45 1.389 62.5 Partial 25.7824
239830 462 30 Sep 2012 12:34 64.11 1.439 92.25 Brimmed 25.7824

The two peaks of 28 and 30mpg were both down in the heat, Croatia and Pyrenees respectively. Picos in Oct 2011 I was averaging 24.

Mark, thanks, I'll try to take care of that lot later

Lloyd, Have you actually entered a few fuellings and flipped worksheets to the chart and seen it plotted those points?

Yes i have clive. A starting mileage and two fill ups so far, nice and easy to use

Lloyd, you have made me so happy

Finally someone else has actually used it

It's great, have it as a shortcut on my desktop. it takes a matter on minutes to update, also now have a small notepad in the glove box to keep a record as well

I've started recording data in the way you require Clive, I'll see if I can use the thing in the wiki.

Figured it would be interesting to stick an Mtdi in the mix..

For the record, everytime I've worked it out recently I've been getting somewhere inbetween 25-30mpg