HARDY CROSS CON CORRECCION DE ALTURA PIEZOME

datos del problema PI=

diametro 0.15 m
rugosidad absoluta 0.00006 m
velocidad 0 m/s
densidad 1000 kg/m3
viscosidad 0.000001141 pa.s
f1 (valor inicial) 0.001
margen de error 0.000001
gravedad
PI

TUBO Hi(m) Hj(m) hf(m) Q(m3/s) ∑Km+(f*l)/d)

1-2 100 92 8 0.10934325 31.6333212621
2-3 92 80 12 0.03952358 47.0665662446
3-4 80 75 5 0.01229923 40.003041888
4-5 75 90 15 0.04439345 46.6334282172
2-5 92 90 2 0.00755953 42.3564152484
5-6 90 95 5 0.04312042 52.0718341475
1-6 100 95 5 0.1116936 18.9475130485
1-6
1-6

NUDO TUBERIA Q dfi/dHj dfi/dHi -fi

2-1 0.10934325 -0.006834
2-3 -0.0357684 -0.0016468
2 2-5 -0.0075595 -0.0018899 -0.0103707 0.006015295
3-2 0.03576843 -0.0016468
3-4 -0.0122992 -0.0012299
3 3-4 0 0 -0.0028767 -0.0165307985
4-3 0.01229923 -0.0012299
4-5 0.04439345 -0.0014798
4 3-4 0 0 -0.0027097 0.0266926748
5-4 -0.0443934 -0.0014798
5-2 0.00755953 -0.0018899
5 5-6 0.04312042 -0.004312 -0.0076817 -0.0237135006
6-5 -0.0431204 -0.004312
6-1 0.1116936 -0.0111694
6 3-4 0 0 -0.0154814 0.0285731859
3-4
3-4
7 3-4

MATRIZ
ION DE ALTURA PIEZOMETRICA D L Qdi
1-2 0.25 500 0.12
3.1415926536 2-3 0.15 400 0.05
3-4 0.1 200 0.01
4-5 0.15 400 0.02
2-5 0.1 200 0.01
5-6 0.2 600 0.04
1-6 0.25 300 0.8
1-2
1-2
1-2
1-2
1-2

dfi/dHj Kmij fi 1-2 2-3

-0.0068339534 0 0.0108166606 12
-0.0016468158 10 0.0138999623 9.45041949
-0.0012299229 0 0.0200015209 10.0134698
-0.0014797815 0 0.0174875356 9.88949029
-0.0018898824 0 0.0211782076 9.91680912
-0.0043120416 0 0.017357278 9.91079035
-0.0111693602 0 0.0157895942 9.91211642
9.91182426
9.91188863
9.91187445
 2-3 3-4
0.03952358 47.0665662 0
0.03488747 47.572494
0.03595966 47.4457415
0.03572617 47.4727994
0.03577774 47.4667974
0.03576638 47.4681178
0.03576889 47.4678268
0.03576834 47.4678909
0.03576846 47.4678767
0.03576843 47.4678799
 INTERACION POR NEWTON RAPHSON PARA HALLAR EL FACTOR DE FRICCION (f)

para la tercera tuveria

datos del problema caudal
diametro 0.152 m velocidad
rugosidad absoluta 0.00006 m
velocidad 16.5327156951 m/s V=
densidad 1000 kg/m3
viscosidad 0.000001141 pa.s
f1 (valor inicial) 0.001 hf=
margen de error 0.000001 L=

valores calculados
numero de reynons 2202430136 turbolento
rugosidad relativa 0.00039474

NEWTON RAPHSON
x f(x) f'(x) X(x+1) x=X(x+1) f
31.6227766017 7.94349476 -9.238459E-06 7.94371352 no
7.9437135175 7.94371442 -9.277759E-06 7.94371442 si 0.01584721

RESULTADOS
factor de friccion 0.015847
 0.3
16.5327157

8
400
 DATOS ITERACCIO
NODO 1 2
Tuveria 1-2 2-3
h (ASUMIDOS) 40 38
L(m) 100 100
Diametro 0.152 0.1
Qdemandada 0 0.002
K 0 0

Tuberia LONG DIAMETRO

1 2 100 0.152
2 3 100 0.1
3 4 220 0.076
4 5 100 0.203
5 6 100 0.203
6 1 220 0.203
5 2 220 0.076

NUDO TUBERIA Q(conv.)

-1 2-1 -1
-1 1-6 -1
1 2-5 1
1 1-2 1
-1 3-2 -1
-1 2 5-2 -1
1 2-3 1
-1 3-4 -1
-1 3 -1
 1 3-4 1
1 5-4 1
-1 4 -1
-1 4-5 -1
1 6-5 1
1 5 5-2 1
1 6-1 1
-1 5-6 -1
6 1
 DATOS ITERA
NODO 1 2
Tuveria 1-2 2-3
h (ASUMIDOS) 40 40.10686
L(m) 100 100
Diametro 0.152 0.1
Qdemandada 0 0.002
K 0 0

Tuberia LONG DIAMETRO

1 2 100 0.152
2 3 100 0.1
3 4 220 0.076
4 5 100 0.203
5 6 100 0.203
6 1 220 0.203
5 2 220 0.076
4 R 350 8

NUDO TUBERIA Q(conv.)

-1 2-1 -1
-1 1-6 -1
1 2-5 1
1 1-2 -1
-1 3-2 -1
-1 2 5-2 -1
1 2-3 1
-1 3-4 -1
3
-1 3 -1
1 3-4 1
1 5-4 1
4 4-R -1
-1 4-5 -1
1 6-5 1
1 5 5-2 1
1 6-1 1
-1 5-6 -1
6 1
 DATOS ITERA
NODO 1 2
Tuveria 1-2 2-3
h (ASUMIDOS) 40 39.41857
L(m) 100 100
Diametro 0.152 0.1
Qdemandada 0 0.002
K 0 0

Tuberia LONG DIAMETRO

1 2 100 0.152
2 3 100 0.1
3 4 220 0.076
4 5 100 0.203
5 6 100 0.203
6 1 220 0.203
5 2 220 0.076

NUDO TUBERIA Q(conv.)

-1 2-1 -1
-1 1-6 -1
1 2-5 1
1 1-2 1
-1 3-2 -1
-1 2 5-2 -1
1 2-3 1
-1 3-4 -1
3
-1 3 -1
1 3-4 1
1 5-4 1
4 1
-1 4-5 -1
1 6-5 1
1 5 5-2 1
1 6-1 1
-1 5-6 -1
6 1
 DATOS ITERA
