Excel Calculation on Distillation of Ethanol/water

Cp Species n a n*a b n*b c n*c d Ethene -1 0.04075 -0.04075 0.000115 -0.000115 -6.9E-08 6.891E-08 1.766E-11 Ethanol 1 0.06134 0.06134 0.000157 0.000157 -8.7E-08 -8.749E-08 1.983E-11 Water -1 0.0336 -0.0336 6.88E-06 -6.88E-06 7.6E-09 -7.604E-09 -3.593E-12 Sum -0.01301 3.56E-05 -2.618E-08 Equilibrium Data Vapor-Liquid E Temperatur xa ya x=y 100 0 0 0 98.1 0 0.192 0.02 95.2 0 0.377 0.05 91.8 0 0.527 0.1 87.3 0 0.656 0.2 84.7 0 0.713 0.3 83.2 0 0.746 0.4 82 1 0.771 0.5 81 1 0.794 0.6 80.1 1 0.822 0.7 79.1 1 0.858 0.8 78.3 1 0.912 0.9 78.2 1 0.942 0.94 78.1 1 0.959 0.96    e 78.2 1 0.978 0.98     l    t    i    T 78.3 1 1 1    s    i    x    A

Enthalpy of mi Temperatur TemperaturLiq Liq Vapor 100 # 2675 91.8 # 2517 84.7 # 2193 82 # 1870 80.1 # 1544 78.3 # 1223 78.3 # 1064

n*d -1.7 -1.766E 66E-1 -11 1 1.983 1.983EE-11 11 3.593 3.593EE-12 12 5.763E-12

state g g g

Chart Title 1.2

1

0.8

0.6

0.4

0.2

3

2

y0= 0.3253x  - 91.659x  + 8619.1x - 267937 0 0.2 R² = 0.9946

5

4

3

0.4

0.6

Axis Title

2

y = 0.0005x  - 0.2394x  + 42.407x  - 3751.7x  + 165788x - 3E+06 R² = 0.9956

Chart Title

3000 y = 0.3253x3 - 91.659x2 + 8619.1x - 267937 R² = 0.9946

2500 2000 1500 1000

y = 0.0005x5 - 0.2394x 4 + 42.407x 3 - 3751.7x2 + 165788x - 3E+06 R² = 0.9956

500 0 78.2

83.2 Series1

88.2 Series2

93.2 Poly. (Series1)

98.2 Poly. (Series2)

6

5

4

3

2

y = -42.592x  + 148.07x  - 201.55x  + 136.76x  - 48.614x  + 8.9041x + 0.0179 R² = 0.9985

y = -42.592x6 + 148.07x 5 - 201.55x4 + 136.76x3 - 48.614x2 + 8.9041x + 0.0179 R² = 0.9985

0.8

1

1.2

Cp Species n a n*a b n*b c n*c d Ethene 1 4.08E-02 4.08E-02 1.15E-04 1.15E-04 -6.89E-08 -6.89E-08 1.77E-11 Ethanol 0 6.13E-02 0.00E+00 1.57E-04 0.00E+00 -8.75E-08 0.00E+00 1.98E-11 Water 1 3.36E-02 3.36E-02 6.88E-06 6.88E-06 7.60E-09 7.60E-09 -3.59E-12 Sum 7.44E-02 1.22E-04 -6.13E-08 Equilibrium Data Equili Equilibri bria, a, Mass Mass fractio fractio Temperatu xa ya x=y 100 0 0 0 98.1 0.02 0.192 0.02 95.2 0.05 0.377 0.05 91.8 0.1 0.527 0.1 87.3 0.2 0.656 0.2 84.7 0.3 0.713 0.3 83.2 0.4 0.746 0.4 82 0.5 0.771 0.5 81 0.6 0.794 0.6 80.1 0.7 0.822 0.7 79.1 0.8 0.858 0.8 78.3 0.9 0.912 0.9 78.2 0.94 0.942 0.94 78.1 0.96 0.959 0.96 78.2 0.98 0.978 0.98 78.3 1 1 1

