Soarer Central: Stock Production Cars 1/4 Mile Spreadsheet

Soarer Central Mechanical - TT General Mechanical Stock Production Cars 1/4 Mile Spreadsheet

Previous Next

Author

Message

Manual Kalianis
TryHard
NSW
2JZ-GTE TT

Posts: 273
Reg: 11-2008

Rating: N/A
Votes: 0 (Vote!)

Monday, May 13, 2013 - 01:49 pm, by: Manual Kalianis (Manual_kalianis)

I have created a spreadsheet which lets you compare stock production cars (versus each other) and how they compare in a drag race against each other.

I compiled all the data for each car from MOTOR Magazine. MOTOR Magazine use a GPS Timer accurate to within 1% accuracy.
The data I compiled tells you how long a vehicle takes to accelerate from 0-10kph, 0-20kph, 0-30 kph etc etc and also tells you the 1/4 mile.

I have created a spreadsheet which converts this data to how many metres a car has travelled per second during a race. And in turn have worked out and made a drag timeslip for each car.

The times are very accurate to real life times.
Some people have stated some of the 60 foot times on these supercars look a bit slow.

There is 3 reasons for this:

Firstly, there is no rollout with these times like a drag strip.
Secondly, Tyre pressures and tyres are untouched from the manufacturer. No ET Streets or 18psi tyre pressures. Tyre pressures are all over 35psi which equates into slow take offs
Thirdly, a lot of these times are timed at race tracks which are unprepared like a sticky drag strip.

The cells which get highlighted yellow shows you which vehicle is ahead during the race.
Also on the right it shows you how much metres ahead or behind each car is against the other.

A good example is load up a SUBARU WRX STI 2011 for Vehicle A and a FPV F6 310 for Vehicle B. You get to see how the Subaru jumps ahead by a few cars and then the Ford comes backs and overtakes it.

Upload
MOTOR Stock Cars - COMPARISON SPREADSHEET.xls (149.0 k)

Joshua Rao
Goo Roo
WA
TT (for sale $5.2k), 97 Blk UZZ31, 97 JZZ30 vvti turbo white manual, 96 vvti turbo manual, Legnum VR4, MR2 sw20, Alfa 156

Posts: 3248
Reg: 09-2006

Rating: N/A
Votes: 0 (Vote!)

Monday, May 13, 2013 - 02:26 pm, by: Joshua Rao (Soaren1)

Awesome your a legend. Thanks

Manual Kalianis
TryHard
NSW
2JZ-GTE TT

Posts: 274
Reg: 11-2008

Rating: N/A
Votes: 0 (Vote!)

Monday, May 13, 2013 - 02:44 pm, by: Manual Kalianis (Manual_kalianis)

Joshua Rao wrote on Monday, May 13, 2013 - 02:26 pm:
Awesome your a legend. Thanks

No probs. I will update this every month when new cars are tested by MOTOR Magazine.
The Editor of MOTOR Magazine has given me free subscription for life and I also send them this data which they use to compare cars. Also I get invited to all their Performance Car of the Year Shoouts & Tuner Shootouts which is awesome.

Matthew Sharpe
Goo Roo
North Island
JZZ31

Posts: 6854
Reg: 10-2005

Rating: N/A
Votes: 0 (Vote!)

Tuesday, May 14, 2013 - 06:47 am, by: Matthew Sharpe (Madmatt)

Awesome work!

Manual Kalianis
TryHard
NSW
2JZ-GTE TT

Posts: 276
Reg: 11-2008

Rating: N/A
Votes: 0 (Vote!)

Tuesday, May 14, 2013 - 10:29 am, by: Manual Kalianis (Manual_kalianis)

Thanks Guys.

What I love about this spreadsheet the most is it shows you how a slower car with a super fast launch vs a faster car with a slower launch compare every second during the race.

A good example is the screenshot below you have the fastest HSV ever built the W427 7 litre LS7 vs
a Subaru WRX STI with 4WD turbo 2 litre.

What this spreadsheet shows you which is awesome is even though the HSV W427 does 0-100 kph 4.90 seconds and the Subaru WRX STI does 0-100 kph in 5.51 seconds, its not until the 7.5 second mark when the HSV eventually catches and passes the STI.

A lot of people think just because the HSV does 4.90 to 100kph and the STI does 5.51 seconds that the HSV is ahead at the 100kph mark is misleading.

