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...
The Engineering Challenge: In 2005, I was tasked with upgrading a mechanical transfer turret used to handle highly fragile glass tubes between a conveyor and another process. Production demanded a 25% throughput increase—jumping from 1,200 UPH (Units Per Hour) to 1,500 UPH. Simply speeding up the main drive motor was impossible; the resulting inertial forces and acceleration spikes would have violently shattered the glass tubes before they ever reached the sealing station.
The Solution: When you need to increase machine throughput without increasing acceleration forces, the answer is almost always overlapping motion.
However, overlapping mechanisms in tight spaces introduces a severe risk of catastrophic mechanical collisions. To validate this 25% speed increase safely, I didn't use expensive 3D motion analysis software. Instead, I used Microsoft Excel and VBA to build a custom 2D kinematic simulator. Here is how that mathematical model was built, and how that exact machine is still running in production over two decades later.
Figure 1: High-speed transfer turrets require precise kinematic timing to safely handle fragile payloads like glass without introducing destructive acceleration forces.
(Note: This image is an AI-generated illustration for conceptual purposes and does not depict the actual 2005 production machine.)
(Note: This image is an AI-generated illustration for conceptual purposes and does not depict the actual 2005 production machine.)
Table of Contents
Advertisement
1. The Speed Limit in Machine Design
When plant managers ask engineers to increase machine throughput, the instinct is straightforward: turn up the VFD frequency or change the gear ratio. In practice, this brute-force approach quickly hits a brick wall.
Because Force equals Mass times Acceleration (F = ma), higher speeds drastically increase acceleration. This results in exponentially higher inertial forces, severe machine vibration, premature bearing fatigue, and product damage. For machines handling delicate payloads like glass, excessive acceleration is the ultimate limiting factor.
2. Sequential vs. Overlapping Motion
To safely increase throughput, you must eliminate idle time in the machine's 360-degree master cycle.
| Motion Strategy | Machine Cycle Example | Throughput & Risk Profile |
|---|---|---|
| Sequential Motion | 1. Turret indexes to position. 2. Turret comes to a complete stop. 3. Gripper moves down. 4. Part is transferred. |
Low Risk / Low Speed. Extremely safe, no chance of collision, but highly inefficient due to accumulated idle time. |
| Overlapping Motion | 1. Turret approaches final index position. 2. Simultaneously, gripper begins downward stroke. 3. Gripper enters turret slot perfectly as turret stops. |
High Speed / High Risk. Maximizes throughput without increasing acceleration, but timing errors result in mechanical crashes. |
Implementing overlapping motion meant the gripper would be entering the turret slot while the turret was still rotating. Even a 3-degree cam timing error would cause the steel gripper to violently strike the aluminum turret. I needed absolute mathematical certainty.
Advertisement
3. Building the Kinematic Simulator in Excel
Today, engineers use advanced CAD motion software to verify clearances. In 2005, I relied on Microsoft Excel and a trusty VBA programming guide. The spreadsheet was designed to calculate the position of every mechanism based on the machine’s master timing diagram.
By mapping the multi-axis motion of the turret and the gripper across the full 360-degree machine cycle, the spreadsheet utilized standard trigonometric functions to produce the exact X and Y coordinates of each moving part at any given degree of rotation. This provided the rigid mathematical foundation of the simulation.
4. Visualizing the Clearance with VBA (Video Demo)
Numbers in a spreadsheet are not enough to confidently verify a dynamic mechanical clearance. To truly visualize the overlapping motion, I wrote a Visual Basic for Applications (VBA) macro that stepped through the machine cycle one degree at a time.
For each loop of the macro, variables such as the cam angle, turret rotation, and gripper elevation were updated. Excel recalculated the geometry instantly, and the resulting coordinates were plotted on a standard 2D XY scatter chart. Watch the video below to see the actual macro animation in action:
Figure 2: By stepping through the master timing cycle via a VBA macro, the Excel XY scatter chart animates the exact mechanical clearance between the rotating turret and the descending gripper.
As the macro ran, the chart animated the machine motion in real-time. I could watch the gripper safely enter the turret slot while the turret was still rotating, confirming visually that the mechanisms cleared each other throughout the entire 360-degree cycle.
5. From Spreadsheet to 21 Years of Production
Once the Excel simulation verified the timing, we translated that exact motion data into the final machine design, defining the cam timing profiles, motion synchronization, and safe mechanical limits.
The upgraded system successfully achieved the target 1,500 UPH (a 25% throughput increase) without introducing a single damaging acceleration spike to the fragile glass payload.
The Engineering Reality: Recently, I reconnected with the project manager who oversaw that 2005 installation. He confirmed that the transfer turrets from that exact project are still operating reliably in continuous production today, more than two decades later.
Sometimes the most powerful engineering tools are not expensive software platforms. They are a solid understanding of machine kinematics, strong engineering fundamentals (like those found in Machinery's Handbook), and the creativity to build your own tools.
⚙️ Related Kinematics & Motion Control Guides
Master the fundamentals of machine design and complex motion profiles. Explore our full engineering series:
- Linkage Kinematics: Hoeken's Straight Line Mechanism Explained
- Motion Profiling: Watt's Straight Line Mechanism
- Synchronized Drive Design: Timing Belt vs. Ball Screw Drive Selection
- Positioning & Acceleration: NEMA 17 vs NEMA 23 Stepper Motor Selection
⚙️ Related Mechanical Design Guides
Master the fundamentals of machine design and reliability. Explore our full engineering series:
- Drive Physics: Overhung Load (OHL) Motor Shaft Calculations
- Transmission Dynamics: Worm Gear vs Planetary Gearbox Efficiency
- Motion Control: Conveyor Backstop & Sprag Clutch Selection
- Linear Motion: Ball Screw vs Lead Screw Actuator Selection
- System Reliability: Coupling Failure Analysis in Rotating Machinery
You simulated the kinematics. But can you defend the design on the factory floor?
The Sheet Mechanic is the field manual for the chaotic space between the CAD model and the factory floor. Learn how to manage vendors, defend your designs, and prevent downstream project failures.
About the Author:
This article is written by a senior engineering leader with over 25 years of experience in industrial automation, process optimization, and mechanical design.
This article is written by a senior engineering leader with over 25 years of experience in industrial automation, process optimization, and mechanical design.
As an Amazon Associate, I earn from qualifying purchases.
Comments