Search this site
Spreadsheets

Below are spreadsheets that we use to help with engineering analysis of aircraft structures. Note that most of these spreadsheets use the XLC excel add-in which is available here.
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-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. 1 Jul 2, 2010 10:07 AM Richard Abbott
 AA-SM-000 Metal Stress Analysis
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-000SectionProperties.xls
View Download		 Section Properties of Common Shapes  162k v. 2 Feb 1, 2011 5:59 AM Richard Abbott
AA-SM-001-002SectionProperties-General-SmallFormat.xlsx
View Download		 General Section Properties - Half Page Format  41k v. 2 Feb 1, 2011 5:59 AM Richard Abbott
AA-SM-001-002SectionProperties-General.xlsx
View Download		 General Section Properties - Full Page Format  41k v. 2 Feb 1, 2011 5:59 AM Richard Abbott
AA-SM-001-003SectionProperties-Nodebased.xls
View Download		 General Section Properties - Node Based  61k v. 2 Feb 1, 2011 5:59 AM Richard Abbott
AA-SM-001-004SectionProperties-EllipseSectionProperties.xlsx
View Download		 Section Properties of An Ellipse  161k v. 2 Feb 1, 2011 5:59 AM Richard Abbott
AA-SM-001-005SectionProperties-GeneralwithAngles-SmallFormat.xlsx
View Download		 General Section Properties with Angles - Half Page Format  42k v. 2 Feb 1, 2011 5:59 AM Richard Abbott
AA-SM-001-005SectionProperties-GeneralwithAngles.xlsx
View Download		 General Section Properties with Angles - Full Page Format  43k v. 2 Feb 1, 2011 5:59 AM Richard Abbott
AA-SM-002Torsion.xls
View Download		 Torsion analysis of a number of common cross sections     469k v. 6 Apr 23, 2009 2:37 PM 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-004BoltGroup-1-2DBoltGroup.xls
View Download		 Rigid body load distribution of a single point load and moment across a 2D set of restraints    259k v. 5 Apr 23, 2009 2:38 PM Richard Abbott
AA-SM-004BoltGroup-2-3DBoltGroup.xls
View Download		 Rigid body load distribution of multiple loads and moments across a 3D set of restraints with definable effective directions    339k v. 5 Apr 23, 2009 2:39 PM 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-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-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-026BeamAnalysis.xls
View Download		 Single and multi-span beam analysis (up to 5 spans)   9410k v. 5 Apr 23, 2009 3:06 PM Richard Abbott
AA-SM-027TensionClips.xls
View Download		 OEM proprietary analysis methods for formed and machined steel clips     395k v. 7 Apr 30, 2009 6:50 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-1Composites-laminatefailurecriteria-USUnits.xls
View Download		 Laminate strain and Lamina stress based failure criteria calculation.    579k v. 5 Feb 24, 2011 5:56 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

Sign in|Report Abuse|Print Page|Remove Access|Powered By Google Sites