After a lot of effort working on improvements, I’m proud to release the newest version of the AMB Design Spreadsheet. You can download it here:
With version 4.1 the user interface has gone through a complete redesign, with a high importance placed on the user experience. Now instead of having one copy of each calculator in the spreadsheet, you can have as many copies of each as you want. This way you can have one master spreadsheet for the whole robot, with separate calculators for each mechanism.
The new version also features three new calculators: Lead Screw, Beam Bend, and Pneumatic Linkage. Use the Lead Screw Calculator on its own to find the torque needed to lift a load with a certain leadscrew, or in combination with the Mechanism Ratio Calculator for gearboxes connected to lead screw outputs. Use the Beam Bend Calculator to determine how much a frame member, manipulator, or axle will deform under different loads. Use the Pneumatic Linkage Calculator to help find the correct geometry to stow and deploy an intake with a pneumatic cylinder. I decided to remove the Sprint Distance Calculator from this version of the spreadsheet due to questionable accuracy and programming bugs. If you need a similar calculator, I recommend ILITE’s Drive Train Simulator.
As always, I’d love to hear people’s comments, questions, and concerns. I can help answer questions on how to use the spreadsheet for anyone confused, and try to explain how it works for people interested in learning how the equations are devloped. If you find a bug, have ideas for improvements, or want to suggest a new calculator, you can send that my way too and I will try to work on it. You can reply to this thread, send me a PM, or send an email to arimb1999 (at) gmail (dot) com. If you don’t have anything to ask/suggest and just want to let me know you’re making good use of the sheet, I love hearing that too.