IMPORTANT INFORMATION About us: XL-Viking as created XL-Viking created to make orking ith !icroso"t !icroso"t #$cel easier and more more e%cient& XL-Vikin XL-Vikin as an inte intern rnal al grou group p at at Abb Abbot ottt Aer Aeros ospa pace ce 'nc& 'nc& deve develo lopi ping ng #$ce #$cell too tools ls to incr increa ease se prod produc ucti tivi vity ty(( r and )uality o" engineering applications& XL-Viking as establised as a seperate company in *+ #stablis #stablished hed in *++.( *++.( Abbott Abbott Aeros Aerospace pace helps helps peopl people e develop develop ne air aircra" cra"tt structur structure e and syste syste make modifcations to e$isting structure and systems& /e do all types o" aircra"t - 0art *1( 0art !ilita !ilitary ry(( 0ro 0rotot totype ype(( #$pe #$perim riment ental al - and and have have e$te e$tensi nsive ve e$per e$perien ience ce ith ith comp composi osite te lamina laminate te m selection( process control( manu"acture( design( substantiation and certifcation& /e have made these spreadheets available through XL-Xiking and have helped in developing Viking add-in&
About the Abbott Aerospace Analysis Spreadsheets: 4ur in-house structural analysis toolbo$ is our collection o" spreadsheets& The sheets that e available are a small proportion o" the sheets that e have developed "or our on use& They are are intended to to be used by engineers& They are are not protected protected so"tare so"tare packages packages and ca changed in every ay by the user& All All o" our our spr sprea eads dshe heet ets s ar are prov provid ided ed 5as 5as is5 is5 ith ith no ar arra rant nty y or or guar guaran ante tee e e$p e$pli lici citl tly y giv given en or or i may these spreadsheets at your on risk& The Author ill nor be liable "or data loss( damages( profts or any other kind o" loss hile using or misusing these spreadsheets /e have have mad made e ever every y reas reasona onable ble e7ort e7ort to to remo remove ve all all err errors ors but some some may may still still e$ist e$ist and and all all an should be thoroughly checked& '" you do fnd errors plese noti"y us at: spreadsheets8abbottaerospace&com Proprietary information: The spreadsheets spreadsheets contain contain no proprietary proprietary in"ormation in"ormation "rom outside outside o" Abbott Aerospace Aerospace 'nc& '" y that e have used proprietary in"ormation inappropriately please let us kno& Abbott Aerospace 'nc& and XL-Viking grants the user the right to use( modi"y( reproduce and re these spreadsheets& spreadsheets& /e /e 9ust ask that i" possible you maintain maintain a credit naming Abbott Abbott Aerospac Aerospac Viking as the source& 4ur analysis spreadsheets in general do not use Visual ;asic routines and the outcome o" the the spreadsheets spreadsheets rely solely solely on native #$cel "unctions& "unctions& The display o" the math in these sheet sheet the XL-Viking add-in and the spreadsheets ill not display correcly i" the add-in is not installed& To To fnd out more more about the XlXl-Viking Viking Add-in: &XL-Viking&com Find out more about the Design and Analysis services provided by Abbott Aerospace: &abbottaerospace&com
ABBOTT AEROSPACE INC. PROPRIETARY INFORMATION INFORMATION
Subject to restrictions on the cover or first page
ABBOTT AEROSPACE INC. PROPRIETARY INFORMATION INFORMATION
Subject to restrictions on the cover or first page
g started eliability ,& s and *2( 3ivil( terial
he Xl-
ake "reely be
plied& 6ou loss o" lysis ork
ou think
distribute e 'nc&XL-
nalysis in rely on &
ABBOTT AEROSPACE INC. PROPRIETARY INFORMATION INFORMATION
Subject to restrictions on the cover or first page
ABBOTT AEROSPACE INC. PROPRIETARY INFORMATION INFORMATION
Subject to restrictions on the cover or first page
Author: R. Abbott Document
FAST&N&R F(&)I*I(IT+ ,OMPARISON ,OMPARISON =e"erences: 4#! 0roprietary !ethod
C
=
8 tE f
2 t 2 t B1 D B 2 + D + B 3
strap >ingle >hear ?oint
t1
t
t2
=
t1
+
t2
2
plate Double >hear t1 ?oint t1
t2
t
=
2t 1 + t 2 2
strap Average #lement Thickness For >ingle @ Double >hear ?oints ,ase , * 1 2 B
Plate Strap Fastener Aluminum Aluminum Aluminum >teel >teel >teel Aluminum Aluminum >teel Aluminum >teel >teel Aluminum >teel Aluminum Aluminum Aluminum Titanium Aluminum Titanium Titanium
*#
*
*$
+&,1+ +&,1+ +&,1+ +&,1+ +&,1+ +&,11 +&,11
* &, *+ * & ,* + * &, * + * &, *+ * &, * + * &+B + * &+ B +
,&+++ ,&+++ ,&.+ ,&1+ +&.+ ,&** ,&,,1
,ase , * 1 2 B
?oint 0arameter 0arameters s 3ase: 1 ?oint: >ingle >hear DC +&*2+ in t C +&,++ in tE C +&,++ in # C ,+2+++++ psi #" C *++++++ psi ; C ;E C ;G C tC 3C
+&,1++ *&,*++ ,&.++ +&,+ in 2&*#-+B inlb"
M " C
,.+2B lb"in lb"in
?oint Type Type ;olt Diameter >trap Thickness 0late Thickness 0late !odulus o" #lasticity ;olt !odulus o" #lasticity
?oint 0arameters Average Thickness o" #lements( H>ee I C . Ht J #" I J H; J Ht D IK J H;E Ht D IKI ;G I ;olt >pring 3onstant( M " C ,3
If you see errors on this spreadsheet it is because you do not have t he XL-Viking XL-Viking Plugin, !XL-Viking!com Author: R. Abbott Document
Date: !"#!"!#$ 0age: Title: STAN%AR% STAN%AR% SPR&A%S'&&T M&T'O% M &T'O%
FAST&N&R F(&)I*I(IT+ ,OMPARISON ,OMPARISON 4#! !ethod P
>ingle >hear ?oint
C=
Double >hear ?oint
t1
δ
t2
=
P
( t1 + t 2 ) 2 E f D
3
P
1 1 + 3.72 + t E t E 1 1 2 2
P/2
t1 t1
P/2
C
=
t2
δ P
=
( t 1 + t 2 / 2) 2E f D
3
P
2 1 + + t 1E 1 t 2E 2
#)uations For the Nrumman !ethod
?oint: >ingle >hear DC +&*2+ in t C +&,++ in tE C +&,++ in #" C *++++++ psi # C ,+2+++++ psi #E C ,+2+++++ psi 3C M " C
&,#-+B inlb" ,11* lb"in lb"in
?oint Type Type ;olt Diameter >trap Thickness 0late Thickness ;olt !odulus o" #lasticity >trap !odulus o" #lasticity 0late !odulus o" #lasticity ;olt Fle$ibility 3onstant ;olt >pring 3onstant( M " C ,3
If you see errors on this spreadsheet it is because you do not have t he XL-Viking XL-Viking Plugin, !XL-Viking!com Author: R. Abbott Document
FAST&N&R F(&)I*I(IT+ ,OMPARISON ,OMPARISON Outh !ethod
C
a t 1 + t 2 b 1 1 1 1 = + + + 2D n t1E1 nt 2E 2 2t 1E f 2nt 2E f
-roup ' '' '''
Type ;olted !etallic =iveted !etallic ;olted Nraphite#po$y
a *1 *2 *1
b 1 &+ + * &* + &* +
!aterial Types and 3onstants For Outh5s Formula
Nroup: ?oint: DC t C tE C # C #E C #" C aC bC nC
''' ingle >hear +&*2+ in +&,++ in +&,++ in ,+2+++++ psi ,+2+++++ psi *++++++ psi + &B &*+ , &+
?oint Type Type ;olt Diameter >trap Thickness 0late Thickness >trap !odulus o" #lasticity 0late !odulus o" #lasticity ;olt !odulus o" #lasticity
n C , For >ingle->hearP n C * For Double->hear ?oints
3 C H, H+&, H+&, J H,&+ H,&+2# 2#+I +III , H, H, J +&, +&, J H,&+2# H,&+2#+ +II II , H* J +&, J H*& H*&#+ #+ J H*&#+III J H&* ,I J HH+&, +&,I H* J +&*2IIQRSS 3 C 2&,1#-+B inlb" ;olt Fle$ibility 3onstant M " C
,2. lb"in lb"in
;olt >pring 3onstant( M " C ,3
If you see errors on this spreadsheet it is because you do not have t he XL-Viking XL-Viking Plugin, !XL-Viking!com Author: R. Abbott Document
FAST&N&R F(&)I*I(IT+ ,OMPARISON ,OMPARISON
4#! !ethod
C
DC t C tE C # C #E C #" C
=
2 ( t1
D)
!.8
t1
+&*2+ in +&,++ in +&,++ in ,+2+++++ psi ,+2+++++ psi *++++++ psi
1 2 ( t D ) + 3 + t E 8 E 1 f 2
!.8
2
1 3 + E 8 E 2 f
;olt Diameter >trap Thickness 0late Thickness >trap !odulus o" #lasticity 0late !odulus o" #lasticity ;olt !odulus o" #lasticity
3 C *UUQRWQRKYQRZI +&, J H, H,&+2#+I 1 H. J H*&#+III *UUQRWQRKYQRZI +&, H. J H*&#+III *&#-+B inlb" ;olt Fl Fle$ibility 3o 3onstant M " C
11B*+ lb"in lb"in
;olt >pring 3onstant( M " C ,3
Alternate ;oeing "ormula H"rom ;oltran manualI:
C
=
#t 1
+ #t 2
% f $ f
3
+
t1
+ t 1 2 t 2 + t 1t 2 2 + t 2 3
N" C ,++**2B psi A" C +&+, inK '" C
+&+++* in
#!E f " f
+
t1
+ t2
t 1t 2E f
+
1 t 1E1
+
1 t 2E 2
;olt >hear !odulus ;olt Area( A C p HD*I* ;olt !oment o" 'nertia( ' C p HD*I
3 C H J +&, J +&,I H2 J H,&+#+I J +&+,I H+&,[ 2 J +&,K J +&, 2 +&,[I H+ J H*&#+I J H,&*#-+II H,&*#-+II H+&, +&,I H+&, J +&, +&, J H*&#+II 3 C *&2#-+B inlb" ;olt Fle$ibility 3onstant M " C
11*. lb"in lb"in
;olt >pring 3onstant( M " C ,3
If you see errors on this spreadsheet it is because you do not have t he XL-Viking XL-Viking Plugin, !XL-Viking!com Author: R. Abbott Document
FAST&N&R F(&)I*I(IT+ ,OMPARISON ,OMPARISON
Tate Tate and =osenF =osenFeld eld !ethod
C
=
+
1 t 1E f
+
1 t 2E f
8 E f πD
#
+
1 t 1E 1
(t + t 3 1
DC +&*2+ in t C +&,++ in tE C +&,++ in # C ,+2+++++ psi #E C ,+2+++++ psi #" C *++++++ psi nb C +&11
2 1
+ t2
1 t 2E 2
+
32 &E f πD 2
(1 + ν f ) ( t 1 + t 2 ) +
+ t 1t 2 2 + t 2 3 ) ;olt Diameter >trap Thickness 0late Thickness >trap !odulus o" #lasticity 0late !odulus o" #lasticity ;olt !odulus o" #lasticity ;olt 0oisson5s =atio
3 C , HH*&#+I J +&,I , HH*&#+I J +&,I , HH,&+2#+I J +&,I , 1* H J H*&#+I H*&#+I J \ J +&*2KI +&*2KI J H, +&11I +&11I J H+&, H+&, +&,I . H2 J H*&#+ H*&#+ 2 J +&,K J +&, 2 J +&, J +&,K +&,[I 3 C *&.,#-+B inlb" ;olt Fle$ibility 3onstant M " C
1221+ lb"in lb"in
;olt >pring 3onstant( M " C ,3
Alternate Tate @ =osen"eld "ormula H"rom ;oltran manualI:
C
=
2t 1 + t 2 3% f $ f
3
+
8t 1
N" C ,++**2B psi A" C +&+, inK '" C
+&+++* in
+ 1't 12 t 2 + 8t 1t 2 2 + t 2 3 1&2E f "f
+
2t 1 + t 2 t 1t 2E f
+
1 t 1E1
+
2 t 2E 2
;olt >hear !odulus ;olt Area( A C p HD*I* ;olt !oment o" 'nertia( ' C p HD*I
3 C H* J +&, +&,I H1 J H,&+#+I J +&+,I H. J +&,[ ,B J +&,K J +&, . H,* J H*&#+I J H,&*#-+II H* J +&, +&,I H+&, J +&, J H*&#+II H,&+2#+II * H+&, J H,&+2#+II 3 C &,,#-+B inlb" ;olt Fle$ibility 3onstant M " C
*112 lb"in lb"in
;olt >pring 3onstant( M " C ,3
If you see errors on this spreadsheet it is because you do not have t he XL-Viking XL-Viking Plugin, !XL-Viking!com Author: R. Abbott Document
FAST&N&R F(&)I*I(IT+ ,OMPARISON ,OMPARISON >i"t !ethod
C
DC t C tE C # C #E C #" C
=
DE f
+&*2+ in +&,++ in +&,++ in ,+2+++++ psi ,+2+++++ psi *++++++ psi
1 1 + !.8 + t E t E 1 1 2 2 ;olt Diameter >trap Thickness 0late Thickness >trap !odulus o" #lasticity 0late !odulus o" #lasticity ;olt !odulus o" #lasticity
H+&, J H,&+2#+I 3 C 2 H+&*2 J H*&#+II +&. J H, H+&, J H,&+2#+II , H+&, *&*,#-+B inlb" ;olt Fl Fle$ibility 3o 3onstant M " C
;olt >pring 3onstant( M " C ,3
2,.+ lb"in lb"in
4#! !ethod
C
=
1 DE 2
$ + BD 1 + t 2
Type >teel ;olts Aluminum =ivets
t 1E1 E2
A , &B 2 &+ +
* + & . + &. +
Fastener Types and 3onstants For Douglas5 Formula Fastener: >teel ;olts DC +&*2+ in t C +&,++ in tE C +&,++ in # C ,+2+++++ psi #E C ,+2+++++ psi
;olt Diameter >trap Thickness 0late Thickness >trap !odulus o" #lasticity 0late !odulus o" #lasticity
AC , &B 0arameter From ;C + &. 0arameter From HH,&+ &+2# 2#+ +I I J +&*2I +&*2I J H,& H,&B B +&. +&. J +&*2 +&*2 J H, +&, +&, H,& H,&+2 +2# #+ +II HH, HH,&+ &+2# 2# 3 C , HH, *&*#-+B inlb" ;olt Fl Fle$ibility 3o 3onstant M " C
1B+ lb"in lb"in
;olt >pring 3onstant( M " C ,3
If you see errors on this spreadsheet it is because you do not have t he XL-Viking XL-Viking Plugin, !XL-Viking!com Author: R. Abbott Document
FAST&N&R F(&)I*I(IT+ ,OMPARISON ,OMPARISON !orris !ethod =e"erence: !orris N& - Defning a >tandard Formula and Test-!ethod est-!etho d "or Fastener Fastener
Fle$ibility in Lap-?oints C
t 1 2 !! 1!!! t 2 2 = 28# + 28# + c f !! + 1!!! + + E )1t 1 E ) 2 t 2 E f t 1 E S(1t 1 D E f t 2 E S( 2 t 2 D
D h −!.3# s −!. p !.3# !.3r e D D D Type ormal Aluminum =ivet 3>M Al Aluminum =i =ivets Titanium Titanium Oi-Loks
cf , &+ + . & *+ ,1&,
Fastener Type 3onstants For !orris5 Formula Fastener: Titaniu Fastener: Titanium m Oi-Loks sC 1,&2 mm pC ,2&.. mm rC , DC B&12 mm Dh C ,+&2 mm t, C *&2 mm t* C *&2 mm #L, C *& N0a #>T, C *& N0a #L* C *& N0a #>T* C *& N0a #" C ,,+&1 N0a c" C
, 1 &,
Fastener 0itch =o 0itch trap Thickness 0late Thickness >trap !odulus o" #lasticity >trap !odulus o" #lasticity 0late !odulus o" #lasticity 0late !odulus o" #lasticity ;olt !odulus o" #lasticity 3oe%cient
3C
&*2#-+2 mm<
;olt Fle$ibility 3onstant
3C
&#-+B inlb"
;olt Fle$ibility 3onstant
M " C
,1*2 lb"in lb"in
L >T L >T
;olt >pring 3onstant( M " C ,3
FAST&N&R F(&)I*I(IT+ ,OMPARISON ,OMPARISON >^!!A=6 4F ALL !#TO4D>
Outh Outh !eth !ethod od 4#! 4#! !eth !ethod od Tate Tate and =osenF =osenFeld eld !ethod >i" >i"tt !etho !ethod d 4#! 4#! !eth !ethod od !orris !orris !ethod !ethod
2&,1 2&,1##-+B +B *& *&##-+B +B *&.,#-+B *&*, *&*,##-+B +B *&* *&*##-+B +B &#&#-+B +B
>teel Fasteners
Titanium Fastener
8.!!E+!' 7.!!E+!' '.!!E+!' .!!E+!' #.!!E+!' 3.!!E+!' 2.!!E+!' 1.!!E+!' !.!!E*!!
If you see errors on this spreadsheet it is because you do not have t he XL-Viking XL-Viking Plugin, !XL-Viking!com
AASM!/ IR # of /
to nd out more: AASM!/ IR
of /
to nd out more: AASM!/ IR $ of /
II , H* J , J +&,
to nd out more: AASM!/ IR 0 of /
J H, H,&+2#+I 1
J +&, +&, J +&,K , H+&, J
to nd out more: AASM!/ IR 1 of /
HH,&+2#+I J +&,I I J \ J +&*2]I J H+&,[
J +&, J +&,K +&,[I , H+&, J
to nd out more: AASM!/ IR 2 of /
I
+I J +&,III
to nd out more: AASM!/ IR 3 of /
to nd out more: AASM!/ IR / of /
to nd out more:
