Palm Vag Com Logging Help..... can log but how do I graph

[Unispeed]

I know I know, and I do use excel, but when I import the values in excel in puts them all in one column....(all in A). I did get it to put the values in 140 different rows (1,2,3,ect), but they are all in comumn A...

Here is the data I got from the Palm( time, rpm, engine load, number of missfires, missifire recognition:

889.65;2480;48.1;0;activated
890.05;2480;47.3;0;activated
890.45;2480;47.3;0;activated
890.86;2480;45.8;0;activated
891.26;2480;45.8;0;activated
891.66;2480;44.3;0;activated
892.06;2480;44.3;0;activated
892.47;2480;44.3;0;activated
892.87;2480;44.3;0;activated
893.27;2480;45.1;0;activated
893.67;2480;45.8;0;activated
894.07;2480;45.1;0;activated
894.48;2480;45.8;0;activated
894.88;2480;46.6;0;activated
895.28;2480;47.3;0;activated
895.68;2480;47.3;0;activated
896.09;2480;48.1;0;activated
896.49;2480;47.3;0;activated
896.89;2480;47.3;0;activated
897.29;2480;46.6;0;activated
897.69;2480;45.1;0;activated
898.10;2480;46.6;0;activated
898.50;2480;46.6;0;activated
898.90;2480;45.8;0;activated
899.30;2480;47.3;0;activated
899.71;2480;45.8;0;activated
900.11;2480;46.6;0;activated
900.51;2480;45.8;0;activated
900.91;2480;46.6;0;activated
901.32;2480;46.6;0;activated
901.72;2480;46.6;0;activated
902.12;2480;46.6;0;activated
902.52;2480;47.3;0;activated
902.93;2440;33.0;0;activated
903.33;2440;17.2;0;activated
903.73;2440;9.7;0;blocked
904.13;2400;10.5;0;blocked
904.53;2400;10.5;0;blocked
904.93;2360;11.2;0;blocked
905.34;2360;11.2;0;blocked
905.74;2360;11.2;0;blocked
906.14;2320;11.2;0;blocked
906.54;2320;11.2;0;blocked
906.95;2280;11.2;0;blocked
907.35;2280;11.2;0;blocked
907.75;2280;11.2;0;blocked
908.15;2240;11.2;0;blocked
908.55;2240;11.2;0;blocked
908.96;2240;11.2;0;blocked
909.36;2200;10.5;0;blocked
909.77;2200;11.2;0;blocked
910.16;2200;11.2;0;blocked
910.57;2160;11.2;0;blocked
910.97;2160;11.2;0;blocked
911.37;2160;11.2;0;blocked
911.77;2160;11.2;0;blocked
912.17;2120;11.2;0;blocked
912.58;2120;11.2;0;blocked
912.98;2120;11.2;0;blocked
913.38;2080;11.2;0;blocked
913.78;2080;11.2;0;blocked
914.19;2080;11.2;0;blocked
914.59;2040;11.2;0;blocked
914.99;2040;11.2;0;blocked
915.39;2040;11.2;0;blocked
915.79;2000;11.2;0;blocked
916.20;2000;11.2;0;blocked
916.60;2000;11.2;0;blocked
917.00;1960;11.2;0;blocked
917.40;1960;11.2;0;blocked
917.81;1960;11.2;0;blocked
918.21;1920;11.2;0;blocked
918.61;1920;11.2;0;blocked
919.01;1920;11.2;0;blocked
919.42;1880;11.2;0;blocked
919.82;1880;11.2;0;blocked
920.22;1760;11.2;0;blocked
920.62;2040;21.8;0;blocked
921.02;2160;9.0;0;blocked
921.43;2160;10.5;0;blocked
921.83;2160;10.5;0;blocked
922.23;2120;10.5;0;blocked
922.63;2120;10.5;0;blocked
923.04;2080;10.5;0;blocked
923.44;2080;10.5;0;blocked
923.83;2080;10.5;0;blocked
924.24;2040;10.5;0;blocked
924.65;2040;10.5;0;blocked
925.05;2000;10.5;0;blocked
925.45;1760;11.2;0;blocked
925.85;2160;18.0;0;blocked
926.25;2400;8.2;0;blocked
926.66;2320;9.7;0;blocked
927.06;2280;9.7;0;blocked
927.46;2280;9.7;0;blocked
927.86;2240;9.7;0;blocked
928.26;2200;9.7;0;blocked
928.67;2200;10.5;0;blocked
929.07;2160;9.7;0;blocked
929.47;2160;9.7;0;blocked
929.88;2120;12.0;0;blocked
930.28;2080;26.3;0;blocked
930.68;2120;32.3;0;blocked
931.08;2120;35.3;0;blocked
931.49;2120;33.8;0;activated
931.89;2120;27.0;0;activated
932.29;2120;26.3;0;activated
932.69;2120;22.5;0;activated
933.10;2120;21.0;0;activated
933.50;2120;18.0;0;activated
933.90;2080;15.0;0;activated
934.30;2080;14.2;1;activated
934.70;2080;13.5;1;activated
935.10;2040;13.5;1;blocked
935.51;2040;13.5;1;activated
935.91;2040;13.5;1;activated
936.31;2000;13.5;1;activated
936.71;2000;12.7;1;blocked
937.12;1960;13.5;1;blocked
937.52;1960;13.5;1;blocked
937.92;1920;13.5;1;blocked
938.32;1920;14.2;1;activated
938.73;1880;14.2;1;activated
939.13;1880;13.5;1;activated
939.53;1840;15.0;1;activated
939.93;1840;15.7;1;activated
940.34;1800;15.7;1;activated
940.73;1800;15.7;1;activated
941.14;1800;34.5;1;activated
941.54;1800;42.8;1;activated
941.95;1800;45.1;1;activated
942.35;1800;43.6;1;blocked
942.75;1800;38.3;1;blocked
943.15;1760;23.3;1;activated
943.55;1760;15.7;2;activated
943.96;1760;15.7;2;activated
944.36;1720;16.5;2;activated
944.77;1720;16.5;2;activated
945.16;1680;16.5;2;activated
945.57;1720;66.9;2;activated
945.97;1720;69.1;2;activated
946.37;1760;66.1;2;activated
946.77;1800;63.9;2;blocked

Is there any way to simply put this data in excel without having to manually separate it all?

Thanks in advance

[BITRBO]

so it doesn't save it as a certain file type then? I know it's a different program & OS, but VAGCOM on my laptop saves it as a file type (I forget what kind) that is automatically recognized by excel; puts it into seperate columns and everything.

[Unispeed]

nope, it saves it just like that... the thing is handy cause you can log on the fly if something is going on thats not normal. whereas you dont usully have a laptop in the car and hooked up at all times... I have the palm mounted on the front of the dash right by the steering wheel and its always connected to the car so its always logging.. when something is going on all I gotta do is look down and there it is.. the problem is that it doesnt create a file like the real vagcom does... grrrrr has anybody gotten past this.. maybe written a program that separates all that crap into different colums?

[jrock]

where did you get the mount for that?

[rageman2]

When you import the file, make sure it plain text. Then tell Excel that you want everything to be separated by a semi-colon and it should put each measuring block in a separate column. HTH

[Unispeed]

How do you tell exel that you want everything separated by a semicolon?

When you import the file, make sure it plain text. Then tell Excel that you want everything to be separated by a semi-colon and it should put each measuring block in a separate column. HTH

[rageman2]

I guess it could depend on which version of excel you are running (I am running an older version on a Mac, but this are basic Excel functions) - but for me, I just use File>Open, then a dialog box comes up asking how I want to import the file - I choose "Delimited" and then choose "Semicolon" as the separator. Are you familair with Excel at all? It takes a litte work to get from the raw data to graphs.

[jrock]

where did you get that mount

[Unispeed]

Custom made

where did you get that mount

[Unispeed]

Wow, you're the man... I just tried this and it separated it perfectly.. now I gotta learn how to graph.... I started doing a few graphs but it doesnt put things like I want them.. gotta get more efficient at that so I can start posting pretty line graphs like every other S4 nerd out there

I guess it could depend on which version of excel you are running (I am running an older version on a Mac, but this are basic Excel functions) - but for me, I just use File>Open, then a dialog box comes up asking how I want to import the file - I choose "Delimited" and then choose "Semicolon" as the separator. Are you familair with Excel at all? It takes a litte work to get from the raw data to graphs.

[Unispeed]

I dont know about you guys but boy its nice to have a vag com with you and hooked up all the time... right in front of you ready to log.. I mean.. I get in the car.. turn it on.. turn the palm on, push "connect to engine module" and then "m blocks".. type in the block I want and after that just push log.... good stuff!

[HK-Steve]

I have a Vag-Com, Palm V, What else is needed??

Where did you get all the parts to do this??




Cheers
Steve

[rageman2]

Wow, you're the man... I just tried this and it separated it perfectly.. now I gotta learn how to graph.... I started doing a few graphs but it doesnt put things like I want them.. gotta get more efficient at that so I can start posting pretty line graphs like every other S4 nerd out there

I know it - getting graphs out of it can be a PITA. Let me know if I can help at all.

[Unispeed]

You're asking how I mounted it?

I have a Vag-Com, Palm V, What else is needed??

Where did you get all the parts to do this??




Cheers
Steve

[HK-Steve]

No, Mounting would not be an issue,

just what else you need to do,

Cables,
Software on the palm
Power


Much Appreciated
Cheers
Steve

[JDM EJ1 95]

NICE! i have the same palm


where can i get the cable for it.


and what software?