Skip to main content

Posts

Showing posts with the label Timing Diagram

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.

Excel VBA Kinematic Simulation: Overlapping Motion in High-Speed Machines

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 m...