{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Chapa de Cabeça"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":27,"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":"Chapa de Cabeça","index":0,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,5,4,6],[1,5,1,6],[5,5,5,6],[2,5,2,6],[3,5,3,6],[7,4,7,5],[8,12,8,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"a'",{"$f":"K6+0.5*K8","v":31}]
["NSd (Esforço Axial)",0,"kN",null,null,"y (cm)",null,4.8932367210743806,null,"Fy da Chapa",25,"kN/cm²","e1/2",{"$f":"K4/2","v":25}]
["Msd (Momento Fletor)",7000,"kN.cm",null,null,"Momento Estático Superior",null,{"$f":"SUM(G11:G26)","v":119.71817369600234},null,"Espessura da Chapa",16.701087438996364,"mm","b+0,5db",{"$f":"K7+0.5*K8","v":31}]
["VSd (Esforço Cortante)",0,"kN",null,null,"Momento Estático Inferior",null,{"$f":"((B5/10)*H2^2)/2","v":119.71882804235378},null,"e1",50,"mm","p",{"$f":"MIN(N2:N3)+MIN(N3,K5)","v":50}]
["A Largura da Chapa)",100,"mm",null,null,"Delta",null,{"$f":"H4-H3","v":6.5434635143901687E-4},null,"e2",25,"mm","d'(mm)",{"$f":"K8+1.6","v":13.6}]
["B (Altura da Chapa)",300,"mm",null,null,"Ix (cm4)",null,{"$f":"((B5/10)*H2^3)/3+SUM(H11:H26)","v":2494.1651300054382},null,"a",25,"mm","delta",{"$f":"(N4-N5)/N4","v":0.72799999999999998}]
["Qtd de parafusos por linha",2,"Unid",null,null,null,null,null,null,"b",25,"mm","Ma(kN.cm)",{"$f":"((1.5*(N4/10)*((K3/10)^2)*K2)/6)/1.1","v":79.240432285511972}]
[null,null,null,null,null,null,null,null,null,"db",12,"mm","alfa",{"$f":"((MAX(I11:I26)*((K7-0.5*K8)/10))-N7)/(N6*N7)","v":0.98978315694782582}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N8<=1,\"APROVADO\",\"REPROVADO\")","v":"APROVADO"}]
["Linha","dy(mm)","Diam. (mm)","Fu(kN/cm²)","Cisalh. No plano de Rosca?","Área (cm²)","Mom. Estático","Ai(dy-y)²","Tração por parafuso (kN)","Admissível(kN)","Tração Adicional devido ao Efeito Alavanca","Cisalhamento Por parafuso","Adm.","Esforços Combinados:","Status"]
["d1",25,{"$f":"IF(B11=\"\",\"\",$K$8)","v":12},82.5,"SIM",{"$f":"IF(C11=\"\",\"\",((((C11/10)^2)*PI())/4)*$B$7)","v":2.2619467105846511},{"$f":"IF(B11=\"\",\"\",IF(B11<$B$6/6,0,((B11/10)-$H$2)*F11))","v":0},{"$f":"IF(B11=\"\",\"\",IF(B11<$B$6/6,0,(((B11/10)-$H$2)^2)*F11))","v":0},{"$f":"IF(B11=\"\",\"\",IF(H11=0,0,($B$3/$H$6)*((B11/10)-$H$2))*(F11/$B$7)+($B$2/(COUNTIF($B$11:$B$26,\">0\")*$B$7)))","v":0},{"$f":"IF(B11=\"\",\"\",(0.75*(F11/$B$7)*D11)/1.35)","v":51.836278784231581},{"$f":"IF(B11=\"\",\"\",IF($N$8>=0,IF((I11*(($K$7-0.5*$K$8)/10)-$N$7)/($K$6+0.5*$K$8)<0,0,(I11*(($K$7-0.5*$K$8)/10)-$N$7)/(($K$6+0.5*$K$8)/10)),0))","v":0},{"$f":"IF(B11=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":0},{"$f":"IF(B11=\"\",\"\",IF(E11=\"SIM\",(0.4*(F11/$B$7)*D11)/1.35,(0.5*(F11/$B$7)*D11)/1.35))","v":27.646015351590179},{"$f":"IF(B11=\"\",\"\",((I11+K11)/J11)^2+(L11/M11)^2)","v":0},{"$f":"IF(B11=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N11<1,\"APROVADO\",\"REPROVADO\")))","v":"APROVADO"}]
["d2",75,{"$f":"IF(B12=\"\",\"\",$K$8)","v":12},82.5,"SIM",{"$f":"IF(C12=\"\",\"\",((((C12/10)^2)*PI())/4)*$B$7)","v":2.2619467105846511},{"$f":"IF(B12=\"\",\"\",IF(B12<$B$6/6,0,((B12/10)-$H$2)*F12))","v":5.8963596240386646},{"$f":"IF(B12=\"\",\"\",IF(B12<$B$6/6,0,(((B12/10)-$H$2)^2)*F12))","v":15.370413747283662},8.2742150613300929,{"$f":"IF(B12=\"\",\"\",(0.75*(F12/$B$7)*D12)/1.35)","v":51.836278784231581},0,{"$f":"IF(B12=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":0},{"$f":"IF(B12=\"\",\"\",IF(E12=\"SIM\",(0.4*(F12/$B$7)*D12)/1.35,(0.5*(F12/$B$7)*D12)/1.35))","v":27.646015351590179},{"$f":"IF(B12=\"\",\"\",((I12+K12)/J12)^2+(L12/M12)^2)","v":2.5479211024538057E-2},{"$f":"IF(B12=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N12<1,\"APROVADO\",\"REPROVADO\")))","v":"APROVADO"}]
["d3",150,12,82.5,"SIM",{"$f":"IF(C13=\"\",\"\",((((C13/10)^2)*PI())/4)*$B$7)","v":2.2619467105846511},{"$f":"IF(B13=\"\",\"\",IF(B13<$B$6/6,0,((B13/10)-$H$2)*F13))","v":22.860959953423549},{"$f":"IF(B13=\"\",\"\",IF(B13<$B$6/6,0,(((B13/10)-$H$2)^2)*F13))","v":231.05031057825025},{"$f":"IF(B13=\"\",\"\",IF(H13=0,0,($B$3/$H$6)*((B13/10)-$H$2))*(F13/$B$7)+($B$2/(COUNTIF($B$11:$B$26,\">0\")*$B$7)))","v":32.080217494183302},{"$f":"IF(B13=\"\",\"\",(0.75*(F13/$B$7)*D13)/1.35)","v":51.836278784231581},0,{"$f":"IF(B13=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":0},{"$f":"IF(B13=\"\",\"\",IF(E13=\"SIM\",(0.4*(F13/$B$7)*D13)/1.35,(0.5*(F13/$B$7)*D13)/1.35))","v":27.646015351590179},0.38300723177010598,{"$f":"IF(B13=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N13<1,\"APROVADO\",\"REPROVADO\")))","v":"APROVADO"}]
["d4",225,12,82.5,"SIM",{"$f":"IF(C14=\"\",\"\",((((C14/10)^2)*PI())/4)*$B$7)","v":2.2619467105846511},{"$f":"IF(B14=\"\",\"\",IF(B14<$B$6/6,0,((B14/10)-$H$2)*F14))","v":39.825560282808432},{"$f":"IF(B14=\"\",\"\",IF(B14<$B$6/6,0,(((B14/10)-$H$2)^2)*F14))","v":701.19921234999015},55.886219927036507,{"$f":"IF(B14=\"\",\"\",(0.75*(F14/$B$7)*D14)/1.35)","v":51.836278784231581},8.6914147018894816,{"$f":"IF(B14=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":0},{"$f":"IF(B14=\"\",\"\",IF(E14=\"SIM\",(0.4*(F14/$B$7)*D14)/1.35,(0.5*(F14/$B$7)*D14)/1.35))","v":27.646015351590179},1.5520175688386746,{"$f":"IF(B14=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N14<1,\"APROVADO\",\"REPROVADO\")))","v":"REPROVADO"}]
["d5",275,12,82.5,"SIM",{"$f":"IF(C15=\"\",\"\",((((C15/10)^2)*PI())/4)*$B$7)","v":2.2619467105846511},{"$f":"IF(B15=\"\",\"\",IF(B15<$B$6/6,0,((B15/10)-$H$2)*F15))","v":51.135293835731687},{"$f":"IF(B15=\"\",\"\",IF(B15<$B$6/6,0,(((B15/10)-$H$2)^2)*F15))","v":1156.0034829426907},71.756888215605315,{"$f":"IF(B15=\"\",\"\",(0.75*(F15/$B$7)*D15)/1.35)","v":51.836278784231581},18.418598491657463,{"$f":"IF(B15=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":0},{"$f":"IF(B15=\"\",\"\",IF(E15=\"SIM\",(0.4*(F15/$B$7)*D15)/1.35,(0.5*(F15/$B$7)*D15)/1.35))","v":27.646015351590179},3.0262817318964412,{"$f":"IF(B15=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N15<1,\"APROVADO\",\"REPROVADO\")))","v":"REPROVADO"}]
["d6",null,"",null,null,{"$f":"IF(C16=\"\",\"\",((((C16/10)^2)*PI())/4)*$B$7)","v":""},{"$f":"IF(B16=\"\",\"\",IF(B16<$B$6/6,0,((B16/10)-$H$2)*F16))","v":""},{"$f":"IF(B16=\"\",\"\",IF(B16<$B$6/6,0,(((B16/10)-$H$2)^2)*F16))","v":""},"",{"$f":"IF(B16=\"\",\"\",(0.75*(F16/$B$7)*D16)/1.35)","v":""},"",{"$f":"IF(B16=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":""},{"$f":"IF(B16=\"\",\"\",IF(E16=\"SIM\",(0.4*(F16/$B$7)*D16)/1.35,(0.5*(F16/$B$7)*D16)/1.35))","v":""},"",{"$f":"IF(B16=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N16<1,\"APROVADO\",\"REPROVADO\")))","v":""}]
["d7",null,"",null,null,{"$f":"IF(C17=\"\",\"\",((((C17/10)^2)*PI())/4)*$B$7)","v":""},{"$f":"IF(B17=\"\",\"\",IF(B17<$B$6/6,0,((B17/10)-$H$2)*F17))","v":""},{"$f":"IF(B17=\"\",\"\",IF(B17<$B$6/6,0,(((B17/10)-$H$2)^2)*F17))","v":""},"",{"$f":"IF(B17=\"\",\"\",(0.75*(F17/$B$7)*D17)/1.35)","v":""},"",{"$f":"IF(B17=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":""},{"$f":"IF(B17=\"\",\"\",IF(E17=\"SIM\",(0.4*(F17/$B$7)*D17)/1.35,(0.5*(F17/$B$7)*D17)/1.35))","v":""},"",{"$f":"IF(B17=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N17<1,\"APROVADO\",\"REPROVADO\")))","v":""}]
["d8",null,"",null,null,{"$f":"IF(C18=\"\",\"\",((((C18/10)^2)*PI())/4)*$B$7)","v":""},{"$f":"IF(B18=\"\",\"\",IF(B18<$B$6/6,0,((B18/10)-$H$2)*F18))","v":""},{"$f":"IF(B18=\"\",\"\",IF(B18<$B$6/6,0,(((B18/10)-$H$2)^2)*F18))","v":""},"",{"$f":"IF(B18=\"\",\"\",(0.75*(F18/$B$7)*D18)/1.35)","v":""},"",{"$f":"IF(B18=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":""},{"$f":"IF(B18=\"\",\"\",IF(E18=\"SIM\",(0.4*(F18/$B$7)*D18)/1.35,(0.5*(F18/$B$7)*D18)/1.35))","v":""},"",{"$f":"IF(B18=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N18<1,\"APROVADO\",\"REPROVADO\")))","v":""}]
["d9",null,"",null,null,{"$f":"IF(C19=\"\",\"\",((((C19/10)^2)*PI())/4)*$B$7)","v":""},{"$f":"IF(B19=\"\",\"\",IF(B19<$B$6/6,0,((B19/10)-$H$2)*F19))","v":""},{"$f":"IF(B19=\"\",\"\",IF(B19<$B$6/6,0,(((B19/10)-$H$2)^2)*F19))","v":""},"",{"$f":"IF(B19=\"\",\"\",(0.75*(F19/$B$7)*D19)/1.35)","v":""},"",{"$f":"IF(B19=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":""},{"$f":"IF(B19=\"\",\"\",IF(E19=\"SIM\",(0.4*(F19/$B$7)*D19)/1.35,(0.5*(F19/$B$7)*D19)/1.35))","v":""},"",{"$f":"IF(B19=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N19<1,\"APROVADO\",\"REPROVADO\")))","v":""}]
["d10",null,"",null,null,{"$f":"IF(C20=\"\",\"\",((((C20/10)^2)*PI())/4)*$B$7)","v":""},{"$f":"IF(B20=\"\",\"\",IF(B20<$B$6/6,0,((B20/10)-$H$2)*F20))","v":""},{"$f":"IF(B20=\"\",\"\",IF(B20<$B$6/6,0,(((B20/10)-$H$2)^2)*F20))","v":""},"",{"$f":"IF(B20=\"\",\"\",(0.75*(F20/$B$7)*D20)/1.35)","v":""},"",{"$f":"IF(B20=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":""},{"$f":"IF(B20=\"\",\"\",IF(E20=\"SIM\",(0.4*(F20/$B$7)*D20)/1.35,(0.5*(F20/$B$7)*D20)/1.35))","v":""},"",{"$f":"IF(B20=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N20<1,\"APROVADO\",\"REPROVADO\")))","v":""}]
["d11",null,"",null,null,{"$f":"IF(C21=\"\",\"\",((((C21/10)^2)*PI())/4)*$B$7)","v":""},{"$f":"IF(B21=\"\",\"\",IF(B21<$B$6/6,0,((B21/10)-$H$2)*F21))","v":""},{"$f":"IF(B21=\"\",\"\",IF(B21<$B$6/6,0,(((B21/10)-$H$2)^2)*F21))","v":""},"",{"$f":"IF(B21=\"\",\"\",(0.75*(F21/$B$7)*D21)/1.35)","v":""},"",{"$f":"IF(B21=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":""},{"$f":"IF(B21=\"\",\"\",IF(E21=\"SIM\",(0.4*(F21/$B$7)*D21)/1.35,(0.5*(F21/$B$7)*D21)/1.35))","v":""},"",{"$f":"IF(B21=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N21<1,\"APROVADO\",\"REPROVADO\")))","v":""}]
["d12",null,"",null,null,{"$f":"IF(C22=\"\",\"\",((((C22/10)^2)*PI())/4)*$B$7)","v":""},{"$f":"IF(B22=\"\",\"\",IF(B22<$B$6/6,0,((B22/10)-$H$2)*F22))","v":""},{"$f":"IF(B22=\"\",\"\",IF(B22<$B$6/6,0,(((B22/10)-$H$2)^2)*F22))","v":""},"",{"$f":"IF(B22=\"\",\"\",(0.75*(F22/$B$7)*D22)/1.35)","v":""},"",{"$f":"IF(B22=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":""},{"$f":"IF(B22=\"\",\"\",IF(E22=\"SIM\",(0.4*(F22/$B$7)*D22)/1.35,(0.5*(F22/$B$7)*D22)/1.35))","v":""},"",{"$f":"IF(B22=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N22<1,\"APROVADO\",\"REPROVADO\")))","v":""}]
["d13",null,"",null,null,{"$f":"IF(C23=\"\",\"\",((((C23/10)^2)*PI())/4)*$B$7)","v":""},{"$f":"IF(B23=\"\",\"\",IF(B23<$B$6/6,0,((B23/10)-$H$2)*F23))","v":""},{"$f":"IF(B23=\"\",\"\",IF(B23<$B$6/6,0,(((B23/10)-$H$2)^2)*F23))","v":""},"",{"$f":"IF(B23=\"\",\"\",(0.75*(F23/$B$7)*D23)/1.35)","v":""},"",{"$f":"IF(B23=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":""},{"$f":"IF(B23=\"\",\"\",IF(E23=\"SIM\",(0.4*(F23/$B$7)*D23)/1.35,(0.5*(F23/$B$7)*D23)/1.35))","v":""},"",{"$f":"IF(B23=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N23<1,\"APROVADO\",\"REPROVADO\")))","v":""}]
["d14",null,"",null,null,{"$f":"IF(C24=\"\",\"\",((((C24/10)^2)*PI())/4)*$B$7)","v":""},{"$f":"IF(B24=\"\",\"\",IF(B24<$B$6/6,0,((B24/10)-$H$2)*F24))","v":""},{"$f":"IF(B24=\"\",\"\",IF(B24<$B$6/6,0,(((B24/10)-$H$2)^2)*F24))","v":""},"",{"$f":"IF(B24=\"\",\"\",(0.75*(F24/$B$7)*D24)/1.35)","v":""},"",{"$f":"IF(B24=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":""},{"$f":"IF(B24=\"\",\"\",IF(E24=\"SIM\",(0.4*(F24/$B$7)*D24)/1.35,(0.5*(F24/$B$7)*D24)/1.35))","v":""},"",{"$f":"IF(B24=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N24<1,\"APROVADO\",\"REPROVADO\")))","v":""}]
["d15",null,"",null,null,{"$f":"IF(C25=\"\",\"\",((((C25/10)^2)*PI())/4)*$B$7)","v":""},{"$f":"IF(B25=\"\",\"\",IF(B25<$B$6/6,0,((B25/10)-$H$2)*F25))","v":""},{"$f":"IF(B25=\"\",\"\",IF(B25<$B$6/6,0,(((B25/10)-$H$2)^2)*F25))","v":""},"",{"$f":"IF(B25=\"\",\"\",(0.75*(F25/$B$7)*D25)/1.35)","v":""},"",{"$f":"IF(B25=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":""},{"$f":"IF(B25=\"\",\"\",IF(E25=\"SIM\",(0.4*(F25/$B$7)*D25)/1.35,(0.5*(F25/$B$7)*D25)/1.35))","v":""},"",{"$f":"IF(B25=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N25<1,\"APROVADO\",\"REPROVADO\")))","v":""}]
["d16",null,"",null,null,{"$f":"IF(C26=\"\",\"\",((((C26/10)^2)*PI())/4)*$B$7)","v":""},{"$f":"IF(B26=\"\",\"\",IF(B26<$B$6/6,0,((B26/10)-$H$2)*F26))","v":""},{"$f":"IF(B26=\"\",\"\",IF(B26<$B$6/6,0,(((B26/10)-$H$2)^2)*F26))","v":""},"",{"$f":"IF(B26=\"\",\"\",(0.75*(F26/$B$7)*D26)/1.35)","v":""},"",{"$f":"IF(B26=\"\",\"\",$B$4/($B$7*(COUNTIF($B$11:$B$26,\">0\"))))","v":""},{"$f":"IF(B26=\"\",\"\",IF(E26=\"SIM\",(0.4*(F26/$B$7)*D26)/1.35,(0.5*(F26/$B$7)*D26)/1.35))","v":""},"",{"$f":"IF(B26=\"\",\"\",IF(OR($H$5>0.001,$H$5<-0.001),\"CALCULAR Y\",IF(N26<1,\"APROVADO\",\"REPROVADO\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B27=\"\",\"\",IF(E27=\"SIM\",(0.4*(F27/$B$7)*D27)/1.35,(0.5*(F27/$B$7)*D27)/1.35))","v":""}]