{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Canaleta de concreto polímero","Auxiliar"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Canaleta de concreto polímero","index":0,"n_rows":35,"n_cols":24,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,9,4,9],[1,13,1,19],[1,10,1,11],[0,0,0,19],[1,12,2,12]]}
["PLANILHA DE CÁLCULO  -  CANALETA PD"]
["km",null,"POSIÇÃO","ÁREA",null,"TEMPO  DE","INTENS.","VAZÃO","DECLIVI-","TIPO DE CANALETA","DIMENSÕES",null,"COMPRI-MENTO","DIMENSIONAMENTO"]
[null,null,null,"A","C","CONCEN-","PLUVIO-","Q","DADE",null,"b","h",null,"RUGOSIDADE","ÁREA","PERÍMETRO","RAIO ","VELOCIDADE","LÂMINA","RELAÇÃO",null,"H","Qesc","Qatingir"]
["INICIAL","FINAL","RELATIVA",null,null,"TRAÇÃO","MÉTRICA",null,"I",null,null,null,"L","DE MANNING","MOLHADA","MOLHADO","HIDRÁULICO",null,"Y","Y/H",null,null,"Manning","Racional"]
[null,null,null,"( ha )",null,"tc ( min. )","i ( mm/min. )","( m3/s )","( m/m )",null,"(m)","(m)","(m)",null,"( m² )","(m)","(m)","( m/s )","( m )",null,null,"( m)","( m³/s )","( m³/s )"]
[null,null,null,0.5,0.9,10,2,{"$f":"(D6*E6*G6)/6","v":0.15},0.01,"PD200V 30.0",{"$f":"IFERROR((VLOOKUP(J6,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.2},{"$f":"IFERROR((VLOOKUP(J6,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.5},150,1.0500000000000001E-2,{"$f":"IF(J6=\"PD100V 0.0\",(0.0773*S6^2)+(0.085*S6)-(0.0011),IF(J6=\"PD200V 0.0\",(0.1205*S6^2)+(0.1625*S6)-(0.0031),IF(J6=\"PD200V 30.0\",0.0571*S6^2+0.1689*S6-0.005,0)))","v":8.1796388170525675E-2},{"$f":"IF(J6=\"PD100V 0.0\",(-0.9956*S6^2)+(2.2005*S6)+0.0368,IF(J6=\"PD200V 0.0\",(-1.3*S6^2)+(2.377*S6)+0.075,IF(J6=\"PD200V 30.0\",-0.2783*S6^2+2.1511*S6+0.0634,0)))","v":0.96837458276616095},{"$f":"IFERROR((O6/P6),\"-\")","v":8.4467714896930043E-2},{"$f":"IFERROR(((Q6^(2/3))*(I6^0.5))/N6,\"-\")","v":1.8334589796736003},{"$f":"V6","v":0.44649524169202942},{"$f":"IFERROR(S6/L6,\"calcular\")","v":0.89299048338405884},null,0.44649524169202942,{"$f":"IFERROR(R6*O6,\"-\")","v":0.14997032239611774},{"$f":"H6","v":0.15}]
[null,null,null,null,0.9,10,2.0449999999999999,{"$f":"(D7*E7*G7)/6","v":0},null,null,{"$f":"IFERROR((VLOOKUP(J7,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J7,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,{"$f":"IF(J7=\"PD100V 0.0\",(0.0773*S7^2)+(0.085*S7)-(0.0011),IF(J7=\"PD200V 0.0\",(0.1205*S7^2)+(0.1625*S7)-(0.0031),IF(J7=\"PD200V 30.0\",0.0571*S7^2+0.1689*S7-0.005,0)))","v":0},{"$f":"IF(J7=\"PD100V 0.0\",(-0.9956*S7^2)+(2.2005*S7)+0.0368,IF(J7=\"PD200V 0.0\",(-1.3*S7^2)+(2.377*S7)+0.075,IF(J7=\"PD200V 30.0\",-0.2783*S7^2+2.1511*S7+0.0634,0)))","v":0},{"$f":"IFERROR((O7/P7),\"-\")","v":"-"},{"$f":"IFERROR(((Q7^(2/3))*(I7^0.5))/N7,\"-\")","v":"-"},{"$f":"V7","v":3.7017751748569458E-2},{"$f":"IFERROR(S7/L7,\"calcular\")","v":"calcular"},null,3.7017751748569458E-2,{"$f":"IFERROR(R7*O7,\"-\")","v":"-"},{"$f":"H7","v":0}]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J8,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J8,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J9,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J9,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J10,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J10,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J11,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J11,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J12,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J12,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J13,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J13,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J14,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J14,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J15,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J15,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,{"$f":"(D16*E16*G16)/6","v":0},null,null,{"$f":"IFERROR((VLOOKUP(J16,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J16,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,{"$f":"IFERROR((O16/P16),\"-\")","v":"-"},{"$f":"IFERROR(((Q16^(2/3))*(I16^0.5))/N16,\"-\")","v":"-"},{"$f":"V16","v":3.7017751748569458E-2},{"$f":"IFERROR(S16/L16,\"calcular\")","v":"calcular"},null,3.7017751748569458E-2,{"$f":"IFERROR(R16*O16,\"-\")","v":"-"},{"$f":"H16","v":0}]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J17,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J17,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J18,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J18,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J19,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J19,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J20,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J20,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J21,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J21,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J22,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J22,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J23,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J23,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J24,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J24,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",3.7017751748569458E-2,"calcular",null,3.7017751748569458E-2,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,{"$f":"(D25*E25*G25)/6","v":0},null,null,{"$f":"IFERROR((VLOOKUP(J25,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J25,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,{"$f":"IFERROR((O25/P25),\"-\")","v":"-"},{"$f":"IFERROR(((Q25^(2/3))*(I25^0.5))/N25,\"-\")","v":"-"},{"$f":"V25","v":3.7017751748569458E-2},{"$f":"IFERROR(S25/L25,\"calcular\")","v":"calcular"},null,3.7017751748569458E-2,{"$f":"IFERROR(R25*O25,\"-\")","v":"-"},{"$f":"H25","v":0}]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J26,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J26,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",0.01,{"$f":"IFERROR(S26/L26,\"calcular\")","v":"calcular"},null,0.01,{"$f":"IFERROR(R26*O26,\"-\")","v":"-"},{"$f":"H26","v":0}]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J27,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J27,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",0.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J28,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J28,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",0.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J29,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J29,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",0.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J30,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J30,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",0.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J31,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J31,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",0.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J32,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J32,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",0.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J33,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J33,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",0.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J34,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J34,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",0.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,2.0449999999999999,0,null,null,{"$f":"IFERROR((VLOOKUP(J35,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":"-"},{"$f":"IFERROR((VLOOKUP(J35,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":"-"},null,1.0500000000000001E-2,0,0,"-","-",0.01,"calcular",null,0.01,"-",0]

{"sheet":"Auxiliar","index":1,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"Canal ACO Monoblock","Base","Hútil","Am","Pm"]
[null,null,null,null,"PD100V 0.0",0.1,0.154]
[null,null,null,null,"PD200V 0.0",0.2,0.215]
[null,null,null,null,"PD200V 30.0",0.2,0.5]