CSV Grapher

[Y o o z]

So I got my AP today, and to celebrate I coded a CSV web based grapher for my data logs.
CSV Grapher v0.1a

It isn't up to par with what you DH folks have, but it works for me

UPDATE: Got on it after 50 miles. Pulls like crazy 1st-3rd gear, but 4th+ feels tame, albeit stronger than stock.
Stage 1+ v1.03 WOT logs look clean to me, however, the second log is from a non-launch start from 1st gear. The fuel pressure sensor PSI drops below 1400, which is a bit unnerving IMO. But then again, my wheels are spinning at that point so I modulated the throttle (boost drops), so I guess its expected? It's about 60 degrees, sea level, CA 91.

Log 1:- 3rd gear pull


Log 2: w/wheels slipping


Regarding the CSVG,
Let me know if anything is unclear, have any suggestions, or if you find any bugs D:
Also, if you put in ridiculously large log files, you'll have to wait a few seconds for everything to render.

HAVE FUN - DON'T BREAK IT

Thanks to xandrake for posting his CSV file and Haltech for letting me use his MS3 image without permission

TODO (3/31/09):
* More Color Choices
* Thicker Font
* Input new data without refreshing the page
* Tool to help trim logs

[Stan-O]

This should be stickied, good work.

I'm in the process of building one in VB.NET to use Excell in the background, but we'll see how it goes.....

[superskaterxes]

when i click ok it doesent make a graph for me


EDIT: nm

[acidbbg]

Thanks for the Graphing Tool!

Def should be stickied.

[Haltech]

Good work!

[Arrowpoint]

+1 on the sticky! Thannnnnk you!

[Matrix311]

hmm ya i've having some difficulties with it as well. I paste my .csv data log from wordpad into the text box and hit graph and nothing happens. I've tried 3 different browsers and non work (IE7, Chrome and FireFox).

got it working, great tool and thanks!

[acidbbg]

Originally Posted by Matrix311 hmm ya i've having some difficulties with it as well. I paste my .csv data log from wordpad into the text box and hit graph and nothing happens. I've tried 3 different browsers and non work (IE7, Chrome and FireFox). got it working, great tool and thanks!

It's not the web browser..I was having this problem as well.

First, You need to watch out for any weird characters in the first cell.

such as:

Seconds (sec)

should actually be
Seconds (sec)

Also, your data should look like this:

Seconds (sec),Accel. Pedal Pos. (%),Knock Retard (°),RPM (RPM),Actual AFR (AFR),Fuel Press. Sens. (PSI),Boost (PSI)
0,16.38,0,2207,14.99,1154.46,-8.56
0.21,16.38,0,2220,14.55,1137.06,-8.7
0.48,16.38,0,2226,14.7,1129.8,-8.7
0.77,16.77,0,2235,13.96,1141.41,-8.7
1.02,16.77,0,2236,14.55,1126.9,-8.7
1.26,16.77,0,2238,14.55,1147.21,-8.7
1.52,16.77,0,2228,14.85,1138.51,-8.7
1.78,24.57,0,2235,14.99,1171.86,-8.56
2.05,53.04,0,2234,14.99,1147.21,-7.83
2.32,99.06,0,2302,14.41,1654.82,0.29
2.57,99.06,0,2415,13.67,1675.13,3.48
2.83,99.06,0,2486,13.38,1609.86,6.53
3.11,99.06,0,2629,12.64,1721.54,13.49
3.4,99.06,0,2844,12.49,1595.36,17.4
3.64,99.06,0,3051,12.35,1641.77,18.42
3.93,99.06,1.05,3213,11.76,1682.38,18.42
4.17,99.06,0.35,3632,12.35,1654.82,17.69
4.45,99.06,0.35,3672,12.35,1675.13,17.26
4.71,99.06,0,3862,12.35,1741.84,16.97
4.99,99.06,0,4100,12.35,1659.17,17.11
5.28,99.06,0,4271,12.35,1714.29,16.68
5.52,99.06,0,4393,12.2,1686.73,16.24
5.81,0,0,4629,29.25,1679.48,15.81
6.01,0,0,4564,29.25,1689.63,-3.19
6.31,0,0,4067,29.25,1728.79,-12.62
6.57,0,0,3761,29.25,1746.19,-12.62
6.84,0,0,3331,29.25,1763.6,-12.62
7.06,0,0,3280,29.25,1781,-12.33
7.27,0,0,3225,29.25,1791.15,-11.89
7.57,0,0,3199,29.25,1798.4,-11.89
7.83,0.39,0,3160,29.25,1811.46,-11.89
8.08,0,0,3146,29.25,1823.06,-11.75
8.3,0,0,3113,29.25,1830.31,-11.75
8.57,0,0,3090,29.25,1836.11,-11.75
8.82,0,0,3051,29.25,1846.27,-11.6
9.05,0,0,3024,29.25,1854.97,-11.75
9.31,0,0,3009,29.25,1857.87,-11.6
9.54,0,0,2984,29.25,1860.77,-11.6
9.78,0,0,2952,29.25,1862.22,-11.6
10.07,0,0,2934,29.25,1862.22,-11.6
10.31,0,0,2894,29.25,1862.22,-11.6
10.58,0,0,2879,29.25,1862.22,-11.75
10.86,0,0,2845,29.25,1862.22,-11.6
11.1,0,0,2810,29.25,1862.22,-11.75
11.33,0,0,2783,29.25,1862.22,-11.75
11.56,0,0,2755,29.25,1860.77,-11.75
11.8,0,0,2730,29.25,1862.22,-11.75
12.09,0,0,2714,29.25,1862.22,-11.75
12.34,0,0,2679,29.25,1862.22,-11.75
12.54,0,0,2645,29.25,1862.22,-11.89
12.8,0,0,2629,29.25,1860.77,-11.75
13.02,0,0,2604,29.25,1860.77,-11.89
13.3,0,0,2574,29.25,1862.22,-11.89
13.58,0,0,2552,29.25,1862.22,-11.89
13.85,0,0,2527,29.25,1860.77,-11.89
14.07,0,0,2493,29.25,1862.22,-11.75
14.32,0,0,2475,29.25,1862.22,-11.89
14.52,0,0,2443,29.25,1862.22,-11.75
14.74,0,0,2423,29.25,1862.22,-11.75
14.94,0,0,2397,29.25,1862.22,-11.75
15.15,0,0,2384,29.25,1862.22,-11.75


