Spreadsheets

All of the spreadsheets below are provided 'as is' and while we have made every effort to ensure accuracy we give no warranty or guarantee that they are reliable or correct. If you find an error or would like to send us a comment please send a mail to spreadsheets@abbottaerospace.com.
 AA-Add ins
Ċ AA-SM-99-001 Documentation.pdf
View Download
Documentation for Macro Display in Excel.  1414k v. 5 Apr 24, 2012, 5:13 AM Richard Abbott
ċ
AA-SM-99-001 Equations.xlam
Download
Macro for display of Equations for Report writing in Excel 2007.   43k v. 7 Apr 24, 2012, 5:12 AM Richard Abbott
 AA-SM-000 Metal Stress Analysis
Ĉ AA-SM-000-001 Aluminum Material Data Basic Full Curves without Data Online.xlsx
View Download
  169k v. 2 Mar 26, 2013, 4:09 AM Richard Abbott
Ĉ AA-SM-000AluminumMaterialData.xls
View Download
Comprehensive aluminum alloy static strength and plastic buckling digitization workbook in report format, based on military handbook 5F data. Includes visual basic routines.    602k v. 6 May 17, 2009, 8:36 AM Richard Abbott
Ĉ AA-SM-001-000 Section Properties.xlsx
View Download
Section (and mass) properties of regular shapes.  929k v. 2 Feb 6, 2013, 3:21 AM Richard Abbott
Ĉ AA-SM-001-001 Section Properties - Seat Tracks.xlsx
View Download
Section properties of common seat track sections  65k v. 2 Feb 6, 2013, 3:21 AM Richard Abbott
Ĉ AA-SM-001-002 Section Properties - General.xlsx
View Download
Compound section properties using rectangular components.  44k v. 2 Feb 6, 2013, 3:21 AM Richard Abbott
Ĉ AA-SM-001-003 Section Properties - Node based.xlsx
View Download
Node based section properties.  42k v. 2 Feb 6, 2013, 3:22 AM Richard Abbott
Ĉ AA-SM-001-004 Section Properties - General with Angles - moment distribution.xlsx
View Download
Section properties of compound rectangular sections with bending moment disribution  58k v. 2 Feb 6, 2013, 3:23 AM Richard Abbott
Ĉ AA-SM-001-005 Section Properties - General with Angles - Small Format.xlsx
View Download
Section properties of compound rectangular sections at angles.  45k v. 2 Feb 6, 2013, 3:23 AM Richard Abbott
Ĉ AA-SM-001-006 Section Properties - General with Angles - weighted area - moment distribution.xlsx
View Download
Section properties of compound rectangular sections with weighted areas (stiffness) and moment distribution.  61k v. 2 Feb 6, 2013, 3:24 AM Richard Abbott
Ĉ AA-SM-001-007 Section Properties - General with Angles - weighted area - moment distribution - small format.xlsx
View Download
  52k v. 2 Feb 4, 2013, 5:36 AM Richard Abbott
