Mazdaspeed Forums

Mazdaspeed Forums (http://www.mazdaspeedforum.org/forum/forum/)
-   MSF KB - Mazdaspeed 3/6 - ECU Computer Tuning (http://www.mazdaspeedforum.org/forum/forum/f628/)
-   -   CSV Grapher (http://www.mazdaspeedforum.org/forum/forum/f628/csv-grapher-125203/)

Y o o z 03-31-2009 11:06 PM

CSV Grapher v0.1a
 
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? :sigh: It's about 60 degrees, sea level, CA 91.

Log 1:- 3rd gear pull
http://img27.imageshack.us/img27/2401/642656.png

Log 2: w/wheels slipping
http://img27.imageshack.us/img27/9074/776786.png

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 :pokey:

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

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

Stan-O 04-01-2009 02:53 PM

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 04-01-2009 04:16 PM

when i click ok it doesent make a graph for me


EDIT: nm

acidbbg 04-03-2009 08:22 AM

Thanks for the Graphing Tool!

Def should be stickied.

Haltech 04-03-2009 08:31 AM

Good work!

Arrowpoint 04-05-2009 01:52 PM

+1 on the sticky! Thannnnnk you!

Matrix311 04-14-2009 10:29 AM

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 04-14-2009 11:25 AM

Quote:

Originally Posted by Matrix311 (Post 203166)
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 07-03-2009 08:39 PM

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

Ferdball 11-02-2009 10:52 PM

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

Y o o z 11-02-2009 11:02 PM

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 11-13-2009 06:40 PM

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 11-13-2009 11:19 PM

Quote:

Originally Posted by nukechemist (Post 357290)
...

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 11-14-2009 04:40 AM

Quote:

Originally Posted by Ferdball (Post 357421)
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 11-16-2009 11:45 AM

Quote:

Originally Posted by nukechemist (Post 357455)
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 11-16-2009 06:00 PM

Chrome works. Thanks

dougefresh_ 03-11-2010 05:07 PM

Great job! Thanks for the graphing tool!

N2o 09-18-2012 08:56 AM

Does not work anymore...Account suspended

CWP_MS3 09-20-2012 07:16 AM

Discuss Here: http://www.mazdaspeedforum.org/forum/foru...grapher-24597/


All times are GMT -7. The time now is 09:07 PM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
vB.Sponsors

©Copyright 2008 ; 2019 Cymru Internet Services LLC | FYHN™ Autosports HQ
Ad Management plugin by RedTyger

Page generated in 0.19589 seconds with 11 queries