capacidad reservorio

Upload: joseph-orrillo

Post on 02-Mar-2016

7 views

Category:

Documents


0 download

DESCRIPTION

Hoja de cálculo para determinar la capacidad de un reservorio.

TRANSCRIPT

  • CAPACIDAD DE RESERVORIOHORAS DE BOMBEO

    HORA1 AM 237.412 237.412 272.02483333 34.6132 AM 416.208 178.796 272.02483333 127.8423 AM 565.616 149.408 272.02483333 250.4594 AM 701.684 136.068 272.02483333 386.4155 AM 853.760 152.076 272.02483333 506.3646 AM 1021.894 168.134 272.02483333 610.2557 AM 1216.844 194.950 272.02483333 687.3308 AM 1472.736 255.892 272.02483333 703.4639 AM 1726.196 253.460 272.02483333 722.02810 AM 2011.672 285.476 272.02483333 708.57611 AM 2379.856 368.184 272.02483333 612.41712 AM 2846.736 466.880 272.02483333 417.5621 PM 3281.640 434.904 272.02483333 254.6832 PM 3687.176 405.536 272.02483333 121.1723 PM 4071.368 384.192 272.02483333 9.0054 PM 4434.216 362.848 272.02483333 -81.8195 PM 4707.044 272.828 272.02483333 -82.6226 PM 5043.844 336.800 272.02483333 -147.3977 PM 5327.996 284.152 272.02483333 -159.5248 PM 5658.828 330.832 272.02483333 -218.3319 PM 5933.632 274.804 272.02483333 -221.11110 PM 6115.052 181.420 272.02483333 -130.50611 PM 6304.484 189.432 272.02483333 -47.91312 PM 6528.596 224.112 272.02483333 0.000

    1 CAUDAL PROMEDIO DIARIOCPD 272.0248333333 m^3/H 75.562453704

    2 CAUDAL MAXIMO HORARIOCmaxH 466.880 m^3/H 129.68888889CminH 136.068 m^3/H 37.796666667

    % CONSUMO MAXIMO 171.631389046 %% CONSUMO MINIMO 50.0204331835 %

    4 DOTACION PROMEDIOPoblacion Futura 67500 Habitantes

    Dotacion Promedio 250 l/hab/diaQprom 195.3125

    Y (Qmed) 253.906255 VARIACION DE CONSUMO

    B=Cp.Dy/Cp.Dx 3.36021711256CONSUMO MAXIMO HORARIO

    435.78282374957CONSUMO MINIMO HORARIO

    127.005006138 CAPACIDAD DEL RESERVORIO

    Vmin 3169.148Vbombeo 3116.274 check

    Vmax Bombeando 10471.35722213479 VOLUMEN DE ALMACENAMIENTO

    VOL AGUA CONSUMIDA m^3

    VOL AGUA CONSUMIDA POR

    HORA m^3

    PROUCCION PROMEDIO

    RESERVORIO m^3

  • Valmacenamiento = Vcons + Vincend + VreservaVi 230.4 check

    Valmacenamiento = 4532.7312627707

  • 10

    0652.8596 457.910652.8596 854.877652.8596 1254.277652.8596 1621.660652.8596 1906.336652.8596 2092.316652.8596 2310.271652.8596 2557.595652.8596 2826.262652.8596 3116.274

    lpslpslps

    VOLUMEN BOMBEO

    RESERVORIO m^3

  • RED DE DISTRIBUCIONMETODO DE HARRY CROSS

    CAUDAL TOTALQ 456

    D(cm) L(m) Q0(supuesto) HL(Tab) S30 1500 150 25.5 1740 900 -306 -14.4 -16

    11.1 1ITERACION

    D(cm) L(m) Q0(supuesto) HL(Tab) S30 1500 122.357723577 25.5 1740 900 -278.357723577 -14.4 -16

    11.1 1

  • HL/Q0 Q Q10.17 -27.6422764228 122.357723577

    0.0470588235 -27.6422764228 -278.357723577

    0.2170588235 400.715447154HL/Q0 Q Q1

    0.2084053156 -27.6422764228 94.71544715450.0517319937 -27.6422764228 -250.715447154

    0.2601373093 345.430894309

    h = 10,674 * [Q1,852/(C1,852* D4,871)] * L

  • 1,852* D4,871)] * L

  • RED DE DISTRIBUCIONQ 200

    TRAMO C D(pulg) L(m) Q(Supuesto) KAQ 100 6 600 70 0.0334QP 100 6 500 -20 0.0279PA 100 8 500 -130 0.0069QB 100 8 600 90 0.0082BP 100 8 700 -110 0.0096PQ 100 6 500 20 0.0279

    CIRCUITO I introAQ 86.5993200219QP -7.1089810058PA -55.878587099

    23.6117519171Q -6.3108182549

    checkCIRCUITO II intro

    QB 33.9609713253BP -57.4321028168PQ 7.1089810058

    -16.3621504857Q 7.0478787971

    check

    hf 0

    hf 0

  • I ITERACIONhf(Abs) hf Q K86.5993 86.5993200219 1.2371331432 76.3108182549 0.03347.1090 -7.1089810058 0.3554490503 -13.6891817451 0.027955.8786 -55.878587099 0.4298352854 2.0224174788 -123.689181745 0.006933.9610 33.9609713253 0.3773441258 82.9521212029 0.008257.4321 -57.4321028168 0.5221100256 -117.047878797 0.00967.1090 7.1089810058 0.3554490503 1.2549032017 12.9521212029 0.0279

    CIRCUITO I introAQ 101.593848468QP -3.5253335765PA -50.9640449526

    47.1044699389Q -12.7253602905

    checkCIRCUITO II intro

    QB 29.2053441528BP -64.4244639008PQ 3.1822370402

    -32.0368827077Q 15.0823565278

    check

    hf0/Q0 hf 0/Q0

    hf 0

    hf 0

  • I ITERACION II ITERACIONhf(Abs) hf Q K

    101.593848468 101.593848468 1.3313164606 82.6216365097 0.03343.5253335765 -3.5253335765 0.2575269758 -7.3783634903 0.027950.9640449526 -50.9640449526 0.4120331644 2.0008766009 -117.37836349 0.006929.2053441528 29.2053441528 0.3520747116 75.9042424057 0.008264.4244639008 -64.4244639008 0.5504112041 -124.095757594 0.00963.1822370402 3.1822370402 0.2456923457 1.1481782614 5.9042424057 0.0279

    CIRCUITO I introAQ 117.681074421QP -1.1236419589PA -46.258133748

    70.2992987142Q -19.2820980729

    checkCIRCUITO II intro

    QB 24.7812753396BP -71.7841528535PQ 0.7439702928

    -46.2589072211Q 24.2542764668

    check

    hf0/Q0 hf 0/Q0

    hf 0

    hf 0

  • II ITERACIONhf(Abs) hf

    117.681074421 117.681074421 1.42433724861.1236419589 -1.1236419589 0.152288777946.258133748 -46.258133748 0.3940942127 1.970720239224.7812753396 24.7812753396 0.326480767871.7841528535 -71.7841528535 0.57845775110.7439702928 0.7439702928 0.1260060549 1.0309445738

    hf0/Q0 hf 0/Q0

    RESERVORIORED.DIST.ABACOSRED.DIST.FORM