desagues hojas de calculo

ABASTECIMIENTO DE AGUA POTABLE Y ALCANTARILLADO

IVAN MOLINA P. MARCO SOTOMAYOR B.

5.5.2 HOJAS DE CALCULO - CROSS

1ra Iteración

Circuito Tramo L (Km) C D Qo V S(m/Km) Hf (m) Hf/Qo AQ(pulg) (lt/seg) (m/seg)

AB 0.143 140 4 -13.56 1.73 -26.995 -3.860 0.285 1.070BC 0.053 140 4 -12.24 1.56 -22.332 -1.184 0.097 1.070AK 0.068 140 4 13.56 1.73 26.995 1.836 0.135 1.070KJ 0.066 140 4 12.99 1.65 24.932 1.645 0.127 1.070IJ 0.147 140 4 10.42 1.33 16.575 2.437 0.234 1.070

I HI 0.260 140 4 10.42 1.33 16.575 4.309 0.414 1.070GH 0.230 140 3 4.49 1.02 14.154 3.255 0.725 1.070CD 0.078 140 3 -4.74 1.07 -15.648 -1.221 0.257 2.034DE 0.120 140 2 -3.77 1.92 -73.780 -8.854 2.348 2.034EF 0.052 140 2 -3.77 1.92 -73.780 -3.837 1.018 2.034FG 0.260 140 2 -3.25 1.66 -56.050 -14.573 4.484 2.034

-20.045 10.123

CD 0.078 140 3 4.74 1.07 15.648 1.221 0.257 -2.034DE 0.120 140 2 3.77 1.92 73.780 8.854 2.348 -2.034EF 0.052 140 2 3.77 1.92 73.780 3.837 1.018 -2.034FG 0.260 140 2 3.25 1.66 56.050 14.573 4.484 -2.034

II GN 0.260 140 3 3.58 0.81 9.305 2.419 0.676 -0.964MN 0.318 140 3 -3.50 0.79 -8.924 -2.838 0.811 -0.964LM 0.107 140 3 -3.50 0.79 -8.924 -0.955 0.273 -0.964CL 0.210 140 3 -7.50 1.70 -36.601 -7.686 1.025 -0.964

19.424 10.892

2da Iteración


AB 0.143 140 4 -12.490 1.59 -23.183 -3.315 0.265 -0.609BC 0.053 140 4 -11.170 1.42 -18.851 -0.999 0.089 -0.609AK 0.068 140 4 14.630 1.86 31.073 2.113 0.144 -0.609KJ 0.066 140 4 14.060 1.79 28.869 1.905 0.136 -0.609IJ 0.147 140 4 11.490 1.46 19.865 2.920 0.254 -0.609

I HI 0.260 140 4 11.490 1.46 19.865 5.165 0.450 -0.609GH 0.230 140 3 5.560 1.26 21.029 4.837 0.870 -0.609CD 0.078 140 3 -2.706 0.61 -5.540 -0.432 0.160 -1.275DE 0.120 140 2 -1.736 0.88 -17.544 -2.105 1.213 -1.275EF 0.052 140 2 -1.736 0.88 -17.544 -0.912 0.526 -1.275FG 0.260 140 2 -1.216 0.62 -9.073 -2.359 1.940 -1.275

6.817 6.047

CD 0.078 140 3 2.706 0.61 5.540 0.432 0.160 1.275DE 0.120 140 2 1.736 0.88 17.544 2.105 1.213 1.275EF 0.052 140 2 1.736 0.88 17.544 0.912 0.526 1.275FG 0.260 140 2 1.216 0.62 9.073 2.359 1.940 1.275

II GN 0.260 140 3 2.616 0.59 5.205 1.353 0.517 0.666MN 0.318 140 3 -4.464 1.01 -14.002 -4.453 0.997 0.666LM 0.107 140 3 -4.464 1.01 -14.002 -1.498 0.336 0.666CL 0.210 140 3 -8.464 1.92 -45.787 -9.615 1.136 0.666

-8.404 6.825



3ra Iteración


AB 0.143 140 4 -13.099 1.67 -25.321 -3.621 0.276 0.496BC 0.053 140 4 -11.779 1.50 -20.800 -1.102 0.094 0.496AK 0.068 140 4 14.021 1.79 28.719 1.953 0.139 0.496KJ 0.066 140 4 13.451 1.71 26.595 1.755 0.130 0.496IJ 0.147 140 4 10.881 1.39 17.958 2.640 0.243 0.496

I HI 0.260 140 4 10.881 1.39 17.958 4.669 0.429 0.496GH 0.230 140 3 4.951 1.12 16.961 3.901 0.788 0.496CD 0.078 140 3 -3.981 0.90 -11.326 -0.883 0.222 0.928DE 0.120 140 2 -3.011 1.53 -48.650 -5.838 1.939 0.928EF 0.052 140 2 -3.011 1.53 -48.650 -2.530 0.840 0.928FG 0.260 140 2 -2.491 1.27 -34.244 -8.904 3.575 0.928

-7.960 8.675

CD 0.078 140 3 3.981 0.90 11.326 0.883 0.222 -0.928DE 0.120 140 2 3.011 1.53 48.650 5.838 1.939 -0.928EF 0.052 140 2 3.011 1.53 48.650 2.530 0.840 -0.928FG 0.260 140 2 2.491 1.27 34.244 8.904 3.575 -0.928

II GN 0.260 140 3 3.282 0.74 7.920 2.059 0.628 -0.432MN 0.318 140 3 -3.798 0.86 -10.383 -3.302 0.869 -0.432LM 0.107 140 3 -3.798 0.86 -10.383 -1.111 0.292 -0.432CL 0.210 140 3 -7.798 1.77 -39.343 -8.262 1.059 -0.432

7.539 9.425

4ta Iteración


AB 0.143 140 4 -12.603 1.60 -23.574 -3.371 0.267 -0.290BC 0.053 140 4 -11.283 1.44 -19.207 -1.018 0.090 -0.290AK 0.068 140 4 14.517 1.85 30.629 2.083 0.143 -0.290KJ 0.066 140 4 13.947 1.78 28.439 1.877 0.135 -0.290IJ 0.147 140 4 11.377 1.45 19.503 2.867 0.252 -0.290

I HI 0.260 140 4 11.377 1.45 19.503 5.071 0.446 -0.290GH 0.230 140 3 5.447 1.23 20.241 4.656 0.855 -0.290CD 0.078 140 3 -3.052 0.69 -6.926 -0.540 0.177 -0.605DE 0.120 140 2 -2.082 1.06 -24.580 -2.950 1.416 -0.605EF 0.052 140 2 -2.082 1.06 -24.580 -1.278 0.614 -0.605FG 0.260 140 2 -1.562 0.80 -14.439 -3.754 2.403 -0.605

3.642 6.798

CD 0.078 140 3 3.052 0.69 6.926 0.540 0.177 0.605DE 0.120 140 2 2.082 1.06 24.580 2.950 1.416 0.605EF 0.052 140 2 2.082 1.06 24.580 1.278 0.614 0.605FG 0.260 140 2 1.562 0.80 14.439 3.754 2.403 0.605