Ĉ AA-SM-002-001 Torsion - Regular Sections.xlsx
View Download
Self Explanatory  184k v. 2 Feb 6, 2013, 3:38 AM Richard Abbott
Ĉ AA-SM-002-002 Torsion - Irregular Sections.xlsx
View Download
Torsion of irregular sections including general solution for C-Section.  137k v. 2 Feb 6, 2013, 3:39 AM Richard Abbott
Ĉ AA-SM-003 Beam in a Socket.xlsx
View Download
Public domain live math version of a well known Beam in a socket method.  196k v. 4 Oct 25, 2013, 3:32 AM Richard Abbott
Ĉ AA-SM-004-001 Bolt Group - 1 -2D Bolt Group.xlsx
View Download
2D bolt group rigid body analysis.  62k v. 2 Feb 6, 2013, 3:39 AM Richard Abbott
Ĉ AA-SM-004-002 Bolt Group - 2 -3D Bolt Group.xls
View Download
3D bolt group rigid body analysis.  523k v. 2 Feb 6, 2013, 3:40 AM Richard Abbott
Ĉ AA-SM-004-002 Bolt Group - 3D Bolt Group Multiple Cases.xlsx
View Download
3D bolt group rigid body analysis for multiple load cases.  251k v. 2 Feb 6, 2013, 3:42 AM Richard Abbott
Ĉ AA-SM-004-003-01 Bolt Group - 3 -3D Bolt Group - 3 Bolts, multiple cases.xlsx
View Download
3D bolt group rigid body analysis, 3 Bolts, multiple cases.  187k v. 2 Feb 6, 2013, 3:43 AM Richard Abbott
Ĉ AA-SM-004-003 Bolt Group - 3 -3D Bolt Group Short Version.xlsx
View Download
3D bolt group, rigid body analysis, small format.  154k v. 2 Feb 6, 2013, 3:43 AM Richard Abbott
Ĉ AA-SM-004-004 Bolt Group - 1 -2D Bolt Group - 2 Bolts - Multiple cases.xls
View Download
2D bolt group rigid body analysis, 2 Bolts, multiple cases.  70k v. 2 Feb 6, 2013, 3:44 AM Richard Abbott
Ĉ AA-SM-004-005 Bolt Group - 1 -2D Bolt Group - 3 bolts - Multiple Cases.xlsx
View Download
2D bolt group rigid body analysis, 3 Bolts, multiple cases.  44k v. 2 Feb 6, 2013, 3:44 AM Richard Abbott
Ĉ AA-SM-004-006 Bolt Group - 1 -2D Bolt Group - 4 bolts - Multiple Cases.xlsx
View Download
2D bolt group rigid body analysis, 4 Bolts, multiple cases.  55k v. 2 Feb 6, 2013, 3:44 AM Richard Abbott
Ĉ AA-SM-005BoltedConnections-1-CombinedShearAndTension.xls
View Download
Analysis of fastener shank under combined loads   274k v. 5 Apr 23, 2009, 2:40 PM Richard Abbott
Ĉ AA-SM-005BoltedConnections-2-BoltBending.xls
View Download
Bending of bolt and relief of bolt bending    423k v. 5 Apr 23, 2009, 2:40 PM Richard Abbott
Ĉ AA-SM-005BoltedConnections-3-Effectsonplate.xls
View Download
Bearing, Shear out, Net tension failure of a joint plate   556k v. 6 Apr 23, 2009, 2:41 PM Richard Abbott
Ĉ AA-SM-005BoltedConnections-4-BoltThreadPullThrough.xls
View Download
Shear out analysis of bolt threads in tension    298k v. 5 Apr 23, 2009, 2:42 PM Richard Abbott
Ĉ AA-SM-005BoltedConnections-5-BendingofBoltandBushing.xls
View Download
Combined bending of bolt and bushing, used to relieve bolt bending effects    398k v. 6 Apr 30, 2009, 6:45 AM Richard Abbott
Ĉ AA-SM-006BucklingofCurvedPlates.xls
View Download
Bruhn method for separate and combined compression and shear buckling of curved plates   882k v. 5 Apr 23, 2009, 2:44 PM Richard Abbott
Ĉ AA-SM-007-002 Shear Buckling Coefficients.xlsx
View Download
Digitization of Bruhn Curves  80k v. 2 Feb 6, 2013, 3:45 AM Richard Abbott
Ĉ AA-SM-007-003 Flange Buckling Coefficients.xlsx
View Download
Digitization of Bruhn Curves  76k v. 2 Feb 6, 2013, 3:45 AM Richard Abbott
Ĉ AA-SM-007BucklingofFlatPlates.xls
View Download
Bruhn method for separate and combined shear, compression and bending buckling of flat plates      284k v. 7 May 15, 2009, 4:40 AM Richard Abbott
Ĉ AA-SM-008ContactStresses.xls
View Download
Contact stress analysis of cylinder on flat plate     144k v. 6 Apr 30, 2009, 6:46 AM Richard Abbott
Ĉ AA-SM-009LugsUnderObliqueLoading.xls
View Download
Self Explanatory    1738k v. 8 Apr 30, 2009, 6:47 AM Richard Abbott
Ĉ AA-SM-010StressDuetoInterferencefitbushinginstallation.xls
View Download
Failure criteria for lug and bushing due to interference fit bushing   77k v. 7 Apr 23, 2009, 2:47 PM Richard Abbott
Ĉ AA-SM-011MohrCircle.xls
View Download
Depiction of principal stresses and max/min shear stress as Mohrs circle    137k v. 5 Apr 23, 2009, 2:47 PM Richard Abbott
Ĉ AA-SM-012SectionCrippling-NeedhamMethod.xls
View Download
Classic section crippling analysis    217k v. 5 Apr 23, 2009, 2:48 PM Richard Abbott
Ĉ AA-SM-013PressureLoadedFlatIsotropicPanel.xls
View Download
Small deflection analysis of different shapes of plates under different types of pressure loading    674k v. 5 Apr 23, 2009, 2:49 PM Richard Abbott
Ĉ AA-SM-014PressureVessels.xls
View Download
Pressure vessel analysis including simple unreinforced analysis and stiffened pressure vessel analysis    941k v. 5 Apr 23, 2009, 2:50 PM Richard Abbott
Ĉ AA-SM-015SteelPlasticBending.xls
View Download
Plastic bending analysis specific to steel cross sections     256k v. 6 Apr 30, 2009, 6:47 AM Richard Abbott
Ĉ AA-SM-016 Steel Round Tubes.xls
View Download
  3110k v. 2 Nov 12, 2013, 4:37 PM Richard Abbott
