{"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":2,"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":34,"n_cols":24,"rows_kept":34,"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 RD"]
["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.35,0.9,10,{"$f":"(19.7523*(F6+20)^-0.7872)+(5.5111*(F6+20)^-0.7609)*(-0.4766+(-0.8977*(LN(LN(10/(10-1))))))+(0*(F6+0)^0)*(LN(10-0.5))","v":1.9972429691989966},{"$f":"(((D6*E6))*G6)*0.16667","v":0.10485735298806499},0.02,"RD200V 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=\"RD150V 0.0\",0.2697*S6^2+0.0819*S6-0.001,IF(J6=\"RD150V 10.0\",0.0693*S6^2+0.1222*S6-0.0027,IF(J6=\"RD200V 0.0\",0.3004*S6^2+0.1063*S6-0.0018,IF(J6=\"RD200V 20.0\",0.0571*S6^2+0.1689*S6-0.005,IF(J6=\"RD200V 30.0\",0.0571*S6^2+0.1689*S6-0.005,0)))))","v":4.5054129086950875E-2},{"$f":"IF(J6=\"RD150V 0.0\",-1.3226*S6^2+2.3282*S6+0.0408,IF(J6=\"RD150V 10.0\",-0.3626*S6^2+2.1349*S6+0.0491,IF(J6=\"RD200V 0.0\",-1.2365*S6^2+2.4051*S6+0.05,IF(J6=\"RD200V 20.0\",-0.2783*S6^2+2.1511*S6+0.0634,IF(J6=\"RD200V 30.0\",-0.2783*S6^2+2.1511*S6+0.0634,0)))))","v":0.62679757221668353},{"$f":"IFERROR((O6/P6),\"-\")","v":7.1879871722565783E-2},{"$f":"IFERROR(((Q6^(2/3))*(I6^0.5))/N6,\"-\")","v":2.3284337967539139},{"$f":"V6","v":0.2714440206588688},{"$f":"IFERROR(S6/L6,\"calcular\")","v":0.5428880413177376},null,0.2714440206588688,{"$f":"IFERROR(R6*O6,\"-\")","v":0.10490555684936997},{"$f":"H6","v":0.10485735298806499}]
[null,null,null,null,0.9,10,{"$f":"(19.7523*(F7+20)^-0.7872)+(5.5111*(F7+20)^-0.7609)*(-0.4766+(-0.8977*(LN(LN(10/(10-1))))))+(0*(F7+0)^0)*(LN(10-0.5))","v":1.9972429691989966},{"$f":"(((D7*E7))*G7)*0.16667","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=\"RD150V 0.0\",0.2697*S7^2+0.0819*S7-0.001,IF(J7=\"RD150V 10.0\",0.0693*S7^2+0.1222*S7-0.0027,IF(J7=\"RD200V 0.0\",0.3004*S7^2+0.1063*S7-0.0018,IF(J7=\"RD200V 20.0\",0.0571*S7^2+0.1689*S7-0.005,0))))","v":0},{"$f":"IF(J7=\"RD150V 0.0\",-1.3226*S7^2+2.3282*S7+0.0408,IF(J7=\"RD150V 10.0\",-0.3626*S7^2+2.1349*S7+0.0491,IF(J7=\"RD200V 0.0\",-1.2365*S7^2+2.4051*S7+0.05,IF(J7=\"RD200V 20.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":0.60046918827874518},{"$f":"IFERROR(S7/L7,\"calcular\")","v":"calcular"},null,0.60046918827874518,{"$f":"IFERROR(R7*O7,\"-\")","v":"-"},{"$f":"H7","v":0}]
[null,null,null,null,0.9,10,{"$f":"(19.7523*(F8+20)^-0.7872)+(5.5111*(F8+20)^-0.7609)*(-0.4766+(-0.8977*(LN(LN(10/(10-1))))))+(0*(F8+0)^0)*(LN(10-0.5))","v":1.9972429691989966},{"$f":"(((D8*E8))*G8)*0.16667","v":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,{"$f":"IF(J8=\"RD150V 0.0\",0.2697*S8^2+0.0819*S8-0.001,IF(J8=\"RD150V 10.0\",0.0693*S8^2+0.1222*S8-0.0027,IF(J8=\"RD200V 0.0\",0.3004*S8^2+0.1063*S8-0.0018,IF(J8=\"RD200V 20.0\",0.0571*S8^2+0.1689*S8-0.005,0))))","v":0},{"$f":"IF(J8=\"RD150V 0.0\",-1.3226*S8^2+2.3282*S8+0.0408,IF(J8=\"RD150V 10.0\",-0.3626*S8^2+2.1349*S8+0.0491,IF(J8=\"RD200V 0.0\",-1.2365*S8^2+2.4051*S8+0.05,IF(J8=\"RD200V 20.0\",-0.2783*S8^2+2.1511*S8+0.0634,0))))","v":0},{"$f":"IFERROR((O8/P8),\"-\")","v":"-"},{"$f":"IFERROR(((Q8^(2/3))*(I8^0.5))/N8,\"-\")","v":"-"},{"$f":"V8","v":0.2087482759461054},{"$f":"IFERROR(S8/L8,\"calcular\")","v":"calcular"},null,0.2087482759461054,{"$f":"IFERROR(R8*O8,\"-\")","v":"-"},{"$f":"H8","v":0}]
[null,null,null,null,0.9,10,1.9972429691989966,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,{"$f":"IFERROR((O9/P9),\"-\")","v":"-"},{"$f":"IFERROR(((Q9^(2/3))*(I9^0.5))/N9,\"-\")","v":"-"},0.31911780110475402,{"$f":"IFERROR(S9/L9,\"calcular\")","v":"calcular"},null,0.31911780110475402,{"$f":"IFERROR(R9*O9,\"-\")","v":"-"},0]
[null,null,null,null,0.9,10,1.9972429691989966,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.30546432233736798,"calcular",null,0.30546432233736798,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.2285219435149686,"calcular",null,0.2285219435149686,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.2218358202377243,"calcular",null,0.2218358202377243,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.18843454750665425,"calcular",null,0.18843454750665425,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.17864548421815743,"calcular",null,0.17864548421815743,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.18154968187169238,"calcular",null,0.18154968187169238,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.26838365871828584,"calcular",null,0.26838365871828584,"-",0]
[null,null,null,null,0.9,10,{"$f":"(19.7523*(F17+20)^-0.7872)+(5.5111*(F17+20)^-0.7609)*(-0.4766+(-0.8977*(LN(LN(10/(10-1))))))+(0*(F17+0)^0)*(LN(10-0.5))","v":1.9972429691989966},{"$f":"(((D17*E17))*G17)*0.16667","v":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.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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.01,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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,"calcular",null,0.01,"-",0]
[null,null,null,null,0.9,10,1.9972429691989966,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,1.9972429691989966,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,1.9972429691989966,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,1.9972429691989966,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,1.9972429691989966,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,1.9972429691989966,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,1.9972429691989966,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,1.9972429691989966,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]

{"sheet":"Auxiliar","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[22,9,23,9],[24,9,25,9]]}
[]
[]
[null,null,null,null,"Canal ACO Monoblock","Base","Hútil","Descrição DNIT"]
[null,null,null,null,"RD150V 0.0",0.15,{"$f":"0.155","v":0.155},"CANAL/GRELHA MONOBLOCO DE CONCRETO POLÍMERO 21X28,0"]
[null,null,null,null,"RD150V 10.0",0.15,0.255,"CANAL/GRELHA MONOBLOCO DE CONCRETO POLÍMERO 21X38,0"]
[null,null,null,null,"RD200V 0.0",0.2,0.2,"CANAL/GRELHA MONOBLOCO DE CONCRETO POLÍMERO 26X33,0"]
[null,null,null,null,"RD200V 20.0",0.2,0.4,"CANAL/GRELHA MONOBLOCO DE CONCRETO POLÍMERO 26X53,0"]
[null,null,null,null,"RD200V 30.0",0.2,0.5,"CANAL/GRELHA MONOBLOCO DE CONCRETO POLÍMERO 26X63,0","ainda não esta no Álbum do DNIT"]