I usually won't post in stickies but I though this might be useful. I turned all the gear ratio information provided by Gravity Fed (and Mazdatrix) into a spreadsheet used to calculate engine speed based on tire diameter, vehicle speed and transmission gear and final drive ratios. The transmission types and ratios are fixed (but can be edited in the second worksheet) but I left the final drive ratio up to the user. I even put in a "custom" transmission type for those feeling ambitious.
Last edited by infernosg; 06-07-2010 at 07:32 AM..
Reason: Corrected spreadsheet equation
|