Ĉ AA-SM-017Pulley&CableLoads.xls
View Download
Analysis for control system cables and pulleys    480k v. 5 Apr 23, 2009, 2:55 PM Richard Abbott
Ĉ AA-SM-019 Bending.xlsx
View Download
  567k v. 3 May 15, 2012, 4:06 AM Richard Abbott
Ĉ AA-SM-024ShearinMulti-celledsectionsduetoshearandtorsion.xls
View Download
Classic shear and torsion distribution onto a multi-celled cross-section    394k v. 6 Jul 11, 2013, 12:09 PM Richard Abbott
Ĉ AA-SM-025-001 Cozzone Theory of Plastic Bending.xlsx
View Download
Calculation of plastic bending allowable using Fty, Ftu and shape factor.  335k v. 2 Feb 6, 2013, 3:48 AM Richard Abbott
Ĉ AA-SM-025-002 Shape Factors of Complex Shapes.xlsx
View Download
Self Explanatory  367k v. 2 Feb 6, 2013, 3:48 AM Richard Abbott
Ĉ AA-SM-026-000 Beam Analysis.xls
View Download
General 2D beam analysis for multiple beam configurations.  9350k v. 2 Feb 6, 2013, 3:48 AM Richard Abbott
Ĉ AA-SM-026-001 Beam Analysis - Simple Beams - Roark .xlsx
View Download
Roark 7th Edition beam analysis.  448k v. 2 Feb 6, 2013, 3:49 AM Richard Abbott
Ĉ AA-SM-026-002 Beam Analysis - single span no moments, single case .xlsx
View Download
Specific beam analysis - Self Explanatory  91k v. 2 Feb 6, 2013, 3:50 AM Richard Abbott
Ĉ AA-SM-026-003 Beam Analysis - Varying Distributed Load and Axial Compresison .xlsx
View Download
Specific beam analysis - Self Explanatory  190k v. 2 Feb 6, 2013, 3:50 AM Richard Abbott
Ĉ AA-SM-026-011 Beam analysis - double span, Moments .xlsx
View Download
Specific beam analysis - Self Explanatory  236k v. 2 Feb 6, 2013, 3:50 AM Richard Abbott
Ĉ AA-SM-026-021 Beam Analysis - triple span no moments, No UDL .xlsx
View Download
Specific beam analysis - Self Explanatory  326k v. 2 Feb 6, 2013, 3:50 AM Richard Abbott
Ĉ AA-SM-026-022 Beam analysis - triple span no moments, UDL .xlsx
View Download
Specific beam analysis - Self Explanatory  340k v. 2 Feb 6, 2013, 3:50 AM Richard Abbott
Ĉ AA-SM-026-030 Beam analysis - Single span, partial uniform load .xlsx
View Download
Specific beam analysis - Self Explanatory  230k v. 2 Feb 6, 2013, 3:50 AM Richard Abbott
Ĉ AA-SM-027-002 Tension Clips.xlsx
View Download
Tension Clips - Niu Method.  309k v. 4 Oct 31, 2013, 5:03 PM Richard Abbott
Ĉ AA-SM-028FastenerFlexibility.xls
View Download
Various methods for deriving stiffnesses for bolted connections     244k v. 6 Apr 30, 2009, 6:50 AM Richard Abbott
Ĉ AA-SM-029GeneralInteractionCurve.xls
View Download
Similar to AA-SM-005 but allows general terms to cover any two dimensional interaction  275k v. 3 May 14, 2009, 7:18 AM Richard Abbott
Ĉ AA-SM-030NeuberElasticStressCorrection.xls
View Download
Correction to (reduction) elastic stress levels using strain energy approach.  161k v. 2 May 15, 2009, 10:53 AM Richard Abbott
Ĉ AA-SM-040 Stress Analysis - 3D Von Mises Stress.xlsx
View Download
3D Von mises stress Calculation  93k v. 2 Feb 2, 2014, 7:26 AM Richard Abbott
Ĉ AA-SM-041-001 Stress Analysis - Von Mises Stress Rectangular section No Torsion.xlsx
View Download
Von mises stress distribution over a rectangular cross section excluding torsion.  382k v. 2 Feb 2, 2014, 7:26 AM Richard Abbott
Ĉ AA-SM-041-002 Stress Analysis - Von Mises Stress Rectangular section Incl Torsion.xlsx
View Download
Von mises stress distribution over a rectangular cross section including torsion  154k v. 2 Feb 2, 2014, 7:27 AM Richard Abbott
 AA-SM-100 Composite Stress Analysis
