Tabla de Cálculo

TABLA DE CALCULO DE REDES DE DISTRIBUCION DE AGUA POTABLE METODO HARDY-CROSS/MANNING

PROYECTO: Red cerrada PROYECTISTA: Olmos Trujillo Cinthia Jimena No. de tramos: 86

DESCRIPCION TRAMO LONGITUD DIAMETRO DIAMETRO COEF. GASTO GASTO VELOCIDAD PERDIDA DE CARGA(m) COTA DE T.N.(m)
De a (m) INTERIOR(mm) EFECTIVO(mm) RUGOSIDAD INICIAL(lps) FINAL(lps) (m/s) TUBERIA ADICIONAL INICIAL FINAL
1 2 22.695 152.4 152.4 0.00900 20.630 20.630 162.071 200.000 #ADDIN? 1.131 0.183 0.000 1908.427 1908.867
2 85 7.510 152.4 152.4 0.00900 11.836 10.215 114.043 150.000 #ADDIN? 0.560 0.015 0.000 1908.867 1908.876
2 3 11.767 152.4 152.4 0.00900 8.683 10.304 114.539 150.000 #ADDIN? 0.565 0.024 0.000 1908.867 1908.989
3 4 45.767 152.4 152.4 0.00900 8.625 10.246 114.217 150.000 #ADDIN? 0.562 0.091 0.000 1908.989 1909.163
4 5 14.203 152.4 152.4 0.00900 8.400 10.021 112.957 150.000 #ADDIN? 0.549 0.027 0.000 1909.163 1908.941
5 6 8.265 152.4 152.4 0.00900 8.330 9.951 112.563 150.000 #ADDIN? 0.546 0.016 0.000 1908.941 1908.655
6 7 15.895 152.4 152.4 0.00900 8.290 9.911 112.333 150.000 #ADDIN? 0.543 0.030 0.000 1908.655 1908.550
7 8 40.739 152.4 152.4 0.00900 8.212 9.833 111.890 150.000 #ADDIN? 0.539 0.075 0.000 1908.550 1908.253
8 9 11.177 152.4 152.4 0.00900 8.011 9.633 110.746 150.000 #ADDIN? 0.528 0.020 0.000 1908.253 1908.105
9 10 22.649 152.4 152.4 0.00900 7.957 9.578 110.430 150.000 #ADDIN? 0.525 0.039 0.000 1908.105 1907.570
10 11 20.007 152.4 152.4 0.00900 7.845 9.466 109.786 150.000 #ADDIN? 0.519 0.034 0.000 1907.570 1907.695
11 12 8.368 152.4 152.4 0.00900 7.747 9.368 109.215 150.000 #ADDIN? 0.514 0.014 0.000 1907.695 1907.609
12 13 38.098 152.4 152.4 0.00900 7.706 9.327 108.975 150.000 #ADDIN? 0.511 0.063 0.000 1907.609 1907.340
13 14 6.854 152.4 152.4 0.00900 7.519 9.140 107.876 150.000 #ADDIN? 0.501 0.011 0.000 1907.340 1907.480
14 15 12.573 152.4 152.4 0.00900 7.485 9.106 107.677 150.000 #ADDIN? 0.499 0.020 0.000 1907.480 1907.687
15 16 15.093 152.4 152.4 0.00900 7.423 9.044 107.312 150.000 #ADDIN? 0.496 0.023 0.000 1907.687 1907.861
16 17 9.864 152.4 152.4 0.00900 7.349 8.970 106.871 150.000 #ADDIN? 0.492 0.015 0.000 1907.861 1907.640
17 18 120.011 152.4 152.4 0.00900 7.301 8.922 106.582 150.000 #ADDIN? 0.489 0.181 0.000 1907.640 1906.491
18 19 35.940 152.4 152.4 0.00900 6.711 8.332 103.000 150.000 #ADDIN? 0.457 0.047 0.000 1906.491 1906.264
19 20 42.104 152.4 152.4 0.00900 6.535 8.156 101.903 150.000 #ADDIN? 0.447 0.053 0.000 1906.264 1905.880
20 21 52.127 152.4 152.4 0.00900 6.328 7.949 100.603 150.000 #ADDIN? 0.436 0.063 0.000 1905.880 1905.548
21 22 15.395 152.4 152.4 0.00900 6.072 7.693 98.970 100.000 #ADDIN? 0.422 0.017 0.000 1905.548 1905.382
22 23 22.491 152.4 152.4 0.00900 5.996 7.617 98.482 100.000 #ADDIN? 0.418 0.025 0.000 1905.382 1904.909
23 24 106.769 152.4 152.4 0.00900 5.886 7.507 97.765 100.000 #ADDIN? 0.412 0.114 0.000 1904.909 1904.165
24 25 192.508 152.4 152.4 0.00900 5.361 6.982 94.288 100.000 #ADDIN? 0.383 0.178 0.000 1904.165 1903.141
25 26 65.978 152.4 152.4 0.00900 4.416 6.037 87.671 100.000 #ADDIN? 0.331 0.046 0.000 1903.141 1902.418
26 58 37.673 152.4 152.4 0.00900 -0.503 1.344 41.368 50.000 #ADDIN? 0.074 0.001 0.000 1902.418 1902.291
26 27 12.957 152.4 152.4 0.00900 4.595 4.369 74.580 75.000 #ADDIN? 0.239 0.005 0.000 1902.418 1902.506
27 28 16.399 152.4 152.4 0.00900 4.531 4.305 74.035 75.000 #ADDIN? 0.236 0.006 0.000 1902.506 1902.753
28 29 33.250 152.4 152.4 0.00900 4.451 4.224 73.339 75.000 #ADDIN? 0.232 0.011 0.000 1902.753 1902.616
29 30 147.941 152.4 152.4 0.00900 4.287 4.061 71.907 75.000 #ADDIN? 0.223 0.046 0.000 1902.616 1902.715
30 31 30.444 152.4 152.4 0.00900 3.561 3.334 65.157 75.000 #ADDIN? 0.183 0.006 0.000 1902.715 1903.233
31 32 135.877 152.4 152.4 0.00900 3.411 3.185 63.679 75.000 #ADDIN? 0.175 0.026 0.000 1903.233 1903.152
32 33 104.818 152.4 152.4 0.00900 2.744 2.517 56.614 75.000 #ADDIN? 0.138 0.013 0.000 1903.152 1902.631
33 34 102.415 152.4 152.4 0.00900 2.229 2.002 50.493 75.000 #ADDIN? 0.110 0.008 0.000 1902.631 1902.178
34 35 133.004 152.4 152.4 0.00900 1.726 1.499 43.693 50.000 #ADDIN? 0.082 0.006 0.000 1902.178 1902.081
35 36 10.212 152.4 152.4 0.00900 1.072 0.846 32.820 50.000 #ADDIN? 0.046 0.000 0.000 1902.081 1901.910
36 37 130.979 152.4 152.4 0.00900 1.022 0.796 31.833 50.000 #ADDIN? 0.044 0.002 0.000 1901.910 1900.931
37 38 49.243 152.4 152.4 0.00900 0.379 0.152 13.933 50.000 #ADDIN? 0.008 0.000 0.000 1900.931 1900.565
39 38 16.482 152.4 152.4 0.00900 -0.137 0.089 10.671 50.000 #ADDIN? 0.005 0.000 0.000 1900.303 1900.565
40 39 26.935 152.4 152.4 0.00900 -0.056 0.170 14.729 50.000 #ADDIN? 0.009 0.000 0.000 1900.126 1900.303
41 40 37.710 152.4 152.4 0.00900 0.076 0.303 19.632 50.000 #ADDIN? 0.017 0.000 0.000 1899.772 1900.126
42 41 50.515 152.4 152.4 0.00900 0.261 0.488 24.925 50.000 #ADDIN? 0.027 0.000 0.000 1899.565 1899.772
43 42 63.384 152.4 152.4 0.00900 0.510 0.736 30.614 50.000 #ADDIN? 0.040 0.001 0.000 1899.082 1899.565
44 43 6.808 152.4 152.4 0.00900 0.821 1.047 36.519 50.000 #ADDIN? 0.057 0.000 0.000 1898.948 1899.082
45 44 41.467 152.4 152.4 0.00900 0.854 1.081 37.097 50.000 #ADDIN? 0.059 0.001 0.000 1898.662 1898.948
46 45 56.959 152.4 152.4 0.00900 1.058 1.285 40.442 50.000 #ADDIN? 0.070 0.002 0.000 1898.305 1898.662
47 46 37.267 152.4 152.4 0.00900 1.338 1.564 44.630 50.000 #ADDIN? 0.086 0.002 0.000 1898.442 1898.305
48 47 68.159 152.4 152.4 0.00900 1.521 1.747 47.169 50.000 #ADDIN? 0.096 0.004 0.000 1898.811 1898.442
49 48 32.498 152.4 152.4 0.00900 1.856 2.082 51.490 75.000 #ADDIN? 0.114 0.003 0.000 1899.097 1898.811
50 49 66.636 152.4 152.4 0.00900 2.015 2.242 53.427 75.000 #ADDIN? 0.123 0.006 0.000 1899.602 1899.097
51 50 12.301 152.4 152.4 0.00900 2.343 2.569 57.194 75.000 #ADDIN? 0.141 0.002 0.000 1899.691 1899.602
52 51 55.981 152.4 152.4 0.00900 2.403 2.630 57.863 75.000 #ADDIN? 0.144 0.007 0.000 1900.441 1899.691
53 52 34.762 152.4 152.4 0.00900 2.678 2.905 60.813 75.000 #ADDIN? 0.159 0.006 0.000 1900.595 1900.441

