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.3CD (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) 330The 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