hope that helps.

[djthom]

how do i copy the image so i can paste it here??

[Ferdball]

Nice work. But is there any chance that we can save the graph as a jpg or png file?

[Y o o z]

Its rendered inside of the browser, so not really. What you can do, is press the "Print Screen" button on your keyboard, Paste it into MSPaint (or whatever image editor you use) and crop it to your liking.

[nukechemist]

Seconds (sec),RPM (RPM),Knock Retard (°),Calculated Load (%),Long Term FT (%),Mass Airflow (g/s),Short Term FT (%),Actual AFR (AFR),DI Fuel Press. (PSI),Boost (PSI)
0.00,3265,0.00,203.45,-0.16,154.59,-0.16,12.20,1577.96,18.71
0.11,3312,0.00,198.74,-0.16,162.24,-0.16,12.05,1609.86,18.13
0.23,3366,0.00,200.31,-0.16,168.81,-0.16,11.91,1622.92,18.56
0.35,3406,0.00,204.62,-0.16,175.53,-0.16,11.91,1707.03,18.85
0.47,3440,0.00,204.62,-0.16,172.14,-0.16,11.91,1592.46,18.56
0.57,3490,0.00,200.31,-0.16,172.14,-0.16,11.91,1689.63,18.13
0.67,3539,0.00,195.22,-0.16,170.14,-0.16,12.05,1738.94,17.98
0.77,3588,0.35,193.26,-0.16,176.21,-0.16,12.05,1738.94,18.13
0.87,3616,0.35,194.43,-0.16,178.26,-0.16,11.76,1746.19,18.42
0.97,3683,0.35,195.22,-0.16,179.65,-0.16,11.91,1721.54,17.98
1.07,3737,0.35,192.86,-0.16,178.96,-0.16,11.76,1627.27,18.13
1.17,3768,0.00,192.86,-0.16,185.24,-0.16,11.76,1662.07,17.98
1.27,3822,0.00,191.30,-0.16,183.12,-0.16,12.05,1659.17,17.69
1.37,3894,0.00,190.90,-0.16,189.50,-0.16,12.05,1686.73,17.55
1.47,3916,0.00,190.51,-0.16,186.65,-0.16,12.05,1714.29,17.40
1.57,3966,0.00,187.77,-0.16,191.67,-0.16,12.05,1622.92,17.55
1.67,4010,0.00,188.16,-0.16,195.31,-0.16,12.05,1675.13,17.26
1.77,4045,0.00,188.55,-0.16,196.78,-0.16,11.91,1669.33,17.26
1.87,4100,0.00,188.16,-0.16,196.78,-0.16,11.91,1686.73,17.26
1.97,4139,0.00,187.77,-0.16,199.73,-0.16,12.20,1709.93,16.97
2.07,4176,0.00,186.59,-0.16,201.23,-0.16,12.05,1644.67,16.82
2.17,4242,0.00,185.81,-0.16,199.73,-0.16,12.05,1721.54,16.82
2.27,4268,0.00,185.81,-0.16,202.74,-0.16,11.91,1692.53,16.97
2.37,4305,0.35,186.20,-0.16,205.76,-0.16,11.91,1728.79,17.11
2.47,4363,0.00,185.42,-0.16,208.06,-0.16,11.76,1679.48,17.11
2.57,4391,0.00,185.42,-0.16,206.52,-0.16,11.91,1672.23,16.82
2.67,4451,0.00,185.02,-0.16,215.83,-0.16,11.91,1615.66,16.82
2.77,4496,0.00,185.02,-0.16,214.26,-0.16,12.05,1734.59,16.97
2.89,4520,0.00,183.46,-0.16,214.26,-0.16,11.76,1675.13,16.97
2.99,4581,0.00,184.24,-0.16,218.19,-0.16,11.76,1711.39,16.97
3.09,4615,0.00,183.85,-0.16,218.99,-0.16,11.91,1714.29,17.26
3.19,4673,0.00,183.46,-0.16,219.79,-0.16,11.91,1707.03,17.26
3.29,4714,0.00,183.85,-0.16,225.42,-0.16,11.76,1679.48,17.26
3.39,4723,0.00,184.63,-0.16,226.24,-0.16,11.76,1746.19,17.40
3.49,4789,0.00,183.06,-0.16,223.00,-0.16,11.76,1682.38,17.26
3.59,4841,0.00,180.71,-0.16,227.88,-0.16,11.76,1751.99,17.26
3.69,4876,0.00,180.32,-0.16,228.70,-0.16,11.76,1664.97,17.40
3.81,4905,0.00,180.32,-0.16,232.83,-0.16,11.76,1672.23,17.11
3.91,4960,0.00,180.71,-0.16,233.66,-0.16,11.76,1637.42,17.26
4.01,4996,0.00,179.93,-0.16,234.50,-0.16,11.76,1676.58,17.26
4.11,5030,0.00,180.32,-0.16,237.01,-0.16,11.76,1731.69,17.26
4.21,5081,0.00,179.14,-0.16,236.17,-0.16,11.76,1728.79,17.26
4.31,5112,0.00,178.75,-0.16,236.17,-0.16,11.76,1699.78,17.11
4.41,5112,0.00,178.75,-0.16,236.17,-0.16,11.76,1699.78,17.26
4.51,5165,0.70,176.79,-0.16,237.01,-0.16,11.76,1675.13,17.11
4.61,5201,0.70,175.62,-0.16,241.25,-0.16,11.47,1615.66,17.11
4.71,5241,0.70,175.62,-0.16,240.40,-0.16,11.61,1666.42,17.11
4.81,5289,0.70,174.44,-0.16,241.25,-0.16,11.61,1651.92,16.97
4.91,5323,0.70,173.26,-0.16,241.25,-0.16,11.47,1738.94,16.97
5.01,5357,0.70,172.87,-0.16,245.53,-0.16,11.61,1741.84,16.97
5.11,5357,0.70,172.87,-0.16,245.53,-0.16,11.47,1741.84,16.97
5.21,5403,0.70,172.48,-0.16,246.40,-0.16,11.47,1612.76,16.68
5.31,5458,0.35,170.91,-0.16,245.53,-0.16,11.76,1692.53,16.68
5.41,5502,0.35,169.74,-0.16,244.67,-0.16,11.76,1728.79,16.68
5.51,5531,0.35,168.95,-0.16,244.67,-0.16,9.70,1724.44,16.68
5.61,5539,0.00,143.08,-0.16,132.56,-0.16,10.00,1605.51,13.63

