Northwest Members WA, OR, ID, MT, WY, SD, ND

Fun With Excel, Race Graphs...

Thread Tools
 
Search this Thread
 
Old 07-18-2005, 09:05 PM
  #1  
Pathological Modifier
Thread Starter
iTrader: (11)
 
Ryan K's Avatar
 
Join Date: Jan 2002
Posts: 3,626
Likes: 0
Received 1 Like on 1 Post

Default Fun With Excel, Race Graphs...

Here is the Graph of my race against Mark in the Semi.
The run went like this:



Here is the graph of the run:



More to Come!

Ryan
Old 07-18-2005, 09:34 PM
  #2  
teh PuRpL3z
iTrader: (5)
 
DrEvyl's Avatar
 
Join Date: Jun 2003
Location: Seattle, WA
Posts: 4,477
Likes: 0
Received 4 Likes on 3 Posts

Default

Want to translate for those of us who don't know what the bars represent?

Old 07-18-2005, 09:49 PM
  #3  
Pathological Modifier
Thread Starter
iTrader: (11)
 
Ryan K's Avatar
 
Join Date: Jan 2002
Posts: 3,626
Likes: 0
Received 1 Like on 1 Post

Default

So, Basically what you are looking at is the last couple of seconds for staging the car and then the run down the track.

The Yellow line represents Throttle Position, So, you can see when I go to wide open throttle. The blue line, RPM, starts to climb as I am running out first gear. You can see I have my shift points down at 5000rpm, its only in first gear for about 2 seconds. In fact it takes about that long for it to build boost from off idle.

Then after only 3 seconds in second gear, it goes into 3rd for the long haul.

The shift points were set to 5000rpm, and the shift drops the rpm down to 4000rpm.

The Pink line is a graph of Manifold pressure, at idle its running the standard 50ish KPA, then wot moves upto 100kpa (atmoshperic), then as the turbo starts working its magic it runs upto 160-180kpa (about 11psi boost).

As you can see, I caught Mark at about 9.5 seconds into my run, after that, I hung a fender, and just blipped the throttle enough to stay ahead!

Ryan
Old 07-18-2005, 10:12 PM
  #4  
Pathological Modifier
Thread Starter
iTrader: (11)
 
Ryan K's Avatar
 
Join Date: Jan 2002
Posts: 3,626
Likes: 0
Received 1 Like on 1 Post

Default

Here are the graphs for Zeke's race.




In this one, I went around Zeke about 10 seconds into my run, then just lifted and hit the brakes abit.

Looking at the slip, there was about a 40 mph difference in our speeds when I caught him.

Ryan K.
Old 07-18-2005, 10:56 PM
  #5  
10 Second Club
iTrader: (8)
 
TwoFast4Lv's Avatar
 
Join Date: Nov 2001
Location: LT1 land...the "409" of the 90s!
Posts: 10,023
Received 5 Likes on 5 Posts

Default

Damn your waste gate is bouncing alot Better fix that LOL!
Old 07-18-2005, 11:11 PM
  #6  
Pathological Modifier
Thread Starter
iTrader: (11)
 
Ryan K's Avatar
 
Join Date: Jan 2002
Posts: 3,626
Likes: 0
Received 1 Like on 1 Post

Default

I don't believe its the Wastegate, I think its the intake valves opening/closing.

The MAP sensor has a very quick response! I doubt that the turbo could raise/lower speed that quickly....

Ryan
Old 07-19-2005, 08:33 AM
  #7  
10 Second Club
iTrader: (4)
 
WAHUSKER's Avatar
 
Join Date: Feb 2004
Location: Marysville, WA
Posts: 9,448
Likes: 0
Received 0 Likes on 0 Posts
Default

You can certainly see where the turbo starts to build boost in 1st gear (almost at the end, what looks like about 4k). Your MAP sure bounces around compared to mine. I'll see if I can't post a graph of my car for comparison.

Damn fast car you got there Ryan! That was a good race, I enjoyed it. But if I'm going to make you work for it next time I need to get more agressive at the light. You had way too much room to work with at the end....
Old 07-19-2005, 08:58 AM
  #8  
Pathological Modifier
Thread Starter
iTrader: (11)
 
Ryan K's Avatar
 
Join Date: Jan 2002
Posts: 3,626
Likes: 0
Received 1 Like on 1 Post

Default

It was fun racing both of you guys, These weren't posted to make any negative comments. I only posted these up to show you what it looked like on my part.

Ryan K.
Old 07-19-2005, 09:17 AM
  #9  
10 Second Club
iTrader: (4)
 
WAHUSKER's Avatar
 
Join Date: Feb 2004
Location: Marysville, WA
Posts: 9,448
Likes: 0
Received 0 Likes on 0 Posts
Default

I didn't take it negatively. I was just critiquing myself for cutting such a bad light against you. As Ellis would say, I got treed. My plan was not to redlight & try to make you breakout. So much for that.....

So where's a pic of that trophy?
Old 07-19-2005, 10:05 AM
  #10  
teh PuRpL3z
iTrader: (5)
 
DrEvyl's Avatar
 
Join Date: Jun 2003
Location: Seattle, WA
Posts: 4,477
Likes: 0
Received 4 Likes on 3 Posts

Default

You cut a better light than I did, and actually ran your number.... I was easy pickins for Ryan. The margin of victory with you was only like .01 seconds, you gave him a .193 margin... I gave him over half a second to work with.

Looking at the history of my truck's runs, I think every third run I need to raise my dial-in by 3 tenths. Seems to do that a lot.

Either that or I really need to work on my sand bagging technique with a slow vehicle. Otherwise the truck would never be consistent enough to make it into the final.



Quick Reply: Fun With Excel, Race Graphs...



All times are GMT -5. The time now is 10:59 PM.