Skip to main content

Featured Post

Why I Wrote The Sheet Mechanic (And Why Calculations Aren’t Enough)

For engineers who already know the math—but still lose projects. For the last few years, I’ve been sharing technical guides here on Mechanical Design Handbook —how to size a motor, how to calculate fits, and (as you recently read) how to choose between timing belts and ball screws. But after 25 years in industrial automation, I realized something uncomfortable: Projects rarely fail because the math was wrong. They fail because: The client changed the scope three times in one week. A critical vendor lied about a shipping date (and no one verified it). The installation technician couldn’t fit a wrench into the gap we designed. University taught us the physics. It didn’t teach us the reality. That gap is why I wrote my new book, The Sheet Mechanic . This is not a textbook. It is a field manual for the messy, political, and chaotic space between the CAD model and the factory floor. It captures the systems I’ve used to survive industrial projec...
NEW RELEASE: Stop trying to be a Hero. Start being a Mechanic. Get "The Sheet Mechanic" on Amazon »
Disclosure: As an Amazon Associate, I earn from qualifying purchases.

Timing Diagrams Part 4: Motion Simulation & Verification in Excel

In post [Part 1 - No Overlap Movement], we established the core design requirement: The die must work synchronously with the indexing mill.

Advertisement
Sketch of indexing mill mechanism
Figure 1: The physical system requires precise synchronization.

The Problem: Rigid Sequencing

Without detailed calculation, inexperienced designers often end up with a rigid timing diagram. The die waits for the indexing to completely finish before moving.

The Consequence:
This compressed movement window results in extremely high acceleration (4.15 m/s²). This leads to massive inertial forces, vibration, and premature equipment failure.

The Solution: Optimized Overlap

In post [Part 3 - Cycloid Cam Profile Analysis], we utilized the "Soft Start" properties of the Cycloid profile. By allowing the motions to overlap safely, we extended the indexing angle significantly without causing collisions.

The Engineering Impact:
We calculated that the maximum acceleration for this new timing diagram is 5 times lower than the original. This is the power of smart Motion Simulation.
Advertisement

Visual Verification: "Digital Prototyping" in Excel

Before manufacturing expensive cams or programming PLC Logic, engineers should verify their designs. This is often called "Virtual Commissioning."

While you could use high-end software like Siemens NX or SolidWorks Motion, Microsoft Excel is often powerful enough for 2D kinematics verification.

The Simulation Setup:

  1. Geometry: Plot the geometric shape of the indexing mill and die using X-Y scatter charts.
  2. Driver: Create "Driver" cells that represent the Master Clock (Time/Angle).
  3. Math: Link the position of the shapes to the driver cells using the Cycloid formulas derived in Part 2.
  4. Animation: Use a simple VBA loop to increment the "Driver" cells, creating real-time movement.

Watch the Comparison Video below:
Notice how the "Overlap" version (Right) moves smoother and slower, while completing the cycle in the exact same total time as the "No Overlap" version (Left).

Conclusion

This example demonstrates that by simply analyzing the timing diagram during the design phase, you can reduce industrial maintenance costs and improve machine reliability without spending a dime on hardware.

While we used standard Cycloid curves here, advanced designers might optimize this further using Polynomial Cam Functions.

Comments

Popular posts from this blog

Ball Detent Torque Limiter – Working Principle & Selection

Figure 1: The ball detent mechanism provides precise overload protection by disengaging instantly when the torque limit is exceeded. The First Line of Defense: Overload Clutches In high-speed automation and heavy industrial machinery, a "jam" is not a matter of if , but when . Whether it is a cardboard box getting stuck in a packaging machine or a tool crashing in a CNC lathe, the resulting torque spike can destroy gearboxes, twist shafts, and burn out expensive servo motors in milliseconds. A torque limiter (or overload clutch) is the mechanical fuse of the drive system. While electronic monitoring (current limiting) is common, it is often too slow to prevent physical damage from the massive kinetic energy stored in the system inertia. A mechanical torque limiter provides a physical disconnect that operates in a fraction of a second. Search for Torque Limiters & Safety Couplings Advertisement Why Choose ...

Polynomial Cams: Analysis & Design Pitfalls (Part 3)

Figure 1: Mathematical coefficients determine the physical shape. Poor math leads to physical defects like the "dip" shown on the right. In [ Polynomial Cam Function (Derivation of Fifth-degree function) - Part 2 ], we derived the equations for the Fifth-Degree (3-4-5) Polynomial . Advertisement Now, we apply this math to the real world of Mechanical Cam Design . The shape of the physical cam is determined by plotting these functions. Unlike a standard Cycloid curve, the polynomial allows us to manipulate the Start Velocity (v 0 ) and End Velocity (v 1 ) of the follower. However, this flexibility requires careful design. If the coefficients are not balanced, the physical cam profile can develop "dips" or negative slopes, causing the mechanical linkage to behave unpredictably. Case 1: Standard Dwell-to-Dwell (Zero Velocity) Figure 2: The standard profile (v 0 =0, v 1 =0). Safe, smooth, and ide...

Chebyshev Linkage Design: Ratios & Straight-Line Motion

Figure 1: The Chebyshev linkage converts rotary input into approximate straight-line output. Introduction to the Chebyshev Linkage The Chebyshev linkage is a four-bar mechanical linkage that converts rotational motion into approximate straight-line motion . It was invented by the 19th-century Russian mathematician Pafnuty Chebyshev , who was deeply involved in the theoretical problems of kinematic mechanisms. His goal was to improve upon existing designs, such as the Watt Straight-line Mechanism , which James Watt had used to revolutionize the steam engine. While Watt's design produces a lemniscate (figure-eight) curve with a straight section, the Chebyshev linkage is often preferred in specific machinery because the straight-line portion of the path is parallel to the line connecting the two fixed ground pivots. Search for Mechanism Design & Robotics Books Advertisement Design Ratios and Geometry The gen...