Microsoft Excel VBA - Mohr's Circle for Plane Stress
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.
Normal stresses are plotted as horizontal coordinates, with tensile stresses (positive) plotted to the right of the origin and compressive stresses (negative) plotted to the left. Shearing stresses are plotted as vertical coordinates, with those tending to produce a clockwise rotation of the stress element plotted above the s axis, and those tending to produce a counterclockwise rotation of the stress element plotted below the s axis.
The results obtained from Mohr's circle are identical with the equation derived from the free-body diagram. Consequently, Mohr's circle provides an extremely useful aid in the solution for, and visualization of, the stresses on various planes through a point in a stressed body in terms of the stresses on two mutually perpendicular planes through the point. Although Mohr's circle can be drawn to scale and used to obtain values of stresses and angles by direct measurements on the figure, it is probably more useful as a pictorial aid to the analyst who is performing analytical determinations of stresses and their directions at the point.
Useful information about Mohr's Circle:
DOWNLOAD Mohr's Circle Excel file for FREE
Normal stresses are plotted as horizontal coordinates, with tensile stresses (positive) plotted to the right of the origin and compressive stresses (negative) plotted to the left. Shearing stresses are plotted as vertical coordinates, with those tending to produce a clockwise rotation of the stress element plotted above the s axis, and those tending to produce a counterclockwise rotation of the stress element plotted below the s axis.
The results obtained from Mohr's circle are identical with the equation derived from the free-body diagram. Consequently, Mohr's circle provides an extremely useful aid in the solution for, and visualization of, the stresses on various planes through a point in a stressed body in terms of the stresses on two mutually perpendicular planes through the point. Although Mohr's circle can be drawn to scale and used to obtain values of stresses and angles by direct measurements on the figure, it is probably more useful as a pictorial aid to the analyst who is performing analytical determinations of stresses and their directions at the point.
Useful information about Mohr's Circle:
- http://en.wikiversity.org/wiki/Mohr%27s_circle
- http://akedynamic.blogspot.com/2015/02/how-to-draw-circle-in-excel.html
DOWNLOAD Mohr's Circle Excel file for FREE
Comments
You have to "Enable macros" when opening the excel file.
Please note that if you don't follow these steps, you may not be able to run the macro.
1) Tools > Macro > Security
2) Security Level tab > Medium. > OK
3) Close Microsoft Excel
4) Open the file again and you will see the pop-up
5) Select Enable Macros
Note: step 1 -3, you have to do only once, later you can skip them
I hope this helps.
Ake
is it possible for you to include a square diagram with normal stress, shear stress and angels?
i get really confused when relating angle and rotation on square TO morh's circle's angles and rotation.
could you contact me if you can be bothered? slxia1@student.monash.edu.au
j.mayer@my.und.edu
I'm a french student and I would like to have this program on excel for a project in mechanical engineering.
Please can someone send me this program.
Thanks
I wish to download a copy of your Mohr's Circle program for academic purpose. I cannot download it through the link provided. Thank you. Can you post another link please.