nisr227

I've put this on the Evo Mag Forum, but I'll put it on here too. I've been working on a spreadsheet with my own 1/4 mile (and 0-60) formulars using just very basic information to keep it simple.

There are other programs on the web, far far more complicated, that do this, but I wanted a go at designing a "simple" formular myself, which will soon be on a web site, with interesting figures.

I'm now using NEW FORMULAS, to allow for fwd big power and trying to get it down (MRKIV !), so hopefully they are closer to real life in most cases, including modified cars.

Here's a sample of info from my spreadsheet:
THE END FIGURES ARE THE PREDICTED 1/4 MILE TIMES

In theory, how fast should a car accelerate? Here you will find a calculated 0-60 and 1/4 mile time based on outright power, weight ratio, and its drivetrain, and nothing else! Figures are based on full maximum trash with no TLC, but fwd does allow for wheel spin:

Sunny / Pulsar GTi-R (standard) 93 227 1250 182 5.5 13.8
Sunny / Pulsar GTiR with genuine everyday 290bhp (MY CAR) 290 1250 232 4.4 12.7

Sample of 4WD
Audi S3 99 210 1375 153 6.4 14.8
Audi S4 01 265 1512 175 5.6 14.0
Audi RS2 95 315 1595 197 5.1 13.3
Audi RS4 02 375 1620 231 4.4 12.6
Audi RS6 02 444 1840 241 4.2 12.4
Audi TT 1.8T 225bhp 98 225 1395 161 6.1 14.5
Ford Escort RS Cosworth 96 227 1304 174 5.7 14.1
Ford Sapphire RS Cosworth 4X4 93 220 1367 161 6.1 14.5
Lancia Delta Integrale 16v Evo 93 210 1350 156 6.3 14.7
Mitsubishi Lancer Evo VI GSR/Makinen Ed 01 276 1365 202 5.0 13.3
Mitsubishi Lancer Evo VI RS 01 276 1260 219 4.6 12.9
Mitsubishi Lancer Evo VII 02 276 1360 203 4.9 13.3
Mitsubishi Lancer Evo VII FQ300 02 305 1360 224 4.5 12.8
Mitsubishi Lancer Evo VII RS Sprint 02 320 1260 254 4.1 12.4
Mitsubishi Galant VR-4 (Import) 99 276 1524 181 5.5 13.8
Nissan Skyline R33 GT-R VSpec 97 330 1601 206 4.9 13.1
Nissan Skyline R34 GT-R 99 350 1605 218 4.6 12.9
Porsche 911 (996) Turbo 4wd 00 420 1549 271 3.9 12.0
Subaru Impreza 2.0 Turbo UK 98 215 1235 174 5.7 14.1
Subaru Impreza P1 98 276 1283 215 4.7 13.0
Subaru Impreza RB5 (PPP) 98 237 1235 192 5.2 13.6
Subaru Impreza Sti 4/5/6 98 276 1275 216 4.7 13.0
Subaru Impreza WRX 01 215 1385 155 6.3 14.7
Subaru Impreza UK300 02 242 1385 175 5.7 14.0
Subaru Impreza WRX Sti 7 Type UK 02 261 1470 178 5.6 13.9
Subaru Impreza WRX Sti 7 Type UK PPP 02 305 1470 207 4.8 13.1
Subaru Impreza WRX Sti 7 (New Import) 02 276 1430 193 5.2 13.5
Subaru Impreza WRX Sti S202 03 316 1330 238 4.3 12.6
Subaru Legacy RSK B4 (import) 99 276 1584 174 5.7 14.0
Toyota Celica GT4 96 255 1380 185 5.4 13.7
Volkswagen Golf 2.8 V6 4motion 00 204 1400 146 6.7 15.1
Volkswagen Golf R32 02 237 1477 160 6.1 14.5

Sample of Rwd
BMW M3 Coupe E36 98 321 1471 218 5.1 13.4
BMW M3 Coupe E46 02 338 1570 215 5.2 13.4
BMW M5 99 400 1756 228 5.0 13.2
Caterham Super 7 R500 00 230 450 511 3.2 11.6
Ferrari F355 Spider 94 380 1332 285 4.2 12.4
Ferrari 360 Modena 02 400 1390 288 4.2 12.4
Lamborghini Murcielago 02 570 1650 345 3.8 11.8
Lotus Elise 1.8i 96 118 723 163 6.5 15.0
Lotus Exige 01 192 780 246 4.7 13.1
Mclaren F1 94 627 1138 551 3.2 11.2
Noble M12 GTO 02 310 980 316 4.0 12.2
Pagani Zonda C12S rwd 02 542 1250 434 3.4 11.4
Porshe 911 GT3 (new) 03 381 1380 276 4.3 12.5
Totota Supra 3.0TT 96 326 1582 206 5.4 13.6
TVR Griffith 500 93 340 1075 316 4.0 12.2
TVR Tuscan S 01 390 1100 355 3.7 11.9
TVR Cerbera 4.5 98 420 1178 357 3.7 11.9
Ultima GTR 02 534 990 539 3.2 11.3
Vauxhall VX220 Turbo new 03 197 930 212 5.3 13.7
Westfield SEiGHT 02 270 622 434 3.4 11.7