NODO 1 2
Tuveria 1-2 2-3
h (ASUMIDOS) 40 39.545
L(m) 100 100
Diametro 0.152 0.1
Qdemandada 0 0.002
K 0 0

Tuberia LONG DIAMETRO

1 2 100 0.152
2 3 100 0.1
3 4 220 0.076
4 5 100 0.203
5 6 100 0.203
6 1 220 0.203
5 2 220 0.076

NUDO TUBERIA Q(conv.)

-1 2-1 -1
-1 1-6 -1
1 2-5 1
1 1-2 1
-1 3-2 -1
-1 2 5-2 -1
1 2-3 1
-1 3-4 -1
3
-1 3 -1
1 3-4 1
1 5-4 1
4 1
-1 4-5 -1
1 6-5 1
1 5 5-2 1
1 6-1 1
-1 5-6 -1
6 1
 DATOS ITERA
NODO 1 2
Tuveria 1-2 2-3
h (ASUMIDOS) 40 39.54183
L(m) 100 100
Diametro 0.152 0.1
Qdemandada 0 0.002
K 0 0

Tuberia LONG DIAMETRO

1 2 100 0.152
2 3 100 0.1
3 4 220 0.076
4 5 100 0.203
5 6 100 0.203
6 1 220 0.203
5 2 220 0.076

NUDO TUBERIA Q(conv.)

-1 2-1 -1
-1 1-6 -1
1 2-5 1
1 1-2 1
-1 3-2 -1
-1 2 5-2 -1
1 2-3 1
-1 3-4 -1
3
-1 3 -1
1 3-4 1
1 5-4 1
4 1
-1 4-5 -1
1 6-5 1
1 5 5-2 1
1 6-1 1
-1 5-6 -1
6 1
 DATOS ITERA
NODO 1 2
Tuveria 1-2 2-3
h (ASUMIDOS) 40 39.54227
L(m) 100 100
Diametro 0.152 0.1
Qdemandada 0 0.002
K 0 0

Tuberia LONG DIAMETRO

1 2 100 0.152
2 3 100 0.1
3 4 220 0.076
4 5 100 0.203
5 6 100 0.203
6 1 220 0.203
5 2 220 0.076

NUDO TUBERIA Q(conv.)

-1 2-1 -1
-1 1-6 -1
1 2-5 1
1 1-2 1
-1 3-2 -1
-1 2 5-2 -1
1 2-3 1
-1 3-4 -1
3
-1 3 -1
1 3-4 1
1 5-4 1
4 1
-1 4-5 -1
1 6-5 1
1 5 5-2 1
1 6-1 1
-1 5-6 -1
6 1
 DATOS ITERA
NODO 1 7
Tuveria 1-2 2-3
h (ASUMIDOS) 40 39.54222
L(m) 100 100
Diametro 0.152 0.1
Qdemandada 0 0.002
K 0 0

Tuberia LONG DIAMETRO

1 2 100 0.152
2 3 100 0.1
3 4 220 0.076
4 5 100 0.203
5 6 100 0.203
6 1 220 0.203
5 2 220 0.076

NUDO TUBERIA Q(conv.)

-1 2-1 -1
-1 1-6 -1
1 2-5 1
1 1-2 1
-1 3-2 -1
-1 2 5-2 -1
1 2-3 1
-1 3-4 -1
3
-1 3 -1
1 3-4 1
1 5-4 1
4 1
-1 4-5 -1
1 6-5 1
1 5 5-2 1
1 6-1 1
-1 5-6 -1
6 1
 DATOS ITERA
NODO 1 7
Tuveria 1-2 2-3
h (ASUMIDOS) 40 39.54223
L(m) 100 100
Diametro 0.152 0.1
Qdemandada 0 0.002
K 0 0

Tuberia LONG DIAMETRO

1 2 100 0.152
2 3 100 0.1
3 4 220 0.076
4 5 100 0.203
5 6 100 0.203
6 1 220 0.203
5 2 220 0.076

NUDO TUBERIA Q(conv.)

-1 2-1 -1
-1 1-6 -1
1 2-5 1
1 1-2 1
-1 3-2 -1
-1 2 5-2 -1
1 2-3 1
-1 3-4 -1
3
-1 3 -1
1 3-4 1
1 5-4 1
4 1
-1 4-5 -1
1 6-5 1
1 5 5-2 1
1 6-1 1
-1 5-6 -1
6 1

DATOS ITERA
NODO 1 7
Tuveria 1-2 2-3
h (ASUMIDOS) 40 39.54223
L(m) 100 100
Diametro 0.152 0.1
Qdemandada 0 0.002
K 0 0

Tuberia LONG DIAMETRO

1 2 100 0.152
2 3 100 0.1
3 4 220 0.076
4 5 100 0.203
5 6 100 0.203
6 1 220 0.203
5 2 220 0.076

NUDO TUBERIA Q(conv.)

-1 2-1 -1
-1 1-6 -1
1 2-5 1
1 1-2 1
-1 3-2 -1
-1 2 5-2 -1
1 2-3 1
-1 3-4 -1
-1 3 -1
1 3-4 1
1 5-4 1
4 1
-1 4-5 -1
1 6-5 1
1 5 5-2 1
1 6-1 1
-1 5-6 -1
6 1
 DATOS ITERA
NODO 1 7
Tuveria 1-2 2-3
h (ASUMIDOS) 40 39.54223
L(m) 100 100
Diametro 0.152 0.1
Qdemandada 0 0.002
K 0 0

Tuberia LONG DIAMETRO

1 2 100 0.152
2 3 100 0.1
3 4 220 0.076
4 5 100 0.203
5 6 100 0.203
6 1 220 0.203
5 2 220 0.076

conv. NUDO TUBERIA Q(conv.)

-1 2-1 -1
-1 1-6 -1
1 2-5 1
1 1-2 1
-1 3-2 -1
-1 2 5-2 -1
1 2-3 1
-1 3-4 -1
-1 3 -1
1 3-4 1
1 5-4 1
4 1
-1 4-5 -1
1 6-5 1
1 5 5-2 1
1 6-1 1
-1 5-6 -1
6 1

