Skip to main content

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...
Post a Comment

Stop trying to be a hero. Start being a mechanic.

Get the book →

The Sheet Mechanic on Amazon. Affiliate link, I earn from qualifying purchases.

Gauss Elimination Solver: Video Demo & Series Recap (Part 6)

Final Engineering Solver Tool Demonstration

Figure 1: The completed Gauss Elimination Solver ready for action.

Putting It All Together

We have reached the conclusion of our 6-part series on building a Linear Equation Solver in Excel.

Over the course of this tutorial, we have moved from the raw mathematical theory of Gauss Elimination to writing efficient VBA Code, and finally designing a professional User Interface that handles dynamic matrix scaling.

Advertisement

Video Demonstration

Below is a video clip demonstrating the final result. You will see how the program takes user input, automatically resizes the matrix (as discussed in Part 5), and solves for the unknowns instantly.

By following the code provided in Part 1 and Part 4, you can build this exact tool yourself.

Video 1: Live demonstration of the dynamic Excel Solver tool.

Complete Series Recap

If you missed any part of this tutorial, here is the complete roadmap to building your own solver:

Advertisement

Why build it yourself?

Downloading a black-box file teaches you nothing. By coding this tool step-by-step, you gain the skills to automate any engineering calculation in Excel, making you a more valuable engineer.

Labels:

Comments

Post a Comment

Popular posts from this blog

Dowel Pins & Locating Pins: The Basics of Fixture Design

Dowel pins are precision cylindrical pins used for accurate part alignment in assemblies. They control position, not clamping force. This guide explains tolerances, fits, sizing rules, and design best practices. Figure 1: A typical fixture setup. Notice how dowel pins (silver) provide precise location, while bolts (not shown here) provide the clamping force. In the world of Precision Engineering , the difference between a high-quality product and a scrap part often comes down to microns. While bolts hold parts together, they are terrible at positioning them. This is where Dowel Pins and Locating Pins become essential components in industrial tooling . Advertisement What is a Dowel Pin? Dowel pins are precision-ground fasteners used to secure the relative position of two parts. They are typically machined to extremely tight tolerances (often within 0.0001 inches) and are available in materials like: Hardened Steel: For high-wea...
Post a Comment
Read more about this Mechanical Design Article »

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 ...
Post a Comment
Read more about this Mechanical Design Article »

Cam Base Circle Sizing: Pressure Angle vs Undercut

Cam Base Circle Sizing: Pressure Angle vs Undercut In high-speed automation and custom machine packaging, reducing mechanism envelope size is a frequent design objective. When sizing a disc cam with a translating roller follower, shrinking the base circle radius ( R b ) appears to offer immediate space savings. However, reducing cam size does not merely scale the physical profile; it fundamentally alters the pressure angle and vector orientation of the contact force. When the follower motion law, total lift stroke, rise duration, and roller radius remain identical, a smaller base circle provides less circumferential distance along the pitch path to accommodate the prescribed lift. Consequently, the common normal tilts farther away from the direction of follower motion, thereby affecting pressure angle, transverse guide force, and pitch-curve curvature. Core Design Trade-Off: Pressure angle progressively worsens force transmission by increasing normal-force demand and transver...
Post a Comment
Read more about this Mechanical Design Article »