In reality it takes the monster HSV 7 litre Corvette engine over 170 metres and around 7.5 seconds to catch the little STI from a standing start.

Its funny at the 7 second mark during the race the STI is around a bumper ahead of the HSV (47 centimetres ahead) then 5 seconds later at the 12 second mark the HSV is a whopping (26.52 metres ahead) over 5 car lengths ahead lol.

Manual Kalianis
TryHard
NSW
2JZ-GTE TT

Posts: 278
Reg: 11-2008

Rating: N/A
Votes: 0 (Vote!)

Tuesday, May 14, 2013 - 10:45 am, by: Manual Kalianis (Manual_kalianis)

Just to let everyone know there are over 181 cars you can compare ranging from 11 seond Supercars to 16 second front wheel drive hatches.

The stock cars included in this spreadsheet are as follows:

ABARTH 500 ESSEESSE
ALFA ROMEO GIULIETTA QV
ALFA ROMEO MITO
AUDI A1 SPORT
AUDI A5 COUPE 2.0T
AUDI A5 COUPE 2.0TFSI QUATTRO
AUDI A6 SEDAN 3.0T
AUDI A7 SPORTBACK 3.0
AUDI A8 SEDAN 4.2
AUDI Q7 V12
AUDI R8 SPYDER V10 5.2
AUDI R8 V10 5.2
AUDI RS5 COUPE
AUDI RS6 AVANT
AUDI RS6 SEDAN
AUDI S3 HATCH 2.0T
AUDI S4 SEDAN 3.0T
AUDI S7 SEDAN
AUDI TT 2.0 TFSI S-LINE
AUDI TT RS
AUDI TT S
BMW 1 SERIES M COUPE
BMW 123D HATCH
BMW 125I HATCH
BMW 135I COUPE
BMW 330D COUPE
BMW 335I SEDAN
BMW 335I TOURING
BMW 535i SEDAN
BMW 650i CONVERTIBLE
BMW 750I SEDAN
BMW M135i
BMW M3 COUPE
BMW M3 SEDAN
BMW M5 SEDAN V10
BMW M5 SEDAN V8 TT
BMW M6 COUPE V8 TT
BMW S1000 RR
BMW X5 M
BMW Z4 28IS
BMW Z4 35IS
CALLAWAY SC652
CHEVORLET CAMARO SS
CHRYSLER 300 SRT8 2009
CHRYSLER 300 SRT8 2012
CITROEN DS3 DSPORT
ELFIN TYPE 5
FORD FALCON G6 ECOBOOST (FG)
FORD FALCON G6E TURBO (FG)
FORD FALCON GT HO (XY)
FORD FALCON XR6 SEDAN (FG)
FORD FALCON XR6 TURBO SEDAN (FG)
FORD FALCON XR6 TURBO UTE (FG)
FORD FOCUS RS
FORD FOCUS ST
FORD FOCUS XR5 TURBO
FPV F6 SEDAN 310 (FG)
FPV F6 UTE 310 (FG)
FPV GS 302 (FG)
FPV GS 315 S/C (FG)
FPV GS UTE 315 S/C (FG)
FPV GT 335 S/C (FG)
FPV GT R-SPEC 335 S/C (FG)
FPV GT-E 315 (FG)
FPV GT-P 315 (FG)
FPV GT-P 335 S/C (FG)
FPV TERRITORY F6X
HOLDEN COMMODORE SV6 (VE)
HOLDEN SS SEDAN (VE)
HOLDEN SS UTE (VE)
HOLDEN SS WAGON (VE)
HONDA CIVIC TYPE-R
HSV CLUBSPORT GXP 317 (VE)
HSV CLUBSPORT R8 317 (VE)
HSV CLUBSPORT R8 325 (VE)
HSV GTS 317 (VE)
HSV GTS 325 (VE)
HSV MALOO R8 UTE 325 (VE)
HSV SENATOR 317 (VE)
HSV W427 SEDAN (VE)
HYUNDAI VELOSTER TURBO SR
INFINITI G37 COUPE S
JAGUAR XF V8 LUXURY
JAGUAR XF-R
JAGUAR XF-S
JAGUAR XJ S/C 5.0
JAGUAR XKR COUPE
JAGUAR XKR-S
JEEP GRAND CHEROKEE SRT8
LAMBORGHINI GALLARDO LP550-2
LEXUS IS350
LEXUS IS-F
LOTUS EVORA
LOTUS EXIGE S PP
MASERATI GRANTURISMO S
MAZDA 3 MPS
MAZDA 6 GT 2.5
MAZDA MX5 ROADSTER
MAZDA RX8 GT
MERCEDES A250 SPORT
MERCEDES C250 CGI
MERCEDES C250 SPORT
MERCEDES C63 AMG COUPE
MERCEDES C63 AMG SEDAN
MERCEDES C63 AMG SEDAN PP
MERCEDES CLS350
MERCEDES CLS63 AMG 5.5 V8 TT
MERCEDES E350
MERCEDES E500 CONVERTIBLE
MERCEDES E63 AMG 5.5 V8 TT
MERCEDES E63 AMG 6.2 V8
MERCEDES ML63 AMG 5.5 V8 TT
MERCEDES ML63 AMG 6.2 V8
MERCEDES S63 AMG
MERCEDES SL63 AMG
MERCEDES SLK55 AMG
MERCEDES SLS AMG
MERCEDES SLS AMG CONVERTIBLE
MINI COOPER JCW GP
MINI COOPER S
MINI COOPER S JCW
MINI COUNTRYMAN COOPER S ALL4
MINI COUPE JCW
MITSUBISHI EVO X MR
MITSUBISHI LANCER RALLIART
MITSUBISHI MAGNA VRX
NISSAN 350Z
NISSAN 370Z
NISSAN R35 GTR 2008
NISSAN R35 GTR 2011
NISSAN R35 GTR 2012
OPEL CORSA OPC
PEUGEOT 207 GTI
PEUGEOT RCZ
PORSCHE 911 CABRIOLET (997)
PORSCHE 911 CARRERA S (991)
PORSCHE 911 GT2 (997)
PORSCHE 911 GT3 RS (997)
PORSCHE 911 TURBO PDK (997)
PORSCHE BOXSTER
PORSCHE BOXSTER S PDK
PORSCHE BOXSTER SPYDER
PORSCHE CAYENNE GTS
PORSCHE CAYENNE TURBO
PORSCHE CAYMAN R
PORSCHE CAYMAN S
PORSCHE PANAMERA
PORSCHE PANAMERA TURBO
PORSCHE PANAMERA TURBO S
RANGE ROVER EVOQUE Si4 DYNAMIC
RANGE ROVER SPORT SC
RANGE ROVER VOGUE SC
RENAULT CLIO 197
RENAULT CLIO RS 200
RENAULT MEGANE RS 225
RENAULT MEGANE RS 250
RENAULT MEGANE RS265
SKODA FABIA RS
SKODA OCTAVIA RS-P
SKODA OCTAVIS RS WAGON
SUBARU BRZ
SUBARU FORESTER S-EDITION
SUBARU LIBERTY GT
SUBARU WRX 2008 HATCH
SUBARU WRX 2010 HATCH
SUBARU WRX 2010 SEDAN
SUBARU WRX 2012 HATCH
SUBARU WRX STI 2008
SUBARU WRX STI 2011
TESLA ROADSTER S
TOYOTA 86 GTS
VOLVO C30 T5
VOLVO S60 T6 R
VOLVO V40 T5 R-DESIGN
VW GOLF GTI
VW GOLF R
VW PASSAT CC
VW PASSAT R36
VW POLO GTI
VW SCIROCCO R
VW TIGUAN 2.0 TFSI

