MDA logo MDA text

Spreadsheet / VBA for Robotic Drive System Sizing

MDA developed and documented this Visual Basic for Applications (VBA) driven spreadsheet which allows the user to quickly size robotic drive systems by specifying motors, gear reducers, and geared bearings for rotating equipment with loads offset from the rotation axis such as H-frames, weld positioners and such. Technical data for frequently used reducers, motors, and geared bearings is stored on the worksheets Motor, Reducer, and Geared as shown below. The Units worksheet contains all unit conversion constants. The Loads worksheet is used to input all the industry specific loads, equipment weights, and etc. Based on user selections, VBA code extracts and performs calculations on data from these worksheets. The worksheets Drive, Torque, CycleTime, and ReducerMoment are used to perform drive system performance checks, cycle time calculations for indexing type operations, component factor of safety, component life cycle, and other industry calculations. The worksheets Surface Speed, TorqueVsTime, and RollingFriction are VBA driven and used for proprietary calculations. Some VBA code and sample calculations from the Drive and Torque worksheets are shown below. The far right column of the worksheet shows the equation that is used in the corresponding cell formula in that row.

not found
not found
not found
not found
not found
not found
not found
not found
not found
MDA and Spreadsheet / VBA Development

MDA has developed hundreds of industry specific calculation spreadsheets and VBA programs. We also use spreadsheets and VBA for many of our in-house calculation programs. Some of the applications we have developed spreadsheets and VBA programs for are:

  • Custom cell-formula/VBA driven spreadsheets
  • Technical calculations spreadsheets
  • Automation of end-of-month reporting
  • Data mining incorporating SQL
  • Project engineering and sales tools