CAUDAL(Q) 1
tuberia 12
CAUDAL(Q) 0.015325999
ALT. PIEZOMETRICA 40

NUDO CAUDAL(Q)
1 Q12
2 Q23
3 Q34
4 Q45
5 Q56
6 Q61

Q52
 ITERACCION I
3 4 5 6
3-4 4-5 5-6 6-1 5-2
37 32 34 35 0
220 100 100 220 220
0.076 0.203 0.203 0.203 0.076
0.002 0.071 0.002 0.003 0
0 0 0 0 0

k AREA Hi Hj Hj-Hi
0 0.018145839 40 38 2
0 0.007853982 38 37 1
0 0.00453646 37 32 5
0 0.032365473 32 34 2
0 0.032365473 34 35 1
0 0.032365473 35 40 5
0 0.00453646 34 38 4

0.0075595298 0.003779765
Q dfi/dHj dfi/dHi -fi
-0.033109344 0.008277336
-0.075894469 0.007589447
0 0 -0.01586678 -0.1090038
0.0331093439 0.008277336
-0.00755953 0.003779765
-0.005011069 0.000626384 -0.01268348 0.0185387
0.0075595298 0.003779765
-0.0056433 0.00056433
0 0 -0.00434409 -8.377E-05
0.0056433004 0.00056433
0.071003946 0.017750987
0 0 -0.01831532 0.0056472
-0.071003946 0.017750987
0.0493774351 0.024688718
0.0050110692 0.000626384 -0.04306609 -0.0186154
0.0758944693 0.007589447
-0.049377435 0.024688718
0 0 -0.03227816 0.023517
 ITERACCION II
3 4 5 6
3-4 4-5 5-6 6-1 5-2
38.99280741 33.37735754 35.03965444 36.523778 0
220 100 100 220 220
0.076 0.203 0.203 0.203 0.076
0.002 0.071 0.002 0.003 0
0 0 0 0 0

k AREA Hi Hj Hj-Hi
0 0.018145839 40 40.106859 0.10686
0.007853982 40.1068588 38.992807 1.11405
0.00453646 38.99280741 33.377358 5.61545
0.032365473 33.37735754 35.039654 1.6623
0.032365473 35.03965444 36.523778 1.48412
0.032365473 36.52377837 40 3.47622
0.00453646 35.03965444 40.106859 5.0672
50.26548246 33.37735754

0.008008991 0.003594534
Q dfi/dHj dfi/dHi -fi
-0.006875731 0.03217204
-0.062780169 0.009029943
0 0 -0.04120198 -0.0696559
-0.006875731 0.03217204 0.03999
-0.008008991 0.003594534
-0.005683482 0.00056081 -0.03632738 -0.0225682 -0.00067
0.008008991 0.003594534
-0.006002063 0.000534424
 0 0 -0.00412896 6.9276E-06 0.02623
0.0060020634 0.000534424 0.01165
0.0644675791 0.019391115 0.00654
0 0 -0.01992554 -0.0005304
-0.064467579 0.019391115
0.0607543488 0.020468085
0.005683482 0.00056081 -0.04042001 -2.975E-05
0.0627801688 0.009029943
-0.060754349 0.020468085
0 0 -0.02949803 -0.0009742
 ITERACCION III
3 4 5 6
3-4 4-5 5-6 6-1 5-2
38.356383785 33.07683884 34.7757439 36.307631 0
220 100 100 220 220
0.076 0.203 0.203 0.203 0.076
0.002 0.071 0.002 0.003 0
0 0 0 0 0

k AREA Hi Hj Hj-Hi
0 0.018145839 40 39.418567 0.58143
0.007853982 39.41856663 38.356384 1.06218
0.00453646 38.35638378 33.076839 5.27954
0.032365473 33.07683884 34.775744 1.69891
0.032365473 34.7757439 36.307631 1.53189
0.032365473 36.30763093 40 3.69237
0.00453646 34.7757439 39.418567 4.64282

0.0078074773 0.003675204
Q dfi/dHj dfi/dHi -fi
-0.017215804 0.014804623
-0.064792306 0.008773812
0 0 -0.02357844 -0.0820081
0.0172158036 0.014804623
-0.007807477 0.003675204
-0.005425197 0.000584256 -0.01906408 0.0019831
0.0078074773 0.003675204
-0.005808769 0.00055012
 0 0 -0.00422532 -1.292E-06
0.0058087688 0.00055012
0.0652058996 0.019190566
0 0 -0.01974069 1.4668E-05
-0.0652059 0.019190566
0.0617702884 0.020161503
0.0054251975 0.000584256 -0.03993632 -1.041E-05
0.0647923058 0.008773812
-0.061770288 0.020161503
0 0 -0.02893531 2.2017E-05
 ITERACCION IV
3 4 5 6
3-4 4-5 5-6 6-1 5-2
38.469239007 33.10134698 34.79695512 36.323171 0
220 100 100 220 220
0.076 0.203 0.203 0.203 0.076
0.002 0.071 0.002 0.003 0
0 0 0 0 0

k AREA Hi Hj Hj-Hi
0 0.018145839 40 39.544997 0.455
0 0.007853982 39.54499744 38.469239 1.07576
0 0.00453646 38.46923901 33.101347 5.36789
0 0.032365473 33.10134698 34.796955 1.69561
0 0.032365473 34.79695512 36.323171 1.52622
0 0.032365473 36.32317136 40 3.67683
0 0.00453646 34.79695512 39.544997 4.74804

0.0079709582 0.003704809
Q dfi/dHj dfi/dHi -fi
-0.015275833 0.016786536
-0.06573102 0.008938548
0 0 -0.02572508 -0.0810069
0.0152758335 0.016786536
-0.007970958 0.003704809
-0.005578687 0.000587472 -0.02107882 -0.0002738
0.0079709582 0.003704809
-0.005957239 0.000554896
 0 0 -0.0042597 1.372E-05
0.0059572387 0.000554896
0.0662324342 0.019530584
0 0 -0.02008548 0.0011897
-0.066232434 0.019530584
0.0626632946 0.02052897
0.0055786869 0.000587472 -0.04064703 9.5473E-06
0.0657310197 0.008938548
-0.062663295 0.02052897
0 0 -0.02946752 6.7725E-05
 ITERACCION V
3 4 5 6
3-4 4-5 5-6 6-1 5-2
38.498672243 33.32369826 34.96387418 36.441756 0
220 100 100 220 220
0.076 0.203 0.203 0.203 0.076
0.002 0.071 0.002 0.003 0
0 0 0 0 0