II GN 0.260 140 3 2.849 0.64 6.097 1.585 0.556 0.316MN 0.318 140 3 -4.231 0.96 -12.678 -4.032 0.953 0.316LM 0.107 140 3 -4.231 0.96 -12.678 -1.357 0.321 0.316CL 0.210 140 3 -8.231 1.86 -43.478 -9.130 1.109 0.316

-4.411 7.549



5ta Iteración


AB 0.143 140 4 -12.893 1.64 -24.587 -3.516 0.273 0.230BC 0.053 140 4 -11.573 1.47 -20.130 -1.067 0.092 0.230AK 0.068 140 4 14.227 1.81 29.507 2.006 0.141 0.230KJ 0.066 140 4 13.657 1.74 27.355 1.805 0.132 0.230IJ 0.147 140 4 11.087 1.41 18.594 2.733 0.247 0.230

I HI 0.260 140 4 11.087 1.41 18.594 4.834 0.436 0.230GH 0.230 140 3 5.157 1.17 18.294 4.208 0.816 0.230CD 0.078 140 3 -3.658 0.83 -9.683 -0.755 0.206 0.426DE 0.120 140 2 -2.688 1.37 -39.431 -4.732 1.760 0.426EF 0.052 140 2 -2.688 1.37 -39.431 -2.050 0.763 0.426FG 0.260 140 2 -2.168 1.10 -26.480 -6.885 3.176 0.426

-3.418 8.042

CD 0.078 140 3 3.658 0.83 9.683 0.755 0.206 -0.426DE 0.120 140 2 2.688 1.37 39.431 4.732 1.760 -0.426EF 0.052 140 2 2.688 1.37 39.431 2.050 0.763 -0.426FG 0.260 140 2 2.168 1.10 26.480 6.885 3.176 -0.426

II GN 0.260 140 3 3.165 0.72 7.407 1.926 0.608 -0.196MN 0.318 140 3 -3.915 0.89 -10.981 -3.492 0.892 -0.196LM 0.107 140 3 -3.915 0.89 -10.981 -1.175 0.300 -0.196CL 0.210 140 3 -7.915 1.79 -40.439 -8.492 1.073 -0.196

3.189 8.779

6ta Iteración


AB 0.143 140 4 -12.663 1.61 -23.782 -3.401 0.269 -0.136BC 0.053 140 4 -11.343 1.44 -19.396 -1.028 0.091 -0.136AK 0.068 140 4 14.457 1.84 30.395 2.067 0.143 -0.136KJ 0.066 140 4 13.887 1.77 28.213 1.862 0.134 -0.136IJ 0.147 140 4 11.317 1.44 19.314 2.839 0.251 -0.136

I HI 0.260 140 4 11.317 1.44 19.314 5.022 0.444 -0.136GH 0.230 140 3 5.387 1.22 19.831 4.561 0.847 -0.136CD 0.078 140 3 -3.232 0.73 -7.699 -0.601 0.186 -0.284DE 0.120 140 2 -2.262 1.15 -28.644 -3.437 1.520 -0.284EF 0.052 140 2 -2.262 1.15 -28.644 -1.489 0.659 -0.284FG 0.260 140 2 -1.742 0.89 -17.657 -4.591 2.636 -0.284

1.804 7.177

CD 0.078 140 3 3.232 0.73 7.699 0.601 0.186 0.284DE 0.120 140 2 2.262 1.15 28.644 3.437 1.520 0.284EF 0.052 140 2 2.262 1.15 28.644 1.489 0.659 0.284FG 0.260 140 2 1.742 0.89 17.657 4.591 2.636 0.284

II GN 0.260 140 3 2.969 0.67 6.579 1.710 0.576 0.148MN 0.318 140 3 -4.111 0.93 -12.023 -3.823 0.930 0.148



LM 0.107 140 3 -4.111 0.93 -12.023 -1.286 0.313 0.148CL 0.210 140 3 -8.111 1.84 -42.316 -8.886 1.096 0.148

-2.167 7.914

7ta Iteración


AB 0.143 140 4 -12.799 1.63 -24.257 -3.469 0.271 0.107BC 0.053 140 4 -11.479 1.46 -19.829 -1.051 0.092 0.107AK 0.068 140 4 14.321 1.82 29.868 2.031 0.142 0.107KJ 0.066 140 4 13.751 1.75 27.704 1.828 0.133 0.107IJ 0.147 140 4 11.181 1.42 18.887 2.776 0.248 0.107

I HI 0.260 140 4 11.181 1.42 18.887 4.910 0.439 0.107GH 0.230 140 3 5.251 1.19 18.915 4.350 0.828 0.107CD 0.078 140 3 -3.516 0.80 -8.998 -0.702 0.200 0.197DE 0.120 140 2 -2.546 1.30 -35.655 -4.279 1.681 0.197EF 0.052 140 2 -2.546 1.30 -35.655 -1.854 0.728 0.197FG 0.260 140 2 -2.026 1.03 -23.354 -6.072 2.998 0.197

-1.529 7.760

CD 0.078 140 3 3.516 0.80 8.998 0.702 0.200 -0.197DE 0.120 140 2 2.546 1.30 35.655 4.279 1.681 -0.197EF 0.052 140 2 2.546 1.30 35.655 1.854 0.728 -0.197FG 0.260 140 2 2.026 1.03 23.354 6.072 2.998 -0.197

II GN 0.260 140 3 3.117 0.71 7.199 1.872 0.601 -0.090MN 0.318 140 3 -3.963 0.90 -11.233 -3.572 0.901 -0.090LM 0.107 140 3 -3.963 0.90 -11.233 -1.202 0.303 -0.090CL 0.210 140 3 -7.963 1.80 -40.897 -8.588 1.079 -0.090

1.416 8.490

8va Iteración


AB 0.143 140 4 -12.692 1.62 -23.884 -3.415 0.269 -0.063BC 0.053 140 4 -11.372 1.45 -19.489 -1.033 0.091 -0.063AK 0.068 140 4 14.428 1.84 30.281 2.059 0.143 -0.063KJ 0.066 140 4 13.858 1.76 28.103 1.855 0.134 -0.063IJ 0.147 140 4 11.288 1.44 19.221 2.826 0.250 -0.063

I HI 0.260 140 4 11.288 1.44 19.221 4.997 0.443 -0.063GH 0.230 140 3 5.358 1.21 19.632 4.515 0.843 -0.063CD 0.078 140 3 -3.319 0.75 -8.088 -0.631 0.190 -0.132DE 0.120 140 2 -2.349 1.20 -30.723 -3.687 1.569 -0.132EF 0.052 140 2 -2.349 1.20 -30.723 -1.598 0.680 -0.132FG 0.260 140 2 -1.829 0.93 -19.329 -5.026 2.748 -0.132

0.863 7.360

CD 0.078 140 3 3.319 0.75 8.088 0.631 0.190 0.132DE 0.120 140 2 2.349 1.20 30.723 3.687 1.569 0.132EF 0.052 140 2 2.349 1.20 30.723 1.598 0.680 0.132



FG 0.260 140 2 1.829 0.93 19.329 5.026 2.748 0.132II GN 0.260 140 3 3.027 0.69 6.818 1.773 0.586 0.069

MN 0.318 140 3 -4.053 0.92 -11.711 -3.724 0.919 0.069LM 0.107 140 3 -4.053 0.92 -11.711 -1.253 0.309 0.069CL 0.210 140 3 -8.053 1.82 -41.759 -8.769 1.089 0.069