Página 1
 Tabla de Cálculo

54 53 57.546 152.4 152.4 0.00900 2.849 3.075 62.575 75.000 #ADDIN? 0.169 0.010 0.000 1900.749 1900.595
55 54 34.802 152.4 152.4 0.00900 3.132 3.358 65.388 75.000 #ADDIN? 0.184 0.007 0.000 1901.300 1900.749
56 55 78.382 152.4 152.4 0.00900 3.303 3.529 67.032 75.000 #ADDIN? 0.193 0.019 0.000 1902.313 1901.300
57 56 196.018 152.4 152.4 0.00900 3.688 3.914 70.594 75.000 #ADDIN? 0.215 0.057 0.000 1902.134 1902.313
58 57 58.596 152.4 152.4 0.00900 -0.976 0.871 33.305 50.000 #ADDIN? 0.048 0.001 0.000 1902.291 1902.134
59 57 96.325 152.4 152.4 0.00900 5.627 4.006 71.416 75.000 #ADDIN? 0.220 0.029 0.000 1902.027 1902.134
60 59 25.444 152.4 152.4 0.00900 6.100 4.479 75.516 100.000 #ADDIN? 0.246 0.010 0.000 1902.125 1902.027
61 60 17.899 152.4 152.4 0.00900 6.225 4.604 76.563 100.000 #ADDIN? 0.252 0.007 0.000 1902.180 1902.125
62 61 13.776 152.4 152.4 0.00900 6.313 4.692 77.290 100.000 #ADDIN? 0.257 0.006 0.000 1901.880 1902.180
63 62 12.506 152.4 152.4 0.00900 6.381 4.759 77.846 100.000 #ADDIN? 0.261 0.005 0.000 1902.043 1901.880
64 63 13.076 152.4 152.4 0.00900 6.442 4.821 78.346 100.000 #ADDIN? 0.264 0.006 0.000 1902.240 1902.043
65 64 62.490 152.4 152.4 0.00900 6.506 4.885 78.867 100.000 #ADDIN? 0.268 0.028 0.000 1902.435 1902.240
66 65 33.189 152.4 152.4 0.00900 6.813 5.192 81.307 100.000 #ADDIN? 0.285 0.017 0.000 1902.477 1902.435
67 66 86.259 152.4 152.4 0.00900 6.976 5.355 82.573 100.000 #ADDIN? 0.294 0.047 0.000 1902.290 1902.477
68 67 23.029 152.4 152.4 0.00900 7.400 5.779 85.778 100.000 #ADDIN? 0.317 0.015 0.000 1902.360 1902.290
69 68 31.458 152.4 152.4 0.00900 7.513 5.892 86.613 100.000 #ADDIN? 0.323 0.021 0.000 1902.630 1902.360
70 69 28.447 152.4 152.4 0.00900 7.668 6.046 87.742 100.000 #ADDIN? 0.331 0.020 0.000 1902.858 1902.630
71 70 36.239 152.4 152.4 0.00900 7.807 6.186 88.750 100.000 #ADDIN? 0.339 0.026 0.000 1903.022 1902.858
72 71 36.639 152.4 152.4 0.00900 7.985 6.364 90.018 100.000 #ADDIN? 0.349 0.028 0.000 1903.273 1903.022
73 72 21.630 152.4 152.4 0.00900 8.165 6.544 91.282 100.000 #ADDIN? 0.359 0.018 0.000 1902.851 1903.273
74 73 55.941 152.4 152.4 0.00900 8.272 6.650 92.020 100.000 #ADDIN? 0.365 0.047 0.000 1903.755 1902.851
75 74 93.904 152.4 152.4 0.00900 8.546 6.925 93.902 100.000 #ADDIN? 0.380 0.086 0.000 1904.485 1903.755
76 75 50.495 152.4 152.4 0.00900 9.008 7.387 96.979 100.000 #ADDIN? 0.405 0.052 0.000 1904.549 1904.485
77 76 10.270 152.4 152.4 0.00900 9.256 7.635 98.593 100.000 #ADDIN? 0.419 0.011 0.000 1904.657 1904.549
78 77 80.291 152.4 152.4 0.00900 9.306 7.685 98.919 100.000 #ADDIN? 0.421 0.090 0.000 1905.570 1904.657
79 78 121.814 152.4 152.4 0.00900 9.701 8.079 101.425 150.000 #ADDIN? 0.443 0.151 0.000 1906.093 1905.570
80 79 145.088 152.4 152.4 0.00900 10.299 8.678 105.114 150.000 #ADDIN? 0.476 0.207 0.000 1907.371 1906.093
81 80 35.921 152.4 152.4 0.00900 11.012 9.391 109.345 150.000 #ADDIN? 0.515 0.060 0.000 1907.548 1907.371
82 81 44.954 152.4 152.4 0.00900 11.188 9.567 110.368 150.000 #ADDIN? 0.524 0.078 0.000 1908.139 1907.548
83 82 7.486 152.4 152.4 0.00900 11.409 9.788 111.634 150.000 #ADDIN? 0.537 0.014 0.000 1908.282 1908.139
84 83 27.209 152.4 152.4 0.00900 11.446 9.825 111.844 150.000 #ADDIN? 0.539 0.050 0.000 1908.464 1908.282
85 84 44.717 152.4 152.4 0.00900 11.579 9.958 112.602 150.000 #ADDIN? 0.546 0.084 0.000 1908.876 1908.464