k AREA Hi Hj Hj-Hi
0 0.018145839 40 39.541833 0.45817
0.007853982 39.54183281 38.498672 1.04316
0.00453646 38.49867224 33.323698 5.17497
0.032365473 33.32369826 34.963874 1.64018
0.032365473 34.96387418 36.441756 1.47788
0.032365473 36.44175623 40 3.55824
0.00453646 34.96387418 39.541833 4.57796

0.0078400248 0.003757823
Q dfi/dHj dfi/dHi -fi
-0.015333103 0.016733087
-0.064606949 0.009078488
0 0 -0.02581158 -0.0799401
0.0153331028 0.016733087
-0.007840025 0.003757823
-0.005470711 0.000597505 -0.02108841 2.2367E-05
0.0078400248 0.003757823
-0.005841792 0.000564427
 0 0 -0.00432225 -1.767E-06
0.0058417915 0.000564427
0.0650844568 0.019840694
0 0 -0.02040512 -7.375E-05
-0.065084457 0.019840694
0.0616098295 0.02084396
0.0054707106 0.000597505 -0.04128216 -3.917E-06
0.0646069488 0.009078488
-0.06160983 0.02084396
0 0 -0.02992245 -2.881E-06
 ITERACCION VI
3 4 5 6
3-4 4-5 5-6 6-1 5-2
38.496830947 33.30983038 34.95338135 36.434351 0
220 100 100 220 220
0.076 0.203 0.203 0.203 0.076
0.002 0.071 0.002 0.003 0
0 0 0 0 0

k AREA Hi Hj Hj-Hi
0 0.018145839 40 39.542268 0.45773
0.007853982 39.54226805 38.496831 1.04544
0.00453646 38.49683095 33.30983 5.187
0.032365473 33.30983038 34.953381 1.64355
0.032365473 34.95338135 36.434351 1.48097
0.032365473 36.43435066 40 3.56565
0.00453646 34.95338135 39.542268 4.58889

0.0078492318 0.003754043
Q dfi/dHj dfi/dHi -fi
-0.015325238 0.016740406
-0.064677677 0.009069551
0 0 -0.02580996 -0.0800029
0.0153252375 0.016740406
-0.007849232 0.003754043
-0.005477706 0.000596845 -0.02109129 -1.7E-06
0.0078492318 0.003754043
-0.005849049 0.000563818
 0 0 -0.00431786 1.8324E-07
0.0058490486 0.000563818
0.0651548894 0.019821378
0 0 -0.0203852 3.938E-06
-0.065154889 0.019821378
0.0616776153 0.020823394
0.0054777056 0.000596845 -0.04124162 4.3153E-07
0.064677677 0.009069551
-0.061677615 0.020823394
0 0 -0.02989295 6.1625E-08
 ITERACCION VII
3 4 5 6
3-4 4-5 5-6 6-1 5-2
38.496932612 33.31059075 34.95396179 36.434757 0
220 100 100 220 220
0.076 0.203 0.203 0.203 0.076
0.002 0.071 0.002 0.003 0
0 0 0 0 0

k AREA Hi Hj Hj-Hi
0 0.018145839 40 39.542222 0.45778
0.007853982 39.54222197 38.496933 1.04529
0.00453646 38.49693261 33.310591 5.18634
0.032365473 33.31059075 34.953962 1.64337
0.032365473 34.95396179 36.434757 1.4808
0.032365473 36.43475705 40 3.56524
0.00453646 34.95396179 39.542222 4.58826

0.0078486346 0.003754288
Q dfi/dHj dfi/dHi -fi
-0.01532607 0.016739631
-0.064673798 0.009070041
0 0 -0.02580967 -0.0799999
0.0153260703 0.016739631
-0.007848635 0.003754288
-0.005477305 0.000596883 -0.0210908 1.3094E-07
0.0078486346 0.003754288
-0.005848651 0.000563851
 0 0 -0.00431814 -1.672E-08
0.0058486513 0.000563851
0.0651511362 0.019822406
0 0 -0.02038626 -2.125E-07
-0.065151136 0.019822406
0.0616737958 0.020824552
0.0054773048 0.000596883 -0.04124384 -3.564E-08
0.0646737975 0.009070041
-0.061673796 0.020824552
0 0 -0.02989459 1.7388E-09
 ITERACCION VIII
3 4 5 6
3-4 4-5 5-6 6-1 5-2
38.496926979 33.31054869 34.95392942 36.434735 0
220 100 100 220 220
0.076 0.203 0.203 0.203 0.076
0.002 0.071 0.002 0.003 0
0 0 0 0 0

k AREA Hi Hj Hj-Hi
0 0.018145839 40 39.542226 0.45777
0.007853982 39.54222626 38.496927 1.0453
0.00453646 38.49692698 33.310549 5.18638
0.032365473 33.31054869 34.953929 1.64338
0.032365473 34.95392942 36.434735 1.48081
0.032365473 36.43473456 40 3.56527
0.00453646 34.95392942 39.542226 4.5883

0.0078486747 0.003754272
Q dfi/dHj dfi/dHi -fi
-0.015325993 0.016739703
-0.064674012 0.009070014
0 0 -0.02580972 -0.08
0.0153259928 0.016739703
-0.007848675 0.003754272
-0.005477328 0.00059688 -0.02109085 -1.016E-08
0.0078486747 0.003754272
-0.005848673 0.000563849
 0 0 -0.00431812 1.4292E-09
0.0058486733 0.000563849
0.0651513382 0.019822351
0 0 -0.0203862 1.1471E-08
-0.065151338 0.019822351
0.0616740126 0.020824486
0.0054773282 0.00059688 -0.04124372 2.6178E-09
0.0646740122 0.009070014
-0.061674013 0.020824486
0 0 -0.0298945 -3.736E-10

ITERACCION IX
3 4 5 6
3-4 4-5 5-6 6-1 5-2
38.496927287 33.31055101 34.95393122 36.434736 0
220 100 100 220 220
0.076 0.203 0.203 0.203 0.076
0.002 0.071 0.002 0.003 0
0 0 0 0 0

k AREA Hi Hj Hj-Hi
0 0.018145839 40 39.542226 0.45777
0.007853982 39.54222589 38.496927 1.0453
0.00453646 38.49692729 33.310551 5.18638
0.032365473 33.31055101 34.953931 1.64338
 0.032365473 34.95393122 36.434736 1.4808
