A spreadsheet to compute gearbox ratios

Here is a spreadsheet i did to compute gearbox ratios, linear ou log progression with adjustable k factor.

Just enter the 1st gear ratio, the last gear ratio, the number of gears, then you have the desired progression with adjustable k factor.

Works up to 20 gears, plus a rangebox with two gears.

Sorry it is in French, if someone wants to translate, no problem.

Can be downloaded here :

https://www.stonerecording.art/2024...-determiner-les-rapports-de-boite-de-vitesse/

I did cook this formula, it gives intermediate gear ratios from the first and last ratio, number of gears, and desired k log factor :


There is a second page, where you can compute vehicle speeds and torque values.

A screenshot :