Página 2
 Tabla de Cálculo

E DISTRIBUCION DE AGUA POTABLE METODO HARDY-CROSS/MANNING

No. de nodos: 85

COTA PIEZOMETRICA(m) CARGA DISPONIBLE(m) OBSERVACIONES

INICIAL FINAL INICIAL FINAL
1928.427 1928.243 20.000 19.377
1928.243 1928.228 19.377 19.353
1928.243 1928.219 19.377 19.231
1928.219 1928.128 19.231 18.965
1928.128 1928.101 18.965 19.160
1928.101 1928.086 19.160 19.431
1928.086 1928.056 19.431 19.505
1928.056 1927.981 19.505 19.728
1927.981 1927.961 19.728 19.857
1927.961 1927.922 19.857 20.352
1927.922 1927.888 20.352 20.193
1927.888 1927.874 20.193 20.265
1927.874 1927.811 20.265 20.471
1927.811 1927.800 20.471 20.320
1927.800 1927.780 20.320 20.093
1927.780 1927.757 20.093 19.896
1927.757 1927.742 19.896 20.102
1927.742 1927.561 20.102 21.069
1927.561 1927.513 21.069 21.249
1927.513 1927.460 21.249 21.580
1927.460 1927.397 21.580 21.850
1927.397 1927.380 21.850 21.998
1927.380 1927.355 21.998 22.446
1927.355 1927.241 22.446 23.076
1927.241 1927.063 23.076 23.922
1927.063 1927.017 23.922 24.599
1927.017 1927.016 24.599 24.725
1927.017 1927.013 24.599 24.506
1927.013 1927.007 24.506 24.254
1927.007 1926.996 24.254 24.380
1926.996 1926.949 24.380 24.234
1926.949 1926.943 24.234 23.710
1926.943 1926.917 23.710 23.765
1926.917 1926.904 23.765 24.273
1926.904 1926.896 24.273 24.718
1926.896 1926.891 24.718 24.809
1926.891 1926.890 24.809 24.981
1926.890 1926.889 24.981 25.958
1926.889 1926.889 25.958 26.324
1926.889 1926.889 26.586 26.324
1926.889 1926.889 26.763 26.586
1926.889 1926.889 27.117 26.763
1926.889 1926.889 27.324 27.117
1926.890 1926.889 27.808 27.324
1926.890 1926.890 27.942 27.808
1926.891 1926.890 28.229 27.942
1926.893 1926.891 28.588 28.229
1926.894 1926.893 28.452 28.588
1926.898 1926.894 28.087 28.452
1926.901 1926.898 27.804 28.087
1926.907 1926.901 27.305 27.804
1926.909 1926.907 27.218 27.305
1926.916 1926.909 26.475 27.218
1926.922 1926.916 26.327 26.475

