{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cálculo","Cantoneira","Compressão","fy"],"not_rendered":{"charts":1,"images":10,"macros":1,"external_links":0,"defined_names":20,"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":"Cálculo","index":0,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Verificação dos Esforços Resistentes de Compressão de Cantoneiras de Abas iguais"]
["NRd=",{"$f":"IF(E15<=200,ROUND(Compressão!B28,2),\"-\")","v":79.88},"kN","Dupla"]
["NRd=",{"$f":"IF(E16<=200,ROUND(Compressão!B30,2),\"-\")","v":39.799999999999997},"kN","Simples"]
[]
["Perfil L:",19,null,"E=",200000,"MPa"]
["Aço:",1,null,"G=",77000,"MPa"]
["fy=",{"$f":"IF(B6=1,fy!B2,IF(B6=2,fy!B3,fy!B4))","v":250},"MPa ","ga1=",1.1000000000000001,"Obs: Ações normais"]
["fu=",{"$f":"IF(B6=1,fy!C2,IF(B6=2,fy!C3,fy!C4))","v":400},"MPa ",null,"Comprimentos:"]
["b=",50.8,"mm","Lx=",2.4,"m (dupla)"]
["t=",6.35,"mm","Lx1=",1.7150000000000001,"m (simples)"]
["A=",6.06,"cm2","k=",{"$f":"0.5*rz/rx","v":0.3193548387096774}]
["Ix=",14.6,"cm4","Lx10=",{"$f":"ROUND(E9/E17,3)","v":0.6}]
["Wx=",4.0999999999999996,"cm3","Kx=",1,"coef flamb (dupla)"]
["rx=",1.55,"cm","Kx1=",1,"coef flamb (simples)"]
["rz=",0.99,"cm","KL/r=",{"$f":"Kx*Lx*100/rx","v":154.83870967741936},"dupla",{"$f":"IF(E15>200,\"Erro! - Esbeltez superior à limite\",\"-\")","v":"-"}]
["x=",1.5,"cm","KL/r=",{"$f":"Kx_1*Lx_1*100/rz","v":173.23232323232324},"simples",{"$f":"IF(E16>200,\"Erro! - Esbeltez superior à limite\",\"-\")","v":"-"}]
[null,null,null,"n =",{"$f":"MAX(ROUNDUP(1/E11,0),2)","v":4},"espaçadores NBR 8800-5.3.4.2"]
[null,null,null,"n =",{"$f":"ROUNDDOWN(Lx/Lx_1,0)","v":1},"espaçadores calculados",null,null,"b (mm)","t (mm)","Lx (m)","Lx1 (m)","NRd Dupla (kN)","NRd Simples (kN)","KLx/rx Dupla","KLz/rz Simples"]
[null,null,null,null,null,null,null,null,{"$f":"b","v":50.8},{"$f":"t","v":6.35},{"$f":"Lx","v":2.4},{"$f":"Lx_1","v":1.7150000000000001},{"$f":"B2","v":79.88},{"$f":"B3","v":39.799999999999997},{"$f":"E15","v":154.83870967741936},{"$f":"E16","v":173.23232323232324}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Relação Lx/Lx1"]
[null,null,null,null,null,null,null,null,50.8,6.35,1.2,0.11600000000000001,200.53,100.13,77.41935483870968,11.717171717171718,{"$f":"K21/L21","v":10.344827586206895}]
[null,null,null,null,null,null,null,null,50.8,6.35,1.4,0.38,179.05,89.39,90.322580645161281,38.383838383838388,{"$f":"K22/L22","v":3.6842105263157894}]
[null,null,null,null,null,null,null,null,50.8,6.35,1.6,0.64700000000000002,156.72999999999999,78.37,103.2258064516129,65.353535353535364,2.472952086553323]
[null,null,null,null,null,null,null,null,50.8,6.35,1.8,0.91600000000000004,134.97,67.349999999999994,116.12903225806451,92.52525252525254,1.965065502183406]
[null,null,null,null,null,null,null,null,50.8,6.35,2,1.18,114.31,57.02,129.03225806451613,119.1919191919192,1.6949152542372883]
[null,null,null,null,null,null,null,null,50.8,6.35,2.2000000000000002,1.446,95.03,47.52,141.93548387096774,146.06060606060606,1.521438450899032]
[null,null,null,null,null,null,null,null,50.8,6.35,2.4,1.7150000000000001,79.88,39.799999999999997,154.83870967741936,173.23232323232324,1.3994169096209912]
[null,null,null,null,null,null,null,null,50.8,6.35,2.6,1.976,68.040000000000006,34.020000000000003,167.74193548387098,199.59595959595958,1.3157894736842106]

{"sheet":"Cantoneira","index":1,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,4]]}
["b",null," Peso Nominal"," t",null," Área"," Ix=Iy"," Wx=Wy"," rx=ry"," rz mín."," x"]
["pol","mm","kg/m","pol","mm"," cm2"," cm4","cm3"," cm"," cm"," cm"]
["1/2”",12.7,0.55000000000000004,"1/8”",3.18,0.7,0.1,0.11,0.37,0.25,0.43]
["5/8”",15.88,0.71,"1/8”",3.18,0.9,0.2,0.19,0.47,0.32,0.51]
["3/4”",19.05,0.87,"1/8”",3.18,1.1100000000000001,0.36,0.27,0.56999999999999995,0.38,0.59]
["7/8”",22.2,1.04,"1/8”",3.18,1.32,0.57999999999999996,0.38,0.66,0.46,0.66]
["1” x 1” x 1/8\"",25.4,1.19,"1/8”",3.18,1.48,0.83,0.49,0.79,0.48,0.76]
["1” x 1” x 3/16\"",25.4,1.73,"3/16”",4.76,2.19,1.25,0.66,0.76,0.48,0.81]
["1” x 1” x 1/4\"",25.4,2.2200000000000002,"1/4”",6.35,2.84,1.66,0.98,0.76,0.48,0.86]
["1.1/4”x1.1/4”x1/8\"",31.75,1.5,"1/8”",3.18,1.93,1.67,0.82,0.97,0.64,0.89]
["1.1/4”x1.1/4”x3/16",31.75,2.2000000000000002,"3/16”",4.76,2.77,2.5,1.1499999999999999,0.97,0.61,0.97]
["1.1/4”x1.1/4”x1/4\"",31.75,2.86,"1/4”",6.35,3.62,3.33,1.47,0.94,0.61,1.02]
["1.1/2”x1.1/2”x1/8\"",38.1,1.83,"1/8”",3.18,2.3199999999999998,3.33,1.1499999999999999,1.17,0.76,1.07]
["1.1/2”x1.1/2”x3/16",38.1,2.68,"3/16”",4.76,3.42,4.58,1.64,1.17,0.74,1.1200000000000001]
["1.1/2”x1.1/2”x1/4\"",38.1,3.48,"1/4”",6.35,4.45,5.83,2.13,1.1499999999999999,0.74,1.19]
["1.3/4”x1.3/4”x1/8\"",44.45,2.14,"1/8”",3.18,2.71,5.41,1.64,1.4,0.89,1.22]
["1.3/4”x1.3/4”x3/16",44.45,3.15,"3/16”",4.76,4,7.5,2.2999999999999998,1.37,0.89,1.3]
["1.3/4”x1.3/4”x1/4\"",44.45,4.12,"1/4”",6.35,5.22,9.57,3.13,1.35,0.86,1.35]
["2” x 2” x 1/8\"",50.8,2.46,"1/8”",3.18,3.1,7.91,2.13,1.6,1.02,1.4]
["2” x 2” x 3/16\"",50.8,3.63,"3/16”",4.76,4.58,11.7,3.13,1.58,1.02,1.45]
["2” x 2” x 1/4\"",50.8,4.74,"1/4”",6.35,6.06,14.6,4.0999999999999996,1.55,0.99,1.5]
["2” x 2” x 5/16\"",50.8,5.83,"5/16”",7.94,7.42,17.5,4.91,1.53,0.99,1.55]
["2” x 2” x 3/8\"",50.8,6.99,"3/8”",9.52,8.76,20,5.73,1.5,0.99,1.63]
["2.1/2”x2.1/2”x3/16\"",63.5,4.57,"3/16”",4.76,5.8,23,4.91,1.98,1.24,1.75]
["2.1/2”x2.1/2”x1/4\"",63.5,6.1,"1/4”",6.35,7.67,29,6.4,1.96,1.24,1.83]
["2.1/2”x2.1/2”x5/16\"",63.5,7.44,"5/16”",7.94,9.48,35,7.87,1.93,1.24,1.88]
["2.1/2”x2.1/2”x3/8\"",63.5,8.7799999999999994,"3/8”",9.52,11.16,41,9.35,1.91,1.22,1.93]
["3” x 3” x 3/16\"",76.2,5.52,"3/16”",4.76,7.03,40,7.21,2.39,1.5,2.08]
["3” x 3” x 1/4\"",76.2,7.29,"1/4”",6.35,9.2899999999999991,50,9.5,2.36,1.5,2.13]
["3” x 3” x 5/16\"",76.2,9.07,"5/16”",7.94,11.48,62,11.6,2.34,1.5,2.21]
["3” x 3” x 3/8\"",76.2,10.71,"3/8”",9.52,13.61,75,13.6,2.31,1.47,2.2599999999999998]
["3” x 3” x 1/2\"",76.2,14,"1/2”",12.7,17.739999999999998,91,18,2.29,1.47,2.36]
["3.1/2”x3.1/2”x1/4\"",88.9,8.56,"1/4”",6.35,10.9,83.7,13,2.77,1.76,2.46]
["3.1/2”x3.1/2”x5/16\"",88.9,10.59,"5/16”",7.94,13.5,102,16,2.75,1.75,2.52]
["3.1/2”x3.1/2”x3/8\"",88.9,12.58,"3/8”",9.52,16,121,19.2,2.75,1.75,2.58]
["4” x 9,81",101.6,9.81,"1/4”",6.35,12.51,125,16.399999999999999,3.17,2,2.77]
["4” x 12,19",101.6,12.19,"5/16”",7.94,15.48,154,21.3,3.15,2,2.84]
["4” x 14,57",101.6,14.57,"3/8”",9.52,18.45,183,24.6,3.12,2,2.9]
["4” x 16,8",101.6,16.8,"7/16”",11.11,21.35,208,29.5,3.12,1.98,2.95]
["4” x 19,03",101.6,19.03,"1/2”",12.7,24.19,233,32.799999999999997,3.1,1.98,3]
["5” x 12,34",127,12.34,"1/4”",6.35,15.73,251.63,27.09,4,2.5299999999999998,3.41]
["5” x 15,31",127,15.31,"5/16”",7.94,19.5,308,33.4,3.97,2.5299999999999998,3.47]
["5” x 18,3",127,18.3,"3/8”",9.52,23.29,362,39.5,3.94,2.5099999999999998,3.53]
["5” x 23,52",127,23.52,"7/16”",11.11,26.96,416.68,45.71,3.93,2.5,3.58]
["5” x 24,1",127,24.1,"1/2”",12.7,30.64,470,52.5,3.91,2.4900000000000002,3.63]
["5” x 29,8",127,29.8,"5/8”",15.88,37.799999999999997,566,64,3.86,2.46,3.76]
["6” x 22,2",152.4,22.2,"3/8”",9.52,28.1,641,57.4,4.78,3.02,4.17]
["6” x 29,2",152.4,29.2,"1/2”",12.7,37.090000000000003,828,75.400000000000006,4.72,3,4.2699999999999996]
["6” x 36",152.4,36,"5/8”",15.88,45.86,1007,93.5,4.67,2.97,4.3899999999999997]
["6” x 42,7",152.4,42.7,"3/4”",19.05,54.44,1173,109.9,4.6500000000000004,2.97,4.5199999999999996]
["8” x 48,7",203.2,48.7,"5/8”",15.88,62.9,2472.4,168.9,6.31,4.01,5.66]
["8” x 57,9",203.2,57.9,"3/4”",19.05,73.81,2901.1,199.9,6.27,3.99,5.79]

