Mechanical Design Spreadsheets

EnginExcel creates customised spreadsheets to help Mechanical Engineers to automate the design and sizing of machine components.


A big part of my day-to-day job involves the design and sizing of mechanical components that will be part of special purpose machinery.  Excel is a great tool to help Mechanical Engineers during the design phase, since it allows to record data, to do calculations and to do interactive changes. The integration of Excel and VBA (Visual Basic for Applications) is particularly relevant when the design requires several iterations due to the non-linear nature of the problem.

Mechanical design spreadsheets examples

  • Motor gearbox calculation
  • BOM (build of materials) creation and update
  • Dimensioning of components and automated transfer to CAD

To see some examples of my work, visit my Free Material page.