-1.033 8.090

9na Iteración


AB 0.143 140 4 -12.756 1.62 -24.105 -3.447 0.270 0.049BC 0.053 140 4 -11.436 1.46 -19.691 -1.044 0.091 0.049AK 0.068 140 4 14.364 1.83 30.035 2.042 0.142 0.049KJ 0.066 140 4 13.794 1.76 27.865 1.839 0.133 0.049IJ 0.147 140 4 11.224 1.43 19.022 2.796 0.249 0.049

I HI 0.260 140 4 11.224 1.43 19.022 4.946 0.441 0.049GH 0.230 140 3 5.294 1.20 19.204 4.417 0.834 0.049CD 0.078 140 3 -3.451 0.78 -8.696 -0.678 0.197 0.091DE 0.120 140 2 -2.481 1.26 -34.006 -4.081 1.645 0.091EF 0.052 140 2 -2.481 1.26 -34.006 -1.768 0.713 0.091FG 0.260 140 2 -1.961 1.00 -22.000 -5.720 2.916 0.091

-0.698 7.631

CD 0.078 140 3 3.451 0.78 8.696 0.678 0.197 -0.091DE 0.120 140 2 2.481 1.26 34.006 4.081 1.645 -0.091EF 0.052 140 2 2.481 1.26 34.006 1.768 0.713 -0.091FG 0.260 140 2 1.961 1.00 22.000 5.720 2.916 -0.091

II GN 0.260 140 3 3.096 0.70 7.109 1.848 0.597 -0.042MN 0.318 140 3 -3.984 0.90 -11.344 -3.608 0.905 -0.042LM 0.107 140 3 -3.984 0.90 -11.344 -1.214 0.305 -0.042CL 0.210 140 3 -7.984 1.81 -41.098 -8.631 1.081 -0.042

0.644 8.358

10ma Iteración


AB 0.143 140 4 -12.706 1.62 -23.933 -3.422 0.269 -0.030BC 0.053 140 4 -11.386 1.45 -19.533 -1.035 0.091 -0.030AK 0.068 140 4 14.414 1.84 30.227 2.055 0.143 -0.030KJ 0.066 140 4 13.844 1.76 28.051 1.851 0.134 -0.030IJ 0.147 140 4 11.274 1.44 19.177 2.819 0.250 -0.030

I HI 0.260 140 4 11.274 1.44 19.177 4.986 0.442 -0.030GH 0.230 140 3 5.344 1.21 19.537 4.494 0.841 -0.030CD 0.078 140 3 -3.360 0.76 -8.275 -0.645 0.192 -0.062DE 0.120 140 2 -2.390 1.22 -31.731 -3.808 1.593 -0.062EF 0.052 140 2 -2.390 1.22 -31.731 -1.650 0.690 -0.062FG 0.260 140 2 -1.870 0.95 -20.146 -5.238 2.801 -0.062

0.407 7.446



CD 0.078 140 3 3.360 0.76 8.275 0.645 0.192 0.062DE 0.120 140 2 2.390 1.22 31.731 3.808 1.593 0.062EF 0.052 140 2 2.390 1.22 31.731 1.650 0.690 0.062FG 0.260 140 2 1.870 0.95 20.146 5.238 2.801 0.062

II GN 0.260 140 3 3.054 0.69 6.933 1.803 0.590 0.032MN 0.318 140 3 -4.026 0.91 -11.565 -3.678 0.913 0.032LM 0.107 140 3 -4.026 0.91 -11.565 -1.237 0.307 0.032CL 0.210 140 3 -8.026 1.82 -41.496 -8.714 1.086 0.032

-0.485 8.173

11va Iteración


AB 0.143 140 4 -12.736 1.62 -24.036 -3.437 0.270 0.023BC 0.053 140 4 -11.416 1.45 -19.627 -1.040 0.091 0.023AK 0.068 140 4 14.384 1.83 30.112 2.048 0.142 0.023KJ 0.066 140 4 13.814 1.76 27.940 1.844 0.133 0.023IJ 0.147 140 4 11.244 1.43 19.084 2.805 0.249 0.023

I HI 0.260 140 4 11.244 1.43 19.084 4.962 0.441 0.023GH 0.230 140 3 5.314 1.20 19.338 4.448 0.837 0.023CD 0.078 140 3 -3.422 0.77 -8.559 -0.668 0.195 0.042DE 0.120 140 2 -2.452 1.25 -33.263 -3.992 1.628 0.042EF 0.052 140 2 -2.452 1.25 -33.263 -1.730 0.705 0.042FG 0.260 140 2 -1.932 0.98 -21.392 -5.562 2.879 0.042

-0.321 7.572

CD 0.078 140 3 3.422 0.77 8.559 0.668 0.195 -0.042DE 0.120 140 2 2.452 1.25 33.263 3.992 1.628 -0.042EF 0.052 140 2 2.452 1.25 33.263 1.730 0.705 -0.042FG 0.260 140 2 1.932 0.98 21.392 5.562 2.879 -0.042

II GN 0.260 140 3 3.086 0.70 7.069 1.838 0.596 -0.019MN 0.318 140 3 -3.994 0.90 -11.395 -3.624 0.907 -0.019LM 0.107 140 3 -3.994 0.90 -11.395 -1.219 0.305 -0.019CL 0.210 140 3 -7.994 1.81 -41.189 -8.650 1.082 -0.019

0.296 8.297

12va Iteración


AB 0.143 140 4 -12.713 1.62 -23.956 -3.426 0.269 -0.014BC 0.053 140 4 -11.393 1.45 -19.554 -1.036 0.091 -0.014AK 0.068 140 4 14.407 1.83 30.201 2.054 0.143 -0.014KJ 0.066 140 4 13.837 1.76 28.026 1.850 0.134 -0.014IJ 0.147 140 4 11.267 1.43 19.156 2.816 0.250 -0.014

I HI 0.260 140 4 11.267 1.43 19.156 4.981 0.442 -0.014GH 0.230 140 3 5.337 1.21 19.493 4.483 0.840 -0.014CD 0.078 140 3 -3.380 0.77 -8.364 -0.652 0.193 -0.029DE 0.120 140 2 -2.410 1.23 -32.209 -3.865 1.604 -0.029EF 0.052 140 2 -2.410 1.23 -32.209 -1.675 0.695 -0.029



FG 0.260 140 2 -1.890 0.96 -20.534 -5.339 2.825 -0.0290.190 7.486

CD 0.078 140 3 3.380 0.77 8.364 0.652 0.193 0.029DE 0.120 140 2 2.410 1.23 32.209 3.865 1.604 0.029EF 0.052 140 2 2.410 1.23 32.209 1.675 0.695 0.029FG 0.260 140 2 1.890 0.96 20.534 5.339 2.825 0.029

II GN 0.260 140 3 3.067 0.69 6.987 1.817 0.592 0.015MN 0.318 140 3 -4.013 0.91 -11.497 -3.656 0.911 0.015LM 0.107 140 3 -4.013 0.91 -11.497 -1.230 0.307 0.015CL 0.210 140 3 -8.013 1.81 -41.373 -8.688 1.084 0.015

-0.227 8.211

13va Iteración


