alcantarillado entrega 2 sfkffkgfkgk).xlsx

download alcantarillado entrega 2 sfkffkgfkgk).xlsx

of 46

Transcript of alcantarillado entrega 2 sfkffkgfkgk).xlsx

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    1/46

    Poblacion total De Diseo (hab)rea Total Residencial De Diseo (Ha)

    Densidad de poblacin (Hab/ha)Dotacin Neta (L/Hab-dia):Contribcin !n"ltracin (L/s-Ha):Contribcin Cone#iones $rradas (L/s-Ha):Contribocin Co%ercial (L/s-Ha)Contribocin !nstitcional (L/s-Ha)Contribocin !ndstrial (L/s-Ha)&actor RetornoCoe"ciente de 'annin

    Tbera

    *bicacin Tra%o + Propia Res ,tras reas + Total Res PoblacinD$ + (Ha) (Ha) (Ha) (Hab)

    . 0102 0102 32134.034 4 0105 0105 341.456

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    2/46

    .76773701.

    5261347732.017

    7015.015.

    0101

    01006P8C +lcantarillado

    +co%ercial +rea !nst +rea indst 9do%estico 9co%ercial 9 inst(Ha) (Ha) (Ha)

    010356. 0 0010736.625

    0

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    3/46

    9indstrial &%aorac 9%a# Horar 9 in"ltra 9cone# erra 9prop Tra%(L/;) (L/;) (L/;) (L/;)

    0 5 010.403 0100 010 013234030 0100 010 010

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    4/46

    9dise tra%o 9dise Real Lon Dia% No% Dia% !ntern C1T1;(L/;) (L/;) (%) (%%) (%%) (%)

    31. 31. .2127 .715.31. 31. .5127

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    5/46

    CT! PR,& CC; $

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    6/46

    P$ND(%)01237643

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    7/46

    Poblacion total De Diseo (hab)rea Total Residencial De Diseo (Ha)

    Densidad de poblacin (Hab/ha)Dotacin Neta (L/Hab-dia):Contribcin !n"ltracin (L/s-Ha):Contribcin Cone#iones $rradas (L/s-Ha):Contribocin Co%ercial (L/s-Ha)Contribocin !nstitcional (L/s-Ha)Contribocin !ndstrial (L/s-Ha)&actor RetornoCoe"ciente de 'annin

    Tbera P8C +lca

    *bicacin Tra%o + Propia Res ,tras re+ Total Res Poblacin +co%erc(Ha) (Ha) (Ha) (Hab) (Ha)

    0102 0102 32134.034-5 0105 0105 341.456

    0102 0102 32134.0340105 0105 341.456

    2-5 0104 0104 201452040.5-7 01076 01076 371425356

    01025 01025 35162725.7-3 0104 0104 2212436067-0 010.2 010.2 7217462

    01065 01065 53172..360-44 0103 0103 4160.23

    01006 01006 216.70.01056 01056 731.703565

    47-45 01024 01024 3175660445-4 01052 01052 31.0764-44 010. 010. 7316.622344-4 010 010 215523.4-4. 0102 0102 3.130477

    0104 0104 217067554.-42 0105 0105 341.456

    010 010 2414400.342-43 0105 0105 341.456

    010 010 215523.43-6 01054 01054 7015344.66-40 017 017 4124255540- 0133 0133 51230.265

    013 013 521634770102 0102 32134.034

    5- 010 010 712.37022

    .-

    .-23-2

    46-3

    46-0

    46-440-47

    4-4.

    45-42

    47-43

    6-47-5

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    8/46

    -4 0132. 0132. .61760704.0104 0104 2517..52010 010 712.370220133 0133 51230.265

    .-4 010 010 2.1325624.6-7 013. 013. .14002

    7-3 0136 0136 2155.544755-5 013 013 401764..5-54 01. 01. 7361.622354-5 017 017 41242555.0-5 0123 0123 32135455-.6 0104 0104 201452040..6-. 0177. 0177. 61340375.-0 013 013 4610.230-3 013 013 4610.233-6. 0127 0127 3501.264.3

    4-6 013 013 521634776.-6 01756 01756 30612.45656-64 0136 0136 16.64365-64 0125 0125 35612725.64-6 0135 0135 315353366-6 0174 0174 373173..2.6-332 0132 0132 .4106574265-.7 0176 0176 374125356.7-.. 0176 0176 37412535667-.. 015. 015. 36412507...-.4 013 013 401764..67-62 0176 0176 374125356.-.4 017.. 017.. 333166735.4-6. 015 015 730106746.-65 015 015 707107.67.4-62 015 015 34.145662-65 015 015 707107.6765-66 01257 01257 3.01703.667-303 0152 0152 31.076307-303 015 015 34.145630-306 015 015 34.1456303-2 013 013 4610.232-306 013 013 4610.23306-333 0157 0157 3515.572

    0 00 00 00 00 00 00 00 0

    5-.2-.-.

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    9/46

    0 00 00 00 00 00 0

    0 00 00 00 0

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    10/46

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    11/46

    010453374 0 0 0 5 0176. 01074010577043 0 0 0 5 013432 0103.

    01027626 0 0 0 5 01323 010370100234 0 0 0 5 01753 0107701052634 0 0 0 5 0134.4 01030107254.3 0 0 0 5 012765 0102

    0130520. 0 0 0 5 015347 010201042425 0 0 0 5 012.32 01027017455634 0 0 0 5 31060 013

    0130646 0 0 0 5 015267 01050134035. 0 0 0 5 0104 01070102575 0 0 0 5 013.24 0103501372.7374 0 0 0 5 015653 0105.01063403 0 0 0 5 0126.2 010201063403 0 0 0 5 0126.2 01020134.456 0 0 0 5 014074 0105

    010.5625 0 0 0 5 01736 0107013264 0 0 0 5 01.5 010560130643 0 0 0 5 01525 01026013.52 0 0 0 5 0145 0100104.4 0 0 0 5 012045 0107013.3.3657 0 0 0 5 0103 010..701043245 0 0 0 5 017.. 0107013.670.36 0 0 0 5 012 010.013.670.36 0 0 0 5 012 010.01754057.2 0 0 0 5 0167 010601042425 0 0 0 5 012.32 01027013.670.36 0 0 0 5 012 010.0132666044 0 0 0 5 01.00 010.30172.3702 0 0 0 5 310.50 0106017.7.2724 0 0 0 5 310303 0106701736.622 0 0 0 5 0145 010017.7.2724 0 0 0 5 310303 0106701344.727 0 0 0 5 014.30 0105017207 0 0 0 5 016552 01001736.622 0 0 0 5 0145 01001736.622 0 0 0 5 0145 01001063403 0 0 0 5 0126.2 010201063403 0 0 0 5 0126.2 010201720.4202 0 0 0 5 016772 0105

    0 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 0

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    12/46

    0 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 0

    0 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 00 0 0 0 5 010000 0

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    13/46

    '+N*+L9cone# erra 9prop Tra% 9dise tra%o 9dise Real Lon Dia% No%(L/;) (L/;) (L/;) (L/;) (%) (%%)

    010 01323403 31. 01323403 .2127 700010 0134.2425 31. 0120443.2. 5610. 700010 01323403 31. 01323403 57144 700010 0134.2425 31. 0134.2425 5714 7000135 0120443.2. 31. 013. .6107 700

    010. 013745704 31. 310.3 215 700010 013565345 31. 01356 21. 700013.7 012250606. 31. 0152..74 173 7000130 01727655 31. 3144 515 700013 015327344 31. 015327344 47157 7000102 0104637 31. 7170 24152 7000103 01026.25 31. 01026.25 7512 7000106 0173.5004. 31. 0173.5004. 20126 70001045 013756.5 31. 01240.076 2.125 700010 013607.3. 31. 01.404.55 2216 700

    013 0173646 31. 0144737 50165 7000134 012573 31. 21522 416 70001047 013.7.23 31. 2123 251 70001345 01275577 31. 01275577 10 700010 0134.2425 31. 5136 2.1. 700

    01347 01240.076 31. 01240.076 6313 700010 0134.2425 31. 51452 25152 700

    0134 012573 31. 012573 61 70001065 01700 31. .1224 2517 700

    015 0146347 31. 173 616 7000177 0152..74 31. 166 44146 700017 01526.622 31. 01526.622 4.137 700

    010 01323403 31. 01323403 015 7000137 01724.07 31. 0126.2507 .21.6 700

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    14/46

    0174 01.625.305 31. 41 43162 700013. 0125777 31. 0125777 10 7000137 01724.07 31. 01724.07 71 7000177 0152..74 31. 0152..74 1 700013 012.3456 31. 3155377 5.17. 700012 01.626005 31. 01.626005 330 700

    012 012.77426 31. 315653452 .61245 7000127 014022562 31. 014022562 461.4 700

    3 713646 713646 71603233 330 700015 0146347 31. 2140.076 ..17 700

    017 312742657 31. 312742657 4216 7000135 0120443.2. 31. .15.06.4 6124 700015. 01660.0 31. 155005745 .216. 700012 0146370. 31. 4172323046 .516. 700012 0146370. 31. 1077.45 5134 700015 315064 31. 3016726. 6412 700

    017 01526.622 31. 301030 330 7000156 31065.454 31. 31065.454 6613 7000126 0140265. 31. 33164. 3051 70001 315653452 31. 315653452 6412 700017 013.52043 31. 3510. 0123 700

    01..7 31732744 31. 31732744 651. 700017 01.4354324 31. 3.16 41. 70001. 31745704. 31. 31745704. .715 70001. 31745704. 31. 71.565356 .4106 700016 316434037 316434037 316434037 30.1. 700

    0127 014022562 31. .172333 712 70001. 31745704. 31. 31745704. 46124 70001.3 313706204 31. 313706204 4213 700016 713300532 713300532 51.0.236. 330 7000167 710773765 710773765 3415.3.5 30.17. 70001 314.24255 314.24255 1330564.3 612 700

    0167 710773765 710773765 3315045544 330 700015 31.0250676 31.0250676 201274325 41 7.001 31607.35. 31607.35. 31607.35. 302136 70001 314.24255 314.24255 314.24255 330 70001 314.24255 314.24255 314.24255 301 700

    012 0146370. 31. 51526676. 215 700012 0146370. 31. .172333 54 700015 31576737 31576737 12.7. 330 700

    0 0 31. 7000 0 31. 7000 0 31. 7000 0 31. 7000 0 31. 7000 0 31. 7000 0 31. 7000 0 31. 700

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    15/46

    0 0 31. 7000 0 31. 7000 0 31. 7000 0 31.0 0 31.0 0 31.

    0 0 31.0 0 31.0 0 31.0 0 31.

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    16/46

    Dia% !ntern C1T1; CT! PR,& CC; $

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    17/46

    3. .5132 .5132 51 0102 .10.3. .5175 .216 3 0 016.3. .5132 .216 3 0 016.3. .214 .216 3 0 31.3. .216 .5132 31. 010 31.3. .5162 .51.6 3 0 3

    3. .51.6 .5135 3 0102 0143. .1.5 .122 3 0 310.3. .122 ..15 310. 0102 33. ..15 ..15. 3 0102 310.3. ..1 ..15. 3 0 33. ..15. .5162 310. 0102 33. .5162 .51 3 0102 33. .51 .5172 3 0102 33. .5172 .5135 3 0102 3173. .5135 .216 317 0102 313

    3. .5132 .21 .10. 0102 5163. .216 .21 3 0 3173. .21 .2132 516 0102 513. .2125 .2132 3 0 3133. .2132 .716 51 0102 516.3. .2173 .716 3 0 3133. .716 .716 516. 0102 51673. ..15. ..155 3 0 313.3. ..155 ..13 313. 0102 310.3. ..175 ..13 3 0 3173. ..13 .51.3 317 0102 33. ..175 .5153 3 0 33. .51 .51.3 3 0 3173. .51.3 .216 317 0102 33. .216 .2125 313 0102 3133. .51.3 .5153 317 0102 31573. .5153 .2125 3157 0102 377. .2125 .2173 313 0102 3123. ..175 .516 3 0 33. .51. .516 3 0 3173. .51 .5122 3 0 33. .516 .51.6 317 0102 317.3. .51.6 .5122 317. 0102 3173. .5122 .21 317 0102 33.3.3.3.3.3.3.3.

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    18/46

    3.3.3.

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    19/46

    C=; C=! P$ND >elocidad 9 ( cadal) ?/9(%) (%) (%) %/s L/s

    .317. .3104 01224.55 0123035 7712.67375 0100.63.

    .3105 .01 01273644 0134.65 7316467. 0103500056

    .317. .3106 0124506266 014.225 721.24757 0100.076.

    .313 .312. 010662 31334327. 201070.. 0100...7

    .310 .012 0126653 016240625 7510723275 0107.37.

    .01. .0145 01203.2.06 0143535 73132360 010564332

    .313 .313 01.3477 3102305403 74143502 0100.267.

    .31. .3123 015044622 01635777. 751.45.50 0103646

    .0143 .01.3 01520767 01626305. 7.17522.4 0104000.35

    .313 .31. 0125.70.3 015335 7713075 010374..

    .015 .0125 01245023.2 014..02. 721.2.72 010600.73

    .313 .3143 01533.772 0163262.6 751.32 01003077.71 .712 0147267725 317300 271457505 0100.45

    .712. .7172 01226...4 0125724 77157556. 0103.3.717 .7102 01.0354562 31032300. 7417.3566 01070066

    .7 .317 0152643 0165674664 7.1.35 010202423.0123 .0105 0125770.27 01245344 771.334737 013.7.076.0103 5616 0125703 01523303 771207. 01307342.717. .3165 012032033 01.632..4 721062404 0103.0.4561 5614. 01206.63. 01466365 73157327 0136..452.717 .7 012042.5. 0146263. 73122523 0103447002.0107 56163 0123657 010670425 7314.3642 01730343.712 .7105 012.37264 015554 77106557 010363561 5614 0125705. 0157405 771.544 0172..5656142 5615 0125025.2 012.7053 7715.0565 017463556124 56132 0120.776. 0146.36 73124.3552 0123257075.712 .7102 012.657567 01.765 7210433.6 010360.2

    .2126 .2136 0122046477 0172502 7713222026 0100.6.2.

    .213 .716 0122.2. 01764300 7712073. 010344267

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    20/46

    5613 51 0120..763 014634.05 731775.05 01237.6.7.2105 .712 01234677 0104322 731647665 0103.0207.7162 .712 0125632. 015..2 7714235.5 010330232.71. .717 01236260. 010606. 73145.267 01077722

    .7177 .710 0120626774 01462327 73150.7242 01042055

    .2142 .2126 0120606063 0146.62053 731265303 010207006

    .212 .213 0122544 012060032 771225056 010634

    ..125 ..10 01274.27 0132.673 731664407 0102364244

    ..10. .5155 01..5.5.5. 3103057 71.47062 013037573

    .5153 .517 01205254 0120723. 72142.. 013.674242

    .515 .517. 0123372326 01463 7315476 010254.5.

    .5134 .2142 015..427 01642.2 7100724 01706762..214 .215 01..00 3104.3362 716566 0177552063

    .2124 .2102 01345523 3137374.4 201740.623 017264.2 .7145 01206 0146.75 73123..5 0124.06554

    .7143 .7126 0127464. 01730326 77106074 0156563

    51. 51. 0123337 0104..05. 7314043.6 015333407.7156 .717 01767264 014453264 701060.0 010.703.35154 5132 0127546626 013.6056 731623423 01.5.6604.7135 .312 01234.7.2. 010436. 73154..3 010675513 5412 012236475 01200645 7712327742 012377047

    .7103 .31 012563064 015.542 7714237357 010.22456541 541.4 01200.2.6 014566363 73130040. 014.70474

    .517. .5106 012070063 014446036 73134.666 010070373

    .510 .21. 0124507. 01727 7212267 013067507

    .5105 .214 012770634 01375664 731503725 01060.4.05

    .214 .2123 01.445637 3107426 7617.23526 0134726

    .5105 .2173 3105.42.3 315500.65 2612.754 010272657.215 .2133 01267235 016037773 75177.753 0105747.7

    .210 .7156 01.2225 3105523 7132.02 013.645

    .712 .7105 0120502 01462643 7317367372 01775..52

    .210 .7146 012006.54. 014.2564 73133325 012534436

    .7143 .7106 01.222 310450654 7163356. 012655776

    .7103 .3143 012575.4. 016.5.5. 2416..076. 014666.5

    .5105 .2156 01.276642 3105.37. 71065672 0104706

    .21. .2176 0127474742 013600.2 77103.04 010464327.21 .2132 0152740. 016533. 7.1237544 01065.27

    .217 .2135 01233.023 0146654.25 73156006 01700346

    .2133 .7162 01276447 01.640.6 7213.337 01736.47.716 .715 015 0160.555 75122.5. 01220247-017 -017 @D!8/0A @D!8/0A @D!8/0A @D!8/0A-017 -017 @D!8/0A @D!8/0A @D!8/0A @D!8/0A-017 -017 @D!8/0A @D!8/0A @D!8/0A @D!8/0A-017 -017 @D!8/0A @D!8/0A @D!8/0A @D!8/0A-017 -017 @D!8/0A @D!8/0A @D!8/0A @D!8/0A-017 -017 @D!8/0A @D!8/0A @D!8/0A @D!8/0A-017 -017 @D!8/0A @D!8/0A @D!8/0A @D!8/0A-017 -017 @D!8/0A @D!8/0A @D!8/0A @D!8/0A

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    21/46

    -017 -017 @D!8/0A @D!8/0A @D!8/0A @D!8/0A-017 -017 @D!8/0A @D!8/0A @D!8/0A @D!8/0A

    0 0 @D!8/0A @D!8/0A @D!8/0A @D!8/0A0 0 @D!8/0A @D!8/0A @D!8/0A @D!8/0A

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    22/46

    >/8 8R$+L h/D +n + Rh/D &1 Tracti>a1%/s rad B/%7

    01750.554 017000402 010.33266 01634.272 010.7447 0102.35670120622233 017.76763. 013042437 3122.263 0100.352. 0100233.301726446 01704.0.44 010520736 0125.65 0102.77 010526.01750024 0173..37 010.335472 01637.75 010.4755 010555360124.7 01276.4 013525764 31.4070665 714247$-00 316425$-00

    015547.7 012.3042 01363302 31466.602017252.427 017532253 0105.2405 01205.01253.2253 01237724. 0137627574 315435760154752 015.477506 01733375 3160662..7012257405 01733430 01375..602 315574664

    01.2727.4 0150257 01723..24. 7100062013557 013.373003 -0102757627 @8+L*$A01752063 0120753. 010.. 016456.23

    0127.323 0174726 013362.537 3153065012543243 012.362335 0132762733 3156700126774 01265.74 013.207.4 31244350104047. 01.0307 0120623772 712.60756013.77743 01.3400 01236574 712636236401275775 0174605 0133707 315026.01.0465 01.3637 0125445 71.776365

    01223733. 017762.0 01377.4. 3152064050143732. 01.523.27 012405543 71345002401274063. 01744.7.2 013364534 31532502501004. 01.473275 01273064 71..56.201475.367 010.373.7 015064343 71447547014.3057.2 01.647737 015250.32 7144076201222.026 0176050533 013747556 315.60357017537.5 0136.3. 010.7766 01677..012232.24 017456.244 01377242 315233777.

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    23/46

    0147772 013653.6 015.603 2100.2740127057472 017.523 0133.374. 312.0..70176776 01754425 0106.7.403 317..05055012.2633 0172764 013247024 31.34027

    015307.3 0122.063 01706.7 3164424250126327 012064543 013.7.. 312.64

    015040 0126657025 01707457 316.57012622567 01273660 01302. 3156.26

    01.5024 01.40627 017256465 710757654.013536.04 01.572554 01230745 712466501542..0 01247524 0170567 3143..60124442 0157330.7 012..7 71.44707

    01466.6 0147725 012456.57 71256424014555 0144.350 01252265 71454364

    014633640. 0176.5367 0154.303 210572026701.45.7.6 0140260. 01...3.7 212745

    015003056 0142.05 01.27..0. 2174365.35015.5.22 012.3656 01367457 313047.017356 014364460. 01.634.. 21.007354701554247 0126305.44 0173034627 3160.03..0167004656 01424...6 01507577 2142527..015..26 01233744 0136222 3177534.01607034 014.603 01472754 51075573015.566 0124.5252 017035.06. 3132.2.01..73322. 015462606 0172626. 710542547401.72243 0157.5.54 017744623 3166072470125775 01605.0 012226262. 7155562401265522 01.40.424 0133502 31.53705015200445 0126545562 0135543. 3144.46601355673 0155.627 01233073 71260.074016625..5 0145725 01442.4444 51766.340201464056. 017.47006 0153753 210..64601020..5 0123233 0152.63 2106.074016..050. 016504564 014..46 51772424015355343 01.0236477 0170772 316427701.0.2..5. 0153264 017364 316.320467015.46042 015.4.7.53 01730453 316045550130.507 01.7562 012.747 71..54673014700. 01.6.60522 01243.332. 717302.01424245 0140623 01543577 2103007

    @D!8/0A @D!8/0A @D!8/0A @D!8/0A@D!8/0A @D!8/0A @D!8/0A @D!8/0A@D!8/0A @D!8/0A @D!8/0A @D!8/0A@D!8/0A @D!8/0A @D!8/0A @D!8/0A@D!8/0A @D!8/0A @D!8/0A @D!8/0A@D!8/0A @D!8/0A @D!8/0A @D!8/0A@D!8/0A @D!8/0A @D!8/0A @D!8/0A@D!8/0A @D!8/0A @D!8/0A @D!8/0A

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    24/46

    @D!8/0A @D!8/0A @D!8/0A @D!8/0A@D!8/0A @D!8/0A @D!8/0A @D!8/0A@D!8/0A @D!8/0A @D!8/0A @D!8/0A@D!8/0A @D!8/0A @D!8/0A @D!8/0A

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    25/46

    ancho %en de e#ca>acion% %2

    01 .216.6501 .41065701 512701 531501 45137637

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    26/46

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    27/46

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    28/46

    Poblacion total De Diseo (hab) .7677rea Total Residencial De Diseo (Ha) 6012Densidad de poblacin (Hab/ha) .10Dotacin Neta (L/Hab-dia): 32.Contribcin !n"ltracin (L/s-Ha): 017Contribcin Cone#iones $rradas (L/s-Ha): 7

    Contribocin Co%ercial (L/s-Ha) 015.Contribocin !nstitcional (L/s-Ha) 015.Contribocin !ndstrial (L/s-Ha) 01&actor Retorno 01Coe"ciente de 'annin 01006Tbera P8C +lcantarillado

    *bic Tra%o + Propia Re ,tras re+ T Res Poblacin +co%erci+rea !nst +rea inds9do%estico9co%erci9 inst 9indstria(Ha) (Ha) (Ha) (Hab) (Ha) (Ha) (Ha)

    0102 0102 341.70 01073644 0 0 0-5 0105 0105 7215574. 010762025 0 0 0

    0102 0102 341.70 01073644 0 0 00105 0105 7215574. 010762025 0 0 0

    2-5 0104 0104 5310753 010.373 0 0 0

    5-7 01076 01076 3166.66 0107375. 0 0 001025 01025 3616722 010756046 0 0 0

    7-3 0104 0104 551.5377 010..4. 0 0 07-0 010.2 010.2 231035 010274 0 0 0

    01065 01065 ..10605. 01023 0 0 00-44 0103 0103 301.5675 010323. 0 0 0

    01006 01006 .17453 0100.622 0 0 001056 01056 714342 0102.64 0 0 0

    47-45 01024 01024 7315.5 0107430.4 0 0 045-4 01052 01052 7.17006. 01023.037 0 0 04-44 010. 010. 76120252 0102762 0 0 044-4 010 010 .31.4505 010554 0 0 04-4. 0102 0102 7310654 01072423 0 0 0

    0104 0104 .016464 010242. 0 0 0

    4.-42 0105 0105 7215574. 010762025 0 0 0010 010 .015036 01020075 0 0 0

    42-43 0105 0105 7215574. 010762025 0 0 0010 010 .31.4505 010554 0 0 0

    43-6 01054 01054 741.5.72 01025523. 0 0 06-40 017 017 33417324 0135.347 0 0 040- 0133 0133 5154.. 0100.55 0 0 0

    013 013 .104 010427. 0 0 00102 0102 341.70 01073644 0 0 0

    5- 010 010 2.13537 010526..3 0 0 0-4 0132. 0132. 46133674 0106663 0 0 0

    0104 0104 5.14322 010.43534 0 0 0010 010 2.13537 010526..3 0 0 00133 0133 5154.. 0100.55 0 0 0

    .-4 010 010 51.56 010.06 0 0 0.6-7 013. 013. 416302 0130646 0 0 07-3 0136 0136 33312.2 013263632 0 0 055-5 013 013 62144066 013347324 0 0 05-54 01. 01. 76210252 0127676 0 0 054-5 017 017 33417324 0135.347 0 0 0.0-5 0123 0123 33132 01774303 0 0 05-.6 0104 0104 5310753 010.373 0 0 0.6-. 0177. 0177. 3231.5 013523 0 0 0.-0 013 013 30.15675 01323.5 0 0 00-3 013 013 30.15675 01323.5 0 0 03-6. 0127 0127 341.57 01725574. 0 0 04-6 013 013 .104 010427. 0 0 0

    6.-6 01756 01756 35.16233 01375326 0 0 06-64 0136 0136 331053 0135.0.7 0 0 065-64 0125 0125 3661722 017560467 0 0 064 6 0 35 0 35 7 0563 0 307.7 0 0 0

    .-

    .-23-2

    46-3

    46-0

    46-440-47

    4-4.

    45-42

    47-43

    6-47-5

    5-.2-.-.

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    29/46

    5.-56 017 017 33417324 0135.347 0 0 056-.7 012 012 7301654 01724206 0 0 0.4-.7 012 012 34.170 0173644.4 0 0 0.7-.2 017 017 3510667 0170.375 0 0 052-.3 0153 0153 750177 01200207 0 0 0.3-.2 0153 0153 750177 01200207 0 0 0.2-76 0126 0126 771. 017.40. 0 0 076-7 0134 0134 661234 01375.26 0 0 07- 013 013 62144066 013347324 0 0 06- 015 015 7251574. 017620252 0 0 0

    -7. 013 013 30.15675 01323.5 0 0 07.-75 0175 0175 3501.. 0134.70 0 0 0302-75 0153 0153 750177 01200207 0 0 075-77 012 012 7771403 017427 0 0 077-70 012 012 7301654 01724206 0 0 026-24 0104 0104 5310753 010.373 0 0 02-24 0107 0107 33147324 01035.34 0 0 02-2. 0107 0107 33147324 01035.34 0 0 02.-25 0107 0107 33147324 01035.34 0 0 024-25 0105 0105 7215574. 010762025 0 0 025-27 010 010 51.56 010.06 0 0 022-27 0102 0102 341.70 01073644 0 0 027-23 0103 0103 .104 0100427.6 0 0 023-20 0103 0103 .104 0100427.6 0 0 0

    24-22 0125 0125 3661722 017560467 0 0 022-20 0103 0103 .104 0100427.6 0 0 076-20 017 017 3.712446 013605472 0 0 020-74 013 013 .104 010427. 0 0 07-74 0177 0177 37162.3 013336 0 0 074-7 0137 0137 4012775 01046302 0 0 07.-7 017 017 3.712446 013605472 0 0 07-72 0132 0132 41362 0106.727 0 0 025-72 0174 0174 3.172. 01364467 0 0 072-73 0132 0132 41362 0106.727 0 0 077-73 0175 0175 3501.. 0134.70 0 0 073-36 010 010 2.13537 010526..3 0 0 003 07 714 714 3341.. 71073626 0 0 007 02 2104 2104 34661723 7175602. 0 0 0

    02 05 0163 0163 .221277. 314 01.23 0 014. 005 360 314. 314. 307.17 317707.7 0 0 0360 0. 3127 3127 442130 01640322 0 0 00. 0 014 014 5.41322 01.43536 0 0 00 363 3165 3165 3321642 3157373. 0 0 0363 04 31.6 31.6 6231567 313533. 0 0 004 367 314 314 661234 3175.26.6 0 0 0367 0 31.6 31.6 6231567 313533. 0 0 00 362 313 313 300145 3127.602 0 0 0362 06 3145 3145 303614.6 31745662 0 0 006 365 31.2 31.2 61. 31370.2 0 0 0365 30 312 312 01445 3103065 0 0 030 33 31 31 3303106 31244735 0 0 033 37 3172 3172 47015. 0160300 0 0 037 32 713 713 37201455 31.25207 0 0 032 35 0135 0153 01.. 2771224 015076777 0 0 035 34 0105 0135 013 30.15675 01323.5 0 0 03. 34 012 012 34.170 0173644.4 0 0 034 3 0135 0172 0124 7315.5 017430. 0 0 032 3 0105 017 0175 3501.. 0134.70 0 0 03-36 0145 0145 522160 01.57332. 0 0 0

    bo% 36-70 0106 317 3176 4.107 0165.02.4 0 0 070-30. 0173 0165 313. 421646 01575424 0 0 0305-30. 015 015 7251574. 017620252 0 0 030.-30 01 01 261.74 01563.5 0 0 030-304 0177 012. 01.4 22510.63 01534.426 0 0 0.2-6 0125 0125 3661722 017560467 0 0 0

    302-6 0153 0153 750177 01200207 0 0 06-60 0125 0125 3661722 017560467 0 0 0.7-60 015 015 761.63 012266. 0 0 067 63 0 2 0 2 34. 70 0 73644.4 0 0 0

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    30/46

    30-3.6 017 017 33417324 0135.347 0 0 03.6-3. 0134 0134 661234 01375.26 0 0 03.-32 013. 013. 416302 0130646 0 0 037-32 0174 0174 3.172. 01364467 0 0 032-340 017. 017. 351.347 013235. 0 0 0340-36 017. 017. 351.347 013235. 0 0 0347-36 015. 015. 7214206 012762 0 0 036-34 0137. 0137. 4217.. 01063.427 0 0 0370-372 0 013 013 30.15675 013 01323.5 0 0 0137372-327 0 0172 0172 325146. 013 0135654 0 0 0137

    327-35 0 0 0 015 0 013 0 035-354 0 0 0 015 0 013 0 035-354 0173 0173 37210455 013.252 0 0 0354-30 010 010 51.56 010.06 0 0 030-33 013 013 .104 010427. 0 0 0342-33 0177 0177 37162.3 013336 0 0 033-37 015 015 7251574. 017620252 0 0 03.6-37 013 013 30.15675 01323.5 0 0 037-343 0122 0122 36215074 017534.22 0 0 0343-347 0122 0122 36215074 017534.22 0 0 034-347 01 01 210.2 0152.0 0 0 0347-344 017. 017. 351.347 013235. 0 0 0344-33 017. 017. 351.347 013235. 0 0 0342-345 0177 0177 37162.3 013336 0 0 0

    345-34. 0177 0177 37162.3 013336 0 0 034-34. 01. 01. 76210252 0127676 0 0 034.-37 0172 0172 325146. 0135654 0 0 037-32 0172 0172 325146. 0135654 0 0 032-35 0172 0172 325146. 0135654 0 0 035-3. 010 010 51.56 010.06 0 0 03.-3 010 010 51.56 010.06 0 0 03-3 010 010 51.56 010.06 0 0 0346-30 015 015 7251574. 017620252 0 0 034-30 0137. 0137. 4217.. 01063.427 0 0 030-33 0175 0175 3501.. 0134.70 0 0 035-33 0154 0154 74.15.72 0125523.2 0 0 033-34 0133 0133 5154.. 0100.55 0 0 034-3 0133 0133 5154.. 0100.55 0 0 0

    3-$;T+C 0 0 0 0 0 0total 213 601744 .7601.7 713 71. 316

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    31/46

    D$ + Lon 9dise Real Dia% No% C=;. .2127 31. 700 .317. 5 5610. 31. 700 .3105

    5 7 215 31. 700 .01.7 0 515 71072603 700 .01430 44 24152 712665 700 .01544 4 416 51004637 700 .01234 4. 251 517242.4 700 .01034. 42 2.1. 51673434 700 56142 43 25152 .1.2.5057 700 .010743 6 2517 1777244 700 5616 40 616 417.520.52 700 5614240 44146 4135236 700 56124

    4 43162 164764052 700 56134 6 330 33134634 700 51.6 64 3051 32164.0..3 700 515464 6 0123 31524366 700 5136 332 41. 31.70.262 700 541

    332 335 41 3041.3303 500 54125335 33. 712. 30177656 500 5417233. 37 612 3371.6053 5.0 51637 376 612 33512256. 500 515376 32. 717 33104674. 500 512332. 324 4142 3341456. 500 513324 32 3031. 37214426 5.0 .010332 326 304154 37.15402 5.0 5613326 3.5 6712. 376150460 5.0 51..3.5 3.. .4105 3221..2775 5.0 51753.. 3. 37 351460252 5.0 510.3. 3. 142 35613336 .00 54163. 35 50 3.015270.2 .00 541435 3 330 55170356 420 54133 36 330 5561.2..2 420 541236 34 41 5212.777 420 54104

    34 30 4315 521662.32 420 5177430 33 5162 54174622 32 51.33 34 461 .3714720 32 5.15434 3 471. .32176055 32 5.1463 PT+R 532 .77152 .0 517

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    32/46

    C=! C1T1; CT! PR,& CC; $

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    33/46

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    34/46

    D + Lon 9dise Real Dia% No% C=;55 5 461.4 31. 700 ..1255 54 330 21207. 700 ..10.54 5 ..17 5153706.75 700 .51535 .6 6124 1237.6 700 .5134.6 . .216. 41.3.6.762 700 .214

    . 0 .516. 152653542 700 .21240 3 5134 61274.7 700 .23 6. 6412 371456023 700 .71436. 65 30.17. 70124576 7.0 .71265 66 41 2516774 7.0 .710366 337 4610 .1745.64 23. .31.7.

    337 332 67162 12753342 2.. .3173

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    35/46

    C=! C1T1; CT!..10 .1.5 .122.5155 .122 ..15.517 ..15 ..15.

    .2142 ..15. .5162.215 .5162 .51

    .2102 .51 .5172

    .7145 .5172 .5135

    .7126 .5135 .216

    .7105 .216 .2125

    .3143 .2125 .2173.317. .2173 .2136

    .016 .2136 .716

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    36/46

    *bicacin Tra%o Lon 9dise Real Dia% No% C=;370 372 16 31445346 700 .7142372 327 415 21235504. 700 .7156327 35 30.1.7 .15235504. 700 .316735 354 60156 410235504. 700 .314354 30 4.135 1.3675023 700 .317

    30 33 4514 610277455 700 .310733 37 330 37173204. 700 .014437 343 3144 35176.7 700 .015343 347 431 31.77.4.6 700 .0135347 344 6133 73136332 7.0 561344 33 217 7715424453 7.0 561

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    37/46

    C=! C1T1; CT!.71.7 .2162 .2147.717. .2147 .21..31. .212. .2172.312 .212. .2172.310. .2172 .217.

    .01 .217. .213.0152 .213 .715.0134 .715 .7174561 .7174 .31561. .31 .31256126 .312 .3126

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    38/46

    *bicacin Tra%o Lon 9dise Real Dia% No% C=;57 53 616 31. 700 .51253 50 413 31737434 700 .51550 26 152 71..343. 700 .51326 4 4016. 331237504 700 .214 76 4314 371237726 700 .21.4

    76 7 .61 70176362 7.0 .21737 5313. 731.0054 7.0 .2105 7. 57153 7517.54 7.0 .71467. 75 461 7.1.6207 7.0 .71.75 77 6710 7616066035 7.0 .712277 70 4.174 2314.7. 7.0 .7104

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    39/46

    C=! C1T1; CT!.5156 .102 ..16.5136 ..16 ..156.2167 ..156 ..177.21 ..177 ..

    .2125 .. .5145

    .2107 .5145 .5157

    .714 .5157 .5177

    .712 .5177 .517

    .7153 .517 .513

    .710. .513 .517.

    .315 .517. .2166

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    40/46

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    41/46

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    42/46

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    43/46

    *bicacin Tra%o Lon 9dise Real Dia% No% C=;373 370 330 216775.505 700 .21370 336 330 410705.505 700 .7142336 375 6412 301.36425 700 .3167375 323 4516 33163..4 700 .31.4323 356 614. 3103.775 700 .3134

    356 35. 6164 70120022 7.0 .01635. 3. 5122 75175.636 7.0 .01..3. 32 216 71632405 7.0 .01232 340 4012. 761.5356 7.0 .010

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    44/46

    C=! C1T1; CT!.7142 .51 .2162.713. .2162 .212..31 .212. .716

    .317. .716 .71..

    .014 .71.. .715

    .01. .715 .7132.012 .7132 .713.

    .0133 .713. .71035617 .7103 .314

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    45/46

    *bicacin Tra%o Lon 9dise Real Dia% No% C=;5. 56 330 31. 700 .51656 .7 461. 51375 700 .510.7 60 3051.4 1.44223 700 .2160 307 330 36156735 7.0 .21.

    307 30 1 75162255 7.0 .2134

    30 304 330 761363.25 23. .7167

  • 7/24/2019 alcantarillado entrega 2 sfkffkgfkgk).xlsx

    46/46

    C=! C1T1; CT!.512 .106 ..1..212 ..1. ..1.3.21.2 ..1.3 ..17.217 ..17 .51.

    .716. .51. .51

    .717 .51 .5127