Dirk & Mike R,
Thanks for the spreadsheet. I entered 7.2 gear ratio,1.8 step angle,18 teeth pinions & the results are exactly twice the recommended unit values. Also, the recommended unit values for my ball screws are 2000. The screw has a .2 pitch & motor has no gearbox with a 1.8 step angle which I caculated at 1000 steps per inch. I'm totally lost & could use a good explanation.
Thanks,
Jeff