Motion Simulation with Microsoft Excel Mechanical design usually deals with the movement of several parts. There are a lot of software packages that help simulate the movement of machine parts, such as NX (UG), Solid Edge, and SolidWorks. But how do you make a simulation without those expensive software packages? I use Microsoft Excel to simulate my timing diagrams. As you can see in the video above, it provides a clear visual representation of the machine's cycle. How it Works Actually, it is nothing but motion simulation using the graphing method in Microsoft Excel. While it cannot simulate complex 3D collisions or physics like high-end CAD, it helps you get a feel for how your machine will behave according to your timing diagram. This technique uses VBA (Visual Basic for Applications) to control the movements. Here is the general workflow: Prepare the Spreadsheet: Create a table defining the geometry (coordinates) of your machine parts. Set Formu...
Mechanical Design Handbook provides practical mechanical engineering tutorials, design calculations, conveyor sizing methods, motor power and torque analysis, Excel VBA tools, and real-world industrial examples for engineers and designers.