{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Doubler"],"not_rendered":{"charts":3,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Doubler","index":0,"n_rows":164,"n_cols":65,"rows_kept":164,"cut":false,"hidden":false,"merged":[[80,2,80,5],[80,6,80,9],[72,41,73,49],[21,1,22,9],[23,1,24,9],[25,1,26,9],[27,1,28,9],[29,1,32,9],[33,1,34,9],[74,1,75,9],[55,2,55,3],[56,2,56,3]]}
[null,"Author:","R. Abbott",null,null,"Total Report Pages:",{"$f":"X1","v":3},null,null,null,null,null,"Page ","Title","Sub","Sub","Sub","Fig","Table","Running Counts",null,null,"Total Sheet Pages:",{"$f":"SUM(M:M)","v":3}]
[null,"Check:","J. Singh",null,null,"Report:","AA-SM-291",null,null,null,null,null,"No","No","Title","Title","Title","No","No",null,null,null,"Total Title No:",{"$f":"SUM(N:N)","v":0}]
[null,"Date:","20/10/2013",null,null,"Revision:","IR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sub No:",{"$f":"SUM(O:O)","v":0}]
[null,"Section Number:",null,null,null,"Sheet Name","SPLICE LOAD DISTRIBUTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sub No:",{"$f":"SUM(P:P)","v":0}]
[null,"Report Title:","STANDARD SPREADSHEET METHOD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sub No:",{"$f":"SUM(Q:Q)","v":0}]
[null,"Section:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Fig No:",{"$f":"SUM(R:R)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Table No:",{"$f":"SUM(S:S)","v":0}]
[null,null,null,null,"Author:",{"$f":"$C$1","v":"R. Abbott"},null,null,"Document Number:",{"$f":"$G$2","v":"AA-SM-291"}]
[null,null,null,null,"Check:",{"$f":"$C$2","v":"J. Singh"},null,null,"Revision Level :",{"$f":"$G$3","v":"IR"},null,null,1]
[null,null,null,null,"Date:",{"$f":"$C$3","v":"20/10/2013"},null,null,"Page:",{"$f":"L10&\" of \"&$G$1","v":"1 of 3"},null,{"$f":"SUM($M$1:M9)","v":1}]
[null,null,null,null,"Title:",{"$f":"$C$5","v":"STANDARD SPREADSHEET METHOD"}]
[]
[null,{"$f":"$G$4","v":"SPLICE LOAD DISTRIBUTION"}]
[null,"Joint Load Distribution: Ref AFFDL-TR-67-184 Analytical Design Methods for Aircraft Structural Joints"]
[null,"Fastener Stiffness: Ref Huth, On the influence of Rivet Piability of Multi-Row Rivet Connections on Load Transfer"]
[]
[]
[]
[]
[null,"Notes:"]
["●","All input values are in Blue, other values should not be ovewritten"]
["●","This spreadsheets used visual basic code to automatically trigger a specific 'goal-seek' solution to enable the bolt group calculation to converge."]
[]
["●","The visual basic code depends on absolute cell references so do not move any cells or insert any rows or columns"]
[]
["●","Thickness are defined at each fastener position. The thickness between fasteners in the skin and the Splice are the calculated average of those defined at the fastener positions."]
[]
["●","Fastener stiffness values are automatically calculated  using the Huth method, these values can be overwitten in cells F104 to F117"]
[]
["●","In the original method the axial stiffness is based on the net area of the plate and Splice, this is judged to be incorrect as the length of the skin and Splice between the fastener does noe see the effect of the fastener hole. In this method the gross area of the skin and Splice are considered in the calcualtion of the axial stiffness of the plate and Splice."]
[]
[]
[]
["●","This method is set up for up to 14 fasteners. To analyse a situation with less than 14 fasteners the following approach should be taken"]
[]
[null,null,"For a joint with 13 fastneners set the diameter of fastener no. 14 to zero"]
[null,null,"For a joitn with 12 fasteners set the diameters of fasteners no. 13 and 14 to zero"]
[null,null,"etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skin",null,"Splice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","z","x","z"]
[null,"Axial Load carried by the skin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End to Fastener 1"]
[null,"Q =",3250,"lb",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"BD47","v":0},{"$f":"BE43/2","v":2},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC41","v":0},{"$f":"BD48","v":-0.06},{"$f":"BE41","v":2},{"$f":"BF48","v":0.02}]
[null,"Material Stiffness Properties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y136","v":4},{"$f":"BD49","v":-0.06},{"$f":"BC43","v":4},{"$f":"BF42","v":0.02}]
[null,"Aluminum",10700000,"psi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC43","v":4},0,{"$f":"BC44","v":4},{"$f":"BF41","v":0}]
[null,"Steel",29000000,"psi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC41","v":0},{"$f":"BD51","v":0},{"$f":"BE41","v":2},{"$f":"BF41","v":0}]
[null,"Titanium",16000000,"psi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 1 to Fastener 2"]
[null,"Monel",26000000,"psi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC44","v":4},0,{"$f":"BC47","v":4},0,null,null,null,"Fastener 1",{"$f":"IF(B104=0,0,1)","v":1},{"$f":"BE48","v":4},{"$f":"MIN(BD48,BD42)","v":-0.06}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC47","v":4},{"$f":"-W137","v":-0.06},{"$f":"BC48","v":4},{"$f":"X137","v":0.02},null,null,null,null,null,{"$f":"BL47","v":4},{"$f":"MAX(BF48,BF42)","v":0.02}]
[null,"Material Selection for Individual Components",null,null,null,null,null,"Select Material Below:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y137","v":5.5},{"$f":"BD48","v":-0.06},5.5,{"$f":"BF48","v":0.02}]
[null,"Es =",{"$f":"INDEX($C$44:$C$47,MATCH(I50,$B$44:$B$47,0))","v":10700000},"psi, Young's modulus of Skin",null,null,null,"Skin:","Aluminum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC49","v":5.5},{"$f":"0","v":0},5.5,{"$f":"BF47","v":0}]
[null,"Ed =",{"$f":"INDEX($C$44:$C$47,MATCH(I51,$B$44:$B$47,0))","v":29000000},"psi, Young's Modulus of Splice",null,null,null,"Splice:","Steel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC47","v":4},{"$f":"BD47","v":0},4,{"$f":"BF47","v":0}]
[null,"Ef =",{"$f":"INDEX($C$44:$C$47,MATCH(I52,$B$44:$B$47,0))","v":16000000},"psi, Young's Modulus of Fastener",null,null,null,"Fastener:","Titanium",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 2 to Fastener 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC49","v":5.5},0,{"$f":"BC53","v":5.5},0,null,null,null,"Fastener 2",{"$f":"IF(B105=0,0,1)","v":1},{"$f":"BE54","v":5.5},{"$f":"MIN(BD54,BD48)","v":-0.06}]
[null,"Input Data for Huth Fastener Stiffness Calculation",null,null,null,null,null,"Select Type of Joint Below:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC53","v":5.5},{"$f":"-W139","v":-0.06},{"$f":"BC54","v":5.5},{"$f":"X139","v":2.5000000000000001E-2},null,null,null,null,null,{"$f":"BL53","v":5.5},{"$f":"MAX(BF54,BF48)*BK53","v":2.5000000000000001E-2}]
[null,"Group","Type",null,"a","b",null,"Group:","II",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y139","v":7},{"$f":"BD54","v":-0.06},7,{"$f":"BF54","v":2.5000000000000001E-2}]
[null,"I","Bolted Metallic",null,0.66666666666666663,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC55","v":7},{"$f":"0","v":0},7,{"$f":"BF53","v":0}]
[null,"II","Riveted Metallic",null,0.4,2.2000000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC53","v":5.5},{"$f":"BD53","v":0},5.5,{"$f":"BF53","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 3 to Fastener 4"]
[null,"a =",{"$f":"IF(I55=\"I\",E56,IF(I55=\"II\",E57,IF(I55=\"III\",#REF!,\"Error\")))","v":0.4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC55","v":7},0,{"$f":"BC59","v":7},0,null,null,null,"Fastener 3",{"$f":"IF(B106=0,0,1)","v":1},{"$f":"BE60","v":7},{"$f":"MIN(BD60,BD54)","v":-0.06}]
[null,"b =",{"$f":"IF(I55=\"I\",F56,IF(I55=\"II\",F57,IF(I55=\"III\",#REF!,\"Error\")))","v":2.2000000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC59","v":7},{"$f":"-W141","v":-0.06},{"$f":"BC60","v":7},{"$f":"X141","v":0.03},null,null,null,null,null,{"$f":"BL59","v":7},{"$f":"MAX(BF60,BF54)*BK59","v":0.03}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y141","v":8.5},{"$f":"BD60","v":-0.06},8.5,{"$f":"BF60","v":0.03}]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC61","v":8.5},{"$f":"0","v":0},8.5,{"$f":"BF59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC59","v":7},{"$f":"BD59","v":0},7,{"$f":"BF59","v":0}]
[null,null,null,null,"Author:",{"$f":"$C$1","v":"R. Abbott"},null,null,"Document Number:",{"$f":"$G$2","v":"AA-SM-291"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 4 to Fastener 5"]
[null,null,null,null,"Check:",{"$f":"$C$2","v":"J. Singh"},null,null,"Revision Level :",{"$f":"$G$3","v":"IR"},null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC61","v":8.5},0,{"$f":"BC65","v":8.5},0,null,null,null,"Fastener 4",{"$f":"IF(B107=0,0,1)","v":1},{"$f":"BE66","v":8.5},{"$f":"MIN(BD66,BD60)","v":-0.06}]
[null,null,null,null,"Date:",{"$f":"$C$3","v":"20/10/2013"},null,null,"Page:",{"$f":"L66&\" of \"&$G$1","v":"2 of 3"},null,{"$f":"SUM($M$1:M65)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC65","v":8.5},{"$f":"-W143","v":-0.06},{"$f":"BC66","v":8.5},{"$f":"X143","v":3.5000000000000003E-2},null,null,null,null,null,{"$f":"BL65","v":8.5},{"$f":"MAX(BF66,BF60)*BK65","v":3.5000000000000003E-2}]
[null,null,null,null,"Title:",{"$f":"$C$5","v":"STANDARD SPREADSHEET METHOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y143","v":10},{"$f":"BD66","v":-0.06},10,{"$f":"BF66","v":3.5000000000000003E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC67","v":10},{"$f":"0","v":0},10,{"$f":"BF65","v":0}]
[null,{"$f":"$G$4","v":"SPLICE LOAD DISTRIBUTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC65","v":8.5},{"$f":"BD65","v":0},8.5,{"$f":"BF65","v":0}]
[null,"Joint Load Distribution: Ref AFFDL-TR-67-184 Analytical Design Methods for Aircraft Structural Joints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 5 to Fastener 6"]
[null,"Fastener Stiffness: Ref Huth, On the influence of Rivet Pliability of Multi-Row Rivet Connections on Load Transfer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n =",{"$f":"IF(AG70=\"Single Shear\",1,IF(AG70=\"Double Shear\",2,\"Error\"))","v":"Error"},null,"n = 1 For Single-Shear; n = 2 For Double-Shear Joints",null,null,null,null,null,null,null,null,null,null,{"$f":"BC67","v":10},0,{"$f":"BC71","v":10},0,null,null,null,"Fastener 5",{"$f":"IF(B108=0,0,1)","v":1},{"$f":"BE72","v":10},{"$f":"MIN(BD72,BD66)","v":-0.06}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC71","v":10},{"$f":"-W145","v":-0.06},{"$f":"BC72","v":10},{"$f":"X145","v":0.04},null,null,null,null,null,{"$f":"BL71","v":10},{"$f":"MAX(BF72,BF66)*BK71","v":0.04}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y145","v":11.5},{"$f":"BD72","v":-0.06},11.5,{"$f":"BF72","v":0.04}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC73","v":11.5},{"$f":"0","v":0},11.5,{"$f":"BF71","v":0}]
[null,"In the tables below input the blue value: Fastener pitch, skin and Splice widths, fastener diameter, skin and Splice thicknesses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C =",{"$f":"1/((1/(D104*$C$51) + 1/(C104*$C$50) + 1/(2*D104*$C$52) + 1/(2*C104*$C$52))*(C60)*((D104+C104)/(2*B104))^C59)","v":158007.11565913635},"in/lbf","Bolt Flexibility Constant",null,null,null,null,null,null,null,null,null,null,{"$f":"BC71","v":10},{"$f":"BD71","v":0},10,{"$f":"BF71","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 6 to Fastener 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kf = ",{"$f":"1/AP75","v":6.3288289000684484E-6},"lbf/in","Bolt Spring Constant, Kf = 1/C",null,null,null,null,null,null,null,null,null,null,{"$f":"BC73","v":11.5},0,{"$f":"BC77","v":11.5},0,null,null,null,"Fastener 6",{"$f":"IF(B109=0,0,1)","v":1},{"$f":"BE78","v":11.5},{"$f":"MIN(BD78,BD72)","v":-0.06}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC77","v":11.5},{"$f":"-W147","v":-0.06},{"$f":"BC78","v":11.5},{"$f":"X147","v":0.04},null,null,null,null,null,{"$f":"BL77","v":11.5},{"$f":"MAX(BF78,BF72)*BK77","v":0.04}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y147","v":13},{"$f":"BD78","v":-0.06},13,{"$f":"BF78","v":0.04}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Δ","Fastener","Fastener","Fastener","Fastener","Splice ","Splice","Splice","Interim","Σ","Σ","Load in","Base","Base","Diff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC79","v":13},{"$f":"0","v":0},13,{"$f":"BF77","v":0}]
["Fastener","Pitch","Skin",null,null,null,"Splice",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ratio of",null,null,"Strain","Slop","Shear","Spring","Load","Load","Spring","Strain","Loads","Interim","Applied","Base","Structure","Structure","in Strain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC77","v":11.5},{"$f":"BD77","v":0},11.5,{"$f":"BF77","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Splice",null,null,null,null,"Strain","Constant",null,null,"Constant",null,null,"Loads","Loads","Structure","Spring","Strain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 7 to Fastener 8"]
[null,null,"Thick","Width","Area","Stiffness","Thick","Width","Area","Stiffness",null,null,null,null,null,null,null,null,null,null,null,"to Skin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Const",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC79","v":13},0,{"$f":"BC83","v":13},0,null,null,null,"Fastener 7",{"$f":"IF(B110=0,0,1)","v":1},{"$f":"BE84","v":13},{"$f":"MIN(BD84,BD78)","v":-0.06}]
[null,"(in)","(in)","(in)","(in²)","(lb/in)","(in)","(in)","(in²)","(lb/in)",null,null,null,null,null,null,null,null,null,null,null,"Stiffness",1,{"$f":"$B104","v":0.19},{"$f":"AA84","v":4.8208611933595229E-3},null,{"$f":"AC84/AB84","v":4.8208611933595229E-3},{"$f":"$F104","v":158007.11565913635},761.73037215580018,{"$f":"IF(X84=0,#REF!,SUM(AC84:AC84))","v":761.73037215580018},{"$f":"$J85","v":773333.33333333337},{"$f":"AD84/AE84","v":9.8499617089112083E-4},null,{"$f":"SUM(AG84:AG84)","v":0},{"$f":"$C$41+AH84","v":3250},{"$f":"AI84-AC84","v":2488.2696278441999},{"$f":"$F85","v":856000},{"$f":"AJ84/AK84","v":2.9068570418740655E-3},{"$f":"AL84-AF84","v":1.9218608709829447E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC83","v":13},{"$f":"-W149","v":-0.06},{"$f":"BC84","v":13},{"$f":"X149","v":0.04},null,null,null,null,null,{"$f":"BL83","v":13},{"$f":"MAX(BF84,BF78)*BK83","v":0.04}]
["1-2",1.5,{"$f":"AVERAGE(C104:C105)","v":0.06},2,{"$f":"(D85)*C85","v":0.12},{"$f":"$C$50*E85/B85","v":856000},{"$f":"AVERAGE(D104:D105)","v":0.02},2,{"$f":"(H85)*G85","v":0.04},{"$f":"$C$51*I85/B85","v":773333.33333333337},null,null,null,null,null,null,null,null,null,null,null,{"$f":"J85/F85","v":0.90342679127725867},2,{"$f":"$B105","v":0.19},{"$f":"Y84-AM84","v":2.8990003223765782E-3},null,{"$f":"Y85","v":2.8990003223765782E-3},{"$f":"$F105","v":158007.11565913635},{"$f":"AA85*AB85","v":458.06267923362958},{"$f":"IF(X85=0,AD84,SUM(AC84:AC85))","v":1219.7930513894298},{"$f":"$J86","v":966666.66666666663},1.2618548807476861E-3,null,{"$f":"SUM(AG84:AG85)","v":0},{"$f":"$C$41+AH85","v":3250},{"$f":"AI85-AD85","v":2030.2069486105702},{"$f":"$F86","v":856000},2.3717370894983298E-3,1.1098822087506437E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y149","v":14.5},{"$f":"BD84","v":-0.06},14.5,{"$f":"BF84","v":0.04}]
["2-3",1.5,{"$f":"AVERAGE(C105:C106)","v":0.06},2,{"$f":"(D86)*C86","v":0.12},{"$f":"$C$50*E86/B86","v":856000},{"$f":"AVERAGE(D105:D106)","v":2.5000000000000001E-2},2,{"$f":"(H86)*G86","v":0.05},{"$f":"$C$51*I86/B86","v":966666.66666666663},null,null,null,null,null,null,null,null,null,null,null,1.1292834890965731,3,{"$f":"$B106","v":0.19},1.7891181136259345E-3,null,1.7891181136259345E-3,{"$f":"$F106","v":189413.47351221653},338.88307642551274,{"$f":"IF(X86=0,AD85,SUM(AC84:AC86))","v":1558.6761278149424},{"$f":"$J87","v":1160000},1.3436863170818469E-3,null,{"$f":"SUM(AG84:AG86)","v":0},{"$f":"$C$41+AH86","v":3250},1691.3238721850576,{"$f":"$F87","v":856000},1.9758456450760017E-3,6.3215932799415482E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC85","v":14.5},{"$f":"0","v":0},14.5,{"$f":"BF83","v":0}]
["3-4",1.5,{"$f":"AVERAGE(C106:C107)","v":0.06},2,0.12,{"$f":"$C$50*E87/B87","v":856000},{"$f":"AVERAGE(D106:D107)","v":0.03},2,0.06,{"$f":"$C$51*I87/B87","v":1160000},null,null,null,null,null,null,null,null,null,null,null,1.3551401869158879,4,{"$f":"$B107","v":0.19},1.1569587856317797E-3,null,1.1569587856317797E-3,{"$f":"$F107","v":189413.47351221653},219.1435822969913,{"$f":"IF(X87=0,AD86,SUM(AC84:AC87))","v":1777.8197101119338},{"$f":"$J88","v":1353333.3333333335},1.3136598843191628E-3,null,{"$f":"SUM(AG84:AG87)","v":0},{"$f":"$C$41+AH87","v":3250},1472.1802898880662,{"$f":"$F88","v":856000},1.7198367872524138E-3,4.0617690293325102E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC83","v":13},{"$f":"BD83","v":0},13,{"$f":"BF83","v":0}]
["4-5",1.5,{"$f":"AVERAGE(C107:C108)","v":0.06},2,0.12,{"$f":"$C$50*E88/B88","v":856000},{"$f":"AVERAGE(D107:D108)","v":3.5000000000000003E-2},2,7.0000000000000007E-2,{"$f":"$C$51*I88/B88","v":1353333.3333333335},null,null,null,null,null,null,null,null,null,null,null,1.5809968847352027,5,{"$f":"$B108","v":0.19},7.507818826985287E-4,null,7.507818826985287E-4,{"$f":"$F108","v":208324.09886793696},156.40595915954415,{"$f":"IF(X88=0,AD87,SUM(AC84:AC88))","v":1934.225669271478},{"$f":"$J89","v":1546666.6666666667},1.2505769413393177E-3,null,{"$f":"SUM(AG84:AG88)","v":0},{"$f":"$C$41+AH88","v":3250},1315.774330728522,{"$f":"$F89","v":856000},1.5371195452436005E-3,2.8654260390428279E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 8 to Fastener 9"]
["5-6",1.5,{"$f":"AVERAGE(C108:C109)","v":0.06},2,0.12,{"$f":"$C$50*E89/B89","v":856000},{"$f":"AVERAGE(D108:D109)","v":0.04},2,0.08,{"$f":"$C$51*I89/B89","v":1546666.6666666667},null,null,null,null,null,null,null,null,null,null,null,1.8068535825545173,6,{"$f":"$B109","v":0.19},4.6423927879424591E-4,null,4.6423927879424591E-4,{"$f":"$F109","v":208324.09886793696},96.71222941391224,{"$f":"IF(X89=0,AD88,SUM(AC84:AC89))","v":2030.9378986853901},{"$f":"$J90","v":1546666.6666666667},1.3131064000121056E-3,null,{"$f":"SUM(AG84:AG89)","v":0},{"$f":"$C$41+AH89","v":3250},1219.0621013146099,{"$f":"$F90","v":856000},1.4241379688254788E-3,1.1103156881337329E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC85","v":14.5},0,{"$f":"BC89","v":14.5},0,null,null,null,"Fastener 8",{"$f":"IF(B111=0,0,1)","v":1},{"$f":"BE90","v":14.5},{"$f":"MIN(BD90,BD84)","v":-0.06}]
["6-7",1.5,{"$f":"AVERAGE(C109:C110)","v":0.06},2,0.12,{"$f":"$C$50*E90/B90","v":856000},{"$f":"AVERAGE(D109:D110)","v":0.04},2,0.08,{"$f":"$C$51*I90/B90","v":1546666.6666666667},null,null,null,null,null,null,null,null,null,null,null,1.8068535825545173,7,{"$f":"$B110","v":0.19},3.5320770998087262E-4,null,3.5320770998087262E-4,{"$f":"$F110","v":208324.09886793696},73.581677894972913,{"$f":"IF(X90=0,AD89,SUM(AC84:AC90))","v":2104.5195765803628},{"$f":"$J91","v":1546666.6666666667},1.360680760720062E-3,null,{"$f":"SUM(AG84:AG90)","v":0},{"$f":"$C$41+AH90","v":3250},1145.4804234196372,{"$f":"$F91","v":856000},1.3381780647425668E-3,-2.2502695977495235E-5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC89","v":14.5},{"$f":"-W151","v":-5.5E-2},{"$f":"BC90","v":14.5},{"$f":"X151","v":0.04},null,null,null,null,null,{"$f":"BL89","v":14.5},{"$f":"MAX(BF90,BF84)*BK89","v":0.04}]
["7-8",1.5,{"$f":"AVERAGE(C110:C111)","v":0.06},2,0.12,{"$f":"$C$50*E91/B91","v":856000},{"$f":"AVERAGE(D110:D111)","v":0.04},2,0.08,{"$f":"$C$51*I91/B91","v":1546666.6666666667},null,null,null,null,null,null,null,null,null,null,null,1.8068535825545173,8,{"$f":"$B111","v":0.19},3.7571040595836785E-4,null,3.7571040595836785E-4,{"$f":"$F111","v":208324.09886793696},78.26953175658376,{"$f":"IF(X91=0,AD90,SUM(AC84:AC91))","v":2182.7891083369464},{"$f":"$J92","v":1546666.6666666667},1.4112860614247497E-3,null,{"$f":"SUM(AG84:AG91)","v":0},{"$f":"$C$41+AH91","v":3250},1067.2108916630536,{"$f":"$F92","v":784666.66666666663},1.3600818500378764E-3,-5.120421138687329E-5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y151","v":16},{"$f":"BD90","v":-5.5E-2},16,{"$f":"BF90","v":0.04}]
["8-9",1.5,{"$f":"AVERAGE(C111:C112)","v":5.5E-2},2,0.11,{"$f":"$C$50*E92/B92","v":784666.66666666663},{"$f":"AVERAGE(D111:D112)","v":0.04},2,0.08,{"$f":"$C$51*I92/B92","v":1546666.6666666667},null,null,null,null,null,null,null,null,null,null,null,1.9711129991503826,9,{"$f":"$B112","v":0.19},4.2691461734524114E-4,null,4.2691461734524114E-4,{"$f":"$F112","v":195460.08031327461},83.444765393211725,{"$f":"IF(X92=0,AD91,SUM(AC84:AC92))","v":2266.2338737301579},{"$f":"$J93","v":1546666.6666666667},1.4652374183600158E-3,null,{"$f":"SUM(AG84:AG92)","v":0},{"$f":"$C$41+AH92","v":3250},983.76612626984206,{"$f":"$F93","v":713333.33333333337},1.3791113919670683E-3,-8.6126026392947461E-5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC91","v":16},{"$f":"0","v":0},16,{"$f":"BF89","v":0}]
["9-10",1.5,{"$f":"AVERAGE(C112:C113)","v":0.05},2,0.1,{"$f":"$C$50*E93/B93","v":713333.33333333337},{"$f":"AVERAGE(D112:D113)","v":0.04},2,0.08,{"$f":"$C$51*I93/B93","v":1546666.6666666667},null,null,null,null,null,null,null,null,null,null,null,2.1682242990654204,10,{"$f":"$B113","v":0.19},5.130406437381886E-4,null,5.130406437381886E-4,{"$f":"$F113","v":195460.08031327461},100.27896542904045,{"$f":"IF(X93=0,AD92,SUM(AC84:AC93))","v":2366.5128391591984},{"$f":"$J94","v":1546666.6666666667},1.53007295635293E-3,null,0,{"$f":"$C$41+AH93","v":3250},883.48716084080161,{"$f":"$F94","v":642000},1.3761482256087253E-3,-1.5392473074420467E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC89","v":14.5},{"$f":"BD89","v":0},14.5,{"$f":"BF89","v":0}]
["10-11",1.5,{"$f":"AVERAGE(C113:C114)","v":4.4999999999999998E-2},2,0.09,{"$f":"$C$50*E94/B94","v":642000},{"$f":"AVERAGE(D113:D114)","v":0.04},2,0.08,{"$f":"$C$51*I94/B94","v":1546666.6666666667},null,null,null,null,null,null,null,null,null,null,null,2.4091381100726896,11,{"$f":"$B114","v":0.19},6.6696537448239328E-4,null,6.6696537448239328E-4,{"$f":"$F114","v":178055.33033416659},118.75674007491367,{"$f":"IF(X94=0,AD93,SUM(AC84:AC94))","v":2485.2695792341119},{"$f":"$J95","v":1546666.6666666667},1.6068553314013655E-3,null,0,{"$f":"$C$41+AH94","v":3250},764.73042076588808,{"$f":"$F95","v":570666.66666666663},1.3400649896598508E-3,-2.6679034174151468E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 9 to Fastener 10"]
["11-12",1.5,{"$f":"AVERAGE(C114:C115)","v":0.04},2,0.08,{"$f":"$C$50*E95/B95","v":570666.66666666663},{"$f":"AVERAGE(D114:D115)","v":0.04},2,0.08,{"$f":"$C$51*I95/B95","v":1546666.6666666667},null,null,null,null,null,null,null,null,null,null,null,2.7102803738317762,12,{"$f":"$B115","v":0.19},9.3375571622390796E-4,null,9.3375571622390796E-4,{"$f":"$F115","v":178055.33033416659},166.26018250366425,{"$f":"IF(X95=0,AD94,SUM(AC84:AC95))","v":2651.529761737776},{"$f":"$J96","v":1546666.6666666667},1.7143511390545964E-3,null,0,{"$f":"$C$41+AH95","v":3250},598.47023826222403,{"$f":"$F96","v":499333.33333333343},1.1985385278949746E-3,-5.1581261115962187E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC91","v":16},0,{"$f":"BC95","v":16},0,null,null,null,"Fastener 9",{"$f":"IF(B112=0,0,1)","v":1},{"$f":"BE96","v":16},{"$f":"MIN(BD96,BD90)","v":-5.5E-2}]
["12-13",1.5,{"$f":"AVERAGE(C115:C116)","v":3.5000000000000003E-2},2,7.0000000000000007E-2,{"$f":"$C$50*E96/B96","v":499333.33333333343},{"$f":"AVERAGE(D115:D116)","v":0.04},2,0.08,{"$f":"$C$51*I96/B96","v":1546666.6666666667},null,null,null,null,null,null,null,null,null,null,null,3.0974632843791716,13,{"$f":"$B116","v":0.19},1.4495683273835298E-3,null,1.4495683273835298E-3,{"$f":"$F116","v":154171.7481529064},223.48248309980332,{"$f":"IF(X96=0,AD95,SUM(AC84:AC96))","v":2875.0122448375791},{"$f":"$J97","v":1546666.6666666667},1.8588441238174002E-3,null,0,{"$f":"$C$41+AH96","v":3250},374.98775516242085,{"$f":"$F97","v":428000},8.7613961486546926E-4,-9.8270450895193099E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC95","v":16},{"$f":"-W153","v":-0.05},{"$f":"BC96","v":16},{"$f":"X153","v":0.04},null,null,null,null,null,{"$f":"BL95","v":16},{"$f":"MAX(BF96,BF90)*BK95","v":0.04}]
["13-14",1.5,{"$f":"AVERAGE(C116:C117)","v":0.03},2,0.06,{"$f":"$C$50*E97/B97","v":428000},{"$f":"AVERAGE(D116:D117)","v":0.04},2,0.08,{"$f":"$C$51*I97/B97","v":1546666.6666666667},null,null,null,null,null,null,null,null,null,null,null,3.6137071651090347,14,{"$f":"$B117","v":0.19},2.432272836335461E-3,null,2.432272836335461E-3,{"$f":"$F117","v":154171.7481529064},374.98775516266602,{"$f":"IF(X97=0,AD96,SUM(AC84:AC97))","v":3250.0000000002451},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"SUM(AG84:AG97)","v":0},{"$f":"$C$41+AH97","v":3250},-2.4510882212780416E-10,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y153","v":17.5},{"$f":"BD96","v":-0.05},17.5,{"$f":"BF96","v":0.04}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC97","v":17.5},{"$f":"0","v":0},17.5,{"$f":"BF95","v":0}]
[null,null,null,null,null,null,"Results",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC95","v":16},{"$f":"BD95","v":0},16,{"$f":"BF95","v":0}]
["Fastener",null,"Skin","Splice","Average","Fastener","Fastener","% of Load","Splice","% of Load","Skin",null,null,null,null,null,null,null,null,null,null,"Ratio of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 10 to Fastener 11"]
[null,"Dia","Thick","Thick","Thickness","Stiffness","Load","Transfer","Load","in","Load",null,null,null,null,null,null,null,null,null,null,"Splice",null,"Skin","Splice","Bearing","Bearing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC97","v":17.5},0,{"$f":"BC101","v":17.5},0,null,null,null,"Fastener 10",{"$f":"IF(B113=0,0,1)","v":1},{"$f":"BE102","v":17.5},{"$f":"MIN(BD102,BD96)","v":-0.05}]
[null,"(in)","(in)","(in)","(in)","(lb/in)","(lb)","in Fast.","(lb)","Splice","(lb)",null,null,null,null,null,null,null,null,null,null,"to Skin",null,"Bearing","Bearing","Stress","Stress",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC101","v":17.5},{"$f":"-W155","v":-4.4999999999999998E-2},{"$f":"BC102","v":17.5},{"$f":"X155","v":0.04},null,null,null,null,null,{"$f":"BL101","v":17.5},{"$f":"MAX(BF102,BF96)*BK101","v":0.04}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load",null,"Area","Area","Skin","Splice",null,null,null,{"$f":"K104/E85","v":27083.333333333336},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y155","v":19},{"$f":"BD102","v":-4.4999999999999998E-2},19,{"$f":"BF102","v":0.04}]
[1,0.19,0.06,0.02,{"$f":"(D104+C104)/2","v":0.04},{"$f":"1/((1/(D104*$C$51) + 1/(C104*$C$50) + 1/(2*D104*$C$52) + 1/(2*C104*$C$52))*($C$60)*((D104+C104)/(2*B104))^$C$59)","v":158007.11565913635},{"$f":"ABS(AC84)","v":761.73037215580018},{"$f":"G104/MAX($I$104:$I$118)","v":0.23437857604792084},0,{"$f":"I104/$C$41","v":0},{"$f":"C41","v":3250},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B104*C104","v":1.14E-2},{"$f":"D104*B104","v":3.8E-3},{"$f":"G104/X104","v":66818.453697877208},{"$f":"G104/Y104","v":200455.36109363163},null,null,{"$f":"I105/I85","v":19043.259303895004},{"$f":"K105/E85","v":20735.580232035001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC103","v":19},{"$f":"0","v":0},19,{"$f":"BF101","v":0}]
[2,0.19,0.06,0.02,0.04,{"$f":"1/((1/(D105*$C$51) + 1/(C105*$C$50) + 1/(2*D105*$C$52) + 1/(2*C105*$C$52))*($C$60)*((D105+C105)/(2*B105))^$C$59)","v":158007.11565913635},{"$f":"ABS(AC85)","v":458.06267923362958},{"$f":"G105/MAX($I$104:$I$118)","v":0.14094236284110617},{"$f":"AD84","v":761.73037215580018},{"$f":"I105/$C$41","v":0.23437857604793852},{"$f":"AJ84","v":2488.2696278441999},null,null,null,null,null,null,null,null,null,null,{"$f":"I105/K105","v":0.30612854958799307},null,1.14E-2,3.8E-3,40180.936774879789,120542.81032463936,null,null,{"$f":"I106/I86","v":24395.861027788596},{"$f":"K106/E86","v":16918.39123842142},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC101","v":17.5},{"$f":"BD101","v":0},17.5,{"$f":"BF101","v":0}]
[3,0.19,0.06,0.03,4.4999999999999998E-2,{"$f":"1/((1/(D106*$C$51) + 1/(C106*$C$50) + 1/(2*D106*$C$52) + 1/(2*C106*$C$52))*($C$60)*((D106+C106)/(2*B106))^$C$59)","v":189413.47351221653},{"$f":"ABS(AC86)","v":338.88307642551274},{"$f":"G106/MAX($I$104:$I$118)","v":0.10427171582322682},{"$f":"AD85","v":1219.7930513894298},{"$f":"I106/$C$41","v":0.37532093888905532},{"$f":"AJ85","v":2030.2069486105702},null,null,null,null,null,null,null,null,null,null,0.60082202566798915,null,1.14E-2,5.7000000000000002E-3,29726.585651360765,59453.17130272153,null,null,{"$f":"I107/I87","v":25977.935463582377},{"$f":"K107/E87","v":14094.365601542147},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 11 to Fastener 12"]
[4,0.19,0.06,0.03,4.4999999999999998E-2,{"$f":"1/((1/(D107*$C$51) + 1/(C107*$C$50) + 1/(2*D107*$C$52) + 1/(2*C107*$C$52))*($C$60)*((D107+C107)/(2*B107))^$C$59)","v":189413.47351221653},{"$f":"ABS(AC87)","v":219.1435822969913},{"$f":"G107/MAX($I$104:$I$118)","v":6.7428794552915311E-2},{"$f":"AD86","v":1558.6761278149424},{"$f":"I107/$C$41","v":0.47959265471228996},{"$f":"AJ86","v":1691.3238721850576},null,null,null,null,null,null,null,null,null,null,0.92157164777746281,null,1.14E-2,5.7000000000000002E-3,19223.121254122045,38446.24250824409,null,null,{"$f":"I108/I88","v":25397.424430170478},{"$f":"K108/E88","v":12268.169082400553},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC103","v":19},0,{"$f":"BC107","v":19},0,null,null,null,"Fastener 11",{"$f":"IF(B114=0,0,1)","v":1},{"$f":"BE108","v":19},{"$f":"MIN(BD108,BD102)","v":-4.4999999999999998E-2}]
[5,0.19,0.06,0.04,0.05,{"$f":"1/((1/(D108*$C$51) + 1/(C108*$C$50) + 1/(2*D108*$C$52) + 1/(2*C108*$C$52))*($C$60)*((D108+C108)/(2*B108))^$C$59)","v":208324.09886793696},{"$f":"ABS(AC88)","v":156.40595915954415},{"$f":"G108/MAX($I$104:$I$118)","v":4.8124910510625341E-2},{"$f":"AD87","v":1777.8197101119338},{"$f":"I108/$C$41","v":0.54702144926521035},{"$f":"AJ87","v":1472.1802898880662},null,null,null,null,null,null,null,null,null,null,1.2076100477116876,null,1.14E-2,7.6E-3,13719.820978907381,20579.731468361071,null,null,{"$f":"I109/I89","v":24177.820865893475},{"$f":"K109/E89","v":10964.786089404352},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC107","v":19},{"$f":"-W157","v":-0.04},{"$f":"BC108","v":19},{"$f":"X157","v":0.04},null,null,null,null,null,{"$f":"BL107","v":19},{"$f":"MAX(BF108,BF102)*BK107","v":0.04}]
[6,0.19,0.06,0.04,0.05,{"$f":"1/((1/(D109*$C$51) + 1/(C109*$C$50) + 1/(2*D109*$C$52) + 1/(2*C109*$C$52))*($C$60)*((D109+C109)/(2*B109))^$C$59)","v":208324.09886793696},{"$f":"ABS(AC89)","v":96.71222941391224},{"$f":"G109/MAX($I$104:$I$118)","v":2.9757609050432291E-2},{"$f":"AD88","v":1934.225669271478},{"$f":"I109/$C$41","v":0.59514635977583941},{"$f":"AJ88","v":1315.774330728522},null,null,null,null,null,null,null,null,null,null,1.470028426683571,null,1.14E-2,7.6E-3,8483.5288959572135,12725.29334393582,null,null,{"$f":"I110/I90","v":25386.723733567374},{"$f":"K110/E90","v":10158.850844288416},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y157","v":20.5},{"$f":"BD108","v":-0.04},20.5,{"$f":"BF108","v":0.04}]
[7,0.19,0.06,0.04,0.05,{"$f":"1/((1/(D110*$C$51) + 1/(C110*$C$50) + 1/(2*D110*$C$52) + 1/(2*C110*$C$52))*($C$60)*((D110+C110)/(2*B110))^$C$59)","v":208324.09886793696},{"$f":"ABS(AC90)","v":73.581677894972913},{"$f":"G110/MAX($I$104:$I$118)","v":2.2640516275374573E-2},{"$f":"AD89","v":2030.9378986853901},{"$f":"I110/$C$41","v":0.62490396882627386},{"$f":"AJ89","v":1219.0621013146099},null,null,null,null,null,null,null,null,null,null,1.6659839531515837,null,1.14E-2,7.6E-3,6454.5331486818341,9681.799723022752,null,null,{"$f":"I111/I91","v":26306.494707254533},{"$f":"K111/E91","v":9545.6701951636442},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC109","v":20.5},{"$f":"0","v":0},20.5,{"$f":"BF107","v":0}]
[8,0.19,0.06,0.04,0.05,{"$f":"1/((1/(D111*$C$51) + 1/(C111*$C$50) + 1/(2*D111*$C$52) + 1/(2*C111*$C$52))*($C$60)*((D111+C111)/(2*B111))^$C$59)","v":208324.09886793696},{"$f":"ABS(AC91)","v":78.26953175658376},{"$f":"G111/MAX($I$104:$I$118)","v":2.4082932848177804E-2},{"$f":"AD90","v":2104.5195765803628},{"$f":"I111/$C$41","v":0.64754448510165008},{"$f":"AJ90","v":1145.4804234196372},null,null,null,null,null,null,null,null,null,null,1.8372374887889198,null,1.14E-2,7.6E-3,6865.7483997003292,10298.622599550496,null,null,{"$f":"I112/I92","v":27284.863854211828},{"$f":"K112/E92","v":9701.9171969368508},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC107","v":19},{"$f":"BD107","v":0},19,{"$f":"BF107","v":0}]
[9,0.19,0.05,0.04,4.4999999999999998E-2,{"$f":"1/((1/(D112*$C$51) + 1/(C112*$C$50) + 1/(2*D112*$C$52) + 1/(2*C112*$C$52))*($C$60)*((D112+C112)/(2*B112))^$C$59)","v":195460.08031327461},{"$f":"ABS(AC92)","v":83.444765393211725},{"$f":"G112/MAX($I$104:$I$118)","v":2.5675312428678595E-2},{"$f":"AD91","v":2182.7891083369464},{"$f":"I112/$C$41","v":0.67162741794982961},{"$f":"AJ91","v":1067.2108916630536},null,null,null,null,null,null,null,null,null,null,2.0453212438035253,null,9.5000000000000015E-3,7.6E-3,8783.6595150749163,10979.574393843648,null,null,{"$f":"I113/I93","v":28327.923421626972},{"$f":"K113/E93","v":9837.6612626984206},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 12 to Fastener 13"]
[10,0.19,0.05,0.04,4.4999999999999998E-2,{"$f":"1/((1/(D113*$C$51) + 1/(C113*$C$50) + 1/(2*D113*$C$52) + 1/(2*C113*$C$52))*($C$60)*((D113+C113)/(2*B113))^$C$59)","v":195460.08031327461},{"$f":"ABS(AC93)","v":100.27896542904045},{"$f":"G113/MAX($I$104:$I$118)","v":3.0855066285856273E-2},{"$f":"AD92","v":2266.2338737301579},{"$f":"I113/$C$41","v":0.69730273037851009},{"$f":"AJ92","v":983.76612626984206},null,null,null,null,null,null,null,null,null,null,2.3036307240248903,null,9.5000000000000015E-3,7.6E-3,10555.68057147794,13194.600714347429,null,null,{"$f":"I114/I94","v":29581.410489489979},{"$f":"K114/E94","v":9816.5240093422399},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC109","v":20.5},0,{"$f":"BC113","v":20.5},0,null,null,null,"Fastener 12",{"$f":"IF(B115=0,0,1)","v":1},{"$f":"BE113","v":20.5},{"$f":"MIN(BD114,BD108)","v":-0.04}]
[11,0.19,0.04,0.04,0.04,{"$f":"1/((1/(D114*$C$51) + 1/(C114*$C$50) + 1/(2*D114*$C$52) + 1/(2*C114*$C$52))*($C$60)*((D114+C114)/(2*B114))^$C$59)","v":178055.33033416659},{"$f":"ABS(AC94)","v":118.75674007491367},{"$f":"G114/MAX($I$104:$I$118)","v":3.6540535407662986E-2},{"$f":"AD93","v":2366.5128391591984},{"$f":"I114/$C$41","v":0.72815779666436875},{"$f":"AJ93","v":883.48716084080161},null,null,null,null,null,null,null,null,null,null,2.6786046748059396,null,7.6E-3,7.6E-3,15625.886851962325,15625.886851962325,null,null,{"$f":"I115/I95","v":31065.869740426398},{"$f":"K115/E95","v":9559.1302595736015},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC113","v":20.5},{"$f":"-W159","v":-3.5000000000000003E-2},{"$f":"BC114","v":20.5},{"$f":"X159","v":0.04},null,null,null,null,null,{"$f":"BL113","v":20.5},{"$f":"MAX(BF114,BF108)*BK113","v":0.04}]
[12,0.19,0.04,0.04,0.04,{"$f":"1/((1/(D115*$C$51) + 1/(C115*$C$50) + 1/(2*D115*$C$52) + 1/(2*C115*$C$52))*($C$60)*((D115+C115)/(2*B115))^$C$59)","v":178055.33033416659},{"$f":"ABS(AC95)","v":166.26018250366425},{"$f":"G115/MAX($I$104:$I$118)","v":5.1156979231892837E-2},{"$f":"AD94","v":2485.2695792341119},{"$f":"I115/$C$41","v":0.76469833207203441},{"$f":"AJ94","v":764.73042076588808},null,null,null,null,null,null,null,null,null,null,3.2498636274271395,null,7.6E-3,7.6E-3,21876.339803113719,21876.339803113719,null,null,{"$f":"I116/I96","v":33144.1220217222},{"$f":"K116/E96","v":8549.5748323174848},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y159","v":22},{"$f":"BD114","v":-3.5000000000000003E-2},22,{"$f":"BF114","v":0.04}]
[13,0.19,0.03,0.04,3.5000000000000003E-2,{"$f":"1/((1/(D116*$C$51) + 1/(C116*$C$50) + 1/(2*D116*$C$52) + 1/(2*C116*$C$52))*($C$60)*((D116+C116)/(2*B116))^$C$59)","v":154171.7481529064},{"$f":"ABS(AC96)","v":223.48248309980332},{"$f":"G116/MAX($I$104:$I$118)","v":6.876384095378045E-2},{"$f":"AD95","v":2651.529761737776},{"$f":"I116/$C$41","v":0.81585531130393107},{"$f":"AJ95","v":598.47023826222403},null,null,null,null,null,null,null,null,null,null,4.4305123165974196,null,5.7000000000000002E-3,7.6E-3,39207.453175404087,29405.589881553067,null,null,{"$f":"I117/I97","v":35937.65306046974},{"$f":"K117/E97","v":6249.7959193736815},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC115","v":22},{"$f":"0","v":0},22,{"$f":"BF113","v":0}]
[14,0.19,0.03,0.04,3.5000000000000003E-2,{"$f":"1/((1/(D117*$C$51) + 1/(C117*$C$50) + 1/(2*D117*$C$52) + 1/(2*C117*$C$52))*($C$60)*((D117+C117)/(2*B117))^$C$59)","v":154171.7481529064},{"$f":"ABS(AC97)","v":374.98775516266602},{"$f":"G117/MAX($I$104:$I$118)","v":0.11538084774235008},{"$f":"AD96","v":2875.0122448375791},{"$f":"I117/$C$41","v":0.8846191522577167},{"$f":"AJ96","v":374.98775516242085},null,null,null,null,null,null,null,null,null,null,7.666949667709301,null,5.7000000000000002E-3,7.6E-3,65787.325467134389,49340.494100350792,null,null,null,{"$f":"K118/E97","v":-4.0851470354634029E-9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC113","v":20.5},{"$f":"BD113","v":0},20.5,{"$f":"BF113","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"AD97","v":3250.0000000002451},{"$f":"I118/$C$41","v":1.0000000000000755},{"$f":"AJ97","v":-2.4510882212780416E-10},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 13 to Fastener 14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC115","v":22},0,{"$f":"BC119","v":22},0,null,null,null,"Fastener 13",{"$f":"IF(B116=0,0,1)","v":1},{"$f":"BE119","v":22},{"$f":"MIN(BD120,BD114)","v":-3.5000000000000003E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC119","v":22},{"$f":"-W161","v":-0.03},{"$f":"BC120","v":22},{"$f":"X161","v":0.04},null,null,null,null,null,{"$f":"BL119","v":22},{"$f":"MAX(BF120,BF114)*BK119","v":0.04}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y161","v":23.5},{"$f":"BD120","v":-0.03},23.5,{"$f":"BF120","v":0.04}]
[null,null,null,null,"Author:",{"$f":"$C$1","v":"R. Abbott"},null,null,"Document Number:",{"$f":"$G$2","v":"AA-SM-291"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC121","v":23.5},{"$f":"0","v":0},23.5,{"$f":"BF119","v":0}]
[null,null,null,null,"Check:",{"$f":"$C$2","v":"J. Singh"},null,null,"Revision Level :",{"$f":"$G$3","v":"IR"},null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC119","v":22},{"$f":"BD119","v":0},22,{"$f":"BF119","v":0}]
[null,null,null,null,"Date:",{"$f":"$C$3","v":"20/10/2013"},null,null,"Page:",{"$f":"L124&\" of \"&$G$1","v":"3 of 3"},null,{"$f":"SUM($M$1:M123)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fastener 14 to End"]
[null,null,null,null,"Title:",{"$f":"$C$5","v":"STANDARD SPREADSHEET METHOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC121","v":23.5},0,{"$f":"BC125","v":23.5},0,null,null,null,"Fastener 14",{"$f":"IF(B117=0,0,1)","v":1},{"$f":"BE125","v":23.5},{"$f":"MIN(BD126,BD120)","v":-0.03}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC125","v":23.5},{"$f":"BD120","v":-0.03},{"$f":"BC126","v":23.5},{"$f":"BF120","v":0.04},null,null,null,null,null,{"$f":"BL125","v":23.5},{"$f":"MAX(BF126,BF120)*BK125","v":0.04}]
[null,{"$f":"$G$4","v":"SPLICE LOAD DISTRIBUTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC126+BE41","v":25.5},{"$f":"BD126","v":-0.03},{"$f":"BE126+BE43","v":27.5},{"$f":"BF126","v":0.04}]
[null,"Joint Load Distribution: Ref AFFDL-TR-67-184 Analytical Design Methods for Aircraft Structural Joints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC127","v":25.5},{"$f":"0","v":0},{"$f":"BE127","v":27.5},{"$f":"BF125","v":0}]
[null,"Fastener Stiffness: Ref Huth, On the influence of Rivet Pliability of Multi-Row Rivet Connections on Load Transfer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC125","v":23.5},{"$f":"BD125","v":0},23.5,{"$f":"BF125","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AA135","v":3250},null,{"$f":"AE103","v":27083.333333333336}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y136","v":4},{"$f":"I104","v":0},{"$f":"K104","v":3250},0,{"$f":"AC134","v":27083.333333333336}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"B104","v":0.19},{"$f":"C104","v":0.06},{"$f":"D104","v":0.02},4,{"$f":"I105","v":761.73037215580018},{"$f":"K105","v":2488.2696278441999},{"$f":"AD104","v":19043.259303895004},{"$f":"AE104","v":20735.580232035001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C85","v":0.06},{"$f":"G85","v":0.02},{"$f":"Y136+B85","v":5.5},{"$f":"Z136","v":761.73037215580018},{"$f":"AA136","v":2488.2696278441999},{"$f":"AB136","v":19043.259303895004},{"$f":"AC136","v":20735.580232035001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"B105","v":0.19},{"$f":"C105","v":0.06},{"$f":"D105","v":0.02},{"$f":"Y137","v":5.5},{"$f":"I106","v":1219.7930513894298},{"$f":"K106","v":2030.2069486105702},{"$f":"AD105","v":24395.861027788596},{"$f":"AE105","v":16918.39123842142},{"$f":"Z138","v":1219.7930513894298},1,{"$f":"Y136","v":4},{"$f":"AFF85","v":0},{"$f":"G104","v":761.73037215580018},{"$f":"Z104","v":66818.453697877208},{"$f":"AA104","v":200455.36109363163}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C86","v":0.06},{"$f":"G86","v":2.5000000000000001E-2},{"$f":"Y138+B86","v":7},{"$f":"Z138","v":1219.7930513894298},{"$f":"AA138","v":2030.2069486105702},{"$f":"AB138","v":24395.861027788596},{"$f":"AC138","v":16918.39123842142}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"B106","v":0.19},{"$f":"C106","v":0.06},{"$f":"D106","v":0.03},{"$f":"Y139","v":7},{"$f":"I107","v":1558.6761278149424},{"$f":"K107","v":1691.3238721850576},{"$f":"AD106","v":25977.935463582377},{"$f":"AE106","v":14094.365601542147},{"$f":"Z140","v":1558.6761278149424},2,{"$f":"Y138","v":5.5},{"$f":"AFF86","v":0},{"$f":"G105","v":458.06267923362958},{"$f":"Z105","v":40180.936774879789},{"$f":"AA105","v":120542.81032463936}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C87","v":0.06},{"$f":"G87","v":0.03},{"$f":"Y140+B87","v":8.5},{"$f":"Z140","v":1558.6761278149424},{"$f":"AA140","v":1691.3238721850576},{"$f":"AB140","v":25977.935463582377},{"$f":"AC140","v":14094.365601542147}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"B107","v":0.19},{"$f":"C107","v":0.06},{"$f":"D107","v":0.03},{"$f":"Y141","v":8.5},{"$f":"I108","v":1777.8197101119338},{"$f":"K108","v":1472.1802898880662},{"$f":"AD107","v":25397.424430170478},{"$f":"AE107","v":12268.169082400553},{"$f":"Z142","v":1777.8197101119338},3,{"$f":"Y140","v":7},{"$f":"AFF87","v":0},{"$f":"G106","v":338.88307642551274},{"$f":"Z106","v":29726.585651360765},{"$f":"AA106","v":59453.17130272153}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C88","v":0.06},{"$f":"G88","v":3.5000000000000003E-2},{"$f":"IF(V144=0,Y142,Y142+B88)","v":10},{"$f":"Z142","v":1777.8197101119338},{"$f":"AA142","v":1472.1802898880662},{"$f":"AB142","v":25397.424430170478},{"$f":"AC142","v":12268.169082400553}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"B108","v":0.19},{"$f":"C108","v":0.06},{"$f":"D108","v":0.04},{"$f":"Y143","v":10},{"$f":"I109","v":1934.225669271478},{"$f":"K109","v":1315.774330728522},{"$f":"AD108","v":24177.820865893475},{"$f":"AE108","v":10964.786089404352},{"$f":"Z144","v":1934.225669271478},4,{"$f":"Y142","v":8.5},{"$f":"AFF88","v":0},{"$f":"G107","v":219.1435822969913},{"$f":"Z107","v":19223.121254122045},{"$f":"AA107","v":38446.24250824409},null,0,{"$f":"AM145+AG138","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C89","v":0.06},{"$f":"G89","v":0.04},{"$f":"IF(V146=0,Y144,Y144+B89)","v":11.5},{"$f":"Z144","v":1934.225669271478},{"$f":"AA144","v":1315.774330728522},{"$f":"AB144","v":24177.820865893475},{"$f":"AC144","v":10964.786089404352},null,null,null,null,null,null,null,null,{"$f":"AFG85","v":0},{"$f":"AFM85","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"B109","v":0.19},{"$f":"C109","v":0.06},{"$f":"D109","v":0.04},{"$f":"Y145","v":11.5},{"$f":"I110","v":2030.9378986853901},{"$f":"K110","v":1219.0621013146099},{"$f":"AD109","v":25386.723733567374},{"$f":"AE109","v":10158.850844288416},{"$f":"Z146","v":2030.9378986853901},5,{"$f":"Y144","v":10},{"$f":"AFF89","v":0},{"$f":"G108","v":156.40595915954415},{"$f":"Z108","v":13719.820978907381},{"$f":"AA108","v":20579.731468361071},null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C90","v":0.06},{"$f":"G90","v":0.04},{"$f":"IF(V148=0,Y146,Y146+B90)","v":13},{"$f":"Z146","v":2030.9378986853901},{"$f":"AA146","v":1219.0621013146099},{"$f":"AB146","v":25386.723733567374},{"$f":"AC146","v":10158.850844288416},null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"B110","v":0.19},{"$f":"C110","v":0.06},{"$f":"D110","v":0.04},{"$f":"Y147","v":13},{"$f":"I111","v":2104.5195765803628},{"$f":"K111","v":1145.4804234196372},{"$f":"AD110","v":26306.494707254533},{"$f":"AE110","v":9545.6701951636442},{"$f":"Z148","v":2104.5195765803628},6,{"$f":"Y146","v":11.5},{"$f":"AFF90","v":0},{"$f":"G109","v":96.71222941391224},{"$f":"Z109","v":8483.5288959572135},{"$f":"AA109","v":12725.29334393582},null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C91","v":0.06},{"$f":"G91","v":0.04},{"$f":"IF(V150=0,Y148,Y148+B91)","v":14.5},{"$f":"Z148","v":2104.5195765803628},{"$f":"AA148","v":1145.4804234196372},{"$f":"AB148","v":26306.494707254533},{"$f":"AC148","v":9545.6701951636442},null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"B111","v":0.19},{"$f":"C111","v":0.06},{"$f":"D111","v":0.04},{"$f":"Y149","v":14.5},{"$f":"I112","v":2182.7891083369464},{"$f":"K112","v":1067.2108916630536},{"$f":"AD111","v":27284.863854211828},{"$f":"AE111","v":9701.9171969368508},{"$f":"Z150","v":2182.7891083369464},7,{"$f":"Y148","v":13},{"$f":"AFF91","v":0},{"$f":"G110","v":73.581677894972913},{"$f":"Z110","v":6454.5331486818341},{"$f":"AA110","v":9681.799723022752},null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C92","v":5.5E-2},{"$f":"G92","v":0.04},{"$f":"IF(V152=0,Y150,Y150+B92)","v":16},{"$f":"Z150","v":2182.7891083369464},{"$f":"AA150","v":1067.2108916630536},{"$f":"AB150","v":27284.863854211828},{"$f":"AC150","v":9701.9171969368508},null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"B112","v":0.19},{"$f":"C112","v":0.05},{"$f":"D112","v":0.04},{"$f":"Y151","v":16},{"$f":"I113","v":2266.2338737301579},{"$f":"K113","v":983.76612626984206},{"$f":"AD112","v":28327.923421626972},{"$f":"AE112","v":9837.6612626984206},{"$f":"Z152","v":2266.2338737301579},8,{"$f":"Y150","v":14.5},{"$f":"AFF92","v":0},{"$f":"G111","v":78.26953175658376},{"$f":"Z111","v":6865.7483997003292},{"$f":"AA111","v":10298.622599550496},null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C93","v":0.05},{"$f":"G93","v":0.04},{"$f":"IF(V154=0,Y152,Y152+B93)","v":17.5},{"$f":"Z152","v":2266.2338737301579},{"$f":"AA152","v":983.76612626984206},{"$f":"AB152","v":28327.923421626972},{"$f":"AC152","v":9837.6612626984206},null,null,null,null,null,null,null,null,{"$f":"AFG97","v":0},{"$f":"AFM97","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"B113","v":0.19},{"$f":"C113","v":0.05},{"$f":"D113","v":0.04},{"$f":"Y153","v":17.5},{"$f":"I114","v":2366.5128391591984},{"$f":"K114","v":883.48716084080161},{"$f":"AD113","v":29581.410489489979},{"$f":"AE113","v":9816.5240093422399},{"$f":"Z154","v":2366.5128391591984},9,{"$f":"Y152","v":16},{"$f":"AFF97","v":0},{"$f":"G112","v":83.444765393211725},{"$f":"Z112","v":8783.6595150749163},{"$f":"AA112","v":10979.574393843648},null,{"$f":"AFG98","v":0},{"$f":"AFM98","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C94","v":4.4999999999999998E-2},{"$f":"G94","v":0.04},{"$f":"IF(V156=0,Y154,Y154+B94)","v":19},{"$f":"Z154","v":2366.5128391591984},{"$f":"AA154","v":883.48716084080161},{"$f":"AB154","v":29581.410489489979},{"$f":"AC154","v":9816.5240093422399}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"B114","v":0.19},{"$f":"C114","v":0.04},{"$f":"D114","v":0.04},{"$f":"Y155","v":19},{"$f":"I115","v":2485.2695792341119},{"$f":"K115","v":764.73042076588808},{"$f":"AD114","v":31065.869740426398},{"$f":"AE114","v":9559.1302595736015},{"$f":"Z156","v":2485.2695792341119},10,{"$f":"Y154","v":17.5},{"$f":"AFF98","v":0},{"$f":"G113","v":100.27896542904045},{"$f":"Z113","v":10555.68057147794},{"$f":"AA113","v":13194.600714347429}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C95","v":0.04},{"$f":"G95","v":0.04},{"$f":"IF(V158=0,Y156,Y156+B95)","v":20.5},{"$f":"Z156","v":2485.2695792341119},{"$f":"AA156","v":764.73042076588808},{"$f":"AB156","v":31065.869740426398},{"$f":"AC156","v":9559.1302595736015}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"B115","v":0.19},{"$f":"C115","v":0.04},{"$f":"D115","v":0.04},{"$f":"Y157","v":20.5},{"$f":"I116","v":2651.529761737776},{"$f":"K116","v":598.47023826222403},{"$f":"AD115","v":33144.1220217222},{"$f":"AE115","v":8549.5748323174848},null,11,{"$f":"Y156","v":19},null,{"$f":"G114","v":118.75674007491367},{"$f":"Z114","v":15625.886851962325},{"$f":"AA114","v":15625.886851962325}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C96","v":3.5000000000000003E-2},{"$f":"G96","v":0.04},{"$f":"IF(V160=0,Y158,Y158+B96)","v":22},{"$f":"Z158","v":2651.529761737776},{"$f":"AA158","v":598.47023826222403},{"$f":"AB158","v":33144.1220217222},{"$f":"AC158","v":8549.5748323174848}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"B116","v":0.19},{"$f":"C116","v":0.03},{"$f":"D116","v":0.04},{"$f":"Y159","v":22},{"$f":"I117","v":2875.0122448375791},{"$f":"K117","v":374.98775516242085},{"$f":"AD116","v":35937.65306046974},{"$f":"AE116","v":6249.7959193736815},null,12,{"$f":"Y158","v":20.5},null,{"$f":"G115","v":166.26018250366425},{"$f":"Z115","v":21876.339803113719},{"$f":"AA115","v":21876.339803113719}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C97","v":0.03},{"$f":"G97","v":0.04},{"$f":"IF(V162=0,Y160,Y160+B97)","v":23.5},{"$f":"Z160","v":2875.0122448375791},{"$f":"AA160","v":374.98775516242085},{"$f":"AB160","v":35937.65306046974},{"$f":"AC160","v":6249.7959193736815}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"B117","v":0.19},{"$f":"C117","v":0.03},{"$f":"D117","v":0.04},{"$f":"Y161","v":23.5},{"$f":"I118","v":3250.0000000002451},{"$f":"K118","v":-2.4510882212780416E-10},{"$f":"AB161","v":35937.65306046974},{"$f":"AE117","v":-4.0851470354634029E-9},null,13,{"$f":"Y160","v":22},null,{"$f":"G116","v":223.48248309980332},{"$f":"Z116","v":39207.453175404087},{"$f":"AA116","v":29405.589881553067}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y162+Y135","v":27.5},{"$f":"Z162","v":3250.0000000002451},{"$f":"K118","v":-2.4510882212780416E-10},{"$f":"AB162","v":35937.65306046974},{"$f":"AC162","v":-4.0851470354634029E-9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"Y162","v":23.5},null,{"$f":"G117","v":374.98775516266602},{"$f":"Z117","v":65787.325467134389},{"$f":"AA117","v":49340.494100350792}]