Mechanical Design Handbook is an online reference for mechanical design engineers. Besides the general topics related to mechanical component design, we provide the techniques with calculation sheets made with Microsoft Excel VBA. With help of Microsoft Excel VBA, we can reduce the repetitive calculation processes. We also show you simple techniques to use Microsoft Excel VBA and Solid Edge 3D CAD software to do motion simulation without using simulation module of Solid Edge. The graphing technique to make motion simulation can be found as well. The followings are the list of Mechanical Engineering computation using Microsoft Excel VBA to help reduce repetitive task as well as dynamic simulation using Unigraphics (UG) motion in mechanical engineering design:



Sponsored links

Wednesday, April 30, 2008

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.


video

You can download Mohr's Circle Excel file for free.


DOWNLOAD Mohr's Circle Excel file for FREE

2 comments:

dbf064 said...

How do i get it to show mohr's circle plotted in the negative x direction? The graph is not shown fully in the diagram.

May 8, 2009 9:28 AM
Ake Blogger said...

Hi

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

May 8, 2009 10:29 PM

Post a Comment

Subscribe to: Post Comments (Atom)

Mechanical Design Articles

My Blog List