Notices
ECU Flash

calc HP/TQ from EvoScan using Excel

Thread Tools
 
Search this Thread
 
Old Jun 1, 2009 | 11:40 AM
  #286  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
ahh...you called me out on my lack of effort haha. Thanks man.
Reply
Old Jun 1, 2009 | 05:08 PM
  #287  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Originally Posted by MR Turco
Last time i was at the track my Evo IX SSL full interior, laptop, full tank of gas, and me weighed in at 3552. I weigh about 270. 3625 is pretty heavy.
Was that the time I met you? Didnt you have your toolbox in the car too?lol.

Originally Posted by GST Motorsports
Do you know what Buschur and ESP use for the HP@50 setting?
I asked ESP what HP@50MPH setting they have and he said its 15:1.
Reply
Old Jun 1, 2009 | 07:52 PM
  #288  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Question to anyone who has Excel AND openoffice.....when I open up the spreadsheet in excel (version 4.1) my torque values are elevated but when I open the SAME logs in OpenOffice, the peak torque values reflect my actual torque numbers from the dyno much more realistically. Can anyone else confirm a variance between the two programs for me????
Reply
Old Jun 1, 2009 | 08:15 PM
  #289  
MR Turco's Avatar
EvoM Staff Alumni
iTrader: (16)
 
Joined: May 2007
Posts: 3,233
Likes: 3
From: Massachusetts
Originally Posted by Jack_of_Trades
Was that the time I met you? Didnt you have your toolbox in the car too?lol.
Oh no, i removed anything that could get airborn
Reply
Old Jun 2, 2009 | 10:20 AM
  #290  
lan_evo_mr9's Avatar
Evolved Member
iTrader: (10)
 
Joined: Feb 2006
Posts: 1,097
Likes: 2
From: MD
I was able to copy/paste all info into the spreadsheet and it gave me my HP/TQ numbers but no nice picture. Any ideas?
Reply
Old Jun 2, 2009 | 10:39 AM
  #291  
MR Turco's Avatar
EvoM Staff Alumni
iTrader: (16)
 
Joined: May 2007
Posts: 3,233
Likes: 3
From: Massachusetts
Originally Posted by lan_evo_mr9
I was able to copy/paste all info into the spreadsheet and it gave me my HP/TQ numbers but no nice picture. Any ideas?
i ran into a somewhat similar problem.

Try two things - copy and paste the same info into the comparison data tab and seeif that graph comes up.

2. Completely delete all the data you entered from base pull tab and try again.
Reply
Old Jun 2, 2009 | 10:42 AM
  #292  
lan_evo_mr9's Avatar
Evolved Member
iTrader: (10)
 
Joined: Feb 2006
Posts: 1,097
Likes: 2
From: MD
I'm also having a problem selecting only one gear for one of my runs. I select one and then they all disappear or they all appear depending on what I do. I'll try doing the stuff you said to get the picture up. thanks for the help.

Edit: according the Virtual Dyno, here are my new numbers...
448 WHP @ 6027 RPM
428 WTQ @ 4192 RPM

It has been a while since I've dyno'd- I'm very pleased id this is accurate.

Last edited by lan_evo_mr9; Jun 2, 2009 at 10:45 AM.
Reply
Old Jun 2, 2009 | 10:47 AM
  #293  
MR Turco's Avatar
EvoM Staff Alumni
iTrader: (16)
 
Joined: May 2007
Posts: 3,233
Likes: 3
From: Massachusetts
Originally Posted by lan_evo_mr9
It has been a while since I've dyno'd- I'm very pleased id this is accurate.
Which dyno correction are you using?

From what i can tell the MD factor looks pretty dead on, if not a little low. The DJ factor seems a bit unrealistic. Not that i dont want to believe it is true.
Reply
Old Jun 2, 2009 | 11:03 AM
  #294  
lan_evo_mr9's Avatar
Evolved Member
iTrader: (10)
 
Joined: Feb 2006
Posts: 1,097
Likes: 2
From: MD
I used DJ-let me try the MD

