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.

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

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

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!

desagues hojas de calculo

Documents

hojas-calculo - caballete

"hojas de calculo"

hojas de calculo yoleyma

hojas de calculo (1)2

hojas de calculo tic

hojas de calculo trabajo

hojas de calculo natzil

hojas calculo planta piloto

hojas de calculo

hojas de calculo css

5. hojas de calculo

hojas de calculo educativa

excel hojas de calculo

modulo -hojas de calculo

hojas electronicas de calculo

hojas de calculo diapositiva

hojas de calculo

hojas de calculo-rosy

hojas de calculo albañileria