[SOLVED] Deciphering Primo fuel.txt file?
Mon Feb 21, 2011 1:11 pm
Primo has a very handy mileage calculator/log that will prompt maintenance reminders. I would like to export this data, but the numbers are converted to a format that doesn't make any sense to me. This is crossposted to ****.
I'm looking at my fuel.txt and trying to make sense of the numbers. Here is an excerpt:
131729418;34410.9934;35099.7926;48.529000;2.550000
131729425;35099.7926;35638.9229;38.649100;2.540000
131729433;35638.9229;36203.8026;40.049700;2.520000
The date has already been solved (thanks to yksyks).The last "column" is the fuel price. The remainder of the line is puzzling. It's clear there are repeating numbers (mileage) carried from one line to another for the 2nd and 3rd Columns. These middle 3 numbers must be converted user input data. The fourth column must be fuel amount.
Real Data (displayed by Primo in the app)
First line from above: 8/10/2010, Odometer: Start-21382_____End-21810 , Fuel Amount- [unknown] MPG 33.39, Cost of trip .08/mi
I don't see the values for Gas amount in the data line in fuel.txt
Can anyone buy me a clue here?
I'm looking at my fuel.txt and trying to make sense of the numbers. Here is an excerpt:
131729418;34410.9934;35099.7926;48.529000;2.550000
131729425;35099.7926;35638.9229;38.649100;2.540000
131729433;35638.9229;36203.8026;40.049700;2.520000
The date has already been solved (thanks to yksyks).The last "column" is the fuel price. The remainder of the line is puzzling. It's clear there are repeating numbers (mileage) carried from one line to another for the 2nd and 3rd Columns. These middle 3 numbers must be converted user input data. The fourth column must be fuel amount.
Real Data (displayed by Primo in the app)
First line from above: 8/10/2010, Odometer: Start-21382_____End-21810 , Fuel Amount- [unknown] MPG 33.39, Cost of trip .08/mi
I don't see the values for Gas amount in the data line in fuel.txt
Can anyone buy me a clue here?
Mon Feb 21, 2011 1:46 pm
I don't know if they're supposed to be but the numbers 48.529000 2.550000 are GPS coordinates for an area in France near Paris, Other than that i don't know.
Mon Feb 21, 2011 1:50 pm
This is a first and very raw idea, so don't take it to be true. Also, I can not check things right now.
NavNGo is an European company. In Europe is counted with liters and Kilometers, not gallons and miles. Also not kms per liter (in some European countries they do use this) but very often (mostly?) liters per 100 km.
So now I am guessing that the programmers use this metric system in fuel.txt, while the conversion to miles and gallons is very quickly done by the processor depending on your settings.
As said, just a first idea.
NavNGo is an European company. In Europe is counted with liters and Kilometers, not gallons and miles. Also not kms per liter (in some European countries they do use this) but very often (mostly?) liters per 100 km.
So now I am guessing that the programmers use this metric system in fuel.txt, while the conversion to miles and gallons is very quickly done by the processor depending on your settings.
As said, just a first idea.
Mon Feb 21, 2011 1:59 pm
21382 miles = 34410.9934 km, Spot on Nabi !!
Mon Feb 21, 2011 2:29 pm
So it's time, km at start, km at arrival, total fuel consumption (?), fuel price.
With these figures, it's possible to calculate the average fuel consumption (here 7.45449 liter per 100km) and the cost.
Even in gallons.
Am I correct? What did I win?? Gimme Gimme !!
With these figures, it's possible to calculate the average fuel consumption (here 7.45449 liter per 100km) and the cost.
Even in gallons.
Am I correct? What did I win?? Gimme Gimme !!
Mon Feb 21, 2011 9:08 pm
You win a spreadsheet! What would you like to have won?
Sorry, No links to other GPS sites allowed!:rulz:
Sorry, No links to other GPS sites allowed!:rulz:
Mon Feb 21, 2011 9:14 pm
I won I won!!
A spreadsheet is fine, so I can play on
Mon Feb 21, 2011 11:47 pm
Spreadsheet attached.
Tue Feb 22, 2011 7:37 am
Interesting. Thanks for the attachment!!