0.032365473 36.4347358 40 3.56526
0.00453646 34.95393122 39.542226 4.58829

0.0078486719 0.003754273
Q dfi/dHj dfi/dHi -fi
-0.015326 0.016739697
-0.064674 0.009070015
0 0 -0.02580971 -0.08
0.0153259996 0.016739697
-0.007848672 0.003754273
-0.005477327 0.00059688 -0.02109085 7.9187E-10
0.0078486719 0.003754273
-0.005848672 0.00056385
0 0 -0.00431812 -1.178E-10
0.005848672 0.00056385
0.0651513273 0.019822354
0 0 -0.0203862 -6.197E-10
-0.065151327 0.019822354
0.0616740003 0.02082449
0.0054773268 0.00059688 -0.04124372 -1.808E-10
0.0646740003 0.009070015
-0.061674 0.02082449
0 0 -0.02989451 3.5612E-11
 ITERACCION X
3 4 5 6
3-4 4-5 5-6 6-1 5-2
38.496927271 33.31055089 34.95393112 36.434736 0
220 100 100 220 220
0.076 0.203 0.203 0.203 0.076
0.002 0.071 0.002 0.003 0
0 0 0 0 0

k AREA Hi Hj Hj-Hi
0 0.018145839 40 39.542226 0.45777
0.007853982 39.54222592 38.496927 1.0453
0.00453646 38.49692727 33.310551 5.18638
0.032365473 33.31055089 34.953931 1.64338
0.032365473 34.95393112 36.434736 1.4808
0.032365473 36.43473573 40 3.56526
0.00453646 34.95393112 39.542226 4.58829

0.0078486721 0.003754273
Q dfi/dHj dfi/dHi -fi
-0.015325999 0.016739697
-0.064674001 0.009070015
0 0 -0.02580971 -0.08
0.015325999 0.016739697
-0.007848672 0.003754273
-0.005477327 0.00059688 -0.02109085 -6.197E-11
0.0078486721 0.003754273
-0.005848672 0.00056385
0 0 -0.00431812 9.4911E-12
0.0058486721 0.00056385
0.0651513279 0.019822354
0 0 -0.0203862 3.3505E-11
-0.065151328 0.019822354
0.061674001 0.02082449
0.0054773269 0.00059688 -0.04124372 1.2041E-11
0.064674001 0.009070015
-0.061674001 0.02082449
0 0 -0.0298945 -2.774E-12

2 3 4 5 6
23 34 45 56 61
0.0078486721 0.0058486721 0.0651513279 0.061674001 0.064674001
39.5422259181 38.4969272716 33.3105508934 34.9539311262 36.43473573

ALT. PIEZOMETRICA
15.3259989852 L/S 40.00 mH2O
7.8486721267 L/S 39.54 mH2O
5.8486721172 L/S 38.50 mH2O
65.1513279163 L/S 33.31 mH2O
61.6740010078 L/S 34.95 mH2O
64.6740010051 L/S 36.43 mH2O

5.4773269205 L/S
 D(pulg) D(m) tuberia
6 0.1524003 12
4 0.1016002 23
3 0.07620015 34
8 0.20320041 45
8 0.20320041 56
8 0.20320041 61
3 0.07620015 52

Q ∑hm ∑Km+(f*L)/D dfi/DHj

0.03310934 0 11.786421359 0.008277336
0.00755953 0 21.178207624 0.0037797649
0.0056433 0 63.392343424 0.00056433
0.07100395 0 8.1531971305 0.0177509865
0.04937744 0 8.4295785688 0.0246887176
0.07589447 0 17.84073182 0.0075894469
0.00501107 0 64.317969565 0.0006263837

DF/DH
n2 n3 n4
2 -0.0126835 0.0037797649 0
3 0.00377976 -0.0043440949 0.00056433
4 0 0.00056433 -0.0183153165
5 0.00062638 0 0.0177509865
6 0 0 0

(DF/DH)^-1
-108.63594 -97.09789548 -19.8184763945
-97.097895 -320.22077328 -42.6385598204
-19.818476 -42.63855982 -195.482719251
-17.36165 -33.81381193 -144.006963251
-13.279468 -25.86329383 -110.147131944

dH2 2.1068587994
dH3 1.9928074099
dH4 1.3773575384
dH5 = 1.0396544356
dH6 1.5237783694
 4-R

8
8
0
0

Q ∑hm ∑Km+(f*L)/D dfi/DHj

0.00687573 0 14.602446877 0.03217204
0.00800899 0 21.019790447 0.0035945339
0.00600206 0 62.938520509 0.0005344241
0.06446758 0 8.2203212064 0.0193911146
0.06075435 0 8.2637723616 0.0204680847
0.06278017 0 18.126978387 0.0090299434
0.00568348 0 63.339200811 0.0005608104

DF/DH
n2 n3 n4
2 -0.0363274 0.0035945339 0
3 0.00359453 -0.004128958 0.0005344241
4 0 0.0005344241 -0.0199255387
5 0.00056081 0 0.0193911146
6 0 0 0
 (DF/DH)^-1
-30.261161 -26.969455977 -4.8294615022
-26.969456 -269.26576779 -27.7764811133
-4.8294615 -27.776481113 -182.118025316
-4.2192776 -21.120974395 -134.801706421
-2.9276713 -14.655416703 -93.5361760767

dH1 -0.6882921691
dH3 -0.6364236252
dH4 -0.3005187006
dH5 = -0.2639105343
dH6 -0.2161474386
 Q ∑hm ∑Km+(f*L)/D dfi/DHj
0.0172158 0 12.673555542 0.0148046229
0.00780748 0 21.089029313 0.003675204
0.00580877 0 63.177354782 0.0005501202
0.0652059 0 8.2121759529 0.019190566
0.06177029 0 8.2514523813 0.0201615025
0.06479231 0 18.076783245 0.0087738122
0.0054252 0 63.69188981 0.0005842564

DF/DH
n2 n3 n4
2 -0.0190641 0.003675204 0
3 0.0036752 -0.0042253242 0.0005501202
4 0 0.0005501202 -0.0197406863
5 0.00058426 0 0.019190566
6 0 0 0
 (DF/DH)^-1
