READ MEAuthor:R. AbbottTotal Report Pages:Check: Report:Date:Revision:Section Number:Sheet NameIMPORTANT INFORMATIONReport Title:Section:

IMPORTANT INFORMATION

About us:

XL-Viking was created to make working with Microsoft Excel easier and more efficient. XL-Viking started as an internal group at Abbott Aerospace Inc. developing Excel tools to increase productivity, reliability and quality of engineering applications. XL-Viking was establised as a seperate company in 2014.

Established in 2008, Abbott Aerospace helps people develop new aircraft structure and systems and make modifications to existing structure and systems. We do all types of aircraft - Part 23, Part 25, Civil, Military, Prototype, Experimental - and have extensive experience with composite laminate material selection, process control, manufacture, design, substantiation and certification.

We have made these spreadheets available through XL-Xiking and have helped in developing the Xl-Viking add-in.

About the Abbott Aerospace Analysis Spreadsheets:

Our in-house structural analysis toolbox is our collection of spreadsheets. The sheets that we make freely available are a small proportion of the sheets that we have developed for our own use.

They are intended to be used by engineers. They are not protected software packages and can be changed in every way by the user.

All of our spreadsheets are provided 'as is' with no warranty or guarantee explicitly given or implied. You may these spreadsheets at your own risk. The Author will nor be liable for data loss, damages, loss of profits or any other kind of loss while using or misusing these spreadsheetsWe have made every reasonable effort to remove all errors but some may still exist and all analysis work should be thoroughly checked. If you do find errors plese notify us at:

spreadsheets@abbottaerospace.com

Proprietary information:

The spreadsheets contain no proprietary information from outside of Abbott Aerospace Inc. If you think that we have used proprietary information inappropriately please let us know.

Abbott Aerospace Inc. and XL-Viking grants the user the right to use, modify, reproduce and redistribute these spreadsheets. We just ask that if possible you maintain a credit naming Abbott Aerospace Inc./XL-Viking as the source.

Our analysis spreadsheets in general do not use Visual Basic routines and the outcome of the analysis in the spreadsheets rely solely on native Excel functions. The display of the math in these sheets rely on the XL-Viking add-in and the spreadsheets will not display correcly if the add-in is not installed.

To find out more about the Xl-Viking Add-in:www.XL-Viking.com

Find out more about the Design and Analysis services provided by Abbott Aerospace:www.abbottaerospace.com

&"Arial,Bold"ABBOTT AEROSPACE INC. PROPRIETARY INFORMATION&"Arial,Regular"Subject to restrictions on the cover or first page

Cross SectionAuthor:R. AbbottTotal Report Pages:2Page TitleSubSubSubFigTableRunning CountsTotal Sheet Pages:2Check: Report:AA-SM-001-006NoNoTitleTitleTitleNoNoTotal Title No:0Date:20/10/2013Revision:IRTotal Sub No:0Section Number:Sheet NameSECTION PROPERTIESTotal Sub No:0Report Title:STANDARD SPREADSHEET METHODTotal Sub No:0Section:Total Fig No:0Total Table No:0Author:R. AbbottDocument Number:AA-SM-001-006Check: Revision Level :IR1Date:20/10/2013Page:1 of 21Title:STANDARD SPREADSHEET METHODSECTION PROPERTIES12.000.50417.0015.50710131619 ChangeChartAxisScale(Chart name, Xmin, Xmax, Y1min, Y1max, Y2min, Y2max)-2.000.5013.0015.50 Values in italics are optional-2.00-0.5013.0014.502.00-0.5017.0014.50Example2.000.5017.0015.50ERROR:#VALUE!Chart 527.007.0058111417Axis 13.007.00XY3.003.00Maximum17.10017.17.003.00Minimum-2.100-2.17.007.00

312.0012.00691215188.0012.008.008.0012.008.0012.0012.00

Total Section Properties about origin:

yTotal IyzTotal Iz(mm)(mm4)(mm)(mm4)7.500029537.52943

