Lug Analysis Spreadsheets

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  and is explained in our online textbook here. We have 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

Enjoy!


Comment On This Post

Your email address will not be published. Required fields are marked *

Lug Analysis Spreadsheets

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  and is explained in our online textbook here. We have 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

Enjoy!


Comment On This Post

Your email address will not be published. Required fields are marked *