Area Under the Curve
#181
02-26-2012, 01:19 PM
Join Date: Oct 2008
Location: Fastlane USA
Posts: 2,319
Rep Power: 244 
Sounds good. For example, when I independently extracted your data from the dyno I got 735 max tq (dyno lists 734). So the methodology is quite accurate.
#185
03-16-2013, 10:55 AM
Here's something I did for another project. It calculates area under the curve for Dynojet dyno charts. However it could be used and adapted to calculate AUC for anything.
There's a series of youtube tutorials followed by examples. There's also a spareadsheet you can download with all of the formulas built in to calculate AUC.
HowTO: Export Dynojet dyno data and import to Excel:
HowTo: Advanced Dyno Graphing in Excel
HowTo: Calculate area under HP and TQ curves in Excel
Files for download:
Dyno Database: http://www.s65dynos.com
Spreadsheet with AUC forumula: http://www.rcollins.org/public/Articles/Excel%20Howto%20-%20Area%20Under%20Curve/
Instructions for using advanced techniques and AUC formula:
1. Download the files:
http://www.rcollins.org/public/Artic...Under%20Curve/
2. Load the "HowTo - Area Under Curve.xlsm" spreadsheet.
3. If you see a warning message saying the document is protected, click to enable editing.
4. If you see a warning message that you need to enable macros, then click to enable macros.
5. Make sure macros are enabled.
A) Click "File -> Options -> Trust Center -> Trust Center Settings -> Macro settings."
B) Check box "Trust access to the VBA project object model."
C) Check box "Enable all macros (not recommended...)" D) Click "OK -> OK"
This spreadsheet is already populated with four different dyno charts from different M3 supercharger solutions.
1) ESS VT2-625, 586whp, 379wtq
2) Gintani Stage-2+, 585whp, 384wtq
3) VF-620, 587whp, 381wtq
4) Active Autowerke, Stage-2, Level-3, 589whp, 379wtq
To calculate area under the curve.
1) Select one of the four tabs containing the dyno data.
2) Find an open cell under the graph to place the "=TrapRule" function. T45 and T46 are already populated with the function.
3) "=TrapRule" uses five parameters to calculate area.
=TrapRule(rpmColumn, hptqCol, startRPM, endRPM, dummyCell)
Where:
rpmColumn = Spreadsheet column containing RPM data (Column-A in this example)
hptqColumn = Spreadsheet column containing HP or TQ data
(Column-J, Column-I in this example)
startRPM = Start RPM (e.g. 3000)
endRPM = Ending RPM (e.g. 8350)
dummyCell = (OPTIONAL) If you want to automatically recalulate the results after changing dyno correction factors, then fill in this cell with any reference to data in your HP or TQ column. For example: putting "I2" in this parameter would force an automatic recalculation.
Examples:
=TrapRule("A", "J", 3000, 8400) - Calculate HP from 3000-8400 RPMs. No automatic recalculation.
=TrapRule("A", "I", 2500, 8600, I2) - Calculate TQ from 2500-8600 RPMs. Automatically recalculates if HP correction formula is changed.
See the spreadsheet. Each dyno chart already has the area calculated under the graph.
Any questions, send me a PM.
There's a series of youtube tutorials followed by examples. There's also a spareadsheet you can download with all of the formulas built in to calculate AUC.
HowTO: Export Dynojet dyno data and import to Excel:
HowTo: Advanced Dyno Graphing in Excel
HowTo: Calculate area under HP and TQ curves in Excel
Files for download:
Dyno Database: http://www.s65dynos.com
Spreadsheet with AUC forumula: http://www.rcollins.org/public/Articles/Excel%20Howto%20-%20Area%20Under%20Curve/
Instructions for using advanced techniques and AUC formula:
1. Download the files:
http://www.rcollins.org/public/Artic...Under%20Curve/
2. Load the "HowTo - Area Under Curve.xlsm" spreadsheet.
3. If you see a warning message saying the document is protected, click to enable editing.
4. If you see a warning message that you need to enable macros, then click to enable macros.
5. Make sure macros are enabled.
A) Click "File -> Options -> Trust Center -> Trust Center Settings -> Macro settings."
B) Check box "Trust access to the VBA project object model."
C) Check box "Enable all macros (not recommended...)" D) Click "OK -> OK"
This spreadsheet is already populated with four different dyno charts from different M3 supercharger solutions.
1) ESS VT2-625, 586whp, 379wtq
2) Gintani Stage-2+, 585whp, 384wtq
3) VF-620, 587whp, 381wtq
4) Active Autowerke, Stage-2, Level-3, 589whp, 379wtq
To calculate area under the curve.
1) Select one of the four tabs containing the dyno data.
2) Find an open cell under the graph to place the "=TrapRule" function. T45 and T46 are already populated with the function.
3) "=TrapRule" uses five parameters to calculate area.
=TrapRule(rpmColumn, hptqCol, startRPM, endRPM, dummyCell)
Where:
rpmColumn = Spreadsheet column containing RPM data (Column-A in this example)
hptqColumn = Spreadsheet column containing HP or TQ data
(Column-J, Column-I in this example)
startRPM = Start RPM (e.g. 3000)
endRPM = Ending RPM (e.g. 8350)
dummyCell = (OPTIONAL) If you want to automatically recalulate the results after changing dyno correction factors, then fill in this cell with any reference to data in your HP or TQ column. For example: putting "I2" in this parameter would force an automatic recalculation.
Examples:
=TrapRule("A", "J", 3000, 8400) - Calculate HP from 3000-8400 RPMs. No automatic recalculation.
=TrapRule("A", "I", 2500, 8600, I2) - Calculate TQ from 2500-8600 RPMs. Automatically recalculates if HP correction formula is changed.
See the spreadsheet. Each dyno chart already has the area calculated under the graph.
Any questions, send me a PM.
#186
04-22-2013, 12:34 AM
Hi Spooln...yeah that thread caused quite a bit of controversy it seems..lol. But in the end it turned into some very healthy and educational conversation about these engines and what they can and cannot handle. Although many other tuners have insisted that over 700+ whp AND tq is safe for the stock engine (and even shown it in some of their builds), there was an equal amount of owners who showed and proved that their rods were damaged at the power level we suggested, and even lower!
So...that begs the question: Is anything over 675 whp REALLY necessary, other then for bragging rights? In our opinion, no. With all due respect to Switzer and Proto and all those who use alpha and GT turbos (who build fantastic and powerful kits), our approach using VTG turbos is yielding greater performance, even at a lower power level. Our 68mm VTG turbo kit, only producing 675hp is capable of a 5.50 second 60-130 time (verified in the 6Speed rankings), which is equal to or faster then a lot of kits using larger turbos and producing more power. I've attached a dyno chart that should shed some light on why. (for the record that test was conducted at a 3rd party facility, not ours) It's WHERE the power is delivered. Look not only at how early peak TQ is achieved with our turbos, but also the duration of that TQ. You're getting over 500 lb/ft of TQ from 3700 rpm's onward....and a good portion of that is over 600 lb/ft. That's USABLE power. And if you take a look at what our turbo "kit" includes for the price (all the carbon, the exhaust, the manifolds...etc)...it's an incredible value in comparison.
So the question in my eyes then becomes why any more then that power level is needed?
So...that begs the question: Is anything over 675 whp REALLY necessary, other then for bragging rights? In our opinion, no. With all due respect to Switzer and Proto and all those who use alpha and GT turbos (who build fantastic and powerful kits), our approach using VTG turbos is yielding greater performance, even at a lower power level. Our 68mm VTG turbo kit, only producing 675hp is capable of a 5.50 second 60-130 time (verified in the 6Speed rankings), which is equal to or faster then a lot of kits using larger turbos and producing more power. I've attached a dyno chart that should shed some light on why. (for the record that test was conducted at a 3rd party facility, not ours) It's WHERE the power is delivered. Look not only at how early peak TQ is achieved with our turbos, but also the duration of that TQ. You're getting over 500 lb/ft of TQ from 3700 rpm's onward....and a good portion of that is over 600 lb/ft. That's USABLE power. And if you take a look at what our turbo "kit" includes for the price (all the carbon, the exhaust, the manifolds...etc)...it's an incredible value in comparison.
So the question in my eyes then becomes why any more then that power level is needed?
"Needed" is the operative word. We need far less then the stock 415 hp
of a 996 turbo. Come now, this isn't the Toyota Camry forums. You'll
find the practical and compliant people on the Camry boards and they're
very clear about not exceeding their "needs."
Sorry, just came across this and couldn't believe what I was reading!
Oh, by the way. My car does 5.5s and even 5.4s on less wheel hp
then any vtg turbo @ same level. Working on a few tweaks and in
2 weeks I'll post 5.2s 60-130. And it will be less then 675 whp.
Thread
Thread Starter
Forum
Replies
Last Post
PelicanParts.com
996 Turbo Vendor Classifieds
5
10-22-2015 09:31 AM
PelicanParts.com
996 Vendor Classifieds
3
10-20-2015 02:33 PM
