{"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":20,"n_cols":24,"rows_kept":20,"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 BD300"]
["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,"Drenagem 01",0.26242399999999999,0.4,10,2.9513333333333334,{"$f":"(D6*E6*G6)/6","v":5.163337991111111E-2},4.3400000000000001E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J6,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J6,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},175,1.0500000000000001E-2,{"$f":"IF(J6=\"BD300\",(0.1642*S6^2)+(0.237*S6)-0.0043,0)","v":1.8397903389978307E-2},{"$f":"IF(J6=\"BD300\",(-1.3918*S6^2)+(2.5237*S6)+0.1251,0)","v":0.34128243123507473},{"$f":"IFERROR((O6/P6),\"-\")","v":5.3908146761020535E-2},{"$f":"IFERROR(((Q6^(2/3))*(I6^0.5))/N6,\"-\")","v":2.8313387559886682},{"$f":"V6","v":9.0142109252662805E-2},{"$f":"IFERROR(S6/L6,\"calcular\")","v":0.34015890284023698},null,9.0142109252662805E-2,{"$f":"IFERROR(R6*O6,\"-\")","v":5.2090696896980884E-2},{"$f":"H6","v":5.163337991111111E-2}]
[null,null,"Drenagem 02",0.28485199999999999,0.4,10,2.9513333333333334,{"$f":"(D7*E7*G7)/6","v":5.6046213511111116E-2},3.7900000000000003E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J7,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J7,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},44.11,1.0500000000000001E-2,{"$f":"IF(J7=\"BD300\",(0.1642*S7^2)+(0.237*S7)-0.0043,0)","v":2.0470273285773832E-2},{"$f":"IF(J7=\"BD300\",(-1.3918*S7^2)+(2.5237*S7)+0.1251,0)","v":0.35878224552861515},{"$f":"IFERROR((O7/P7),\"-\")","v":5.7054866958686223E-2},{"$f":"IFERROR(((Q7^(2/3))*(I7^0.5))/N7,\"-\")","v":2.7478441930208062},{"$f":"V7","v":9.7878499333486593E-2},{"$f":"IFERROR(S7/L7,\"calcular\")","v":0.36935282767353428},null,9.7878499333486593E-2,{"$f":"IFERROR(R7*O7,\"-\")","v":5.6249121577862563E-2},{"$f":"H7","v":5.6046213511111116E-2}]
[null,null,"Drenagem 03",0.30728,0.4,10,2.9513333333333334,6.0459047111111115E-2,6.3899999999999998E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J8,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J8,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},25.19,1.0500000000000001E-2,1.7925463863390001E-2,0.33724611175687547,5.3152470075956491E-2,3.4033772993968139,8.8368097440653534E-2,0.33346451864397558,null,8.8368097440653534E-2,6.1007116793819441E-2,6.0459047111111115E-2]
[null,null,"Drenagem 04",4.5199999999999997E-2,0.4,10,2.9513333333333334,8.8933511111111106E-3,2.8000000000000004E-3,"BD300",{"$f":"IFERROR((VLOOKUP(J9,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J9,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},89.67,1.0500000000000001E-2,1.4094068874796526E-2,0.30385001975382175,4.6384952965333008E-2,0.65059061924327755,7.3835076435017147E-2,0.27862292994346094,null,7.3835076435017147E-2,9.1694689969112758E-3,8.8933511111111106E-3]
[null,null,"Drenagem 05",0.204155,0.4,10,2.9513333333333334,4.016863044444445E-2,2.5699999999999997E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J10,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J10,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},81.05,1.0500000000000001E-2,1.8526052174356558E-2,0.34237425149177586,5.4110529905902024E-2,2.1842304333883318,9.0622640335008511E-2,0.34197222767927737,null,9.0622640335008511E-2,4.0465166969769671E-2,4.016863044444445E-2]
[null,null,"Drenagem 06",7.7405999999999989E-2,0.4,10,2.9513333333333334,1.5230060533333332E-2,5.4299999999999994E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J11,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J11,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},39.380000000000003,1.0500000000000001E-2,7.2574583733904727E-3,0.24116764411108899,3.0093001903885048E-2,2.1471099810387635,4.722078005747609E-2,0.17819162285840034,null,4.722078005747609E-2,1.5582561310480032E-2,1.5230060533333332E-2]
[null,null,"Drenagem 07",0.46602399999999999,0.4,10,2.9513333333333334,9.1692811022222223E-2,2.9600000000000001E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J12,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J12,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},46.6,1.0500000000000001E-2,3.2488081441917421E-2,0.45407303128526766,7.1548141385888761E-2,2.8239399723530036,0.14137626664125977,0.53349534581607461,null,0.14137626664125977,9.1744391808890408E-2,9.1692811022222223E-2]
[null,null,"Drenagem 08",0.15979000000000002,0.4,10,2.9513333333333334,3.1439570222222234E-2,5.16E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J13,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J13,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},97.37,1.0500000000000001E-2,1.2024653369313127E-2,0.28530655559319312,4.2146432087100671E-2,2.6200490906794554,6.5873955678024704E-2,0.24858096482273473,null,6.5873955678024704E-2,3.1505182126004505E-2,3.1439570222222234E-2]
[null,null,"Drenagem 09",0.87521900000000008,0.4,10,2.9513333333333334,0.17220420057777783,2.87E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J14,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J14,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},51.88,1.0500000000000001E-2,5.3519114062852452E-2,0.59880199344261464,8.9376980452523125E-2,3.2252899854498329,0.21263675617107405,0.80240285347575113,null,0.21263675617107405,0.17261466261706535,0.17220420057777783]
[null,null,"Drenagem 10",0.16409400000000002,0.4,10,2.9513333333333334,3.2286406133333334E-2,5.9699999999999996E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J15,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J15,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},92.37,1.0500000000000001E-2,1.1640667801362073E-2,0.28182556985953999,4.1304512600342493E-2,2.7805424794482256,6.4387880118682198E-2,0.24297313252332903,null,6.4387880118682198E-2,3.2367371310832421E-2,3.2286406133333334E-2]
[null,null,"Drenagem 11",1.2668999999999999,0.4,10,2.9513333333333334,0.24926961333333333,2.6200000000000001E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J16,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J16,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},58.88,1.0500000000000001E-2,7.3589859546218703E-2,0.71545740533431579,0.1028570799568871,3.3841593707350963,0.27590769991352865,1.0411611317491647,null,0.27590769991352865,0.24903981277441561,0.24926961333333333]
[null,null,"Drenagem 12",0.22882,0.4,10,2.9513333333333334,4.5021606222222225E-2,4.6199999999999998E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J17,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J17,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},94.59,1.0500000000000001E-2,1.6342410022982368E-2,0.32359186979049148,5.0503153968494974E-2,2.7969026864141635,8.2395195894726145E-2,0.31092526752726846,null,8.2395195894726145E-2,4.5708130495761133E-2,4.5021606222222225E-2]
[null,null,"Drenagem 13",0.3916,0.4,10,2.9513333333333334,7.7049475555555566E-2,5.6799999999999996E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J18,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J18,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},41.52,1.0500000000000001E-2,2.2277697434074241E-2,0.37377672539251328,5.9601617545019192E-2,3.4633009579217831,0.10456668067480183,0.39459124782944088,null,0.10456668067480183,7.715437086372097E-2,7.7049475555555566E-2]
[null,null,"Drenagem 14",0.39839999999999998,0.4,10,2.9513333333333334,7.8387413333333336E-2,5.5399999999999998E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J19,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J19,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},4.51,1.0500000000000001E-2,2.2776326093110151E-2,0.37787028293334618,6.0275515492515572E-2,3.446086746192853,0.10640229630140044,0.40151809925056769,null,0.10640229630140044,7.8489195476433335E-2,7.8387413333333336E-2]
[null,null,"Drenagem 15",0.41959999999999997,0.4,10,2.9513333333333334,8.25586311111111E-2,5.0799999999999998E-2,"BD300",{"$f":"IFERROR((VLOOKUP(J20,Auxiliar!$E$4:$G$8,2,0)),\"-\")","v":0.3},{"$f":"IFERROR((VLOOKUP(J20,Auxiliar!$E$4:$G$8,3,0)),\"-\")","v":0.26500000000000001},17.93,1.0500000000000001E-2,2.4457725427870745E-2,0.39153900705830191,6.2465616418720907E-2,3.3793764796646717,0.11256230644994784,0.42476342056584088,null,0.11256230644994784,8.265186205704296E-2,8.25586311111111E-2]

{"sheet":"Auxiliar","index":1,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"Canal ACO Monoblock","Base","Hútil","Am","Pm"]
[null,null,null,null,"BD300",0.3,0.26500000000000001]