Methodology and sample could be found in attachment of this post.https://files.engineering.com/getfile.aspx?folder=c7b12ef2-5c4a-40c1-8841-83601d428f91&file=Project#7-APPENDIX.docx
I have a composite analysis in matlab code. I am looking for an example building in excel spread sheet thru VBA. Any suggestion?https://files.engineering.com/getfile.aspx?folder=fa5f1bb0-37bf-4185-9198-87cfe92921ac&file=ARO436_P7_1_Kieu_Tai.m
Moment of Inertia (Fuselage)https://files.engineering.com/getfile.aspx?folder=85836e74-a325-4292-89b7-aa6580ad43f9&file=Copy_of_FEM_Validation_(latest).xls
Update to include Stringer arrangement analysis from Bruhnhttps://files.engineering.com/getfile.aspx?folder=ba6b5527-3355-446e-9781-315661df5e75&file=Determine_Stringer_Arrangement_(Elliptical_or_Circular_Shape_Fuselage).xlsx
Update to include 3D fastener reaction calculationhttps://files.engineering.com/getfile.aspx?folder=6f44f0da-bbd1-4f21-b0d9-59bd3d2fda70&file=3D_Rigid_Body_Analysis.xls
Attached spreadsheet helps to calculate the load from antenna.https://files.engineering.com/getfile.aspx?folder=ca5e8318-264f-4deb-a0c6-2998524fa9e4&file=antenna.xls
Stress due to interference fithttps://files.engineering.com/getfile.aspx?folder=4eb1b186-e213-4e55-9ed8-7f8133a7a3b6&file=Stress_Due_To_Interference_Fit_Bushing.xlsx
Principal Stress from CQUAD elementshttps://files.engineering.com/getfile.aspx?folder=eb428bdf-fcc3-45eb-9bb2-14c26cb2a3b6&file=Principal_Stresses_from_Nastran_QUAD_Element_Extract.xlsx
There excel file contained the calculation for:
1. Fastener torque reduction
2. Principal stress from CQUAD elements
3. Stress due to bushing interference...
