Planilla (areas) Adscripcion 2013.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Planilla (areas) Adscripcion 2013.xlsx as PDF for free.
More details
- Words: 3,599
- Pages: 14
Intrucciones de Uso "Planilla Alcantarilla Sanitario" Con Areas para el Area Urban Introducir los DATOS en las Celdas o Casilla de color Celeste y Blanco.
Las casillas de Color Amarillo son FORMULAS que NO deben de tocarlas, ya q Zanjas y Relaciones Hidraulicas
Se tiene las planillas de "Zanjas y Relaciones Hidraulicas ", las mis nodificar na
illa Alcantarillado a el Area Urbana.
a de color Celeste y Blanco.
ue NO deben de tocarlas, ya que todo Cambiaria y les saldra error.
as y Relaciones Hidraulicas ", las mismas estan vinculadas con la Planilla de calculo, no se debe nodificar nada.
EJEMPLO PARA EL LLENADO DE LA PLANILLA DE CALCULO Coef. De Maximo Caudal Diario K1 =
1.3
i=
1.2
[%]
Coef. De Maximo Caudal Horario K2 =
1.3
Periodo de Diseño t = Poblacion Futura Pf=
20
[Años]
2640
[Hab.]
COEFICIENTE DE PUNTA M=
b
Poblacion Inicial=
1 Fila 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
2
3
4
Ubicac. del colector Calle Independ Litoral Litoral Boqueron Boqueron La Paz La Paz Independ La Paz La Paz Boqueron Civica Oruro Oruro Independ Oruro Oruro Boqueron Civica Potosi Potosi Independ Potosi Potosi Boqueron Civica CBBA
De Litoral Independ Independ Litoral La Paz Civica Civica La Paz Independ Independ Oruro Oruro Civica Civica Oruro Independ Independ Potosi Potosi Independ Independ Potosi Independ Independ CBBA CBBA Independ
2080
5
Area Proyectada A =
6
7
Cam. Inf. C2 C3 C5 C5 C11 C7 C9 C9 C10 C11 C18 C13 C14 C16 C16 C17 C18 C25 C20 C21 C23 C23 C24 C25 C32 C27 C28
Propia 27.00 70.00 70.00 40.20 68.00 68.00 68.00 63.20 70.00 70.00 68.50 63.40 70.00 70.00 64.53 70.00 70.00 68.00 65.37 70.00 70.00 65.37 70.00 70.00 68.00 65.40 70.00
Tramo
A Cam. Sup. S.N. C1 Boqueron C2 Boqueron C3 S.N. C4 Litoral C5 Independ C6 Independ C7 Litoral C8 Boqueron C9 Boqueron C10 La Paz C11 La Paz C12 Independ C13 Independ C14 La Paz C15 Boqueron C16 Boqueron C17 Oruro C18 Oruro C19 Civica C20 Civica C21 Oruro C22 Boqueron C23 Boqueron C24 Potosi C25 Potosi C26 Civica C27
[Hab]
8
9
10
Acum. 27.00 97.00 167.00 40.20 275.20 68.00 136.00 63.20 269.20 339.20 682.90 63.40 133.40 203.40 64.53 337.93 407.93 1158.83 65.37 135.37 205.37 65.37 340.74 410.74 1637.57 65.40 135.40
Propia 0.03 0.15 0.15 0.05 0.08 0.15 0.15 0.08 0.15 0.15 0.08 0.08 0.15 0.15 0.08 0.15 0.15 0.08 0.08 0.15 0.15 0.08 0.15 0.15 0.08 0.08 0.15
Longitud ( m ) Trib. 0.00 27.00 97.00 0.00 207.20 0.00 68.00 0.00 199.20 269.20 614.40 0.00 63.40 133.40 0.00 267.93 337.93 1090.83 0.00 65.37 135.37 0.00 270.74 340.74 1569.57 0.00 65.40
4.9
[Ha]
11 Trib. 0.00 0.03 0.18 0.00 0.38 0.00 0.15 0.00 0.38 0.53 1.14 0.00 0.08 0.23 0.00 0.46 0.61 1.98 0.00 0.08 0.23 0.00 0.46 0.61 2.83 0.00 0.08
539
Dotación =
90
Coeficiente de retorno = 60 a 80 %
75
Caudal malos empotramientos = 5 A 10%
12
13
Acum. 0.03 0.18 0.33 0.05 0.46 0.15 0.30 0.08 0.53 0.68 1.22 0.08 0.23 0.38 0.08 0.61 0.76 2.06 0.08 0.23 0.38 0.08 0.61 0.76 2.91 0.08 0.23
Propio 16 81 81 27 44 80 80 44 81 81 44 44 81 81 44 81 81 44 44 81 81 44 81 81 44 44 81
Área ( ha)
Densidad Poblc. =
14
Población Acum. 16 96 177 27 248 80 161 44 285 366 658 44 124 205 44 330 411 1112 44 124 205 44 330 411 1566 44 124
15
8
16
17
18
Medio 0.012 0.075 0.139 0.021 0.194 0.063 0.125 0.034 0.223 0.286 0.514 0.034 0.097 0.160 0.034 0.258 0.321 0.869 0.034 0.097 0.160 0.034 0.258 0.321 1.224 0.034 0.097
Qmáx 0.140 0.601 0.979 0.220 1.282 0.519 0.904 0.319 1.431 1.748 2.795 0.319 0.738 1.101 0.319 1.608 1.916 4.253 0.319 0.738 1.101 0.319 1.608 1.916 5.594 0.319 0.738
Qi 0.0135 0.0485 0.0835 0.0201 0.1376 0.0340 0.0680 0.0316 0.1346 0.1696 0.3415 0.0317 0.0667 0.1017 0.0323 0.1690 0.2040 0.5794 0.0327 0.0677 0.1027 0.0327 0.1704 0.2054 0.8188 0.0327 0.0677
Coef. Punta 11.49 7.98 7.07 10.26 6.61 8.28 7.21 9.35 6.43 6.11 5.44 9.35 7.58 6.86 9.35 6.24 5.97 4.89 9.35 7.58 6.86 9.35 6.24 5.97 4.57 9.35 7.58
Caudal (l/s)
28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
CBBA Independ CBBA CBBA Boqueron Boqueron Civica Sucre Sucre Independ Independ Civica Tarija Tarija Tarija Tarija Boqueron
Independ CBBA Boqueron Boqueron Tarija Tarija Sucre Independ Independ Sucre Sucre Tarija Independ Independ Boqueron Boqueron
Civica Potosi Independ Independ CBBA CBBA CBBA Civica Civica CBBA Tarija Sucre Civica Civica Independ Independ
C28 C29 C30 C31 C32 C33 C34 C35 C36 C37 C38 C39 C40 C41 C42 C43 C44
C30 C30 C31 C32 C33 C44 C35 C36 C38 C38 C42 C40 C41 C42 C43 C44 SALIDA
70.00 65.40 70.00 70.00 68.00 68.00 65.40 70.00 70.00 65.40 68.00 65.40 70.00 70.00 70.00 70.00 16.40
135.40 0.00 270.80 340.80 2048.37 2116.37 0.00 65.40 135.40 0.00 270.80 0.00 65.40 135.40 544.20 614.20 2868.57
205.40 65.40 340.80 410.80 2116.37 2184.37 65.40 135.40 205.40 65.40 338.80 65.40 135.40 205.40 614.20 684.20 2884.97
0.15 0.08 0.15 0.15 0.00 0.00 0.08 0.15 0.15 0.08 0.08 0.08 0.15 0.15 0.15 0.15 0.00
0.23 0.00 0.46 0.61 3.67 3.67 0.00 0.08 0.23 0.00 0.46 0.00 0.08 0.23 0.92 1.07 4.89
0.38 0.08 0.61 0.76 3.67 3.67 0.08 0.23 0.38 0.08 0.54 0.08 0.23 0.38 1.07 1.22 4.89
81 44 81 81 0 0 44 81 81 44 44 44 81 81 81 81 0
205 44 330 411 1977 1977 44 124 205 44 293 44 124 205 579 660 2637
6.86 9.35 6.24 5.97 4.36 4.36 9.35 7.58 6.86 9.35 6.39 9.35 7.58 6.86 5.58 5.43 4.12
0.160 0.034 0.258 0.321 1.545 1.545 0.034 0.097 0.160 0.034 0.229 0.034 0.097 0.160 0.452 0.515 2.060
1.101 0.319 1.608 1.916 6.739 6.739 0.319 0.738 1.101 0.319 1.461 0.319 0.738 1.101 2.522 2.800 8.484
0.1027 0.0327 0.1704 0.2054 1.0582 1.0922 0.0327 0.0677 0.1027 0.0327 0.1694 0.0327 0.0677 0.1027 0.3071 0.3421 1.4425
[hab/ha]
Coeficiente de Infiltracion =
[L/hab/dia]
0.5
[ L/s/Km]
Coef. de Rugosidad Manning 0.013 Para cualquier tipo de material de tuberia
[%]
Peso esp.del agua =
1000
[%]
Cama de arena =
10
[Cm]
19
20 # com. 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Dot. Instituciones Publicas = 5,000 - 15,000
5000
Dot. Industrial = 16,000 - 18,000 16000 Gravedad g = 9.81
21
22
23
24
25
26
27
28
29
Qc 0.0000 0.0000 0.0000 0.0000 0.0116 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
# I.P. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Qip 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
# ind. 0 0 0 0 0 0 0 0 0 0
Qind. 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
∑Qdc 0.000 0.000 0.000 0.000 0.012 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Acum. 0.16 0.70 1.14 0.26 1.53 0.59 1.04 0.38 1.68 2.06 3.36 0.38 0.86 1.29 0.38 1.91 2.27 5.17 0.38 0.86 1.29 0.38 1.91 2.28 6.86 0.38 0.86
q 1.50 1.50 1.50 1.50 1.53 1.50 1.50 1.50 1.68 2.06 3.36 1.50 1.50 1.50 1.50 1.91 2.27 5.17 1.50 1.50 1.50 1.50 1.91 2.28 6.86 1.50 1.50
inicial 2544.8 2544.6 2544.1 2544.3 2544 2545.3 2544.88 2544.6 2544 2544 2544 2544.95 2544.7 2544.5 2544 2544 2544 2544 2544.95 2544.7 2544.3 2544 2544 2544 2543.95 2544.75 2544.45
30
Cota terreno (m)
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000
[Kg/m^3]
Caudal (l/s) Qe 0.0112 0.0481 0.0783 0.0176 0.1026 0.0416 0.0723 0.0255 0.1145 0.1398 0.2236 0.0255 0.0590 0.0881 0.0255 0.1287 0.1533 0.3403 0.0255 0.0590 0.0881 0.0255 0.1287 0.1533 0.4475 0.0255 0.0590
Dot. Comercial = 600 - 3,000
final 2544.6 2544.1 2544 2544 2544 2544.88 2544 2544 2544 2544 2544 2544.7 2544.5 2544 2544 2544 2544 2543.95 2544.7 2544.3 2544 2544 2544 2543.95 2543.75 2544.45 2544
31
32
33
Prof.de excav. (m) inicial 1.20 1.20 1.20 1.20 1.30 1.20 1.20 1.20 1.30 1.50 1.70 1.20 1.20 1.20 1.20 1.40 1.60 2.00 1.20 1.30 1.40 1.45 1.70 2.00 2.30 1.20 1.25
final 1.20 1.20 1.30 1.30 1.70 1.20 1.30 1.30 1.50 1.70 2.00 1.20 1.20 1.20 1.40 1.60 2.00 2.30 1.30 1.40 1.45 1.70 2.00 2.30 2.35 1.25 1.30
Media 1.20 1.20 1.25 1.25 1.50 1.20 1.25 1.25 1.40 1.60 1.85 1.20 1.20 1.20 1.30 1.50 1.80 2.15 1.25 1.35 1.43 1.58 1.85 2.15 2.33 1.23 1.28
34
35
Cota Solera inicial 2543.60 2543.40 2542.90 2543.10 2542.70 2544.10 2543.68 2543.40 2542.70 2542.50 2542.30 2543.75 2543.50 2543.30 2542.80 2542.60 2542.40 2542.00 2543.75 2543.40 2542.90 2542.55 2542.30 2542.00 2541.65 2543.55 2543.20
final 2543.40 2542.90 2542.70 2542.70 2542.30 2543.68 2542.70 2542.70 2542.50 2542.30 2542.00 2543.50 2543.30 2542.80 2542.60 2542.40 2542.00 2541.65 2543.40 2542.90 2542.55 2542.30 2542.00 2541.65 2541.40 2543.20 2542.70
36 Pend. % 0.741 0.714 0.286 0.995 0.588 0.618 1.441 1.108 0.286 0.286 0.438 0.394 0.286 0.714 0.310 0.286 0.571 0.515 0.535 0.714 0.500 0.382 0.429 0.500 0.368 0.535 0.714
0.0881 0.0255 0.1287 0.1533 0.5391 0.5391 0.0255 0.0590 0.0881 0.0255 0.1169 0.0255 0.0590 0.0881 0.2018 0.2240 0.6787
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
1.29 0.38 1.91 2.28 8.34 8.37 0.38 0.86 1.29 0.38 1.75 0.38 0.86 1.29 3.03 3.37 10.61
1.50 1.50 1.91 2.28 8.34 8.37 1.50 1.50 1.50 1.50 1.75 1.50 1.50 1.50 3.03 3.37 10.61
2544 2544.1 2544 2544 2543.75 2543.45 2544.45 2544.15 2544 2544.15 2544 2544 2544 2544 2543.85 2543.5 2544
2544 2544 2544 2543.75 2543.45 2543 2544.15 2544 2544 2544 2543.85 2544 2544 2543.85 2543.5 2543 2544
1.25 1.20 1.60 2.35 2.45 2.45 1.20 1.25 1.45 1.20 1.40 1.20 1.55 1.90 2.20 2.30 1.40
1.60 1.60 2.35 2.45 2.45 2.45 1.25 1.45 1.80 1.40 1.60 1.55 1.90 2.20 2.30 2.45 1.60
1.43 1.40 1.98 2.40 2.45 2.45 1.23 1.35 1.63 1.30 1.50 1.38 1.73 2.05 2.25 2.38 1.50
2542.75 2542.90 2542.40 2541.65 2541.30 2541.00 2543.25 2542.90 2542.55 2542.95 2542.60 2542.80 2542.45 2542.10 2541.65 2541.20 2542.60
2542.40 2542.40 2541.65 2541.30 2541.00 2540.55 2542.90 2542.55 2542.20 2542.60 2542.25 2542.45 2542.10 2541.65 2541.20 2540.55 2542.40
0.500 0.765 1.071 0.500 0.441 0.662 0.535 0.500 0.500 0.535 0.515 0.535 0.500 0.643 0.643 0.929 1.220
[L/comercio/dia] [L/Instituciones Publicas/dia] [L/Industria/dia]
UnitLoad =
0.23 [L/s]
[m/s^2]
37
38
39
(mm) 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 200 150 150 150 150 150 150 200 150 150
Rh (m) 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0500 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0500 0.0375 0.0375
Diametro (Pulgadas) 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 8 6 6 6 6 6 6 8 6 6
40
41
42
43
44
45
46
rh/Rh 0.533 0.533 0.659 0.488 0.573 0.555 0.437 0.488 0.690 0.758 0.850 0.611 0.659 0.533 0.644 0.732 0.675 0.704 0.573 0.533 0.573 0.611 0.675 0.704 0.860 0.573 0.533
v (m/s) 0.488 0.479 0.349 0.533 0.456 0.457 0.596 0.562 0.360 0.383 0.512 0.390 0.349 0.479 0.358 0.375 0.502 0.593 0.435 0.479 0.420 0.384 0.434 0.483 0.572 0.435 0.479
47
48
REGIMEN HIDRAULICO V (m/s) Q (l/s) 0.74 ok 13.11 0.73 ok 12.87 0.46 baja 8.14 0.86 ok 15.19 0.66 ok 11.68 0.68 ok 11.97 1.03 ok 18.28 0.91 ok 16.03 0.46 baja 8.14 0.46 baja 8.14 0.57 baja 10.08 0.54 baja 9.56 0.46 baja 8.14 0.73 ok 12.87 0.48 baja 8.48 0.46 baja 8.14 0.65 ok 11.51 0.75 ok 23.53 0.63 ok 11.14 0.73 ok 12.87 0.61 ok 10.77 0.53 baja 9.42 0.56 baja 9.97 0.61 ok 10.77 0.63 ok 19.89 0.63 ok 11.14 0.73 ok 12.87
q/Q 0.11 0.12 0.18 0.10 0.13 0.13 0.08 0.09 0.21 0.25 0.33 0.16 0.18 0.12 0.18 0.23 0.20 0.22 0.13 0.12 0.14 0.16 0.19 0.21 0.34 0.13 0.12
v/V 0.658 0.658 0.757 0.620 0.690 0.675 0.576 0.620 0.781 0.831 0.897 0.720 0.757 0.658 0.746 0.813 0.770 0.792 0.690 0.658 0.690 0.720 0.770 0.792 0.904 0.690 0.658
d/D 0.224 0.224 0.287 0.203 0.244 0.234 0.179 0.203 0.303 0.341 0.395 0.262 0.287 0.224 0.279 0.326 0.295 0.311 0.244 0.224 0.244 0.262 0.295 0.311 0.402 0.244 0.224
49 Vc
d (mm) r h (m) 33.6 ok 0.020 33.6 ok 0.020 43.05 ok 0.025 30.45 ok 0.018 36.6 ok 0.021 35.1 ok 0.021 26.85 bajo 0.016 30.45 ok 0.018 45.45 ok 0.026 51.15 ok 0.028 59.25 ok 0.032 39.3 ok 0.023 43.05 ok 0.025 33.6 ok 0.020 41.85 ok 0.024 48.9 ok 0.027 44.25 ok 0.025 62.2 ok 0.035 36.6 ok 0.021 33.6 ok 0.020 36.6 ok 0.021 39.3 ok 0.023 44.25 ok 0.025 46.65 ok 0.026 80.4 ok 0.043 36.6 ok 0.021 33.6 ok 0.020
(m/s) 2.66 2.66 2.95 2.54 2.75 2.71 2.41 2.54 3.02 3.17 3.36 2.84 2.95 2.66 2.92 3.11 2.99 3.53 2.75 2.66 2.75 2.84 2.99 3.05 3.90 2.75 2.66
50
51
F tract.
Ancho
(N/m^2) zanja (m) 1.45 ok 0.60 1.40 ok 0.60 0.69 baja 0.60 1.79 ok 0.60 1.24 ok 0.60 1.26 ok 0.60 2.32 ok 0.60 1.99 ok 0.60 0.73 baja 0.60 0.80 baja 0.60 1.37 ok 0.60 0.89 baja 0.60 0.69 baja 0.60 1.40 ok 0.60 0.73 baja 0.60 0.77 baja 0.60 1.42 ok 0.60 1.78 ok 0.65 1.13 ok 0.60 1.40 ok 0.60 1.05 ok 0.60 0.86 baja 0.60 1.06 ok 0.60 1.29 ok 0.60 1.55 ok 0.65 1.13 ok 0.60 1.40 ok 0.60
52
53
54
Volumenes (m^3) Excav. 19.44 50.40 52.50 30.15 61.20 48.96 51.00 47.40 58.80 67.20 76.04 45.65 50.40 50.40 50.33 63.00 75.60 95.03 49.03 56.70 59.85 61.77 77.70 90.30 102.77 48.07 53.55
Arena 1.62 4.20 4.20 2.41 4.08 4.08 4.08 3.79 4.20 4.20 4.11 3.80 4.20 4.20 3.87 4.20 4.20 4.42 3.92 4.20 4.20 3.92 4.20 4.20 4.42 3.92 4.20
Relleno 17.82 46.20 48.30 27.74 57.12 44.88 46.92 43.61 54.60 63.00 71.93 41.84 46.20 46.20 46.46 58.80 71.40 90.61 45.11 52.50 55.65 57.85 73.50 86.10 98.35 44.15 49.35
6 6 6 6 8 8 6 6 6 6 6 6 6 6 6 6 6
150 150 150 150 200 200 150 150 150 150 150 150 150 150 150 150 150
0.0375 0.0375 0.0375 0.0375 0.0500 0.0500 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375
0.61 0.75 0.89 0.61 0.69 0.85 0.63 0.61 0.61 0.63 0.62 0.63 0.61 0.69 0.69 0.83 0.95
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
10.77 13.32 15.76 10.77 21.79 26.68 11.14 10.77 10.77 11.14 10.93 11.14 10.77 12.21 12.21 14.68 16.82
0.14 0.11 0.12 0.21 0.38 0.31 0.13 0.14 0.14 0.13 0.16 0.13 0.14 0.12 0.25 0.23 0.63
0.690 0.658 0.675 0.792 0.932 0.882 0.690 0.690 0.690 0.690 0.720 0.690 0.690 0.675 0.822 0.802 1.057
0.244 0.224 0.234 0.311 0.428 0.382 0.244 0.244 0.244 0.244 0.262 0.244 0.244 0.234 0.334 0.319 0.576
0.573 0.533 0.555 0.704 0.900 0.828 0.573 0.573 0.573 0.573 0.611 0.573 0.573 0.555 0.745 0.718 1.087
0.420 0.496 0.602 0.483 0.646 0.749 0.435 0.420 0.420 0.435 0.445 0.435 0.420 0.466 0.568 0.666 1.006
36.6 33.6 35.1 46.65 85.6 76.4 36.6 36.6 36.6 36.6 39.3 36.6 36.6 35.1 50.1 47.85 86.4
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
0.021 0.020 0.021 0.026 0.045 0.041 0.021 0.021 0.021 0.021 0.023 0.021 0.021 0.021 0.028 0.027 0.041
2.75 2.66 2.71 3.05 3.99 3.82 2.75 2.75 2.75 2.75 2.84 2.75 2.75 2.71 3.14 3.08 3.79
1.05 1.50 2.19 1.29 1.95 2.69 1.13 1.05 1.05 1.13 1.16 1.13 1.05 1.31 1.76 2.45 4.88
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
0.60 0.60 0.60 0.60 0.65 0.65 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60
59.85 54.94 82.95 100.80 108.29 108.29 48.07 56.70 68.25 51.01 61.20 53.96 72.45 86.10 94.50 99.75 14.76
4.20 3.92 4.20 4.20 4.42 4.42 3.92 4.20 4.20 3.92 4.08 3.92 4.20 4.20 4.20 4.20 0.98
55.65 51.01 78.75 96.60 103.87 103.87 44.15 52.50 64.05 47.09 57.12 50.03 68.25 81.90 90.30 95.55 13.78
55 Observ. C. Arranque
C. Arranque C. Arranque C. Arranque
C. Arranque
C. Arranque
C. Arranque
C. Arranque
C. Arranque
C. Arranque
C. Arranque
C. Arranque C. Arranque
Diametro Ancho Zanja 100 150 200 250 300 400 450 500 550 600 700 800 900 1000 1100
0.50 0.60 0.65 0.70 0.80 0.90 0.95 1 1.10 1.15 1.25 1.35 1.50 1.60 1.80
Relaciones Hidraulicas q/Q v/V q/Q d/D q/Q rh/RH 0.00 0.01 0.02 0.03 0.04 0.05 0.08 0.06 0.07 0.09 0.10 0.11 0.12 0.13 0.14 0.15 0.16 0.17 0.18 0.19 0.20 0.21 0.22 0.23 0.24 0.25 0.26 0.27 0.28 0.29 0.30 0.31 0.32 0.33 0.34 0.35 0.36 0.37 0.38 0.39 0.40 0.41 0.42 0.43 0.44
0.000 0.326 0.398 0.448 0.488 0.522 0.599 0.551 0.576 0.620 0.641 0.658 0.675 0.690 0.705 0.720 0.733 0.746 0.757 0.770 0.781 0.792 0.802 0.813 0.822 0.831 0.840 0.849 0.858 0.866 0.874 0.882 0.890 0.897 0.904 0.911 0.918 0.925 0.932 0.938 0.944 0.950 0.956 0.962 0.968
0.00 0.01 0.02 0.03 0.04 0.05 0.08 0.06 0.07 0.09 0.10 0.11 0.12 0.13 0.14 0.15 0.16 0.17 0.18 0.19 0.20 0.21 0.22 0.23 0.24 0.25 0.26 0.27 0.28 0.29 0.30 0.31 0.32 0.33 0.34 0.35 0.36 0.37 0.38 0.39 0.40 0.41 0.42 0.43 0.44
0.000 0.072 0.099 0.119 0.137 0.152 0.191 0.167 0.179 0.203 0.215 0.224 0.234 0.244 0.253 0.262 0.271 0.279 0.287 0.295 0.303 0.311 0.319 0.326 0.334 0.341 0.348 0.355 0.362 0.369 0.376 0.382 0.389 0.395 0.402 0.408 0.415 0.421 0.428 0.434 0.440 0.446 0.452 0.458 0.464
0.00 0.01 0.02 0.03 0.04 0.05 0.08 0.06 0.07 0.09 0.10 0.11 0.12 0.13 0.14 0.15 0.16 0.17 0.18 0.19 0.20 0.21 0.22 0.23 0.24 0.25 0.26 0.27 0.28 0.29 0.30 0.31 0.32 0.33 0.34 0.35 0.36 0.37 0.38 0.39 0.40 0.41 0.42 0.43 0.44
0.000 0.186 0.251 0.300 0.341 0.377 0.464 0.409 0.437 0.488 0.513 0.533 0.555 0.573 0.592 0.611 0.627 0.644 0.659 0.675 0.690 0.704 0.718 0.732 0.745 0.758 0.770 0.783 0.794 0.806 0.817 0.828 0.839 0.850 0.860 0.870 0.880 0.890 0.900 0.908 0.918 0.927 0.935 0.943 0.952
0.45 0.46 0.47 0.48 0.49 0.50 0.51 0.52 0.53 0.54 0.55 0.56 0.57 0.58 0.59 0.60 0.61 0.62 0.63 0.64 0.65 0.66 0.67 0.68 0.69 0.70 0.71 0.72 0.73 0.74 0.75 0.76 0.77 0.78 0.79 0.80 0.81 0.82 0.83 0.84 0.85 0.86 0.87 0.88 0.89 0.90 0.91 0.92
0.974 0.979 0.985 0.990 0.995 1.000 1.005 1.010 1.015 1.019 1.024 1.028 1.033 1.037 1.041 1.045 1.049 1.053 1.057 1.061 1.065 1.068 1.072 1.075 1.079 1.082 1.085 1.088 1.092 1.095 1.097 1.100 1.103 1.106 1.108 1.111 1.113 1.116 1.118 1.120 1.123 1.125 1.126 1.128 1.130 1.132 1.133 1.135
0.45 0.46 0.47 0.48 0.49 0.50 0.51 0.52 0.53 0.54 0.55 0.56 0.57 0.58 0.59 0.60 0.61 0.62 0.63 0.64 0.65 0.66 0.67 0.68 0.69 0.70 0.71 0.72 0.73 0.74 0.75 0.76 0.77 0.78 0.79 0.80 0.81 0.82 0.83 0.84 0.85 0.86 0.87 0.88 0.89 0.90 0.91 0.92
0.470 0.476 0.482 0.488 0.494 0.500 0.506 0.512 0.518 0.523 0.529 0.535 0.541 0.547 0.552 0.558 0.564 0.570 0.576 0.581 0.587 0.593 0.599 0.605 0.611 0.616 0.622 0.628 0.634 0.640 0.646 0.652 0.658 0.664 0.670 0.677 0.683 0.689 0.695 0.702 0.708 0.715 0.721 0.728 0.735 0.742 0.749 0.756
0.45 0.46 0.47 0.48 0.49 0.50 0.51 0.52 0.53 0.54 0.55 0.56 0.57 0.58 0.59 0.60 0.61 0.62 0.63 0.64 0.65 0.66 0.67 0.68 0.69 0.70 0.71 0.72 0.73 0.74 0.75 0.76 0.77 0.78 0.79 0.80 0.81 0.82 0.83 0.84 0.85 0.86 0.87 0.88 0.89 0.90 0.91 0.92
0.961 0.969 0.977 0.985 0.992 1.000 1.007 1.015 1.022 1.029 1.036 1.043 1.049 1.056 1.062 1.068 1.075 1.081 1.087 1.093 1.098 1.104 1.110 1.115 1.120 1.125 1.131 1.135 1.140 1.145 1.150 1.154 1.159 1.163 1.167 1.171 1.175 1.179 1.182 1.186 1.189 1.193 1.196 1.199 1.201 1.204 1.206 1.209
0.93 0.94 0.95 0.96 0.97 0.98 0.99
1.136 1.137 1.138 1.139 1.139 1.140 1.140
0.93 0.94 0.95 0.96 0.97 0.98 0.99
0.763 0.771 0.778 0.786 0.794 0.802 0.811
0.93 0.94 0.95 0.96 0.97 0.98 0.99
1.211 1.212 1.214 1.215 1.216 1.217 1.217
HOJA VINCULADA CON LA PLANILLA SANITARIA 2012 "NO TOCAR NADA"
Las casillas de Color Amarillo son FORMULAS que NO deben de tocarlas, ya q Zanjas y Relaciones Hidraulicas
Se tiene las planillas de "Zanjas y Relaciones Hidraulicas ", las mis nodificar na
illa Alcantarillado a el Area Urbana.
a de color Celeste y Blanco.
ue NO deben de tocarlas, ya que todo Cambiaria y les saldra error.
as y Relaciones Hidraulicas ", las mismas estan vinculadas con la Planilla de calculo, no se debe nodificar nada.
EJEMPLO PARA EL LLENADO DE LA PLANILLA DE CALCULO Coef. De Maximo Caudal Diario K1 =
1.3
i=
1.2
[%]
Coef. De Maximo Caudal Horario K2 =
1.3
Periodo de Diseño t = Poblacion Futura Pf=
20
[Años]
2640
[Hab.]
COEFICIENTE DE PUNTA M=
b
Poblacion Inicial=
1 Fila 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
2
3
4
Ubicac. del colector Calle Independ Litoral Litoral Boqueron Boqueron La Paz La Paz Independ La Paz La Paz Boqueron Civica Oruro Oruro Independ Oruro Oruro Boqueron Civica Potosi Potosi Independ Potosi Potosi Boqueron Civica CBBA
De Litoral Independ Independ Litoral La Paz Civica Civica La Paz Independ Independ Oruro Oruro Civica Civica Oruro Independ Independ Potosi Potosi Independ Independ Potosi Independ Independ CBBA CBBA Independ
2080
5
Area Proyectada A =
6
7
Cam. Inf. C2 C3 C5 C5 C11 C7 C9 C9 C10 C11 C18 C13 C14 C16 C16 C17 C18 C25 C20 C21 C23 C23 C24 C25 C32 C27 C28
Propia 27.00 70.00 70.00 40.20 68.00 68.00 68.00 63.20 70.00 70.00 68.50 63.40 70.00 70.00 64.53 70.00 70.00 68.00 65.37 70.00 70.00 65.37 70.00 70.00 68.00 65.40 70.00
Tramo
A Cam. Sup. S.N. C1 Boqueron C2 Boqueron C3 S.N. C4 Litoral C5 Independ C6 Independ C7 Litoral C8 Boqueron C9 Boqueron C10 La Paz C11 La Paz C12 Independ C13 Independ C14 La Paz C15 Boqueron C16 Boqueron C17 Oruro C18 Oruro C19 Civica C20 Civica C21 Oruro C22 Boqueron C23 Boqueron C24 Potosi C25 Potosi C26 Civica C27
[Hab]
8
9
10
Acum. 27.00 97.00 167.00 40.20 275.20 68.00 136.00 63.20 269.20 339.20 682.90 63.40 133.40 203.40 64.53 337.93 407.93 1158.83 65.37 135.37 205.37 65.37 340.74 410.74 1637.57 65.40 135.40
Propia 0.03 0.15 0.15 0.05 0.08 0.15 0.15 0.08 0.15 0.15 0.08 0.08 0.15 0.15 0.08 0.15 0.15 0.08 0.08 0.15 0.15 0.08 0.15 0.15 0.08 0.08 0.15
Longitud ( m ) Trib. 0.00 27.00 97.00 0.00 207.20 0.00 68.00 0.00 199.20 269.20 614.40 0.00 63.40 133.40 0.00 267.93 337.93 1090.83 0.00 65.37 135.37 0.00 270.74 340.74 1569.57 0.00 65.40
4.9
[Ha]
11 Trib. 0.00 0.03 0.18 0.00 0.38 0.00 0.15 0.00 0.38 0.53 1.14 0.00 0.08 0.23 0.00 0.46 0.61 1.98 0.00 0.08 0.23 0.00 0.46 0.61 2.83 0.00 0.08
539
Dotación =
90
Coeficiente de retorno = 60 a 80 %
75
Caudal malos empotramientos = 5 A 10%
12
13
Acum. 0.03 0.18 0.33 0.05 0.46 0.15 0.30 0.08 0.53 0.68 1.22 0.08 0.23 0.38 0.08 0.61 0.76 2.06 0.08 0.23 0.38 0.08 0.61 0.76 2.91 0.08 0.23
Propio 16 81 81 27 44 80 80 44 81 81 44 44 81 81 44 81 81 44 44 81 81 44 81 81 44 44 81
Área ( ha)
Densidad Poblc. =
14
Población Acum. 16 96 177 27 248 80 161 44 285 366 658 44 124 205 44 330 411 1112 44 124 205 44 330 411 1566 44 124
15
8
16
17
18
Medio 0.012 0.075 0.139 0.021 0.194 0.063 0.125 0.034 0.223 0.286 0.514 0.034 0.097 0.160 0.034 0.258 0.321 0.869 0.034 0.097 0.160 0.034 0.258 0.321 1.224 0.034 0.097
Qmáx 0.140 0.601 0.979 0.220 1.282 0.519 0.904 0.319 1.431 1.748 2.795 0.319 0.738 1.101 0.319 1.608 1.916 4.253 0.319 0.738 1.101 0.319 1.608 1.916 5.594 0.319 0.738
Qi 0.0135 0.0485 0.0835 0.0201 0.1376 0.0340 0.0680 0.0316 0.1346 0.1696 0.3415 0.0317 0.0667 0.1017 0.0323 0.1690 0.2040 0.5794 0.0327 0.0677 0.1027 0.0327 0.1704 0.2054 0.8188 0.0327 0.0677
Coef. Punta 11.49 7.98 7.07 10.26 6.61 8.28 7.21 9.35 6.43 6.11 5.44 9.35 7.58 6.86 9.35 6.24 5.97 4.89 9.35 7.58 6.86 9.35 6.24 5.97 4.57 9.35 7.58
Caudal (l/s)
28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
CBBA Independ CBBA CBBA Boqueron Boqueron Civica Sucre Sucre Independ Independ Civica Tarija Tarija Tarija Tarija Boqueron
Independ CBBA Boqueron Boqueron Tarija Tarija Sucre Independ Independ Sucre Sucre Tarija Independ Independ Boqueron Boqueron
Civica Potosi Independ Independ CBBA CBBA CBBA Civica Civica CBBA Tarija Sucre Civica Civica Independ Independ
C28 C29 C30 C31 C32 C33 C34 C35 C36 C37 C38 C39 C40 C41 C42 C43 C44
C30 C30 C31 C32 C33 C44 C35 C36 C38 C38 C42 C40 C41 C42 C43 C44 SALIDA
70.00 65.40 70.00 70.00 68.00 68.00 65.40 70.00 70.00 65.40 68.00 65.40 70.00 70.00 70.00 70.00 16.40
135.40 0.00 270.80 340.80 2048.37 2116.37 0.00 65.40 135.40 0.00 270.80 0.00 65.40 135.40 544.20 614.20 2868.57
205.40 65.40 340.80 410.80 2116.37 2184.37 65.40 135.40 205.40 65.40 338.80 65.40 135.40 205.40 614.20 684.20 2884.97
0.15 0.08 0.15 0.15 0.00 0.00 0.08 0.15 0.15 0.08 0.08 0.08 0.15 0.15 0.15 0.15 0.00
0.23 0.00 0.46 0.61 3.67 3.67 0.00 0.08 0.23 0.00 0.46 0.00 0.08 0.23 0.92 1.07 4.89
0.38 0.08 0.61 0.76 3.67 3.67 0.08 0.23 0.38 0.08 0.54 0.08 0.23 0.38 1.07 1.22 4.89
81 44 81 81 0 0 44 81 81 44 44 44 81 81 81 81 0
205 44 330 411 1977 1977 44 124 205 44 293 44 124 205 579 660 2637
6.86 9.35 6.24 5.97 4.36 4.36 9.35 7.58 6.86 9.35 6.39 9.35 7.58 6.86 5.58 5.43 4.12
0.160 0.034 0.258 0.321 1.545 1.545 0.034 0.097 0.160 0.034 0.229 0.034 0.097 0.160 0.452 0.515 2.060
1.101 0.319 1.608 1.916 6.739 6.739 0.319 0.738 1.101 0.319 1.461 0.319 0.738 1.101 2.522 2.800 8.484
0.1027 0.0327 0.1704 0.2054 1.0582 1.0922 0.0327 0.0677 0.1027 0.0327 0.1694 0.0327 0.0677 0.1027 0.3071 0.3421 1.4425
[hab/ha]
Coeficiente de Infiltracion =
[L/hab/dia]
0.5
[ L/s/Km]
Coef. de Rugosidad Manning 0.013 Para cualquier tipo de material de tuberia
[%]
Peso esp.del agua =
1000
[%]
Cama de arena =
10
[Cm]
19
20 # com. 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Dot. Instituciones Publicas = 5,000 - 15,000
5000
Dot. Industrial = 16,000 - 18,000 16000 Gravedad g = 9.81
21
22
23
24
25
26
27
28
29
Qc 0.0000 0.0000 0.0000 0.0000 0.0116 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
# I.P. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Qip 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
# ind. 0 0 0 0 0 0 0 0 0 0
Qind. 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
∑Qdc 0.000 0.000 0.000 0.000 0.012 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Acum. 0.16 0.70 1.14 0.26 1.53 0.59 1.04 0.38 1.68 2.06 3.36 0.38 0.86 1.29 0.38 1.91 2.27 5.17 0.38 0.86 1.29 0.38 1.91 2.28 6.86 0.38 0.86
q 1.50 1.50 1.50 1.50 1.53 1.50 1.50 1.50 1.68 2.06 3.36 1.50 1.50 1.50 1.50 1.91 2.27 5.17 1.50 1.50 1.50 1.50 1.91 2.28 6.86 1.50 1.50
inicial 2544.8 2544.6 2544.1 2544.3 2544 2545.3 2544.88 2544.6 2544 2544 2544 2544.95 2544.7 2544.5 2544 2544 2544 2544 2544.95 2544.7 2544.3 2544 2544 2544 2543.95 2544.75 2544.45
30
Cota terreno (m)
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000
[Kg/m^3]
Caudal (l/s) Qe 0.0112 0.0481 0.0783 0.0176 0.1026 0.0416 0.0723 0.0255 0.1145 0.1398 0.2236 0.0255 0.0590 0.0881 0.0255 0.1287 0.1533 0.3403 0.0255 0.0590 0.0881 0.0255 0.1287 0.1533 0.4475 0.0255 0.0590
Dot. Comercial = 600 - 3,000
final 2544.6 2544.1 2544 2544 2544 2544.88 2544 2544 2544 2544 2544 2544.7 2544.5 2544 2544 2544 2544 2543.95 2544.7 2544.3 2544 2544 2544 2543.95 2543.75 2544.45 2544
31
32
33
Prof.de excav. (m) inicial 1.20 1.20 1.20 1.20 1.30 1.20 1.20 1.20 1.30 1.50 1.70 1.20 1.20 1.20 1.20 1.40 1.60 2.00 1.20 1.30 1.40 1.45 1.70 2.00 2.30 1.20 1.25
final 1.20 1.20 1.30 1.30 1.70 1.20 1.30 1.30 1.50 1.70 2.00 1.20 1.20 1.20 1.40 1.60 2.00 2.30 1.30 1.40 1.45 1.70 2.00 2.30 2.35 1.25 1.30
Media 1.20 1.20 1.25 1.25 1.50 1.20 1.25 1.25 1.40 1.60 1.85 1.20 1.20 1.20 1.30 1.50 1.80 2.15 1.25 1.35 1.43 1.58 1.85 2.15 2.33 1.23 1.28
34
35
Cota Solera inicial 2543.60 2543.40 2542.90 2543.10 2542.70 2544.10 2543.68 2543.40 2542.70 2542.50 2542.30 2543.75 2543.50 2543.30 2542.80 2542.60 2542.40 2542.00 2543.75 2543.40 2542.90 2542.55 2542.30 2542.00 2541.65 2543.55 2543.20
final 2543.40 2542.90 2542.70 2542.70 2542.30 2543.68 2542.70 2542.70 2542.50 2542.30 2542.00 2543.50 2543.30 2542.80 2542.60 2542.40 2542.00 2541.65 2543.40 2542.90 2542.55 2542.30 2542.00 2541.65 2541.40 2543.20 2542.70
36 Pend. % 0.741 0.714 0.286 0.995 0.588 0.618 1.441 1.108 0.286 0.286 0.438 0.394 0.286 0.714 0.310 0.286 0.571 0.515 0.535 0.714 0.500 0.382 0.429 0.500 0.368 0.535 0.714
0.0881 0.0255 0.1287 0.1533 0.5391 0.5391 0.0255 0.0590 0.0881 0.0255 0.1169 0.0255 0.0590 0.0881 0.2018 0.2240 0.6787
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
1.29 0.38 1.91 2.28 8.34 8.37 0.38 0.86 1.29 0.38 1.75 0.38 0.86 1.29 3.03 3.37 10.61
1.50 1.50 1.91 2.28 8.34 8.37 1.50 1.50 1.50 1.50 1.75 1.50 1.50 1.50 3.03 3.37 10.61
2544 2544.1 2544 2544 2543.75 2543.45 2544.45 2544.15 2544 2544.15 2544 2544 2544 2544 2543.85 2543.5 2544
2544 2544 2544 2543.75 2543.45 2543 2544.15 2544 2544 2544 2543.85 2544 2544 2543.85 2543.5 2543 2544
1.25 1.20 1.60 2.35 2.45 2.45 1.20 1.25 1.45 1.20 1.40 1.20 1.55 1.90 2.20 2.30 1.40
1.60 1.60 2.35 2.45 2.45 2.45 1.25 1.45 1.80 1.40 1.60 1.55 1.90 2.20 2.30 2.45 1.60
1.43 1.40 1.98 2.40 2.45 2.45 1.23 1.35 1.63 1.30 1.50 1.38 1.73 2.05 2.25 2.38 1.50
2542.75 2542.90 2542.40 2541.65 2541.30 2541.00 2543.25 2542.90 2542.55 2542.95 2542.60 2542.80 2542.45 2542.10 2541.65 2541.20 2542.60
2542.40 2542.40 2541.65 2541.30 2541.00 2540.55 2542.90 2542.55 2542.20 2542.60 2542.25 2542.45 2542.10 2541.65 2541.20 2540.55 2542.40
0.500 0.765 1.071 0.500 0.441 0.662 0.535 0.500 0.500 0.535 0.515 0.535 0.500 0.643 0.643 0.929 1.220
[L/comercio/dia] [L/Instituciones Publicas/dia] [L/Industria/dia]
UnitLoad =
0.23 [L/s]
[m/s^2]
37
38
39
(mm) 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 200 150 150 150 150 150 150 200 150 150
Rh (m) 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0500 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0500 0.0375 0.0375
Diametro (Pulgadas) 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 8 6 6 6 6 6 6 8 6 6
40
41
42
43
44
45
46
rh/Rh 0.533 0.533 0.659 0.488 0.573 0.555 0.437 0.488 0.690 0.758 0.850 0.611 0.659 0.533 0.644 0.732 0.675 0.704 0.573 0.533 0.573 0.611 0.675 0.704 0.860 0.573 0.533
v (m/s) 0.488 0.479 0.349 0.533 0.456 0.457 0.596 0.562 0.360 0.383 0.512 0.390 0.349 0.479 0.358 0.375 0.502 0.593 0.435 0.479 0.420 0.384 0.434 0.483 0.572 0.435 0.479
47
48
REGIMEN HIDRAULICO V (m/s) Q (l/s) 0.74 ok 13.11 0.73 ok 12.87 0.46 baja 8.14 0.86 ok 15.19 0.66 ok 11.68 0.68 ok 11.97 1.03 ok 18.28 0.91 ok 16.03 0.46 baja 8.14 0.46 baja 8.14 0.57 baja 10.08 0.54 baja 9.56 0.46 baja 8.14 0.73 ok 12.87 0.48 baja 8.48 0.46 baja 8.14 0.65 ok 11.51 0.75 ok 23.53 0.63 ok 11.14 0.73 ok 12.87 0.61 ok 10.77 0.53 baja 9.42 0.56 baja 9.97 0.61 ok 10.77 0.63 ok 19.89 0.63 ok 11.14 0.73 ok 12.87
q/Q 0.11 0.12 0.18 0.10 0.13 0.13 0.08 0.09 0.21 0.25 0.33 0.16 0.18 0.12 0.18 0.23 0.20 0.22 0.13 0.12 0.14 0.16 0.19 0.21 0.34 0.13 0.12
v/V 0.658 0.658 0.757 0.620 0.690 0.675 0.576 0.620 0.781 0.831 0.897 0.720 0.757 0.658 0.746 0.813 0.770 0.792 0.690 0.658 0.690 0.720 0.770 0.792 0.904 0.690 0.658
d/D 0.224 0.224 0.287 0.203 0.244 0.234 0.179 0.203 0.303 0.341 0.395 0.262 0.287 0.224 0.279 0.326 0.295 0.311 0.244 0.224 0.244 0.262 0.295 0.311 0.402 0.244 0.224
49 Vc
d (mm) r h (m) 33.6 ok 0.020 33.6 ok 0.020 43.05 ok 0.025 30.45 ok 0.018 36.6 ok 0.021 35.1 ok 0.021 26.85 bajo 0.016 30.45 ok 0.018 45.45 ok 0.026 51.15 ok 0.028 59.25 ok 0.032 39.3 ok 0.023 43.05 ok 0.025 33.6 ok 0.020 41.85 ok 0.024 48.9 ok 0.027 44.25 ok 0.025 62.2 ok 0.035 36.6 ok 0.021 33.6 ok 0.020 36.6 ok 0.021 39.3 ok 0.023 44.25 ok 0.025 46.65 ok 0.026 80.4 ok 0.043 36.6 ok 0.021 33.6 ok 0.020
(m/s) 2.66 2.66 2.95 2.54 2.75 2.71 2.41 2.54 3.02 3.17 3.36 2.84 2.95 2.66 2.92 3.11 2.99 3.53 2.75 2.66 2.75 2.84 2.99 3.05 3.90 2.75 2.66
50
51
F tract.
Ancho
(N/m^2) zanja (m) 1.45 ok 0.60 1.40 ok 0.60 0.69 baja 0.60 1.79 ok 0.60 1.24 ok 0.60 1.26 ok 0.60 2.32 ok 0.60 1.99 ok 0.60 0.73 baja 0.60 0.80 baja 0.60 1.37 ok 0.60 0.89 baja 0.60 0.69 baja 0.60 1.40 ok 0.60 0.73 baja 0.60 0.77 baja 0.60 1.42 ok 0.60 1.78 ok 0.65 1.13 ok 0.60 1.40 ok 0.60 1.05 ok 0.60 0.86 baja 0.60 1.06 ok 0.60 1.29 ok 0.60 1.55 ok 0.65 1.13 ok 0.60 1.40 ok 0.60
52
53
54
Volumenes (m^3) Excav. 19.44 50.40 52.50 30.15 61.20 48.96 51.00 47.40 58.80 67.20 76.04 45.65 50.40 50.40 50.33 63.00 75.60 95.03 49.03 56.70 59.85 61.77 77.70 90.30 102.77 48.07 53.55
Arena 1.62 4.20 4.20 2.41 4.08 4.08 4.08 3.79 4.20 4.20 4.11 3.80 4.20 4.20 3.87 4.20 4.20 4.42 3.92 4.20 4.20 3.92 4.20 4.20 4.42 3.92 4.20
Relleno 17.82 46.20 48.30 27.74 57.12 44.88 46.92 43.61 54.60 63.00 71.93 41.84 46.20 46.20 46.46 58.80 71.40 90.61 45.11 52.50 55.65 57.85 73.50 86.10 98.35 44.15 49.35
6 6 6 6 8 8 6 6 6 6 6 6 6 6 6 6 6
150 150 150 150 200 200 150 150 150 150 150 150 150 150 150 150 150
0.0375 0.0375 0.0375 0.0375 0.0500 0.0500 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375 0.0375
0.61 0.75 0.89 0.61 0.69 0.85 0.63 0.61 0.61 0.63 0.62 0.63 0.61 0.69 0.69 0.83 0.95
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
10.77 13.32 15.76 10.77 21.79 26.68 11.14 10.77 10.77 11.14 10.93 11.14 10.77 12.21 12.21 14.68 16.82
0.14 0.11 0.12 0.21 0.38 0.31 0.13 0.14 0.14 0.13 0.16 0.13 0.14 0.12 0.25 0.23 0.63
0.690 0.658 0.675 0.792 0.932 0.882 0.690 0.690 0.690 0.690 0.720 0.690 0.690 0.675 0.822 0.802 1.057
0.244 0.224 0.234 0.311 0.428 0.382 0.244 0.244 0.244 0.244 0.262 0.244 0.244 0.234 0.334 0.319 0.576
0.573 0.533 0.555 0.704 0.900 0.828 0.573 0.573 0.573 0.573 0.611 0.573 0.573 0.555 0.745 0.718 1.087
0.420 0.496 0.602 0.483 0.646 0.749 0.435 0.420 0.420 0.435 0.445 0.435 0.420 0.466 0.568 0.666 1.006
36.6 33.6 35.1 46.65 85.6 76.4 36.6 36.6 36.6 36.6 39.3 36.6 36.6 35.1 50.1 47.85 86.4
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
0.021 0.020 0.021 0.026 0.045 0.041 0.021 0.021 0.021 0.021 0.023 0.021 0.021 0.021 0.028 0.027 0.041
2.75 2.66 2.71 3.05 3.99 3.82 2.75 2.75 2.75 2.75 2.84 2.75 2.75 2.71 3.14 3.08 3.79
1.05 1.50 2.19 1.29 1.95 2.69 1.13 1.05 1.05 1.13 1.16 1.13 1.05 1.31 1.76 2.45 4.88
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
0.60 0.60 0.60 0.60 0.65 0.65 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60
59.85 54.94 82.95 100.80 108.29 108.29 48.07 56.70 68.25 51.01 61.20 53.96 72.45 86.10 94.50 99.75 14.76
4.20 3.92 4.20 4.20 4.42 4.42 3.92 4.20 4.20 3.92 4.08 3.92 4.20 4.20 4.20 4.20 0.98
55.65 51.01 78.75 96.60 103.87 103.87 44.15 52.50 64.05 47.09 57.12 50.03 68.25 81.90 90.30 95.55 13.78
55 Observ. C. Arranque
C. Arranque C. Arranque C. Arranque
C. Arranque
C. Arranque
C. Arranque
C. Arranque
C. Arranque
C. Arranque
C. Arranque
C. Arranque C. Arranque
Diametro Ancho Zanja 100 150 200 250 300 400 450 500 550 600 700 800 900 1000 1100
0.50 0.60 0.65 0.70 0.80 0.90 0.95 1 1.10 1.15 1.25 1.35 1.50 1.60 1.80
Relaciones Hidraulicas q/Q v/V q/Q d/D q/Q rh/RH 0.00 0.01 0.02 0.03 0.04 0.05 0.08 0.06 0.07 0.09 0.10 0.11 0.12 0.13 0.14 0.15 0.16 0.17 0.18 0.19 0.20 0.21 0.22 0.23 0.24 0.25 0.26 0.27 0.28 0.29 0.30 0.31 0.32 0.33 0.34 0.35 0.36 0.37 0.38 0.39 0.40 0.41 0.42 0.43 0.44
0.000 0.326 0.398 0.448 0.488 0.522 0.599 0.551 0.576 0.620 0.641 0.658 0.675 0.690 0.705 0.720 0.733 0.746 0.757 0.770 0.781 0.792 0.802 0.813 0.822 0.831 0.840 0.849 0.858 0.866 0.874 0.882 0.890 0.897 0.904 0.911 0.918 0.925 0.932 0.938 0.944 0.950 0.956 0.962 0.968
0.00 0.01 0.02 0.03 0.04 0.05 0.08 0.06 0.07 0.09 0.10 0.11 0.12 0.13 0.14 0.15 0.16 0.17 0.18 0.19 0.20 0.21 0.22 0.23 0.24 0.25 0.26 0.27 0.28 0.29 0.30 0.31 0.32 0.33 0.34 0.35 0.36 0.37 0.38 0.39 0.40 0.41 0.42 0.43 0.44
0.000 0.072 0.099 0.119 0.137 0.152 0.191 0.167 0.179 0.203 0.215 0.224 0.234 0.244 0.253 0.262 0.271 0.279 0.287 0.295 0.303 0.311 0.319 0.326 0.334 0.341 0.348 0.355 0.362 0.369 0.376 0.382 0.389 0.395 0.402 0.408 0.415 0.421 0.428 0.434 0.440 0.446 0.452 0.458 0.464
0.00 0.01 0.02 0.03 0.04 0.05 0.08 0.06 0.07 0.09 0.10 0.11 0.12 0.13 0.14 0.15 0.16 0.17 0.18 0.19 0.20 0.21 0.22 0.23 0.24 0.25 0.26 0.27 0.28 0.29 0.30 0.31 0.32 0.33 0.34 0.35 0.36 0.37 0.38 0.39 0.40 0.41 0.42 0.43 0.44
0.000 0.186 0.251 0.300 0.341 0.377 0.464 0.409 0.437 0.488 0.513 0.533 0.555 0.573 0.592 0.611 0.627 0.644 0.659 0.675 0.690 0.704 0.718 0.732 0.745 0.758 0.770 0.783 0.794 0.806 0.817 0.828 0.839 0.850 0.860 0.870 0.880 0.890 0.900 0.908 0.918 0.927 0.935 0.943 0.952
0.45 0.46 0.47 0.48 0.49 0.50 0.51 0.52 0.53 0.54 0.55 0.56 0.57 0.58 0.59 0.60 0.61 0.62 0.63 0.64 0.65 0.66 0.67 0.68 0.69 0.70 0.71 0.72 0.73 0.74 0.75 0.76 0.77 0.78 0.79 0.80 0.81 0.82 0.83 0.84 0.85 0.86 0.87 0.88 0.89 0.90 0.91 0.92
0.974 0.979 0.985 0.990 0.995 1.000 1.005 1.010 1.015 1.019 1.024 1.028 1.033 1.037 1.041 1.045 1.049 1.053 1.057 1.061 1.065 1.068 1.072 1.075 1.079 1.082 1.085 1.088 1.092 1.095 1.097 1.100 1.103 1.106 1.108 1.111 1.113 1.116 1.118 1.120 1.123 1.125 1.126 1.128 1.130 1.132 1.133 1.135
0.45 0.46 0.47 0.48 0.49 0.50 0.51 0.52 0.53 0.54 0.55 0.56 0.57 0.58 0.59 0.60 0.61 0.62 0.63 0.64 0.65 0.66 0.67 0.68 0.69 0.70 0.71 0.72 0.73 0.74 0.75 0.76 0.77 0.78 0.79 0.80 0.81 0.82 0.83 0.84 0.85 0.86 0.87 0.88 0.89 0.90 0.91 0.92
0.470 0.476 0.482 0.488 0.494 0.500 0.506 0.512 0.518 0.523 0.529 0.535 0.541 0.547 0.552 0.558 0.564 0.570 0.576 0.581 0.587 0.593 0.599 0.605 0.611 0.616 0.622 0.628 0.634 0.640 0.646 0.652 0.658 0.664 0.670 0.677 0.683 0.689 0.695 0.702 0.708 0.715 0.721 0.728 0.735 0.742 0.749 0.756
0.45 0.46 0.47 0.48 0.49 0.50 0.51 0.52 0.53 0.54 0.55 0.56 0.57 0.58 0.59 0.60 0.61 0.62 0.63 0.64 0.65 0.66 0.67 0.68 0.69 0.70 0.71 0.72 0.73 0.74 0.75 0.76 0.77 0.78 0.79 0.80 0.81 0.82 0.83 0.84 0.85 0.86 0.87 0.88 0.89 0.90 0.91 0.92
0.961 0.969 0.977 0.985 0.992 1.000 1.007 1.015 1.022 1.029 1.036 1.043 1.049 1.056 1.062 1.068 1.075 1.081 1.087 1.093 1.098 1.104 1.110 1.115 1.120 1.125 1.131 1.135 1.140 1.145 1.150 1.154 1.159 1.163 1.167 1.171 1.175 1.179 1.182 1.186 1.189 1.193 1.196 1.199 1.201 1.204 1.206 1.209
0.93 0.94 0.95 0.96 0.97 0.98 0.99
1.136 1.137 1.138 1.139 1.139 1.140 1.140
0.93 0.94 0.95 0.96 0.97 0.98 0.99
0.763 0.771 0.778 0.786 0.794 0.802 0.811
0.93 0.94 0.95 0.96 0.97 0.98 0.99
1.211 1.212 1.214 1.215 1.216 1.217 1.217
HOJA VINCULADA CON LA PLANILLA SANITARIA 2012 "NO TOCAR NADA"
Related Documents
Planilla (areas) Adscripcion 2013.xlsx
November 2019 18
Planilla
April 2020 30
Areas
October 2019 48
Areas
April 2020 33
Areas
November 2019 45
Areas
November 2019 47More Documents from ""
Makalah Biostatistik.docx
June 2020 21
Fran-utaaahj.docx
October 2019 80
Edwin Collectie
December 2019 66
Sistemas Activos Amd.docx
November 2019 60