Ĉ AA-SM-100Composites-TypicalDesignValues.xls
View Download
Typical design values for common composite materials     169k v. 6 Aug 2, 2010, 4:18 AM Richard Abbott
Ĉ AA-SM-101-1 Composites - laminate failure criteria - US Units.xlsx
View Download
Classical Laminate Analysis covering Laminate Strain and individual ply failure criteria  299k v. 3 Mar 20, 2013, 7:45 AM Richard Abbott
Ĉ AA-SM-103Composites-BucklingofFoamCoreSandwichPanels.xls
View Download
Methods for buckling of foam core sandwich panels  1990k v. 3 Apr 30, 2009, 6:21 AM Richard Abbott
Ĉ AA-SM-104Composites-IntracellBucklingofHoneycombSandwichPanels.xls
View Download
Self Explanatory  504k v. 4 Apr 30, 2009, 6:24 AM Richard Abbott
Ĉ AA-SM-106Composites-SandwichCylinders.xls
View Download
Composite Cylinder analysis for equal facings with isotropic cores  533k v. 3 Apr 30, 2009, 6:23 AM Richard Abbott
Ĉ AA-SM-107Composites-SandwichPanelsLoadedatanInsert.xls
View Download
Self Explanatory   527k v. 5 Jan 27, 2011, 4:45 AM Richard Abbott
Ĉ AA-SM-108Composites-ShearCrimpingofSandwichPanels.xls
View Download
Self Explanatory  141k v. 3 Apr 30, 2009, 6:24 AM Richard Abbott
Ĉ AA-SM-111Composites-WrinklingofFacingsinSandwichPanels.xls
View Download
Self Explanatory   617k v. 5 May 4, 2009, 11:15 AM Richard Abbott
Ĉ AA-SM-112Composites-WrinklingofFacingsinHoneycombSandwichPanels.xls
View Download
Self Explanatory  82k v. 3 Apr 30, 2009, 6:25 AM Richard Abbott
Ĉ AA-SM-113Composites-SandwichPanelsUnderPressure.xls
View Download
Self Explanatory  494k v. 3 Apr 30, 2009, 6:25 AM Richard Abbott
Ĉ AA-SM-117Composites-PressureLoadedQuasi-IsotropicPanels.xls
View Download
Self Explanatory  261k v. 3 Apr 30, 2009, 6:25 AM Richard Abbott
Ĉ AA-SM-121Composites-PlySeparationStressinCornerRadii.xls
View Download
Corrected according to comment by P Morata (Many Thanks) making reference to public domain paper. Maximum stress now considerably smaller.  341k v. 6 Apr 10, 2011, 10:58 AM Richard Abbott
 General