Enthalpy of mixture Temperatu Li L iquid Vapor 100 418 2675 91.8 371.7 2517 84.7 314 2193 82 285.9 1870 80.1 258.4 1544 78.3 224.7 1223 78.3 207 1064

3

y = 0.3253x  -

n*d state 1.77 1.77EE-11 11 g 0.00 0.00E+ E+00 00 g -3.5 -3.59E 9E-12 -12 g 1.41E-11

 

2

91.659x  + 8619.1x - 267937 R² = 0.9946

5

4

3

2

y = 0.0005x  - 0.2394x  + 42.407x  - 3751.7x  + 165788x - 3E+06 R² = 0.9956

Chart Title

3000 y = 0.3253x3 - 91.659x2 + 8619.1x - 2679 R² = 0.9946

2500 2000 1500 1000

y = 0.0005x 5 - 0.2394x 4 + 42.407x3 - 3751.7x2 + 165788x - 3E+ R² = 0.9956

500 0 78.2

83.2 Series1

88.2 Series2

93.2 Poly. (Series1)

98.2 Poly. (Series2)

6

5

4

3

2

y = -42.592x  + 148.07x  - 201.55x  + 136.76x  - 48.614x  + 8.9041x + 0.0179 R² = 0.9985

37

06

)

Cp Species n a n*a b n*b c n*c d Ethene 0.95 4.08E-02 3.87E-02 1.15E-04 1.09E-04 -6.89E-08 -6.55E-08 1.77E-11 Ethanol 0.05 6.13E-02 3.07E-03 1.57E-04 7.86E-06 -8.75E-08 -4.37E-09 1.98E-11 Water 0.95 3.36E-02 3.19E-02 6.88E-06 6.54E-06 7.60E-09 7.22E-09 -3.59E-12 Sum 7.37E-02 1.23E-04 -6.26E-08 Equilibrium Data Equili Equilibri bria, a, Mass Mass fractio fractio Temperatu xa ya x=y 100 0 0 0 98.1 0.02 0.192 0.02 95.2 0.05 0.377 0.05 91.8 0.1 0.527 0.1 87.3 0.2 0.656 0.2 84.7 0.3 0.713 0.3 83.2 0.4 0.746 0.4 82 0.5 0.771 0.5 81 0.6 0.794 0.6 80.1 0.7 0.822 0.7 79.1 0.8 0.858 0.8 78.3 0.9 0.912 0.9 78.2 0.94 0.942 0.94 78.1 0.96 0.959 0.96 78.2 0.98 0.978 0.98 78.3 1 1 1

Enthalpy of mixture Temperatu Li L iquid Vapor 100 418 2675 91.8 371.7 2517 84.7 314 2193 82 285.9 1870 80.1 258.4 1544 78.3 224.7 1223 78.3 207 1064

3

y = 0.3253x  -

n*d state 1.68 1.68EE-11 11 g 9.92 9.92EE-13 13 g -3.4 -3.41E 1E-12 -12 g 1.44E-11

 

2

91.659x  + 8619.1x - 267937 R² = 0.9946

5

4

3

2

y = 0.0005x  - 0.2394x  + 42.407x  - 3751.7x  + 165788x - 3E+06 R² = 0.9956

Chart Title

3000 y = 0.3253x3 - 91.659x2 + 8619.1x - 2679 R² = 0.9946

2500 2000 1500 1000

y = 0.0005x 5 - 0.2394x 4 + 42.407x3 - 3751.7x2 + 165788x - 3E+ R² = 0.9956

500 0 78.2

83.2 Series1

88.2 Series2

93.2 Poly. (Series1)

98.2 Poly. (Series2)

6

5

4

3

2

y = -42.592x  + 148.07x  - 201.55x  + 136.76x  - 48.614x  + 8.9041x + 0.0179 R² = 0.9985

37

06

)