3º Practica Cayllahua
9
METODO DE HARDY CROSS - SOLUCION NUMERICA Solucion de la 1º pregunta: determine los caudales que circula sobre las tuberias I ITERACION Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.)Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo I AB 0.793 10 100 55 1 6.0880 0.1107 -0.40 54.60 I AB BC 0.256 8 100 15 -1 -0.5266 0.0351 -14.66 BC CA 0.262 8 100 52 -1 -5.3751 0.1034 -52.80 CA Sumatoria 0.1862 0.2492 Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.)Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo II AC 0.262 8 100 52 1 5.3751 0.1034 0.40 52.80 II AC CD 0.338 4 100 5 1 2.6638 0.5328 5.49 CD DA 0.217 6 100 35 -1 -8.6880 0.2482 -34.60 DA Sumatoria -0.6490 0.8844 Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.)Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo III CE 0.338 4 100 7 1 4.9641 0.7092 -0.10 7.65 III CE ED 0.518 6 100 10 -1 -2.0430 0.2043 -10.10 ED DC 0.338 4 100 5 -1 -2.6638 0.5328 -5.49 DC Sumatoria 0.2573 1.4462 Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.)Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo IV CB 0.256 8 100 15 1 0.5266 0.0351 -0.75 14.66 IV CB BE 0.217 6 100 28 1 5.7496 0.2053 27.25 BE EC 0.338 4 100 7 -1 -4.9641 0.7092 -7.65 EC Sumatoria 1.3120 0.9496 Q1 Q1 Q1 Q1 A C B E D RESERVORIO 55 lt/s 52 lt/s 15 lt/s 7 lt/s 28 lt/s 35 lt/s 5 lt/s 10 lt/s ASUMIENDO CAUDALES Y EL SENTIDO DEL FLUJO A D RESERVORIO 52.49 lt/ 35.19 lt/s 5.67 lt/s CAUDALES FINALES
-
Upload
santa-barbara-huancavelica -
Category
Documents
-
view
225 -
download
0
description
practica excel
Transcript of 3º Practica Cayllahua
METODO DE HARDY CROSS - SOLUCION NUMERICA
Solucion de la 1º pregunta: determine los caudales que circula sobre las tuberias
I ITERACION II ITERACION
Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.)
I
AB 0.793 10 100 55 1 6.0880 0.1107
-0.40
54.60
I
AB 0.793BC 0.256 8 100 15 -1 -0.5266 0.0351 -14.66 BC 0.256CA 0.262 8 100 52 -1 -5.3751 0.1034 -52.80 CA 0.262
Sumatoria 0.1862 0.2492
Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.)
II
AC 0.262 8 100 52 1 5.3751 0.1034
0.40
52.80
II
AC 0.262CD 0.338 4 100 5 1 2.6638 0.5328 5.49 CD 0.338DA 0.217 6 100 35 -1 -8.6880 0.2482 -34.60 DA 0.217
Sumatoria -0.6490 0.8844
Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.)
III
CE 0.338 4 100 7 1 4.9641 0.7092
-0.10
7.65
III
CE 0.338ED 0.518 6 100 10 -1 -2.0430 0.2043 -10.10 ED 0.518DC 0.338 4 100 5 -1 -2.6638 0.5328 -5.49 DC 0.338
Sumatoria 0.2573 1.4462
Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.)
IV
CB 0.256 8 100 15 1 0.5266 0.0351
-0.75
14.66
IV
CB 0.256BE 0.217 6 100 28 1 5.7496 0.2053 27.25 BE 0.217EC 0.338 4 100 7 -1 -4.9641 0.7092 -7.65 EC 0.338
Sumatoria 1.3120 0.9496
Q1
Q1
Q1
Q1
A C B
ED
RESERVORIO
55 lt/s
52 lt/s 15 lt/s
7 lt/s
28 lt/s35 lt/s
5 lt/s
10 lt/s
ASUMIENDO CAUDALES Y EL SENTIDO DEL FLUJO
A C B
ED
RESERVORIO
54.33 lt/s
52.49 lt/s 14.19 lt/s
7.63 lt/s
27.10 lt/s35.19 lt/s
5.67 lt/s
10.89 lt/s
CAUDALES FINALES Y EL SENTIDO DEL FLUJO
II ITERACION III ITERACION
Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC)10 100 54.60 1 6.0055 0.1100
0.06
54.66
I
AB 0.793 10 1008 100 14.66 -1 -0.5046 0.0344 -14.53 BC 0.256 8 1008 100 52.80 -1 -5.5292 0.1047 -52.63 CA 0.262 8 100
Sumatoria -0.0283 0.2491
Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC)8 100 52.80 1 5.5292 0.1047
-0.11
52.63
II
AC 0.262 8 1004 100 5.49 1 3.1699 0.5771 5.59 CD 0.338 4 1006 100 34.60 -1 -8.5067 0.2458 -34.72 DA 0.217 6 100
Sumatoria 0.1924 0.9276
Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC)4 100 7.65 1 5.8513 0.7648
-0.21
7.51
III
CE 0.338 4 1006 100 10.10 -1 -2.0795 0.2060 -10.31 ED 0.518 6 1004 100 5.49 -1 -3.1699 0.5771 -5.59 DC 0.338 4 100
Sumatoria 0.6020 1.5479
Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC)8 100 14.66 1 0.5046 0.0344
-0.07
14.53
IV
CB 0.256 8 1006 100 27.25 1 5.4691 0.2007 27.30 BE 0.217 6 1004 100 7.65 -1 -5.8513 0.7648 -7.51 EC 0.338 4 100
Sumatoria 0.1223 0.9999
Q1
Q1
Q1
Q1
A C B
ED
RESERVORIO
54.33 lt/s
52.49 lt/s 14.19 lt/s
7.63 lt/s
27.10 lt/s35.19 lt/s
5.67 lt/s
10.89 lt/s
CAUDALES FINALES Y EL SENTIDO DEL FLUJO
III ITERACION IV ITERACION
Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.)54.66 1 6.0180 0.1101
-0.06
54.60
I
AB 0.793 10 100 54.60 1 6.006614.53 -1 -0.4965 0.0342 -14.40 BC 0.256 8 100 14.40 -1 -0.488552.63 -1 -5.4957 0.1044 -52.56 CA 0.262 8 100 52.56 -1 -5.4828
Sumatoria 0.0259 0.2487 Sumatoria 0.0353
Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.)52.63 1 5.4957 0.1044
-0.12
52.56
II
AC 0.262 8 100 52.56 1 5.48285.59 1 3.2754 0.5858 5.54 CD 0.338 4 100 5.54 1 3.2229
34.72 -1 -8.5577 0.2465 -34.84 DA 0.217 6 100 34.84 -1 -8.6140
Sumatoria 0.2133 0.9368 Sumatoria 0.0917
Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.)7.51 1 5.6491 0.7526
-0.07
7.61
III
CE 0.338 4 100 7.61 1 5.800410.31 -1 -2.1603 0.2096 -10.38 ED 0.518 6 100 10.38 -1 -2.1893
5.59 -1 -3.2754 0.5858 -5.54 DC 0.338 4 100 5.54 -1 -3.2229
Sumatoria 0.2134 1.5480 Sumatoria 0.3882
Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.)14.53 1 0.4965 0.0342
-0.18
14.40
IV
CB 0.256 8 100 14.40 1 0.488527.30 1 5.4862 0.2010 27.24 BE 0.217 6 100 27.24 1 5.4641
7.51 -1 -5.6491 0.7526 -7.61 EC 0.338 4 100 7.61 -1 -5.8004
Sumatoria 0.3336 0.9877 Sumatoria 0.1522
Q1
Q1
Q1
Q1
IV ITERACION V ITERACION
Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo0.1100
-0.08
54.52
I
AB 0.793 10 100 54.52 1 5.9909 0.1099
-0.03
54.490.0339 -14.40 BC 0.256 8 100 14.40 -1 -0.4882 0.0339 -14.310.1043 -52.58 CA 0.262 8 100 52.58 -1 -5.4873 0.1044 -52.53
0.2482 Sumatoria 0.0154 0.2481
Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo0.1043
-0.05
52.58
II
AC 0.262 8 100 52.58 1 5.4873 0.1044
-0.09
52.530.5815 5.62 CD 0.338 4 100 5.62 1 3.3116 0.5888 5.590.2473 -34.89 DA 0.217 6 100 34.89 -1 -8.6383 0.2476 -34.98
0.9331 Sumatoria 0.1606 0.9407
Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo0.7617
-0.14
7.56
III
CE 0.338 4 100 7.56 1 5.7267 0.7573
-0.06
7.620.2109 -10.52 ED 0.518 6 100 10.52 -1 -2.2422 0.2132 -10.580.5815 -5.62 DC 0.338 4 100 5.62 -1 -3.3116 0.5888 -5.59
1.5541 Sumatoria 0.1729 1.5593
Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo0.0339
-0.08
14.40
IV
CB 0.256 8 100 14.40 1 0.4882 0.0339
-0.12
14.310.2006 27.21 BE 0.217 6 100 27.21 1 5.4532 0.2004 27.190.7617 -7.56 EC 0.338 4 100 7.56 -1 -5.7267 0.7573 -7.62
0.9963 Sumatoria 0.2146 0.9916
Q1 Q1
Q1 Q1
Q1 Q1
Q1 Q1
VI ITERACION VII ITERACION
Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo
I
AB 0.793 10 100 54.49 1 5.9841 0.1098
-0.05
54.44
I
ABBC 0.256 8 100 14.31 -1 -0.4829 0.0337 -14.30 BCCA 0.262 8 100 52.53 -1 -5.4760 0.1043 -52.54 CA
Sumatoria 0.0251 0.2478
Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo
II
AC 0.262 8 100 52.53 1 5.4760 0.1043
-0.04
52.54
II
ACCD 0.338 4 100 5.59 1 3.2764 0.5859 5.64 CDDA 0.217 6 100 34.98 -1 -8.6806 0.2481 -35.03 DA
Sumatoria 0.0718 0.9383
Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo
III
CE 0.338 4 100 7.62 1 5.8069 0.7621
-0.09
7.59
III
CEED 0.518 6 100 10.58 -1 -2.2659 0.2143 -10.67 EDDC 0.338 4 100 5.59 -1 -3.2764 0.5859 -5.64 DC
Sumatoria 0.2645 1.5623
Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo
IV
CB 0.256 8 100 14.31 1 0.4829 0.0337
-0.07
14.30
IV
CBBE 0.217 6 100 27.19 1 5.4440 0.2003 27.16 BEEC 0.338 4 100 7.62 -1 -5.8069 0.7621 -7.59 EC
Sumatoria 0.1201 0.9961
Q1
Q1
Q1
Q1
VII ITERACION VIII ITERACION
Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (")0.793 10 100 54.44 1 5.9729 0.1097
-0.03
54.41
I
AB 0.793 100.256 8 100 14.30 -1 -0.4823 0.0337 -14.25 BC 0.256 80.262 8 100 52.54 -1 -5.4786 0.1043 -52.50 CA 0.262 8
Sumatoria 0.0121 0.2477
Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (")0.262 8 100 52.54 1 5.4786 0.1043
-0.06
52.50
II
AC 0.262 80.338 4 100 5.64 1 3.3310 0.5904 5.63 CD 0.338 40.217 6 100 35.03 -1 -8.6996 0.2484 -35.09 DA 0.217 6
Sumatoria 0.1100 0.9430
Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (")0.338 4 100 7.59 1 5.7697 0.7599
-0.05
7.63
III
CE 0.338 40.518 6 100 10.67 -1 -2.3023 0.2158 -10.71 ED 0.518 60.338 4 100 5.64 -1 -3.3310 0.5904 -5.63 DC 0.338 4
Sumatoria 0.1364 1.5661
Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (")0.256 8 100 14.30 1 0.4823 0.0337
-0.08
14.25
IV
CB 0.256 80.217 6 100 27.16 1 5.4352 0.2001 27.14 BE 0.217 60.338 4 100 7.59 -1 -5.7697 0.7599 -7.63 EC 0.338 4
Sumatoria 0.1477 0.9937
Q1
Q1
Q1
Q1
VIII ITERACION IX ITERACION
C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.)100 54.41 1 5.9676 0.1097
-0.04
54.37
I
AB 0.793 10 100 54.37100 14.25 -1 -0.4789 0.0336 -14.24 BC 0.256 8 100 14.24100 52.50 -1 -5.4715 0.1042 -52.51 CA 0.262 8 100 52.51
Sumatoria 0.0172 0.2475
C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.)100 52.50 1 5.4715 0.1042
-0.03
52.51
II
AC 0.262 8 100 52.51100 5.63 1 3.3136 0.5890 5.66 CD 0.338 4 100 5.66100 35.09 -1 -8.7286 0.2488 -35.12 DA 0.217 6 100 35.12
Sumatoria 0.0565 0.9419
C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.)100 7.63 1 5.8166 0.7627
-0.06
7.61
III
CE 0.338 4 100 7.61100 10.71 -1 -2.3212 0.2166 -10.78 ED 0.518 6 100 10.78100 5.63 -1 -3.3136 0.5890 -5.66 DC 0.338 4 100 5.66
Sumatoria 0.1819 1.5683
C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.)100 14.25 1 0.4789 0.0336
-0.05
14.24
IV
CB 0.256 8 100 14.24100 27.14 1 5.4288 0.2000 27.13 BE 0.217 6 100 27.13100 7.63 -1 -5.8166 0.7627 -7.61 EC 0.338 4 100 7.61
Sumatoria 0.0911 0.9963
Q1
Q1
Q1
Q1
IX ITERACION X ITERACION
Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.)1 5.9600 0.1096
-0.02
54.35
I
AB 0.793 10 100 54.35 1 5.9559-1 -0.4782 0.0336 -14.20 BC 0.256 8 100 14.20 -1 -0.4760-1 -5.4725 0.1042 -52.48 CA 0.262 8 100 52.48 -1 -5.4681
Sumatoria 0.0093 0.2474 Sumatoria 0.0118
Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.)1 5.4725 0.1042
-0.04
52.48
II
AC 0.262 8 100 52.48 1 5.46811 3.3466 0.5917 5.65 CD 0.338 4 100 5.65 1 3.3388
-1 -8.7435 0.2490 -35.16 DA 0.217 6 100 35.16 -1 -8.7634
Sumatoria 0.0756 0.9448 Sumatoria 0.0434
Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.)1 5.7979 0.7616
-0.04
7.63
III
CE 0.338 4 100 7.63 1 5.8257-1 -2.3464 0.2177 -10.81 ED 0.518 6 100 10.81 -1 -2.3609-1 -3.3466 0.5917 -5.65 DC 0.338 4 100 5.65 -1 -3.3388
Sumatoria 0.1049 1.5710 Sumatoria 0.1260
Sentido Hfo (mt.) Hfo/Qo ∆ Qo Circuito Tramo Long. (Km.) Diam. (") C (PVC) Qo (Lt/Seg.) Sentido Hfo (mt.)1 0.4782 0.0336
-0.06
14.20
IV
CB 0.256 8 100 14.20 1 0.47601 5.4225 0.1999 27.11 BE 0.217 6 100 27.11 1 5.4179
-1 -5.7979 0.7616 -7.63 EC 0.338 4 100 7.63 -1 -5.8257
Sumatoria 0.1028 0.9951 Sumatoria 0.0681
Q1
Q1
Q1
Q1
X ITERACION
Hfo/Qo ∆ Qo Q FINALES0.1096
-0.03
54.330.0335 -14.190.1042 -52.49
0.2473
Hfo/Qo ∆ Qo Q FINALES0.1042
-0.02
52.490.5910 5.670.2492 -35.19
0.9444
Hfo/Qo ∆ Qo Q FINALES0.7633
-0.04
7.630.2183 -10.860.5910 -5.67
1.5726
Hfo/Qo ∆ Qo Q FINALES0.0335
-0.04
14.190.1998 27.100.7633 -7.63
0.9966