Sample of Fwd
Citroen Saxo VTS 02 120 935 128 8.4 16.8
Fiat Coupe 20v Turbo 00 220 1307 168 6.7 15.1
Ford Focus RS 02 212 1278 166 6.8 15.2
Honda Civic Type-R 02 197 1204 164 6.8 15.3
Mini Cooper S 01 161 1140 141 7.7 16.2
Peugeot 106 GTi 1.6 97 120 950 126 8.5 17.0
Peugeot 206 Gti 02 137 1028 133 8.1 16.6
Peugeot 306 GTi-6 2.0 99 167 1215 137 7.9 16.3
Renault Cio Williams 93 150 981 153 7.2 15.7
Renault Clio Sport 172 mk1 00 170 1059 161 7.0 15.4
Renault Clio Sport 172 mk2 02 170 1110 153 7.2 15.6
Renault Clio Sport Cup 02 170 1011 168 6.7 15.1
Seat Leon Cupra R 02 210 1376 153 7.2 15.6
Skoda Octavia RS 02 180 1354 133 8.1 16.5
Volkswagen Golf GTi (mk1) 83 112 906 124 8.6 17.1
Volkswagen Golf GTi 8v 3dr(mk2) 86 112 920 122 8.8 17.3
Volkswagen Golf GTi 16v 3dr(mk2) 92 139 1020 136 8.0 16.4
Volkswagen Golf 1.8T Gti 02 150 1236 121 8.8 17.2
Volkswagen Golf VR6 96 174 1220 143 7.7 16.1
Volkswagen Corrado VR6 96 190 1237 154 7.2 15.6



DEMOS:
Ford Escort RS Cosworth (Martin H) REYLAND 500 1304 383 3.1 11.2
Nissan Skyline R33 ABBEY MOTORSPORT 700bhp 700 1500 467 2.8 10.7
Mitsubishi Lancer Evo VI RS Norris Designs 586bhp 586 1260 465 2.8 10.8
Mitsubishi Lancer Evo VII RS - NORRIS DESIGNS 771bhp 771 1200 643 2.7 10.5
Nissan Sunny GTiR Ivans (Australia) 564bhp 564 1000 564 2.7 10.7
Mini Cooper S 210bhp conversion 210 1140 184 6.3 14.6
VW Golf MK4 362bhp (G.Handy) 362 1220 297 4.7 12.9




Its not perfect, but its only using very basic info so I'm chuffed with the results i'm getting.

What's everyone's thoughts, and if you give me the required 3 bits of info i'll show you what it predicts on your car, if its not on the list??

I only require your:
1) BHP
2) Weight in KG
3) If its 4wd, Rwd or Fwd


STEVE
GTi-R305 4wd

cletterridge

Hi, try these: 975kg, 130bhp, rwd.

Can you show us your formula? I'd be interested to see how you're making your estimates.

nisr227

Here you go:

Cletterridge 130 975 133 7.8 16.3


Sorry mate, but i'm keeping the formula secret, its taken me ages to design it using just such basic info. I'm trying to proove to people that I don't need torque figures, or anything else other than the BHP, weight, and drivetrain to get a close time.

catflap

Do my westfield megablde

430kg at 135 bhp
Using a 3.6 diff

nisr227

There always one with special diffs! probably knock it out, anyway heres what it comes up with:

Catflap 135 430 314 4.0 12.4

Is it close, or not>.... this is an interesting one? very quick by the way!

Robertio

iTrader: (1)

Just out of interest, what do you get for:

300bhp 1260kgs RWD

And, what difference if power goes up to 380bhp?

Thanks

nisr227

Robertio 300 1260 238 4.8 13.1

When the power's increased to a genuine 380bhp its:
Robertio 380 1260 302 4.1 12.3

cheers
Steve

mbc

steve whats this come out at 365bhp 1365kg and 4 wheel drive

cheers

mike

RichiW

Mitsubishi Lancer Evo VI GSR 360bhp 1365kg Please

mbc

richiw you'll be the same as me the

ScoobyDoo69

iTrader: (17)

295bhp 1385kg 4WD

ScoobyDoo69

catflap

Yeh 3.6 is pretty close mate makes for better acceleration up to 100, but loses 5 or 6 mph at top end

12 odd seconds, thats not bad, the actlal bets figure (ive seen) is 13 seocnds, so your calculaitons are not a million miles out

Taking into acount wheel spin and wind and all that

Cheers

LG John

Surely an E46 M3 would hammer a P1 over the 1/4 mile

nisr227

Here you go:

mbc 365 1365 267 3.9 12.1
RichiW 360 1365 264 4.0 12.2
scoobydoo69 295 1385 213 4.7 13.0

MBC/RichiW - the difference is much closer, i've just set it to only one decimal point, so they are more or less the same.

Re, the new M3 (13.4) slower than the P1 (13.0) in the theory figures, yes, my figures are based on the drivetrain where 4wd will get off the line quicker, bhp per ton, and overall bhp coming into more further up the 1/4 mile. I have not allowed for tranmission losses becuase 4wd is better for 1/4 mile times. But i'm sure the M3 will be closing in hard with a higher terminal speed.