Edit: This is more realistic
Comparison Pull
381 WHP @ 6027 RPM
364 WTQ @ 4192 RPM

Edit: quite the difference between the two correction factors when it comes out with the totals. I still cant get the graph to show up even if I have the same data in each pull or erasing one pull completely. I wish my car was more like the DJ numbers

Edit: How do you have the chart templates setup? I was able to get some lines(not correct), but none the less, some sort of picture, which makes me think it has something to do with the chart template- or I could be completely wrong- like usual.

edit: The MD numbers do seem to be pretty spot according to my last "real" DJ numbers. Good work J of T!

Last edited by lan_evo_mr9; Jun 2, 2009 at 12:05 PM.
Reply
Old Jun 2, 2009 | 12:59 PM
  #295  
John F's Avatar
Evolving Member
 
Joined: May 2007
Posts: 121
Likes: 0
From: Edinburgh, UK
Originally Posted by Jack_of_Trades
Question to anyone who has Excel AND openoffice.....when I open up the spreadsheet in excel (version 4.1) my torque values are elevated but when I open the SAME logs in OpenOffice, the peak torque values reflect my actual torque numbers from the dyno much more realistically. Can anyone else confirm a variance between the two programs for me????
I have both on a Mac. HP is similar but torque is lower on Openoffice.
Attached Thumbnails calc HP/TQ from EvoScan using Excel-openoffice.png   calc HP/TQ from EvoScan using Excel-excel.png  
Reply
Old Jun 2, 2009 | 01:42 PM
  #296  
lan_evo_mr9's Avatar
Evolved Member
iTrader: (10)
 
Joined: Feb 2006
Posts: 1,097
Likes: 2
From: MD
John, what chart settings are you using for openoffice?
Reply
Old Jun 2, 2009 | 02:19 PM
  #297  
John F's Avatar
Evolving Member
 
Joined: May 2007
Posts: 121
Likes: 0
From: Edinburgh, UK
Originally Posted by lan_evo_mr9
John, what chart settings are you using for openoffice?
I made a duplicate of the Excel file and opened it with Openoffice. The chart settings are identical:

Evo 8 3rd gear
3500lbs
Dynojet correction = 1.121
Air temp = 65
Baro = 30
Reply
Old Jun 2, 2009 | 03:40 PM
  #298  
lan_evo_mr9's Avatar
Evolved Member
iTrader: (10)
 
Joined: Feb 2006
Posts: 1,097
Likes: 2
From: MD
^^^^^^ I meant for the dyno graph plot picture. My picture isn't showing up, but the number calculations are all there. there's specific settings for that chart- wondered if you had messed with them at all. I'm using the openoffice also.
Reply
Old Jun 2, 2009 | 03:55 PM
  #299  
John F's Avatar
Evolving Member
 
Joined: May 2007
Posts: 121
Likes: 0
From: Edinburgh, UK
Originally Posted by lan_evo_mr9
^^^^^^ I meant for the dyno graph plot picture. My picture isn't showing up, but the number calculations are all there. there's specific settings for that chart- wondered if you had messed with them at all. I'm using the openoffice also.
No. Sorry, I didn't touch the chart settings.
Reply
Old Jun 2, 2009 | 04:01 PM
  #300  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Ok, been crazy busy but it looks like my smoothing for the Base HP Smooth column is a bit too aggressive. I tried scaling it to MrFreds original spreadsheet but I guess its not as solid of a plan I thought lol. I have a fair amount of data between Spins4's dyno results I datalogged plus the data GST Motorsports contributed so hopefully I can find a good ratio that works overall.

The thing tat sucks is trying to make it work for small files AND huge files. Maybe someone can find a way to have it average each log to fit in only 50-70 cells (average 'small' file I have seen when people log a lot of things at once). If anyone wants to figure out how to do that, we can probably get the consistency to be pretty fair.
Reply



All times are GMT -7. The time now is 01:00 PM.