Manual Kalianis
TryHard
NSW
2JZ-GTE TT

Posts: 279
Reg: 11-2008

Rating: N/A
Votes: 0 (Vote!)

Tuesday, May 14, 2013 - 10:49 am, by: Manual Kalianis (Manual_kalianis)

Upload
MOTOR Stock Cars - TIME TAKEN PER 10KPH.xls (105.5 k)

And above is the raw data which gets published monthly whenever they test a new stock vehicle in MOTOR Magazine which I have converted to what you see in the spreadsheet.

You can filter ASIA, AUSTRALIA, EUROPE, USA
or Drive Type FWD, RWD & AWD

Manual Kalianis
TryHard
NSW
2JZ-GTE TT

Posts: 280
Reg: 11-2008

Rating: N/A
Votes: 0 (Vote!)

Tuesday, May 14, 2013 - 10:57 am, by: Manual Kalianis (Manual_kalianis)

And here is the spreadsheet showing metres per second travelled for all the stock cars in the spreadsheet in a list.

Upload
MOTOR Stock Cars - METRES TRAVELLED PER SECOND.xls (86.5 k)

And below here is the drag timeslips I created showing what these cars get in the 60ft , 330ft, 1/8th ET & MPH, 1000ft anf the 1/4 mile ET & MPH

