ScanGaugeII Calibration Worksheet

[BrianWillan]

Originally Posted by n3rdyguy

Hi
Is it possible to make a version for us that uses litres/100km?

Just convert your liters/100km to km/liter and then use the spreadsheet as is. The spreadsheet is essentially unit independent. Meaning that it wouldn't really know the difference if you entered a km for miles or liters for gallons, as long as the units are consistent.

Cheers

Brian Willan
Oshawa, Ontario
Canada

[jdhog]

This looks like useful info. I'm coming up to my first fill while having a SG so I'll be needing to read this again soon to help me calibrate it. Thanks!

[morfes]

I have a question about how am I use this utility.

I go to the gas station and I fill up
I write down to a paper the data we need to fill the spreadsheet.
Then I need to go at my home to fill it so I should do some km. At the gas station I reset the data as you suggest at the spreadsheet without adjust anything.
I go home and the spreadsheet calculate for example that I need to adjust the fuel at the sg 4%.When should I adjust it? Because this moment the sg has already done some distance from the gas station to my home....

[Dan]

Well I was carrying it on my cell phone so that solved your immediate problem.

Plus the spreadsheet will simply zero in on a calibration setting over multiple tanks. You can just follow one tank behind the spreadsheet if you like. Won't effect the math since I factor out whatever calibration you have set.

So plug in TankA get CalibA. When you fill TankB, set you calibration to CalibA, then go home and fill in your tank to get CalibB. When you fill TankC, set your calibration to CalibB.... One tank behind.

11011011

[morfes]

Originally Posted by Dan

Well I was carrying it on my cell phone so that solved your immediate problem.

Plus the spreadsheet will simply zero in on a calibration setting over multiple tanks. You can just follow one tank behind the spreadsheet if you like. Won't effect the math since I factor out whatever calibration you have set.

So plug in TankA get CalibA. When you fill TankB, set you calibration to CalibA, then go home and fill in your tank to get CalibB. When you fill TankC, set your calibration to CalibB.... One tank behind.

11011011

Thank you very much for your answer , but I have a question more. Every time I fill up , I will use a new tank at the step 2? I mean tha I don't erase the previous data and should I write the new one so the spreadsheet calculate all of the fill ups?

[Dan]

Originally Posted by morfes

Thank you very much for your answer , but I have a question more. Every time I fill up , I will use a new tank at the step 2? I mean tha I don't erase the previous data and should I write the new one so the spreadsheet calculate all of the fill ups?

Yes, the top bold line of step 2 is the accumulated total. Add each tank into a blank row in step 2. This will sum all the tanks together to help get a very accurate picture of the required calibrations.

11011011

[morfes]

Originally Posted by Dan

Yes, the top bold line of step 2 is the accumulated total. Add each tank into a blank row in step 2. This will sum all the tanks together to help get a very accurate picture of the required calibrations.

11011011

Thank you again! I test it and I will post the results!

[Showbizk]

The only problem I've had with this is by the time I get home after filling and make the spreadsheet entries to calibrate, I lose about 4 miles of data on the tank, since changing the calibration zeroes out other entries...

[PaleMelanesian]

Any time within the first gallon, you can change the offsets on the fly. Just go to fillup and adjust it, but don't hit save. Sure, the first 4 miles might be off by 1%, but that's not much.

[morfes]

Originally Posted by PaleMelanesian

Any time within the first gallon, you can change the offsets on the fly. Just go to fillup and adjust it, but don't hit save.

But If I do that and not hit save , it doesn't save the offset...