Spritmonitor through translator

[DropDeadRed 0]

http://www.worldlingo.com/en/websites/url_translator.html

enter "www.spritmonitor.de " in the URL and go nuts.. working fairly well so far for me actually.

Edit: Fixed URL.

The translator thinger is excellent for getting registered, car set up, and learning how to enter data. Once to that point it's of course much faster to just work in German from there.

I've only punched in the first half of my data so far hence the appauling bad number. It gets better... a bit.

DDR

[smartdawg 0]

little typo there DDR - should be:www.spritmonitor.deCheers,Kirk.

[RoySkyBell 0]

I did this and it is indeed great. Have to say though that Mike T's step by step guide in "online economy tracking" was awesome for getting me started - he also had some insights that the straight translator doesn't give.

[DropDeadRed 0]

Oh now this is cute

at 5.5 I'm the worst fuel economy of any diesel on the site!

Bleh! Steadily improving though!

DDR

[Doozy 0]

I just added my gas mileage and it has an X in the line.

I hit the enter key as I was entering my data. Now I can't get rid of the X. Does anyone know how to fix this?

http://www.spritmonitor.de/detail.php?vid=112289

thank you, Mark

[RoySkyBell 0]

Hi Mark, I've concluded that it always does that for the first tank. I don't think it will calculate for the first tank, anything with an X or a partial tank. Guess you'll have to drive more so that you'll have more data!

[Doozy 0]

Hi Roy, this isn't my first tank, we got the car in March 2005.

cheers, Mark

[RoySkyBell 0]

Sorry, Mark. I think I misunderstood. What you really want is to know how to correct an entry.

When you are in your account - click on "Refuelings" then click on the date you want to correct. You should be able to fix it from there.

[spinner 0]

I noticed the Spritmonitor is offering CSV import and export. "CSV" stands for Comma-Separated Values, which is one way to port database records through a text file. It's a common, universal method to move data between database and spreadsheet applications. If you have Microsoft Excel, it will associate itself with .csv files, so all you have to do is open the file to see it presented.

I haven't tried their CSV import, but if it's smart enough it will save you a lot of effort of re-entering everything.

[DropDeadRed 0]

What they call CSV is actually quite humerous to me as a progammer type....

It's actually Semicolon( seperated, NOT comma seperated.

Worse yet, it uses comma (,) as a decimal indicator rather than a period (.).

So basically I can convince Excel to import the data nicely with a bit of cleverness but Excel sure won't save the data in a format that is importable.

Example...

Datum;Km-Stand;Teil-Km;Spritmenge;Kosten;Tankart;Reifen;Strecken;Fahrweise;Kraftstoff;Bemerkung;Verb

rauch

13.06.2005;6288;244;15,05;12,63;1;1;4;2;1;"";6,2

07.06.2005;6044;265;16,55;13,56;1;1;4;2;1;"";6,2

27.05.2005;5779;234;11,13;80,90;1;1;4;2;1;"";4,8

20.05.2005;5545;216;11,20;9,06;1;1;4;2;1;"";5,2

13.05.2005;5329;184;10,26;8,51;1;1;4;2;1;"";5,6

Note in the first line:

Date = 13.06.2005

Odometer = 6299 km

Kilometers = 244 km

Litres = 15,05 = 15.05 L

cost = 12,63 = $12.63

followed by some flags for driving conditions, tires etc...

Efficiency = 6,2 = 6.2 L/100km

DDR

[spinner 0]

OK, suppose a sed script does character substitution:

[*], becomes ;

[*]. becomes ,

[*]and, / becomes .

...in that order, to do the final filtering of a North American exported Excel spreadsheed in CSV format, would there be any other problems?

EDIT: Corrections, corrections, corrections