So, I’ve been mucking around with a car spreadsheet again and I’ve developed it further to allow anyone to calculate the performance of a car EXTREMELY accurately with as fewer items of data supplied as possible. I’ve narrowed it down to up to 38 fields; some of which are not required for certain cars (8 gears, DSG gearboxes etc.) and some of which simply make it slightly more accurate (peak BHP and Torque for example).

So, for a bit of fun (and to test it), I’d like anyone who can supply data for a car they are familiar with and paste the results up so I can run it through the calculator and therefore estimate the performance. The trick bit, is that I don’t want to know what the actual car you’ve supplied data for it is! You can then compare the results with real data and let me know how it compares.

Obviously, it only works if you have actual performance data. Therefore a dyno print from a standard car that has been subjected to an automotive road test would be best.

*I should say that, due to the mystery surrounding drivetrain losses, I use wheel power only. This means that the whole formula is based on the accuracy of the dyno read out.

Vehicle
Surface: Road / Drag Strip
Weather: Dry / Wet
Compound: Road / Sports / Track Day / SlickDriven Wheels: Front
Weight (kgs): 1310
Weight Distribution (% on front): 68
Wheelbase (inches): 100
Final Drive Ratio: 3.110
1st Gear Ratio: 3.800
2nd Gear Ratio: 2.235
3rd Gear Ratio: 1.520
4th Gear Ratio: 1.156
5th Gear Ratio: 0.914
6th Gear Ratio:
7th Gear Ratio:
Tyre Width (mm): 215
Tyre Profile (%): 40
Tyre Size (inches): 17
Gear change time: 0.3
CD (Co-efficient of drag): 0.32
Frontal Area (feet): 21.6
BHP @ wheels @ 2000 rpm 40
BHP @ wheels @ 3000 rpm 91.3
BHP @ wheels @ 4000 rpm 239.3
BHP @ wheels @ 5000 rpm 315
BHP @ wheels @ 6000 rpm 342.8
BHP @ wheels @ 7000 rpm 348.2
BHP @ wheels @ 8000 rpm
BHP @ wheels @ 9000 rpm
Redline Wheel Power (rpm) 7200
Redline Wheel Power (bhp) 348.2
Peak Wheel Power (rpm) 6500
Peak Wheel Power (bhp) 348
Peak Wheel Torque (rpm) 4501
Peak Wheel Torque (lbs/ft) 330

The above represents the dataset for a circa 400bhp 20vT (hopefully coming to me in September ).

I’ve highlighted optional fields in italic. They will help but I can make do without. Have a go then, fill out as much as you can, and then paste it back up on this thread and let’s see what happens. I might even have a go at guessing the car from the stats

Excellent work. That's helped me out with some of the info I need for my dyno app
Ive still loads more to find yet though.

I'll do it myself then

I've taken it upon myself to collate the number for the upcoming Ford Focus RS (2016). Here are my estimated numbers for when Autocar get it in for their road test in the coming weeks / months. This is for a dry road for the record. Let's see how it compares when they finally get it done.

0-10mph: 0.5
0-20mph: 0.98
0-30mph: 1.5
0-40mph: 2.4
0-50mph: 3.23
0-60mph: 4.15
0-70mph: 5.72
0-80mph: 7.11
0-90mph: 8.68
0-100mph: 11.14
0-110mph: 13.32
0-120mph: 16.32
0-130mph: 20.62
0-140mph: 24.9
0-150mph: 32.99
0-160mph: 114.49

Top Speed (mph): 168.8
Top Speed (rpm): 6197
60-100mph: 6.97

60ft Time: 2
60ft Terminal: 38.4
330ft Time: 5.37
330ft Terminal: 67.3
1/8 Mile Time: 8.27
1/8 Mile Terminal: 87.7
1000ft Time: 10.67
1000ft Terminal: 97.7
1/4 Mile Time: 12.85
1/4 Mile Terminal: 108
0-400m Time: 12.8
0-400m Terminal: 107.7
1km Time: 23.62
1km Terminal: 137.4
3/4 Mile Time: 26.91
3/4 Mile Terminal: 143.5
1 Mile Time: 33.02
1 Mile Terminal: 150.1

