Next it converts the "old money" values to proper scientific units. Power in BHP is converted to kW
Torque from ft.lb to Nm and RPM to Rad/s.

Depending on whether you entered quoted or measured values you'll see Metric values in the relevant cells
(You can enter data in all the power and torque input cells if you want to !)

The sheet next works out an "estimation" of the value of average torque through the
revs in each gear and presents you with a guess for you to use in all further calculations.

To explain the various figures it works out :-

Peak Torque is the metric value calculated directly from the figures entered in the input data area.
Torque at Max Power is the value of the torque at the revs corresponding to peak power.
Average torque is a gross approximation arrived at by finding the average value of torque
between "Peak Torque" and "Torque at Max Power". This figure will hopefully be representative
of the actual torque available through the rev range of the engine between the point of max power -
where you change up and the torque slightly below peak value where you enter the new gear.

The only real way to do it is to know the true torque curve but the maths starts to get hard.
and it would be difficult to enter such information into a spreadsheet.

The sheet gives you a measure of what you'd have at the back wheel if there was a 10% loss between the
crank if you use the manufacturers quoted values..

Your next step is to make an educated guess at a value of torque to use for the rest of the calculations of
acceleration etc. and enter it in the cell Torque Value to Use in Calculations.

The sheet does an estimation of power in Kw and you pick a number to use for the estimation of Max Speed.
You pick a value to enter in the cell Power value to use in Calculations

[Back] [next]