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...
In the previous post , we talked about several root finding techniques. In this post, we're going to see how we can use Microsoft Excel VBA to find the roots using the Newton-Raphson Method. Advertisement Figure 1: The Newton-Raphson method rapidly converges on a solution using the function's derivative. The Logic As we know, the Newton-Raphson Method is the most widely used of all root-locating formulas. It uses the slope ( first derivative ) of the function to find the root. That means, in the VBA code, we have to calculate the first derivative of the function. We already discussed how to find the first derivative using numerical methods , and we will incorporate that logic here. Figure 2: Geometric interpretation: The tangent line points to the next approximate root. The Iterative Formula: The method uses the Taylor series to approximate the next position (x N ) based on the curre...