Upload
MOTOR Stock Cars - DRAG TIMESLIPS.xls (67.1 k)

Michael O'Driscoll
TryHard
Victoria
TT

Posts: 374
Reg: 10-2005

Rating: N/A
Votes: 0 (Vote!)

Tuesday, May 14, 2013 - 03:07 pm, by: Michael O'Driscoll (Remickz)

Looks good Manual, Do you know what they use to do their logging?
We use Racelogic VBox's here at work for our performance testing.

Manual Kalianis
TryHard
NSW
2JZ-GTE TT

Posts: 281
Reg: 11-2008

Rating: N/A
Votes: 0 (Vote!)

Tuesday, May 14, 2013 - 07:11 pm, by: Manual Kalianis (Manual_kalianis)

Hey Michael they use the vbox aswell very good accuracy.

Joshua Rao
Goo Roo
WA
TT (for sale $5.2k), 97 Blk UZZ31, 97 JZZ30 vvti turbo white manual, 96 vvti turbo manual, Legnum VR4, MR2 sw20, Alfa 156

Posts: 3251
Reg: 09-2006

Rating: N/A
Votes: 0 (Vote!)

Wednesday, May 15, 2013 - 12:02 am, by: Joshua Rao (Soaren1)

Manual I love you. This is the best ever. I read a few car mags and absolutely hate how all there stats only ever tell me 0-100 times. I always have to Google quarter times so I'm loving your spread sheet. Would be great to see how the older stock cars fair

Matthew Sharpe
Goo Roo
North Island
JZZ31

Posts: 6856
Reg: 10-2005

Rating: N/A
Votes: 0 (Vote!)

Wednesday, May 15, 2013 - 02:10 pm, by: Matthew Sharpe (Madmatt)

I've driven a few (older) Subaru STI models and they have all felt crap until you hit at least a few thousand RPM - so how in the hell does the WRX-STI manage to pretty much beat everything over the first hundred meters? Launch control? Or is this someone just destroying the transmission so they can get off the line so fast?

Manual Kalianis
TryHard
NSW
2JZ-GTE TT

Posts: 283
Reg: 11-2008

Rating: N/A
Votes: 0 (Vote!)

Wednesday, May 15, 2013 - 02:52 pm, by: Manual Kalianis (Manual_kalianis)

Matthew Sharpe wrote on Wednesday, May 15, 2013 - 02:10 pm:
I've driven a few (older) Subaru STI models and they have all felt crap until you hit at least a few thousand RPM - so how in the hell does the WRX-STI manage to pretty much beat everything over the first hundred meters? Launch control? Or is this someone just destroying the transmission so they can get off the line so fast?

You give it at least 6000rpm and just side step the clutch and pray everything holds together.
I had a friend who had a 2004 STI completely stock on stock tyres and he got a 1.77 60 foot time. They are made for brutal launches, they just grip and lunge. Its when they hit top of 2nd to 3rd gear is when they stop moving and our heavy ass soarers start putting the hurt on these cars.

I raced a friends 210AWKW 2009 STI full bolt ons. He dropped the clutch at 6500rpm and put 3 car lengths on me from 0-80kph but by 160kph I caught and past him by a few cars. They are good in the first 2 gears only. At the drags I can outlaunch them but on the street with proper street tyres no chance, they are super quick off the line.

Walter Gillmore
Goo Roo
QLD
TT JZZ30

Posts: 1687
Reg: 07-2009

Rating: N/A
Votes: 0 (Vote!)

Wednesday, May 15, 2013 - 03:00 pm, by: Walter Gillmore (Cl33pa)

wow man. thats some dedicated work! great stuff.

Manual Kalianis
TryHard
NSW
2JZ-GTE TT

Posts: 284
Reg: 11-2008

Rating: N/A
Votes: 0 (Vote!)

Wednesday, May 15, 2013 - 04:11 pm, by: Manual Kalianis (Manual_kalianis)

