Valentina De La Cruz M Datos de equilibrio

Masa II, G2 T, C hy, KJ/KgAS hy, kcal/KgAS Modelo SSE

15.0 42.0 10.04 10.9245453 0.78
17.0 47.8 11.42 12.102745 0.46
19.0 54.1 12.92 13.40801219 0.24
21.0 60.9 14.55 14.85405094 0.09
23.0 68.2 16.31 16.45604332 0.02
25.0 76.27 18.23 18.23080875 0.00
28.0 89.69 21.44 21.25821057 0.03
31.0 105.01 25.10 24.7883417 0.10
34.0 122.57 29.29 28.90468519 0.15
37.0 142.75 34.12 33.70458726 0.17
40.0 166.02 39.68 39.30155942 0.14
43.0 192.93 46.11 45.82796284 0.08
46.0 224.18 53.58 53.43813858 0.02
49.0 260.58 62.28 62.31205747 0.00
52.0 303.18 72.46 72.65957628 0.04
55.0 353.29 84.44 84.7254005 0.08

Suma del error cuadrado 2.41

A 5.0675672668
B 0.0512100831

Se hace solver para buscar los coeficientes del modelo que haga que s
minimice la suma del error al cuadrado
 Chart Title
90.00

80.00
𝑀𝑜𝑑𝑒𝑙𝑜  ℎ𝑦=𝐴𝑒^𝐵∗𝑇
70.00

60.00

50.00

40.00

30.00

20.00

10.00

0.00
10.0 15.0 20.0 25.0 30.0 35.0 40.0

eficientes del modelo que haga que se

del error al cuadrado
 Chart Title

0 35.0 40.0 45.0 50.0 55.0 60.0

 hy2 24.3195833381317 TL2= 45
H2 0.00372842412346 L= 5000
TG2 0

pendiente de operación
intercepto de operacion
Altura de la torre

Pendiente minima Puntos A y B para kya 2000

determinar
TL hy (L/G)max CL 1
27 13.51958333813 A
45 50.77045614501 B
(L/G)max 2.069492933715
Gmin 2416.050771927

L/G 0.6

QG 8333.333333333 kg/h-m2 TL1 27

TG1 31 o
C
Tw1 20 C
o

H1 0.009942732702 Kg agua/Kg AS
hy1 13.51958333813 kcal/KgAS Condiciones del
v1 0.873786719073 m3/KgAS aire entrante
ρ1 1.144444036711 Kg AS/m3
ANTOINE T(°C) Y P(mmHg)
A B C
8.071 1730.63 233.423

Pw-Pv=0,5(T-Tw) Ecuacion Psicometrica

Pw 17.45753422373
Pv 11.95753422373
 o
C
kg/h-m2

L'= ρ*QL/A 5000 90.00