{"sheet":"Compressão","index":2,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Verificação à Flambagem na Compressão"]
["Esbeltez da mesa (AL):"]
["b/t=",{"$f":"b/t","v":8}]
["b/tlim=",{"$f":"0.45*SQRT(E/fy)","v":12.727922061357857},{"$f":"IF(B3<=B4, \"Ok!\",\"Qs<1\")","v":"Ok!"}]
["Q=Qs=",{"$f":"IF(B3<=B4, 1,IF(B3<=(0.91*SQRT(E/fy)),1.34-0.76*b/t*SQRT(fy/E),0.53*E/fy/((b/t)^2)))","v":1}]
[]
[]
["Forças axiais elásticas"]
[null,"Dupla"]
["Nex=",{"$f":"ROUND(PI()^2*E*(2*Ix)/(Kx*Lx)^2/100000,3)","v":100.06699999999999},"kN"]
[null,"Simples"]
["Nez=",{"$f":"IF(Lx_1/rx<=80,ROUND(PI()^2*E*Ix/(0.72*rx+0.75*Lx_1)^2/100000,3),ROUND(PI()^2*E*Ix/(0.32*rx+1.25*Lx_1)^2/100000,3))","v":49.94},"kN"]
[]
["Esbeltez reduzida"]
[null,"Dupla"]
["l0=",{"$f":"ROUND(SQRT(0.1*Q*(2*Area)*fy/B10),3)","v":1.74}]
[null,"Simples"]
["l0=",{"$f":"ROUND(SQRT(0.1*Q*Area*fy/B12),3)","v":1.742}]
[]
["Fator de Redução - Resist. à Compressão"]
[null,"Dupla"]
["c=",{"$f":"ROUND(IF(B16<=1.5,0.658^(B16^2),0.877/(B16^2)),3)","v":0.28999999999999998}]
[null,"Simples"]
["c=",{"$f":"ROUND(IF(B18<=1.5,0.658^(B18^2),0.877/(B18^2)),3)","v":0.28899999999999998}]
[]
["Força Axial Resistente de Cálculo"]
[null,"Dupla"]
["NRd=",{"$f":"0.1*qsi*Q*(2*Area)*fy/gama_a1","v":79.881818181818161},"kN"]
[null,"Simples"]
["NRd=",{"$f":"ROUND(0.1*qsi_1*Q*Area*fy/gama_a1,5)","v":39.803179999999998},"kN"]

{"sheet":"fy","index":3,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Propriedades Mecânicas","Limite de Escoamento (MPa) ","Limite de Resistência (MPa) ","Alongamento após ruptura,% (lo=200mm) "]
["MR 250",250,400,18]
["ASTM A 572 Grau 50",345,450,18]
["AÇO COR 500",370,500]