-63.688078 -56.784789484 -10.6657912469
-56.784789 -290.41205212 -33.427950546
-10.665791 -33.427950546 -185.495764164
-9.3437357 -26.061198056 -137.746030295
-6.5105133 -18.158880072 -95.9784595931

dH1 0.1264308147
dH3 0.1128552224
dH4 0.0245081457
dH5 = 0.0212112143
dH6 0.0155404317
 Q ∑hm ∑Km+(f*L)/D dfi/DHj
0.01527583 0 12.596709726 0.0167865359
0.00797096 0 20.49143914 0.0037048086
0.00595724 0 61.072669044 0.0005548955
0.06623243 0 7.9441415705 0.019530584
0.06266329 0 7.9882664144 0.0205289698
0.06573102 0 17.490231886 0.0089385482
0.00557869 0 61.600429628 0.0005874723

DF/DH
n2 n3 n4
2 -0.0210788 0.0037048086 0
3 0.00370481 -0.0042597041 0.0005548955
4 0 0.0005548955 -0.0200854796
5 0.00058747 0 0.019530584
6 0 0 0
 (DF/DH)^-1
-56.52524 -50.38341503 -9.3769821003
-50.383415 -282.73310198 -31.8951144788
-9.3769821 -31.895114479 -182.239394024
-8.2119229 -24.768400759 -135.309172765
-5.7209541 -17.255262289 -94.2650794811

dH1 -0.0031646375
dH3 0.0294332355
dH4 0.2223512801
dH5 = 0.1669190651
dH6 0.1185848628
 Q ∑hm ∑Km+(f*L)/D dfi/DHj
0.0153331 0 12.5897473 0.0167330867
0.00784002 0 20.539745157 0.0037578227
0.00584179 0 61.227876515 0.0005644271
0.06508446 0 7.9579055295 0.019840694
0.06160983 0 8.002076074 0.0208439604
0.06460695 0 17.520244121 0.0090784883
0.00547071 0 61.761455299 0.0005975055

DF/DH
n2 n3 n4
2 -0.0210884 0.0037578227 0
3 0.00375782 -0.0043222498 0.0005644271
4 0 0.0005644271 -0.0204051211
5 0.00059751 0 0.019840694
6 0 0 0
 (DF/DH)^-1
-56.647881 -50.478957606 -9.4077221086
-50.478958 -279.37596306 -31.6103340378
-9.4077221 -31.610334038 -179.430083453
-8.2393295 -24.561908939 -133.233789919
-5.7395122 -17.109811516 -92.8105807533

dH2 0.0004352429
dH3 -0.0018412955
dH4 -0.0138678868
dH5 = -0.0104928259
dH6 -0.007405569
 Q ∑hm ∑Km+(f*L)/D dfi/DHj
0.01532524 0 12.590701187 0.0167404062
0.00784923 0 20.536307857 0.0037540431
0.00584905 0 61.217977364 0.000563818
0.06515489 0 7.9570497402 0.0198213777
0.06167762 0 8.0011760371 0.0208233943
0.06467768 0 17.518330798 0.009069551
0.00547771 0 61.75087235 0.0005968447

DF/DH
n2 n3 n4
2 -0.0210913 0.0037540431 0
3 0.00375404 -0.0043178611 0.000563818
4 0 0.000563818 -0.0203851957
5 0.00059684 0 0.0198213777
6 0 0 0
 (DF/DH)^-1
-56.627569 -50.461144715 -9.403527176
-50.461145 -279.59814329 -31.6283342808
-9.4035272 -31.628334281 -179.606729776
-8.2356455 -24.574846697 -133.365387153
-5.736942 -17.118812406 -92.9021886574

dH2 -4.60753018E-05
dH3 0.0001016654
dH4 0.0007603691
dH5 = 0.0005804339
dH6 0.0004063912
 Q ∑hm ∑Km+(f*L)/D dfi/DHj
0.01532607 0 12.590600152 0.0167396309
0.00784863 0 20.536530631 0.003754288
0.00584865 0 61.218518757 0.0005638513
0.06515114 0 7.9570953055 0.019822406
0.0616738 0 8.0012267095 0.020824552
0.0646738 0 17.518435656 0.0090700407
0.0054773 0 61.751478171 0.0005968825

DF/DH
n2 n3 n4
2 -0.0210908 0.003754288 0
3 0.00375429 -0.0043181393 0.0005638513
4 0 0.0005638513 -0.0203862574
5 0.00059688 0 0.019822406
6 0 0 0
 (DF/DH)^-1
-56.629877 -50.463241682 -9.4039692488
-50.463242 -279.58492646 -31.6273350606
-9.4039692 -31.627335061 -179.597046005
-8.2360321 -24.574144236 -133.358103935
-5.7372141 -17.118331378 -92.8971602493

dH2 4.28974416E-06
dH3 -0.000005633
dH4 -4.20554923E-05
dH5 = -3.23707381E-05
dH6 -2.24912673E-05
 Q ∑hm ∑Km+(f*L)/D dfi/DHj
0.01532599 0 12.590609558 0.016739703
0.00784867 0 20.536515668 0.0037542715
0.00584867 0 61.218488819 0.0005638495
0.06515134 0 7.9570928529 0.0198223507
0.06167401 0 8.0012238329 0.0208244863
0.06467401 0 17.518429853 0.0090700136
0.00547733 0 61.751442718 0.0005968803

DF/DH
n2 n3 n4
2 -0.0210909 0.0037542715 0
3 0.00375427 -0.004318121 0.0005638495
4 0 0.0005638495 -0.0203862002
5 0.00059688 0 0.0198223507
6 0 0 0
 (DF/DH)^-1
-56.629656 -50.463038038 -9.4039281694
-50.463038 -279.5857354 -31.6273908765
-9.4039282 -31.627390877 -179.597581956
-8.2359962 -24.574181975 -133.358510671
-5.7371888 -17.118356797 -92.8974388602

dH2 -3.75752484E-07
dH3 3.0778642E-07
dH4 2.32421229E-06
dH5 = 1.80289108E-06
dH6 1.24339389E-06

Q ∑hm ∑Km+(f*L)/D dfi/DHj

0.015326 0 12.590608734 0.0167396967
0.00784867 0 20.536516698 0.0037542727
0.00584867 0 61.218490476 0.0005638496
0.06515133 0 7.9570929849 0.0198223537
 0.061674 0 8.0012239958 0.02082449