AB 0.143 140 4 -12.727 1.62 -24.004 -3.433 0.270 0.011BC 0.053 140 4 -11.407 1.45 -19.598 -1.039 0.091 0.011AK 0.068 140 4 14.393 1.83 30.148 2.050 0.142 0.011KJ 0.066 140 4 13.823 1.76 27.975 1.846 0.134 0.011IJ 0.147 140 4 11.253 1.43 19.113 2.810 0.250 0.011

I HI 0.260 140 4 11.253 1.43 19.113 4.969 0.442 0.011GH 0.230 140 3 5.323 1.20 19.400 4.462 0.838 0.011CD 0.078 140 3 -3.408 0.77 -8.496 -0.663 0.194 0.020DE 0.120 140 2 -2.438 1.24 -32.922 -3.951 1.620 0.020EF 0.052 140 2 -2.438 1.24 -32.922 -1.712 0.702 0.020FG 0.260 140 2 -1.918 0.98 -21.115 -5.490 2.862 0.020

-0.149 7.545

CD 0.078 140 3 3.408 0.77 8.496 0.663 0.194 -0.020DE 0.120 140 2 2.438 1.24 32.922 3.951 1.620 -0.020EF 0.052 140 2 2.438 1.24 32.922 1.712 0.702 -0.020FG 0.260 140 2 1.918 0.98 21.115 5.490 2.862 -0.020

II GN 0.260 140 3 3.082 0.70 7.050 1.833 0.595 -0.009MN 0.318 140 3 -3.998 0.91 -11.418 -3.631 0.908 -0.009LM 0.107 140 3 -3.998 0.91 -11.418 -1.222 0.306 -0.009CL 0.210 140 3 -7.998 1.81 -41.231 -8.658 1.083 -0.009

0.137 8.269



Qf (lt/seg)

-12.490-11.17014.63014.06011.49011.490

5.560-2.706-1.736-1.736-1.216

2.7061.7361.7361.2162.616

-4.464-4.464-8.464

Qf (lt/seg)

-13.099-11.77914.02113.45110.88110.881

4.951-3.981-3.011-3.011-2.491

3.9813.0113.0112.4913.282

-3.798-3.798-7.798



Qf (lt/seg)

-12.603-11.28314.51713.94711.37711.377

5.447-3.052-2.082-2.082-1.562

3.0522.0822.0821.5622.849

-4.231-4.231-8.231

Qf (lt/seg)

-12.893-11.57314.22713.65711.08711.087

5.157-3.658-2.688-2.688-2.168

3.6582.6882.6882.1683.165

-3.915-3.915-7.915



Qf (lt/seg)

-12.663-11.34314.45713.88711.31711.317

5.387-3.232-2.262-2.262-1.742

3.2322.2622.2621.7422.969

-4.111-4.111-8.111

Qf (lt/seg)

-12.799-11.47914.32113.75111.18111.181

5.251-3.516-2.546-2.546-2.026

3.5162.5462.5462.0263.117

-3.963



-3.963-7.963

Qf (lt/seg)

-12.692-11.37214.42813.85811.28811.288

5.358-3.319-2.349-2.349-1.829

3.3192.3492.3491.8293.027

-4.053-4.053-8.053

Qf (lt/seg)

-12.756-11.43614.36413.79411.22411.224

5.294-3.451-2.481-2.481-1.961

3.4512.4812.481



1.9613.096

-3.984-3.984-7.984

Qf (lt/seg)

-12.706-11.38614.41413.84411.27411.274

5.344-3.360-2.390-2.390-1.870

3.3602.3902.3901.8703.054

-4.026-4.026-8.026

Qf (lt/seg)

-12.736-11.41614.38413.81411.24411.244

5.314-3.422-2.452-2.452-1.932



3.4222.4522.4521.9323.086

-3.994-3.994-7.994

Qf (lt/seg)

-12.713-11.39314.40713.83711.26711.267

5.337-3.380-2.410-2.410-1.890

3.3802.4102.4101.8903.067

-4.013-4.013-8.013

Qf (lt/seg)

-12.727-11.40714.39313.82311.25311.253

5.323-3.408-2.438-2.438



-1.918

3.4082.4382.4381.9183.082

-3.998-3.998-7.998

Qf (lt/seg)

-12.716-11.39614.40413.83411.26411.264

5.334-3.389-2.419-2.419-1.899

3.3892.4192.4191.8993.073

-4.007-4.007-8.007



5.6 VERIFICACION DE PRESIONES

Circuito Tramo Pto Cota terren. P. Estática hf (m) Presión(m.s.n.m.) (m) (m)

A 3813.00 20.00AB B 3812.60 20.40 -3.433 23.83BC C 3812.90 23.53 -1.039 24.57CD D 3812.75 24.72 -0.663 25.39DE E 3814.00 24.14 -3.951 28.09EF F 3813.75 28.34 -1.712 30.05

I FG G 3811.65 32.15 -5.490 37.64GH H 3811.00 38.29 4.462 33.83HI I 3812.15 32.68 4.969 27.71IJ J 3812.00 27.86 2.810 25.05JK K 3812.25 24.80 1.846 22.95KA A 3813.00 22.20 2.050 20.15

C 3812.90 24.57CL L 3811.00 26.47 -8.658 35.13

II LM M 3811.20 34.93 -1.222 36.15MN N 3811.00 36.35 -3.631 39.98NG G 3811.65 39.33 1.833 37.50

La presión minima según normas es de 15 m y la máxima de 50 m, por lo tanto, como se aprecia en la tabla anterior, las presiones en cada nudo están dentro de los parámetros permisibles.

5.7 VERIFICACION DE VELOCIDADES