Go on PH 0-60 is already declared as is v-max.
4.7 to.62 and 165.

You're bloody close!!!!

This is interesting ryan. Do you know where i could attempt to populate this for the aston? It's the standard 4.3 I've got.

I'm surprised how tardy the Focus RS is (or will prove to be...) from 60-100 - almost seven seconds - just goes to show that its decent 0-100 and quarter mile times are down to the 4WD launch and (presumably) lots of electronics

By comparison, my Coupe is doing 60-100 in 4.1

RS is also a bit lacking at the top end - 21 seconds for 100-150 against 9.43 for me

Just goes to show how rapid a modded 15+ year old Coupe can be, for about a third of the cost of the Ford

Trappy - are you sure about the 0-160 figure? - 114 seconds is a monstrous jump from the 33 second 0-150 time - is it really taking 81 seconds to add that last 10mph? - that would be well over three miles

Regardless, I'm looking forward to an "encounter" with one, but I just hope its in a straight line with a rolling start....

It weighs just under 1600kgs and has 345bhp. When tuned it will be interesting but those two numbers, combined with 4wd transmission losses weren't going to set any records...



Good spot. I've checked back on the spreadsheet and quickly realised it was set to 'no short shifting'. This means it was being run to the limiter in 5th and it pretty much gasses. Switch on short shifting and the optimum gear changes are here instead. Updated numbers follow.



0-10mph: 0.5
0-20mph: 0.98
0-30mph: 1.5
0-40mph: 2.4
0-50mph: 3.23
0-60mph: 4.15
0-70mph: 5.69
0-80mph: 7.09
0-90mph: 8.66
0-100mph: 10.92
0-110mph: 13.1
0-120mph: 16.26
0-130mph: 19.73
0-140mph: 24.01
0-150mph: 31.14
0-160mph: 41.93

Top Speed (mph): 168.8
Top Speed (rpm): 6197
60-100mph: 6.75

60ft Time: 2
60ft Terminal: 38.4
330ft Time: 5.38
330ft Terminal: 67.5
1/8 Mile Time: 8.28
1/8 Mile Terminal: 87.9
1000ft Time: 10.69
1000ft Terminal: 98.9
1/4 Mile Time: 12.85
1/4 Mile Terminal: 108.9
0-400m Time: 12.8
0-400m Terminal: 108.7
1km Time: 23.51
1km Terminal: 139
3/4 Mile Time: 26.77
3/4 Mile Terminal: 144.2
1 Mile Time: 32.83
1 Mile Terminal: 152

I'd still like to see official tests rather than manufacturer's claims. 4.7s seems conservative to me...

I've got these numbers from a road test. I've filled in the red as 'estimated' as only the black numbers were available. The distances are based on this dataset.

Aston Martin V8 Vantage (2005)
0-30mph: 2.0
0-40mph: 2.9
0-50mph: 3.8
0-60mph: 4.9
0-70mph: 6.1
0-80mph: 7.7
0-90mph: 9.5
0-100mph: 11.5
0-110mph: 13.8
0-120mph: 16.5
0-130mph: 20.2
0-140mph: 24.2
0-150mph: 30.4

Calculated 60ft (18.3m) (s): 2.31
Calculated 60ft (18.3m) (mph): 33.5
Calculated 330ft (100.6m) (s): 5.86
Calculated 330ft (100.6m) (mph): 68.0
Calculated 1/8 Mile (201.1m) (s): 8.75
Calculated 1/8 Mile (201.1m) (mph): 85.9
Calculated 1000ft (301.7m) (s): 11.27
Calculated 1000ft (301.7m) (mph): 98.9
Calculated 0-400m (s): 13.32
Calculated 0-400m (mph): 107.9
Calculated 1/4 Mile (402.3m) (s): 13.37
Calculated 1/4 Mile (402.3m) (mph): 108.1
Calculated 0-1000m (s): 24.05
Calculated 0-1000m (mph): 139.6

Oooo, do my xfr please!