0.064674 0 17.518430174 0.0090700151
0.00547733 0 61.751444825 0.0005968805

DF/DH
n2 n3 n4
2 -0.0210908 0.0037542727 0
3 0.00375427 -0.0043181222 0.0005638496
4 0 0.0005638496 -0.0203862032
5 0.00059688 0 0.0198223537
6 0 0 0

(DF/DH)^-1
-56.629675 -50.463056263 -9.4039317644
-50.463056 -279.58568486 -31.6273877923
-9.4039318 -31.627387792 -179.597552305
-8.2359993 -24.574180025 -133.358487976
-5.737191 -17.118355509 -92.8974234322

dH2 3.17866168E-08
dH3 -1.64063481E-08
dH4 -1.28373103E-07
dH5 = -1.00296879E-07
dH6 -6.86754834E-08
 Q ∑hm ∑Km+(f*L)/D dfi/DHj
0.015326 0 12.590608804 0.0167396972
0.00784867 0 20.536516626 0.0037542726
0.00584867 0 61.218490384 0.0005638496
0.06515133 0 7.9570929778 0.0198223535
0.061674 0 8.0012239866 0.0208244898
0.064674 0 17.518430156 0.009070015
0.00547733 0 61.751444697 0.0005968804

DF/DH
n2 n3 n4
2 -0.0210909 0.0037542726 0
3 0.00375427 -0.0043181221 0.0005638496
4 0 0.0005638496 -0.0203862031
5 0.00059688 0 0.0198223535
6 0 0 0

(DF/DH)^-1
 -56.629674 -50.463054703 -9.4039314604
-50.463055 -279.58568809 -31.6273879594
-9.4039315 -31.627387959 -179.597553946
-8.2359991 -24.574180119 -133.358489242
-5.7371908 -17.118355569 -92.8974242864

dH2 -2.63221821E-09
dH3 8.34333353E-10
dH4 7.0829038E-09
dH5 = 5.57037735E-09
dH6 3.78753074E-09

52
0.0054773269
 D(pulg) D(m)
6 0.1524003048
4 0.1016002032
3 0.0762001524
8 0.2032004064
8 0.2032004064
8 0.2032004064

12 0.3048006096

F/DH
n5 n6
0.0006263837 0
0 0
0.0177509865 0
-0.043066088 0.0246887176 X
0.0246887176 -0.032278165

DH)^-1
-17.36164971 -13.27946842
-33.81381193 -25.86329383
-144.0069633 -110.1471319
-147.510166 -112.8266394 X
-112.8266394 -117.2788197

H2 40.1069
H3 38.9928
H4 33.3774
H5 = 35.0397
H6 36.5238
F/DH
n5 n6
0.0005608104 0
0 0
0.0193911146 0
-0.04042001 0.0204680847 X
0.0204680847 -0.029498028
DH)^-1
-4.219277572 -2.927671321
-21.12097439 -14.6554167
-134.8017064 -93.53617608
-137.9347766 -95.71015005 X
-95.71015005 -100.3119074

H2 39.4186
H3 38.3564
H4 33.0768
H5 = 34.7757
H6 36.3076
F/DH
n5 n6
0.0005842564 0
0 0
0.019190566 0
-0.039936325 0.0201615025 X
0.0201615025 -0.028935315
DH)^-1
-9.343735746 -6.510513311
-26.06119806 -18.15888007
-137.7460303 -95.97845959
-140.9476078 -98.20924966 X
-98.20924966 -102.9899298

H2 39.545
H3 38.4692
H4 33.1013
H5 = 34.797
H6 36.3232
F/DH
n5 n6
0.0005874723 0
0 0
0.019530584 0
-0.040647026 0.0205289698 X
0.0205289698 -0.029467518
DH)^-1
-8.211922888 -5.720954078
-24.76840076 -17.25526229
-135.3091728 -94.26507948
-138.4498152 -96.45305319 X
-96.45305319 -101.1310766

H2 39.5418
H3 38.4987
H4 33.3237
H5 = 34.9639
H6 36.4418
F/DH
n5 n6
0.0005975055 0
0 0
0.019840694 0
-0.04128216 0.0208439604 X
0.0208439604 -0.029922449
DH)^-1
-8.23932951 -5.739512156
-24.56190894 -17.10981152
-133.2337899 -92.81058075
-136.3252825 -94.96411272 X
-94.96411272 -99.57167064

H2 39.5423 mH2O
H3 38.4968 mH2O
H4 33.3098 mH2O
H5 = 34.9534 mH2O
H6 36.4344 mH2O
F/DH
n5 n6
0.0005968447 0
0 0
0.0198213777 0
-0.041241617 0.0208233943 X
0.0208233943 -0.029892945
DH)^-1
-8.235645503 -5.73694201
-24.5748467 -17.11881241
-133.3653872 -92.90218866
-136.4599281 -95.05784263 X
-95.05784263 -99.66990242

H2 39.5422
H3 38.4969
H4 33.3106
H5 = 34.954
H6 36.4348
F/DH
n5 n6
0.0005968825 0
0 0
0.019822406 0
-0.041243841 0.020824552 X
0.020824552 -0.029894593
DH)^-1
-8.236032095 -5.737214093
-24.57414424 -17.11833138
-133.3581039 -92.89716025
-136.45248 -95.05270039 X
-95.05270039 -99.66450889

H2 39.5422
H3 38.4969
H4 33.3105
H5 = 34.9539
H6 36.4347
F/DH
n5 n6
0.0005968803 0
0 0
0.0198223507 0
-0.041243717 0.0208244863 X
0.0208244863 -0.0298945
DH)^-1
-8.235996194 -5.737188793
-24.57418197 -17.1183568
-133.3585107 -92.89743886
-136.4528957 -95.05298518 X
-95.05298518 -99.66480778

H2 39.5422
H3 38.4969
H4 33.3106
H5 = 34.9539
H6 36.4347
F/DH
n5 n6
0.0005968805 0
0 0
0.0198223537 0
-0.041243724 0.02082449 X
0.02082449 -0.029894505

DH)^-1
-8.235999337 -5.737191006
-24.57418003 -17.11835551
-133.358488 -92.89742343
-136.4528725 -95.05296941 X
-95.05296941 -99.66479123

H2 39.5422
H3 38.4969
H4 33.3106
H5 = 34.9539
H6 36.4347
F/DH
n5 n6
0.0005968804 0
0 0
0.0198223535 0
-0.041243724 0.0208244898 X
0.0208244898 -0.029894505