Las velocidades en cada uno de los tramos de la red no deben ser menores de 0.60 m/seg (para evitar la sedimentación de las partículas, ni mayores a 2 m/seg. (velocidades mayores podrían ocasionar problemas de vibración en las tuberías) Se recomienda emplear velocidades entre 1 m/seg a 1.20 m/seg.

Tramo Gasto Gasto Diámetro Area Velocidad(lt/seg) (m3/seg) (pulg) (m2) (m/seg)

AB 12.72 0.0127 4 0.0079 1.62BC 11.40 0.0114 4 0.0079 1.45CD 3.39 0.0034 3 0.0044 0.77DE 2.42 0.0024 2 0.0020 1.23EF 2.42 0.0024 2 0.0020 1.23FG 1.90 0.0019 2 0.0020 0.97GH 5.33 0.0053 3 0.0044 1.21HI 11.26 0.0113 4 0.0079 1.43IJ 11.26 0.0113 4 0.0079 1.43JK 13.83 0.0138 4 0.0079 1.76KA 14.40 0.0144 4 0.0079 1.83CL 8.01 0.0080 3 0.0044 1.81LM 4.01 0.0040 3 0.0044 0.91MN 4.01 0.0040 3 0.0044 0.91NG 3.07 0.0031 3 0.0044 0.69

Como se observa en la tabla anterior, las velocidades en cada tramo estan dentro de los parámetros admisibles, por tanto los diámetros asumidos son correctos y se usarán



para la red de distribución que se detallan en los planos.

Informe de PracticasEliot Pezo Z.

F.I.C

Página 17

PROYECTO "AGUA - DESAGUE"DEPARTAMENTO CUSCO PROVINCIA CUSCO DISTRITO CUSCO

SISTEMA DE DESAGUE

CALCULO HIDRAULICO Usaremos tubería PVC, n = 0.010Coeficiente de M anning 0.01

TRAMO LONG COTA DE TERRENO BUZON PEND. BUZON COTA FONDO PEND. DIAM. Y/D VELOCIDADES(m) INICIO FINAL INICIO FINAL INICIO FINAL pulg. lt/seg lt/seg

1-8 100.00 220.00 218.33 1.20 16.70 1.20 218.80 217.13 16.70 8 3.42 55.09 0.0622 0.19 0.54 1.96 1.058-7 100.00 218.33 216.67 1.20 16.60 1.20 217.13 215.47 16.60 8 6.84 54.92 0.1246 0.26 0.68 1.95 1.337-6 100.00 216.67 215.00 1.20 16.70 1.40 215.47 213.80 16.70 8 10.27 55.09 0.1865 0.32 0.77 1.96 1.506-5 120.00 214.80 212.98 1.40 15.17 1.20 213.60 211.78 15.17 8 14.38 52.50 0.2740 0.37 0.85 1.87 1.585-4 120.00 212.98 211.17 1.20 15.08 1.20 211.78 209.97 15.08 8 18.49 52.35 0.3532 0.42 0.90 1.86 1.684-3 110.00 211.17 209.50 1.20 15.18 1.20 209.97 208.30 15.18 8 22.26 52.52 0.4237 0.46 0.95 1.87 1.771-2 100.00 220.00 214.75 1.20 52.50 1.20 218.80 213.55 52.50 8 3.42 97.67 0.0351 0.14 0.44 3.47 1.532-3 100.00 214.75 209.50 1.20 52.50 1.70 213.55 208.30 52.50 8 6.84 97.67 0.0701 0.20 0.56 3.47 1.94

Long. Total 850.00

QR QO QR/QO

%o %o VV/VO VO VV



4.0 DISEÑO Y CALCULO DEL SISTEMA DE ALCANTARILLADO Usaremos tubería de C°, n = 0.013

TRAMO LONG COTA DE TERRENO COTA FONDO PEND. DIAM. Y/D VELOCIDADES(m) INICIO FINAL INICIO FINAL pulg. lt/seg lt/seg

5 - 20 96.00 3812.42 3812.37 3809.81 3809.25 5.83 8 9.5 25.04 0.38 0.43 0.92 0.89 0.8220 - 20´ 63.00 3812.37 3811.99 3809.25 3808.89 5.71 8 14.22 24.78 0.57 0.54 1.03 0.88 0.9120´ - 37 74.00 3811.99 3811.61 3808.89 3808.00 12.03 8 16.95 35.96 0.47 0.48 0.98 1.28 1.2537 - 45 126.00 3811.61 3810.10 3808.00 3806.50 11.90 8 23.81 35.77 0.67 0.59 1.06 1.27 1.3545 - 52 73.00 3810.10 3810.13 3806.50 3807.10 8.22 12 78.51 87.65 0.90 0.72 1.13 1.36 1.5452 - 54 70.00 3810.13 3810.48 3807.10 3807.80 10.00 12 68.81 96.67 0.71 0.62 1.08 1.50 1.624 - 11 36.50 3812.36 3812.43 3810.40 3811.23 22.74 8 1.35 49.45 0.03 0.13 0.41 1.76 0.72

11 - 19 60.00 3812.43 3812.20 3811.23 3810.20 17.17 8 4.42 42.97 0.10 0.24 0.64 1.53 0.9719 - 21 20.00 3812.20 3812.15 3810.20 3809.90 15.00 8 5.16 40.16 0.13 0.27 0.69 1.43 0.9821 - 27 57.00 3812.15 3812.00 3809.90 3809.50 7.02 8 14.57 27.47 0.53 0.52 1.01 0.98 0.9827 - 35 44.00 3812.00 3812.02 3809.50 3809.00 11.36 8 31.11 34.95 0.89 0.72 1.13 1.24 1.4035 - 36 20.00 3812.02 3812.01 3809.00 3808.70 15.00 10 38.48 72.81 0.53 0.52 1.01 1.64 1.6536 - 44 124.00 3812.01 3810.45 3808.70 3807.00 13.71 10 43.06 69.61 0.62 0.57 1.05 1.57 1.653 - 10 43.00 3813.71 3814.94 3812.51 3813.10 13.72 6 3.99 17.83 0.22 0.34 0.81 1.14 0.92

10 - 18 78.40 3814.94 3812.83 3813.10 3811.63 18.75 6 2.89 20.85 0.14 0.28 0.70 1.33 0.9318 - 26 55.00 3812.83 3811.90 3811.63 3810.04 28.90 6 2.03 25.88 0.08 0.21 0.58 1.65 0.9626 - 34 42.00 3811.90 3812.12 3810.04 3810.92 20.95 6 1.55 22.04 0.07 0.20 0.56 1.41 0.7934 - 34´ 70.00 3812.12 3812.06 3810.92 3809.71 17.29 6 2.58 20.02 0.13 0.27 0.69 1.28 0.8834´ - 43 70.00 3812.06 3810.43 3809.71 3807.43 32.57 6 5.16 27.48 0.19 0.32 0.77 1.75 1.3543 - 51 82.20 3810.43 3810.80 3807.43 3807.93 6.10 6 3.03 11.89 0.25 0.36 0.83 0.76 0.6351 - 53 85.00 3810.80 3811.05 3807.93 3808.45 6.12 6 3.14 11.91 0.26 0.37 0.84 0.76 0.642 - 9 46.30 3813.07 3815.40 3811.87 3814.20 50.32 6 1.71 34.15 0.05 0.17 0.50 2.18 1.089 - 17 74.50 3815.40 3814.88 3814.20 3813.04 15.57 6 2.75 19.00 0.14 0.28 0.71 1.21 0.86

17 - 25 62.40 3814.88 3814.08 3813.04 3812.05 15.86 6 2.3 19.17 0.12 0.26 0.67 1.22 0.8225 - 33 48.00 3814.08 3814.80 3812.05 3813.60 32.29 6 1.77 27.36 0.06 0.19 0.54 1.75 0.9533 - 33´ 62.50 3814.80 3814.20 3813.60 3812.43 18.72 6 2.31 20.83 0.11 0.25 0.65 1.33 0.8733´ - 42 70.00 3814.20 3812.88 3812.43 3811.37 15.14 6 4.89 18.73 0.26 0.36 0.84 1.20 1.0042 - 42´ 80.00 3812.88 3813.90 3811.37 3810.25 14.00 6 2.95 18.01 0.16 0.30 0.74 1.15 0.8542´ - 50 80.00 3813.90 3812.57 3810.25 3808.57 21.00 6 5.9 22.06 0.27 0.37 0.84 1.41 1.19

QR QO QR/QO

%o VV/VO VO VV




32 - 32´ 62.50 3814.56 3814.10 3813.00 3812.50 8.00 6 3.6 13.62 0.26 0.37 0.84 0.87 0.7332´ - 41 62.50 3814.10 3813.68 3812.50 3812.00 8.00 6 5.91 13.62 0.43 0.46 0.96 0.87 0.8341 - 41´ 75.00 3813.68 3812.82 3812.00 3810.36 21.87 6 2.77 22.52 0.12 0.26 0.68 1.44 0.9741´ - 49 75.00 3812.82 3811.97 3810.36 3809.05 17.47 6 5.54 20.12 0.28 0.37 0.85 1.28 1.09

1 - 8 48.00 3812.19 3813.60 3810.99 3812.30 27.29 6 1.77 25.15 0.07 0.20 0.56 1.61 0.908 - 16 70.00 3813.60 3814.75 3812.30 3812.65 5.00 6 2.58 10.77 0.24 0.35 0.82 0.69 0.56

16 - 24 59.00 3814.75 3814.52 3812.65 3812.36 5.00 6 2.18 10.77 0.20 0.33 0.78 0.69 0.5424 - 31 50.00 3814.52 3813.77 3812.36 3811.86 10.00 8 5.99 32.79 0.18 0.31 0.76 1.17 0.8931 - 40 125.50 3813.77 3813.39 3811.86 3811.23 5.02 8 12.1 23.23 0.52 0.51 1.00 0.83 0.8340 - 40´ 70.00 3813.39 3813.30 3811.23 3810.95 4.00 8 16.53 20.74 0.80 0.66 1.10 0.74 0.8140´ - 48 70.00 3813.30 3811.40 3810.95 3809.50 20.71 8 19.11 47.19 0.40 0.45 0.94 1.68 1.57

6 - 7 30.00 3811.60 3813.59 3810.40 3811.90 50.00 6 8.23 34.04 0.24 0.35 0.82 2.17 1.797 - 15 70.00 3813.59 3814.28 3811.90 3811.50 5.71 6 2.58 11.50 0.22 0.34 0.81 0.73 0.59

15 - 23 63.00 3814.28 3814.52 3811.50 3813.32 28.89 6 2.32 25.88 0.09 0.22 0.61 1.65 1.0123 - 30 65.00 3814.52 3814.38 3813.32 3812.22 16.92 6 2.4 19.80 0.12 0.26 0.67 1.26 0.8530 - 39 105.00 3814.38 3813.07 3812.22 3811.00 11.62 6 3.87 16.41 0.24 0.35 0.82 1.05 0.8639 - 47 110.00 3813.07 3811.40 3811.00 3809.75 11.36 6 9.41 16.23 0.58 0.55 1.03 1.04 1.0712 - 14 60.00 3811.97 3812.38 3808.50 3809.11 10.17 10 39.26 59.95 0.65 0.59 1.06 1.35 1.4314 - 22 63.00 3812.38 3812.59 3809.11 3811.04 30.63 6 12.91 26.65 0.48 0.49 0.98 1.70 1.6722 - 29 74.00 3812.59 3812.92 3811.04 3811.51 6.35 6 7.82 12.13 0.64 0.58 1.06 0.77 0.8229 - 38 101.00 3812.92 3811.80 3811.51 3810.60 9.01 6 3.73 14.45 0.26 0.36 0.84 0.92 0.7738 - 46 110.00 3811.80 3811.32 3810.60 3810.10 5.00 8 10.3 23.19 0.44 0.47 0.96 0.82 0.7913 - 13´ 70.00 3812.39 3812.10 3809.80 3810.40 8.57 6 6.82 14.09 0.48 0.49 0.98 0.90 0.8913´ - 28 70.00 3812.10 3812.41 3810.40 3811.00 8.57 6 4.24 14.09 0.30 0.39 0.87 0.90 0.7812 - 6 94.00 3811.97 3811.60 3808.50 3810.40 20.21 8 26.25 46.61 0.56 0.54 1.02 1.66 1.706 - 1 54.00 3811.60 3812.19 3810.40 3810.99 10.93 8 14.55 34.28 0.42 0.46 0.95 1.22 1.161 - 2 73.00 3812.19 3813.07 3810.99 3811.87 12.05 6 10.79 16.71 0.65 0.58 1.06 1.07 1.132 - 3 65.00 3813.07 3813.71 3811.87 3812.51 9.85 6 6.39 15.11 0.42 0.46 0.95 0.96 0.923 - 4 60.00 3813.71 3812.36 3812.51 3810.40 35.17 6 2.21 28.55 0.08 0.21 0.58 1.82 1.054 - 5 65.00 3812.36 3810.42 3810.40 3809.81 9.08 6 5.96 14.51 0.41 0.45 0.94 0.93 0.87

QR QO QR/QO

%o VV/VO VO VV




7 - 8 50.00 3813.59 3813.60 3811.90 3812.30 8.00 6 7.12 13.62 0.52 0.51 1.00 0.87 0.878 - 9 73.00 3813.60 3815.40 3812.30 3814.20 26.03 6 2.69 24.56 0.11 0.25 0.65 1.57 1.02

9 - 10 65.00 3815.40 3814.94 3814.20 3813.10 16.92 6 2.4 19.80 0.12 0.26 0.67 1.26 0.8510 - 11 60.00 3814.94 3812.43 3813.10 3811.23 31.17 6 2.21 26.88 0.08 0.21 0.59 1.72 1.0113 - 14 65.00 3812.39 3812.38 3809.80 3809.11 10.62 6 9.22 15.69 0.59 0.55 1.03 1.00 1.0414 - 15 77.00 3812.38 3814.28 3809.11 3811.50 31.04 6 14.92 26.82 0.56 0.53 1.02 1.71 1.7515 - 16 50.00 3814.28 3814.75 3811.50 3812.65 23.00 6 7.18 23.09 0.31 0.39 0.88 1.47 1.2916 - 17 70.00 3814.75 3814.88 3812.65 3813.04 5.57 6 5.33 11.36 0.47 0.48 0.98 0.73 0.7117 - 18 60.00 3814.88 3812.83 3813.04 3811.63 23.50 6 2.21 23.34 0.09 0.23 0.62 1.49 0.9218 - 21 60.00 3812.83 3812.15 3811.63 3809.90 28.80 6 7.31 25.84 0.28 0.38 0.86 1.65 1.4122 - 23 75.00 3812.59 3814.52 3811.04 3813.32 30.40 6 2.77 26.55 0.10 0.24 0.64 1.69 1.0923 - 24 53.00 3814.52 3814.52 3813.32 3812.36 18.11 6 1.96 20.49 0.10 0.23 0.62 1.31 0.8124 - 25 75.00 3814.52 3814.08 3812.36 3812.05 5.00 6 2.77 10.77 0.26 0.36 0.83 0.69 0.6025 - 26 60.00 3814.08 3811.90 3812.05 3810.04 33.50 6 9.05 27.87 0.32 0.40 0.89 1.78 1.5826 - 27 62.00 3811.90 3812.00 3810.04 3809.50 8.71 8 14.92 30.60 0.49 0.49 0.99 1.09 1.0728 - 29 45.00 3812.41 3812.92 3811.00 3811.51 11.33 6 1.66 16.21 0.10 0.24 0.64 1.03 0.6629 - 30 73.00 3812.92 3814.38 3811.51 3812.22 9.73 6 5.09 15.02 0.34 0.41 0.90 0.96 0.8638 - 39 68.00 3811.80 3813.07 3810.60 3811.00 5.88 6 2.51 11.67 0.21 0.34 0.80 0.75 0.5939 - 40 40.00 3813.07 3813.39 3811.00 3811.23 5.75 6 1.48 11.55 0.13 0.27 0.69 0.74 0.5140 - 41 50.00 3813.39 3813.68 3811.23 3812.00 15.40 6 1.85 18.89 0.10 0.23 0.63 1.21 0.7641 - 42 70.00 3813.68 3812.88 3812.00 3811.37 9.00 6 8.49 14.44 0.59 0.55 1.03 0.92 0.9542 - 43 53.00 3812.88 3810.43 3811.37 3807.43 74.30 6 15.34 41.50 0.37 0.43 0.92 2.65 2.4343 - 44 60.00 3810.43 3810.45 3807.43 3807.00 7.17 10 25.74 50.34 0.51 0.51 1.00 1.14 1.1344 - 45 65.00 3810.45 3810.10 3807.00 3806.50 7.69 14 71.2 127.88 0.56 0.53 1.02 1.45 1.4846 - 47 70.00 3811.32 3811.40 3810.10 3809.75 5.00 8 12.88 23.19 0.56 0.53 1.02 0.82 0.8447 - 48 45.00 3811.40 3811.40 3809.75 3809.50 5.55 10 23.95 44.29 0.54 0.52 1.01 1.00 1.0148 - 49 90.00 3811.40 3811.97 3809.50 3809.05 5.00 12 46.38 68.36 0.68 0.60 1.07 1.06 1.1449 - 50 93.00 3811.97 3812.67 3809.05 3808.57 5.16 14 55.35 104.75 0.53 0.52 1.01 1.19 1.2050 - 53 60.00 3812.67 3811.05 3808.57 3808.45 2.00 16 63.46 93.11 0.68 0.60 1.07 0.81 0.8653 - 54 75.00 3811.05 3810.48 3808.45 3807.80 8.67 12 66.23 90.02 0.74 0.63 1.09 1.40 1.52

QR QO QR/QO

%o VV/VO VO VV




31 - 32 40.00 3813.77 3814.56 3811.86 3813.00 28.50 6 1.48 25.70 0.06 0.18 0.52 1.64 0.8632 - 33 35.00 3814.56 3814.80 3813.00 3813.60 17.14 6 1.29 19.93 0.06 0.19 0.54 1.27 0.6933 - 34 60.00 3814.80 3812.12 3813.60 3810.92 44.67 6 2.21 32.18 0.07 0.20 0.55 2.05 1.1434 - 35 60.00 3812.12 3812.02 3810.92 3809.00 32.00 6 4.42 27.24 0.16 0.30 0.74 1.74 1.2836 - 37 60.00 3812.01 3811.61 3808.70 3808.00 11.67 6 2.21 16.45 0.13 0.27 0.70 1.05 0.7351 - 52 105.00 3810.80 3810.13 3807.93 3807.10 7.90 6 7.01 13.53 0.52 0.51 1.00 0.86 0.8719 - 20 65.00 3812.20 3812.37 3810.20 3809.25 14.62 6 2.4 18.41 0.13 0.27 0.69 1.18 0.81Emisor 1 20.00 14 173.52 206.23 0.84 0.69 1.11 2.34 2.61Emisor 2 20.00 10 65.31 84.08 0.78 0.65 1.10 1.90 2.08

TUB. CONCRETO n=0.013

QR QO QR/QO

%o VV/VO VO VV

TRAMO LONG terreno COTA DE TERRENO BUZON PEND.(m) ini fin INICIO FINAL INICIO

1 - 4 #REF! 3500.00 57.00 57.45 3557.00 3557.45 1.00 25.006 - 5 #REF! 3500.00 64.00 60.35 3564.00 3560.355 - 4 #REF! 3500.00 60.35 57.45 3560.35 3557.454 - 9 #REF! 3500.00 57.45 57.10 3557.45 3557.10

11 - 10 #REF! 3500.00 66.70 61.20 3566.70 3561.2010 - 9 #REF! 3500.00 61.20 57.10 3561.20 3557.109 - 14 #REF! 3500.00 57.10 56.05 3557.10 3556.05

15 - 14 #REF! 3500.00 59.90 56.05 3559.90 3556.0514 - 18 #REF! 3500.00 56.05 55.20 3556.05 3555.2010 - 15 #REF! 3500.00 61.20 59.90 3561.20 3559.9015 - 19 #REF! 3500.00 59.90 58.00 3559.90 3558.0020 - 19 #REF! 3500.00 58.70 58.00 3558.70 3558.0019 - 18 #REF! 3500.00 58.00 55.20 3558.00 3555.2018 - 23 #REF! 3500.00 55.20 53.50 3555.20 3553.5025 - 24 #REF! 3500.00 56.50 54.70 3556.50 3554.7024 - 23 #REF! 3500.00 54.70 53.50 3554.70 3553.5023 - 28 #REF! 3500.00 53.50 51.00 3553.50 3551.0029 - 28 #REF! 3500.00 51.50 51.00 3551.50 3551.00

4 - 3 #REF! 3500.00 57.45 53.90 3557.45 3553.903 - 2 #REF! 3500.00 53.90 52.15 3553.90 3552.152 - 7 #REF! 3500.00 52.15 51.55 3552.15 3551.559 - 8 #REF! 3500.00 57.10 54.70 3557.10 3554.708 - 7 #REF! 3500.00 54.70 51.55 3554.70 3551.55

7 - 12 #REF! 3500.00 51.55 51.05 3551.55 3551.0513 - 12 #REF! 3500.00 54.05 51.05 3554.05 3551.0512 - 16 #REF! 3500.00 51.05 51.30 3551.05 3551.308 - 13 #REF! 3500.00 54.70 54.05 3554.70 3554.05

13 - 17 #REF! 3500.00 54.05 53.65 3554.05 3553.6518 - 17 #REF! 3500.00 55.20 53.65 3555.20 3553.6517 - 16 #REF! 3500.00 53.65 51.30 3553.65 3551.3016 - 21 #REF! 3500.00 51.30 50.35 3551.30 3550.3523 - 22 #REF! 3500.00 53.50 52.00 3553.50 3552.0022 - 21 #REF! 3500.00 52.00 50.35 3552.00 3550.3521 - 26 #REF! 3500.00 50.35 49.20 3550.35 3549.2026 - 27 #REF! 3500.00 51.00 50.50 3551.00 3550.5027 - 28 #REF! 3500.00 50.50 49.20 3550.50 3549.2028 - 30 #REF! 3500.00 51.00 47.75 3551.00 3547.7530 - 31 #REF! 3500.00 47.75 43.85 3547.75 3543.8531 - 32 #REF! 3500.00 43.85 42.45 3543.85 3542.4532 - 33 #REF! 3500.00 42.45 41.40 3542.45 3541.4033 - 34 #REF! 3500.00 41.40 40.75 3541.40 3540.7534 - 35 #REF! 3500.00 40.75 40.35 3540.75 3540.3535 - 36 #REF! 3500.00 40.35 40.10 3540.35 3540.1041 - 42 #REF! 3500.00 41.55 41.05 3541.55 3541.0542 - 43 #REF! 3500.00 41.05 40.70 3541.05 3540.7043 - 44 #REF! 3500.00 40.70 40.00 3540.70 3540.0044 - 45 #REF! 3500.00 40.00 40.05 3540.00 3540.0545 - 46 #REF! 3500.00 40.05 40.10 3540.05 3540.1037 - 39 #REF! 3500.00 40.95 40.50 3540.95 3540.5039 - 46 #REF! 3500.00 40.50 40.10 3540.50 3540.1046 - 47 #REF! 3500.00 40.10 40.10 3540.10 3540.1038 - 40 #REF! 3500.00 40.95 40.50 3540.95 3540.50

%o

40 - 47 #REF! 3500.00 40.50 40.10 3540.50 3540.1047 - 36 #REF! 3500.00 40.10 40.10 3540.10 3540.1036 - 48 #REF! 3500.00 40.10 39.70 3540.10 3539.7048 - 49 #REF! 3500.00 39.70 39.55 3539.70 3539.5549 - 50 #REF! 3500.00 39.55 39.45 3539.55 3539.4550 - 51 #REF! 3500.00 39.45 39.35 3539.45 3539.3551 - 52 #REF! 3500.00 39.35 39.25 3539.35 3539.2552 - 53 #REF! 3500.00 39.25 39.15 3539.25 3539.1553 - 54 #REF! 3500.00 39.15 38.90 3539.15 3538.9054 - 55 #REF! 3500.00 38.90 38.65 3538.90 3538.6556 - 59 #REF! 3500.00 41.30 41.20 3541.30 3541.2057 - 58 #REF! 3500.00 40.65 40.85 3540.65 3540.8558 - 59 #REF! 3500.00 40.85 41.20 3540.85 3541.2059 - 60 #REF! 3500.00 41.20 40.85 3541.20 3540.8560 - 62 #REF! 3500.00 40.85 40.75 3540.85 3540.7561 - 62 #REF! 3500.00 41.10 40.75 3541.10 3540.7562 - 63 #REF! 3500.00 40.75 40.50 3540.75 3540.5063 - 64 #REF! 3500.00 40.50 40.15 3540.50 3540.1564 - 65 #REF! 3500.00 40.15 39.35 3540.15 3539.3565 - 66 #REF! 3500.00 39.35 39.20 3539.35 3539.2066 - 67 #REF! 3500.00 39.20 39.10 3539.20 3539.1067 - 55 #REF! 3500.00 39.10 38.65 3539.10 3538.6555 - 68 #REF! 3500.00 38.65 38.20 3538.65 3538.2068 - 69 #REF! 3500.00 38.20 37.70 3538.20 3537.7069 - 70 #REF! 3500.00 37.70 37.20 3537.70 3537.2071 - 72 #REF! 3500.00 38.70 38.45 3538.70 3538.4572 - 73 #REF! 3500.00 38.45 38.10 3538.45 3538.1073 - 74 #REF! 3500.00 38.10 37.70 3538.10 3537.7074 - 70 #REF! 3500.00 37.70 37.20 3537.70 3537.2070 - 75 #REF! 3500.00 37.20 36.75 3537.20 3536.7575 - 76 #REF! 3500.00 36.75 35.80 3536.75 3535.8076 - 77 #REF! 3500.00 35.80 35.50 3535.80 3535.5077 - 78 #REF! 3500.00 35.50 34.95 3535.50 3534.9578 - 79 #REF! 3500.00 34.95 34.35 3534.95 3534.3580 - 81 #REF! 3500.00 36.85 36.55 3536.85 3536.5581 - 82 #REF! 3500.00 36.55 36.25 3536.55 3536.2582 - 83 #REF! 3500.00 36.25 35.70 3536.25 3535.7083 - 79 #REF! 3500.00 37.70 34.35 3537.70 3534.3579 - 84 #REF! 3500.00 34.35 33.75 3534.35 3533.7584 - 85 #REF! 3500.00 33.75 33.50 3533.75 3533.5085 - 86 #REF! 3500.00 33.50 33.25 3533.50 3533.2586 - 87 #REF! 3500.00 33.25 33.00 3533.25 3533.0087 - 88 #REF! 3500.00 33.00 32.75 3533.00 3532.7588 - 89 #REF! 3500.00 32.75 32.50 3532.75 3532.5089 - 90 #REF! 3500.00 32.50 32.35 3532.50 3532.3590 - 91 #REF! 3500.00 32.35 32.20 3532.35 3532.2091 - 92 #REF! 3500.00 32.20 32.10 3532.20 3532.1092 - 93 #REF! 3500.00 32.10 31.10 3532.10 3531.1093 - 94 #REF! 3500.00 31.10 30.70 3531.10 3530.7094 - 95 #REF! 3500.00 30.70 30.35 3530.70 3530.3595 - 99 #REF! 3500.00 30.35 30.00 3530.35 3530.0096 - 97 #REF! 3500.00 31.20 30.65 3531.20 3530.6597 - 98 #REF! 3500.00 30.65 30.10 3530.65 3530.1098 - 99 #REF! 3500.00 30.10 30.00 3530.10 3530.00

99 - 105 #REF! 3500.00 30.00 30.00 3530.00 3530.00100 - 96 #REF! 3500.00 32.20 31.20 3532.20 3531.20

100 - 101 #REF! 3500.00 31.20 30.80 3531.20 3530.80101 - 97 #REF! 3500.00 30.80 30.65 3530.80 3530.65

101 - 102 #REF! 3500.00 30.65 29.90 3530.65 3529.9098 - 102 #REF! 3500.00 30.10 29.90 3530.10 3529.90

102 - 104 #REF! 3500.00 29.90 29.90 3529.90 3529.90103 - 104 #REF! 3500.00 32.40 29.90 3532.40 3529.90104 - 105 #REF! 3500.00 29.90 30.00 3529.90 3530.00105 - 108 #REF! 3500.00 30.00 29.40 3530.00 3529.40104 - 107 #REF! 3500.00 29.90 29.90 3529.90 3529.90106 - 107 #REF! 3500.00 32.75 29.90 3532.75 3529.90107 - 108 #REF! 3500.00 29.90 29.40 3529.90 3529.40108 - 110 #REF! 3500.00 29.40 29.40 3529.40 3529.40110 - 113 #REF! 3500.00 29.40 29.30 3529.40 3529.30107 - 109 #REF! 3500.00 29.90 29.85 3529.90 3529.85109 - 111 #REF! 3500.00 29.85 29.80 3529.85 3529.80111 - 112 #REF! 3500.00 29.80 29.55 3529.80 3529.55112 - 113 #REF! 3500.00 29.55 29.30 3529.55 3529.30113 - 116 #REF! 3500.00 29.30 29.25 3529.30 3529.25115 - 112 #REF! 3500.00 29.70 29.55 3529.70 3529.55114 - 115 #REF! 3500.00 30.80 29.70 3530.80 3529.70115 - 116 #REF! 3500.00 29.70 29.25 3529.70 3529.25116 - 117 #REF! 3500.00 29.25 29.45 3529.25 3529.45117 - 118 #REF! 3500.00 29.45 27.50 3529.45 3527.50118 - plan #REF! 3500.00 27.50 27.50 3527.50 3527.50

#REF!

BUZON Y/D 0 COTA FONDO PEND.FINAL VV INICIO FINAL

#REF! #REF! #REF! 25.00#REF! #REF!#REF! #REF!#REF! #REF! 69.96214#REF! #REF!#REF! #REF!#REF! #REF!#REF! #REF!#REF! #REF!#REF! #REF!

#REF!

%o

desagues hojas de calculo

Documents