** AsTher Thermodynamic Database and Applications**

**AsTher Process Calculator
for MS Excel**

8.4. Enthalpy-Concentration, Liquid-Gas-Concentration-Diagrams of Ethanol-Water Mixtures

This example shows the sheets of the MS Excel file to plot state diagrams using the empirical equations of activity coefficients in the application AsTher Process Calculator.

Downlad fileC2H5OH-H2O.50C.xls

The **C2H5OH-H2O.50C.xls** contains 4 sheets: **conditions, Gas, Liq and
graphics**.

The data in the sheets are written in following

Cell **[B2] **Temperature of the thermodynamic system

Cell **[B3]** Pressure of the thermodynamic system

Cell **[B6]** Calculation is made 100 time, the input values changed in
depend of the calculation count for different concentrations of the substances.

Cell **[B10] *** : means if the calculation count is less than 100 [C6], then
the next calculations system is defined in the same file.

Cell **[C10] *** : means if the calculation count is less than 100 [C6], then the
next calculations system is defined in the same condition sheet.

Cell **[B12] graphics: **Calculations result is written in the sheet named **
graphics**, the sheet must exist in the same file (or in the same MS Excel book)

Cells** [B13] to [B21]**: the cells contain links to another cell in
different sheet, which data are recorded in the sheet **graphics**

8.4.**2. Sheet for gas phase**

In cell **[J1] **written **H**, so that the application writes enthalpies
of the substances in the cells [J2] and [J3].

Enthalpy of the C2H5OH in the mixture **[K2]=C2*J2
**Enthalpy of the H2O in the mixture

The calculation results are written in the blue coloured cells,

8.4.**3. Sheet for liquid phase**

The cell **[B2]=Conditions!B6*0.01** the input values are varied in depend
of the calculation count.

The cell **[B2]=1-B2** the input values are varied in depend of the
calculation count.

Enthalpy of the C2H5OH in the mixture **[K2]=C2*J2
**Enthalpy of the H2O in the mixture

In cell **[J1] **written **H**, so that the application writes
enthalpies of the substances in the cells [J2] and [J3].

The activity coefficients of the binary mixtures given by Van Laar

There are **Eq.(1)** the activity coefficients of ethanol and **Eq.(2)**
the activity coefficient of water in the binary mixture.

The constants A and B are given by C.A. Jones, A.P.
Schoenborn, Ind. Chem. Eng. 40 (1940) 1273-1276

for 50 C

**A** is in Cell **[P2]**=0.936

**B** is in Cell**
[P3]**=0.38

Eq.(1) and Eq.(2) written in Cells [N2] and [N3]

**[N2]**=P2*POWER(1-D2;2)*POWER((1-D2+D2*P2/P3);-2)
**Eq. (1)**

**[N3]**=P3*POWER(1-D3;2)*POWER((1-D3+D3*P3/P2);-2) **
Eq. (2)**

The cells [F2] and [F3] contain the activity coefficients:

**[F2]**=POWER(10;N2)

**[F3]**=POWER(10;N3)

8.4.**4. Calculations
**When

8.4.**5. Sheet for Graphics**

The sheet graphics contains no any data before the calculations.

The data in th colums A.. I are written by application corresponding the
parameters in the conditions sheet.