Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    Excel Almonte

    Uploaded by

    Edward Rtz
    This document contains information about water flow and population in an area served by multiple circuits. It provides the maximum hourly flow rate of 64.85 liters/second and a population of 25,940 people. It then calculates the consumption per person and served population for each circuit and calculates the total flow rate.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Excel Almonte

    Uploaded by

    Edward Rtz
    29 views10 pages
    This document contains information about water flow and population in an area served by multiple circuits. It provides the maximum hourly flow rate of 64.85 liters/second and a population of 25,940 people. It then calculates the consumption per person and served population for each circuit and calculates the total flow rate.

    Original Title

    EXCEL ALMONTE.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains information about water flow and population in an area served by multiple circuits. It provides the maximum hourly flow rate of 64.85 liters/second and a population of 25,940 people. It then calculates the consumption per person and served population for each circuit and calculates the total flow rate.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    29 views10 pages

    Excel Almonte

    Uploaded by

    Edward Rtz
    This document contains information about water flow and population in an area served by multiple circuits. It provides the maximum hourly flow rate of 64.85 liters/second and a population of 25,940 people. It then calculates the consumption per person and served population for each circuit and calculates the total flow rate.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 10

    CAUDAL MAXIMO HORARIO 64.

    85 LTS/S
    POBLACION 25940

    interaciones por metodo de cro

    CALCULO DEL CONSUMO POR PERSONA

    AREA SERVIDA DENCIDAD


    TRAMO
    (Ha) (Hab/dia)
    1A B 7.5 532.102564
    1 3.75 532.102564
    1 7.5 532.102564
    1 7.5 532.102564
    1 7.5 532.102564
    1 7.5 532.102564
    1 7.5 532.102564
    0 0.000000
    0 0.000000
    0 0.000000
    0 0.000000
    0 0.000000
    0 0.000000
    0 0.000000
    0 0.000000
    0 0.000000
    0 0.000000
    0 0.000000
    0 0 0.000000

    ∑= 48.750000 ∑=
    metodo de cross

    POBLACION SERVIDA CONSUMO


    CONSUMO POR PERSONA
    Hab. (Lits/seg)
    3990.769231 0.002500 9.976923 1
    1995.384615 0.002500 4.988462 1
    3990.769231 0.002500 9.976923 1
    3990.769231 0.002500 9.976923 1
    3990.769231 0.002500 9.976923 0
    3990.769231 0.002500 9.976923 0
    3990.769231 0.002500 9.976923 0
    0.000000 0.000000 0.000000 0
    0.000000 0.000000 0.000000
    0.000000 0.000000 0.000000 1
    0.000000 0.000000 0.000000 1
    0.000000 0.000000 0.000000 1
    0.000000 0.000000 0.000000 1
    0.000000 0.000000 0.000000 0
    0.000000 0.000000 0.000000 0
    0.000000 0.000000 0.000000 0
    0.000000 0.000000 0.000000 0
    0.000000 0.000000 0.000000
    0.000000 0.000000 0.000000 1
    1
    1
    1
    25940.000000 ∑= 64.850000
    0
    0
    0
    0

    1
    1
    1
    1
    0
    0
    0
    0
    CUADRO DE TRAMOS INTERACIONES POR CROSS

    LONGITUD DIAMETRO Q
    CIRCUITO TRAMO CR K h
    (km) (Pulg.) (Lts/seg)
    AB 0.5 6 150 44.85 0.01315844 14.9611436
    CIRCUITO N° 1

    AD 0.3 6 150 -20 0.00789506 -2.0149348


    DE 0.5 4 150 -15 0.09479135 -14.20815
    EB 0.3 4 150 15 0.05687481 8.52488981
    0 0
    0 0
    0 0
    0 0
    ∑= 7.26294886
    EB 0.3 4 150 -15 0.05687481 -8.5248898
    CIRCUITO N° 2

    BC 0.5 4 150 19.87 0.09479135 23.9020279


    CF 0.3 4 150 9.9 0.05687481 3.95225588
    FE 0.5 4 150 -10.4 0.09479135 -7.2157316
    0 0
    0 0
    0 0
    0 0
    ∑= 12.1136623
    CIRCUITO N° 3

    ∑=
    IRCUITO N° 4
    CIRCUITO N° 4

    ∑=

    -5 5 #VALUE!
    -25

    -15625
    h/Q ∆1 CORREGIDO Q1 h h/Q ∆2

    0.3335818 -2.0134313 42.8365687 13.7423629 0.32080914 0.01919932


    0.10074674 -2.0134313 -22.013431 -2.4061785 0.10930502 0.01919932
    0.94720998 -2.0134313 -17.013431 -17.936336 1.05424566 0.01919932
    0.56832599 -2.0134313 12.9865687 6.52957048 0.50279413 0.01919932
    0 0 0 0 0 0
    0 0 0 0 0 0
    0 0 0 0 0 0
    0 0 2.28605979 0 0 0 0
    1.9498645 ∑= -0.0705812 1.98715395
    0.56832599 -2.2860598 2.01343134 -17.28606 -11.083006 0.64115282 0.00147956
    1.20292038 -2.2860598 17.5839402 19.0648618 1.08422012 0.00147956
    0.39921777 -2.2860598 7.61394021 2.43162976 0.31936549 0.00147956
    0.69382035 -2.2860598 -12.68606 -10.421331 0.82147894 0.00147956
    0 0 0 0 0 0
    0 0 0 0 0 0
    0 0 0 0 0 0
    0 0 0 0 0 0
    2.86428448 ∑= -0.0078454 2.86621737
    CORREGIDO Q2 h h/Q ∆3 CORREGIDO Q3

    42.855768 13.75375978 0.32093136 1.634724E-06 42.8557696


    -21.994232 -2.402297543 0.10922398 1.634724E-06 -21.99423
    -16.994232 -17.89890856 1.05323433 1.634724E-06 -16.99423
    13.005768 6.547440321 0.50342589 1.634724E-06 13.0057696
    0 0 0 0 0
    0 0 0 0 0
    0 0 0 0 0
    -0.0014796 0 0 0 0 5.706801E-10 0
    ∑= -6.0086E-06 1.98681556
    -0.0191993 -17.28458 -11.08125103 0.64110617 -5.7068E-10 -1.634724E-06 -17.28458
    17.5854198 19.0678296 1.08429767 -5.7068E-10 17.5854198
    7.61541976 2.432503989 0.31941824 -5.7068E-10 7.61541976
    -12.68458 -10.41908256 0.8213975 -5.7068E-10 -12.68458
    0 0 0 0 0
    0 0 0 0 0
    0 0 0 0 0
    0 0 0 0 0
    ∑= 0.000000003 2.86621958
    VELOCIDADES

    caudal caudal diametros velocidad


    Lts/seg m3/seg (m) ( m/seg )
    41.5300098 0.04153001 0.1524 2.27668118
    CIRCUITO N° 1 -23.31999 -0.02332 0.1524 -1.2784053
    -18.31999 -0.01832 0.1016 -2.2596852
    11.6800098 0.01168001 0.1016 1.44067463
    0 0 0 0
    0 0 0 0
    0 0 0 0
    0 0 0 0

    -17.28458 -0.0172846 0.1016 -2.1319722


    CIRCUITO N° 2

    17.5854198 0.01758542 0.1016 2.16907936


    7.61541976 0.00761542 0.1016 0.93932645
    -12.68458 -0.0126846 0.1016 -1.5645837
    0 0 0 0
    0 0 0 0
    0 0 0 0
    0 0 0 0

    0 0 #DIV/0!
    CIRCUITO N° 3

    0 0 #DIV/0!
    0 0 #DIV/0!
    0 0 #DIV/0!
    0 0 0
    0 0 0
    0 0 0
    0 0 0

    0 0 #DIV/0!
    CIRCUITO N° 4

    0 0 #DIV/0!
    0 0 #DIV/0!
    0 0 #DIV/0!
    0 0 0
    0 0 0
    0 0 0
    0 0 0

    You might also like