1.1
Bubble
T calculationDuring the calculation of the bubble T,
data required are:
Liquid
phase composition at a particular temperature,
Pressure,
Critical
Properties (TC, PC, ZC) of all component that
are present in the system,
Values
of acentric factors of all component that are present in the system,
Antoine
equation constants,
Value
of Wilson parameters for the given system. Following are the steps for performing
bubble T calculation1
List
the data required.2
Estimate
value of temperature for the compounds at the given pressure using Antoine
Equation. From equation (3.1) find value of T1sat
and T2sat and
estimated T becomes,
……… (3.8)3
Find
P1sat and P2sat using Test in equation (3.1),4
Find
activity coefficient by using Wilson equation. Eq. (3.2) and (3.3),5
Find
valve of fugacity coefficients by use of Tsai and Jan EOS. The maximum value of fugacity coefficient is
related to vapor phase non-ideality. In this calculation value of T is required that is not available at
start so we have to make an estimate by performing steps 2.6
Find
Value of y1 and y2 by using Eq. (3.6).7
Use
y values found by step 6 in equation
(3.4) with ? value that is found by step 5
to find new value of P.8
Recalculate
steps 6, 7 and 8 till following
condition is satisfied,
……… (3.9)9
When
above condition satisfied value of temperature obtain is Bubble T. To obtain T-x-y data perfume all steps for different values of x. 1.2
Dew
T calculationDuring the calculation of the dew T, data
required are:
Vapor
phase composition at a particular temperature,
Pressure,
Critical
Properties (TC, PC, ZC) of all component that
are present in the system,
Values
of acentric factors of all component that are present in the system,
Antoine
equation constants,
Value
of Wilson parameters for the given system. Following are the steps for performing Dew
T calculation1
List
the data required.2
Estimate
value of temperature for the compounds at the given pressure using Antoine
Equation. From equation (3.1) find value of T1sat
and T2sat and
estimated T becomes,
……… (3.10)3
Find
P1sat and P2sat using Test in equation (3.1),4
Take
? = 1 and ? = 1 and use Roult’s law to find x1 and x2,5
Find
valve of fugacity coefficients by use of Tsai and Jan EOS. (The maximum value of fugacity coefficient is
related to vapor phase non-ideality.) 6
Find
the value of ? by using (3.2) and (3.3).7
Recalculate
value of P using equation (3.4).8
Recalculate
steps 2 to 7 till following condition is satisfied,
……… (3.11)9
When
above condition satisfied value of temperature obtain is Bubble T. To obtain T-x-y data perfume all steps for different values of x. 1.3
Dew
P calculationDuring the calculation of the dew P, data
required are:
Vapor
phase composition at a particular pressure,
Temperature,
Critical
Properties (TC, PC, ZC) of all component that
are present in the system,
Values
of acentric factors of all component that are present in the system,
Antoine
equation constants,
Value
of Wilson parameters for the given system. Following are the steps for performing Dew
P calculation1
List
the data required.2
Find
P1sat and P2sat using T in equation (3.1),3
Take
? = 1 and ? = 1 and use Roult’s law to find x1 and x2,4
Find
valve of fugacity coefficients by use of Tsai and Jan EOS. (The maximum value of fugacity coefficient is
related to vapor phase non-ideality).5
Find
the value of ? by using (3.2) and (3.3).6
Recalculate
value of P using equation (3.4).7
Recalculate
steps 2 to 7 till following condition is satisfied,
……… (3.12)8
When
above condition satisfied value of temperature obtain is Bubble T. To obtain T-x-y data perfume all steps for different values of x. 1.4
Flash
calculationFlash calculation is used when any of the
two values (From P, T, x,
y) are given. In flash calculation K-
value are used for calculation. It does serve as a measure of the “Lightness”
of a constituent species, i.e., its tendency to favor the vapor phase. When its
value is greater that one means species i
exhibits a higher concentration in vapor phase and if less than higher
concentration in liquid phase. K-values can be found from the nomographs.
……… (3.13)
……… (3.14)
……… (3.15) Above equations are use to for VLE
calculation. Equation (3.13) used when T
& P or x & y values are
given. Equation (3.14) use for bubble point calculation and (3.15) use for dew
point calculation. Nomographs and Algorithms for all the calculation
are provided in the Appendix.
CHAPTER 4DESIGN IN EXCELIn this chapter, the procedure for
performing calculations for bubble P for generating P-x-y data in Excel is
shown. The work in this course project has been restricted to only bubble P
calculation. Following are the steps to perform Bubble P calculation. Step 1.
Generation
of Proper Data Base System.Proper Data Base will
make work easy when we need to call values for particular systems. In this work,
I include three different types of the Data Base systems for my calculation.1.
For
critical properties of individual compounds,2.
For
binary systems and their Wilson parameters,3.
For
comparison with experimental data.First Data Base contains
critical properties, Antoine constants, acentric factor etc. for the
calculation purpose (Fig. 4.1). There are two columns containing no, first for calling the compounds and
second for calling the values.
Figure 4.1 Data
Base for critical properties of components Second Database (Fig 4.2)contain
Wilson parameter constants and slope and intersects values to generate parity
plot. First column is for giving unique identity for particular system. And
second and third columns are unique identities of first and second compound in
systems respectively. Last two columns are slope and intercepts to generate
parity plot. Ex no is unique identity for the experimental data and use to call
experimental data from Third Data Base. Third Data Base contains P-x-y data of
experiments.
Figure 4.2 Data
Base for Wilson parameter constants Step 2.
Listing
properties and parameters,List all the Parameters
and properties that are remain constant during the calculation. For this
calculation following are the parameters and properties that are constant
during the calculation of particular system. Table 4.1 Constant
Parameters and Properties.
To call the values of different properties
and parameters vlookup function is
use. Syntax for vlookup can be given
as follow,= vlookup (lookup_value, table_array, column_index_no,
range_lookup) Step 3.
Design
Tools,In this work, the button
and combo box from the developer tab were used. To use that one first need to
make visible the developer tab which is hide default in any MS word. To make it
visible follow step below for MS Office 2016 or Office 20131.
Go
to File ? Options ? Customize Ribbon,
check the box before the developer.
Figure 4.3 Excel Option for developer tab2.
From
developer select insert ? combo box,
Figure 4.4 Combo box 3.
After
selecting combo box draw box of appropriate size, and then follow window will
open,
Figure 4.5 Format control for combo boxIn input range
select the cells whose value one want to show in box, in cell link select any blank cell, it will show the number of a
system that is selected from the list i.e. if u select fifth system from the
list (combo box) then it will show 5
in the cell and that is helpful to call the values using vlookup. To create button, go to developer ? insert ? button,
Figure 4.6 Button tool After selecting button draw a button of an appropriate
size and after that on window will open to ask for macro but we don’t make it
one so just close the window. Step 4.
Use
the equations mention in chapter 3 for Tsai and Jan to calculate the ? values and Wilson equation to find ?. To calculate follow the step given
bellow,
1.
List
the values of x at uniform intervals,
2.
Find
the values of the parameters required in the calculation of Tsai & Jan EOS
(Calculate till A, B, C).
3.
From
A, B, C generate the equation for Z using equation (2.31). and compare it
with following equation,
………. (4.1)By doing so,
……… (4.2)To solve this 3rd
degree polynomial equation following equations are use,f = ((3*c/a) – (b^2/a^2))/3g = ((2*b^3/a^3) – (9*b*c/a^2)
+ (27*d/a))/27h = (g^2/4) + (f^3/27)i = SQRT ((g^2/4)-h)j = I ^ (1/3)k = ACOS(-(g/(2*i)))L = j*(-1)M = COS(k/3) N = SQRT (3) * SIN(k/3)P = (b/(3*a)) * (-1)R = -(g/2) + SQRT(h)S = R ^ (1/3)T = – (g/2) – SQRT(h)U = T ^ (1/3)For h > 0, one real
root and two imaginaryZ1 = (S+U) –
(b/3a),Z2 = (-
(S+U)/2-(b/3a)) + i (S-U) *SQRT
(3)/2,Z3 = (-
(S+U)/2-(b/3a)) – i (S-U) *SQRT (3)/2,For h ? 0, three unique
and real rootsZ1 = 2*j*COS(k/3)
– (b/(3*a)),Z2 = L*(M+N) +P,Z3 = L*(M-N) +P;For f, g, h = 0, only one
real rootZ = (d/a) ^ (1/3) * (-1);For the all possible
values of Z obtain highest real root
is consider to calculate ? for both
the component from the system and same method is used to find ?b for equation
(2.26).
4.
Use
equation (3.2) and (3.3) to find ?.
5.
Calculate
P1sat and P2sat from Antoine
equationStep 5.
Bubble
P calculation,To calculate bubble P in
excel follow the bellow steps,1.
Make
a column for estimate P, which will
be found by equation (3.5),2.
Calculate
yi using equation (3.6),3.
Make
a column for calculated P, which is
calculated by equation (3.4),4.
Copy
calculated value on estimate as paste as
value only, 5.
Make
column for ?P and ?y. ?P
is difference between estimate and calculated P and ?y is summation of
y values.6.
Use
solver to make ?y = 1 and ?P = 0,
Step 6.
Make
use of solver,Solve is not installed by
default in Excel. So, to install and use solver use steps given bellow for
office 2013 or above,1.
Go
to File ? options ? add-ins ? solver add-in, click on GO.2.
To
use solver, go to data ? solver,
following window will open,
Figure 4.7 Solver window 3.
Make
set cell as ?P, to value 0 and by
changing cell as copied P cell which
is paste as value only. Add constrain that ?y
cell becomes 1. Run the solver.Step 7.
Macro
for solver,Repetitive use of solver
is very tedious and time consuming work. So, to avoid that we have to create macro.
Before that one has to make sure that its macro is enable. For that go to developer ? macro security ? enable all
macro. After that follow steps given bellow,1.
Go
to developer and click on record macro,2.
Perform
on single solver process,3.
Go
to developer and click on stop recording,4.
Go
to developer and click on Visual Basic,5.
Copy
the code and paste it in the sheet where calculation is performed,6.
Sheet
can be found from the list of all active sheet shown in top-left penal,7.
Go
to tools ? reference and tick mark solver,
press OK,8.
Edit
the code as follow,9.
After
creating macro assign it to button mention in step 3.
Sub Macr()” Macr Macro Range(“BK51:BK71”).SelectSelection.CopyRange(“BD51″).SelectSelection.PasteSpecial
Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _:=False,
Transpose:=False solverResetSolverOk
SetCell:=”$BN$51″, MaxMinVal:=3, ValueOf:=0,
ByChange:=”$BD$51″, _Engine:=1,
EngineDesc:=”GRG Nonlinear”SolverAdd
CellRef:=”$BO$51”, Relation:=2, FormulaText:=”1″SolverSolve True In above coding first
paragraph is add for copy the calculated value and paste as value only so that
solver can be run. In second paragraph first and last line are added fist line
is for reset solver after every titration and last line is to avoid clicking OK every
time solver run. Coding between that is generated by recording macro. Copy
second paragraph and paste it for the number of time one would run it for
different rows or cells. Change the value of cell references with appropriate
values (i.e. if one want to use for next row then $BN$51 becomes $BN$52 and so
on…). Save coding and save excel file as macro enable file. Step 8.
Graph
plot.After generating P-x-y data draw a scatter graphs of1.
P vs x,2.
P vs y, 3.
y vs x.Step 9.
Comparison
plots,To create comparison plot
we have to generate P-x-y data for the
same value of x that is given in experimental data and compare the calculated y and P values with experimental one. After that, draw various comparison
graphs. (All graphs are mentions in appendix.)
CHAPTER 5RESULTS AND DISCUSSIONIn this excel file
around 25 random systems are included and the result obtained are compared with
the actual experimentally 4 generated data. For Ethanol – Benzene
system at 298.15 K temperature following data are generated and comparison with
actual data generate graphs shown in figure 5.1.Table 5.1 P-x-y
data for Ethanol – Benzene system
x
0.00
0.10
0.20
0.30
0.40
0.50
0.60
0.70
0.80
0.90
1.00
y
0.00
0.41
0.53
0.59
0.63
0.65
0.67
0.69
0.70
0.74
1.00
P (mmHg)
59.1
90.9
107.5
116.4
121.1
123.6
124.7
125.0
124.4
121.3
95.2
Figure 5.1
Comparison plots for Ethanol – Benzene system Just like this
more systems can be calculated in Excel. For around 25 azeotropic and non
– azeotropic system calculation has been
done and results are compiled in table 5.2 and table 5.3 with error in pressure,
y values, parity plot error etc.
Figure 5.2 P-x-y diagram and x-y diagram for ethanol –
benzene system Table 5.2 Result
for non azeotropic systems
Table 5.3 Result
for azeotropic systems
In above tables values of
?Y and ?P average error are found by using equation given bellow,
The number in the final
column are show how good the fitting of the curve is, and 1. Excellent, 2.
Good, 3. Moderate, 4. Poor, 5. Very Poor. Rating is done on the bases of how
many points are deviating from the experimental values and how much is the
deviation. i.e., for benzene – toluene systems all the points are perfectly
match except one so, there is possibility that the point is due to experimental
error, thus it is considered as perfect match.
CONCLUSION From the above result I
can conclude that,v
some
of the non azeotropic systems with few of the azeotropic systems shows the very
good match with experimental data, but most of the azeotropic systems are
showing deviation from the experimental values. v More over system with combination of
aliphatic and aromatic compounds are showing more deviation compare to same
systems. More details about this
EOS can be obtain by including more compounds.