examen balance de caudales por tramo excel

Upload: jorge-luis-espinal-mora

Post on 07-Jul-2018

225 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    1/20

    CÁLCULO DETUBERÍA PVC-P-UPRESIÓN DE TRAB

    PRIMERA ITERACIÓN

    CIRCUITO   TRAMO  LONG. Q DIÁMETRO

    m lts/seg EXTER. (plg! EXTER. (mm!

    I  KA 102.66 12.11 5 125

    AB 286.26 9.51 5 125B! 199.55 1.58" 2 50E 286.26 -8.""" 5 125KE 96.89 -12.11 6 160

    TOTA#

    II  B! 199.55 -1.58" 2 50

    BC 156.5$ 5.000 $ 110%! 156.5$ -1.618 & "5C%! 199.55 0.996 2 50

    TOTA#

    III  %! 156.5$ 1.618   &   "5

    I 1"&."9 -5.000   $   110IJ 156.5$ -&.690   $   110J% 1"&."9 -1.$2$   &   "5

    TOTA#

    IV

    CD 1$6.6 2.000 & "5D' 199.55 0.299 2 50

    %' 1$6.6 -1.562 & "5%C! 199.55 -0.996 2 50

    "

    CIRCUITO   TRAMO  LONG. Q DIÁMETRO

    m lts/seg EXTER. (plg! EXTER. (mm!

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    2/20

    I  KA 102.66 11.22 5 125

    AB 286.26 8.62 5 125B! 199.55 0.$& 2 50E 286.26 -9.6" 5 125KE 96.89 -1&.00 6 160

    TOTA#

    II  B! 199.55 -0.$& 2 50

    BC 156.5$ 5.26 $ 110%! 156.5$ -1.96 & "5C%! 199.55 1.01 2 50

    TOTA#

    III  %! 156.5$ 1.96   &   "5

    I 1"&."9 -$.&9   $   110IJ 156.5$ -&.08   $   110J% 1"&."9 -0.82   &   "5

    TOTA#CD 1$6.6 2.25 & "5D' 199.55 0.5$ 2 50%' 1$6.6 -1.&2 & "5%C! 199.55 -1.01 2 50

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    3/20

    #

    CIRCUITO   TRAMO  LONG. Q DIÁMETRO

    m lts/seg EXTER. (plg! EXTER. (mm!

    I  KA 102.66 10.99 5 125

    AB 286.26 8.&9 5 125B! 199.55 0.$5 2 50E 286.26 -9.90 5 125KE 96.89 -1&.2& 6 160

    TOTA#

    II  B! 199.55 -0.$5 2 50

    BC 156.5$ 5.02 $ 110%! 156.5$ -2.&6 & "5C%! 199.55 0.65 2 50

    TOTA#

    III  %! 156.5$ 2.&6   &   "5

    I 1"&."9 -$.2$   $   110IJ 156.5$ -2.9&   $   110J% 1"&."9 -0.6"   &   "5

    TOTA#

    IV

    CD 1$6.6 2.&" & "5D' 199.55 0.6" 2 50%' 1$6.6 -1.20 & "5%C! 199.55 -0.65 2 50

    $

    CIRCUITO   TRAMO  LONG. Q DIÁMETRO

    m lts/seg EXTER. (plg! EXTER. (mm!KA 102.66 10.8& 5 125

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    4/20

    AB 286.26 8.2& 5 125B! 199.55 0.&0 2 50

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    5/20

    E 286.26 -10.06 5 125KE 96.89 -1&.&9 6 160

    TOTA#

    II

      B! 199.55 -0.&0 2 50BC 156.5$ 5.01 $ 110%! 156.5$ -2.2$ & "5

    C%! 199.55 0."5 2 50TOTA#

    III  %! 156.5$ 2.2$   &   "5

    I 1"&."9 -$.&"   $   110IJ 156.5$ -&.06   $   110J% 1"&."9 -0."9   &   "5

    TOTA#

    IVCD 1$6.6 2.25 & "5D' 199.55 0.55 2 50

    %' 1$6.6 -1.&1 & "5%C! 199.55 -0."5 2 50

    %

    CIRCUITO   TRAMO  LONG. Q DIÁMETRO

    m lts/seg EXTER. (plg! EXTER. (mm!

    I  KA 102.66 10.80 5 125

    AB 286.26 8.20 5 125B! 199.55 0.$0 2 50E 286.26 -10.08 5 125KE 96.89 -1&.$2 6 160

    TOTA#B! 199.55 -0.$0 2 50BC 156.5$ $.88 $ 110%! 156.5$ -2.&6 & "5

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    6/20

    C%! 199.55 0.6& 2 50TOTA#

    III

      %! 156.5$ 2.&6   &   "5I 1"&."9 -$.&"   $   110IJ 156.5$ -&.06   $   110J% 1"&."9 -0.80   &   "5

    TOTA#

    IVCD 1$6.6 2.25 & "5D' 199.55 0.55 2 50%' 1$6.6 -1.&1 & "5%C! 199.55 -0.6& 2 50

    &

    CIRCUITO   TRAMO  LONG. Q DIÁMETRO

    m lts/seg EXTER. (plg! EXTER. (mm!

    I  KA 102.66 10."& 5 125

    AB 286.26 8.1& 5 125B! 199.55 0.&$ 2 50E 286.26 -10.15 5 125KE 96.89 -1&.$9 6 160

    TOTA#

    II

      B! 199.55 -0.&$ 2 50BC 156.5$ $.8" $ 110%! 156.5$ -2.&1 & "5C%! 199.55 0.68 2 50

    TOTA#

    III  %! 156.5$ 2.&1   &   "5

    I 1"&."9 -$.$$   $   110IJ 156.5$ -&.1&   $   110J% 1"&."9 -0.86   &   "5

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    7/20

    TOTA#

    IV

    CD 1$6.6 2.19 & "5D' 199.55 0.$9 2 50%' 1$6.6 -1.&" & "5%C! 199.55 -0.68 2 50

    '

    CIRCUITO   TRAMO  LONG. Q DIÁMETRO

    m lts/seg EXTER. (plg! EXTER. (mm!

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    8/20

    I  KA 102.66 10."2 5 125

    AB 286.26 8.12 5 125B! 199.55 0.&9 2 50E 286.26 -10.16 5 125KE 96.89 -1&.50 6 160

    TOTA#

    II  B! 199.55 -0.&9 2 50

    BC 156.5$ $.81 $ 110%! 156.5$ -2.&" & "5C%! 199.55 0.62 2 50

    TOTA#

    III  %! 156.5$ 2.&"   &   "5

    I 1"&."9 -$.$$   $   110IJ 156.5$ -&.1&   $   110J% 1"&."9 -0.8"   &   "5

    TOTA#

    IVCD 1$6.6 2.18 & "5D' 199.55 0.$8 2 50%' 1$6.6 -1.&8 & "5%C! 199.55 -0.62 2 50

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    9/20

    CIRCUITO   TRAMO  LONG. Q DIÁMETRO

    m lts/seg EXTER. (plg! EXTER. (mm!

    I

      KA 102.66 10.69 5 125AB 286.26 8.09 5 125B! 199.55 0.&6 2 50

    E 286.26 -10.20 5 125KE 96.89 -1&.5& 6 160

    TOTA#

    II  B! 199.55 -0.&6 2 50

    BC 156.5$ $.80 $ 110%! 156.5$ -2.&$ & "5C%! 199.55 0.6$ 2 50

    TOTA#

    III  %! 156.5$ 2.&$   &   "5

    I 1"&."9 -$.$"   $   110

    IJ 156.5$ -&.16   $   110J% 1"&."9 -0.90   &   "5

    TOTA#

    IVCD 1$6.6 2.16 & "5D' 199.55 0.$6 2 50%' 1$6.6 -1.$1 & "5%C! 199.55 -0.6$ 2 50

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    10/20

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    11/20

      A RED DE DISTRIBUCIÓN  Z  AJO: 0(50 )*+

    ) *+ *+/Q ,.-e-. Q0 1INTERIOR(mm! mm/mm m lts/seg lts/seg m/s

    120 0.0096$862"8 0.9905281&02 0.081"9$2&0$ 11.22 0.9916&85&69120 0.00616"2062 1."65$2$$$2$ 0.1856&8"$26 8.62 0."61"$806&5$" 0.02151$&"29 $.29&19&108& 2."052256511 0.$& 0.2$"$"881"5120 0.005&159$26 -1.521"$1"&81 0.1"&&"8&$55 -9.6" 0.8551"""&89

    15&.6 0.002899$&$$ -0.28092620&5 0.02&19"8698 -1&.00 0."018&08&61%."$&$'''#2" #.0&2"#$#2$

    $" 0.02151$&"29 -$.29&19&108& 2."052256511 -0.$& 0.2$"$"881"5105.6 0.00&$9$"96" 0.5$"0"5$691 0.109$1509&8 5.26 0.600896$12$"1.$ 0.0029095526 -0.$55$61&60" 0.281$9651$6 -1.96 0.$901"2&8&&

    $" 0.0090"9595& 1.8118&&2&9" 1.8191096"8$ 1.01 0.58&802$0663".#2'$%'&4" $.20%"$&2#"1.$ 0.0029095526 0.$55$61&60" 0.281$9651$6 1.96 0.$901"2&8&&105.6 0.00&$9$"96" -0.60"&60"115 0.121$"21$2& -$.&9 0.5015&5"$18105.6 0.0019910$85 -0.&116"8"&&" 0.08$$65"815 -&.08 0.&5196261&2"1.$ 0.002296"129 -0.&991$5"&8$ 0.2802989"&6 -0.82 0.20&9$$5186

    34.&"'"#""2 4.'&''##$0"

    "1.$ 0.00$&081609 0.6&15"6&816 0.&15"881908 2.25 0.5609&$&058$" 0.0009""9&65 0.1951$"2292 0.652666&185 0.5$ 0.&1$0969616

    "1.$ 0.002"258222 -0.&996055&8" 0.255829$102 -1.&2 0.&2869198"5$" 0.0090"9595& -1.8118&&2&9" 1.8191096"8$ -1.01 0.58&802$066

    30.#$'0%0&'& #.4$##2#%2'2

    ) *+ *+/Q ,.-e-. Q0 1INTERIOR(mm! mm/mm m lts/seg lts/seg m/s

      -   0.   8   9  $

       8   &   2   &

      6   "

       0.   2  6

       2   8   0   5

      6   0   9

       0.  6   0   "  $

       2   0   "  $

       5  6

       0.   2  $

       5   9  $   0   8   0

       9   5

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    12/20

    120 0.008&"00$56 0.8592688822 0.0"66166""6 10.99 0.9"1$"85092120 0.0051&585"2 1.$"0190$862 0.1"0651$0"9 8.&9 0."$15880&59$" 0.001911&21& 0.&81$0$1626 0.888&0$&"1 0.$5 0.256952258$120 0.006&62961$ -1.821$61&&5" 0.188&26&96& -9.90 0.8"5&&""665

    15&.6 0.00&&08626" -0.&205"28&8" 0.02$6502861 -1&.2& 0."1$1&55$054.%&"2#%&& 0.#$%$20#2

    $" 0.001911&21& -0.&81$0$1626 0.888&0$&"1 -0.$5 0.256952258$105.6 0.00&8$256 0.60151$&$"& 0.11$295&"6& 5.02 0.5"2986"019"1.$ 0.00$1602196 -0.6512$0"815 0.&&18229689 -2.&6 0.5890181868$" 0.009&66&515 1.869055$$"" 1.8$5&158296 0.65 0.&"&1"96$96

    0.$#'2"$%0 #.0'2'#%$%"1.$ 0.00$1602196 0.6512$0"815 0.&&18229689 2.&6 0.5890181868105.6 0.002"$9505 -0.$""8&6$6"$ 0.108"82662" -$.2$ 0.$8$25"06"105.6 0.001$2"0191 -0.22&&855651 0.0"2$6"0955 -2.9& 0.&&$68&9&8$"1.$ 0.000820092" -0.1$252&902" 0.1"$5&""$62 -0.6" 0.1661$8866&

    34.02"%4%0%# 4.&'&04$'##

    "1.$ 0.005&$0&111 0."828896119 0.&$85"98061 2.&" 0.5911$922&$$" 0.0029"199$2 0.59&061$$"9 1.088&0$&&98 0.6" 0.&8&82"&559

    "1.$ 0.00198$"66& -0.290966"&29 0.221089&9" -1.20 0.298$""0"$" 0.009&66&515 -1.869055$$"" 1.8$5&158296 -0.65 0.&"&1"96$96

      -   0.   2   2   8

       0   0  $   5

      $   1   &

      -   0.   2  $  $

      $  $   0  $

       &   5   9

       0.   1   5

       1   &   &   1

       0   8  6   &

       0.   1   2

       0   9   "   8

       &  6   "

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    13/20

    34.'$4'00"4 #.%4#"2#'"%

    ) *+ *+/Q ,.-e-. Q0 1INTERIOR(mm! mm/mm m lts/seg lts/seg m/s

    120 0.00805"66 0.82"199&""$ 0.0"528"80&6 10.8& 0.95"5125582

    120 0.00$8869892 1.&989$952&6 0.166"965089 8.2& 0."2"62208$8$" 0.0020$901" 0.$08881&$19 0.91"1898855 0.&0 0.1"0900"968120 0.0066$&5269 -1.901""60028 0.192101"508 -10.06 0.889&0&"1"6

    15&.6 0.00&$1685 -0.&&1058599" 0.02501"9612 -1&.&9 0."2265968054.$4"02%&$4# 0.#'#2040

    $" 0.0020$901" -0.$08881&$19 0.91"1898855 -0.&0 0.1"0900"968105.6 0.00&5186052 0.550802$51 0.109"5"&$"" 5.01 0.5"1998&009"1.$ 0.0058$59"2& -0.915128$988 0.&880&15"88 -2.2$ 0.5595&8"&11$" 0.00$089$686 0.81605&$6"2 1.260$19&5"8 0."5 0.$&$$085$62

    4.4$"$&4''& ".&'%#20&2"1.$ 0.0058$59"2& 0.915128$988 0.&880&15"88 2.2$ 0.5595&8"&11105.6 0.0025"666"$ -0.$$""990222 0.1055818958 -$.&" 0.$98"22&0"&105.6 0.001&000056 -0.20&5028"&$ 0.069$25&&0" -&.06 0.&$91$91"8""1.$ 0.0005610"51 -0.09"5092&5" 0.1$65"5"29" -0."9 0.19""90&665

    4.0&'#&'$ 4.'42&0$%#%0

    "1.$ 0.0058852001 0.862""0&2"" 0.&6$511951& 2.25 0.562$56050&$" 0.00$&081692 0.8596951"22 1.290990262 0.55 0.&1"60886$

    "1.$ 0.00166018"9 -0.2$&&8&5$8 0.20&65$$669 -1.&1 0.&2"1"02$&

    $" 0.00$089$686 -0.81605&$6"2 1.260$19&5"8 -0."5 0.$&$$085$624.&"$$& #.002%'&4#

    ) *+ *+/Q ,.-e-. Q0 1INTERIOR(mm! mm/mm m lts/seg lts/seg m/s

    120 0.00"8$$$62 0.805&12$6"8 0.0"$&6$8268 10.80 0.955299066"

      -   0.   1   5   "

       9   5   1   1

       8  $   8

      -   0.   0   0   8

      6   5  6  6   "   1

       1

      -   0.   1   2  6

      6   9   0   &

       0   1   9

      -   0

    .   1   1  $

       8   8   5  $

       1   1   1

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    14/20

    120 0.00$"1"92&9 1.&505528881 0.16$11691"1 8.20 0."25$0859&&$" 0.0009628688 0.1921$0$"69 0.6$80211$85 0.$0 0.2&01169$0$

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    15/20

    120 0.0068$11505 -1.958&$""&&9 0.19$"0958&8 -10.08 0.89151"209115&.6 0.00&$92"608 -0.&&8$1&59 0.0252"2119 -1&.$2 0."2$0106885

    4.4%0"$$%42 0.04&$$%2%"$" 0.0009628688 -0.1921$0$"69 0.6$80211$85 -0.$0 0.2&01169$0$

    105.6 0.00&50"&"&$ 0.5$90$$2&"8 0.1095960$$9 $.88 0.55"$09"001"1.$ 0.005&15"&2" -0.8&212$80&" 0.&"1$25"5 -2.&6 0.590610505

    $" 0.005$181"2$ 1.081196&10" 1.$&$566210$ 0.6& 0.&6&02""5254.&4%2'%"&'2 ".%&420%#2

    "1.$ 0.005&15"&2" 0.8&212$80&" 0.&"1$25"5 2.&6 0.590610505105.6 0.002"210108 -0.$"288$$602 0.108262619$ -$.&" 0.$9910612$105.6 0.001$0596" -0.2200900"6 0.0"19"&&501 -&.06 0.&$95&2995$"1.$ 0.000""$8551 -0.1&$6620"2" 0.1"00$10"99 -0.80 0.1986299&&$

    4.44$$02$ 4.'"0'4"'22$

    "1.$ 0.005&6"1"1 0."8682"269" 0.&$9&852009 2.25 0.561$"$"625

    $" 0.00&0&&82&6 0.605&995062 1.098661&601 0.55 0.&15&$$2&$9"1.$ 0.00196""8&$ -0.288$""0$58 0.22021"1615 -1.&1 0.&281515&08$" 0.005$181"2$ -1.081196&10" 1.$&$566210$ -0.6& 0.&6&02""525

    4.4""%%#$02# #.04""22##

    ) *+ *+/Q ,.-e-. Q0 1INTERIOR(mm! mm/mm m lts/seg lts/seg m/s

    120 0.00"81091&& 0.801868&6$$ 0.0"$218&599 10."& 0.9$89"2512$120 0.00$691&"99 1.&$295$$092 0.16&69152" 8.1& 0."190820&91

    $" 0.0016"0$5$8 0.&&&&&925"$ 0.8&$9&$2$"1 0.&$ 0.19$$&98011120 0.0068"2"16" -1.96"&8&89&9 0.195122&$5& -10.15 0.89"8$&"6&&

    15&.6 0.00&50$862$ -0.&&95861195 0.025&12&601 -1&.$9 0."2"8"211084.0'002"40'& 0."2#"'#2$

    $" 0.0016"0$5$8 -0.&&&&&925"$ 0.8&$9&$2$"1 -0.&$ 0.19$$&98011105.6 0.00&&$&519& 0.52&&9$505& 0.10"210$00" $.8" 0.556&0"$506"1.$ 0.0058"52"2 -0.919"150809 0.&8892$9""8 -2.&1 0.5"6620$02$

      -   0.   1   2

       "   "   "   0

       "   2  $   5

      -   0.   0   0   &

       &  6   1   5

      6   5   5

      -   0.   0   0   &

       9   2   9

       0   0  6

      -   0.   0   "   1

       5   5   1  6

      $   2   9

       0   9  6   5   &   "

       8  $   8

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    16/20

    $" 0.00&8858$2& 0.""5$1982$8 1.2&1151$&62 0.68 0.&91520"6814.4$%'%2220 ".%&"""04&0

    "1.$ 0.0058"52"2 0.919"150809 0.&8892$9""8 2.&1 0.5"6620$02$105.6 0.002"2$89 -0.$"&5586291 0.108&&&590" -$.$$ 0.50660$09$1105.6 0.001$088&05 -0.2205&8&286 0.0"20$0"$28 -&.1& 0.&5"0&09655"1.$ 0.000"8095" -0.1&5"22512$ 0.1"0655"&5$ -0.86 0.2150&111$&

    4.422%&042 4.'#22%%4$&'

    "1.$ 0.005&$98$&5 0."8$28"05$1 0.&$886588&9 2.19 0.5$6"1"&592$" 0.00299&8862 0.59"$&0000" 1.09198$6526 0.$9 0.281286900&

    "1.$ 0.0019"8"2" -0.290081&"86 0.220""9686 -1.&" 0.&$29089&$2$" 0.00&8858$2& -0.""5$1982$8 1.2&1151$&62 -0.68 0.&91520"681

    4.#0&"0%%0# ".2"'0&%

    ) *+ *+/Q ,.-e-. Q0 1INTERIOR(mm! mm/mm m lts/seg lts/seg m/s

    120 0.00""15&902 0."9206195$6 0.0"&"99$5&" 10."2 0.9$8116886$120 0.00$6158925 1.&21&$5&882 0.162$"$62&2 8.12 0."18226$1&1$" 0.001222""6 0.2$$00$95&" 0."2&&156"68 0.&9 0.22$6011&"1120 0.00696&&0"2 -1.99&&16&166 0.196&012558 -10.16 0.898699&89&

    15&.6 0.00&5&955"2 -0.&$29$""012 0.025$2"&15 -1&.50 0."28&9$&$&$4.4"00$"'& 0.00#0#"$%

    $" 0.001222""6 -0.2$$00$95&" 0."2&&156"68 -0.&9 0.22$6011&"1105.6 0.00&&&12858 0.521$"9$"88 0.10"029""9 $.81 0.5$922"829&

    "1.$ 0.0056201518 -0.8"9""8566$ 0.&8106&250& -2.&" 0.59095&1$52$" 0.00$$69$$55 0.8918""8$6 1.&1&000"52" 0.62 0.&58&221069

    4."2%'#4$ ".%"$$42$%'"1.$ 0.0056201518 0.8"9""8566$ 0.&8106&250& 2.&" 0.59095&1$52105.6 0.0028011811 -0.$8681"26&2 0.109"18$2&2 -$.$$ 0.50"1&1&5&&105.6 0.001$65&068 -0.229&"91&15 0.0"&&55098 -&.1& 0.&5"55822$""1.$ 0.00090$556$ -0.15"20285&& 0.1825882$5 -0.8" 0.21618$$$9$

      -   0.   0  6

       5  6  6   9   1   5

      $   &

      -   0.   0   5   9

       0   8   "   5

       8  6   8

      -   0.   0   0   9

      6   "  6   9   0   2

       &

      -   0.   0  6   2

       0   0   5   1

      $   "   5

       0  $  6   1   "   8

       "   1   5

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    17/20

    4.44'2#0$ 4.'$&'"%40&%

    "1.$ 0.005092&"0" 0."$65$15$09 0.&$10&96 2.18 0.5$5616612$$" 0.002$228019 0.$8&$"012&5 0.99068260$2 0.$8 0.2"8"$6582

    "1.$ 0.0021$6665& -0.&1$"011&2" 0.2292098098 -1.&8 0.&$$009681$" 0.00$$69$$55 -0.8918""8$6 1.&1&000"52" -0.62 0.&58&221069

    4.4"#$#"&%' ".'#2#"'&&'

    ) *+ *+/Q ,.-e-. Q0 1INTERIOR(mm! mm/mm m lts/seg lts/seg m/s

      -   0.   0   0  $

      $   0   "   &

       1   1  $

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    18/20

    120 0.00""025128 0."90"&9962& 0.0"&"$2"6"6 10.69 0.9$$8&$0869120 0.00$605"266 1.&18$&528"8 0.162&0992&& 8.09 0."1$9$&61&5$" 0.00159"06$$ 0.&1869$20$9 0.81"8555"51 0.&6 0.206$9"185"120 0.0069"56009 -1.9968&55001 0.196$60601& -10.20 0.9019821889

    15&.6 0.00&5$$2616 -0.&$&$0&502" 0.025$$2855 -1&.5& 0."&0&98005&4.4'$%"# 0."'%00'""#

    $" 0.00159"06$$ -0.&1869$20$9 0.81"8555"51 -0.&6 0.206$9"185"105.6 0.00&25&20&" 0.5092565106 0.105868&9" $.80 0.5$85"$9&28"1.$ 0.0058815856 -0.920"0&$15& 0.&8911"1"55 -2.&$ 0.58$$91091"$" 0.00&"9&081$ 0."56909&899 1.21"5$$0"81 0.6$ 0.&"1$0"91&9

    4.4"&'&"4# ".%#4#%""%"1.$ 0.0058815856 0.920"0&$15& 0.&8911"1"55 2.&$ 0.58$$91091"105.6 0.002806582$ -0.$8""559$8" 0.1098156902 -$.$" 0.510"&8$$$"105.6 0.001$69&16" -0.2&00068&05 0.0"&$$"&69 -&.16 0.&61165&161"1.$ 0.00091&561$ -0.158"6"8$&6 0.18&$2215$$ -0.90 0.22$0"$659$

    4.4$$0'"'2"% 4.'%%4"#20

    "1.$ 0.0050"&$002 0."$&"60$69$ 0.&$0$5$596" 2.16 0.5&85182&"&$" 0.002&82$&85 0.$"5$1559"& 0.98&0560$$$ 0.$6 0.262&6$8562

    "1.$ 0.002159$$&6 -0.&165"$$289 0.2298&6$2"6 -1.$1 0.&511080561$" 0.00&"9&081$ -0."56909&899 1.21"5$$0"81 -0.6$ 0.&"1$0"91&9

    4.0$%&2""$' ".''4200$&2

      -   0.   0   &   "

       1   2   "   5

       8   8

      -   0.   0   0   5

       "   1   8   2

       &  6   &

      -   0.   0   &   1

       5   9   1   8

       &  6

      -   0.   0   2   8

      $   2   1   &

       8   5   8

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    19/20

    ) *+ *+/Q ,.-e-. Q0 1INTERIOR(mm! mm/mm m lts/seg lts/seg m/s

    120 0.00"65&19"" 0."856""2"21 0.0"&525208& 10.68 0.9$$$&&$"2$120 0.00$566818$ 1.&0"29"$&29 0.1616"""$52 8.08 0."1$5$29991$" 0.001&66891 0.2"2"6&10&& 0."61&5269&$ 0.&8 0.2215$1&15

    120 0.00"0228608 -2.010&6$1198 0.19"0"1"5"& -10.21 0.902&8280&&15&.6 0.00&562&&"$ -0.&$515$8"02 0.025502$62& -1&.5$ 0."&06$25209

    4.404"00" 0."020"2&&&$" 0.001&66891 -0.2"2"6&10&& 0."61&5269&$ -0.&8 0.2215$1&15

    105.6 0.00&2$60$58 0.5081&600&& 0.105"611808 $."" 0.5$50""$82&"1.$ 0.005"6&0&89 -0.9021$61085 0.&85$896115 -2.&" 0.591$&"$8&1$" 0.00$05&5868 0.80889&2$$6 1.255&20028 0.62 0.&552$"629

    4.0$"0"44#&" ".%4'2"#%0#'"1.$ 0.005"6&0&89 0.9021$61085 0.&85$896115 2.&" 0.591$&"$8&1105.6 0.0028$&6619 -0.$9$199996$ 0.110$80"1&5 -$.$8 0.5110602802105.6 0.001$9688&9 -0.2&$&222051 0.0"$0"80"55 -&.1" 0.&61$8"1516"1.$ 0.0009"62655 -0.1696651"92 0.1891096$1 -0.90 0.22$""86$""

    4.44#2%'"'' 4.'%20%4$0%

    "1.$ 0.00$9518$82 0."259$09528 0.&&66""8"$$ 2.15 0.5&"8"028$" 0.0021296625 0.$2$9"$15$$ 0.9&&622&9$5 0.$5 0.260869$916

    "1.$ 0.0022$268&" -0.&28"""$&1" 0.2&&8"02066 -1.$1 0.&51"5601&&$" 0.00$05&5868 -0.80889&2$$6 1.255&20028 -0.62 0.&552$"629

    4.40#"$$$#42 ".'%2$24%4#%

      -   0.   0   0  $   5

       &   0   8  $

       2  6

      -   0.   0   &   0

      6   &   1   5

       "   2  6

      -   0.   0   0   2

       8   1   8   "

       1   8   5

      -   0.   0   0   2

       5   9  $   &   "  $

       5

  • 8/19/2019 EXAMEN Balance de Caudales Por Tramo EXCEL

    20/20