gear ratio calculations
Posted: Fri Apr 21, 2006 12:36 pm
I don't know if this will be useful to anyone but me, but here you go:
http://members.optusnet.com.au/chimpboy ... ratios.xls
It will calculate resulting speeds and crawl ratios etc for any gearbox you like up with up to six speeds, and dual or single transfer cases. All you have to do is add new ones to the list and they are available for the calculator.
Note that there are four "tabs" on the worksheet - "resulting info", "gearboxes", "transfer cases", and "differentials". Currently there are only a few different gearboxes, transfers and diffs that I have put in data for.
You just select for the different gearboxes etc on the "resulting info" sheet and get your results. Should be easy if you have ever used excel before.
If people send me more gearbox/transfer case/diff information I will update the spreadsheet and upload the new version.
Jason
http://members.optusnet.com.au/chimpboy ... ratios.xls
It will calculate resulting speeds and crawl ratios etc for any gearbox you like up with up to six speeds, and dual or single transfer cases. All you have to do is add new ones to the list and they are available for the calculator.
Note that there are four "tabs" on the worksheet - "resulting info", "gearboxes", "transfer cases", and "differentials". Currently there are only a few different gearboxes, transfers and diffs that I have put in data for.
You just select for the different gearboxes etc on the "resulting info" sheet and get your results. Should be easy if you have ever used excel before.
If people send me more gearbox/transfer case/diff information I will update the spreadsheet and upload the new version.
Jason