Ċ AA-SM-031RambergOsgoodappliedtoCozzone.pdf
View Download
Using the Ramberg Osgood method in MMPDS Chapter 9.8 applied to Cozzone theory to give a single equation based on common material properties  368k v. 3 Apr 2, 2012, 5:04 AM Richard Abbott
Ĉ AA-SM-201 Tools - Linear Simultaneous equations.xlsx
View Download
  153k v. 2 Feb 4, 2013, 5:25 AM Richard Abbott
Ĉ AA-SM-203 - Tools - Analysis Character Set.xlsx
View Download
  12k v. 2 Feb 4, 2013, 5:23 AM Richard Abbott
Ĉ AA-SM-207 Tools - Simple Weight and Balance.xlsx
View Download
  147k v. 2 Feb 4, 2013, 5:24 AM Richard Abbott
Ĉ AA-SM-208 Tools - Simple Drag Loads Calculation.xlsx
View Download
  150k v. 2 Feb 4, 2013, 5:24 AM Richard Abbott
Ĉ AA-SM-210 Tools - Quadrilateral Analysis.xlsx
View Download
  156k v. 2 Feb 4, 2013, 5:23 AM Richard Abbott
Ĉ AA-SM-211-001 Tools - Angles between 2 points in 3D space and distance to a point.xlsx
View Download
  151k v. 2 Feb 4, 2013, 5:23 AM Richard Abbott
Ĉ AA-SM-211 Tools - Angles between 2 points in 3D space.xlsx
View Download
  153k v. 2 Feb 4, 2013, 5:23 AM Richard Abbott
Ĉ AA-SM-213 Tools - General Interaction Curve.xls
View Download
  271k v. 2 Feb 4, 2013, 5:23 AM Richard Abbott
Ĉ AA-SM-215 Tools - Translation between diferent 3D coordinate systems.xlsx
View Download
  175k v. 2 Feb 4, 2013, 5:23 AM Richard Abbott
Ĉ AA-SM-218 Tools - Simple Principal Stress Calculation.xlsx
View Download
  188k v. 2 Feb 4, 2013, 5:23 AM Richard Abbott
Ĉ AA-SM-219 Tools - Various Mass Balances - Linear and Rotational.xlsx
View Download
  322k v. 3 Oct 21, 2013, 2:50 AM Richard Abbott
Ĉ AA-SM-222 Tools - Intersection of two circles.xlsx
View Download
  76k v. 3 Oct 21, 2013, 2:51 AM Richard Abbott
Ĉ AA-SM-224 Tools - Intersection of Line and a Circle.xlsx
View Download
  111k v. 2 Nov 8, 2013, 8:48 AM Richard Abbott
Ĉ AA-SM-230 Tools - Quadratic Curve Fit.xlsx
View Download
  108k v. 2 Feb 2, 2014, 7:25 AM Richard Abbott
Ĉ AA-SM-231 Tools - Cubic Curve Fit.xlsx
View Download
  110k v. 2 Feb 2, 2014, 7:25 AM Richard Abbott
Ĉ AA-SM-232 Tools - Fourth Order Curve Fit.xlsx
View Download
  111k v. 2 Feb 2, 2014, 7:25 AM Richard Abbott
Ĉ AA-SM-233 Tools - Fifth Order Curve Fit.xlsx
View Download
  115k v. 2 Feb 2, 2014, 7:25 AM Richard Abbott
Comments