Virtual Dyno Room

[Admin]

Version v5.71 includeS a new sheet with all of the default Evo 7-10 info for 3rd gear ratio,4th gear ratio,final drive ratio, Frontal Area (ft^2) and Drag CoEfficient. Also, there are 10 USER definable blank rows so ANY vehicle can be added and saved to the drop-down list for future use!

v5.62 revision added on 9/01/2009

• Updated the Dynojet Dyno Correction to 1.110
• 2005 Evo 8 5-speed and 2006 MR gear ratios were corrected
• Fixed the problem with the BASE PULL side not appearing on the graph.

v5.5 revision added on 6/30/2009
The DynoJet and EVO-M Comparator Dyno Correction Factors were corrected.

v5.4 revision added on 6/29/2009
The 'Directions' link was edited to link to the new DIRECTIONS tutorial webpage.
This version works with all platforms (Excel 2007,Excel 97-03,OpenOffice 3.1)

v5.3 revision added on 6/23/2009

• Improved calculations for increased accuracy
• Increased resolution from 250 RPM to 50 RPM
• Edited Dyno Graph to auto-fit to the size of the RPM range logged
• Added Tire Diameter Calculator to 'User Settings' page

First off, I want to thank MrFred for creating the original excel spreadsheet that I got the base formulas from, without your initial motivation I wouldn't have tried to create something with Excel (this was my first time using excel).
Virtual Dyno Room (version 5.71) is an Excel based program (should work with the freeware version 3.1 by www.OpenOffice.org too). You can take a 3rd or 4th gear pull from your logging software (evoscan,etc...) and paste it into this program to get an idea what your power curve looks like (though the HP/TQ values are quite close, dont expect them to be dead-on with a real dyno!).
The simulator only needs two columns of data....TIME and RPM. Everything else required is calculated internally by the vehicle information you enter into the simulator.
The simulator averages the data from 2450 RPM to 10,100 RPM but you will see a little bit of data loss at each end of the graph from the smoothing feature.
Its best to start your pull 250 RPM sooner than you would like to see on the graph and to finish 250 RPM later than you'd like to see on the graph.
Cut and paste the data for LogEntrySeconds and RPM from your datalog but make sure to only transfer over the data while you were at 100% TPS (wide-Open throttle).
When using the 'SMOOTHING' feature, start at a smoothing factor of '1' and work your way up until the jagged bumps just begin to smooth out. Adding too much smoothing will throw off the accuracy. Just like on a real dyno.

Newly added features for those who have been using the beta versions are:

• User adjustable Tire Diameter (the stock default tire diameter is 25.3 inches or 64 centimeters)
• Metric/Imperial conversion (weight,Air Temp,Baro. Pressure,Tire Diameter)
• User defined gear and final drive ratio
• User adjustable labeling for the Base Pull and the Comparison Pull

This took me COUNTLESS hours upon hours to get to work with the LARGE variance in datalog file sizes so although its free for everyone to use, I will be adding a donation button to this thread for anyone who finds this tool useful for them. ANY donations are GREATLY appreciated!
If there are any revisions or updates, I will keep this first post updated with the revisions and the link to the newest version. Thanks guys!
CLICK HERE TO DOWNLOAD 'Virtual Dyno Room v5.71' ![/URL]
"][/URL]








CLICK HERE TO DOWNLOAD 'Virtual Dyno Room v5.71' ![/URL]
"][/URL]

[jack_of_trades]

This will hopefully be in a stand-alone version by summer. A few programmers were attempting to create a stand-alone version for me for free so you didn't need to have Microsoft Excel or OpenOffice3.0( or newer). If you are damn good with that stuff and want to contribute to the cause, PM me and you can give it a try!

I might add some sort of TIME feature which can measure the acceleration time between 2 RPM points (user adjustable) so you can see how well your tuning/upgrades improved/hurt your acceleration from say...4k-7k RPM or whatever.

I also might add a 'performance' factor with this too which takes your vehicle weight,tire size and acceleration time into account and 'RATES' your performance (from 0.0 to 10.0 or something) . Kind of how Windows can rate your computers performance depending on your processor,memory and other hardware items. Buschur's 'BAD BISH' would probably have a pretty high rating lol. Just something to work on to help compare setup's between cars, similar to a power/weight ratio.

I also may add 2 Buschur Dyno modes, one prior to his new Dyno Settings in tha past few months and a new one to match his current Dyno #'s.

Merry Xmas and Happy Holidays!