{"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 MD"]
["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.01,0.85,10,2.0031666666666665,{"$f":"(D6*E6*G6)/6","v":2.8378194444444445E-3},1.3249999999999939E-2,"MD100 0.0",{"$f":"IFERROR((VLOOKUP(J6,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.1},{"$f":"IFERROR((VLOOKUP(J6,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":9.9000000000000005E-2},40,1.0500000000000001E-2,{"$f":"IF(J6=\"MD150 0.0\",(0.2787*S6^2)+(0.0839*S6)-(0.001),IF(J6=\"MD100 0.0\",(0.2287*S6^2)+(0.0641*S6)-(0.0006),0))","v":3.96233082108601E-3},{"$f":"IF(J6=\"MD150 0.0\",(-1.4129*S6^2)+(2.3607*S6)+0.041,IF(J6=\"MD100 0.0\",(-2.6888*S6^2)+(2.4192*S6)+0.0283,0))","v":0.16131115943885771},{"$f":"IFERROR((O6/P6),\"-\")","v":2.4563277797205747E-2},{"$f":"IFERROR(((Q6^(2/3))*(I6^0.5))/N6,\"-\")","v":0.92635230536979485},{"$f":"V6","v":5.8827848918875165E-2},{"$f":"IFERROR(S6/L6,\"calcular\")","v":0.59422069615025419},null,5.8827848918875165E-2,{"$f":"IFERROR(R6*O6,\"-\")","v":3.6705142907508177E-3},{"$f":"H6","v":2.8378194444444445E-3}]
[null,null,null,null,0.85,10,2.0031666666666665,{"$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=\"MD150 0.0\",(0.2787*S7^2)+(0.0839*S7)-(0.001),IF(J7=\"MD100 0.0\",(0.2287*S7^2)+(0.0641*S7)-(0.0006),0))","v":0},{"$f":"IF(J7=\"MD150 0.0\",(-1.4129*S7^2)+(2.3607*S7)+0.041,IF(J7=\"MD100 0.0\",(-2.6888*S7^2)+(2.4192*S7)+0.0283,0))","v":0},{"$f":"IFERROR((O7/P7),\"-\")","v":"-"},{"$f":"IFERROR(((Q7^(2/3))*(I7^0.5))/N7,\"-\")","v":"-"},{"$f":"V7","v":0.18371110153993492},{"$f":"IFERROR(S7/L7,\"calcular\")","v":"calcular"},null,0.18371110153993492,{"$f":"IFERROR(R7*O7,\"-\")","v":"-"},{"$f":"H7","v":0}]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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,"-","-",0.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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.18371110153993492,"calcular",null,0.18371110153993492,"-",0]
[null,null,null,null,0.85,10,2.0031666666666665,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.18371110153993492,"calcular",null,0.18371110153993492,"-",0]

{"sheet":"Auxiliar","index":1,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"Canal ACO Monoblock","Base","Hútil","Am","Pm"]
[null,null,null,null,"MD100 0.0",0.1,9.9000000000000005E-2]
[null,null,null,null,"MD150 0.0",0.15,0.15]