New Stress Analysis Spreadsheets – Von Mises and Principal Stresses

October 10, 2016

I have been working on the new sections for our free engineering textbook and over the weekend I began writing the chapter for stress tensors (principal stresses, Von-Mises) and failure envelopes (Maximum principal Stress, Von Mises, Tresca).

As a report writing stress engineer you seldom get the chance to stop and consider how these measures of stress came about – and for those of us a significant distance from our college years the reason for using these methods and how they came about can blur somewhat….

This weekend was a very useful refresher for me and I updated and created some new spreadsheets to accompany the new sections for the book. As always, we share those with you.

This set is not yet complete – I have yet to create and upload the Tresca envelope, – but it is Monday morning and a good time to share what we have done.

These spreadsheets fit into the AA-SM-041 series that also include the calculation of shear stress distributions over common cross sections.

Let us know what you think and if you spot any errors be sure to let us know so we can share the corrected versions.

AA-SM-041-000: Stress Analysis – 2D Principal Stresses
AA-SM-041-001 Stress Analysis   3D Principal Stresses
AA-SM-041-020 Stress Analysis – 2D Von Mises Stress
AA-SM-041-021 Stress Analysis – 3D Von Mises Stress
AA-SM-041-025 Stress Analysis – Von Mises Stress Rectangular section, No Torsion
AA-SM-041-026 Stress Analysis   Von Mises Stress Rectangular section, Incl. Torsion
AA-SM-041-027 Stress Analysis – Von Mises Stress Circular Tube section, Incl. Torsion
AA-SM-041-030 Stress Analysis – Mohrs Circle

Have A Comment On This Article? Post It Here.

Comments are moderated and will not be published until approved. Your email address will be kept confidential. Please review our Comment Policy before posting your comment.


Next Post -

Microsoft Excel Spreadsheets

FREE ANALYSIS SPREADSHEETS 3 Over the last 10 years we have developed hundreds of spreadsheet tools to help us with our structural analysis work. We have made these available through the Abbott Aerospace web site and the XL Viking project. We have now brought them into the technical library. They have been updated, improved and the collection has been expanded to cover more analysis methods than ever before.

The XL-Viking Add-In for Excel

XL-Viking 2 We created the XL-Viking Excel add-in to satisfy our own need to make Excel a better engineering tool. XL-Viking shows your Excel Formula in a way that makes sense and brings essential new functionality to Microsoft Excel by providing an additional user interface and easy to use functions.

The Indispensable Tool For Engineers, Mathematicians, Scientists, Accountants and Teaching Professionals!


Technical Papers & Reports

This is our collection of public domain references. All of the material we make available has been placed in the public domain by the authors/owners. If you believe this is not the case and any of the library material is not in the public domain please let us know. If you have any reference material that you would like to see included in the library we would love to hear from you.

Market Analysis and Market Information

Our newest addition to the library is an on-going series of articles on the aircraft and aerospace market. These are part quantitative and part qualitative and introduce a new aspect to the competencies within Abbott Aerospace.