Notices
ECU Flash

calc HP/TQ from EvoScan using Excel

Thread Tools
 
Search this Thread
 
Old May 25, 2009 | 09:52 AM
  #196  
l2r99gst's Avatar
Evolved Member
iTrader: (2)
 
Joined: Mar 2004
Posts: 3,499
Likes: 4
From: CA
Originally Posted by Jack_of_Trades
Question for Bryan, how did you plot the dyno runs from your exported .TXT files??
Just paste into Excel and graph it (paste data into first three columns, highlight, and click the little graph icon in the toolbar).

Actually, if you keep the data in it's format, just open it with Excel and pick comma delimited, or if you remove the commas, fixed width. Basically, you just want the RPM in the first column and the HP and TQ in the next two columns.

Last edited by l2r99gst; May 25, 2009 at 10:16 AM.
Reply
Old May 25, 2009 | 10:45 AM
  #197  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Here are the overlays so we can see where the variances are happening:

Solid lines= Virtual Dyno Room 4.0 Simulator with Evoscan DataLogs
Dotted Lines= GST Motorsports Uncorrected Mustang Dyno Results











The simulators were all done with:

SAE corrections OFF
Dyno Correction Factor= .953
Vehicle Weight= 3500lbs

Last edited by Jack_of_Trades; May 25, 2009 at 12:03 PM.
Reply
Old May 25, 2009 | 10:55 AM
  #198  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
The largest discrepancies happen in the higher torque area's and I wouldn't be surprised if its from a lack of resolution in the datalogging with Evoscan. I would love to see a dyno pull with JUST the RPM being datalogged and all of the evoscan features enabled/disabled to get the fastest logging possible. I bet it would be VERY close! Like it isn't already lol. I mean, this is with only 45-48 lines of data! Brians's is the closest and it had 48 lines of data compared to the other two would had 45.

I'm very shocked how close it is!

Last edited by Jack_of_Trades; May 25, 2009 at 12:00 PM.
Reply
Old May 25, 2009 | 11:53 AM
  #199  
l2r99gst's Avatar
Evolved Member
iTrader: (2)
 
Joined: Mar 2004
Posts: 3,499
Likes: 4
From: CA
I finally installed all of my parts, so I'm finally getting around to tuning my car. For this last run, I wanted to see for me if logging 2-byte RPM would have any difference. With the default smoothing and my sample rate (~500 samples/sec) it didn't seem to make much of a difference. This was logging 20 items at about 23-24 rows per second with DMA/LiveMap.

There was a little knock as I'm still tuning and finalizing my timing/fuel with the stock cat and cat-back. When complete, I will post a comparison with the cutout open to see the difference. Then, I will probably throw my hi-flow cat back on for one last comparison and leave it like that. I just hate running the car with the cut-out open, even though there is way more power. It's just so loud and annoying.

Comparison of base (1-byte RPM) with comparison (2-byte RPM). Not much difference with my logging speed and default spreadsheet smoothing:
Attached Thumbnails calc HP/TQ from EvoScan using Excel-2byte-1byte-compare.jpg  
Reply
Old May 25, 2009 | 12:18 PM
  #200  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Well your power curves look pretty darn good so far. Once MrFred or anyone else can add the formulas so we can edit the smoothing factor it should be nearly perfect. Were you using dynojet or mustang values?

I am going to add a checkbox for dyno choice so the user can just select which type of dyno they want to simulate and I'll also add a box on the dyno chart stating which dyno simulation is being used. Also whether it was a 3rd gear pull or a 4th gear pull(and whether its a 5 speed or 6 speed). That way all of the info is on the dyno chart when people post up a snapshot.

Last edited by Jack_of_Trades; May 25, 2009 at 12:24 PM.
Reply
Old May 25, 2009 | 12:26 PM
  #201  
pupo's Avatar
Evolving Member
iTrader: (9)
 
Joined: Jan 2008
Posts: 297
Likes: 2
From: Puerto Rico
This is very impresive work!!! Loocking forward for your last edition.
Reply
Old May 25, 2009 | 12:45 PM
  #202  
