Search this site
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-003BeaminaSocket.xls
View Download		 shear force, bending moment and bearing stress of a beam in a socket      788k v. 7 Feb 4, 2011, 12:48 PM 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-016SteelRoundTubes.xls
View Download		 Set of individual and combined analyses for steel tubes     2988k v. 6 May 14, 2009, 11:07 AM 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    405k v. 5 Apr 23, 2009, 2:57 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.  186k v. 3 Feb 6, 2013, 3:51 AM 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-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
Comments