{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Rede_Exemplo","Plan3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Rede_Exemplo","index":0,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,1,0,14],[1,1,1,14],[2,1,2,14],[3,0,3,19],[4,0,4,19],[5,0,5,19],[6,0,8,0],[6,1,8,2],[6,3,7,3],[6,4,7,7],[6,8,7,8],[6,9,7,9],[6,12,7,13],[6,18,7,19],[35,15,35,17],[26,1,26,13],[36,15,36,17],[6,16,7,17],[30,15,30,17],[31,15,31,17],[26,15,26,19],[18,16,18,19],[24,1,24,13],[32,15,32,17],[33,15,33,17],[27,15,27,17],[25,0,25,4],[28,15,28,17],[29,15,29,17],[34,15,34,17]],"flags":["formulas_cached_only"]}
[null,"Universidade Regional do Cariri - URCA"]
[null,"Disciplina: Saneamento Básico"]
[null,"Prof. Renato de Oliveira Fernandes"]
["Sistema de Abastecimento de Água"]
["Exemplo de Rede Ramificada"]
["Planilha de Cálculo de Rede."]
["Trecho","Nó",null,"Extensão","Vazão   (l/s)",null,null,null,"Diâmetro","Velocidade","Perda de Carga","Perda de","Cota do Terreno",null,"Cota ","Cota ","Pressão Dinâmica",null,"Pressão Estática"]
[{"$nulls":10}," Unitária  (J)","Carga no ",null,null,"Piezométrica","Piezométrica"]
[null,null,null,"(m)","Jusante","Em Marcha","Montante","Fictícia","mm ou DN","m/s","m/m","Trecho (Hf)","Montante","Jusante","a  Montante","a  Jusante","Montante","Jusante","Montante","Jusante"]
[1,"N1","N2",100,0,1.5432098765432098,1.5432098765432098,0.7716049382716049,50,0.3931744908390343,0.0049427163308217986,0.49427163308217986,70,81,91.49427163308218,91,21.494271633082178,10,22.63285700701819,11.632857007018188]
[2,"N2","N3",100,1.5432098765432098,1.5432098765432098,3.0864197530864197,2.314814814814815,100,0.2948808681292757,0.0012897379964036605,0.12897379964036607,72,70,91.62324543272254,91.49427163308218,19.62324543272254,21.494271633082178,20.63285700701819,22.63285700701819]
[3,"N3","N4",150,0,2.314814814814815,2.314814814814815,1.1574074074074074,75,0.2621163272260229,0.0014522709489967235,0.21784064234950853,72,76,91.62324543272254,91.40540479037303,19.62324543272254,15.405404790373026,20.63285700701819,16.63285700701819]
[4,"N3","N8",150,5.401234567901234,2.314814814814815,7.716049382716049,6.558641975308642,150,0.3713314635701991,0.0012293845596158082,0.18440768394237123,78.2,72,91.80765311666491,91.62324543272254,13.607653116664906,19.62324543272254,14.432857007018185,20.63285700701819]
[5,"N5","N7",80,0,1.2345679012345678,1.2345679012345678,0.6172839506172839,50,0.31453959267122744,0.0032700901702920862,0.2616072136233669,74,72.5,90.87775154394046,90.6161443303171,16.877751543940462,18.1161443303171,18.63285700701819,20.13285700701819]
[6,"N6","N7",120,0,1.8518518518518516,1.8518518518518516,0.9259259259259258,50,0.4718093890068411,0.0069235456082171135,0.8308254729860536,74,60.2,90.87775154394046,90.04692607095441,16.877751543940462,29.84692607095441,18.63285700701819,32.432857007018185]
[7,"N7","N8",200,3.0864197530864192,3.0864197530864197,6.1728395061728385,4.629629629629629,100,0.5897617362585513,0.0046495078636222525,0.9299015727244505,78.2,74,91.80765311666491,90.87775154394046,13.607653116664906,16.877751543940462,14.432857007018185,18.63285700701819]
[8,"N8","N9",450,13.888888888888888,6.944444444444444,20.833333333333332,17.36111111111111,200,0.552901627742392,0.0018337864230072963,0.8252038903532833,85,78.2,92.63285700701819,91.80765311666491,7.632857007018188,13.607653116664906,7.632857007018188,14.432857007018185]
[]
[null,"Observação: o ponto mais desfavorável de pressões é o que possui cota mais alta e está mais distante do reservatório (N1 do trecho 1)",{"$nulls":14},"TESTE DE PRESSÕES"]
[null,"Nesse ponto devemos impor uma pressão dinâmica mínima de 10 mca.",{"$nulls":14},"P. Mín.","P. Mín.","P. Máx.","P. Máx."]
[{"$nulls":16},13.607653116664906,10,22.63285700701819,32.432857007018185]
[{"$nulls":16},"OK","OK","OK","OK"]
[]
[]
[null,"CROQUI DA REDE DE ÁGUA"]
[]
[{"$nulls":15},"DADOS DE PROJETO"]
[{"$nulls":15},"L   Total   =",null,null,1350,"m"]
[{"$nulls":15},"População de Projeto  =",null,null,5000,"Hab."]
[{"$nulls":15},"Consumo percapita =",null,null,200,"L/hab.dia"]
[{"$nulls":15},"Coef. K1=",null,null,1.2,"-"]
[{"$nulls":15},"Coef. K2=",null,null,1.5,"-"]
[{"$nulls":15},"Coeficiente C do material =",null,null,130,"-"]
[{"$nulls":15},"Vazão Máxima =",null,null,20.833333333333332,"L/s"]
[{"$nulls":15},"Vazão de Consumo Linear=",null,null,0.015432098765432098,"L/s.m"]
[{"$nulls":15},"Cota do Reservatório=",null,null,85,"m"]
[{"$nulls":15},"Nível da água no Reserv.=",null,null,92.63285700701819,"m"]
{"$rows_empty":12}
[{"$nulls":9},"Fonte: Tsutiya"]

{"sheet":"Plan3","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}