View Single Post
Old 06-04-2010, 12:51 PM   #27
infernosg
IT'S ALIVE!
 
infernosg's Avatar
 
Join Date: Dec 2009
Location: Richmond, VA
iTrader: (5)
Posts: 811
Rep Power: 15
infernosg is on a distinguished road
Default

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.
Attached Files
File Type: zip Transmission Spreadsheet.zip (11.1 KB, 39 views)

Last edited by infernosg; 06-07-2010 at 07:32 AM.. Reason: Corrected spreadsheet equation
infernosg is offline   Reply With Quote