G's= QG*ρ1/A 8333.333333333
nte de operación m= L'CL/G' 0.60 80.00
pto de operacion b= hy-Mt -2.68041666187
z= (G's/Kya)*km 6.178607578722
70.00
Kya= G'Km/Z 2000
kg/h m3
60.00

kcal/Kg °C
50.00

40.00

30.00

DATOS DE LINEA DE OPERACIÓN

20.00
o
C TL hy hy*
1 27 13.51958333813 20.19698058903
10.00
2 29.25 14.86958333813 22.66350234748
3 31.5 16.21958333813 25.43124386292
0.00
4 33.75 17.56958333813 28.53699108369 10.0 15.0
5 36 18.91958333813 32.02202237925
6 38.25 20.26958333813 35.93265716942
7 40.5 21.61958333813 40.32087155407
8 42.75 22.96958333813 45.24498912548
9 45 24.31958333813 50.77045614501

hy 1/(hy*-hy)
Chart Title
hy1 13.519583338 0.149758949846
0.16
14.869583338 0.128305156725
16.219583338 0.10855806044 0.14
17.569583338 0.091179248844 0.12
18.919583338 0.07632166781
0.1
20.269583338 0.063844428672
21.619583338 0.053472252203 0.08
22.969583338 0.044892560412 0.06

0.04

0.02

0
 0.1

0.08

0.06
hy2 24.319583338 0.037805935831
0.04

regla de simpson 0.02

h 2.25 0
12 14 16 18 20
km 1.482865818893
 Chart Title
.00

.00

.00

.00

.00

.00

.00

.00

.00

.00
10.0 15.0 20.0 25.0 30.0 35.0 40.0 45.0 50.0 55.0 60.0

Chart Title
18 20 22 24 26
55.0 60.0
 hy2 26.1195833381317 TL2= 45
H2 0.00372842412346 L= 5000
TG2 0

pendiente de operación
intercepto de operacion
Altura de la torre

Pendiente minima Puntos A y B para kya 2000

determinar
TL hy (L/G)max CL 1
29.25 15.0945833381317 A
42.75 45.2449891254753 B
(L/G)max 2.23336339165508
Gmin 2238.7758385771

L/G 0.7

QG 7142.85714285714 kg/h-m2 TL1 27

TG1 31 o
C
Tw1 20 C o

H1 0.00994273270227 Kg agua/Kg AS
hy1 13.5195833381317 kcal/KgAS Condiciones del
v1 0.87378671907284 m3/KgAS aire entrante
ρ1 1.1444440367108 Kg AS/m3
ANTOINE T(°C) Y P(mmHg)
A B C
8.071 1730.63 233.423

Pw-Pv=0,5(T-Tw) Ecuacion Psicometrica

Pw 17.4575342237338
Pv 11.9575342237338
 o
C
kg/h-m2

L'= ρ*QL/A 5000 90.00

G's= QG*ρ1/A 7142.857142857
nte de operación m= L'CL/G' 0.70 80.00
pto de operacion b= hy-Mt -5.38041666187
z= (G's/Kya)*km 4.090670112353
70.00
Kya= G'Km/Z 2000
kg/h m3
60.00
kcal/Kg °C
50.00

40.00

30.00

DATOS DE LINEA DE OPERACIÓN

20.00
o
C TL hy hy*
1 27 13.51958333813 20.19698058903
10.00
2 29.25 15.09458333813 22.66350234748
3 31.5 16.66958333813 25.43124386292
0.00
4 33.75 18.24458333813 28.53699108369 10.0 15.0
5 36 19.81958333813 32.02202237925
6 38.25 21.39458333813 35.93265716942
7 40.5 22.96958333813 40.32087155407
8 42.75 24.54458333813 45.24498912548
9 45 26.11958333813 50.77045614501

hy 1/(hy*-hy) 0.14

hy1 13.519583338 0.149758949846

0.12
15.094583338 0.132119262839
16.669583338 0.114133616244 0.1
18.244583338 0.09715899571
19.819583338 0.08195082939 0.08
21.394583338 0.068784903117
22.969583338 0.057632608459 0.06
24.544583338 0.048308231745
0.04

0.02

0
 0.08

0.06

0.04
hy2 26.119583338 0.04056651494

0.02
regla de simpson
h 2.25 0
km 1.145387631459 14 16 18 20 22
 Chart Title
0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00
10.0 15.0 20.0 25.0 30.0 35.0 40.0 45.0 50.0 55.0 60.0
20 22 24 26
55.0 60.0
 hy2 27.9195833381317 TL2= 45
H2 0.00372842412346 L= 5000
TG2 0

pendiente de operación
intercepto de operacion
Altura de la torre

Pendiente minima Puntos A y B para kya 2000

determinar
TL hy (L/G)max CL 1
31.5 17.1195833381317 A
40.5 24.3195833381317 B
(L/G)max 0.8
Gmin 6250

L/G 0.8

QG 6250 kg/h-m2 TL1 27

TG1 31 o
C
Tw1 20 o
C
H1 0.00994273270227 Kg agua/Kg AS
hy1 13.5195833381317 kcal/KgAS Condiciones del
v1 0.87378671907284 m3/KgAS aire entrante
ρ1 1.1444440367108 Kg AS/m3
ANTOINE T(°C) Y P(mmHg)
A B C
8.071 1730.63 233.423

Pw-Pv=0,5(T-Tw) Ecuacion Psicometrica

Pw 17.4575342237338
Pv 11.9575342237338
 o
C
kg/h-m2

L'= ρ*QL/A 5000 90.00

G's= QG*ρ1/A 6250
nte de operación m= L'CL/G' 0.80 80.00
pto de operacion b= hy-Mt -8.08041666187
z= (G's/Kya)*km 5.165701996035 70.00
Kya= G'Km/Z 2000
kg/h m3
60.00
kcal/Kg °C
50.00

40.00

30.00

DATOS DE LINEA DE OPERACIÓN

20.00
o
C TL hy hy*
1 27 13.51958333813 20.19698058903
10.00
2 29.25 15.31958333813 22.66350234748
3 31.5 17.11958333813 25.43124386292
0.00
4 33.75 18.91958333813 28.53699108369 10.0 15.0
5 36 20.71958333813 32.02202237925
6 38.25 22.51958333813 35.93265716942
7 40.5 24.31958333813 40.32087155407
8 42.75 26.11958333813 45.24498912548
9 45 27.91958333813 50.77045614501

hy 1/(hy*-hy)
Chart Title
hy1 13.519583338 0.149758949846
0.16
15.319583338 0.136167079012
17.119583338 0.12031290222 0.14
18.919583338 0.103978122427 0.12
20.719583338 0.088476478074
0.1
22.519583338 0.074554126264
24.319583338 0.062494968312 0.08
26.119583338 0.052286472304 0.06

0.04

0.02

0
12 14 16 18 20 22 24
 0.1

0.08

0.06
hy2 27.919583338 0.043762004561
0.04

regla de simpson 0.02

h 2.25 0
12 14 16 18 20 22 24
km 1.653024638731
 Chart Title
.00

.00

.00

.00

.00

.00

.00

.00

.00

.00
10.0 15.0 20.0 25.0 30.0 35.0 40.0 45.0 50.0 55.0 60.0

Chart Title

20 22 24 26 28 30
20 22 24 26 28 30
55.0 60.0
 hy2 29.7195833381317 TL2= 45
H2 0.00372842412346 L= 5000
TG2 0

pendiente de operación
intercepto de operacion
Altura de la torre

Pendiente minima Puntos A y B para kya 2000

determinar
TL hy (L/G)max CL 1
33.75 19.5945833381317 A
38.25 23.6445833381317 B
(L/G)max 0.9
Gmin 5555.55555555555

L/G 0.9

QG 5555.55555555556 kg/h-m2 TL1 27

TG1 31 o
C
Tw1 20 o
C
H1 0.00994273270227 Kg agua/Kg AS
hy1 13.5195833381317 kcal/KgAS Condiciones del
v1 0.87378671907284 m3/KgAS aire entrante
ρ1 1.1444440367108 Kg AS/m3
ANTOINE T(°C) Y P(mmHg)
A B C
8.071 1730.63 233.423

Pw-Pv=0,5(T-Tw) Ecuacion Psicometrica

Pw 17.4575342237338
Pv 11.9575342237338
 o
C
kg/h-m2

L'= ρ*QL/A 5000 90.00

G's= QG*ρ1/A 5555.555555556
nte de operación m= L'CL/G' 0.90 80.00
pto de operacion b= hy-Mt -10.7804166619
z= (G's/Kya)*km 4.881364976939 70.00
Kya= G'Km/Z 2000
kg/h m3
60.00
kcal/Kg °C
50.00

40.00

30.00

DATOS DE LINEA DE OPERACIÓN

20.00
o
C TL hy hy*
1 27 13.51958333813 20.19698058903
10.00
2 29.25 15.54458333813 22.66350234748
3 31.5 17.56958333813 25.43124386292
0.00
4 33.75 19.59458333813 28.53699108369 10.0 15.0
5 36 21.61958333813 32.02202237925
6 38.25 23.64458333813 35.93265716942
7 40.5 25.66958333813 40.32087155407
8 42.75 27.69458333813 45.24498912548
9 45 29.71958333813 50.77045614501

hy 1/(hy*-hy)
Chart Title
hy1 13.519583338 0.149758949846
0.16
15.544583338 0.14047076511
17.569583338 0.127199590576 0.14
19.594583338 0.111826705788 0.12
21.619583338 0.096131301135
0.1
23.644583338 0.081379719371
25.669583338 0.068253383952 0.08
27.694583338 0.05697873953 0.06

0.04

0.02

0
12 14 16 18 20 22 24
 0.1

0.08

0.06
hy2 29.719583338 0.047503968561
0.04

regla de simpson 0.02

h 2.25 0
12 14 16 18 20 22 24
km 1.757291391698
 Chart Title
.00

.00

.00

.00

.00

.00

.00

.00

.00

.00
10.0 15.0 20.0 25.0 30.0 35.0 40.0 45.0 50.0 55.0 60.0

Chart Title

20 22 24 26 28 30 32
20 22 24 26 28 30 32
55.0 60.0
 hy2 31.5195833381317 TL2= 45
H2 0.00372842412346 L= 5000
TG2 0

pendiente de operación
intercepto de operacion
Altura de la torre

Pendiente minima Puntos A y B para kya 2000

determinar
TL hy (L/G)max CL 1
36 22.5195833381317 A
38.25 24.7695833381317 B
(L/G)max 1
Gmin 5000

L/G 1

QG 5000 kg/h-m2 TL1 27

TG1 31 o
C
Tw1 20 o
C
H1 0.00994273270227 Kg agua/Kg AS
hy1 13.5195833381317 kcal/KgAS Condiciones del
v1 0.87378671907284 m3/KgAS aire entrante
ρ1 1.1444440367108 Kg AS/m3
ANTOINE T(°C) Y P(mmHg)
A B C
8.071 1730.63 233.423

Pw-Pv=0,5(T-Tw) Ecuacion Psicometrica

Pw 17.4575342237338
Pv 11.9575342237338
 o
C
kg/h-m2

L'= ρ*QL/A 5000 90.00

G's= QG*ρ1/A 5000
nte de operación m= L'CL/G' 1.00 80.00
pto de operacion b= hy-Mt -13.4804166619
z= (G's/Kya)*km 4.697140453902 70.00
Kya= G'Km/Z 2000
kg/h m3
60.00
kcal/Kg °C
50.00

40.00

30.00

DATOS DE LINEA DE OPERACIÓN

20.00
o
C TL hy hy*
1 27 13.51958333813 20.19698058903
10.00
2 29.25 15.76958333813 22.66350234748
3 31.5 18.01958333813 25.43124386292
0.00
4 33.75 20.26958333813 28.53699108369 10.0 15.0
5 36 22.51958333813 32.02202237925
6 38.25 24.76958333813 35.93265716942
7 40.5 27.01958333813 40.32087155407
8 42.75 29.26958333813 45.24498912548
9 45 31.51958333813 50.77045614501

hy 1/(hy*-hy)
Chart Title
hy1 13.519583338 0.149758949846
0.16
15.769583338 0.145055373967
18.019583338 0.134922531416 0.14
20.269583338 0.120956898556 0.12
22.519583338 0.105236139445
0.1
24.769583338 0.089581061195
27.019583338 0.075180688048 0.08
29.269583338 0.062596219045 0.06

0.04

0.02

0
10 15 20 25
 0.1

0.08

0.06
hy2 31.519583338 0.051945696698
0.04

regla de simpson 0.02

h 2.25 0
10 15 20 25
km 1.878856181561
 Chart Title
.00

.00

.00

.00

.00

.00

.00

.00

.00

.00
10.0 15.0 20.0 25.0 30.0 35.0 40.0 45.0 50.0 55.0 60.0

Chart Title

20 25 30 35
20 25 30 35
55.0 60.0
 hy2 33.3195833381317 TL2= 45
H2 0.00372842412346 L= 5000
TG2 0

pendiente de operación
intercepto de operacion
Altura de la torre

Pendiente minima Puntos A y B para kya 2000

determinar
TL hy (L/G)max CL 1
27 13.519583338 A
45 50.770456145 B
(L/G)max 2.0694929337
Gmin 2416.0507719

L/G 1.1

QG 4545.4545455 kg/h-m2 TL1 27

TG1 31 o
C
Tw1 20 o
C
H1 0.0099427327 Kg agua/Kg AS
hy1 13.519583338 kcal/KgAS Condiciones del
v1 0.8737867191 m3/KgAS aire entrante
ρ1 1.1444440367 Kg AS/m3
ANTOINE T(°C) Y P(mmHg)
A B C
8.071 1730.63 233.423

Pw-Pv=0,5(T-Tw) Ecuacion Psicometrica

Pw 17.457534224
Pv 11.957534224
 o
C
kg/h-m2

L'= ρ*QL/A 5000 90.00

G's= QG*ρ1/A 4545.454545455
nte de operación m= L'CL/G' 1.10 80.00
pto de operacion b= hy-Mt -16.1804166619
z= (G's/Kya)*km 4.597296919434 70.00
Kya= G'Km/Z 2000
kg/h m3
60.00
kcal/Kg °C
50.00

40.00

30.00

DATOS DE LINEA DE OPERACIÓN

20.00
o
C TL hy hy*
1 27 13.51958333813 20.19698058903
10.00
2 29.25 15.99458333813 22.66350234748
3 31.5 18.46958333813 25.43124386292
0.00
4 33.75 20.94458333813 28.53699108369 10.0 15.0
5 36 23.41958333813 32.02202237925
6 38.25 25.89458333813 35.93265716942
7 40.5 28.36958333813 40.32087155407
8 42.75 30.84458333813 45.24498912548
9 45 33.31958333813 50.77045614501

hy 1/(hy*-hy)
Chart Title
hy1 13.519583338 0.149758949846
0.16
15.994583338 0.149949339405
18.469583338 0.143643890195 0.14
20.944583338 0.131710523659 0.12
23.419583338 0.116246101277
0.1
25.894583338 0.099620705805
28.369583338 0.083672988378 0.08
30.844583338 0.069442487578 0.06

0.04

0.02

0
10 15 20 25
 0.1

0.08

0.06
hy2 33.319583338 0.057303724064
0.04

regla de simpson 0.02

h 2.25 0
10 15 20 25
km 2.022810644551
 Chart Title
.00

.00

.00

.00

.00

.00

.00

.00

.00

.00
10.0 15.0 20.0 25.0 30.0 35.0 40.0 45.0 50.0 55.0 60.0

Chart Title

20 25 30 35
20 25 30 35
55.0 60.0
 hy2 35.1195833381317 TL2= 45
H2 0.00372842412346 L= 5000
TG2 0

pendiente de operación
intercepto de operacion
Altura de la torre

Pendiente minima Puntos A y B para kya 2000

determinar
TL hy (L/G)max CL 1
27 13.519583338 A
45 50.770456145 B
(L/G)max 2.0694929337
Gmin 2416.0507719

L/G 1.2

QG 4166.6666667 kg/h-m2 TL1 27

TG1 31 o
C
Tw1 20 o
C
H1 0.0099427327 Kg agua/Kg AS
hy1 13.519583338 kcal/KgAS Condiciones del
v1 0.8737867191 m3/KgAS aire entrante
ρ1 1.1444440367 Kg AS/m3
ANTOINE T(°C) Y P(mmHg)
A B C
8.071 1730.63 233.423

Pw-Pv=0,5(T-Tw) Ecuacion Psicometrica

Pw 17.457534224
Pv 11.957534224
 o
C
kg/h-m2

L'= ρ*QL/A 5000 90.00

G's= QG*ρ1/A 4166.666666667
nte de operación m= L'CL/G' 1.20 80.00
pto de operacion b= hy-Mt -18.8804166619
z= (G's/Kya)*km 4.576187953105 70.00
Kya= G'Km/Z 2000
kg/h m3
60.00
kcal/Kg °C
50.00

40.00

30.00

DATOS DE LINEA DE OPERACIÓN

20.00
o
C TL hy hy*
1 27 13.51958333813 20.19698058903
10.00
2 29.25 16.21958333813 22.66350234748
3 31.5 18.91958333813 25.43124386292
0.00
4 33.75 21.61958333813 28.53699108369 10.0 15.0
5 36 24.31958333813 32.02202237925
6 38.25 27.01958333813 35.93265716942
7 40.5 29.71958333813 40.32087155407
8 42.75 32.41958333813 45.24498912548
9 45 35.11958333813 50.77045614501

hy 1/(hy*-hy)
Chart Title
hy1 13.519583338 0.149758949846
0.18
16.219583338 0.155185066502
18.919583338 0.153570659311 0.16
21.619583338 0.144562824223 0.14
24.319583338 0.129829005418 0.12
27.019583338 0.112194739876 0.1
29.719583338 0.094328158959
0.08
32.419583338 0.077970242547
0.06
0.04
0.02
0
10 15 20 25 30
 0.12
0.1
0.08
0.06
hy2 35.119583338 0.063894200173
0.04
regla de simpson 0.02
h 2.25 0
10 15 20 25 30
km 2.196570217491
 Chart Title
.00

.00

.00

.00

.00

.00

.00

.00

.00

.00
10.0 15.0 20.0 25.0 30.0 35.0 40.0 45.0 50.0 55.0 60.0

Chart Title

25 30 35 40
25 30 35 40
55.0 60.0
 hy2 49.1595833381317 TL2= 45
H2 0.00372842412346 L= 5000
TG2 0

pendiente de operación
intercepto de operacion
Altura de la torre

Pendiente minima Puntos A y B para kya 2000

determinar
TL hy (L/G)max CL 1
27 13.519583338 A
45 50.770456145 B
(L/G)max 2.0694929337
Gmin 2416.0507719

L/G 1.98

QG 2525.2525253 kg/h-m2 TL1 27

TG1 31 o
C
Tw1 20 o
C
H1 0.0099427327 Kg agua/Kg AS
hy1 13.519583338 kcal/KgAS Condiciones del
v1 0.8737867191 m3/KgAS aire entrante
ρ1 1.1444440367 Kg AS/m3
ANTOINE T(°C) Y P(mmHg)
A B C
8.071 1730.63 233.423

Pw-Pv=0,5(T-Tw) Ecuacion Psicometrica

Pw 17.457534224
Pv 11.957534224
 o
C
kg/h-m2

L'= ρ*QL/A 5000 90.00

G's= QG*ρ1/A 2525.252525253
nte de operación m= L'CL/G' 1.98
pto de operacion b= hy-Mt -39.9404166619 80.00

z= (G's/Kya)*km 68.24646688135
Kya= G'Km/Z 2000 70.00
kg/h m3

kcal/Kg °C 60.00

50.00

40.00

DATOS DE LINEA DE OPERACIÓN

o
C TL hy hy* 30.00

1 27 13.51958333813 20.19698058903
2 29.25 17.97458333813 22.66350234748 20.00
3 31.5 22.42958333813 25.43124386292
4 33.75 26.88458333813 28.53699108369
10.00
5 36 31.33958333813 32.02202237925
6 38.25 35.79458333813 35.93265716942
7 40.5 40.24958333813 40.32087155407 0.00
10.0 15.0
8 42.75 44.70458333813 45.24498912548
9 45 49.15958333813 50.77045614501

hy 1/(hy*-hy)
Chart Title
hy1 13.519583338 0.149758949846
16
17.974583338 0.213268772185
22.429583338 0.333148932647 14
26.884583338 0.605177506999 12
31.339583338 1.465332344364
10
35.794583338 7.242502005375
40.249583338 14.02756383826 8
44.704583338 1.850461307818 6

0
10 15 20 25 30 35 40
 10

6
hy2 49.159583338 0.620781476807
4

regla de simpson 2
h 2.25 0
10 15 20 25 30 35 40
km 54.05120177003
 Chart Title
.00

.00

.00

.00

.00

.00

.00

.00

.00

.00
10.0 15.0 20.0 25.0 30.0 35.0 40.0 45.0 50.0 55.0 60.0

Chart Title

30 35 40 45 50 55
30 35 40 45 50 55
0.0 55.0 60.0