Notices
ECU Flash

calc HP/TQ from EvoScan using Excel

Thread Tools
 
Search this Thread
 
Old Jun 6, 2009 | 05:08 PM
  #316  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Thanks man. I'm getting the most conflicting data about the damn gear ratios! That article shows that some 6 speed versions use the standard final drive from the 5 speed and some use a seperate final drive. Does anyone know for CERTAIN!? I'd prefer for this spreadsheet to be as accurate as we can possibly get it. Also, does the '05 5 speed really have different gears than the '04-'05?

Last edited by Jack_of_Trades; Jun 6, 2009 at 05:10 PM.
Reply
Old Jun 6, 2009 | 08:29 PM
  #317  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Been working on this when I can but I figured I'd give you a guys snapshot of the layout so far. The only thing I really haven't added is the WHP/WTQ values will go below the graph. Hopefully I'll have it done tomorrow if i can get enough harness' built for members.



Last edited by Jack_of_Trades; Jun 6, 2009 at 08:51 PM.
Reply
Old Jun 7, 2009 | 04:03 PM
  #318  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Ok, all I need to be SURE of is whether the 2005 Evo 8 5-speeds had the same gear ratio/final drive combo as the '03-'04's or the '06's. Anyone know for CERTAIN!??????

Last edited by Jack_of_Trades; Jun 7, 2009 at 04:33 PM.
Reply
Old Jun 8, 2009 | 04:52 PM
  #319  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Here it is kids! This is about as good as I'm gonna get it for now. Its designed to work with Microsoft Excel 2007 so if you have Excel 2003 you should go to Microsofts site and download the free patch so you can see 2007 files just like Excel '07 displays them. If anyone wants to make an OpenOffice Version that matches the layout I have in Excel, I will gladly host it. I'm gonna need some serious beta testing from you guys to find any bugs I may have missed (I'm sure I missed something lol). I especially need to get feedback from 2003-2004 owners,2005 users, 2006 users, and MR owners too.

I added a seperate selection for Buschur's Mustang dyno since my data shows that his Mustang reads roughly 8% less than the average Mustang Dyno data i was given (not like we all don't already know his reads lower than others ). Nothing is set in stone for the preset values yet but I added 2 'USER" Dyno Correction factor boxes as well.

It averages every 250 RPM which I found to work out just fine since most smoothing removes any detail less than 250 RPM anyhow. If the highest RPM area seems to get a little funky on the graph, try deleting the last couple RPM/LogEntrySeconds values from the datalog you pasted into the simulator. Sometimes too much data at the end can confuse the formulas. The only annoying thing I encountered was the pop-up messages that help explain what to enter into each cell on the dyno graph. The message window can be moved anywhere you'd like it to go easy enough though.

Also, if you go to the 'VIEW' tab at the top of Excel, you can view the program in FULL SCREEN which is 10 times easier to use.

Please give me your feedback! Thanks guys!

Click here to Download 'VIRTUAL DYNO ROOM v5.0'!!!
Right click on link and "save as" to save to your computer

Attached Thumbnails calc HP/TQ from EvoScan using Excel-screenshot_vdrv5.0.jpg  

Last edited by Jack_of_Trades; Jun 8, 2009 at 09:00 PM.
Reply
Old Jun 8, 2009 | 05:08 PM
  #320  
GST Motorsports's Avatar
Account Disabled
iTrader: (8)
 
Joined: Sep 2007
Posts: 3,366
Likes: 2
From: Hayward
Lol, are you going to put a pulldown value for TTP dyno and CFT too then?

Nice work Jamie, very cool app.
Reply
Old Jun 8, 2009 | 05:15 PM
  #321  
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
Lol, are you going to put a pulldown value for TTP dyno and CFT too then?

Nice work Jamie, very cool app.
I definitely will add the 'Big Boy' dyno shops if I can get enough data from their dyno's. Its easy enough to make the drop-down list as long as I want. The Mustang dyno we just tuned with in Mass has the exact same results as your shops (so I assume these two are setup "correctly" and are a good base to set the standard correction factor with. We all know that its just a "simulator" and it could never replace a real dyno so the peak #'s should be taken with a grain of salt.

I also should note that I have it set so if any Mustang Dyno is chosen, it sets a default vehicle weight of 3225 lbs and a driver weight of 175 lbs. The only way to manipulate it is to edit the driver weight above or below 175 lbs.
Reply
Old Jun 8, 2009 | 05:17 PM
  #322  
MR Turco's Avatar
EvoM Staff Alumni
iTrader: (16)
 
Joined: May 2007
Posts: 3,233
Likes: 3
From: Massachusetts
jamie, this is awesome. one question. How do i clear the comparison pull? I just want to see a single pull, i deleted the comparo pull values but it persists.
Reply
Old Jun 8, 2009 | 05:22 PM
  #323  
GST Motorsports's Avatar
Account Disabled
iTrader: (8)
 
