Mohr's Circle

The German engineer Otto Mohr (1835-1918) developed a useful pictorial or graphical interpretation of the equations for finding the principal stresses and the maximum shearing stress at a point in a stressed member. This method, commonly called Mohr's circle, involves the construction of a circle in such a manner that the coordinates of each point on the circle represent the normal and shearing stresses on one plane through the stressed point, and the angular position of the radius to the point gives the orientation of the plane.

An excel file has been created for educational purpose. You can download and use it at your own risk. There is no guarantee for the result of calculation.

More info at http://mechanical-design-handbook.blogspot.com/

Download an Excel File

Problems in mechanical design often require the solution of nonlinear equation such as 3x³ - 20x² + 1000x + 12000 = 0

The equation shown above is a typical equation encountered in the problem of finding the maximum stress at a point. While such equations can be solved by trial and error (simply guessing value until the left-hand side of the equation is nearly zero), there exist simple, systematic ways to solve such problems. Two such methods - the Method of False Position and Newton-Raphson method.

I would like to share a very simple Excel technique to you in order to help you solve your problem easily on your desktop PC. It is called "Microsoft Excel Goal Seek" technique. Knowledge of Microsoft Excel VBA programming is not required for this technique.

An excel file has been created for educational purpose. You can download and use it at your own risk. There is no guarantee for the result of calculation.

More info at http://mechanical-design-handbook.blogspot.com/

Download an Excel File