Notices
997 Turbo / GT2 20062012 Turbo discussion on the 997 model Porsche 911 Twin Turbo.

Area Under the Curve

 
  #181  
Old 02-26-2012, 01:19 PM
Registered User
Thread Starter
Join Date: Oct 2008
Location: Fastlane USA
Posts: 2,335
Rep Power: 240
TTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond repute
Originally Posted by Divexxtreme View Post
I'll ask him to send you the raw data. Thanks!
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.
 
  #182  
Old 03-02-2012, 11:16 AM
Banned
Join Date: Nov 2008
Location: Somewhere far away
Posts: 294
Rep Power: 28
Al Nunez is a name known to allAl Nunez is a name known to allAl Nunez is a name known to allAl Nunez is a name known to allAl Nunez is a name known to allAl Nunez is a name known to all
Oh god brings back memories of Calc 1 as soon as I read it.
 

Last edited by Al Nunez; 03-06-2012 at 03:22 PM.
  #183  
Old 03-04-2012, 03:42 PM
Registered User
Thread Starter
Join Date: Oct 2008
Location: Fastlane USA
Posts: 2,335
Rep Power: 240
TTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond repute
Hey Yousef, Nice gains! You must feeling it big time. Cheers.

 
Attached Thumbnails Click image for larger version

Name:	Yousef_AUC_zpsf9b3f412.jpg
Views:	925
Size:	32.3 KB
ID:	302181  

Last edited by TTdude; 11-17-2013 at 12:14 PM.
  #184  
Old 06-07-2012, 09:40 AM
Registered User
Join Date: Jun 2012
Location: New Jersey
Posts: 16
Rep Power: 0
viper168981 is on a distinguished road
awesome
 
  #185  
Old 03-16-2013, 10:55 AM
Registered User
Join Date: Nov 2009
Location: Morgan Hill, CA
Posts: 95
Rep Power: 15
PencilGeek is a jewel in the roughPencilGeek is a jewel in the roughPencilGeek is a jewel in the rough
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.
 
  #186  
Old 04-22-2013, 12:34 AM
layinback's Avatar
Registered User
Join Date: Sep 2012
Location: Birmingham, Al
Posts: 1,216
Rep Power: 111
layinback has a reputation beyond reputelayinback has a reputation beyond reputelayinback has a reputation beyond reputelayinback has a reputation beyond reputelayinback has a reputation beyond reputelayinback has a reputation beyond reputelayinback has a reputation beyond reputelayinback has a reputation beyond reputelayinback has a reputation beyond reputelayinback has a reputation beyond reputelayinback has a reputation beyond repute
Cool

Originally Posted by [email protected] View Post
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?

Why more power 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.
 
Attached Images  
  #187  
Old 08-19-2013, 12:11 AM
Registered User
Join Date: Aug 2013
Location: USA
Posts: 17
Rep Power: 0
krs2 will become famous soon enough
impressive graphs!
 
  #188  
Old 09-13-2013, 04:24 AM
pete95zhn's Avatar
Registered User
Join Date: Mar 2009
Location: In my garage
Posts: 850
Rep Power: 114
pete95zhn has a reputation beyond reputepete95zhn has a reputation beyond reputepete95zhn has a reputation beyond reputepete95zhn has a reputation beyond reputepete95zhn has a reputation beyond reputepete95zhn has a reputation beyond reputepete95zhn has a reputation beyond reputepete95zhn has a reputation beyond reputepete95zhn has a reputation beyond reputepete95zhn has a reputation beyond reputepete95zhn has a reputation beyond repute
Where are the pictures??!
 
  #189  
Old 09-15-2013, 07:30 PM
Registered User
Thread Starter
Join Date: Oct 2008
Location: Fastlane USA
Posts: 2,335
Rep Power: 240
TTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond repute
Originally Posted by pete95zhn View Post
Where are the pictures??!
Sorry but the original account got corrupted. I'll need to dig them out again and repost.
 
  #190  
Old 10-23-2013, 07:02 PM
Steve K ny's Avatar
Registered User
Join Date: Oct 2005
Posts: 5,611
Rep Power: 326
Steve K ny has a reputation beyond reputeSteve K ny has a reputation beyond reputeSteve K ny has a reputation beyond reputeSteve K ny has a reputation beyond reputeSteve K ny has a reputation beyond reputeSteve K ny has a reputation beyond reputeSteve K ny has a reputation beyond reputeSteve K ny has a reputation beyond reputeSteve K ny has a reputation beyond reputeSteve K ny has a reputation beyond reputeSteve K ny has a reputation beyond repute
can we get the pics to start working again ?
this is an awesome thread. lots to learn.
 
  #191  
Old 11-15-2013, 01:51 PM
Registered User
Join Date: Sep 2008
Location: Irvine
Posts: 18
Rep Power: 0
two outtakes is on a distinguished road
awsome
 
  #192  
Old 11-17-2013, 11:57 AM
Registered User
Thread Starter
Join Date: Oct 2008
Location: Fastlane USA
Posts: 2,335
Rep Power: 240
TTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond reputeTTdude has a reputation beyond repute
Graphs (most) have been restored.
 
  #193  
Old 01-07-2015, 10:18 AM
cam99's Avatar
Registered User
Join Date: Apr 2011
Location: Long Island, NY
Posts: 289
Rep Power: 21
cam99 will become famous soon enoughcam99 will become famous soon enough
Will most tuners provide the raw data or just graphs?
 
 
Related Topics
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
italdream
997
33
09-18-2015 09:33 PM
su_maverick
996 Turbo / GT2
32
09-08-2015 11:12 AM


Thread Tools
Search this Thread
Rate This Thread
Rate This Thread:
You have already rated this thread Rating: Thread Rating: 0 votes,  average.

Quick Reply: Area Under the Curve


Contact Us - About Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

© 2019 MH Sub I, LLC dba Internet Brands

We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.