Calculo Red de Alcantarillado

download Calculo Red de Alcantarillado

of 18

description

tabla de excel...revisar y amarrar celdas

Transcript of Calculo Red de Alcantarillado

  • CALCULO DE LA RED DE ALCANTARILLADO SANITARIO CONVENCIONAL

    DATOS DE ENTRADA

    Tramo

    9 - 5 7430 0

    5 - 6 7430 0.12

    5-1 7430 01-2 7430 0.563-2 7430 02-6 7430 0.3657-6 7430 0

    6-10 7430 1.2459-13 7430 0

    13-14 7430 0.114-10 7430 0.29-10 7430 0

    10-11 7430 2.2115-16 7430 016-11 7430 0.17511-12 7430 3.04516-17 7430 017-12 7430 0.16

    7-3 7430 03-4 7430 0.2054-8 7430 0.289

    11-7 7430 07-8 7430 0.27

    8-12 7430 0.835

    12-EB 7430 4.6

    CALCULOS

    Poblacin (habitantes)

    Area acumulada tramos anteriores (ha)

  • 0.188 1.2 00.565 0 00.188 0 00.377 0 0

    3 0.075 00.565 0.15 00.236 0.075 0

    1.79 0.225 00 0 0.040 0 0.08

    0.275 0 0.120.188 0 0.042.763 0.225 0.160.275 0 00.801 0 03.815 0.225 0.160.251 0 00.502 0 00.126 0.075 00.251 0.075 00.377 0.075 00.236 0 00.361 0 00.738 0.075 05.244 0.3 0.16

    Caudal Domestico (L/s)

    Caudal industrial (L/s)

    Caudal comercial (L/s)

  • CALCULO DE LA RED DE ALCANTARILLADO SANITARIO CONVENCIONAL

    DATOS DE ENTRADA

    Area parcial (ha) Area acumulada (ha)

    0.12 0.12 0.120.24 0.325 0.360.12 0.12 0.120.12 0.68 0.24

    0.125 0.125 00.245 0.61 0.360.275 0.275 0.150.27 1.515 1.140.1 0.1 00.1 0.2 0

    0.275 0.475 0.1750.22 0.22 0.12

    0.325 2.535 1.760.175 0.175 0.1750.335 0.51 0.510.28 3.325 2.430.16 0.16 0.160.16 0.32 0.32

    0.205 0.205 0.080.08 0.285 0.160.08 0.369 0.240.27 0.27 0.150.2 0.47 0.23

    0.12 0.955 0.470 4.6 3.34

    CALCULOS

    Area domestica acumulada (ha)

  • 0 1.388 1.40 0.565 1.40 0.188 1.40 0.377 1.40 3.075 1.40 0.715 1.40 0.311 1.40 2.015 1.40 0.04 1.40 0.08 1.40 0.395 1.40 0.228 1.40 3.148 1.40 0.275 1.40 0.801 1.4

    0.048 4.248 1.40 0.251 1.40 0.502 1.40 0.201 1.40 0.326 1.40 0.452 1.4

    0.048 0.284 1.40.096 0.457 1.40.144 0.957 1.40.144 5.848 1.4

    Caudal institucional (L/s)

    Caudal medio diario (L/s)

    Factor de mayoracin

  • CALCULO DE LA RED DE ALCANTARILLADO SANITARIO CONVENCIONAL

    DATOS DE ENTRADA

    2 0 0

    0 0 00 0 0

    0 0 00.125 0 00.25 0 0

    0.125 0 00.375 0 0

    0 0.1 00 0.2 00 0.3 00 0.1 0

    0.375 0.4 00 0 00 0 0

    0.375 0.4 0.120 0 00 0 0

    0.125 0 00.125 0 00.125 0 0

    0 0 0.120 0 0.24

    0.125 0 0.36

    0.5 0.4 0.36

    CALCULOS

    Area industrial acumulada (ha)

    Area comercial acumulada (ha)

    Area institucional acumulada (ha)

  • 1.9432 0.276 2.21920.791 0.7475 1.5385

    0.2632 0.276 0.53920.5278 1.564 2.0918

    4.305 0.2875 4.59251.001 1.403 2.404

    0.4354 0.6325 1.06792.821 3.4845 6.30550.056 0.23 0.2860.112 0.46 0.5720.553 1.0925 1.6455

    0.3192 0.506 0.82524.4072 5.8305 10.2377

    0.385 0.4025 0.78751.1214 1.173 2.29445.9472 7.6475 13.59470.3514 0.368 0.71940.7028 0.736 1.43880.2814 0.4715 0.75290.4564 0.6555 1.11190.6328 0.8487 1.48150.3976 0.621 1.01860.6398 1.081 1.72081.3398 2.1965 3.53638.1872 10.58 18.7672

    Caudal maximo horario (L/s)

    Caudal INF+CER (L/s)

    Caudal de diseo, Qd (L/s)

  • CALCULO DE LA RED DE ALCANTARILLADO SANITARIO CONVENCIONAL

    DATOS DE ENTRADA

    0.6 0.4 0.4

    0.6 0.4 0.40.6 0.4 0.4

    0.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.40.6 0.4 0.4

    0.6 0.4 0.4

    0.6 0.4 0.4

    CALCULOS

    Contribucin industrial (L/s-ha)

    Contribucin comercial (L/s-ha)

    Contribucion institucional (L/s-ha)

  • 2.2192 34.5968 33.99681.5385 33.9668 32.4968

    1.5 33.9968 31.49682.0918 31.4668 30.79684.5925 32.5968 31.5968

    2.404 30.7368 30.39681.5 33.0968 32.2968

    6.3055 30.3068 29.89681.5 34.5968 32.09681.5 31.9652 31.2952

    1.6455 31.316 30.2461.5 34.5968 32.5968

    10.2377 30.0544 29.84441.5 33.5668 32.7968

    2.2944 32.7668 31.796813.5947 29.9668 28.7968

    1.5 34.5968 31.59681.5 31.5668 30.79681.5 33.0968 32.59681.5 32.5668 31.89681.5 31.8668 31.39681.5 33.5968 33.0968

    1.7208 33.0668 31.59683.5363 31.5368 31.2968

    18.7672 27.656 26.746

    Caudal de diseo escogido, Qd (L/s)

    Cota batea inicial (m)

    Cota batea final (m)

  • CALCULO DE LA RED DE ALCANTARILLADO SANITARIO CONVENCIONAL

    DATOS DE ENTRADA

    2 0.3 0.2032 67

    2 0.3 0.2032 872 0.3 0.2032 67

    2 0.3 0.2032 872 0.3 0.2032 1072 0.3 0.2032 672 0.3 0.2032 108.982 0.3 0.2032 672 0.3 0.2032 672 0.3 0.3048 872 0.3 0.254 472 0.3 0.2032 872 0.3 0.3556 108.982 0.3 0.2032 1072 0.3 0.2032 872 0.3 0.2032 872 0.3 0.2032 872 0.3 0.2032 872 0.3 0.2032 472 0.3 0.2032 872 0.3 0.2032 472 0.3 0.2032 672 0.3 0.2032 87

    2 0.3 0.2032 67

    2 0.3 0.254 100

    CALCULOS

    Aportes mximos por conexiones erradas (L/s-ha)

    Aportes por infiltracin (L/s-ha)

    Diametro tuberia (m)

    Longitud tramo (m)

  • Pendiente

    34.8 34.2 0.9 0.00934.2 32.7 1.8 0.01834.2 31.7 3.8 0.03831.7 31 0.9 0.00932.8 31.8 1 0.01

    31 30.6 0.6 0.00633.3 32.5 0.8 0.00830.6 30.1 0.8 0.00834.8 32.3 3.8 0.03832.3 31.6 0.9 0.00931.6 30.5 2.4 0.02434.8 32.8 2.3 0.02330.5 30.2 0.3 0.00333.8 33 0.8 0.008

    33 32 1.2 0.01230.2 29 1.4 0.01434.8 31.8 3.5 0.03531.8 31 1 0.0133.3 32.8 1.1 0.01132.8 32.1 0.9 0.00932.1 31.6 1.1 0.01133.8 33.3 0.8 0.00833.3 31.8 1.8 0.01831.8 31.5 0.5 0.005

    28 27 1 0.01

    Cota clave inicial, (m)

    Cota clave final, (m)

    Pendiente, (%)

  • CALCULO DE LA RED DE ALCANTARILLADO SANITARIO CONVENCIONAL

    DATOS DE ENTRADA

    36 35.5 0 1.2

    35.5 34 0.03 1.335.5 33 0 1.3

    33 33 0.03 1.334 33 0 1.233 34 0.06 2

    34.5 34 0 1.234 34 0.09 3.436 33.5 0 1.2

    33.5 36 0.03 1.236 34 0.03 4.436 34 0 1.234 35 0.09 3.535 36 0.03 1.236 35 0.03 335 34 0.03 4.836 33 0 1.233 33 0.03 1.2

    34.5 34 0 1.234 33.5 0.03 1.2

    33.5 33 0.03 1.435 34.5 0 1.2

    34.5 33 0.03 1.2

    33 33 0.06 1.2

    33 32 0.09 5

    CALCULOS

    Cota rasante superior (inicial) (m)

    Cota rasante inferior (final) (m)

    Caida en el pozo (m)

    Profundidad minima a cota clave inicial (m)

  • Relacion Qr/Qll

    1.09 35.35 0.46 0.071.54 49.95 0.92 0.042.23 72.32 1.94 0.031.09 35.35 0.46 0.061.15 37.3 0.51 0.130.89 28.87 0.31 0.091.03 33.41 0.41 0.051.03 33.41 0.41 0.192.23 72.32 1.94 0.031.43 104.35 0.69 0.022.06 104.39 1.53 0.021.74 56.43 1.17 0.030.91 90.38 0.27 0.121.03 33.41 0.41 0.051.26 40.87 0.61 0.061.36 44.11 0.72 0.312.14 69.4 1.78 0.031.15 37.3 0.51 0.05

    1.2 38.92 0.56 0.041.09 35.35 0.46 0.05

    1.2 38.92 0.56 0.041.03 33.41 0.41 0.051.54 49.95 0.92 0.040.81 26.27 0.26 0.141.33 67.4 0.64 0.28

    Velocidad a tubo lleno, Vll. (m/s)

    Caudal a tubo lleno, Qll. (L/s)

    Fuerza tractiva a tubo lleno, Tll. (kgf/m2)

  • CALCULO DE LA RED DE ALCANTARILLADO SANITARIO CONVENCIONAL

    DATOS DE ENTRADA

    Consumo, C.

    1.3 120 1615 0.7 0.012

    1.3 120 1615 0.7 0.0121.3 120 1615 0.7 0.012

    2 120 1615 0.7 0.0121.2 120 1615 0.7 0.0123.4 120 1615 0.7 0.0121.5 120 1615 0.7 0.0123.9 120 1615 0.7 0.0121.2 120 1615 0.7 0.0124.4 120 1615 0.7 0.0123.5 120 1615 0.7 0.0121.2 120 1615 0.7 0.0124.8 120 1615 0.7 0.0123 120 1615 0.7 0.0123 120 1615 0.7 0.0125 120 1615 0.7 0.012

    1.2 120 1615 0.7 0.0122 120 1615 0.7 0.012

    1.2 120 1615 0.7 0.0121.4 120 1615 0.7 0.0121.4 120 1615 0.7 0.0121.2 120 1615 0.7 0.0121.2 120 1615 0.7 0.012

    1.5 120 1615 0.7 0.012

    5 120 1615 0.7 0.012

    CALCULOS

    Profundidad minima a cota clave final (m)

    Densidad de Poblacin, D.

    Coeficiente de retorno, R.

    Rugosidad, n.

  • Relacion d/D

    0.445 0.169 0.415 0.486 0.0350.419 0.152 0.375 0.646 0.0310.386 0.131 0.328 0.861 0.0270.445 0.169 0.415 0.486 0.0350.445 0.169 0.415 0.512 0.0350.523 0.228 0.542 0.466 0.0470.445 0.169 0.415 0.459 0.0350.646 0.335 0.748 0.666 0.0690.386 0.131 0.328 0.861 0.0270.344 0.131 0.328 0.492 0.040.344 0.108 0.273 0.709 0.0280.386 0.131 0.328 0.672 0.0270.567 0.265 0.615 0.516 0.0950.445 0.169 0.415 0.459 0.0350.468 0.186 0.452 0.59 0.0380.747 0.433 0.908 1.016 0.0880.386 0.131 0.328 0.827 0.0270.445 0.169 0.415 0.512 0.0350.419 0.152 0.375 0.503 0.0310.445 0.169 0.415 0.486 0.0350.445 0.169 0.415 0.534 0.0350.445 0.169 0.415 0.459 0.0350.419 0.152 0.375 0.646 0.0310.591 0.287 0.658 0.479 0.0590.724 0.411 0.874 0.963 0.105

    1.085

    Relacion Vr/Vll

    Relacion Tr/Tll

    Velocidad real, Vr (m/s)

    Tirante real, d. (m)

  • CALCULO DE LA RED DE ALCANTARILLADO SANITARIO CONVENCIONAL

    CALCULOS VERIFICACIN

  • 0.2 CUMPLE CUMPLE CUMPLE0.35 CUMPLE CUMPLE CUMPLE0.64 CUMPLE NO CUMPLE CUMPLE

    0.2 CUMPLE CUMPLE CUMPLE0.22 CUMPLE CUMPLE CUMPLE0.17 CUMPLE CUMPLE CUMPLE0.18 CUMPLE CUMPLE CUMPLE0.31 CUMPLE CUMPLE CUMPLE0.64 CUMPLE NO CUMPLE CUMPLE0.23 CUMPLE CUMPLE CUMPLE0.42 CUMPLE NO CUMPLE CUMPLE0.39 CUMPLE NO CUMPLE CUMPLE0.17 CUMPLE CUMPLE CUMPLE0.18 CUMPLE CUMPLE CUMPLE0.28 CUMPLE CUMPLE CUMPLE0.66 CUMPLE CUMPLE CUMPLE0.59 CUMPLE NO CUMPLE CUMPLE0.22 CUMPLE CUMPLE CUMPLE0.21 CUMPLE CUMPLE CUMPLE

    0.2 CUMPLE CUMPLE CUMPLE0.24 CUMPLE CUMPLE CUMPLE0.18 CUMPLE CUMPLE CUMPLE0.35 CUMPLE CUMPLE CUMPLE0.18 CUMPLE CUMPLE CUMPLE0.56 CUMPLE CUMPLE CUMPLE

    CUMPLE

    Fuerza tractiva real, Tr. (kgf/m2)

    Velocidad real, Vr (m/s)

    Tirante real, d. (m)

    Fuerza tractiva real, Tr. (kgf/m2)

  • CUMPLE NO CUMPLE

  • Calculos