Here's a copy of a datalog that I'm trying to graph. When I copy and paste from wordpad into the csv grapher it pulls the items logged but only two lines of data. Any ideas? It copied the whole log when pasting here.

[Ferdball]

Originally Posted by nukechemist ... Here's a copy of a datalog that I'm trying to graph. When I copy and paste from wordpad into the csv grapher it pulls the items logged but only two lines of data. Any ideas? It copied the whole log when pasting here.

Works for me. Make sure you check the boxes of the items you want, and also pick the colors.

[nukechemist]

Originally Posted by Ferdball Works for me. Make sure you check the boxes of the items you want, and also pick the colors.

I can't even get that far. When it trys to graph I get a data error and nothing happens. Is there a limit on # of items logged(sec, rpm, di press, etc.)?
I noticed that when I paste in the text box each time stamped data line is split into two lines.

[evidence]

Originally Posted by nukechemist I can't even get that far. When it trys to graph I get a data error and nothing happens. Is there a limit on # of items logged(sec, rpm, di press, etc.)? I noticed that when I paste in the text box each time stamped data line is split into two lines.

Try a different browser.

[nukechemist]

Chrome works. Thanks

[dougefresh_]

Great job! Thanks for the graphing tool!

[N2o]

Does not work anymore...Account suspended

[CWP_MS3]

Discuss Here: CSV Grapher