AA-SM-000-001-1

For our in-house analysis work we always use checked and validated methods and tools. When we create a spreadsheet tool of a validated method we save a version of it in our spreadsheet library. Some work we do for clients includes proprietary methods and data and we have to keep those to ourselves – and our clients. The public domain spreadsheet methods we have developed are made available below.

Note the use of some of these spreadsheets requires our Excel Add-in (apologies, but we use the add-in every day in our office and all the spreadsheets we create use them as a matter of course). The add-ins are free and available here.

These spreadsheets are supplied ‘as is’ with no guarantee or warranty. Like most of our fellow humans we have not yet achieved perfection but do strive to get as close as we possibly can. If you have any suggestions or find an error please contact us.

For comments or questions or to ask about our custom spreadsheet solutions, contact us

 

Name Size Details Download
Icon of AA-SM-000-000 Aluminum Material Data AA-SM-000-000 Aluminum Material Data 154.5 KB Details Download
Icon of AA-SM-000-001 Aluminum Material Data Basic Full Curves Without Data Online AA-SM-000-001 Aluminum Material Data Basic Full Curves Without Data Online 230.4 KB Details Download
Icon of AA-SM-000-002 Aluminum Material Data Plastic Bending AA-SM-000-002 Aluminum Material Data Plastic Bending 504.0 KB Details Download
Icon of AA-SM-001-000 Section Properties AA-SM-001-000 Section Properties 983.0 KB Details Download
Icon of AA-SM-001-002 Section Properties - General AA-SM-001-002 Section Properties - General 107.7 KB Details Download
Icon of AA-SM-001-003 Section Properties - Node Based AA-SM-001-003 Section Properties - Node Based 41.6 KB Details Download
Icon of AA-SM-001-004 Section Properties - General With Angles - Moment Distribution AA-SM-001-004 Section Properties - General With Angles - Moment Distribution 149.3 KB Details Download
Icon of AA-SM-001-005 Section Properties - General With Angles - Really Small Format AA-SM-001-005 Section Properties - General With Angles - Really Small Format 109.0 KB Details Download
Icon of AA-SM-001-005 Section Properties - General With Angles - Small Format AA-SM-001-005 Section Properties - General With Angles - Small Format 108.4 KB Details Download
Icon of AA-SM-001-006 Section Properties - General With Angles - Weighted Area - Moment Distribution AA-SM-001-006 Section Properties - General With Angles - Weighted Area - Moment Distribution 128.7 KB Details Download
Icon of AA-SM-001-007 Section Properties - General With Angles - Weighted Area - Moment Distribution - Small Format AA-SM-001-007 Section Properties - General With Angles - Weighted Area - Moment Distribution - Small Format 115.1 KB Details Download
Icon of AA-SM-002-001 Torsion - Regular Sections AA-SM-002-001 Torsion - Regular Sections 246.3 KB Details Download
Icon of AA-SM-002-002 Torsion - Irregular Sections AA-SM-002-002 Torsion - Irregular Sections 336.9 KB Details Download
Icon of AA-SM-003 Beam In A Socket AA-SM-003 Beam In A Socket 188.6 KB Details Download
Icon of AA-SM-004-001 Bolt Group - 1 -2D Bolt Group AA-SM-004-001 Bolt Group - 1 -2D Bolt Group 122.1 KB Details Download
Icon of AA-SM-004-003 Bolt Group - 3 -3D Bolt Group Short Version AA-SM-004-003 Bolt Group - 3 -3D Bolt Group Short Version 224.9 KB Details Download
Icon of AA-SM-004-003-01 Bolt Group - 3 -3D Bolt Group - 3 Bolts, Multiple Cases AA-SM-004-003-01 Bolt Group - 3 -3D Bolt Group - 3 Bolts, Multiple Cases 271.8 KB Details Download
Icon of AA-SM-004-004 Bolt Group - 1 -2D Bolt Group - 2 Bolts - Multiple Cases AA-SM-004-004 Bolt Group - 1 -2D Bolt Group - 2 Bolts - Multiple Cases 88.3 KB Details Download
Icon of AA-SM-004-005 Bolt Group - 1 -2D Bolt Group - 3 Bolts - Multiple Cases AA-SM-004-005 Bolt Group - 1 -2D Bolt Group - 3 Bolts - Multiple Cases 103.3 KB Details Download
Icon of AA-SM-004-006 Bolt Group - 1 -2D Bolt Group - 4 Bolts - Multiple Cases AA-SM-004-006 Bolt Group - 1 -2D Bolt Group - 4 Bolts - Multiple Cases 111.8 KB Details Download
Icon of AA-SM-005-001 Bolted Connections - 1- Combined Shear And Tension AA-SM-005-001 Bolted Connections - 1- Combined Shear And Tension 107.3 KB Details Download
Icon of AA-SM-005-002 Bolted Connections - 2- Bolt Bending AA-SM-005-002 Bolted Connections - 2- Bolt Bending 446.2 KB Details Download
Icon of AA-SM-005-003 Bolted Connections - 3- Effects On Plate AA-SM-005-003 Bolted Connections - 3- Effects On Plate 590.2 KB Details Download
Icon of AA-SM-005-004 Bolted Connections - 4- Bolt Thread Pull Through AA-SM-005-004 Bolted Connections - 4- Bolt Thread Pull Through 335.6 KB Details Download
Icon of AA-SM-005-005 Bolted Connections - 5- Bending Of Bolt And Bushing AA-SM-005-005 Bolted Connections - 5- Bending Of Bolt And Bushing 391.3 KB Details Download
Icon of AA-SM-005-006 Bolted Connections - 6 - Bolt Pre-Load AA-SM-005-006 Bolted Connections - 6 - Bolt Pre-Load 603.2 KB Details Download
Icon of AA-SM-006 Buckling Of Curved Plates AA-SM-006 Buckling Of Curved Plates 971.3 KB Details Download
Icon of AA-SM-007 Buckling Of Flat Plates AA-SM-007 Buckling Of Flat Plates 308.7 KB Details Download
Icon of AA-SM-007-001 Collapse Of Shear Web With Holes AA-SM-007-001 Collapse Of Shear Web With Holes 374.7 KB Details Download
Icon of AA-SM-007-002 Shear Buckling Coefficients AA-SM-007-002 Shear Buckling Coefficients 138.4 KB Details Download
Icon of AA-SM-007-003 Flange Buckling Coefficients AA-SM-007-003 Flange Buckling Coefficients 136.2 KB Details Download
Icon of AA-SM-008 Contact Stresses AA-SM-008 Contact Stresses 114.1 KB Details Download
Icon of AA-SM-009-003 Lugs Under Oblique Loading - Compact AA-SM-009-003 Lugs Under Oblique Loading - Compact 251.5 KB Details Download
Icon of AA-SM-010 Stress Due To Interference Fit Bushing Installation AA-SM-010 Stress Due To Interference Fit Bushing Installation 97.2 KB Details Download
Icon of AA-SM-011 Mohr Circle AA-SM-011 Mohr Circle 139.2 KB Details Download
Icon of AA-SM-012 Section Crippling - Needham Method AA-SM-012 Section Crippling - Needham Method 192.2 KB Details Download
Icon of AA-SM-017 Pulley & Cable Loads - Small Format AA-SM-017 Pulley & Cable Loads - Small Format 113.7 KB Details Download
Icon of AA-SM-018-001 Simple Euler Column Analysis AA-SM-018-001 Simple Euler Column Analysis 215.4 KB Details Download
Icon of AA-SM-018-002 Beam Column Analysis AA-SM-018-002 Beam Column Analysis 172.2 KB Details Download
Icon of AA-SM-019 Bending AA-SM-019 Bending 287.8 KB Details Download
Icon of AA-SM-024-001 Shear In Multi-celled Sections Due To Shear And Torsion - Small Format) AA-SM-024-001 Shear In Multi-celled Sections Due To Shear And Torsion - Small Format) 399.6 KB Details Download
Icon of AA-SM-024-002 Shear In Multi-celled Sections Due To Shear And Torsion - Mod For 2 Cells AA-SM-024-002 Shear In Multi-celled Sections Due To Shear And Torsion - Mod For 2 Cells 110.0 KB Details Download
Icon of AA-SM-025-001 Cozzone Theory Of Plastic Bending AA-SM-025-001 Cozzone Theory Of Plastic Bending 454.5 KB Details Download
Icon of AA-SM-025-002 Shape Factors Of Complex Shapes AA-SM-025-002 Shape Factors Of Complex Shapes 477.8 KB Details Download
Icon of AA-SM-026-001 Beam Analysis - Simple Beams - Roark AA-SM-026-001 Beam Analysis - Simple Beams - Roark 522.1 KB Details Download
Icon of AA-SM-026-002 Beam Analysis - Single Span No Moments, Single Case AA-SM-026-002 Beam Analysis - Single Span No Moments, Single Case 154.4 KB Details Download
Icon of AA-SM-026-003 Beam Analysis - Varying Distributed Load And Axial Compresison AA-SM-026-003 Beam Analysis - Varying Distributed Load And Axial Compresison 258.2 KB Details Download
Icon of AA-SM-026-011 Beam Analysis - Double Span, Moments AA-SM-026-011 Beam Analysis - Double Span, Moments 288.1 KB Details Download
Icon of AA-SM-026-021 Beam Analysis - Triple Span No Moments, No UDL AA-SM-026-021 Beam Analysis - Triple Span No Moments, No UDL 386.2 KB Details Download
Icon of AA-SM-027-002 Tension Clips AA-SM-027-002 Tension Clips 250.8 KB Details Download
Icon of AA-SM-028 Fastener Flexibility AA-SM-028 Fastener Flexibility 220.2 KB Details Download
Icon of AA-SM-030 Neuber Elastic Stress Correction AA-SM-030 Neuber Elastic Stress Correction 123.7 KB Details Download
Icon of AA-SM-033 Bathtub Fitting - Niu Method AA-SM-033 Bathtub Fitting - Niu Method 437.0 KB Details Download
Icon of AA-SM-034 Angle Fitting - Niu Method AA-SM-034 Angle Fitting - Niu Method 392.6 KB Details Download
Icon of AA-SM-040 Stress Analysis - 3D Von Mises Stress AA-SM-040 Stress Analysis - 3D Von Mises Stress 95.8 KB Details Download
Icon of AA-SM-041-001 Stress Analysis - Von Mises Stress Rectangular Section No Torsion AA-SM-041-001 Stress Analysis - Von Mises Stress Rectangular Section No Torsion 396.5 KB Details Download
Icon of AA-SM-041-002 Stress Analysis - Von Mises Stress Rectangular Section Incl Torsion AA-SM-041-002 Stress Analysis - Von Mises Stress Rectangular Section Incl Torsion 154.3 KB Details Download
Icon of AA-SM-101-001 Laminate Physical Properties AA-SM-101-001 Laminate Physical Properties 175.9 KB Details Download
Icon of AA-SM-101-002 Laminate Principal Strain Calculation AA-SM-101-002 Laminate Principal Strain Calculation 139.3 KB Details Download
Icon of AA-SM-101-003 Laminate Principal Strain Calculation - Compact AA-SM-101-003 Laminate Principal Strain Calculation - Compact 186.5 KB Details Download
Icon of AA-SM-101-004 Laminate Strain Envelope AA-SM-101-004 Laminate Strain Envelope 157.7 KB Details Download
Icon of AA-SM-101-005 Laminate Strain Analysis - Envelope And MS AA-SM-101-005 Laminate Strain Analysis - Envelope And MS 161.8 KB Details Download
Icon of AA-SM-101-006 Laminate Strain Analysis - Envelope And MS - Compact AA-SM-101-006 Laminate Strain Analysis - Envelope And MS - Compact 139.6 KB Details Download
Icon of AA-SM-101-100 Composites - Laminate Failure Criteria - US Units AA-SM-101-100 Composites - Laminate Failure Criteria - US Units 339.8 KB Details Download
Icon of AA-SM-102 Cored Laminate Basic Stiffness Properties AA-SM-102 Cored Laminate Basic Stiffness Properties 190.1 KB Details Download
Icon of AA-SM-103-001 Composites - Buckling Of Foam Core Sandwich Panels - Simple AA-SM-103-001 Composites - Buckling Of Foam Core Sandwich Panels - Simple 269.8 KB Details Download
Icon of AA-SM-106 Composites - Sandwich Cylinders AA-SM-106 Composites - Sandwich Cylinders 709.6 KB Details Download
Icon of AA-SM-107 Composites - Sandwich Panels Loaded At An Insert AA-SM-107 Composites - Sandwich Panels Loaded At An Insert 574.5 KB Details Download
Icon of AA-SM-107 Composites - Sandwich Panels Loaded At An Insert AA-SM-107 Composites - Sandwich Panels Loaded At An Insert 396.2 KB Details Download
Icon of AA-SM-111-001 Composites - Wrinklings Of Facings In Sandwich Panels - Compact AA-SM-111-001 Composites - Wrinklings Of Facings In Sandwich Panels - Compact 119.2 KB Details Download
Icon of AA-SM-113 Composites - Sandwich Panels Under Pressure AA-SM-113 Composites - Sandwich Panels Under Pressure 550.9 KB Details Download
Icon of AA-SM-130 Composites - Different Adhesive Joint Methods AA-SM-130 Composites - Different Adhesive Joint Methods 791.1 KB Details Download
Icon of AA-SM-200 Tools - ATA Chapters Detailed Breakdown AA-SM-200 Tools - ATA Chapters Detailed Breakdown 153.5 KB Details Download
Icon of AA-SM-201 Tools - Linear Simultaneous Equations AA-SM-201 Tools - Linear Simultaneous Equations 215.9 KB Details Download
Icon of AA-SM-202 Tools - Unit Conversion AA-SM-202 Tools - Unit Conversion 215.4 KB Details Download
Icon of AA-SM-203 - Tools - Analysis Character Set AA-SM-203 - Tools - Analysis Character Set 73.5 KB Details Download
Icon of AA-SM-205-001 Tools - Joints - Fastener Terms And Torques AA-SM-205-001 Tools - Joints - Fastener Terms And Torques 490.2 KB Details Download
Icon of AA-SM-205-002 Tools - Joints - Bushings AA-SM-205-002 Tools - Joints - Bushings 401.8 KB Details Download
Icon of AA-SM-205-003 Tools - Joints - Rivets AA-SM-205-003 Tools - Joints - Rivets 228.8 KB Details Download
Icon of AA-SM-205-004 Tools - Joints - Bolts AA-SM-205-004 Tools - Joints - Bolts 137.7 KB Details Download
Icon of AA-SM-207 Tools - Simple Weight And Balance AA-SM-207 Tools - Simple Weight And Balance 213.7 KB Details Download
Icon of AA-SM-209 Tools - 2D Resolving Of Forces AA-SM-209 Tools - 2D Resolving Of Forces 216.3 KB Details Download
Icon of AA-SM-210 Tools - Quadrilateral Analysis AA-SM-210 Tools - Quadrilateral Analysis 227.6 KB Details Download
Icon of AA-SM-213 Tools - General Interaction Curve AA-SM-213 Tools - General Interaction Curve 105.6 KB Details Download
Icon of AA-SM-214 Tools - Simple Two Member Truss Framework AA-SM-214 Tools - Simple Two Member Truss Framework 246.9 KB Details Download
Icon of AA-SM-215 Tools - Translation Between Diferent 3D Coordinate Systems AA-SM-215 Tools - Translation Between Diferent 3D Coordinate Systems 237.6 KB Details Download
Icon of AA-SM-218 Tools - Simple Principal Stress Calculation AA-SM-218 Tools - Simple Principal Stress Calculation 253.4 KB Details Download
Icon of AA-SM-219 Tools - Various Mass Balances - Linear And Rotational AA-SM-219 Tools - Various Mass Balances - Linear And Rotational 395.3 KB Details Download
Icon of AA-SM-220 Tools - 3D Surface Plots AA-SM-220 Tools - 3D Surface Plots 310.2 KB Details Download
Icon of AA-SM-221 Tools - Wing In Ground Effect Performance AA-SM-221 Tools - Wing In Ground Effect Performance 1.2 MB Details Download
Icon of AA-SM-222 Tools - Intersection Of Two Circles AA-SM-222 Tools - Intersection Of Two Circles 127.9 KB Details Download
Icon of AA-SM-223 Tools - Two Bellcrank Kinematic System AA-SM-223 Tools - Two Bellcrank Kinematic System 198.6 KB Details Download
Icon of AA-SM-224 Tools - Intersection Of Line And A Circle AA-SM-224 Tools - Intersection Of Line And A Circle 112.2 KB Details Download
Icon of AA-SM-230 Tools - Quadratic Curve Fit AA-SM-230 Tools - Quadratic Curve Fit 111.2 KB Details Download
Icon of AA-SM-231 Tools - Cubic Curve Fit AA-SM-231 Tools - Cubic Curve Fit 112.1 KB Details Download
Icon of AA-SM-232 Tools - Fourth Order Curve Fit AA-SM-232 Tools - Fourth Order Curve Fit 112.5 KB Details Download
Icon of AA-SM-233 Tools - Fifth Order Curve Fit AA-SM-233 Tools - Fifth Order Curve Fit 118.0 KB Details Download
Icon of AA-SM-501 Loads -  Simple Drag Loads Calculation AA-SM-501 Loads - Simple Drag Loads Calculation 216.9 KB Details Download
Icon of AA-SM-502 Loads - Part 23 Normal Category Aircraft Gust Load Factors AA-SM-502 Loads - Part 23 Normal Category Aircraft Gust Load Factors 219.3 KB Details Download
Icon of AA-SM-503 Loads - Simple Landing Gear Loads AA-SM-503 Loads - Simple Landing Gear Loads 272.2 KB Details Download
Icon of AA-SM-504 Loads - Modification To Wing Lift Gradient For Compressibility AA-SM-504 Loads - Modification To Wing Lift Gradient For Compressibility 241.4 KB Details Download
Icon of AA-SM-506 Loads - Part 23 Propeller Powerplant Loads Derivation AA-SM-506 Loads - Part 23 Propeller Powerplant Loads Derivation 388.8 KB Details Download
Icon of AA-SM-507 Loads - Part 23 Seat Attachment Loads AA-SM-507 Loads - Part 23 Seat Attachment Loads 216.7 KB Details Download
Icon of AA-SM-99-001 Equations 2003 AA-SM-99-001 Equations 2003 41.5 KB Details Download