Joined: Sep 2007
Posts: 3,366
Likes: 2
From: Hayward
Originally Posted by Jack_of_Trades
I definitely will add the 'Big Boy' dyno shops if I can get enough data from their dyno's. Its easy enough to make the drop-down list as long as I want. The Mustang dyno we just tuned with in Mass has the exact same results as your shops (so I assume these two are setup "correctly" and are a good base to set the standard correction factor with. We all know that its just a "simulator" and it could never replace a real dyno so the peak #'s should be taken with a grain of salt.

I also should note that I have it set so if any Mustang Dyno is chosen, it sets a default vehicle weight of 3225 lbs and a driver weight of 175 lbs. The only way to manipulate it is to edit the driver weight above or below 175 lbs.
Yea I know, I was just giving you crap. It's all a tool in the end.

Again, awesome work.
Reply
Old Jun 8, 2009 | 05:35 PM
  #324  
dan l's Avatar
Account Disabled
iTrader: (3)
 
Joined: Apr 2006
Posts: 1,029
Likes: 0
From: USA
Looks good Jamie. I put it into Open Office which I run on Ubuntu and it works as well for those who may have been wondering.
Reply
Old Jun 8, 2009 | 06:01 PM
  #325  
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
jamie, this is awesome. one question. How do i clear the comparison pull? I just want to see a single pull, i deleted the comparo pull values but it persists.
Its a formula conflict I didn't test out. I will fix the error and replace the current link with the repaired version in about 15-20 minutes. For now you can just copy the base pull into both sides I suppose ;-)
Reply
Old Jun 8, 2009 | 06:25 PM
  #326  
nonschlont's Avatar
Evolved Member
iTrader: (3)
 
Joined: Mar 2007
Posts: 1,760
Likes: 2
From: Ca
Originally Posted by Jack_of_Trades
Here it is kids! This is about as good as I'm gonna get it for now. Its designed to work with Microsoft Excel 2007 so if you have Excel 2003 you should go to Microsofts site and download the free patch so you can see 2007 files just like Excel '07 displays them. If anyone wants to make an OpenOffice Version that matches the layout I have in Excel, I will gladly host it. I'm gonna need some serious beta testing from you guys to find any bugs I may have missed (I'm sure I missed something lol). I especially need to get feedback from 2003-2004 owners,2005 users, 2006 users, and MR owners too.

I added a seperate selection for Buschur's Mustang dyno since my data shows that his Mustang reads roughly 8% less than the average Mustang Dyno data i was given (not like we all don't already know his reads lower than others ). Nothing is set in stone for the preset values yet but I added 2 'USER" Dyno Correction factor boxes as well.

It averages every 250 RPM which I found to work out just fine since most smoothing removes any detail less than 250 RPM anyhow. If the highest RPM area seems to get a little funky on the graph, try deleting the last couple RPM/LogEntrySeconds values from the datalog you pasted into the simulator. Sometimes too much data at the end can confuse the formulas. The only annoying thing I encountered was the pop-up messages that help explain what to enter into each cell on the dyno graph. The message window can be moved anywhere you'd like it to go easy enough though.

Also, if you go to the 'VIEW' tab at the top of Excel, you can view the program in FULL SCREEN which is 10 times easier to use.

Please give me your feedback! Thanks guys!

Click here to Download 'VIRTUAL DYNO ROOM v5.0'!!!

Looks pretty cool. Nice work!

I threw in a couple logs, and first thing I noticed is the dynojet #'s were a lil lower... It doesnt erase the log from graph, when you delete the data. Its still showing peak @ 4000 when Im hitting 34xx-3500.
Reply
Old Jun 8, 2009 | 06:41 PM
  #327  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Ok, I updated the link up above but just in case, here is the revision:

http://dsm-ezine.com/Virtual_Dyno/VDR.v5.0.xls
Right click on link and "save as" to save to your computer

Lemme know if this works better guys. THANKS!

EDIT: NVM, its still doing the same thing. Back to work for me lol.

Last edited by Jack_of_Trades; Jun 8, 2009 at 09:00 PM.
Reply
Old Jun 8, 2009 | 06:52 PM
  #328  
MR Turco's Avatar
EvoM Staff Alumni
iTrader: (16)
 
Joined: May 2007
Posts: 3,233
Likes: 3
From: Massachusetts
I dig it jamie

Attached Thumbnails calc HP/TQ from EvoScan using Excel-vdyno5.jpg  
Reply
Old Jun 8, 2009 | 08:03 PM
  #329  
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
I dig it jamie

Try Deleting the time/rpm cells at the end of your datalog one row at a time until that high rpm flip disappears.
Reply
Old Jun 8, 2009 | 08:30 PM
  #330  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Both links should be updated with an 'error free' version. Lemme know how its working for you guys!
Reply



All times are GMT -7. The time now is 06:09 AM.