I've seen many different new M3 figures in the magazines, Evo Mag tested it at 13.7secs, but it all depends on how much they got out of the car, itself. I've tried to predict the best possible figures you'll ever get with no TLC and a perfect setup car.

davyboy

1) 250 & 300
2) 1400 KG
3) Rwd

Jeff Wiltshire

Egg timer for Davyboys Porsche

nisr227

Daveyboy 250 1400 179 6.0 14.4
Daveyboy 300 1400 214 5.2 13.5

m4rk rs

sapphire 2wd-1250 kg can you give figures for 350bhp and 430bhp please

also for 204bhp if youcan please

mark

[Edited by m4rk rs - 3/16/2003 6:08:50 PM]

skiddus_markus

AWD/380bhp/1250kg.I'm guessing it's gonna come out around 11.4secsNice formula you've got there Steve.

chrisp

MY00 WRX RA

1240kgs, 276bhp, AWD



Cheers

chris


BTW I reckon it will come out pretty similar to a
Mitsubishi Lancer Evo VII FQ300 02 305 1360 224 4.5 12.8


[Edited by chrisp - 3/16/2003 6:35:07 PM]

nisr227

M4rk rs 350bhp 350 1250 280 4.3 12.5
M4rk rs 430bhp 430 1250 344 3.8 11.9
M4rk rs standard 204bhp 204 1250 163 6.5 14.9

I would be suprised if a rwd cossie can get those figures consistantly though, I know they suffer from getting the power down from what i've seen at santapod.

ScoobyDoo69

iTrader: (17)

I think these times are slightly optimistic, because your forgeting the extra weight of fuel, so someone needs to add the extra weight of fuel onto the weight of the cars.

ScoobyDoo69

nisr227

Here you go, some more figures:

Skiddus_markcus 380 1250 304 3.5 11.8
Chrisp 276 1240 223 4.5 12.9



Skid, i've actually put a lot of Pulsar figures into the spreadsheet as a comparison, see following:

276bhp filter, plugs, bv, exh 1bar 276 1250 221 4.6 12.9
290bhp as above Unichip/hks 1 bar 290 1250 232 4.4 12.7
300bhp " " " 1 bar + Front Mount 300 1250 240 4.3 12.6
320bhp 1.2 bar, Fmount 320 1250 256 4.0 12.3
350bhp 1.4bar " Forged Pistons, Hybrid 350 1250 280 3.8 12.0
370bhp 1.6bar " Forged Pistons, Hybrid etc 370 1250 296 3.6 11.8
400bhp 1.8/2.0 bar " + cams, injectors etc 400 1250 320 3.4 11.6
400bhp 1.8/2.0 bar as above + Fibreglass/stripped 400 1000 400 3.0 11.2
450bhp+ 2.0+ bar as above + Fibreglass/stripped 450 1000 450 2.8 11.0
500bhp and lightweight 500 1100 455 2.8 10.9

The mods listed, are just examples. If you've noticed, i've changed the weight on some to see what it does. I've also put Ivans car on the first list of samples.

nisr227

Scoobydoo69 - I understand what your saying, but i'm sure some people run Santapod with very low fuel, and i'm trying to predict their possible "best time", by all means add some weight.

As I keep mentioning, they are also full thrash with no TLC, the chances are most people will be as much as half a second off when trying their best and being carefull/TLC. We don't all like doing 20+ runs and "slamming" the box into each gear to see what it can really do.

m4rk rs

thanks for that mate.just wanted to see what it would come out with compared to mine and other cars spec...mines 350bhp and thinking of 430 conversion in the future.standard figure was to compare with factory figures to see how close it is...standard is 0-60...5.8secs and 1/4..14.4/97mph

mark

Merc_Cosworth

1260kgs
187bhp
RWD

and my other toy

1120kgs
235bhp
RWD

This'll be interesting, as both have been 0-60'd already - so lets see if the theory holds against fact!

LordLuthor

MR2 turbo,

1250kgs
280bhp
RWD

Jay m A

iTrader: (2)

I have an impreza MY95 WRX, not sure of the wieght, 1250??

Could you do 250, 280 and 300 bhp please.

Thanks

chrispy200+

iTrader: (2)

ok i'll go for first fwd i think,

around 1230kg (not 100% sure on it though) and 231bhp, i know what it is capable of at santa pod so will be a good judge of how your calcs work

Stripped out rover 220gti turbo

nisr227

Right then, here you go for the most recent requests:

Jay, i've changed yours to 2 decimal points to show the differences in more detail, to get the correct weight is important though:

4wd:
Jay m A 250bhp 250 1250 200 5.00 13.35
Jay m A 280bhp 280 1250 224 4.52 12.84
Jay m A 300bhp 300 1250 240 4.27 12.57

Rwd:
Merc_Cosworth 187 1260 148 7.1 15.5
Merc_Cosworth 235 1120 210 5.3 13.7

Lordluthor 280 1250 224 5.0 13.3


And the fwd:
Chrispy200+ 231 1230 188 6.2 14.5


What do you think?