Lug Analysis Spreadsheets

July 11, 2016

We have updated the lug methods for our engineering textbook and one of the best explained and best laid out classic lug analysis comes from the US Airforce Stress Manual, AFFDL-TR-69-42. We has used this as the basis for our lug analysis spreadsheets. All of the curves are fully digitized. There is a spreadsheet for each of the individual failure modes :

AA-SM-009-001 Lug Analysis – Shear Bearing Strength.xlsx

AA-SM-009-002 Lug Analysis – Axial Strength.xlsx

AA-SM-009-003 Lug Analysis – Transverse Strength.xlsx

and there is a fully automated sheet that does all of the calculations and calculates the interaction:

AA-SM-009-005 Lug Analysis – Compact Oblique.xlsx

There is also a spreadsheet that calculates the complex pin bending effect.

AA-SM-009-004 Lug Analysis – Pin Bending.xlsx


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.


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!