{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Built-Up Bolted Glulam Column","Dropdowns"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":44,"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":"Built-Up Bolted Glulam Column","index":0,"n_rows":119,"n_cols":21,"rows_kept":119,"cut":false,"hidden":false,"merged":[[0,0,1,10],[29,2,29,3],[30,2,30,3],[19,3,19,5],[2,0,2,10],[46,4,46,6],[46,2,46,3],[8,1,8,4],[18,4,18,5],[17,4,17,5],[16,4,16,5],[100,1,101,10],[81,0,81,8],[33,1,33,10],[97,1,98,10],[34,0,34,10],[35,4,35,5]]}
["Design of Built-Up Bolted Glulam Column with Variable Number of Plies (between 2 ply and 5 ply) based on CAN/CSA-O86-09"]
[]
["For EDUCATIONAL PURPOSES ONLY - Not for use as a design aid"]
["Anthony Kwok, Carleton University, Ottawa, Ontario, Canada",null,null,null,null,null,null,null,null,null,"April 2014"]
[]
["DESIGN CRITERIA",null,null,null,null,null,null,null,null,null,"Printer Friendly"]
[]
["Species",null,null,null,null,null,"Grade"]
[null,"Spruce-Lodgepole Pine-Jack Pine",null,null,null,null,"14t-E",null,null,null,null,{"$f":"IF(B9=\"Douglas Fir-Larch\",\"Douglas_Fir_Larch\",IF(B9=\"Spruce-Lodgepole Pine-Jack Pine\",\"Spruce_Lodgepole_Pine_Jack_Pine\",IF(B9=\"Hem-Fir and Douglas Fir-Larch\",\"Hem_Fir_and_Douglas_Fir_Larch\",\"False\")))","v":"Spruce_Lodgepole_Pine_Jack_Pine"}]
[]
["SPECIFIED STRENGTHS AND MODULUS OF ELASTICITY"]
[null,"COMPRESSION PARALLEL",null,null,"fc =",{"$f":"IF(B9=\"Douglas Fir-Larch\",30.2,IF(B9=\"Spruce-Lodgepole Pine-Jack Pine\",25.2,\"N/A\"))","v":25.2},"MPa",null,"Table 6.3"]
[null,"MODULUS OF ELASTICITY",null,null,"E =",{"$f":"IF(B9=\"Douglas Fir-Larch\",VLOOKUP(G9,ElasticityModulusDFL,2,FALSE),IF(B9=\"Spruce-Lodgepole Pine-Jack Pine\",VLOOKUP(G9,ElasticityModulusSLPJP,2,FALSE),IF(B9=\"Hem-Fir and Douglas Fir-Larch\",VLOOKUP(G9,ElasticityModulusHFDFL,2,FALSE))))","v":10700},"MPa",null,"Table 6.3"]
[null,null,null,null,"E05 =",{"$f":"F13*0.87","v":9309},"MPa",null,"§ 6.5.8.5"]
[]
["MODIFICATION FACTORS"]
[null,"DURATION",null,null,"Standard Term",null,"KD = ",{"$f":"VLOOKUP(E17,DurationFactor,2,FALSE)","v":1},"§ 6.4.1"]
[null,"SYSTEM",null,null,"Unsupported",null,"KH = ",{"$f":"VLOOKUP(E18,SystemFactor,2,FALSE)","v":1},"§ 6.4.3"]
[null,"SERVICE CONDITION",null,null,"Wet",null,"KSC = ",{"$f":"VLOOKUP(E19,ServiceFactor,2,FALSE)","v":0.75},"§ 6.4.2 & Table 6.4.2",null,null,{"$f":"IF(E19=\"Dry\",\"2\",\"3\")","v":"3"}]
[null,"TREATMENT",null,"Treated - Unincised <89mm",null,null,"KT = ",{"$f":"VLOOKUP(D20,TreatmentFactor,L19,FALSE)","v":0.85},"§ 6.4.4"]
[null,"MODULUS OF ELASTICITY",null,null,null,null,"KSE = ",{"$f":"VLOOKUP(E19,ModulusElasticity,2,FALSE)","v":0.9},"Table 6.4.2"]
[]
["GEOMETRY AND CONNECTION DETAILS"]
[null,"# OF PLIES",null,null,null,4]
[null,"LENGTH OF MEMBER",null,null,"L = ",2000,"mm"]
[null,"WIDTH",null,null,"W = ",140,"mm"]
[null,"DEPTHS",null,null,"D = ",76,"mm"]
[null,"BOLTS CONECTION"]
[null,null,"BOLT DIAMETER",null,"dF = ",0.125,"in",null,null,null,null,{"$f":"IF(F29>=1/4,\"True\",\"False\")","v":"False"}]
[null,null,"BOLT SPACING (PAR.)",null,"a = ",100,"mm",null,null,null,null,{"$f":"IF(F30<6*F27,\"True\",\"False\")","v":"True"}]
[null,null,"BOLT SPACING (PERP.)",null,"c = ",10,"mm",null,null,null,null,{"$f":"IF(F31<10*F29*25.4,\"True\",\"False\")","v":"True"}]
[null,null,"ROWS OF BOLTS",null,null,1,null,null,null,null,null,{"$f":"IF(F26<F27*3,\"True\",IF(F32>=2,\"True\",\"False\"))","v":"True"}]
[]
[null,{"$f":"IF(L29=\"True\",IF(L30=\"True\",IF(L31=\"True\",IF(L32=\"True\",\"FROM THE SPACING REQUIREMENTS, THE BUILT-UP MEMBER IS ADEQUATELY BOLTED. § 5.5.6.4.3\",\"FROM THE SPACING REQUIREMENTS, THE BUILT-UP MEMBER IS INADEQUATELY BOLTED. § 5.5.6.4.3\"),\"FROM THE SPACING REQUIREMENTS, THE BUILT-UP MEMBER IS INADEQUATELY BOLTED. § 5.5.6.4.3\"),\"FROM THE SPACING REQUIREMENTS, THE BUILT-UP MEMBER IS INADEQUATELY BOLTED. § 5.5.6.4.3\"),\"FROM THE SPACING REQUIREMENTS, THE BUILT-UP MEMBER IS INADEQUATELY BOLTED. § 5.5.6.4.3\")","v":"FROM THE SPACING REQUIREMENTS, THE BUILT-UP MEMBER IS INADEQUATELY BOLTED. § 5.5.6.4.3"},null,null,null,null,null,null,null,null,null,{"$f":"IF(F29>=(1/4),IF(F30<(6*F27),IF(AND(F26>(3*F27),(F32>=2)),\"Adequate\",\"Inadequate\"),\"Inadequate\"),\"Inadequate\")","v":"Inadequate"}]
[]
[null,"END RESTRAINTS",null,null,"Fixed Free",null,"Ke =",{"$f":"VLOOKUP(E36,Dropdowns!A53:B57,2,FALSE)","v":1.2},"Table A.5.5.6.1"]
[]
[]
["UNFACTORED LOADS (+ FOR COMPRESSION)"]
[null,null,"DEAD",null,"D = ",200,"kN"]
[null,null,"LIVE ",null,"L = ",150,"kN"]
[null,null,"SNOW ",null,"S = ",250,"kN"]
[null,null,"WIND ",null,"W = ",0,"kN"]
[null,null,"EARTHQUAKE",null,"E = ",0,"kN"]
[]
["LOAD COMBINATIONS (ULS)",null,null,null,"Table 4.2.4.1"]
[null,null,"COMBINATION",null,"FACTORED LOADS",null,null,"KD",null,null,null,"LOAD",null,"CASE #"]
[null,1,"1.4D",null,null,{"$f":"1.4*$F$40","v":280},"kN",0.65,null,null,null,{"$f":"F48","v":280},null,{"$f":"B48","v":1}]
[null,"2a","1.25D + 1.5L",null,null,{"$f":"1.25*$F$40 + 1.5*$F$41","v":475},"kN",1,null,null,null,475,null,"2a"]
[null,"2b","1.25D + 1.5L + 0.5S",null,null,{"$f":"1.25*$F$40 + 1.5*$F$41 + 0.5*$F$42","v":600},"kN",1,null,null,null,600,null,"2b"]
[null,"2c","1.25D + 1.5L + 0.4W",null,null,{"$f":"1.25*$F$40 + 1.5*$F$41 + 0.4*$F$43","v":475},"kN",1.1499999999999999,null,null,null,475,null,"2c"]
[null,"2d","0.9D + 1.5L",null,null,{"$f":"0.9*$F$40+1.5*$F$41","v":405},"kN",1,null,null,null,405,null,"2d"]
[null,"2e","0.9D + 1.5L + 0.5S",null,null,{"$f":"0.9*$F$40+1.5*$F$41+0.5*$F$42","v":530},"kN",1,null,null,null,530,null,"2e"]
[null,"2f","0.9D + 1.5L + 0.4W",null,null,{"$f":"0.9*$F$40+1.5*$F$41+0.4*$F$43","v":405},"kN",1.1499999999999999,null,null,null,405,null,"2f"]
[null,"3a","1.25D + 1.5S",null,null,{"$f":"1.25*$F$40+1.5*$F$42","v":625},"kN",1,null,null,null,625,null,"3a"]
[null,"3b","1.25D + 1.5S + 0.5L",null,null,{"$f":"1.25*$F$40+1.5*$F$42+0.5*$F$41","v":700},"kN",1,null,null,null,700,null,"3b"]
[null,"3c","1.25D + 1.5S + 0.4W",null,null,{"$f":"1.25*$F$40+1.5*$F$42+0.4*$F$43","v":625},"kN",1.1499999999999999,null,null,null,625,null,"3c"]
[null,"3d","0.9D + 1.5S ",null,null,{"$f":"0.9*$F$40+1.5*$F$42","v":555},"kN",1,null,null,null,555,null,"3d"]
[null,"3e","0.9D + 1.5S + 0.5L",null,null,{"$f":"0.9*$F$40+1.5*$F$42+0.5*$F$41","v":630},"kN",1,null,null,null,630,null,"3e"]
[null,"3f","0.9D + 1.5S + 0.4W",null,null,{"$f":"0.9*$F$40+1.5*$F$42+0.4*$F$43","v":555},"kN",1.1499999999999999,null,null,null,555,null,"3f"]
[null,"4a","1.25D + 1.4W",null,null,{"$f":"1.25*$F$40+1.4*$F$43","v":250},"kN",1.1499999999999999,null,null,null,250,null,"4a"]
[null,"4b","1.25D + 1.4W + 0.5L",null,null,{"$f":"1.25*$F$40+1.4*$F$43 + 0.5*$F$41","v":325},"kN",1.1499999999999999,null,null,null,325,null,"4b"]
[null,"4c","1.25D + 1.4W + 0.5S",null,null,{"$f":"1.25*$F$40+1.4*$F$43 + 0.5*$F$42","v":375},"kN",1.1499999999999999,null,null,null,375,null,"4c"]
[null,"4d","0.9D + 1.4W",null,null,{"$f":"0.9*$F$40+1.4*$F$43","v":180},"kN",1.1499999999999999,null,null,null,180,null,"4d"]
[null,"4e","0.9D + 1.4W + 0.5L",null,null,{"$f":"0.9*$F$40+1.4*$F$43+0.5*$F$41","v":255},"kN",1.1499999999999999,null,null,null,255,null,"4e"]
[null,"4f","0.9D + 1.4W + 0.5S",null,null,{"$f":"0.9*$F$40+1.4*$F$43+0.5*$F$42","v":305},"kN",1.1499999999999999,null,null,null,305,null,"4f"]
[null,"5a","1.0D + 1.0E",null,null,{"$f":"$F$40+$F$44","v":200},"kN",1.1499999999999999,null,null,null,200,null,"5a"]
[null,"5b","1.0D + 1.0E + 0.5L",null,null,{"$f":"$F$40+$F$44+0.5*$F$41","v":275},"kN",1.1499999999999999,null,null,null,275,null,"5b"]
[null,"5c","1.0D + 1.0E + 0.25S",null,null,{"$f":"$F$40+$F$44+0.25*$F$42","v":262.5},"kN",1.1499999999999999,null,null,null,262.5,null,"5c"]
[]
[null,{"$f":"IF(MIN(L48)<>0,CONCATENATE(\"THE GOVERNING LOAD CASE FOR LONG TERM DURATIONS IS \",MIN(L48),\" kN FOR LOAD CASE \",VLOOKUP(MIN(L48),$L$48:$N$69,2,FALSE),\".\"))","v":"THE GOVERNING LOAD CASE FOR LONG TERM DURATIONS IS 280 kN FOR LOAD CASE ."}]
[null,{"$f":"IF(MIN(F49:F50,F52:F53,F55,F55:F56,F58:F59)<>0,CONCATENATE(\"THE GOVERNING LOAD CASE FOR STANDARD TERM DURATIONS IS \",MIN(F49:F50,F52:F53,F55,F55:F56,F58:F59),\" kN FOR LOAD CASE \",VLOOKUP(MIN(F49:F50,F52:F53,F55,F55:F56,F58:F59),$L$48:$N$69,2,FALSE),\".\"))","v":"THE GOVERNING LOAD CASE FOR STANDARD TERM DURATIONS IS 405 kN FOR LOAD CASE ."}]
[null,{"$f":"IF(MIN(F51,F54,F57,F60:F69)<>0,CONCATENATE(\"THE GOVERNING LOAD CASE FOR SHORT TERM DURATIONS IS \",MIN(F51,F54,F57,F60:F69),\" kN FOR LOAD CASE \",VLOOKUP(MIN(F51,F54,F57,F60:F69),$L$48:$N$69,2,FALSE),\".\"))","v":"THE GOVERNING LOAD CASE FOR SHORT TERM DURATIONS IS 180 kN FOR LOAD CASE ."}]
[]
[]
[]
[]
[]
[]
["FACTORED RESISTANCE OF BUILT-UP GLULAM MEMBER"]
[]
["Pr = φFcAKzcgKc",null,null,null,null,null,null,null,null,"§ 6.5.8.4.2"]
[]
["STRONG AXIS BUCKLING (Y-Y AXIS)",null,null,null,null,"WEAK AXIS BUCKLING (X-X AXIS)"]
[]
[null,"Ccy = ",{"$f":"IF($L$34=\"Adequate\",$F$25*$H$36/MAX($F$27*$F$24,$F$26),($F$25*$H$36)/MAX($F$27,$F$26))","v":17.142857142857142},null,null,"Ccx = ",{"$f":"IF($L$34=\"Adequate\",$F$25*$H$36/MIN($F$27*$F$24,$F$26),($F$25*$H$36)/MIN($F$26,$F$27))","v":31.578947368421051},null,null,"SLENDERNESS RATIO"]
[]
[null,null,null,"φ = ",0.8]
[null,null,null,"Fc = ",{"$f":"$F$12*($H$17*$H$18*$H$19*$H$20)","v":16.064999999999998},"MPa",null,null,null,"SPECIFIED STRENGTH"]
[null,null,null,"A = ",{"$f":"IF($L$34=\"Adequate\",$F$24*$F$26*$F$27,$F$26*$F$27)","v":10640},"mm^3",null,null,null,"X - SECTION AREA",null,"Volume of Member"]
[null,null,null,"Kzcg = ",{"$f":"IF((0.68*($L$91)^(-0.13))>1,1,(0.68*($L$91)^(-0.13)))","v":1},null,null,null,null,"VOLUME FACTOR",null,{"$f":"($E$90*$F$25)/(1000^3)","v":2.128E-2},null,"m^3"]
[]
[null,"Kcx = ",{"$f":"((1+($E$89*$E$91*$C$86^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.75488127416345085},null,null,"Kcy = ",{"$f":"((1+($E$89*$E$91*$G$86^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.33006093948687043},null,null,"SLENDERNESS FACTOR"]
[null,"Pry = ",{"$f":"IF($L$34=\"Adequate\",($E$88*$E$89*$E$90*$E$91*$C$93)/1000,(($E$88*$E$89*$E$90*$E$91*$C$93)/1000)*$F$24)","v":412.90580480895142},null,null,"Prx = ",{"$f":"IF($L$34=\"Adequate\",($E$88*$E$89*$E$90*$E$91*$G$93)/1000,(($E$88*$E$89*$E$90*$E$91*$G$93)/1000)*$F$24)","v":180.53710234878062},null,null,"COMPRESSIVE RESISTANCE",null,null,"FACTORED LOAD"]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MIN($L$48:$L$69)","v":180}]
["COMMENTS:",null,null,null,null,null,null,null,null,null,null,1,{"$f":"MIN($L$48:$L$69)","v":180}]
[null,{"$f":"IF(C94>G94,\"Prx WILL GOVERN SINCE Prx < Pry.\",\"Pry WILL GOVERN SINCE Prx > Pry.\")","v":"Prx WILL GOVERN SINCE Prx < Pry."},null,null,null,null,null,null,null,null,null,2,{"$f":"MIN($L$48:$L$69)","v":180}]
[null,{"$f":"IF(L34=\"Inadequate\",\"SINCE THE MEMBERS ARE INADEQUATELY BOLTED, THE RESISTANCE OF EACH MEMBER WAS MULTIPLIED BY THE COLLECTIVE NUMBER OF PLIES.\",\"THE BUILT-UP MEMBER WAS ADEQUATELY BOLTED.\")","v":"SINCE THE MEMBERS ARE INADEQUATELY BOLTED, THE RESISTANCE OF EACH MEMBER WAS MULTIPLIED BY THE COLLECTIVE NUMBER OF PLIES."},null,null,null,null,null,null,null,null,null,3,180]
[null,null,null,null,null,null,null,null,null,null,null,4,180]
[null,{"$f":"CONCATENATE(\"THEREFORE, THE VALUE FOR Prx is \",TEXT(G94,0),\" kN, AND Pry IS \",TEXT(C94,0),\" kN.\")","v":"THEREFORE, THE VALUE FOR Prx is 181 kN, AND Pry IS 413 kN."},null,null,null,null,null,null,null,null,null,5,180]
[null,{"$f":"IF(MIN(G94,C94)>MIN(F48:F69),CONCATENATE(\"THE RESISTANCE OF THE BUILT-UP MEMBER IS SUFFICIENT ENOUGH TO RESIST THE GOVERNING FACTORED LOAD. \", TEXT(MIN(G94,C94),0),\" kN > \",MIN(F48:F69), \" kN\"),CONCATENATE(\"THE RESISTANCE OF THE BUILT-UP MEMBER IS NOT ENOUGH TO RESIST THE GOVERNING FACTORED LOAD. \", TEXT(MIN(G94,C94),0),\" kN < \",MIN(F48:F69), \" kN\"))","v":"THE RESISTANCE OF THE BUILT-UP MEMBER IS SUFFICIENT ENOUGH TO RESIST THE GOVERNING FACTORED LOAD. 181 kN > 180 kN"},null,null,null,null,null,null,null,null,null,6,180]
[null,null,null,null,null,null,null,null,null,null,null,"Adequate"]
[null,null,null,null,null,null,null,null,null,null,null,"PLIES","Ccy","Ccx","A","Kczg","Kcy","Kcx","Pry","Prx","Governing Case"]
["ANALYSIS",null,null,null,null,null,null,null,null,null,null,2,{"$f":"$F$25*$H$36/MAX($F$27*L104,$F$26)","v":15.789473684210526},{"$f":"$F$25*$H$36/MIN($F$27*L104,$F$26)","v":17.142857142857142},{"$f":"L104*$F$26*$F$27","v":21280},{"$f":"IF((0.68*((O104*$F$25)/1000^3)^(-0.13))>1,1,(0.68*((O104*$F$25)/1000^3)^(-0.13)))","v":1},{"$f":"((1+($E$89*P104*M104^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.79762757304829512},{"$f":"((1+($E$89*$E$91*N104^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.75488127416345085},{"$f":"($E$88*$E$89*O104*$P104*Q104)/1000","v":218.14361162441912},{"$f":"($E$88*$E$89*O104*$P104*R104)/1000","v":206.45290240447571},{"$f":"MIN(T104)","v":206.45290240447571}]
[null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"$F$25*$H$36/MAX($F$27*L105,$F$26)","v":10.526315789473685},{"$f":"$F$25*$H$36/MIN($F$27*L105,$F$26)","v":17.142857142857142},{"$f":"L105*$F$26*$F$27","v":31920},0.97240422808943816,0.9318785975909134,{"$f":"((1+($E$89*$E$91*N105^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.75488127416345085},{"$f":"($E$88*$E$89*O105*$P105*Q105)/1000","v":371.74041163744238},{"$f":"($E$88*$E$89*O105*$P105*R105)/1000","v":301.13351279917242},301.13351279917242]
[null,null,null,null,null,null,null,null,null,null,null,4,7.8947368421052628,17.142857142857142,42560,0.93670923674646089,0.97114958103864268,{"$f":"((1+($E$89*$E$91*N106^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.75488127416345085},{"$f":"($E$88*$E$89*O106*$P106*Q106)/1000","v":497.58040135458003},{"$f":"($E$88*$E$89*O106*$P106*R106)/1000","v":386.77268127077605},386.77268127077605]
[null,null,null,null,null,null,null,null,null,null,null,5,6.3157894736842106,17.142857142857142,53200,0.90992689347207922,0.9854397863050981,{"$f":"((1+($E$89*$E$91*N107^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.75488127416345085},{"$f":"($E$88*$E$89*O107*$P107*Q107)/1000","v":613.08253265864744},{"$f":"($E$88*$E$89*O107*$P107*R107)/1000","v":469.6426203329973},469.6426203329973]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Inadequate"]
[null,null,null,null,null,null,null,null,null,null,null,"PLIES","Ccy","Ccx","A","Kczg","Kcy","Kcx","Pry","Prx","Governing Case"]
[null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"$F$25*$H$36/MAX($F$27,$F$26)","v":17.142857142857142},{"$f":"$F$25*$H$36/MIN($F$27,$F$26)","v":31.578947368421051},{"$f":"$F$26*$F$27","v":10640},{"$f":"IF((0.68*((O111*$F$25)/1000^3)^(-0.13))>1,1,(0.68*((O111*$F$25)/1000^3)^(-0.13)))","v":1},{"$f":"((1+($E$89*P111*M111^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.75488127416345085},{"$f":"((1+($E$89*P111*N111^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.33006093948687043},{"$f":"($E$88*$E$89*O111*$P111*Q111)/1000","v":103.22645120223785},{"$f":"($E$88*$E$89*O111*$P111*R111)/1000","v":45.134275587195155},{"$f":"MIN(T111)*L111","v":90.268551174390311}]
[null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"$F$25*$H$36/MAX($F$27,$F$26)","v":17.142857142857142},{"$f":"$F$25*$H$36/MIN($F$27,$F$26)","v":31.578947368421051},{"$f":"$F$26*$F$27","v":10640},{"$f":"IF((0.68*((O112*$F$25)/1000^3)^(-0.13))>1,1,(0.68*((O112*$F$25)/1000^3)^(-0.13)))","v":1},{"$f":"((1+($E$89*P112*M112^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.75488127416345085},{"$f":"((1+($E$89*P112*N112^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.33006093948687043},{"$f":"($E$88*$E$89*O112*$P112*Q112)/1000","v":103.22645120223785},{"$f":"($E$88*$E$89*O112*$P112*R112)/1000","v":45.134275587195155},{"$f":"MIN(T112)*L112","v":135.40282676158546}]
[null,null,null,null,null,null,null,null,null,null,null,4,17.142857142857142,31.578947368421051,10640,1,{"$f":"((1+($E$89*P113*M113^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.75488127416345085},0.33006093948687043,{"$f":"($E$88*$E$89*O113*$P113*Q113)/1000","v":103.22645120223785},{"$f":"($E$88*$E$89*O113*$P113*R113)/1000","v":45.134275587195155},180.53710234878062]
[null,null,null,null,null,null,null,null,null,null,null,5,17.142857142857142,31.578947368421051,10640,1,{"$f":"((1+($E$89*P114*M114^3)/(35*$F$14*$H$21*$H$20))^(-1))","v":0.75488127416345085},0.33006093948687043,{"$f":"($E$88*$E$89*O114*$P114*Q114)/1000","v":103.22645120223785},{"$f":"($E$88*$E$89*O114*$P114*R114)/1000","v":45.134275587195155},225.67137793597578]
[]
[]
["Reference"]
["Canadian Standards Association (CSA) (2010) O86-09 Engineering design in wood with Update No.1. "]
[null,"Mississauga, ON: Canadian Standards Association."]

{"sheet":"Dropdowns","index":1,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Types and Grades"]
["Douglas Fir-Larch","Spruce-Lodgepole Pine-Jack Pine","Hem-Fir and Douglas Fir-Larch",null,"Grades",null,null,null,"Douglas_Fir_Larch","Spruce_Lodgepole_Pine_Jack_Pine","Hem_Fir_and_Douglas_Fir_Larch"]
["24f-E","20f-E","24f-E",null,"Douglas Fir-Larch",null,null,null,"24f-E","20f-E","24f-E"]
["24f-EX","20f-EX","24-EX",null,"Spruce-Lodgepole Pine-Jack Pine",null,null,null,"24f-EX","20f-EX","24-EX"]
["20f-E","14t-E",null,null,"Hem-Fir and Douglas Fir-Larch",null,null,null,"20f-E","14t-E"]
["20f-EX","12c-E",null,null,null,null,null,null,"20f-EX","12c-E"]
["18t-E",null,null,null,null,null,null,null,"18t-E"]
["16c-E",null,null,null,null,null,null,null,"16c-E"]
[]
["Grade","Modulus of Elasticity"]
["24f-E",12800]
["24f-EX",12800]
["20f-E",12400]
["20f-EX",12400]
["18t-E",13800]
["16c-E",12400]
["20f-E",10300]
["20f-EX",10300]
["14t-E",10700]
["12c-E",9700]
["24f-E",13100]
["24-EX",13100]
[]
["Duration Factor"]
["Short Term",1.1499999999999999]
["Standard Term",1]
["Long Term",0.65]
[]
["System Factor"]
["Mutually Supported",1]
["Unsupported",1]
[]
["Service Condition Factor"]
["Wet",0.75]
["Dry",1]
[]
["Treatment Factor"]
["Untreated",1,1]
["Treated - Unincised",1,1]
["Treated - Unincised <89mm",0.75,0.85]
[]
["Number of Plies"]
[2]
[3]
[4]
[5]
[]
["Modulus of Elasticity"]
["Dry",1]
["Wet",0.9]
[]
["End Restraints","Ke"]
["Fixed Ends",0.65]
["Fixed - Pinned",0.8]
["Pinned Ends",1]
["Fixed Free",1.2]
["Pinned Free",2]