This is the moment of truth. In the previous posts, we moved from abstract mathematical derivations in Excel to the concrete setup of a 3D Digital Twin.
The result of our timing diagram design—utilizing overlapping motion with Fifth-Degree (3-4-5) Polynomial and Linear cam functions—is now fully integrated into the 3D model. We are no longer just guessing; we are validating the Mechatronics Design Workflow.
The Power of "Spreadsheet Run"
The simulation below was executed using the Kinematics environment in the Unigraphics (UG) NX4 Motion Simulation Module (now known as Simcenter 3D).
By utilizing the "Spreadsheet Run" command, we are not just animating the assembly; we are driving the geometry with pure, precise data. Every frame of movement corresponds to a specific calculation row in our Excel sheet. This creates a direct data bridge, confirming that the complex polynomial curves we designed will physically clear the tooling without collision.
Video Analysis: Virtual Commissioning
Watch the simulation below closely. This is a prime example of Virtual Commissioning.
Unlike the "Constant Velocity" test in Part 3 (which resulted in a crash), this simulation shows the perfect synchronization of the Indexing Mill and the Punch Die.
- Overlap Verified: Notice that the die starts moving down before the mill has completely stopped. This validates our "Overlap" calculation, allowing for a faster total cycle time without increasing motor speed.
- Smooth Reversal: The die reverses direction at the bottom without a "jerk," confirming the 5th-degree polynomial smoothing. This reduces wear on the servo motors and linear guides.
- Interference Free: Most importantly, despite the tight timing, the parts never collide. This is Dynamic Interference Detection in action.
The Engineering Business Case: ROI of Simulation
Why go through this trouble? For a Mechanical Design Engineer, this workflow represents the gold standard of Predictive Engineering. By validating the timing diagram in a virtual environment, we achieve several key benefits:
- Zero Scrap: If we had discovered a collision here, we could simply adjust the v0 or v1 parameters in Excel, update the sheet, and re-run the simulation in minutes. Compare this to the cost of scrapping a physical cam or breaking a tool on the shop floor.
- Motor Sizing: We can extract accurate acceleration torque values from this simulation to size our motors precisely, avoiding the cost of oversizing.
- Cycle Time Optimization: We can squeeze every millisecond out of the machine cycle by pushing the overlap limits safely in the digital world.
This process—designing in Excel, validating in CAD—is the foundation of modern Multibody Dynamics (MBD) and Automation design.
Review the Full Series
If you missed any steps in this tutorial, navigate the full series below to master this workflow:
- 📂 Part 1: Introduction to NX4 Motion & The Problem with Standard Drivers
- 📂 Part 2: Setting up Links, Joints, and Kinematic Chains
- 📂 Part 3: Defining Slider Joints & Initial Crash Testing
- 📂 Part 4: Injecting Excel Data via "Spreadsheet Run"
Recommended Reading for Advanced Simulation
To master these techniques in modern versions of NX (Simcenter 3D) or other CAD packages, I recommend the following resources:

Comments