Y =7.5000inLoadsNetUpper Fibre Stress =-1153.85-1.0007.5000-2.5007.500From xFrom yFromTotalElementLower Fiber Stress =1153.8516.0007.500017.5007.500ElementxyxyRelativeBendingBendingEnd LoadStressAngle to X-AxisEL fromEL fromEL fromTotal(in)(in)(in)(in)Stiffness(lb)(lb)(lb)(lb)(psi)AyAy2AIyzAz2AIzAyAy2AIyzAz2AIzx Bendy BendELEL14.0001.0000.0000.00014326.90.00.04326.91081.740414005.3333000.3314-302255.333-30.02250.333-7.500-7.54326.90.000.04326.924.0004.0005.0005.00015769.20.00.05769.2360.6160162168040021.33338040021.33216-4010021.333-40.010021.333-2.500-2.55769.20.000.05769.234.0004.00010.00010.0001-5769.20.00.0-5769.2-360.616016316160160021.3333160160021.333164010021.33340.010021.3332.5002.5-5769.20.000.0-5769.244.0001.00015.00015.0001-4326.90.00.0-4326.9-1081.740444609005.3333609000.3344302255.33330.02250.3337.5007.5-4326.90.000.0-4326.950.00.00.00.00.00050000.0000000.0050000.0000.000.0000.0000.00.00.000.00.060.00.00.00.00.00060000.0000000.0060000.0000.000.0000.0000.00.00.000.00.070.00.00.00.00.00070000.0000000.0070000.0000.000.0000.0000.00.00.000.00.080.00.00.00.00.00080000.0000000.0080000.0000.000.0000.0000.00.00.000.00.090.00.00.00.00.00090000.0000000.0090000.0000.000.0000.0000.00.00.000.00.0100.00.00.00.00.000100000.0000000.00100000.0000.000.0000.0000.00.00.000.00.0110.00.00.00.00.000110000.0000000.00110000.0000.000.0000.0000.00.00.000.00.0120.00.00.00.00.000120000.0000000.00120000.0000.000.0000.0000.00.00.000.00.0130.00.00.00.00.000130000.0000000.00130000.0000.000.0000.0000.00.00.000.00.0140.00.00.00.00.000140000.0000000.00140000.0000.000.0000.0000.00.00.000.00.0150.00.00.00.00.000150000.0000000.00150000.0000.000.0000.0000.00.00.000.00.0160.00.00.00.00.000160000.0000000.00160000.0000.000.0000.0000.00.00.000.00.0170.00.00.00.00.000170000.0000000.00170000.0000.000.0000.0000.00.00.000.00.0180.00.00.00.00.000180000.0000000.00180000.0000.000.0000.0000.00.00.000.00.0190.00.00.00.00.000190000.0000000.00190000.0000.000.0000.0000.00.00.000.00.0Mass =200lbSum: ASum: ASum: yASum: y2ASum:IySum: zASum: z2ASum:IzSum: ASum: yASum: y2ASum:IySum: zASum: z2ASum:IzMass moments of intertia calculated assuming constant density4040.00040.000300.0002900.00053.333300.0002900.00043.33340.000.00650.0053.330.00650.0043.330.000.000.001If you see errors on this spreadsheet it is because you do not have the XL-Viking Plugin, to find out more:www.XL-Viking.comAuthor:R. AbbottDocument Number:AA-SM-001-006Check: Revision Level :IR1Date:20/10/2013Page:2 of 22Title:STANDARD SPREADSHEET METHODSECTION PROPERTIES

Moment (about x-axis) =-100000inlbMoment (about y-axis) =0inlbEnd load =0lb

Section Properties About Centroidal Axis Parallel to Original Axis

General PropertiesArea Moment of IntertiaRadius of Gyration01009.615384615410100-1153.8461538462-1154ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE! ChangeChartAxisScale(Chart name, Xmin, Xmax, Y1min, Y1max, Y2min, Y2max)A =40.0inIx =693.3inx =4.163in01009.615384615410100-1153.8461538462-1154ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE! Values in italics are optionalxleft =9.500inIy =703.3iny =4.193in01153.846153846211540-1009.6153846154-1010ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!xright =9.500inJ = 1396.7in01153.846153846211540-1009.6153846154-1010ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!Exampleyupper =8.0000inWeight Moment of InertiaERROR:#VALUE!ylower =8.0000in072.115384615472ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!Chart 16Total Height (y) =16.000inIx =3466.7in072.115384615472ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!Axis 1Total Width (x) =19.000inIy =3516.7in0649.0384615385649ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!XYJ = 6983.3in0649.0384615385649ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!Maximum17.10017.100Minimum-2.100-2.1000-649.0384615385-649ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0-649.0384615385-649ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0-72.1153846154-72ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0-72.1153846154-72ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

If you see errors on this spreadsheet it is because you do not have the XL-Viking Plugin, to find out more:www.XL-Viking.com

yxPositive Moment around x-axis creates tension in upper fiberPositive Moment around y-axis creates tension in RHS fiber