Found this post on Maxima.org.
Anyone with a 1/4mile timeslip can make a very good estimate of their 0-60 time. Here's how:
1. Put your times in the following format in Excel:
time distance
2.439 60
6.737 330
10.202 660
13.154 1000
15.683 1320
2. Make an X/Y graph with the time on the X axis and the distance on the Y axis.
3. Add a trendline (polynomial fit of order 2) and display the formula. For those of us with less Excel experience than others, do this by clicking on any data point on the graph, then click on Chart in the main menu. Then click on Add Trendline. Then select polynomial. Make sure that it says order 2. Click on Options. Toward the bottom, click the box for Display Equation on Chart
4. Now you should have a graph with your data, plus a curvefit, plus a formula. This formula is in the form
y = ax^2 + bx + c
In another cell in Excel type the following:
"=(88-b)/2/a" inserting your values for a and b of course
This value is a VERY VERY good estimate of your 0-60mph time. Believe me this is much easier than it appears in my instructions.
Anyone with a 1/4mile timeslip can make a very good estimate of their 0-60 time. Here's how:
1. Put your times in the following format in Excel:
time distance
2.439 60
6.737 330
10.202 660
13.154 1000
15.683 1320
2. Make an X/Y graph with the time on the X axis and the distance on the Y axis.
3. Add a trendline (polynomial fit of order 2) and display the formula. For those of us with less Excel experience than others, do this by clicking on any data point on the graph, then click on Chart in the main menu. Then click on Add Trendline. Then select polynomial. Make sure that it says order 2. Click on Options. Toward the bottom, click the box for Display Equation on Chart
4. Now you should have a graph with your data, plus a curvefit, plus a formula. This formula is in the form
y = ax^2 + bx + c
In another cell in Excel type the following:
"=(88-b)/2/a" inserting your values for a and b of course
This value is a VERY VERY good estimate of your 0-60mph time. Believe me this is much easier than it appears in my instructions.
Registered User
as soon as u setup the x,y table i knew where this was going. good post. I have NO idea how to use excel to do this but gimme a good ole ti-83+ and i could in abut 2 seconds. I have not personally ever been to a track, but once when we were having an arguement about a race where my friend beat this lightening 0-60 but the lightening beat him in the quarter and although we all agreed that the quarter mattered most, a kid (who had a 12 second wrx at the time) threw out the fact that at the track they GIVE 0-60 times. Maybe this is just a particular track in houston, but if from what ive heard if i ever go time my quarter mile, my time slip will have 0-60 also.
2004 Black on Black g coupe 6spd.... aluminum pedals, clear corners, z tube, and pop charger. soon to have 19" volk gt-c's and PIAA xtreme whites in the clearance and corners
Houston Texas
2004 Black on Black g coupe 6spd.... aluminum pedals, clear corners, z tube, and pop charger. soon to have 19" volk gt-c's and PIAA xtreme whites in the clearance and corners
Houston Texas
so eldy, will we see you there tomorrow night?
2 G or NOT 2 G, there is no question!
Injen SES, Kinetix cats, K&N Typhoon, 19" PIAA Super Rozza's (19x9 & 19x10)
2 G or NOT 2 G, there is no question!
Injen SES, Kinetix cats, K&N Typhoon, 19" PIAA Super Rozza's (19x9 & 19x10)
Yep! As long as I don't get lost in the forrest!
Registered User
O.K.
So I took my old time slip from the track...
R/T... 0.651
60"... 2.368
330... 6.351
1/8... 9.545
MPH... 77.52
1000... 12.271
1/4... 14.568
MPH... 98.24
And set up the spread sheet. I came up with the equation...
y = 4.0551 x^2 +35.209 x - 49.013
Then I plugged in a = 4.0551, and b = 35.209 into your equation and got a 0-60 time of 6.509 seconds.
Is that believeable for a 14.568 1/4 mile time?
Also, just for fun, I took the numbers initially posted and came out with a 0-60 time of 7.904 seconds.
Any one want to comment on the validity of this technique?
<font color=blue>The above statements are only my take on the issue. If you disagree with anything I typed then you are 100% right!</font color=blue>
So I took my old time slip from the track...
R/T... 0.651
60"... 2.368
330... 6.351
1/8... 9.545
MPH... 77.52
1000... 12.271
1/4... 14.568
MPH... 98.24
And set up the spread sheet. I came up with the equation...
y = 4.0551 x^2 +35.209 x - 49.013
Then I plugged in a = 4.0551, and b = 35.209 into your equation and got a 0-60 time of 6.509 seconds.
Is that believeable for a 14.568 1/4 mile time?
Also, just for fun, I took the numbers initially posted and came out with a 0-60 time of 7.904 seconds.
Any one want to comment on the validity of this technique?
<font color=blue>The above statements are only my take on the issue. If you disagree with anything I typed then you are 100% right!</font color=blue>
Registered User
6.0 seconds woo hoo
2003.5 DP 5AT Sedan (E-thing but Nav)
14.2 @ 97.18
Z-Tube
K&N Drop In & Airbox Mod
10 Wire Hyper-Ground
Crawford Plenum (V4)
UR Crank Pulley
Polk EX-3500 Tweeters/Shock Sensor/H-Liner
2003.5 DP 5AT Sedan (E-thing but Nav)
14.2 @ 97.18
Z-Tube
K&N Drop In & Airbox Mod
10 Wire Hyper-Ground
Crawford Plenum (V4)
UR Crank Pulley
Polk EX-3500 Tweeters/Shock Sensor/H-Liner
Registered User
actually 5.9 if i do it your way - i used 990 instead of 1000 for the 4th data point independent value. Is this an accuracy adjustment or just rounding to 1000?
long way from my pontiac sunbird (circa 1980) which wouldnt get to 60 in 1/4 a mile - no lie we had an airstrip that was over 1/4 mile and i'd get to 55 and have to shut her down...not sure why i tried after my bud did the some runs in his built 396 chevelle..it was a laff for sure
playing around here's a good way to get to 5.0 0-60
1.95 60
5.7 330
8.8 660
11.1 1000
13.7 1320
2003.5 DP 5AT Sedan (E-thing but Nav)
14.2 @ 97.18
Z-Tube
K&N Drop In & Airbox Mod
10 Wire Hyper-Ground
Crawford Plenum (V4)
UR Crank Pulley
Polk EX-3500 Tweeters/Shock Sensor/H-Liner
<P ID="edit"><FONT class="small"><EM>Edited by SixFive on 07/14/04 08:29 AM.</EM></FONT></P>
long way from my pontiac sunbird (circa 1980) which wouldnt get to 60 in 1/4 a mile - no lie we had an airstrip that was over 1/4 mile and i'd get to 55 and have to shut her down...not sure why i tried after my bud did the some runs in his built 396 chevelle..it was a laff for sure
playing around here's a good way to get to 5.0 0-60
1.95 60
5.7 330
8.8 660
11.1 1000
13.7 1320
2003.5 DP 5AT Sedan (E-thing but Nav)
14.2 @ 97.18
Z-Tube
K&N Drop In & Airbox Mod
10 Wire Hyper-Ground
Crawford Plenum (V4)
UR Crank Pulley
Polk EX-3500 Tweeters/Shock Sensor/H-Liner
<P ID="edit"><FONT class="small"><EM>Edited by SixFive on 07/14/04 08:29 AM.</EM></FONT></P>
Registered User
did those last 2 posts make sense to anyone?
<font color=blue>The above statements are only my take on the issue. If you disagree with anything I typed then you are 100% right!</font color=blue>
<font color=blue>The above statements are only my take on the issue. If you disagree with anything I typed then you are 100% right!</font color=blue>
Registered User
Not bad, 6.19 seconds in a stock 6MT sedan at 1200 ft altitude. sounds about right to me
Better Life thru Chemistry
Black on Black 03.5 Sedan 6MT - Goodyear F1 GS-D3's 225/55/17, Custom Intake Tube, '03 "Z" Suspension, Magnaflow resonator, 6 Wire 4 Guage Grounding Kit
Better Life thru Chemistry
Black on Black 03.5 Sedan 6MT - Goodyear F1 GS-D3's 225/55/17, Custom Intake Tube, '03 "Z" Suspension, Magnaflow resonator, 6 Wire 4 Guage Grounding Kit
Registered User
If you cant keep up then pipe down
2003.5 DP 5AT Sedan (E-thing but Nav)
14.2 @ 97.18
Z-Tube
K&N Drop In & Airbox Mod
10 Wire Hyper-Ground
Crawford Plenum (V4)
UR Crank Pulley
Polk EX-3500 Tweeters/Shock Sensor/H-Liner
2003.5 DP 5AT Sedan (E-thing but Nav)
14.2 @ 97.18
Z-Tube
K&N Drop In & Airbox Mod
10 Wire Hyper-Ground
Crawford Plenum (V4)
UR Crank Pulley
Polk EX-3500 Tweeters/Shock Sensor/H-Liner
I am not sure, that's why I posted. ;> The first set of numbers (from the example) are from a Maxima, not a G35.
Registered User
<blockquote><font class="small">In reply to:</font><hr>
actually 5.9 if i do it your way - i used 990 instead of 1000 for the 4th data point independent value. Is this an accuracy adjustment or just rounding to 1000?
<hr></blockquote>
The track I ran had 1000 ft. readings, not 990 ft. readings so I'd say that unless your track printed out a slip with x.xxx seconds at 990 ft. the initial post was right, otherwise you'd want to make the necessary adjustments.
Anyone know if there is any validity to these equations?
<font color=blue>The above statements are only my take on the issue. If you disagree with anything I typed then you are 100% right!</font color=blue>
actually 5.9 if i do it your way - i used 990 instead of 1000 for the 4th data point independent value. Is this an accuracy adjustment or just rounding to 1000?
<hr></blockquote>
The track I ran had 1000 ft. readings, not 990 ft. readings so I'd say that unless your track printed out a slip with x.xxx seconds at 990 ft. the initial post was right, otherwise you'd want to make the necessary adjustments.
Anyone know if there is any validity to these equations?
<font color=blue>The above statements are only my take on the issue. If you disagree with anything I typed then you are 100% right!</font color=blue>
Registered User
Mine slip had 990 - ATCO NJ. I made the adjustement and it helped - 10 feet or .1 - like i can tell the diff...
This is prob more accurate that a stopwatch if proven correct...
PS if someone want to see the slip it was posted last april or I can email it as it's frikkin huge
2003.5 DP 5AT Sedan (E-thing but Nav)
14.2 @ 97.18
Z-Tube
K&N Drop In & Airbox Mod
10 Wire Hyper-Ground
Crawford Plenum (V4)
UR Crank Pulley
Polk EX-3500 Tweeters/Shock Sensor/H-Liner
<P ID="edit"><FONT class="small"><EM>Edited by SixFive on 07/14/04 11:01 AM.</EM></FONT></P>
This is prob more accurate that a stopwatch if proven correct...
PS if someone want to see the slip it was posted last april or I can email it as it's frikkin huge
2003.5 DP 5AT Sedan (E-thing but Nav)
14.2 @ 97.18
Z-Tube
K&N Drop In & Airbox Mod
10 Wire Hyper-Ground
Crawford Plenum (V4)
UR Crank Pulley
Polk EX-3500 Tweeters/Shock Sensor/H-Liner
<P ID="edit"><FONT class="small"><EM>Edited by SixFive on 07/14/04 11:01 AM.</EM></FONT></P>
Registered User
So your speed w/ a 14.2 quarter was only 97 mph?
I ran a 14.171 at 101.9 w/ a 2.28 60' time (still no traction) in my 5AT coupe... I've ran 13.88 on my well-calibrated G-tech Pro w/ a 2.10 60' (better traction on a "real" road) - I'm going to have to go home tonight and see what my 60 mph time is according to the track slip... the G-tech tells me 5.7 (on avg)
2003.5 BS coupe 5AT
Clear Corners, Alum. Pedals, Pro-1 Intake, Helix Test Pipes, UR Pulley, Grounding Kit, CF Engine Cover, GReddy EVO II Exhaust, Kinetix Plenum
I ran a 14.171 at 101.9 w/ a 2.28 60' time (still no traction) in my 5AT coupe... I've ran 13.88 on my well-calibrated G-tech Pro w/ a 2.10 60' (better traction on a "real" road) - I'm going to have to go home tonight and see what my 60 mph time is according to the track slip... the G-tech tells me 5.7 (on avg)
2003.5 BS coupe 5AT
Clear Corners, Alum. Pedals, Pro-1 Intake, Helix Test Pipes, UR Pulley, Grounding Kit, CF Engine Cover, GReddy EVO II Exhaust, Kinetix Plenum
Registered User
I don't understand the math in the slightest, but for what it's worth my 14.055 timeslip gave me a 0-60 of 5.848 seconds using that method. That's for a 5AT under highly favorable conditions.