Página 3
 Tabla de Cálculo

1926.932 1926.922 26.183 26.327

1926.940 1926.932 25.639 26.183
1926.958 1926.940 24.645 25.639
1927.015 1926.958 24.881 24.645
1927.016 1927.015 24.725 24.881
1927.045 1927.015 25.018 24.881
1927.054 1927.045 24.929 25.018
1927.061 1927.054 24.881 24.929
1927.067 1927.061 25.188 24.881
1927.073 1927.067 25.030 25.188
1927.078 1927.073 24.838 25.030
1927.107 1927.078 24.672 24.838
1927.124 1927.107 24.646 24.672
1927.171 1927.124 24.880 24.646
1927.185 1927.171 24.825 24.880
1927.206 1927.185 24.576 24.825
1927.226 1927.206 24.368 24.576
1927.252 1927.226 24.230 24.368
1927.280 1927.252 24.007 24.230
1927.298 1927.280 24.447 24.007
1927.345 1927.298 23.590 24.447
1927.430 1927.345 22.945 23.590
1927.483 1927.430 22.934 22.945
1927.494 1927.483 22.837 22.934
1927.584 1927.494 22.014 22.837
1927.735 1927.584 21.642 22.014
1927.942 1927.735 20.572 21.642
1928.002 1927.942 20.454 20.572
1928.081 1928.002 19.942 20.454
1928.094 1928.081 19.812 19.942
1928.144 1928.094 19.680 19.812
1928.228 1928.144 19.353 19.680

Página 4