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.

 

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

 

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)

 

Yep! As long as I don't get lost in the forrest!

 

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>

 

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

 

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>

 

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>

 

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

 

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

 

I am not sure, that's why I posted. ;> The first set of numbers (from the example) are from a Maxima, not a G35.

 

<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>

 

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>

 

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 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.