l2r99gst's Avatar
Evolved Member
iTrader: (2)
 
Joined: Mar 2004
Posts: 3,499
Likes: 4
From: CA
I was using dynojet values. Going through a stock exhaust wouldn't get me much using mustang values.
Reply
Old May 25, 2009 | 12:55 PM
  #203  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
I'm pulling my hair out trying to find a formula so the 'N' value depicts how many rows 'above and below' a particular cell will get avaeraged. This is the ONLY formula holding me back from finishing this.

ANYONE???
Reply
Old May 25, 2009 | 01:00 PM
  #204  
RAbishi's Avatar
Evolved Member
iTrader: (4)
 
Joined: Mar 2006
Posts: 942
Likes: 0
From: South Dakota
I was suprised how close the excel graph was to real dyno graph. The differences could just be in the load.
Reply
Old May 25, 2009 | 01:03 PM
  #205  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Well, the evoscan datalog was recorded WHILE on the dyno. So the datalog and dyno graph were from the exact same moment. The variance is mostly due to the lack of resolution in the evoscan logs he provided. All-in-all...CLOSE ENOUGH IN MY BOOK! Close enough to be in the ballpark for sure!
Reply
Old May 25, 2009 | 01:06 PM
  #206  
Spins4's Avatar
Evolved Member
iTrader: (122)
 
Joined: Nov 2005
Posts: 899
Likes: 0
From: Coventry, R.I
Damn good work as usual Jamie! So suscribed!
Reply
Old May 25, 2009 | 05:28 PM
  #207  
l2r99gst's Avatar
Evolved Member
iTrader: (2)
 
Joined: Mar 2004
Posts: 3,499
Likes: 4
From: CA
Originally Posted by Jack_of_Trades
I'm pulling my hair out trying to find a formula so the 'N' value depicts how many rows 'above and below' a particular cell will get avaeraged. This is the ONLY formula holding me back from finishing this.

ANYONE???
I think I can do something like this. Give me some time and I will post up what I find.

Edit: OK, I got it working with different smoothing factors. I will tidy up the spreadsheet and post something up shortly.

Last edited by l2r99gst; May 25, 2009 at 06:03 PM.
Reply
Old May 25, 2009 | 06:42 PM
  #208  
l2r99gst's Avatar
Evolved Member
iTrader: (2)
 
Joined: Mar 2004
Posts: 3,499
Likes: 4
From: CA
JofT,

OK, I have it finished for now, but it's too big to post up. Do you want me to email it to you so that you can host it, like the last one?

Send me a PM.


Eric
Reply
Old May 25, 2009 | 06:56 PM
  #209  
GST Motorsports's Avatar
Account Disabled
iTrader: (8)
 
Joined: Sep 2007
Posts: 3,366
Likes: 1
From: Hayward
Originally Posted by Jack_of_Trades
Well, the evoscan datalog was recorded WHILE on the dyno. So the datalog and dyno graph were from the exact same moment. The variance is mostly due to the lack of resolution in the evoscan logs he provided. All-in-all...CLOSE ENOUGH IN MY BOOK! Close enough to be in the ballpark for sure!
Once I get my personal Evo back together (which should be tomorrow) I can get around to doing a dyno run and then go out and do a street run and you can use that data as well.
Reply
Old May 25, 2009 | 07:07 PM
  #210  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Originally Posted by GST Motorsports
Once I get my personal Evo back together (which should be tomorrow) I can get around to doing a dyno run and then go out and do a street run and you can use that data as well.
That would be some awesome data Bryan! Thanks again If you could do one pull with only the RPM value being recorded, then another with multiple items being recorded, that would be even better!

Originally Posted by l2r99gst
JofT,

OK, I have it finished for now, but it's too big to post up. Do you want me to email it to you so that you can host it, like the last one?

Send me a PM.


Eric
PM sent Eric
Reply



All times are GMT -7. The time now is 12:51 AM.