Thanks guys. I work with spreadsheets at my work it was very difficult initially with the mathematics but I am very good at it and worked it out. If anyone wants to see the spreadsheet converter I created ill put it up}

Brett Harrison
DieHard
QLD
JZZ30

Posts: 849
Reg: 09-2005

Rating: N/A
Votes: 0 (Vote!)

Saturday, May 18, 2013 - 12:45 pm, by: Brett Harrison (Bretto)

W 427 60 ft of 2.36 seems a tad slow

Manual Kalianis
TryHard
NSW
2JZ-GTE TT

Posts: 286
Reg: 11-2008

Rating: N/A
Votes: 0 (Vote!)

Saturday, May 18, 2013 - 01:24 pm, by: Manual Kalianis (Manual_kalianis)

Brett Harrison wrote on Saturday, May 18, 2013 - 12:45 pm:

is 3 reasons for this:

Firstly, there is no rollout with these times like a drag strip.
Secondly, Tyre pressures and tyres are untouched from the manufacturer. No ET Streets or 18psi tyre pressures. Tyre pressures are all over 35psi which equates into slow take offs
Thirdly, a lot of these times are timed at race tracks which are unprepared like a sticky drag strip.

Here is the true raw data published in MOTOR Magazine using a GPS Racelogic VBOX very accurate which I converted to the 60ft time = 18.28 metres

Here is the raw data of a HSV W427 7.0 Litre

0-10 kph = 0.35 seconds
0-20 kph = 0.85 seconds
0-30 kph = 1.29 seconds
0-40 kph = 1.80 seconds
0-50 kph = 2.21 seconds
0-60 kph = 2.61 seconds
0-70 kph = 3.05 seconds
0-80 kph = 3.90 seconds
0-90 kph = 4.29 seconds
0-100 kph= 4.90 seconds
0-110 kph= 5.52 seconds
0-120 kph= 6.45
0-130 kph= 7.17
0-140 kph= 8.01
0-150 kph= 8.89
0-160 kph= 9.86
0-170 kph= 11.16
0-180 kph= 12.32
0-190 kph= 13.52

1/4 ET & MPH = 12.90@184.9

If you work out the maths properly to get a for example 1.60 second foot time your car needs to be able to accelerate from 0-60kph at the drag strip with the rollout (could be doing up to 5-10kph before the timer starts!) of the beam in 1.5 to 1.6 seconds.

To get a 1.80 second 60 foot your car needs to get to 0-60kph at the drag strip once again with rollout between 1.7 to 1.9 seconds.

The HSV gets to 0-60kph in 2.61 seconds with no rollout(time starts when the car moves even a cm different to a drag strip where you can pick up speed for 30cm and then the time starts.)

a 2.61 second 0-60kph time with no rollout always equals a 2.2 to 2.6 second time depending if there is wheelspin or full grip to 60kph.

Matthew Sharpe
Goo Roo
North Island
JZZ31

Posts: 6857
Reg: 10-2005

Rating: N/A
Votes: 0 (Vote!)

Sunday, May 19, 2013 - 12:30 pm, by: Matthew Sharpe (Madmatt)

Matthew Sharpe wrote on Wednesday, May 15, 2013 - 02:10 pm:
You give it at least 6000rpm and just side step the clutch and pray everything holds together

Ah that's what I was doing wrong... Too much mechanical sympathy. I'll remember never to buy a second hand STI then!

Adrian McGuire
DieHard
Queensland
Soarer Single T

Posts: 905
Reg: 12-2010

Rating: N/A
Votes: 0 (Vote!)

Sunday, May 19, 2013 - 01:11 pm, by: Adrian McGuire (Adro)

The amount of wrx transfer cases I've seen let at the starting line is the reason I would never buy one. They are made for hard launches on dirt, not Tarmac.

Mike Beck
Goo Roo
New Zealand
BMW E36 Coupe 1UZFE V8 340i

Posts: 5738
Reg: 11-2005

Rating: N/A
Votes: 0 (Vote!)

Sunday, May 19, 2013 - 02:11 pm, by: Mike Beck (Gold_40gt)

Matthew Sharpe wrote on Sunday, May 19, 2013 - 12:30 pm:

Ah that's what I was doing wrong... Too much mechanical sympathy. I'll remember never to buy a second hand STI then!

Word