{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Single-Plate Connections","Conversão de Unidades"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":144,"comments":1,"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":"Single-Plate Connections","index":0,"n_rows":206,"n_cols":30,"rows_kept":206,"cut":false,"hidden":false,"merged":[[62,24,62,25],[63,22,63,25],[85,19,85,21],[79,22,79,25],[80,23,80,25],[32,27,32,28],[33,27,33,28],[77,24,77,25],[75,24,75,25],[64,24,64,25],[31,27,31,28],[70,21,70,22],[70,24,70,25],[71,21,71,22],[69,20,69,25],[86,22,86,24],[31,23,31,25],[75,21,75,22],[76,21,76,23],[76,24,76,25],[87,24,87,25],[84,4,84,6],[86,1,86,2],[87,0,87,3],[87,4,87,6],[87,18,87,19],[84,23,84,25],[84,19,84,21],[32,0,32,1],[30,0,30,5],[31,1,31,2],[80,20,80,22],[83,1,83,2],[84,0,84,3],[73,20,73,25],[46,14,46,19],[46,20,46,25],[81,18,81,25],[45,0,46,1],[38,19,38,25],[39,19,39,20],[39,21,39,22],[39,24,39,25],[33,22,33,23],[38,10,38,11],[40,2,40,3],[33,11,33,12],[33,14,33,15],[184,7,184,9],[166,7,166,9],[167,7,167,9],[168,7,168,9],[182,7,182,9],[78,22,78,25],[161,7,161,9],[162,7,162,9],[163,7,163,9],[171,7,171,9],[176,7,176,9],[40,19,40,25],[41,19,41,22],[41,23,41,25],[43,19,43,23],[43,24,43,25],[42,23,42,24],[142,7,142,9],[152,7,152,9],[153,7,153,9],[28,0,28,5],[17,0,17,1],[21,24,21,25],[22,20,22,23],[27,0,27,3],[21,20,21,23],[26,2,26,4],[26,0,26,1],[22,1,22,2],[23,1,23,2],[15,1,15,2],[25,22,25,24],[24,20,24,25],[16,24,16,25],[17,24,17,25],[19,24,19,25],[16,2,16,5],[17,2,17,5],[22,24,22,25],[23,20,23,25],[183,7,183,9],[27,4,27,5],[10,3,10,5],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[11,3,11,5],[12,4,12,5],[141,7,141,9],[185,7,185,9],[186,7,186,9],[187,7,187,9],[15,3,15,5],[19,0,19,5],[24,1,24,2],[25,1,25,2],[22,4,22,5],[16,0,16,1],[150,7,150,9],[19,20,19,21],[177,7,177,9],[31,20,31,22],[32,24,32,25],[151,7,151,9],[164,7,164,9],[165,7,165,9],[158,7,158,9],[140,7,140,9],[47,0,48,1],[85,0,85,6],[0,8,0,23],[1,8,1,23],[2,8,2,23],[14,20,15,25],[45,14,45,25],[81,0,81,17],[13,4,13,5],[14,4,14,5],[178,7,178,9],[179,7,179,9],[180,7,180,9],[181,7,181,9],[147,7,147,9],[148,7,148,9],[169,7,169,9],[170,7,170,9],[160,7,160,9],[149,7,149,9],[172,7,172,9],[173,7,173,9],[174,7,174,9],[175,7,175,9],[155,7,155,9],[156,7,156,9],[157,7,157,9],[159,7,159,9],[154,7,154,9],[143,7,143,9],[144,7,144,9],[132,7,132,9],[133,7,133,9],[145,7,145,9],[146,7,146,9],[134,7,134,9],[135,7,135,9],[136,7,136,9],[125,7,125,9],[137,7,137,9],[138,7,138,9],[139,7,139,9],[126,7,126,9],[127,7,127,9],[128,7,128,9],[129,7,129,9],[130,7,130,9],[131,7,131,9],[105,0,105,2],[120,7,120,9],[121,7,121,9],[122,7,122,9],[123,7,123,9],[124,7,124,9],[106,0,106,2],[119,7,119,9],[111,7,111,9],[113,7,113,9],[106,3,106,5],[108,7,108,9],[109,7,109,9],[110,7,110,9],[33,0,33,1],[45,2,45,13],[104,0,104,2],[49,0,50,1],[102,0,102,2],[103,0,103,2],[32,7,32,18],[87,11,87,14],[59,2,59,5],[82,0,82,6],[51,0,54,1],[55,0,60,1],[87,9,87,10],[58,6,58,7],[54,8,54,10],[54,5,54,7],[7,18,7,20],[180,1,180,2],[20,0,20,4],[21,0,21,4],[23,4,23,5],[24,4,24,5],[25,4,25,5],[87,15,87,17],[105,3,105,5],[103,3,103,5],[5,18,5,20],[9,0,9,2],[9,3,9,5],[9,20,10,25],[5,21,5,25],[6,0,6,1],[6,2,6,17],[6,18,6,20],[6,21,6,24],[7,0,7,1],[5,0,5,1],[5,2,5,17],[192,4,192,5],[191,4,191,5],[185,4,185,5],[102,3,102,5],[104,3,104,5],[103,7,103,9],[117,7,117,9],[118,7,118,9],[4,2,4,3],[31,4,31,5],[116,7,116,9],[114,7,114,9],[115,7,115,9],[104,7,104,9],[105,7,105,9],[112,7,112,9],[7,2,7,17],[32,2,32,5],[201,16,201,17],[201,12,201,13],[201,8,201,9],[200,8,200,9],[197,10,199,11],[199,8,199,9],[197,6,198,9],[199,6,199,7],[200,10,200,11],[191,7,191,9],[202,22,202,23],[202,20,202,21],[202,18,202,19],[188,7,188,9],[190,7,190,9],[197,18,199,19],[202,8,202,9],[202,6,202,7],[201,10,201,11],[197,20,199,21],[197,0,199,1],[197,2,198,5],[199,2,199,3],[199,4,199,5],[182,1,182,2],[182,4,182,5],[183,4,183,5],[184,4,184,5],[187,4,187,5],[181,1,181,2],[65,24,65,25],[60,2,60,5],[59,6,59,7],[61,21,61,22],[61,24,61,25],[64,20,64,23],[60,18,60,19],[63,16,63,19],[62,21,62,22],[50,4,50,5],[51,3,51,4],[51,6,51,7],[52,2,52,4],[66,24,66,25],[74,24,74,25],[57,4,57,7],[58,8,58,11],[57,16,57,19],[66,14,66,17],[181,4,181,5],[70,7,70,9],[69,11,69,13],[68,2,68,4],[67,0,67,19],[102,7,102,9],[106,7,106,9],[107,7,107,9],[100,3,100,5],[101,7,101,9],[200,20,200,21],[200,18,200,19],[200,16,200,17],[200,14,200,15],[188,4,188,5],[189,4,189,5],[190,4,190,5],[200,6,200,7],[189,7,189,9],[194,4,194,5],[87,7,87,8],[65,20,65,23],[61,8,66,13],[55,3,55,4],[55,6,55,7],[56,3,56,4],[74,21,74,22],[66,18,66,19],[66,20,66,23],[87,20,87,22],[65,18,65,19],[50,12,50,13],[51,9,51,10],[52,8,52,10],[62,15,62,16],[62,18,62,19],[59,8,59,11],[59,12,59,13],[60,8,60,11],[52,5,52,7],[53,2,53,4],[53,5,53,7],[200,2,200,3],[197,14,199,15],[197,16,199,17],[197,12,199,13],[200,4,200,5],[200,12,200,13],[65,14,65,17],[54,2,54,4],[58,2,58,5],[56,6,56,7],[60,6,60,7],[64,18,64,19],[61,2,66,7],[55,9,55,10],[56,9,56,10],[58,18,58,19],[56,12,56,13],[201,24,201,25],[201,22,201,23],[201,20,201,21],[201,18,201,19],[72,20,72,23],[72,24,72,25],[197,24,199,25],[197,22,199,23],[200,24,200,25],[200,22,200,23],[67,20,68,25],[201,14,201,15],[101,0,101,2],[101,3,101,5],[99,7,100,9],[201,6,201,7],[201,4,201,5],[99,0,99,2],[99,3,99,5],[100,0,100,2],[201,2,201,3],[26,20,28,25],[29,21,29,22],[29,24,29,25],[37,12,37,18],[32,22,32,23],[33,24,33,25],[35,19,35,25],[36,21,36,22],[60,20,60,23],[60,24,60,25],[58,20,58,23],[58,24,58,25],[59,14,59,17],[59,18,59,19],[59,20,59,23],[59,24,59,25],[58,14,58,17],[60,14,60,17],[57,22,57,25],[57,10,57,13],[51,21,51,22],[51,24,51,25],[51,12,51,13],[52,11,52,13],[53,11,53,13],[54,11,54,13],[56,18,56,19],[53,8,53,10],[50,22,50,23],[50,24,50,25],[56,15,56,16],[54,20,54,22],[52,20,52,22],[53,14,53,16],[56,21,56,22],[56,24,56,25],[47,20,47,23],[46,8,46,13],[47,8,47,11],[47,12,47,13],[52,14,52,16],[52,17,52,19],[48,21,48,22],[49,20,49,23],[48,9,48,10],[49,8,49,11],[49,24,49,25],[11,24,11,25],[12,21,12,23],[13,20,13,22],[13,23,13,24],[11,21,11,22],[17,20,17,23],[36,19,36,20],[20,22,20,23],[18,20,18,25],[61,0,66,1],[68,5,68,6],[78,0,78,2],[52,23,52,25],[53,17,53,19],[53,20,53,22],[53,23,53,25],[54,23,54,25],[55,15,55,16],[70,5,70,6],[69,5,69,6],[80,0,80,3],[80,4,80,6],[75,0,75,2],[72,1,72,2],[69,0,69,1],[69,2,69,4],[74,0,74,19],[71,0,71,19],[79,1,79,3],[49,12,49,13],[61,15,61,16],[61,18,61,19],[64,14,64,17],[49,14,49,17],[49,18,49,19],[54,14,54,16],[54,17,54,19],[55,18,55,19],[58,12,58,13],[50,6,50,7],[50,10,50,11],[82,7,82,17],[51,18,51,19],[55,12,55,13],[60,12,60,13],[50,16,50,17],[50,18,50,19],[80,9,80,10],[68,7,68,9],[48,3,48,4],[49,2,49,5],[49,6,49,7],[80,17,80,19],[80,11,80,12],[80,13,80,16],[72,16,72,19],[73,13,73,16],[70,13,70,16],[51,15,51,16],[68,0,68,1],[75,9,75,11],[69,7,69,9],[70,17,70,19],[73,17,73,19],[68,16,68,18],[69,16,69,18],[68,14,68,15],[69,14,69,15],[68,11,68,13],[20,24,20,25],[19,22,19,23],[16,20,16,23],[47,24,47,25],[38,0,39,1],[36,7,36,8],[37,7,37,8],[40,0,41,1],[42,0,43,1],[38,2,38,3],[47,6,47,7],[33,8,33,9],[46,2,46,7],[47,2,47,5],[36,2,36,3],[42,2,42,3],[33,2,33,5],[43,2,43,3],[42,7,42,8],[39,2,39,3],[41,5,41,6],[35,12,36,18],[41,14,41,15],[41,17,41,18],[33,17,33,18],[36,10,36,11],[39,10,39,11],[40,10,40,11],[41,10,41,11],[36,5,36,6],[35,0,35,1],[36,0,37,1],[37,2,37,3],[35,2,35,6],[35,7,35,11],[41,2,41,3],[38,7,38,8],[39,7,39,8],[40,7,40,8],[37,5,37,6],[42,10,42,11],[43,5,43,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[37,10,37,11],[43,10,43,11],[42,5,42,6],[41,7,41,8],[43,7,43,8],[42,12,42,18],[41,12,41,13],[42,19,42,22],[43,14,43,15],[43,17,43,18],[43,12,43,13],[38,14,38,15],[39,14,39,15],[39,17,39,18],[40,12,40,18],[204,22,204,23],[38,12,38,13],[39,12,39,13],[47,14,47,17],[47,18,47,19],[48,15,48,16],[203,24,203,25],[203,6,203,7],[203,4,203,5],[203,2,203,3],[203,20,203,21],[205,20,205,21],[204,18,204,19],[204,16,204,17],[203,10,203,11],[202,4,202,5],[202,2,202,3],[203,22,203,23],[204,20,204,21],[203,18,203,19],[203,16,203,17],[203,14,203,15],[203,12,203,13],[203,8,203,9],[202,16,202,17],[25,20,25,21],[202,24,202,25],[202,14,202,15],[202,12,202,13],[202,10,202,11],[36,24,36,25],[37,19,37,20],[37,21,37,22],[37,24,37,25],[38,17,38,18],[25,26,25,27],[55,21,55,22],[55,24,55,25],[30,22,30,24],[60,26,60,27],[54,26,54,27],[49,26,49,27],[47,26,47,27],[30,26,30,27],[30,20,30,21],[9,27,9,28],[10,27,10,28],[11,27,11,28],[12,27,12,28],[13,27,13,28],[14,26,14,27],[14,28,14,29]]}
[null,null,null,null,null,null,null,null,"American Institute of Steel Construction (AISC)"]
[null,null,null,null,null,null,null,null,"Load and Resistance Factor Design (LRFD) - 13th Edition"]
[null,null,null,null,null,null,null,null,"Single-Plate Connections"]
[]
[null,"O.S.:"]
["Cliente:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Responsável:"]
["Obra:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data:"]
["Descrição:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revisão:"]
[]
["Dados da Viga:",null,null,"W 410 x 38,8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resistência do Parafuso Considerando Um Plano de Corte",null,null,null,null,null,"m =",0.5]
["d =",399,null,"Recortes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Du =",1.1299999999999999]
["bfs =",140,null,"Sem Recorte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"db =",{"$f":"IF(db=\"5/8\"\"\",25.4*5/8,IF(db=\"3/4\"\"\",25.4*3/4,IF(db=\"7/8\"\"\",25.4*7/8,IF(db=\"1\"\"\",25.4*1,IF(db=\"1.1/8\"\"\",25.4*(1+1/8),25.4*(1+1/4))))))","v":19.049999999999997},null,"Ab =",{"$f":"PI()*(dbSI/10)^2/4","v":2.8502295699234241},null,"hsc =",1]
["tfs =",8.8000000000000007,null,"c =",150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fn =",{"$f":"IF(Tipo=\"ASTM A325N\",48*70.306957964,60*70.306957964)","v":3374.7339822720005},null,null,null,null,"Tb =",{"$f":"IF(db=\"5/8\"\"\",91,IF(db=\"3/4\"\"\",142,IF(db=\"7/8\"\"\",176,IF(db=\"1\"\"\",205,IF(db=\"1.1/8\"\"\",267,326)))))*1000*'Conversão de Unidades'!C3","v":14479.970181999999}]
["bfi =",140,null,"dc =",35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f·Rn = 0,75·Fn·Ab =",null,null,{"$f":"0.75*Fn*Ab","v":7214.0749401728162},null,null,"Ns =",1]
["tfi =",8.8000000000000007,null,"e =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplic.\",rec+folga)","v":"Não Aplic."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verificação da Configuração Convencional",null,null,null,null,null,"f·Rn =",null,{"$f":"1*AB10*AB11*AB12*AB13*AB14","v":8181.183152829999}]
["tw =",6.4,null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"\",IF(AND(rec<=2*d,dc<=d/2),\"Recorte Ok!\",\"Não Permitido!\"))","v":""}]
["Fy =",null,3515.3478982000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nº de Linhas de Parafusos:",null,null,null,{"$f":"IF(nlp=1,\"Ok!\",\"Não Ok!\")","v":"Ok!"}]
["Fu =",null,4569.95226766,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distância Solda / Parafuso:",null,null,null,{"$f":"IF(a<=3.5*25.4,\"Ok!\",\"Não Ok!\")","v":"Ok!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distância Horizontal Parafuso / Bordas:"]
["Parafusos / Geometria da Ligação",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tipo 1",null,"Viga:",null,{"$f":"IF(OR(TipoLig=\"Tipo 1\",TipoLig=\"Tipo 3\"),IF(a-folga>=2*dbSI,\"Ok!\",\"Não Ok!\"),IF(deh>=2*dbSI,\"Ok!\",\"Não Ok!\"))","v":"Ok!"}]
["Nº Linhas Parafusos (Verticais):",null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chapa:",null,{"$f":"IF(deh>=2*dbSI,\"Ok!\",\"Não Ok!\")","v":"Ok!"}]
["Nº Parafusos Linha:",null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Espessura da Alma da Viga:",null,null,null,{"$f":"IF(tw<=dbSI/2+25.4/16,\"Ok!\",\"Não Ok!\")","v":"Ok!"}]
["div =",{"$f":"3*25.4","v":76.199999999999989},null,"a =",{"$f":"3*25.4","v":76.199999999999989},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Espessura da Chapa:",null,null,null,{"$f":"IF(tp<=dbSI/2+25.4/16,\"Ok!\",\"Não Ok!\")","v":"Ok!"}]
["dih =",{"$f":"div","v":76.199999999999989},null,"dfs =",{"$f":"div","v":76.199999999999989},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Nd=0,Y17=\"Ok!\",Y18=\"Ok!\",Y20=\"Ok!\",Y21=\"Ok!\",Y22=\"Ok!\",Y23=\"Ok!\"),\"Configuração Convencional\",\"Configuração Extendida\")","v":"Configuração Extendida"}]
["dev =",{"$f":"1.25*25.4","v":31.75},null,"f =",{"$f":"0.5*25.4","v":12.7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resistência do Grupo de Parafusos"]
["deh =",{"$f":"2*dbSI","v":38.099999999999994},null,"ep =",{"$f":"a+(nlp-1)*dih/2","v":76.199999999999989},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f·Rn Total =",null,{"$f":"IF(Config=\"Configuração Convencional\",IF(npl>=10,W31*1.25,npl*Rb),\"Não Aplicável\")","v":"Não Aplicável"},null,null,{"$f":"IF(Config=\"Configuração Convencional\",Vd/W26,\"N.A.\")","v":"N.A."},{"$f":"W26/453.59237","v":{"$error":"#VALUE!"}}]
["Parafusos:",null,"ASTM A325N",null,null,"3/4\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resistência do Grupo de Parafusos pelo Método do Centro Instatâneo de Rotação Considerando Esmagamento"]
["Furo Padrão + 2mm =",null,null,null,{"$f":"IF(db=\"5/8\"\"\",(5/8+1/16+1/16)*25.4,IF(db=\"3/4\"\"\",(3/4+1/16+1/16)*25.4,IF(db=\"7/8\"\"\",(7/8+1/16+1/16)*25.4,IF(db=\"1\"\"\",(1+1/16+1/16)*25.4,IF(db=\"1.1/8\"\"\",(1+1/8+1/16+1/16)*25.4,(1+1/4+1/16+1/16)*25.4)))))","v":22.224999999999998}]
[{"$f":"IF((npl-1)*div+2*dfs<=d,\"Geometria Ok!\",\"Geometria Inadequada Para O Perfil\")","v":"Geometria Ok!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C =",{"$f":"IF(Nd=0,coefC,MIN(AB33,AB34))","v":2.832409300369783},null,"C' =",{"$f":"Clinha*2.54","v":28.591032315879559}]
["Dados da Chapa (Single-Plate)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f·Rn Total =",null,{"$f":"MIN(Rb,F55/(nlp*npl),L55/(nlp*npl))*V30","v":20433.212954110069},null,null,{"$f":"SQRT(Vd^2+Nd^2)/W31","v":1.1906361923548694},{"$f":"W31/453.59237","v":45.04752351568451}]
["tp =",6.35,null,"dp =",{"$f":"(npl-1)*div+2*dev","v":292.09999999999997},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mmax = 1,25·Fv·Ab·C' =",null,null,{"$f":"1.25*Fn*Ab*Y30","v":343763.08290609653},null,null,"q =",{"$f":"ATAN(Nd/Vd)*180/PI()","v":-14.995891590377529}]
["Fyp =",null,{"$f":"36*70.306957964","v":2531.0504867040004},null,null,null,null,"Esforços de Cálculo",null,null,null,null,null,null,null,null,null,null,null,null,"Viga:","tmax =",{"$f":"10*6*Mmax/(Fy*IF(TipoRec=\"Sem Recorte\",d/10,IF(TipoRec=\"Flange Superior\",(d-dc)/10,(d-2*dc)/10))^2)","v":3.6854997226007638},null,{"$f":"IF(nlp=1,IF(AND(Y20=\"Ok!\",Y21=\"Ok!\"),IF(OR(Y22=\"Ok!\",Y23=\"Ok!\"),\"Ok!\",IF(tw<=tmaxv,\"Ok!\",\"Não Ok!\")),IF(tw<=tmaxv,\"Ok!\",\"Não Ok!\")),IF(nlp=2,IF(AND(Y20=\"Ok!\",Y21=\"Ok!\",Y22=\"Ok!\",Y23=\"Ok!\"),\"Ok!\",IF(tw<=tmaxv,\"Ok!\",\"Não Ok!\")),IF(tw<=tmaxv,\"Ok!\",\"Não Ok!\")))","v":"Ok!"},null,"C =",{"$f":"BoltCoefficient1(npl,nlp,div/25.4,dih/25.4,ep/25.4,ATAN(Nd/Vd)*180/PI())","v":2.8618574817672373},null,"Crawford and Kulak"]
["Fup =",null,{"$f":"58*70.306957964","v":4077.8035619120005},null,null,null,null,"Vd =",23500,null,"Nd =",-6295,null,"Mdv =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplic.\",Vd*e/1000)","v":"Não Aplic."},null,"Mdp =",{"$f":"Vd*ep/1000","v":1790.6999999999998},null,null,"Chapa:","tmax =",{"$f":"10*6*Mmax/(Fyp*(dp/10)^2)","v":9.5509498315104029},null,{"$f":"IF(nlp=1,IF(AND(Y20=\"Ok!\",Y21=\"Ok!\"),IF(OR(Y22=\"Ok!\",Y23=\"Ok!\"),\"Ok!\",IF(tp<=tmaxp,\"Ok!\",\"Não Ok!\")),IF(tp<=tmaxp,\"Ok!\",\"Não Ok!\")),IF(nlp=2,IF(AND(Y20=\"Ok!\",Y21=\"Ok!\",Y22=\"Ok!\",Y23=\"Ok!\"),\"Ok!\",IF(tp<=tmaxp,\"Ok!\",\"Não Ok!\")),IF(tp<=tmaxp,\"Ok!\",\"Não Ok!\")))","v":"Ok!"},null,"C =",{"$f":"BoltCoefficient2(npl,nlp,div/25.4,dih/25.4,ep/25.4,ATAN(Nd/Vd)*180/PI())","v":2.832409300369783},null,"Donald Brandt"]
[]
["Verificações",null,"Viga",null,null,null,null,"Chapa",null,null,null,null,"Verificações Adicionais da Chapa e da Viga Submetidas a Esforço Axial",null,null,null,null,null,null,"Verificação do Momento Fletor Localizado"]
["Escoamento Seção Bruta",null,"Vd / fv·Vn =",null,{"$f":"ROUND(ABS(Vd/G48),2)","v":0.44},{"$f":"IF(E37<=1,\"Ok!\",\"Não Ok!\")","v":"Ok!"},null,"Vd / fv·Vn =",null,{"$f":"ROUND(ABS(Vd/M48),2)","v":0.83},{"$f":"IF(J37<=1,\"Ok!\",\"Não Ok!\")","v":"Ok!"},null,null,null,null,null,null,null,null,"Viga:",null,"Md / fb·Mn =",null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",ROUND(ABS(Mdv/MIN(R71,R74,R81)),2))","v":"N.A."},{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",IF(X37<=1,\"Ok!\",\"Não Ok!\"))","v":"N.A."}]
[null,null,"Nd / f·Nn =",null,{"$f":"IF(Nd=0,\"N.A.\",ROUND(ABS(Nd/S48),2))","v":0.08},{"$f":"IF(Nd=0,\"N.A.\",IF(E38<=1,\"Ok!\",\"Não Ok!\"))","v":"Ok!"},null,"Nd / f·Nn =",null,{"$f":"IF(Nd=0,\"N.A.\",ROUND(ABS(Nd/Y48),2))","v":0.15},{"$f":"IF(Nd=0,\"N.A.\",IF(J38<=1,\"Ok!\",\"Não Ok!\"))","v":"Ok!"},null,"Colapso Rasgamento Externo Linhas Furos",null,null,null,null,null,null,"Chapa:",null,"Md / fb·Mn =",null,{"$f":"ROUND(ABS(Mdp/MIN(E85,E88,P88)),2)","v":0.87},{"$f":"IF(X38<=1,\"Ok!\",\"Não Ok!\")","v":"Ok!"}]
["Ruptura Seção Líquida",null,"Vd / fv·Vn =",null,{"$f":"ROUND(ABS(Vd/G50),2)","v":0.57999999999999996},{"$f":"IF(E39<=1,\"Ok!\",\"Não Ok!\")","v":"Ok!"},null,"Vd / fv·Vn =",null,{"$f":"ROUND(ABS(Vd/M50),2)","v":0.99},{"$f":"IF(J39<=1,\"Ok!\",\"Não Ok!\")","v":"Ok!"},null,"Viga:",null,"Nd / f·Nn =",null,{"$f":"IF(Nd>=0,\"N.A.\",IF(TipoRec<>\"Ambos Flanges\",\"N.A.\",IF(OR(TipoLig<>\"Tipo 3\",a-folga+(nlp-1)*dih>1.5*rec),\"N.A.\",ROUND(ABS(Nd/S67),2))))","v":"N.A."},{"$f":"IF(Nd>=0,\"N.A.\",IF(TipoRec<>\"Ambos Flanges\",\"N.A.\",IF(OR(TipoLig<>\"Tipo 3\",a-folga+(nlp-1)*dih>1.5*rec),\"N.A.\",IF(Q39<=1,\"Ok!\",\"Não Ok!\"))))","v":"N.A."},null,"Verificação das Tensões Combinadas"]
[null,null,"Nd / f·Nn =",null,{"$f":"IF(Nd>=0,\"N.A.\",ROUND(ABS(Nd/S50),2))","v":0.09},{"$f":"IF(Nd>=0,\"N.A.\",IF(E40<=1,\"Ok!\",\"Não Ok!\"))","v":"Ok!"},null,"Nd / f·Nn =",null,{"$f":"IF(Nd>=0,\"N.A.\",ROUND(ABS(Nd/Y50),2))","v":0.16},{"$f":"IF(Nd>=0,\"N.A.\",IF(J40<=1,\"Ok!\",\"Não Ok!\"))","v":"Ok!"},null,"Chapa:",null,"Nd / f·Nn =",null,{"$f":"IF(Nd>=0,\"N.A.\",ROUND(ABS(Nd/Y67),2))","v":0.47},{"$f":"IF(Nd>=0,\"N.A.\",IF(Q40<=1,\"Ok!\",\"Não Ok!\"))","v":"Ok!"},null,"Chapa:",null,"Equação =",null,{"$f":"X88","v":1.2082970563720958},{"$f":"IF(Config=\"Configuração Convencional\",\"N.A.\",IF(X40<=1,\"Ok!\",\"Não Ok!\"))","v":"Não Ok!"}]
["Pressão de Contato",null,"Vd / fv·Vn =",null,{"$f":"ROUND(ABS(Vd/F55),2)","v":0.59},{"$f":"IF(E41<=1,\"Ok!\",\"Não Ok!\")","v":"Ok!"},null,"Vd / fv·Vn =",null,{"$f":"ROUND(ABS(Vd/L55),2)","v":0.66},{"$f":"IF(J41<=1,\"Ok!\",\"Não Ok!\")","v":"Ok!"},null,"Escoamento da Seção de Whitmore",null,null,null,null,null,null,"Solda Filete Eletrodo AWS E70XX"]
[null,null,"Nd / f·Nn =",null,{"$f":"IF(Nd=0,\"N.A.\",ROUND(ABS(Nd/R55),2))","v":0.16},{"$f":"IF(Nd=0,\"N.A.\",IF(E42<=1,\"Ok!\",\"Não Ok!\"))","v":"Ok!"},null,"Nd / f·Nn =",null,{"$f":"IF(Nd=0,\"N.A.\",ROUND(ABS(Nd/X55),2))","v":0.24},{"$f":"IF(Nd=0,\"N.A.\",IF(J42<=1,\"Ok!\",\"Não Ok!\"))","v":"Ok!"},null,"Chapa:",null,"Nd / f·Nn =",null,{"$f":"IF(Nd=0,\"N.A.\",IF(nlp=1,\"N.A.\",ROUND(ABS(Nd/Y73),2)))","v":"N.A."},{"$f":"IF(Nd=0,\"N.A.\",IF(nlp=1,\"N.A.\",IF(Q42<=1,\"Ok!\",\"Não Ok!\")))","v":"N.A."},null,"Resultante de Forças (Pd) =",null,null,null,{"$f":"SQRT(Vd^2+Nd^2)","v":24328.522869257806}]
["Colapso por Rasgamento",null,"Vd / fv·Vn =",null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",ROUND(ABS(Vd/G61),2))","v":"N.A."},{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",IF(E43<=1,\"Ok!\",\"Não Ok!\"))","v":"N.A."},null,"Vd / fv·Vn =",null,{"$f":"ROUND(ABS(Vd/M61),2)","v":0.98},{"$f":"IF(J43<=1,\"Ok!\",\"Não Ok!\")","v":"Ok!"},null,"Flambagem a Compressão",null,null,null,null,null,null,"Ângulo Pd / Vd (d) =",null,null,null,{"$f":"ABS(ATAN(Nd/Vd)*180/PI())","v":14.995891590377529}]
[null,null,"Nd / f·Nn =",null,{"$f":"IF(Nd>=0,\"N.A.\",ROUND(ABS(Nd/S61),2))","v":0.13},{"$f":"IF(Nd>=0,\"N.A.\",IF(E44<=1,\"Ok!\",\"Não Ok!\"))","v":"Ok!"},null,"Nd / f·Nn =",null,{"$f":"IF(Nd>=0,\"N.A.\",ROUND(ABS(Nd/Y61),2))","v":0.17},{"$f":"IF(Nd>=0,\"N.A.\",IF(J44<=1,\"Ok!\",\"Não Ok!\"))","v":"Ok!"},null,"Chapa:",null,"Nd / f·Nn =",null,{"$f":"IF(Nd<=0,\"N.A.\",ROUND(ABS(Nd/X81),2))","v":"N.A."},{"$f":"IF(Nd<=0,\"N.A.\",IF(Q44<=1,\"Ok!\",\"Não Ok!\"))","v":"N.A."},null,"Pd / 2·0,75·Fw·Aw·(1,0+0,5·sen1,5q) =",null,null,null,null,{"$f":"ROUNDUP(MAX(Pd/(2*0.75*(0.6*70*'Conversão de Unidades'!E18)*(0.707*(dp/10))*(1+0.5*SIN(PI()*delta/180)^1.5)),(5/8)*tp/10)*10,0)","v":4}]
[]
["Verificações",null,"Esforço Cortante",null,null,null,null,null,null,null,null,null,null,null,"Esforço Axial"]
[null,null,"Viga",null,null,null,null,null,"Chapa",null,null,null,null,null,"Viga",null,null,null,null,null,"Chapa"]
["Escoamento Seção Bruta",null,"f·Rn = fv·0,60·Fy·Ag =",null,null,null,{"$f":"IF(Perfil=\"Perfil Soldado\",0.9,1)*0.6*Fy*Ag","v":53860.754357061131},null,"f·Rn = 1,00,·0,60·Fy·Ag =",null,null,null,{"$f":"0.6*Fyp*Agp","v":28168.086177033685},null,"f·Rn = 0,90·Fy·Ag =",null,null,null,{"$f":"IF(Nd=0,\"N.A.\",0.9*Fy*Aga)","v":80791.131535591703},null,"f·Rn = 0,90·Fy·Ag =",null,null,null,{"$f":"IF(Nd=0,\"N.A.\",0.9*Fyp*Agpa)","v":42252.129265550524},null,{"$f":"M48/453.59237","v":62.10000000007426}]
[null,null,"Ag =",{"$f":"IF(TipoRec=\"Sem Recorte\",d*tw/100,IF(TipoRec=\"Flange Superior\",(d-dc)*tw/100,(d-2*dc)*tw/100))","v":25.536000000000005},null,null,null,null,"Ag =",{"$f":"((npl-1)*(div/10)+2*(dev/10))*(tp/10)","v":18.548349999999999},null,null,null,null,"Ag =",{"$f":"IF(Nd=0,\"N.A.\",IF(TipoRec=\"Sem Recorte\",IF(nlp=1,d*tw/100,IF(AND(Perfil<>\"Perfil Soldado\",Perfil<>\"Perfil Laminado\"),D107,((d-tfs-tfi)*tw+bfs*tfs+bfi*tfi)/100)),IF(TipoRec=\"Flange Superior\",IF(nlp=1,(d-dc)*tw/100,IF(AND(Perfil<>\"Perfil Soldado\",Perfil<>\"Perfil Laminado\"),D107,((d-dc-tfi)*tw+bfi*tfi)/100)),(d-2*dc)*tw/100)))","v":25.536000000000005},null,null,null,null,"Ag =",{"$f":"IF(Nd=0,\"N.A.\",dp*tp/100)","v":18.548349999999996}]
["Ruptura Seção Líquida",null,"f·Rn = 0,75·0,60·Fu·Ae =",null,null,null,{"$f":"0.75*0.6*Fu*Ae","v":40813.695308199349},null,"f·Rn = 0,75·0,60·Fu·Ae =",null,null,null,{"$f":"0.75*0.6*Fup*Aep","v":23677.521714028313},null,"f·Rn = 0,75·Fu·Ae =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",0.75*Fu*Aea)","v":68022.825513665593},null,"f·Rn = 0,75·Fu·Ae =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",0.75*Fup*Aepa)","v":39462.536190047183},null,{"$f":"M50/453.59237","v":52.200000000062417}]
[null,null,"U =",1,"Ae = U·An =",null,{"$f":"U*(Ag-npl*df*tw/100)","v":19.846400000000006},null,"U =",1,"Ae = U·An =",null,{"$f":"Up*(Agp-npl*(df/10)*(tp/10))","v":12.9032},null,"U =",{"$f":"IF(Nd>=0,\"N.A.\",IF(nlp=1,1,IF(1-R108/((nlp-1)*dih)>=0.6,MIN(1-R108/((nlp-1)*dih),0.9),\"U<0,6\")))","v":1},"Ae = U·An =",null,{"$f":"IF(Nd>=0,\"N.A.\",Ua*(Aga-npl*df*tw/100))","v":19.846400000000006},null,"U =",1,"Ae = U·An =",null,{"$f":"IF(Nd>=0,\"N.A.\",Upa*(Agpa-npl*(df/10)*(tp/10)))","v":12.903199999999996}]
["Pressão de Contato nos Furos (\"Bearing Strength\")",null,"Lci =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",div-(df-2))","v":"N.A."},null,"Lce =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",(dfs-dc)-(df-2)/2)","v":"N.A."},null,"Lci =",{"$f":"div-(df-2)","v":55.974999999999994},null,"Lce =",{"$f":"dev-(df-2)/2","v":21.637500000000003},null,"Lci =",{"$f":"IF(Nd=0,\"N.A.\",IF(nlp=1,0,dih-(df-2)))","v":0},null,"Lce =",{"$f":"IF(Nd=0,\"N.A.\",IF(OR(TipoLig=\"Tipo 1\",TipoLig=\"Tipo 3\"),(a-folga)-(df-2)/2,deh-(df-2)/2))","v":53.387499999999989},null,"Lci =",{"$f":"IF(Nd=0,\"N.A.\",IF(nlp=1,0,dih-(df-2)))","v":0},null,"Lce =",{"$f":"IF(Nd=0,\"N.A.\",deh-(df-2)/2)","v":27.987499999999997}]
[null,null,"Rn = 1,2·Lc·t·Fu =",null,null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",nlp*1.2*((npl-1)*Lci/10+Lce/10)*(tw/10)*Fu)","v":"N.A."},null,null,"Rn = 1,2·Lc·t·Fu =",null,null,{"$f":"nlp*1.2*((npl-1)*Lcip/10+Lcep/10)*(tp/10)*Fup","v":58902.496193116691},null,null,"Rn = 1,2·Lc·t·Fu =",null,null,{"$f":"IF(Nd=0,\"N.A.\",npl*1.2*((nlp-1)*Lcia/10+Lcea/10)*(tw/10)*Fu)","v":74950.141959075278},null,null,"Rn = 1,2·Lc·t·Fu =",null,null,{"$f":"IF(Nd=0,\"N.A.\",npl*1.2*((nlp-1)*Lcipa/10+Lcepa/10)*(tp/10)*Fup)","v":34786.070287210889}]
[null,null,"Rn = 2,4·d·t·Fu =",null,null,{"$f":"2.4*(dbSI/10)*(tw/10)*Fu*npl*nlp","v":53488.183725418276},null,null,"Rn = 2,4·d·t·Fu =",null,null,{"$f":"2.4*(dbSI/10)*(tp/10)*Fup*npl*nlp","v":47355.043428056626},null,null,"Rn = 2,4·d·t·Fu =",null,null,{"$f":"IF(Nd=0,\"N.A.\",2.4*(dbSI/10)*(tw/10)*Fu*npl*nlp)","v":53488.183725418276},null,null,"Rn = 2,4·d·t·Fu =",null,null,{"$f":"IF(Nd=0,\"N.A.\",2.4*(dbSI/10)*(tp/10)*Fup*npl*nlp)","v":47355.043428056626}]
[null,null,"f·Rn = 0,75·Rn =",null,null,{"$f":"IF(TipoRec=\"Sem Recorte\",0.75*F54,0.75*MIN(F53:H54))","v":40116.137794063703},null,null,"f·Rn = 0,75·Rn =",null,null,{"$f":"0.75*MIN(L53:N54)","v":35516.282571042466},null,null,"f·Rn = 0,75·Rn =",null,null,{"$f":"IF(Nd=0,\"N.A.\",0.75*MIN(R53:T54))","v":40116.137794063703},null,null,"f·Rn = 0,75·Rn =",null,null,{"$f":"IF(Nd=0,\"N.A.\",0.75*MIN(X53:Z54))","v":26089.552715408165},null,null,{"$f":"L55/453.59237","v":78.300000000093618}]
["Colapso por Rasgamento (Block Shear)",null,"Agt =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",IF(OR(TipoLig=\"Tipo 1\",TipoLig=\"Tipo 3\"),(((a-folga)+(nlp-1)*dih)/10)*(tw/10),((deh+(nlp-1)*dih)/10)*(tw/10)))","v":"N.A."},null,"Ant =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",Agt-(nlp-0.5)*(df/10)*(tw/10))","v":"N.A."},null,"Agt =",{"$f":"((deh+(nlp-1)*dih)/10)*(tp/10)","v":2.4193499999999997},null,"Ant =",{"$f":"Agtp-(nlp-0.5)*(df/10)*(tp/10)","v":1.7137062499999998},null,"Agt =",{"$f":"IF(Nd>=0,\"N.A.\",(npl-1)*(div/10)*(tw/10))","v":14.6304},null,"Ant =",{"$f":"IF(Nd>=0,\"N.A.\",Agta-(npl-1)*(df/10)*(tw/10))","v":10.363200000000001},null,"Agt =",{"$f":"IF(Nd>=0,\"N.A.\",(npl-1)*(div/10)*(tp/10))","v":14.5161},null,"Ant =",{"$f":"IF(Nd>=0,\"N.A.\",Agtpa-(npl-1)*(df/10)*(tp/10))","v":10.282237500000001}]
[null,null,"Agv =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",((npl-1)*(div/10)+((dfs-dc)/10))*(tw/10))","v":"N.A."},null,"Anv =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",Agv-(npl-0.5)*(df/10)*(tw/10))","v":"N.A."},null,"Agv =",{"$f":"((npl-1)*(div/10)+(dev/10))*(tp/10)","v":16.532225},null,"Anv =",{"$f":"Agvp-(npl-0.5)*(df/10)*(tp/10)","v":11.592718750000001},null,"Agv =",{"$f":"IF(Nd>=0,\"N.A.\",IF(OR(TipoLig=\"Tipo 1\",TipoLig=\"Tipo 3\"),(((a-folga)+(nlp-1)*dih)/10)*(tw/10),((deh+(nlp-1)*dih)/10)*(tw/10))*2)","v":8.1279999999999983},null,"Anv =",{"$f":"IF(Nd>=0,\"N.A.\",Agva-(nlp-0.5)*(df/10)*(tw/10)*2)","v":6.7055999999999987},null,"Agv =",{"$f":"IF(Nd>=0,\"N.A.\",((deh+(nlp-1)*dih)/10)*(tp/10)*2)","v":4.8386999999999993},null,"Anv =",{"$f":"IF(Nd>=0,\"N.A.\",Agvpa-(nlp-0.5)*(df/10)*(tp/10)*2)","v":3.4274124999999995}]
[null,null,"Ubs =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",IF(nlp=1,1,0.5))","v":"N.A."},"(Ver Comentários no AISC 13th)",null,null,null,"Ubs =",{"$f":"IF(nlp=1,1,0.5)","v":1},"(Ver Comentários no AISC 13th)",null,null,null,"Ubs =",1,"(Ver Comentários no AISC 13th)",null,null,null,"Ubs =",1,"(Ver Comentários no AISC 13th)"]
[null,null,"0,60·Fu·Anv+Ubs·Fu·Ant =",null,null,null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",0.6*Fu*Anv+Ubs*Fu*Ant)","v":"N.A."},null,"0,60·Fu·Anv+Ubs·Fu·Ant =",null,null,null,{"$f":"0.6*Fup*Anvp+Ubsp*Fup*Antp","v":35351.855336917281},null,"0,60·Fu·Anv+Ubs·Fu·Ant =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",0.6*Fu*Anva+Ubsa*Fu*Anta)","v":65745.892495826643},null,"0,60·Fu·Anv+Ubs·Fu·Ant =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",0.6*Fup*Anvpa+Ubspa*Fup*Antpa)","v":50314.733642310173}]
[null,null,"0,60·Fy·Agv+Ubs·Fu·Ant =",null,null,null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",0.6*Fy*Agv+Ubs*Fu*Ant)","v":"N.A."},null,"0,60·Fy·Agv+Ubs·Fu·Ant =",null,null,null,{"$f":"0.6*Fyp*Agvp+Ubsp*Fup*Antp","v":32094.495129850882},null,"0,60·Fy·Agv+Ubs·Fu·Ant =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",0.6*Fy*Agva+Ubsa*Fu*Anta)","v":64502.977970155873},null,"0,60·Fy·Agv+Ubs·Fu·Ant =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",0.6*Fyp*Agvpa+Ubspa*Fup*Antpa)","v":49277.141095933934}]
[null,null,"f·Rn = 0,75·Rn =",null,null,null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"N.A.\",0.75*MIN(G59:H60))","v":"N.A."},null,"f·Rn = 0,75·Rn =",null,null,null,{"$f":"0.75*MIN(M59:N60)","v":24070.871347388162},null,"f·Rn = 0,75·Rn =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",0.75*MIN(S59:T60))","v":48377.233477616901},null,"f·Rn = 0,75·Rn =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",0.75*MIN(Y59:Z60))","v":36957.855821950448},null,{"$f":"M61/453.59237","v":53.067187500063461}]
["Colapso por Rasgamento (Block Shear) Externo às Linhas de Furos",null,"Não Aplicável",null,null,null,null,null,"Não Aplicável",null,null,null,null,null,"Agt =",{"$f":"IF(Nd>=0,\"N.A.\",IF(TipoRec<>\"Ambos Flanges\",\"N.A.\",IF(OR(TipoLig<>\"Tipo 3\",a-folga+(nlp-1)*dih>1.5*rec),\"N.A.\",2*((dfs-dc)/10)*(tw/10))))","v":"N.A."},null,"Ant =",{"$f":"IF(Nd>=0,\"N.A.\",IF(TipoRec<>\"Ambos Flanges\",\"N.A.\",IF(OR(TipoLig<>\"Tipo 3\",a-folga+(nlp-1)*dih>1.5*rec),\"N.A.\",Agtae-(df/10)*(tw/10))))","v":"N.A."},null,"Agt =",{"$f":"IF(Nd>=0,\"N.A.\",2*(dev/10)*(tp/10))","v":4.0322499999999994},null,"Ant =",{"$f":"IF(Nd>=0,\"N.A.\",Agtpae-(df/10)*(tp/10))","v":2.6209624999999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agv =",{"$f":"IF(Nd>=0,\"N.A.\",IF(TipoRec<>\"Ambos Flanges\",\"N.A.\",IF(OR(TipoLig<>\"Tipo 3\",a-folga+(nlp-1)*dih>1.5*rec),\"N.A.\",IF(OR(TipoLig=\"Tipo 1\",TipoLig=\"Tipo 3\"),(((a-folga)+(nlp-1)*dih)/10)*(tw/10),((deh+(nlp-1)*dih)/10)*(tw/10))*2)))","v":"N.A."},null,"Anv =",{"$f":"IF(Nd>=0,\"N.A.\",IF(TipoRec<>\"Ambos Flanges\",\"N.A.\",IF(OR(TipoLig<>\"Tipo 3\",a-folga+(nlp-1)*dih>1.5*rec),\"N.A.\",Agvae-(nlp-0.5)*(df/10)*(tw/10)*2)))","v":"N.A."},null,"Agv =",{"$f":"IF(Nd>=0,\"N.A.\",((deh+(nlp-1)*dih)/10)*(tp/10)*2)","v":4.8386999999999993},null,"Anv =",{"$f":"IF(Nd>=0,\"N.A.\",Agvpae-(nlp-0.5)*(df/10)*(tp/10)*2)","v":3.4274124999999995}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ubs =",1,"(Ver Comentários no AISC 13th)",null,null,null,"Ubs =",1,"(Ver Comentários no AISC 13th)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0,60·Fu·Anv+Ubs·Fu·Ant =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",IF(TipoRec<>\"Ambos Flanges\",\"N.A.\",IF(OR(TipoLig<>\"Tipo 3\",a-folga+(nlp-1)*dih>1.5*rec),\"N.A.\",0.6*Fu*Anvae+Ubsae*Fu*Antae)))","v":"N.A."},null,"0,60·Fu·Anv+Ubs·Fu·Ant =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",0.6*Fup*Anvpae+Ubspae*Fup*Antpae)","v":19073.55915852281}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0,60·Fy·Agv+Ubs·Fu·Ant =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",IF(TipoRec<>\"Ambos Flanges\",\"N.A.\",IF(OR(TipoLig<>\"Tipo 3\",a-folga+(nlp-1)*dih>1.5*rec),\"N.A.\",0.6*Fy*Agvae+Ubsae*Fu*Antae)))","v":"N.A."},null,"0,60·Fy·Agv+Ubs·Fu·Ant =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",0.6*Fyp*Agvpae+Ubspae*Fup*Antpae)","v":18035.966612146567}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f·Rn = 0,75·Rn =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",IF(TipoRec<>\"Ambos Flanges\",\"N.A.\",IF(OR(TipoLig<>\"Tipo 3\",a-folga+(nlp-1)*dih>1.5*rec),\"N.A.\",0.75*MIN(S65:T66))))","v":"N.A."},null,"f·Rn = 0,75·Rn =",null,null,null,{"$f":"IF(Nd>=0,\"N.A.\",0.75*MIN(Y65:Z66))","v":13526.974959109924}]
["Verificação da Seção Líquida da Viga Considerando Recorte nos Flanges - Ruptura por Escoamento a Flexão",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verificações Adicionais da Chapa Submetida a Esforço Axial"]
["Awn =",null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(TipoRec=\"Flange Superior\",(d-dc-tfi)*tw,(d-2*dc)*tw))","v":"Não Aplicável"},null,null,"YCGw =",null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(TipoRec=\"Flange Superior\",(d-dc-tfi)/2+tfi,(d-2*dc)/2))","v":"Não Aplicável"},null,null,"dw =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(YCGw>=YCGn,YCGw-YCGn,YCGn-YCGw))","v":"Não Aplicável"},null,null,"Ixn (cm4) =",null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(TipoRec=\"Flange Superior\",(tw*(d-dc-tfi)^3/12+Awn*dw^2+bfi*tfi^3/12+Afi*dfi^2)/10000,(tw*(d-2*dc)^3/12/10000)))","v":"Não Aplicável"}]
["Afi =",null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(TipoRec=\"Flange Superior\",bfi*tfi,\"Não Aplicável\"))","v":"Não Aplicável"},null,null,"YCGfi =",null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(TipoRec=\"Flange Superior\",tfi/2,\"Não Aplicável\"))","v":"Não Aplicável"},null,null,"dfi =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(TipoRec=\"Flange Superior\",YCGn-YCGfi,\"Não Aplicável\"))","v":"Não Aplicável"},null,null,"wxn =",null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(TipoRec=\"Flange Superior\",MIN(Ixn/((d-dc-YCGn)/10),Ixn/(YCGn/10)),Ixn/(YCGn/10)))","v":"Não Aplicável"},null,null,null,"Escoamento da Seção de Whitmore"]
[null,null,null,null,null,"YCGn =",null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(TipoRec=\"Flange Superior\",(Awn*YCGw+Afi*YCGfi)/(Awn+Afi),YCGw))","v":"Não Aplicável"},null,null,null,null,null,"fb·Mn = 0,75·Fu·wxn =",null,null,null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",0.75*Fu*wxn/100)","v":"Não Aplicável"},null,null,"dwt =",{"$f":"IF(Nd=0,\"N.A.\",IF(nlp=1,\"N.A.\",2*(nlp-1)*dih*TAN(PI()*30/180)+(npl-1)*div))","v":"N.A."},null,"dpf =",{"$f":"IF(Nd=0,\"N.A.\",IF(nlp=1,\"N.A.\",MIN(dwt,dp)))","v":"N.A."}]
["Verificação da Seção Líquida da Viga Considerando Recorte no Flange Superior - Flambagem Local da Alma",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ag =",{"$f":"IF(Nd=0,\"N.A.\",IF(nlp=1,\"N.A.\",dpf*tp/100))","v":"N.A."}]
["ho =",{"$f":"d-dc","v":364},null,null,null,null,null,null,null,null,null,null,null,null,null,"Fcr =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",(PI()^2*2.05*10^6/(12*(1-0.3^2)))*(tw/ho)^2*f*k)","v":"Não Aplicável"},null,null,null,"f·Rn = 0,90·Fy·Ag =",null,null,null,{"$f":"IF(Nd=0,\"N.A.\",IF(nlp=1,\"N.A.\",0.9*Fyp*Agpaf))","v":"N.A."}]
["f =",{"$f":"IF(rec/d<=1,2*rec/d,1+rec/d)","v":0.75187969924812026},"k =",{"$f":"IF(rec/ho<=1,2.2*(ho/rec)^1.65,2.2*ho/rec)","v":9.4992515064339678},null,null,null,null,null,null,null,null,null,"fb·Mn = 0,90·Fcr·wxn =",null,null,null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(TipoRec=\"Flange Superior\",0.9*MIN(Fcr,Fy)*wxn/100,\"Não Aplicável\"))","v":"Não Aplicável"},null,null,"Flambagem a Compressão"]
["Verificação da Seção Líquida da Viga Considerando Recorte em Ambos os Flanges - Flambagem Lateral por Torção da Alma",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A =",{"$f":"IF(Nd<=0,\"N.A.\",IF(nlp=1,Agpa,Agpaf))","v":"N.A."},null,"I =",{"$f":"IF(Nd<=0,\"N.A.\",IF(nlp=1,(dp/10)*(tp/10)^3/12,(dpf/10)*(tp/10)^3/12))","v":"N.A."}]
["Para dc ≤ 0,2·d:",null,null,null,null,null,null,null,null,"Para dc > 0,2·d:",null,null,null,null,null,null,null,null,null,null,"r =",{"$f":"IF(Nd<=0,\"N.A.\",SQRT(Y75/V75))","v":"N.A."},null,"L =",{"$f":"IF(Nd<=0,\"N.A.\",a/10)","v":"N.A."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K·L/r = 1,20·L/r =",null,null,{"$f":"IF(Nd<=0,\"N.A.\",1.2*Y76/V76)","v":"N.A."}]
[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":"IF(Nd<=0,\"N.A.\",4.71*SQRT(2040000/Fyp))","v":"N.A."}]
["fd = 3,5-7,5·(dc/d) =",null,null,{"$f":"3.5-7.5*(dc/d)","v":2.8421052631578947},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fe =",{"$f":"IF(Nd<=0,\"N.A.\",PI()^2*2040000/Y77^2)","v":"N.A."}]
["Fcr =",{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",0.62*PI()*2.05*10^6*(tw^2/(rec*ho))*fd)","v":"Não Aplicável"},null,null,null,null,null,null,null,"l =",{"$f":"ho*SQRT(Fy*'Conversão de Unidades'!$E$17)/(10*tw*SQRT(475+280*(ho/rec)^2))","v":0.87266106561470302},null,null,null,null,null,null,null,"Q =",{"$f":"IF(lambda<=0.7,1,IF(lambda<=1.41,1.34-0.486*lambda,1.3/lambda^2))","v":0.91588672211125444},null,"Fcr =",{"$f":"IF(Nd<=0,\"N.A.\",IF(Y77<=25,Fyp,IF(Y77<=Y78,(0.658^(Fyp/W79))*Fyp,0.877*Fep)))","v":"N.A."}]
["fb·Mn = 0,90·Fcr·wxn =",null,null,null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(TipoRec=\"Flange Superior\",\"Não Aplicável\",IF(dc>0.2*d,\"Não Aplicável\",0.9*MIN(B80,Fy)*wxn/100)))","v":"Não Aplicável"},null,null,null,null,"Fcr = Fy·Q =",null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",Fy*Q)","v":"Não Aplicável"},null,"fb·Mn = 0,90·Fcr·wxn =",null,null,null,{"$f":"IF(TipoRec=\"Sem Recorte\",\"Não Aplicável\",IF(TipoRec=\"Flange Superior\",\"Não Aplicável\",IF(dc<=0.5*d,\"Não Aplicável\",0.9*L81*wxn/100)))","v":"Não Aplicável"},null,null,"0,90·Fcr·Ag =",null,null,{"$f":"IF(Nd<=0,\"N.A.\",0.9*W80*V75)","v":"N.A."}]
["Verificação da Chapa a Flexão ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verificação das Tensões Combinadas na Chapa"]
["Escoamento da Seção Bruta",null,null,null,null,null,null,"Flambagem Lateral por Torção"]
["Zpl =",{"$f":"tp*dp^2/4000","v":135.44932587499994}]
["fb·Mn = 0,90·Fy·Zpl =",null,null,null,{"$f":"0.9*Fyp*Zplp/100","v":3085.4617396168264},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Config=\"Configuração Convencional\",\"N.A.\",IF(Nd=0,\"N.A.\",ABS(Nd/Agpa)))","v":339.3832874622272},null,null,null,{"$f":"IF(Config=\"Configuração Convencional\",\"N.A.\",Vd/Agp)","v":1266.9590556572418}]
["Ruptura da Seção Líquida",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Config=\"Configuração Convencional\",\"N.A.\",Mdp*100/Zplp)","v":1322.0442319901656}]
["Znet =",96.304242874999943,null,null,null,null,null,"l =",{"$f":"dp*SQRT(Fyp*'Conversão de Unidades'!$E$17)/(10*tp*SQRT(475+280*(dp/a)^2))","v":0.40740749919758845},null,null,null,null,null,null,null,"Q =",{"$f":"IF(lambdap<=0.7,1,IF(lambdap<=1.41,1.34-0.486*lambdap,1.3/lambdap^2))","v":1},null,null,null,null,{"$f":"IF(Config=\"Configuração Convencional\",\"N.A.\",IF(Nd=0,SQRT(T86^2+3*X85^2),SQRT((T85+T86)^2+3*X85^2)))","v":2752.4347673522439}]
["fb·Mn = 0,75·Fu·Znet =",null,null,null,{"$f":"0.75*Fup*Znet/100","v":2945.3233846718485},null,null,"Fcr = Fy·Q =",null,{"$f":"Fyp*Qp","v":2531.0504867040004},null,"fb·Mn = 0,90·Fcr·wxn =",null,null,null,{"$f":"0.9*Fcrp*(tp*dp^2/6000)/100","v":2056.9744930778847},null,null,"0,90·Fy =",null,{"$f":"0.9*Fyp","v":2277.9454380336006},null,null,{"$f":"IF(Config=\"Configuração Convencional\",\"N.A.\",W87/U88)","v":1.2082970563720958},{"$f":"IF(Config=\"Configuração Convencional\",\"N.A.\",IF(X88<=1,\"Ok!\",\"Não Ok!\"))","v":"Não Ok!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Dados da Seção",null,null,{"$f":"Perfil","v":"W 410 x 38,8"},null,null,null,"DESIGNAÇÃO",null,null,"d","bf","tf","tw","Ag"]
["d (mm) =",null,null,399,null,null,null,null,null,null,"mm","mm","mm","mm","cm²",null,"h =",{"$f":"d-tfs-tfi","v":381.4}]
["bfs (mm) =",null,null,140,null,null,null,"Perfil Soldado",null,null,500,250,12.5,6.35,null,null,"bfs/2 =",{"$f":"bfs/2","v":70}]
["tfs (mm) =",null,null,8.8000000000000007,null,null,null,"W 150 x 13,0",null,null,148,100,4.9000000000000004,4.3,16.602599999999999,null,"tfs =",{"$f":"tfs","v":8.8000000000000007}]
["bfi (mm) =",null,null,140,null,null,null,"W 150 x 13,5",null,null,150,100,5.5,4.3,18.2,null,"bfi/2 =",{"$f":"bfi/2","v":70}]
["tfi (mm) =",null,null,8.8000000000000007,null,null,null,"W 150 x 18,0",null,null,153,102,7.1,5.8,23.394399999999997,null,"tfi =",{"$f":"tfi","v":8.8000000000000007}]
["tw (mm) =",null,null,6.4,null,null,null,"W 150 x 22,5",null,null,152,152,6.6,5.8,28.974399999999996,null,"tw/2 =",{"$f":"tw/2","v":3.2}]
["Ag (cm²) =",null,null,50.288000000000004,null,null,null,"W 150 x 24,0",null,null,160,102,10.3,6.6,31.5,null,"A =",{"$f":"R101*R106+R102*R103+R104*R105","v":2452.48}]
[null,null,null,null,null,null,null,"W 150 x 29,8",null,null,157,153,9.3000000000000007,6.6,38.452399999999997,null,"xCG =",{"$f":"(R101*R106^2/2+R103*R102^2/2+R105*R104^2/2)/R107","v":18.378444676409185}]
[null,null,null,null,null,null,null,"W 150 x 37,1",null,null,162,154,11.6,8.1,47.830799999999996]
[null,null,null,null,null,null,null,"W 200 x 15,0",null,null,200,100,5.2,4.3,19.412800000000001]
[null,null,null,null,null,null,null,"W 200 x 19,3",null,null,203,102,6.5,5.8,25.14]
[null,null,null,null,null,null,null,"W 200 x 22,5",null,null,206,102,8,6.2,28.96]
[null,null,null,null,null,null,null,"W 200 x 26,6",null,null,207,133,8.4,5.8,34.235600000000005]
[null,null,null,null,null,null,null,"W 200 x 31,3",null,null,210,134,10.199999999999999,6.4,40.330400000000004]
[null,null,null,null,null,null,null,"W 200 x 35,9",null,null,201,165,10.199999999999999,6.2,45.7]
[null,null,null,null,null,null,null,"W 200 x 41,7",null,null,205,166,11.8,7.2,53.5]
[null,null,null,null,null,null,null,"W 200 x 46,1",null,null,203,203,11,7.2,58.552000000000007]
[null,null,null,null,null,null,null,"W 200 x 52,0",null,null,206,204,12.6,7.9,66.900000000000006]
[null,null,null,null,null,null,null,"HP 200 x 53,0",null,null,204,207,11.3,11.3,68.140200000000007]
[null,null,null,null,null,null,null,"W 200 x 59,0",null,null,210,205,14.2,9.1,76]
[null,null,null,null,null,null,null,"W 200 x 71,0",null,null,216,206,17.399999999999999,10.199999999999999,91]
[null,null,null,null,null,null,null,"W 200 x 86,0",null,null,222,209,20.6,13,110.9]
[null,null,null,null,null,null,null,"W 250 x 17,9",null,null,251,101,5.3,4.8,23.1052]
[null,null,null,null,null,null,null,"W 250 x 22,3",null,null,254,102,6.9,5.8,28.867599999999999]
[null,null,null,null,null,null,null,"W 250 x 25,3",null,null,257,102,8.4,6.1,32.648199999999996]
[null,null,null,null,null,null,null,"W 250 x 28,4",null,null,260,102,10,6.4,36.619999999999997]
[null,null,null,null,null,null,null,"W 250 x 32,7",null,null,258,146,9.1,6.1,42.059799999999996]
[null,null,null,null,null,null,null,"W 250 x 38,5",null,null,262,147,11.2,6.6,49.601599999999998]
[null,null,null,null,null,null,null,"W 250 x 44,8",null,null,266,148,13,7.6,57.58]
[null,null,null,null,null,null,null,"HP 250 x 62,0",null,null,246,256,10.7,10.5,79.605399999999989]
[null,null,null,null,null,null,null,"W 250 x 73,0",null,null,253,254,14.2,8.6,92.69]
[null,null,null,null,null,null,null,"W 250 x 80,0",null,null,256,255,15.6,9.4,101.92960000000001]
[null,null,null,null,null,null,null,"HP 250 x 85,0",null,null,254,260,14.4,14.4,108.5]
[null,null,null,null,null,null,null,"HP 250 x 89,0",null,null,260,256,17.3,10.7,113.93220000000001]
[null,null,null,null,null,null,null,"W 250 x 101,0",null,null,264,257,19.600000000000001,11.9,128.69999999999999]
[null,null,null,null,null,null,null,"W 250 x 115,0",null,null,269,259,22.1,13.5,146.1]
[null,null,null,null,null,null,null,"W 310 x 21,0",null,null,303,101,5.7,5.0999999999999996,27.245600000000003]
[null,null,null,null,null,null,null,"W 310 x 23,8",null,null,305,101,6.7,5.6,30.723599999999998]
[null,null,null,null,null,null,null,"W 310 x 28,3",null,null,309,102,8.9,6,36.488]
[null,null,null,null,null,null,null,"W 310 x 32,7",null,null,313,102,10.8,6.6,42.124399999999994]
[null,null,null,null,null,null,null,"W 310 x 38,7",null,null,310,165,9.6999999999999993,5.8,49.724799999999995]
[null,null,null,null,null,null,null,"W 310 x 44,5",null,null,313,166,11.2,6.6,57.223599999999998]
[null,null,null,null,null,null,null,"W 310 x 52,0",null,null,317,167,13.2,7.6,67.033599999999993]
[null,null,null,null,null,null,null,"HP 310 x 79,0",null,null,299,306,11,11,99.991600000000005]
[null,null,null,null,null,null,null,"HP 310 x 93,0",null,null,303,308,13.1,13.1,119.15840000000001]
[null,null,null,null,null,null,null,"W 310 x 97,0",null,null,308,305,15.4,9.9,123.5844]
[null,null,null,null,null,null,null,"W 310 x 107,0",null,null,311,306,17,10.9,136.43460000000002]
[null,null,null,null,null,null,null,"HP 310 x 110,0",null,null,308,310,15.5,15.4,140.95960000000002]
[null,null,null,null,null,null,null,"W 310 x 117,0",null,null,314,307,18.7,11.9,149.935]
[null,null,null,null,null,null,null,"HP 310 x 125,0",null,null,312,312,17.399999999999999,17.399999999999999,159.01039999999998]
[null,null,null,null,null,null,null,"W 360 x 32,9",null,null,349,127,8.5,5.8,42.084399999999995]
[null,null,null,null,null,null,null,"W 360 x 39,0",null,null,353,128,10.7,6.5,50.184399999999997]
[null,null,null,null,null,null,null,"W 360 x 44,0",null,null,352,171,9.8000000000000007,6.9,57.69]
[null,null,null,null,null,null,null,"W 360 x 51,0",null,null,355,171,11.6,7.2,64.8]
[null,null,null,null,null,null,null,"W 360 x 57,8",null,null,358,172,13.1,7.9,72.514600000000002]
[null,null,null,null,null,null,null,"W 360 x 64,0",null,null,347,203,13.5,7.7,81.651600000000002]
[null,null,null,null,null,null,null,"W 360 x 72,0",null,null,350,204,15.1,8.6,91.312399999999997]
[null,null,null,null,null,null,null,"W 360 x 79,0",null,null,354,205,16.8,9.4,101.1992]
[null,null,null,null,null,null,null,"W 360 x 91,0",null,null,353,254,16.399999999999999,9.5,115.9]
[null,null,null,null,null,null,null,"W 360 x 101,0",null,null,357,255,18.3,10.5,129.5]
[null,null,null,null,null,null,null,"W 360 x 110,0",null,null,360,256,19.899999999999999,11.4,140.59240000000003]
[null,null,null,null,null,null,null,"W 360 x 122,0",null,null,363,257,21.7,13,155.2876]
[null,null,null,null,null,null,null,"W 410 x 38,8",null,null,399,140,8.8000000000000007,6.4,50.288000000000004]
[null,null,null,null,null,null,null,"W 410 x 46,1",null,null,403,140,11.2,7,59.240399999999994]
[null,null,null,null,null,null,null,"W 410 x 53,0",null,null,403,177,10.9,7.5,68.414399999999986]
[null,null,null,null,null,null,null,"W 410 x 60,0",null,null,407,178,12.8,7.7,76.174199999999999]
[null,null,null,null,null,null,null,"W 410 x 67,0",null,null,410,179,14.4,8.8000000000000007,86.335999999999999]
[null,null,null,null,null,null,null,"W 410 x 75,0",null,null,413,180,16,9.6999999999999993,95.795399999999987]
[null,null,null,null,null,null,null,"W 410 x 85,0",null,null,417,181,18.2,10.9,108.6]
[null,null,null,null,null,null,null,"W 460 x 52,0",null,null,450,152,10.8,7.6,66.628799999999998]
[null,null,null,null,null,null,null,"W 460 x 60,0",null,null,455,153,13.3,8,76.208400000000012]
[null,null,null,null,null,null,null,"W 460 x 68,0",null,null,459,154,15.4,9.1,87.636600000000001]
[null,null,null,null,null,null,null,"W 460 x 74,0",null,null,457,190,14.5,9,94.858400000000003]
[null,null,null,null,null,null,null,"W 460 x 82,0",null,null,460,191,16,9.9,104.7304]
[null,null,null,null,null,null,null,"W 460 x 89,0",null,null,463,192,17.7,10.5,114.10440000000001]
[null,null,null,null,null,null,null,"W 460 x 97,0",null,null,466,193,19,11.4,123.4]
[null,null,null,null,null,null,null,"W 460 x 106,0",null,null,469,194,20.6,12.6,135.1]
[null,null,null,null,null,null,null,"W 530 x 66,0",null,null,525,165,11.4,8.9,83.554199999999994]
[null,null,null,null,null,null,null,"W 530 x 72,0",null,null,524,207,10.9,9,91.562400000000011]
[null,null,null,null,null,null,null,"W 530 x 74,0",null,null,529,166,13.6,9.6999999999999993,95.064999999999998]
["dv =",{"$f":"div/25.4","v":2.9999999999999996},null,"np =",{"$f":"nlp*npl","v":4},null,null,"W 530 x 82,0",null,null,528,209,13.3,9.5,104.4654]
["dh =",{"$f":"dih/25.4","v":2.9999999999999996},null,"xCG =",0,null,null,"W 530 x 85,0",null,null,535,166,16.5,10.3,107.7244]
["ex =",{"$f":"IF(Config=\"Configuração Convencional\",IF(npl>=10,npl-4,ep/25.4),ep/25.4)","v":2.9999999999999996},null,"yCG =",4.4999999999999991,null,null,"W 530 x 92,0",null,null,533,209,15.6,10.199999999999999,117.63]
["db =","3/4\"",null,"r0 =",1,null,null,"W 530 x 101,0",null,null,537,210,17.399999999999999,10.9,130]
[null,null,null,"xCI =",-1,null,null,"W 530 x 109,0",null,null,539,211,18.8,11.6,139.69999999999999]
[null,null,null,"yCI =",0,null,null,"W 610 x 101,0",null,null,603,228,14.9,10.5,130.33160000000001]
[null,null,null,null,null,null,null,"W 610 x 113,0",null,null,608,228,17.3,11.2,145.31039999999999]
[null,null,null,"dmax =",{"$f":"MAX(K201:K204)","v":5.497851544896446},null,null,"W 610 x 125,0",null,null,612,229,19.600000000000001,11.9,160.1]
[null,null,null,"Rult =",{"$f":"0.7*120*PI()*(3/4)^2/4","v":37.110063220529433},null,null,"W 610 x 140,0",null,null,617,230,22.2,13.1,179.3]
[null,null,null,"Dmax =",{"$f":"0.34","v":0.34},null,null,"W 610 x 155,0",null,null,611,324,19,12.7,198.0926]
[null,null,null,"Pn =",104.43562301855329,null,null,"W 610 x 174,0",null,null,616,325,21.6,14,222.7936]
[null,null,null,"Erro =",9.9377356474193755E-4,null,null,"Perfil Laminado",null,null,500,250,12.5,6.35]
[null,null,null,"C =",{"$f":"Pn/Rult","v":2.8142130181222402},null,null,"@"]
[]
[null,null,null,"C' =",{"$f":"SUM(Y201:Y204)","v":11.256311935385654}]
[]
[]
["Posição",null,"Coordenadas Referentes C.G.",null,null,null,"Coordenadas Referentes C.I.R.",null,null,null,"di (in)",null,"Di (in)",null,"Ri (kips)",null,"Ri·yi/di (kips)",null,"Ri·xi/di (kips)",null,"Ri·di (kips·in)",null,"li (in)",null,"C'i (in)"]
[]
[null,null,"x0 (in)",null,"y0 (in)",null,"xi (in)",null,"yi (in)"]
[1,1,0,null,-4.4999999999999991,null,3.1585394741431121,null,-4.4999999999999991,null,5.497851544896446,null,0.34,null,36.423697762969908,null,-29.812853001735931,null,20.925571787290878,null,200.25208301698532,null,4.4999999999999991,null,4.4167707006947579]
[1,2,0,null,-1.4999999999999996,null,3.1585394741431121,null,-1.4999999999999996,null,3.4966228864034288,null,0.21623933852501984,null,34.697417236550692,null,-14.884683749341882,null,31.342574121621897,null,121.32378320841197,null,1.4999999999999996,null,1.2113852669980685]
[1,3,0,null,1.5,null,3.1585394741431121,null,1.5,null,3.4966228864034288,null,0.21623933852501984,null,34.697417236550692,null,14.884683749341887,null,31.342574121621897,null,121.32378320841197,null,1.5,null,1.2113852669980689]
[1,4,0,null,4.4999999999999991,null,3.1585394741431121,null,4.4999999999999991,null,5.497851544896446,null,0.34,null,36.423697762969908,null,29.812853001735931,null,20.925571787290878,null,200.25208301698532,null,4.4999999999999991,null,4.4167707006947579]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q201:Q204)","v":0},null,{"$f":"SUM(S201:S204)","v":104.53629181782554},null,{"$f":"SUM(U201:U204)","v":643.15173245079461},null,{"$f":"MAX(W201:W204)","v":4.4999999999999991}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104.43250955053456]

