Excel Metodo Cross para fluidos
-
Upload
edward-mantilla-romero -
Category
Documents
-
view
225 -
download
0
Transcript of Excel Metodo Cross para fluidos
-
7/24/2019 Excel Metodo Cross para fluidos
1/42
TRAMO L Q1 S
AB 50 900 180 2.60
BE 40 1200 55 0.86
EF 40 900 -80 -1.72
FA 60 1200 -220 -1.55
BC 50 900 125 1.33
CD 40 1200 85 1.93
DE 30 900 -60 -4.10
EB 40 1200 -55 -0.86
FE 40 900 80 1.72
EH 30 1200 55 3.49
HG 40 900 -60 -1.01
GF 40 1200 -140 -4.85
ED 30 900 60 4.10
DI 30 1200 45 2.41
IH 30 900 -35 -1.51
HE 30 1200 -55 -3.49
TRAMO L Q1 S
AB 50 900 180.34 2.61BE 40 1200 49.69 0.71
EF 40 900 -83.16 -1.85
FA 60 1200 -219.66 -1.55
BC 50 900 130.64 1.44
CD 40 1200 90.64 2.17
DE 30 900 -52.05 -3.15
EB 40 1200 -49.69 -0.71
FE 40 900 83.16 1.85EH 30 1200 60.81 4.21
HG 40 900 -56.50 -0.90
GF 40 1200 -136.50 -4.62
ED 30 900 52.05 3.15
DI 30 1200 42.69 2.19
IH 30 900 -37.31 -1.70
HE 30 1200 -60.81 -4.21
-
7/24/2019 Excel Metodo Cross para fluidos
2/42
TRAMO L Q1 S
AB 50 900 183.24 2.69
BE 40 1200 53.59 0.82
EF 40 900 -79.07 -1.68
FA 60 1200 -216.76 -1.51
BC 50 900 129.65 1.42
CD 40 1200 89.65 2.12
DE 30 900 -55.56 -3.56
EB 40 1200 -53.59 -0.82
FE 40 900 79.07 1.68
EH 30 1200 57.10 3.74
HG 40 900 -57.69 -0.94
GF 40 1200 -137.69 -4.70
ED 30 900 55.56 3.56
DI 30 1200 45.21 2.43
IH 30 900 -34.79 -1.50
HE 30 1200 -57.10 -3.74
TRAMO L Q1 S
AB 50 900 182.54 2.67
BE 40 1200 51.18 0.75EF 40 900 -81.45 -1.78
FA 60 1200 -217.46 -1.52
BC 50 900 131.36 1.45
CD 40 1200 91.36 2.20
DE 30 900 -53.22 -3.29
EB 40 1200 -51.18 -0.75
FE 40 900 81.45 1.78
EH 30 1200 59.41 4.03HG 40 900 -56.01 -0.89
GF 40 1200 -136.01 -4.59
ED 30 900 53.22 3.29
DI 30 1200 44.58 2.37
IH 30 900 -35.42 -1.55
HE 30 1200 -59.41 -4.03
-
7/24/2019 Excel Metodo Cross para fluidos
3/42
TRAMO L Q1 S
AB 50 900 183.61 2.70
BE 40 1200 52.67 0.79
EF 40 900 -79.95 -1.72
FA 60 1200 -216.39 -1.51
BC 50 900 130.94 1.44
CD 40 1200 90.94 2.18
DE 30 900 -54.60 -3.45
EB 40 1200 -52.67 -0.79
FE 40 900 79.95 1.72
EH 30 1200 58.02 3.86
HG 40 900 -56.43 -0.90
GF 40 1200 -136.43 -4.62
ED 30 900 54.60 3.45
DI 30 1200 45.54 2.46
IH 30 900 -34.46 -1.47
HE 30 1200 -58.02 -3.86
TRAMO L Q1 S
AB 50 900 183.35 2.69
BE 40 1200 51.75 0.77
EF 40 900 -80.86 -1.76FA 60 1200 -216.65 -1.51
BC 50 900 131.59 1.46
CD 40 1200 91.59 2.21
DE 30 900 -53.71 -3.34
EB 40 1200 -51.75 -0.77
FE 40 900 80.86 1.76
EH 30 1200 58.90 3.96
HG 40 900 -55.80 -0.88GF 40 1200 -135.80 -4.58
ED 30 900 53.71 3.34
DI 30 1200 45.30 2.44
IH 30 900 -34.70 -1.49
HE 30 1200 -58.90 -3.96
-
7/24/2019 Excel Metodo Cross para fluidos
4/42
TRAMO L Q1 S
AB 50 900 183.75 2.70
BE 40 1200 52.32 0.78
EF 40 900 -80.29 -1.73
FA 60 1200 -216.25 -1.50
BC 50 900 131.43 1.45CD 40 1200 91.43 2.20
DE 30 900 -54.24 -3.40
EB 40 1200 -52.32 -0.78
FE 40 900 80.29 1.73
EH 30 1200 58.38 3.90
HG 40 900 -55.96 -0.89
GF 40 1200 -135.96 -4.59
ED 30 900 54.24 3.40DI 30 1200 45.67 2.48
IH 30 900 -34.33 -1.46
HE 30 1200 -58.38 -3.90
TRAMO L Q1 S
AB 50 900 183.65 2.70
BE 40 1200 51.97 0.77
EF 40 900 -80.63 -1.75
FA 60 1200 -216.35 -1.50
BC 50 900 131.68 1.46
CD 40 1200 91.68 2.21
DE 30 900 -53.90 -3.36
EB 40 1200 -51.97 -0.77
FE 40 900 80.63 1.75
EH 30 1200 58.71 3.94
HG 40 900 -55.72 -0.88
GF 40 1200 -135.72 -4.58
ED 30 900 53.90 3.36
DI 30 1200 45.58 2.47
IH 30 900 -34.42 -1.47
HE 30 1200 -58.71 -3.94
TRAMO L Q1 S
-
7/24/2019 Excel Metodo Cross para fluidos
5/42
AB 50 900 183.81 2.70
BE 40 1200 52.19 0.78
EF 40 900 -80.42 -1.74
FA 60 1200 -216.19 -1.50
BC 50 900 131.62 1.46
CD 40 1200 91.62 2.21DE 30 900 -54.10 -3.39
EB 40 1200 -52.19 -0.78
FE 40 900 80.42 1.74
EH 30 1200 58.51 3.92
HG 40 900 -55.78 -0.88
GF 40 1200 -135.78 -4.58
ED 30 900 54.10 3.39
DI 30 1200 45.72 2.48IH 30 900 -34.28 -1.46
HE 30 1200 -58.51 -3.92
TRAMO L Q1 S
AB 50 900 183.77 2.70
BE 40 1200 52.06 0.78
EF 40 900 -80.55 -1.74
FA 60 1200 -216.23 -1.50
BC 50 900 131.71 1.46
CD 40 1200 91.71 2.22
DE 30 900 -53.97 -3.37
EB 40 1200 -52.06 -0.78
FE 40 900 80.55 1.74
EH 30 1200 58.64 3.93
HG 40 900 -55.68 -0.88
GF 40 1200 -135.68 -4.57
ED 30 900 53.97 3.37
DI 30 1200 45.68 2.48
IH 30 900 -34.32 -1.46
HE 30 1200 -58.64 -3.93
-
7/24/2019 Excel Metodo Cross para fluidos
6/42
HL HL/Q1
2.34 0.013 0.3355 0.3355
1.03 0.019 0.3355 5.6432 -5.3077
-1.55 0.019 0.3355 3.4957 -3.1601
-1.86 0.008 0.3355 0.3355-0.037 0.0596
1.19 0.010 5.6432 5.6432
2.31 0.027 5.6432 5.6432
-3.69 0.062 5.6432 -2.3118 7.9550
-1.03 0.019 5.6432 0.3355 5.3077
-1.222 0.117
1.55 0.019 3.4957 0.3355 3.1601
4.19 0.076 3.4957 -2.3118 5.8075
-0.91 0.015 3.4957 3.4957
-5.82 0.042 3.4957 3.4957-0.987 0.1523
3.69 0.062 -2.3118 5.6432 -7.9550
2.89 0.064 -2.3118 -2.3118
-1.36 0.039 -2.3118 -2.3118
-4.19 0.076 -2.3118 3.4957 -5.8075
1.030 0.209
HL HL/Q1
2.35 0.013 2.9043 2.90430.86 0.017 2.9043 -0.9915 3.8958
-1.66 0.020 2.9043 -1.1869 4.0912
-1.86 0.008 2.9043 2.9043
-0.315 0.0587
1.29 0.010 -0.9915 -0.9915
2.60 0.029 -0.9915 -0.9915
-2.84 0.055 -0.9915 2.5199 -3.5114
-0.86 0.017 -0.9915 2.9043 -3.8958
0.202 0.110
1.66 0.020 -1.1869 2.9043 -4.09125.05 0.083 -1.1869 2.5199 -3.7068
-0.81 0.014 -1.1869 -1.1869
-5.55 0.041 -1.1869 -1.1869
0.371 0.1581
2.84 0.055 2.5199 -0.9915 3.5114
2.62 0.061 2.5199 2.5199
-1.53 0.041 2.5199 2.5199
-5.05 0.083 2.5199 -1.1869 3.7068
-
7/24/2019 Excel Metodo Cross para fluidos
7/42
-1.1191 0.201
HL HL/Q1
2.42 0.013 -0.7014 -0.7014
0.98 0.018 -0.7014 1.7059 -2.4073
-1.52 0.019 -0.7014 1.6803 -2.3818
-1.81 0.008 -0.7014 -0.70140.077 0.0591
1.28 0.010 1.7059 1.7059
2.55 0.028 1.7059 1.7059
-3.20 0.058 1.7059 -0.6301 2.3360
-0.98 0.018 1.7059 -0.7014 2.4073
-0.361 0.11
1.52 0.019 1.6803 -0.7014 2.3818
4.49 0.079 1.6803 -0.6301 2.3105
-0.85 0.015 1.6803 1.6803
-5.64 0.041 1.6803 1.6803-0.770 0.1535
3.20 0.058 -0.6301 1.7059 -2.3360
2.92 0.065 -0.6301 -0.6301
-1.35 0.039 -0.6301 -0.6301
-4.49 0.079 -0.6301 1.6803 -2.3105
0.2792 0.2395
HL HL/Q1
2.40 0.013 1.0747 1.0747
0.90 0.018 1.0747 -0.4142 1.4889-1.60 0.020 1.0747 -0.4238 1.4985
-1.82 0.008 1.0747 1.0747
-0.117 0.0589
1.31 0.010 -0.4142 -0.4142
2.64 0.029 -0.4142 -0.4142
-2.96 0.056 -0.4142 0.9632 -1.3775
-0.90 0.018 -0.4142 1.0747 -1.4889
0.086 0.112
1.60 0.020 -0.4238 1.0747 -1.4985
4.83 0.081 -0.4238 0.9632 -1.3871-0.80 0.014 -0.4238 -0.4238
-5.51 0.041 -0.4238 -0.4238
0.1222 0.1559
2.96 0.056 0.9632 -0.4142 1.3775
2.84 0.064 0.9632 0.9632
-1.39 0.039 0.9632 0.9632
-4.83 0.081 0.9632 -0.4238 1.3871
-0.277 0.200
-
7/24/2019 Excel Metodo Cross para fluidos
8/42
-
7/24/2019 Excel Metodo Cross para fluidos
9/42
HL HL/Q1
2.43 0.013 -0.1012 -0.1012
0.94 0.018 -0.1012 0.2461 -0.3474
-1.56 0.019 -0.1012 0.2416 -0.3428
-1.80 0.008 -0.1012 -0.1012
0.011 0.0590
1.31 0.010 0.2461 0.24612.64 0.029 0.2461 0.2461
-3.06 0.056 0.2461 -0.0907 0.3369
-0.94 0.018 0.2461 -0.1012 0.3474
-0.052 0.113
1.56 0.019 0.2416 -0.1012 0.3428
4.68 0.080 0.2416 -0.0907 0.3323
-0.80 0.014 0.2416 0.2416
-5.51 0.041 0.2416 0.2416
-0.0690 0.15
3.06 0.056 -0.0907 0.2461 -0.33692.97 0.065 -0.0907 -0.0907
-1.31 0.038 -0.0907 -0.0907
-4.68 0.080 -0.0907 0.2416 -0.3323
0.003 0.200
HL HL/Q1
2.43 0.013 0.1546 0.1546
0.93 0.018 0.1546 -0.0609 0.2155
-1.57 0.019 0.1546 -0.0601 0.2147
-1.81 0.008 0.1546 0.1546-0.017 0.0590
1.31 0.010 -0.0609 -0.0609
2.66 0.029 -0.0609 -0.0609
-3.03 0.056 -0.0609 0.1386 -0.1996
-0.93 0.018 -0.0609 0.1546 -0.2155
0.013 0.113
1.57 0.019 -0.0601 0.1546 -0.2147
4.73 0.081 -0.0601 0.1386 -0.1988
-0.79 0.014 -0.0601 -0.0601
-5.49 0.040 -0.0601 -0.06010.0172 0.157
3.03 0.056 0.1386 -0.0609 0.1996
2.96 0.065 0.1386 0.1386
-1.32 0.038 0.1386 0.1386
-4.73 0.081 0.1386 -0.0601 0.1988
-0.0616 0.201
HL HL/Q1
-
7/24/2019 Excel Metodo Cross para fluidos
10/42
2.43 0.013 -0.0384 -0.0384
0.94 0.018 -0.0384 0.0934 -0.1318
-1.56 0.019 -0.0384 0.0916 -0.1300
-1.80 0.008 -0.0384 -0.0384
0.00 0.0590
1.31 0.010 0.0934 0.0934
2.65 0.029 0.0934 0.0934-3.05 0.056 0.0934 -0.0344 0.1278
-0.94 0.018 0.0934 -0.0384 0.1318
-0.020 0.113
1.56 0.019 0.0916 -0.0384 0.1300
4.70 0.080 0.0916 -0.0344 0.1260
-0.79 0.014 0.0916 0.0916
-5.49 0.040 0.0916 0.0916
-0.0262 0.155
3.05 0.056 -0.0344 0.0934 -0.1278
2.98 0.065 -0.0344 -0.0344-1.31 0.038 -0.0344 -0.0344
-4.70 0.080 -0.0344 0.0916 -0.1260
0.0153 0.200
HL HL/Q1
2.43 0.013 0.0586 0.0586
0.93 0.018 0.0586 -0.0232 0.0818
-1.57 0.019 0.0586 -0.0228 0.081
-1.80 0.008 0.0586 0.0586
-0.006 0.05901.31 0.010 -0.0232 -0.0232
2.66 0.029 -0.0232 -0.0232
-3.04 0.056 -0.0232 0.0526 -0.0758
-0.93 0.018 -0.0232 0.0586 -0.0818
0.005 0.113
1.57 0.019 -0.0228 0.0586 -0.081
4.72 0.080 -0.0228 0.0526 -0.075
-0.79 0.014 -0.0228 -0.0228
-5.49 0.040 -0.0228 -0.0228
0.0065 0.1563.04 0.056 0.0526 -0.0232 0.0758
2.97 0.065 0.0526 0.0526
-1.31 0.038 0.0526 0.0526
-4.72 0.080 0.0526 -0.0228 0.075
-0.023 0.201
-
7/24/2019 Excel Metodo Cross para fluidos
11/42
Q2
180.3
9.69
-83.16
-219.66
130.6
90.6
-52.05
-9.69
83.16
60.81
-56.50
-136.50
52.05
2.69
-37.31
-60.81
Q2
183.2453.59
-79.07
-216.76
129.65
89.65
-55.56
-53.59
79.0757.10
-57.69
-137.69
55.56
45.21
-34.79
-57.10
-
7/24/2019 Excel Metodo Cross para fluidos
12/42
Q2
182.54
51.18
-81.45
-217.46
131.36
91.36
-53.22
-51.18
81.45
59.41
-56.01
-136.01
53.22
44.58
-35.42
-59.41
Q2
183.61
52.67-79.95
-216.39
130.94
90.94
-54.60
-52.67
79.95
58.02-56.43
-136.43
54.60
45.54
-34.46
-58.02
-
7/24/2019 Excel Metodo Cross para fluidos
13/42
Q2
183.35
51.75
-80.86
-216.65
131.59
91.59
-53.71
-51.75
80.86
58.90
-55.80
-135.80
53.71
45.30
-34.70
-58.90
Q2
183.75
52.32
-80.29-216.25
131.43
91.43
-54.24
-52.32
80.29
58.38
-55.96-135.96
54.24
45.67
-34.33
-58.38
-
7/24/2019 Excel Metodo Cross para fluidos
14/42
Q2
183.65
51.97
-80.63
-216.35
131.6891.68
-53.90
-51.97
80.63
58.71
-55.72
-135.72
53.9045.58
-34.42
-58.71
Q2
183.81
52.19
-80.42
-216.19
131.62
91.62
-54.10
-52.19
80.42
58.51
-55.78
-135.78
54.10
45.72
-34.28
-58.51
Q2
-
7/24/2019 Excel Metodo Cross para fluidos
15/42
183.77
52.06
-80.55
-216.23
131.71
91.71-53.97
-52.06
80.55
58.64
-55.68
-135.68
53.97
45.68-34.32
-58.64
Q2
183.83
52.14
-80.47
-216.17
131.69
91.69
-54.05
-52.14
80.47
58.56
-55.71
-135.71
54.05
45.73
-34.27
-58.56
-
7/24/2019 Excel Metodo Cross para fluidos
16/42
TRAMO L Q1 S
AB 50 1000 250 3.41
BE 40 1200 125 3.93
EF 30 1000 -125 -15.95
FA 60 1200 -250 -1.97
BC 50 1000 125 1.33
CD 40 1200 25 0.20
DE 40 1000 -75 -1.53
EB 40 1200 -125 -3.93
FE 30 1000 125 15.95
EH 30 1200 75 6.20
HG 40 1000 -25 -0.20
GF 40 1200 -125 -3.93
ED 40 1000 75 1.53
DI 30 1200 50 2.93
IH 30 1000 -50 -2.93
HE 30 1200 -75 -6.20
TRAMO L Q1 S
AB 50 900 279.22 5.86BE 40 1200 121.93 3.75
EF 40 900 -59.14 -0.98
FA 60 1200 -220.78 -1.56
BC 50 900 157.29 2.03
CD 40 1200 57.29 0.93
DE 30 900 -54.30 -3.41
EB 40 1200 -121.93 -3.75
FE 40 900 59.14 0.98EH 30 1200 26.76 0.92
HG 40 900 -61.64 -1.06
GF 40 1200 -161.64 -6.32
ED 30 900 54.30 3.41
DI 30 1200 61.59 4.31
IH 30 900 -38.41 -1.80
HE 30 1200 -26.76 -0.92
-
7/24/2019 Excel Metodo Cross para fluidos
17/42
TRAMO L Q1 S
AB 50 900 231.37 4.14
BE 40 1200 53.96 0.83
EF 40 900 -136.81 -4.64
FA 60 1200 -268.63 -2.25
BC 50 900 177.41 2.53
CD 40 1200 77.41 1.62
DE 30 900 -20.87 -0.58
EB 40 1200 -53.96 -0.83
FE 40 900 136.81 4.64
EH 30 1200 69.90 5.44
HG 40 900 -31.82 -0.31
GF 40 1200 -131.82 -4.33
ED 30 900 20.87 0.58
DI 30 1200 48.28 2.74
IH 30 900 -51.72 -3.12
HE 30 1200 -69.90 -5.44
TRAMO L Q1 S
AB 50 900 246.84 4.67
BE 40 1200 87.36 2.03EF 40 900 -104.94 -2.84
FA 60 1200 -253.16 -2.01
BC 50 900 159.48 2.08
CD 40 1200 59.48 0.99
DE 30 900 -51.18 -3.06
EB 40 1200 -87.36 -2.03
FE 40 900 104.94 2.84
EH 30 1200 41.12 2.04HG 40 900 -48.22 -0.67
GF 40 1200 -148.22 -5.39
ED 30 900 51.18 3.06
DI 30 1200 60.66 4.19
IH 30 900 -39.34 -1.88
HE 30 1200 -41.12 -2.04
-
7/24/2019 Excel Metodo Cross para fluidos
18/42
TRAMO L Q1 S
AB 50 900 235.47 4.28
BE 40 1200 65.90 1.20
EF 40 900 -124.27 -3.89
FA 60 1200 -264.53 -2.18
BC 50 900 169.57 2.33
CD 40 1200 69.57 1.33
DE 30 900 -32.87 -1.35
EB 40 1200 -65.90 -1.20
FE 40 900 124.27 3.89
EH 30 1200 57.31 3.77
HG 40 900 -40.26 -0.48
GF 40 1200 -140.26 -4.86
ED 30 900 32.87 1.35
DI 30 1200 52.44 3.20
IH 30 900 -47.56 -2.67
HE 30 1200 -57.31 -3.77
TRAMO L Q1 S
AB 50 900 241.32 4.48
BE 40 1200 77.71 1.63
EF 40 900 -112.49 -3.23FA 60 1200 -258.68 -2.09
BC 50 900 163.61 2.18
CD 40 1200 63.61 1.13
DE 30 900 -43.05 -2.22
EB 40 1200 -77.71 -1.63
FE 40 900 112.49 3.23
EH 30 1200 47.14 2.63
HG 40 900 -46.19 -0.62GF 40 1200 -146.19 -5.25
ED 30 900 43.05 2.22
DI 30 1200 56.67 3.69
IH 30 900 -43.33 -2.25
HE 30 1200 -47.14 -2.63
-
7/24/2019 Excel Metodo Cross para fluidos
19/42
TRAMO L Q1 S
AB 50 900 237.40 4.34
BE 40 1200 70.48 1.36
EF 40 900 -119.34 -3.61
FA 60 1200 -262.60 -2.15
BC 50 900 166.92 2.26CD 40 1200 66.92 1.24
DE 30 900 -36.90 -1.67
EB 40 1200 -70.48 -1.36
FE 40 900 119.34 3.61
EH 30 1200 52.91 3.25
HG 40 900 -43.27 -0.55
GF 40 1200 -143.27 -5.06
ED 30 900 36.90 1.67DI 30 1200 53.82 3.36
IH 30 900 -46.18 -2.53
HE 30 1200 -52.91 -3.25
TRAMO L Q1 S
AB 50 900 239.43 4.41
BE 40 1200 74.63 1.51
EF 40 900 -115.27 -3.38
FA 60 1200 -260.57 -2.12
BC 50 900 164.80 2.21
CD 40 1200 64.80 1.17
DE 30 900 -40.49 -1.98
EB 40 1200 -74.63 -1.51
FE 40 900 115.27 3.38
EH 30 1200 49.41 2.86
HG 40 900 -45.30 -0.60
GF 40 1200 -145.30 -5.19
ED 30 900 40.49 1.98
DI 30 1200 55.29 3.53
IH 30 900 -44.71 -2.38
HE 30 1200 -49.41 -2.86
TRAMO L Q1 S
-
7/24/2019 Excel Metodo Cross para fluidos
20/42
AB 50 900 238.07 4.36
BE 40 1200 72.14 1.42
EF 40 900 -117.67 -3.51
FA 60 1200 -261.93 -2.14
BC 50 900 165.92 2.24
CD 40 1200 65.92 1.20DE 30 900 -38.38 -1.79
EB 40 1200 -72.14 -1.42
FE 40 900 117.67 3.51
EH 30 1200 51.43 3.09
HG 40 900 -44.27 -0.58
GF 40 1200 -144.27 -5.12
ED 30 900 38.38 1.79
DI 30 1200 54.30 3.41IH 30 900 -45.70 -2.48
HE 30 1200 -51.43 -3.09
TRAMO L Q1 S
AB 50 900 238.77 4.39
BE 40 1200 73.59 1.47
EF 40 900 -116.26 -3.44
FA 60 1200 -261.23 -2.13
BC 50 900 165.18 2.22
CD 40 1200 65.18 1.18
DE 30 900 -39.63 -1.90
EB 40 1200 -73.59 -1.47
FE 40 900 116.26 3.44
EH 30 1200 50.22 2.95
HG 40 900 -44.97 -0.59
GF 40 1200 -144.97 -5.17
ED 30 900 39.63 1.90
DI 30 1200 54.81 3.47
IH 30 900 -45.19 -2.43
HE 30 1200 -50.22 -2.95
TRAMO L Q1 S
AB 50 900 238.30 4.37
-
7/24/2019 Excel Metodo Cross para fluidos
21/42
BE 40 1200 72.73 1.44
EF 40 900 -117.09 -3.48
FA 60 1200 -261.70 -2.14
BC 50 900 165.57 2.23
CD 40 1200 65.57 1.19
DE 30 900 -38.90 -1.84EB 40 1200 -72.73 -1.44
FE 40 900 117.09 3.48
EH 30 1200 50.92 3.03
HG 40 900 -44.61 -0.58
GF 40 1200 -144.61 -5.15
ED 30 900 38.90 1.84
DI 30 1200 54.47 3.43
IH 30 900 -45.53 -2.46HE 30 1200 -50.92 -3.03
TRAMO L Q1 S
AB 50 900 238.54 4.38
BE 40 1200 73.23 1.46
EF 40 900 -116.61 -3.46
FA 60 1200 -261.46 -2.14
BC 50 900 165.31 2.22CD 40 1200 65.31 1.18
DE 30 900 -39.34 -1.88
EB 40 1200 -73.23 -1.46
FE 40 900 116.61 3.46
EH 30 1200 50.50 2.98
HG 40 900 -44.85 -0.59
GF 40 1200 -144.85 -5.16
ED 30 900 39.34 1.88DI 30 1200 54.65 3.45
IH 30 900 -45.35 -2.44
HE 30 1200 -50.50 -2.98
TRAMO L Q1 S
AB 50 900 238.38 4.38
BE 40 1200 72.94 1.45
-
7/24/2019 Excel Metodo Cross para fluidos
22/42
EF 40 900 -116.90 -3.47
FA 60 1200 -261.62 -2.14
BC 50 900 165.44 2.23
CD 40 1200 65.44 1.19
DE 30 900 -39.08 -1.86
EB 40 1200 -72.94 -1.45
FE 40 900 116.90 3.47
EH 30 1200 50.75 3.01
HG 40 900 -44.73 -0.59
GF 40 1200 -144.73 -5.15
ED 30 900 39.08 1.86
DI 30 1200 54.53 3.44
IH 30 900 -45.47 -2.46
HE 30 1200 -50.75 -3.01
-
7/24/2019 Excel Metodo Cross para fluidos
23/42
HL HL/Q1
3.41 0.014 29.2199 29.2199
4.72 0.038 29.2199 32.2895 -3.0696
-15.95 0.128 29.2199 -36.6439 65.8638
-2.36 0.009 29.2199 29.2199-10.18 0.188
1.33 0.011 32.2895 32.2895
0.24 0.010 32.2895 32.2895
-1.53 0.020 32.2895 11.5914 20.6981
-4.72 0.038 32.2895 29.2199 3.0696
-.677 0.078
15.95 0.128 -36.6439 29.2199 -65.8638
7.44 0.099 -36.6439 11.5914 -48.2353
-0.20 0.008 -36.6439 -36.6439
-4.72 0.038 -36.6439 -36.643918.72 0.2725
1.53 0.020 11.5914 32.2895 -20.6981
3.51 0.070 11.5914 11.5914
-2.93 0.059 11.5914 11.5914
-7.44 0.099 11.5914 -36.6439 48.2353
-5.326 0.28
HL HL/Q1
5.28 0.019 -47.8472 -47.84724.50 0.037 -47.8472 20.1229 -67.9701
-0.89 0.015 -47.8472 29.8262 -77.6733
-1.87 0.008 -47.8472 -47.8472
7.019 0.0793
1.82 0.012 20.1229 20.1229
1.11 0.019 20.1229 20.1229
-3.07 0.057 20.1229 -13.3136 33.4365
-4.50 0.037 20.1229 -47.8472 67.9701
-.635 0.125
0.89 0.015 29.8262 -47.8472 77.67331.11 0.041 29.8262 -13.3136 43.1398
-0.96 0.016 29.8262 29.8262
-7.59 0.047 29.8262 29.8262
-6.5516 0.1187
3.07 0.057 -13.3136 20.1229 -33.4365
5.17 0.084 -13.3136 -13.3136
-1.62 0.042 -13.3136 -13.3136
-1.11 0.041 -13.3136 29.8262 -43.1398
-
7/24/2019 Excel Metodo Cross para fluidos
24/42
5.5139 0.2239
HL HL/Q1
3.73 0.016 15.4712 15.4712
1.00 0.018 15.4712 -17.9300 33.4012
-4.18 0.031 15.4712 -16.4003 31.8715
-2.70 0.010 15.4712 15.4712-2.151 0.0752
2.28 0.013 -17.9300 -17.9300
1.94 0.025 -17.9300 -17.9300
-0.52 0.025 -17.9300 12.3843 -30.3144
-1.00 0.018 -17.9300 15.4712 -33.4012
2.703 0.081
4.18 0.031 -16.4003 15.4712 -31.8715
6.53 0.093 -16.4003 12.3843 -28.7847
-0.28 0.009 -16.4003 -16.4003
-5.20 0.039 -16.4003 -16.40035.2272 0.1723
0.52 0.025 12.3843 -17.9300 30.3144
3.29 0.068 12.3843 12.3843
-2.81 0.054 12.3843 12.3843
-6.53 0.093 12.3843 -16.4003 28.7847
-5.5207 0.210
HL HL/Q1
4.20 0.017 -11.3742 -11.3742
2.43 0.028 -11.3742 10.0880 -21.4621-2.56 0.024 -11.3742 7.9625 -19.3366
-2.41 0.010 -11.3742 -11.3742
1.657 0.0788
1.87 0.012 10.0880 10.0880
1.19 0.020 10.0880 10.0880
-2.75 0.054 10.0880 -8.2241 18.3121
-2.43 0.028 10.0880 -11.3742 21.4621
-2.116 0.113
2.56 0.024 7.9625 -11.3742 19.3366
2.45 0.060 7.9625 -8.2241 16.1866-0.61 0.013 7.9625 7.9625
-6.46 0.044 7.9625 7.9625
-2.0635 0.101
2.75 0.054 -8.2241 10.0880 -18.3121
5.02 0.083 -8.2241 -8.2241
-1.69 0.043 -8.2241 -8.2241
-2.45 0.060 -8.2241 7.9625 -16.1866
3.6375 0.2391
-
7/24/2019 Excel Metodo Cross para fluidos
25/42
HL HL/Q1
3.85 0.016 5.8521 5.8521
1.44 0.022 5.8521 -5.9559 11.8081
-3.50 0.028 5.8521 -5.9363 11.7884
-2.62 0.010 5.8521 5.8521
-0.826 0.07632.10 0.012 -5.9559 -5.9559
1.59 0.023 -5.9559 -5.9559
-1.21 0.037 -5.9559 4.2312 -10.1872
-1.44 0.022 -5.9559 5.8521 -11.8081
1.037 0.09
3.50 0.028 -5.9363 5.8521 -11.7884
4.52 0.079 -5.9363 4.2312 -10.1676
-0.43 0.011 -5.9363 -5.9363
-5.83 0.042 -5.9363 -5.9363
1.7512 0.15951.21 0.037 4.2312 -5.9559 10.1872
3.84 0.073 4.2312 4.2312
-2.40 0.051 4.2312 4.2312
-4.52 0.079 4.2312 -5.9363 10.1676
-1.877 0.2395
HL HL/Q1
4.03 0.017 -3.9252 -3.9252
1.96 0.025 -3.9252 3.3047 -7.2299
-2.91 0.026 -3.9252 2.9239 -6.8491-2.51 0.010 -3.9252 -3.9252
0.562 0.0775
1.96 0.012 3.3047 3.3047
1.35 0.021 3.3047 3.3047
-2.00 0.046 3.3047 -2.8494 6.1540
-1.96 0.025 3.3047 -3.9252 7.2299
-0.61 0.105
2.91 0.026 2.9239 -3.9252 6.8491
3.15 0.067 2.9239 -2.8494 5.7733
-0.56 0.012 2.9239 2.9239-6.30 0.043 2.9239 2.9239
-0.8002 0.179
2.00 0.046 -2.8494 3.3047 -6.1540
4.43 0.078 -2.8494 -2.8494
-2.02 0.047 -2.8494 -2.8494
-3.15 0.067 -2.8494 2.9239 -5.7733
1.2550 0.2381
-
7/24/2019 Excel Metodo Cross para fluidos
26/42
HL HL/Q1
3.91 0.016 2.0342 2.0342
1.63 0.023 2.0342 -2.1194 4.1536
-3.25 0.027 2.0342 -2.0319 4.0661
-2.58 0.010 2.0342 2.0342
-0.289 0.0767
2.04 0.012 -2.1194 -2.11941.48 0.022 -2.1194 -2.1194
-1.50 0.041 -2.1194 1.4684 -3.5877
-1.63 0.023 -2.1194 2.0342 -4.1536
0.385 0.098
3.25 0.027 -2.0319 2.0342 -4.0661
3.90 0.074 -2.0319 1.4684 -3.5002
-0.50 0.011 -2.0319 -2.0319
-6.07 0.042 -2.0319 -2.0319
0.5818 0.158
1.50 0.041 1.4684 -2.1194 3.58774.03 0.075 1.4684 1.4684
-2.27 0.049 1.4684 1.4684
-3.90 0.074 1.4684 -2.0319 3.5002
-0.679 0.2385
HL HL/Q1
3.97 0.017 -1.3650 -1.3650
1.82 0.024 -1.3650 1.1228 -2.4878
-3.04 0.026 -1.3650 1.0326 -2.3976
-2.55 0.010 -1.3650 -1.36500.195 0.0771
1.99 0.012 1.1228 1.1228
1.40 0.022 1.1228 1.1228
-1.78 0.044 1.1228 -0.9875 2.1103
-1.82 0.024 1.1228 -1.3650 2.4878
-0.212 0.102
3.04 0.026 1.0326 -1.3650 2.3976
3.44 0.070 1.0326 -0.9875 2.0201
-0.54 0.012 1.0326 1.0326
-6.23 0.043 1.0326 1.0326-0.2880 0.1508
1.78 0.044 -0.9875 1.1228 -2.1103
4.23 0.077 -0.9875 -0.9875
-2.14 0.048 -0.9875 -0.9875
-3.44 0.070 -0.9875 1.0326 -2.0201
0.350 0.2381
HL HL/Q1
-
7/24/2019 Excel Metodo Cross para fluidos
27/42
3.93 0.017 0.7062 0.7062
1.71 0.024 0.7062 -0.7418 1.4480
-3.16 0.027 0.7062 -0.7018 1.4080
-2.57 0.010 0.7062 0.7062
-0.100 0.0768
2.01 0.012 -0.7418 -0.7418
1.44 0.022 -0.7418 -0.7418-1.62 0.042 -0.7418 0.5101 -1.2519
-1.71 0.024 -0.7418 0.7062 -1.4480
0.137 0.100
3.16 0.027 -0.7018 0.7062 -1.4080
3.70 0.072 -0.7018 0.5101 -1.2118
-0.52 0.012 -0.7018 -0.7018
-6.15 0.043 -0.7018 -0.7018
0.1989 0.1532
1.62 0.042 0.5101 -0.7418 1.2519
4.09 0.075 0.5101 0.5101-2.23 0.049 0.5101 0.5101
-3.70 0.072 0.5101 -0.7018 1.2118
-0.228 0.2383
HL HL/Q1
3.95 0.017 -0.4742 -0.72
1.77 0.024 -0.4742 0.3867 -0.8609
-3.09 0.027 -0.4742 0.3607 -0.838
-2.56 0.010 -0.4742 -0.72
0.068 0.07702.00 0.012 0.3867 0.3867
1.41 0.022 0.3867 0.3867
-1.71 0.043 0.3867 -0.3428 0.7295
-1.77 0.024 0.3867 -0.4742 0.8609
-0.072 0.101
3.09 0.027 0.3607 -0.4742 0.838
3.54 0.071 0.3607 -0.3428 0.703
-0.53 0.012 0.3607 0.3607
-6.20 0.043 0.3607 0.3607
-0.1013 0.15181.71 0.043 -0.3428 0.3867 -0.7295
4.16 0.076 -0.3428 -0.328
-2.19 0.048 -0.3428 -0.328
-3.54 0.071 -0.3428 0.3607 -0.703
0.1510 0.2381
HL HL/Q1
3.94 0.017 0.2452 0.252
-
7/24/2019 Excel Metodo Cross para fluidos
28/42
1.73 0.024 0.2452 -0.2583 0.5035
-3.13 0.027 0.2452 -0.2432 0.88
-2.57 0.010 0.2452 0.252
-0.035 0.0769
2.01 0.012 -0.2583 -0.2583
1.43 0.022 -0.2583 -0.2583
-1.66 0.043 -0.2583 0.1772 -0.35-1.73 0.024 -0.2583 0.2452 -0.5035
0.08 0.100
3.13 0.027 -0.2432 0.2452 -0.88
3.63 0.071 -0.2432 0.1772 -0.20
-0.53 0.012 -0.2432 -0.232
-6.17 0.043 -0.2432 -0.232
0.0687 0.1526
1.66 0.043 0.1772 -0.2583 0.35
4.12 0.076 0.1772 0.1772
-2.22 0.049 0.1772 0.1772-3.63 0.071 0.1772 -0.2432 0.20
-0.0781 0.2382
HL HL/Q1
3.94 0.017 -0.1647 -0.167
1.75 0.024 -0.1647 0.1339 -0.2986
-3.11 0.027 -0.1647 0.1255 -0.2902
-2.56 0.010 -0.1647 -0.167
0.023 0.0769
2.00 0.012 0.1339 0.13391.42 0.022 0.1339 0.1339
-1.69 0.043 0.1339 -0.1190 0.2529
-1.75 0.024 0.1339 -0.1647 0.2986
-0.025 0.101
3.11 0.027 0.1255 -0.1647 0.2902
3.58 0.071 0.1255 -0.1190 0.25
-0.53 0.012 0.1255 0.1255
-6.19 0.043 0.1255 0.1255
-0.0353 0.1521
1.69 0.043 -0.1190 0.1339 -0.25294.14 0.076 -0.1190 -0.1190
-2.20 0.049 -0.1190 -0.1190
-3.58 0.071 -0.1190 0.1255 -0.25
0.052 0.2382
HL HL/Q1
3.94 0.017 0.0851 0.0851
1.74 0.024 0.0851 -0.0898 0.179
-
7/24/2019 Excel Metodo Cross para fluidos
29/42
-3.12 0.027 0.0851 -0.0844 0.1696
-2.57 0.010 0.0851 0.0851
-0.012 0.0769
2.00 0.012 -0.0898 -0.0898
1.42 0.022 -0.0898 -0.0898
-1.67 0.043 -0.0898 0.0615 -0.1513
-1.74 0.024 -0.0898 0.0851 -0.1790.017 0.100
3.12 0.027 -0.0844 0.0851 -0.1696
3.61 0.071 -0.0844 0.0615 -0.159
-0.53 0.012 -0.0844 -0.08
-6.18 0.043 -0.0844 -0.08
0.0238 0.152
1.67 0.043 0.0615 -0.0898 0.1513
4.12 0.076 0.0615 0.0615
-2.21 0.049 0.0615 0.0615
-3.61 0.071 0.0615 -0.0844 0.159-0.0271 0.2382
-
7/24/2019 Excel Metodo Cross para fluidos
30/42
Q2
279.22
121.93
-59.1
-220.78
157.29
57.29
-5.30
-121.93
59.1
26.76
-61.6
-161.6
5.30
61.59
-38.1
-26.76
Q2
231.3753.96
-136.81
-268.63
177.41
77.41
-20.87
-53.96
136.8169.90
-31.82
-131.82
20.87
48.28
-51.72
-69.90
-
7/24/2019 Excel Metodo Cross para fluidos
31/42
Q2
246.84
87.36
-104.94
-253.16
159.48
59.48
-51.18
-87.36
104.94
41.12
-48.22
-148.22
51.18
60.66
-39.34
-41.12
Q2
235.47
65.90-124.27
-264.53
169.57
69.57
-32.87
-65.90
124.27
57.31-40.26
-140.26
32.87
52.44
-47.56
-57.31
-
7/24/2019 Excel Metodo Cross para fluidos
32/42
Q2
241.32
77.71
-112.49
-258.68
163.61
63.61
-43.05
-77.71
112.49
47.14
-46.19
-146.19
43.05
56.67
-43.33
-47.14
Q2
237.40
70.48
-119.34-262.60
166.92
66.92
-36.90
-70.48
119.34
52.91
-43.27-143.27
36.90
53.82
-46.18
-52.91
-
7/24/2019 Excel Metodo Cross para fluidos
33/42
-
7/24/2019 Excel Metodo Cross para fluidos
34/42
238.77
73.59
-116.26
-261.23
165.18
65.18-39.63
-73.59
116.26
50.22
-44.97
-144.97
39.63
54.81-45.19
-50.22
Q2
238.30
72.73
-117.09
-261.70
165.57
65.57
-38.90
-72.73
117.09
50.92
-44.61
-144.61
38.90
54.47
-45.53
-50.92
Q2
238.54
-
7/24/2019 Excel Metodo Cross para fluidos
35/42
73.23
-116.61
-261.46
165.31
65.31
-39.34-73.23
116.61
50.50
-44.85
-144.85
39.34
54.65
-45.35-50.50
Q2
238.38
72.94
-116.90
-261.62
165.4465.44
-39.08
-72.94
116.90
50.75
-44.73
-144.73
39.0854.53
-45.47
-50.75
Q2
238.46
73.11
-
7/24/2019 Excel Metodo Cross para fluidos
36/42
-
7/24/2019 Excel Metodo Cross para fluidos
37/42
-
7/24/2019 Excel Metodo Cross para fluidos
38/42
DC 61 1.83 -357.26 -2.51
CA 45.7 1.525 -221.21 -4.21
AC 45.7 1.525 221.21 4.21
CB 40.6 1.525 -136.05 -3.05
BA 50.8 1.83 -136.05 -1.02
TRAMO L Q1 S
AD 50.8 3.66 243.19 3.00
DC 61 1.83 -356.81 -2.50
CA 45.7 1.525 -221.46 -4.22
AC 45.7 1.525 221.46 4.22
CB 40.6 1.525 -135.35 -3.02
BA 50.8 1.83 -135.35 -1.01
TRAMO L Q1 S
AD 50.8 3.66 243.43 3.00
DC 61 1.83 -356.57 -2.50
CA 45.7 1.525 -221.40 -4.22
AC 45.7 1.525 221.40 4.22
CB 40.6 1.525 -135.17 -3.01
BA 50.8 1.83 -135.17 -1.01
-
7/24/2019 Excel Metodo Cross para fluidos
39/42
HL HL/Q1 Q2
0.01 0.000 22.8488 22.8488 222.85
-0.01 0.000 22.8488 22.8488 -377.15
-0.01 0.000 22.8488 46.2652 -23.4164 -223.2-0.003 0.0001
0.01 0.000 46.2652 22.8488 23.4164 223.2
-0.01 0.000 46.2652 46.2652 -153.73
0.00 0.000 46.2652 46.2652 -153.73
-0.008 0.000
HL HL/Q1 Q2
0.01 0.000 14.5332 14.5332 237.38
-0.01 0.000 14.5332 14.5332 -362.62
-0.01 0.000 14.5332 10.7233 3.8099 -219.61-0.002 0.0001
0.01 0.000 10.7233 14.5332 -3.8099 219.61
-0.01 0.000 10.7233 10.7233 -13.01
0.00 0.000 10.7233 10.7233 -13.01
-0.002 0.000
HL HL/Q1 Q2
0.01 0.000 3.5001 3.5001 20.88
0.00 0.000 3.5001 3.5001 -359.12
-0.01 0.000 3.5001 5.5997 -2.0996 -221.71-0.001 0.0001
0.01 0.000 5.5997 3.5001 2.0996 221.71
-0.01 0.000 5.5997 5.5997 -137.1
0.00 0.000 5.5997 5.5997 -137.1
-0.001 0.000
HL HL/Q1 Q2
0.01 0.000 1.8569 1.8569 22.7
0.00 0.000 1.8569 1.8569 -357.26
-0.01 0.000 1.8569 1.3613 0.4956 -221.210.000 0.0001
0.01 0.000 1.3613 1.8569 -0.4956 221.21
0.00 0.000 1.3613 1.3613 -136.05
0.00 0.000 1.3613 1.3613 -136.05
0.000 0.000
HL HL/Q1 Q2
0.01 0.000 0.4533 0.4533 23.19
-
7/24/2019 Excel Metodo Cross para fluidos
40/42
0.00 0.000 0.4533 0.4533 -356.81
-0.01 0.000 0.4533 0.7051 -0.2518 -221.6
0.000 0.0001
0.01 0.000 0.7051 0.4533 0.2518 221.6
0.00 0.000 0.7051 0.7051 -135.35
0.00 0.000 0.7051 0.7051 -135.35
0.000 0.000
HL HL/Q1 Q2
0.01 0.000 0.2352 0.2352 23.3
0.00 0.000 0.2352 0.2352 -356.57
-0.01 0.000 0.2352 0.1723 0.0629 -221.0
0.000 0.0001
0.01 0.000 0.1723 0.2352 -0.0629 221.0
0.00 0.000 0.1723 0.1723 -135.17
0.00 0.000 0.1723 0.1723 -135.17
0.000 0.000
HL HL/Q1 Q2
0.0110 0.000 0.0575 0.0575 23.8
-0.0046 0.000 0.0575 0.0575 -356.52
-0.0064 0.000 0.0575 0.0891 -0.0316 -221.3
-0.00000926 0.0001
0.0064 0.000 0.0891 0.0575 0.0316 221.3
0.00 0.000 0.0891 0.0891 -135.08
0.00 0.000 0.0891 0.0891 -135.08
-0.000012661 0.000
-
7/24/2019 Excel Metodo Cross para fluidos
41/42
-
7/24/2019 Excel Metodo Cross para fluidos
42/42