DH)^-1
-8.235999071 -5.737190819
-24.57418012 -17.11835557
-133.3584892 -92.89742429
-136.4528738 -95.05297028 X
-95.05297028 -99.66479215

H2 39.5422 mH2o
H3 38.4969 mH2o
H4 33.3106 mH2o
H5 = 34.9539 mH2o
H6 36.4347 mH2o
DH f(negativo)

dH2 -0.018538745
dH3 8.377059E-05
dH4 -0.005647246
dH5 = 0.0186154417
dH6 -0.023517034
-0.018538745 2.1068587994
8.377059E-05 1.9928074099
-0.005647246 1.3773575384
0.018615442 = 1.0396544356
-0.023517034 1.5237783694
DH f(negativo)

dH2 0.0225682041
dH3 -6.927554E-06
dH4 0.0005303575
dH5 = 2.97483E-05
dH6 0.00097418
-43471
-0.203
0.022568204 -0.688292169
-6.92755E-06 -0.636423625
0.000530357 -0.300518701
2.97483E-05 = -0.263910534
0.00097418 -0.216147439
DH f(negativo)

dH2 -0.001983129
dH3 1.291558E-06
dH4 -1.466847E-05
dH5 = 1.04137E-05
dH6 -2.201733E-05
-43471
-0.203
-0.001983129 0.1264308147
1.291558E-06 0.1128552224
-1.46685E-05 0.0245081457
1.04137E-05 = 0.0212112143
-2.20173E-05 0.0155404317
DH f(negativo)

dH2 0.0002738116
dH3 -1.371952E-05
dH4 -0.001189673
dH5 = -9.547317E-06
dH6 -6.772513E-05
0.000273812 -0.003164638
-1.37195E-05 0.0294332355
-0.001189673 0.2223512801
-9.54732E-06 = 0.1669190651
-6.77251E-05 0.1185848628
DH f(negativo)

dH2 -2.236736E-05
dH3 1.766693E-06
dH4 7.375169E-05
dH5 = 3.916688E-06
dH6 2.880712E-06
-43471
-0.203
-2.23674E-05 0.0004352429
1.766693E-06 -0.001841296
7.375169E-05 -0.013867887
3.916688E-06 = -0.010492826
2.880712E-06 -0.007405569
DH f(negativo)

dH2 1.699873E-06
dH3 -1.83236E-07
dH4 -0.000003938
dH5 = -4.315257E-07
dH6 -6.162528E-08
-43471
-0.203
1.699873E-06 -4.60753E-05
-1.83236E-07 0.0001016654
-0.000003938 0.0007603691
-4.31526E-07 = 0.0005804339
-6.16253E-08 0.0004063912
DH f(negativo)

dH2 -1.309437E-07
dH3 1.671615E-08
dH4 2.12512E-07
dH5 = 3.564243E-08
dH6 -1.738844E-09
-43471
-0.203
-1.30944E-07 4.289744E-06
1.671615E-08 -0.000005633
2.12512E-07 -4.205549E-05
3.564243E-08 = -3.237074E-05
-1.73884E-09 -2.249127E-05
DH f(negativo)

dH2 1.015657E-08
dH3 -1.42923E-09
dH4 -1.147077E-08
dH5 = -2.617819E-09
dH6 3.736419E-10
-43471
-0.203
1.015657E-08 -3.757525E-07
-1.42923E-09 3.077864E-07
-1.14708E-08 2.324212E-06
-2.61782E-09 = 1.802891E-06
3.736419E-10 1.243394E-06
 DH f(negativo)

dH2 -7.918659E-10
dH3 1.177971E-10
dH4 6.196692E-10
dH5 = 1.808006E-10
dH6 -3.561176E-11
-43471
-0.203

-7.91866E-10 3.178662E-08
1.177971E-10 -1.640635E-08
6.196692E-10 -1.283731E-07
1.808006E-10 = -1.002969E-07
-3.56118E-11 -6.867548E-08
DH f(negativo)

dH2 6.197288E-11
dH3 -9.491126E-12
dH4 -3.350509E-11
dH5 = -1.204101E-11
dH6 2.77391E-12
-43471
-0.203
6.197288E-11 -2.632218E-09
-9.49113E-12 8.343334E-10
-3.35051E-11 7.082904E-09
-1.2041E-11 = 5.570377E-09
2.77391E-12 3.787531E-09
Tuberia LONGDIAMETRO
3-4 220 0.076
k AREA Hi Hj Hj-Hi Q ∑hm ∑Km+(f*L)/D

0 0.00453646 5-Feb 32 5 0.00573527 0 61.3754475

5 0.00573527 0 61.3754475
 dfi/DHj Tuberia LONG DIAMETRO k AREA Hi

0.00057353 4-5 100 0.203 0 0.03236547 32

0.00057353
Hj Hj-Hi Q ∑hm ∑Km+(f*L)/D dfi/DHj Tuberia

34 2 0.0722332 0 7.87805874 0.0180583 5-6

2 0.0722332 0 7.87805874 0.0180583

LONG DIAMETRO k AREA Hi Hj Hj-Hi Q

100 0.203 0 0.03236547 34 35 1 0.05011884

1 0.05011884
∑hm ∑Km+(f*L)/D dfi/DHj Tuberia LONG DIAMETRO k

0 8.18202796 0.02505942 6-1 220 0.203 0

0 8.18202796 0.02505942
 AREA Hi Hj Hj-Hi Q ∑hm ∑Km+(f*L)/D dfi/DHj

0.03236547 35 40 5 0.07723953 0 17.2247794 0.00772395

5 0.07723953 0 17.2247794 0.00772395

Tuberia LONG DIAMETRO k AREA Hi Hj

5-2 220 0.076 0 0.00453646 34 38

Hj-Hi Q ∑hm ∑Km+(f*L)/D dfi/DHj Tuberia LONG

4 0.00508856 0 62.3739773 0.00063607 6-3 8

4 0.00508856 0 62.3739773 0.00063607

DIAMETRO k AREA Hi Hj Hj-Hi Q ∑hm

8 3 50.2654825 35 37 2 3648.01506 805.370627

803.370627 73301.7469 325170.539

∑Km+(f*L)/D dfi/DHj

0.00744999 912.0037652

0.00741184 45.621376
 0

#DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!