{"sheet":"Conversão de Unidades","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4]]}
["Conversão de Unidades"]
[]
[1,"=",{"$f":"A3*0.101971621","v":0.101971621},"=",{"$f":"A3*0.224808943","v":0.22480894300000001}]
[1,"=",{"$f":"A4*9.80665","v":9.8066499999999994},"=",{"$f":"A4*2.204622622","v":2.204622622}]
[1,"=",{"$f":"A5*4.448221615","v":4.4482216149999996},"=",{"$f":"A5*0.45359237","v":0.45359237000000002}]
[1,"=",{"$f":"A6*4448.22161525","v":4448.2216152499996},"=",{"$f":"A6*453.59237","v":453.59237000000002}]
[]
[1,"=",{"$f":"A8/25.4","v":3.937007874015748E-2},"=",{"$f":"C8/12","v":3.2808398950131233E-3}]
[1,"=",{"$f":"A9/2.54","v":0.39370078740157477},"=",{"$f":"C9/12","v":3.2808398950131233E-2}]
[1,"=",{"$f":"A10/12","v":8.3333333333333329E-2},"=",{"$f":"A10*25.4","v":25.4}]
[1,"=",{"$f":"A11*12","v":12},"=",{"$f":"A11*12*25.4","v":304.79999999999995}]
[]
[1,"=",{"$f":"A13*0.671968975","v":0.67196897499999997}]
[1,"=",{"$f":"A14*0.45359237/(12*25.4/1000)","v":1.4881639435695542}]
[]
[1,"=",{"$f":"A16*10.19716213","v":10.197162130000001},"=",{"$f":"A16*0.145037738","v":0.145037738}]
[1,"=",9.8066500000000001E-2,"=",{"$f":"A17*0.014223343","v":1.4223342999999999E-2}]
[1,"=",{"$f":"A18*6.894757293","v":6.8947572929999996},"=",{"$f":"A18*70.306957964","v":70.306957964000006}]
[]
["Observações:"]
["1,00 MPa = 1,00 N/mm²"]
["1,00 lb (libra) = 1,00 p (pound)"]
["1 kip = 1.000,00 lb"]
["1,00 ksi = 1,00 kip/in² = 1.000,00 psi = 1.000,00 lb/in²"]