Excel library for process calc's including distillation

[dbert]

Crob,
in Prode Properties the module for characterizing petroleum fractions allows to enter data from

- ASTM, TBP curves

-liquid density

-liquid viscosity

there are several procedures which you can select for best fitting

[Crob]

>in Prode Properties the module for characterizing petroleum fractions allows to enter data from
>- ASTM, TBP curves
>-liquid density
>-liquid viscosity
>there are several procedures which you can select for best fitting

thanks dbert,
I have some light components (from laboratory analysis) + TBP curve + liquid densities,
I see that Prode has different options,
do these options modify the procedure to enter the light components (C1-C4) ?

[psensel]

thanks dbert,
here there are some comments concerning the characterization of petroleum fractions,
-light components can be defined and the procedure automatically includes them in the list
-you can enter TBP or ASTM curves (TBP may require some pre-processing but usually gives better values)
-liquid densities should be defined, differently minimizer may fail to find a complete list of real or pseudo components

[abarre]

thanks all for helping us !!!

I have some questions about vapor-liquid-liquid phase envelope,
specifically,

P-H (pressure enthalpy diagrams)

P-S (pressure entropy diagrams)

P-V (pressure volume diagrams)

my question is : how can I obtain the equivalent

T-H (temperature enthalpy diagrams)

T-S (temperature entropy diagrams)

T-V (temperature volume diagrams)

thanks

[carlo.stenali]

you can easily convert the PH graph to a TH graph (or add a new graph if you prefer)
follow these steps :

1) in Microsoft Excel edit the data series (input data for each line)
2) modify the series y values from P values to t values

in that way you can create
T-H
T-S
T-V
H-S (enthalpy-entropy)
H-V (enthalpy-volume)
etc...

[tinom]

thanks Carlo,
does Properties allow to graph multiphase (liquid-liquid) fractions ?


>you can easily convert the PH graph to a TH graph (or add a new graph if you prefer)
f>ollow these steps :

>1) in Microsoft Excel edit the data series (input data for each line)
>2) modify the series y values from P values to t values
>
>in that way you can create
>T-H
>T-S
>T-V
>H-S (enthalpy-entropy)
>H-V (enthalpy-volume)
>etc...

[carlo.stenali]

>does Properties allow to graph multiphase (liquid-liquid) fractions ?

yes,
you can graph
vapor-liquid equilibria lines
vapor-liquid-liquid equilibria lines
liquid-vapor-lqiuid equilibria lines
vapor-solid equilibria lines
liquid-solid equilibria lines

[tinom]

thanks Carlo,
what model do you suggest to calculate the speed of sound in gas+liquid phases for a mixture of hydrocarbons (C1 = 0.7, C2 = 0.12 ...) plus CO2 and H2S ?

[carlo.stenali]

>what model do you suggest to calculate the speed of sound in gas+liquid phases for a mixture of hydrocarbons >(C1 = 0.7, C2 = 0.12 ...) plus CO2 and H2S ?

there are several models as EOS (SRK, PR etc.) which are good for mixtures of hydrocarbons + CO2 and H2S

with Prode Properties the methods which calculates the speed of sound for gas, liquid and gas+liquid are

ss = StrMSS(stream)
given a stream returns the speed of sound for gas, liquid and gas + liquid (for gas + liquid with HEM model)

ss = EStrMSS(stream,t,p)
given the stream pressure and temperature solves a isothermal flash at p,t and returns the speed of sound for gas, liquid and gas + liquid (for gas + liquid with HEM model)

these methods are available in Microsoft Excel as Macros,
for calculating the speed of sound for a gas + liquid mixture follow these steps

1) define the stream composition, models and BIPs (see attached images StreamComp.jpg StreamModel.jpg StreamBIPS.jpg)

2) in a cell put the macro =EStrMSS(1,$B1,$B2) which instructs Excel to calculate the speed of sound at specified temperature and pressure (see attached image SpeedofSoundinExcel.jpg)

3) modify the temperature and pressure and Excel will recalculate automatically the speed of sound for gas, liquid or gas + liquid phases

[tinom]

thanks Carlo,
indeed I have used Soave Redlich Kwong and Peng Robinson with good results,

could you give some information about HEM model ?
How does it work ?

>there are several models as EOS (SRK, PR etc.) which are good for mixtures of hydrocarbons + CO2 and H2S
>
>with Prode Properties the methods which calculates the speed of sound for gas, liquid and gas+liquid are
>
>ss = StrMSS(stream)
>given a stream returns the speed of sound for gas, liquid and gas + liquid (for gas + liquid with HEM model)
>
>ss = EStrMSS(stream,t,p)
>given the stream pressure and temperature solves a isothermal flash at p,t and returns the speed of sound for gas, liquid and gas + liquid (for gas + liquid >with HEM model)
>
>these methods are available in Microsoft Excel as Macros,
>for calculating the speed of sound for a gas + liquid mixture follow these steps
>
>1) define the stream composition, models and BIPs (see attached images StreamComp.jpg StreamModel.jpg StreamBIPS.jpg)
>
>2) in a cell put the macro =EStrMSS(1,$B1,$B2) which instructs Excel to calculate the speed of sound at specified temperature and pressure (see attached >image SpeedofSoundinExcel.jpg)
>
>3) modify the temperature and pressure and Excel will recalculate automatically the speed of sound for gas, liquid or gas + liquid phases

[carlo.stenali]

You may find some information about HEM and HNE models in this blog entry

'http://www.egpet.net/vb/entries/82302-Comparison-of-Homogeneous-equilibrium-%28HEM%29-VS-NON-equilibrium-%28HNE%29-models'

for the results of HEM vs. HNE see the attached image

[cstaff]

thanks for keeping us informed about the features of this product !!!

I have a question about HEM and HNE models for PSV sizing/rating,
do these models work for non-critical flows ?
(I mean a flow where the maximum speed is below critical flow)
It may seem a stupid question but I have to size some PSV with Pset = 5 Bar.a and Pdischarge (flare network, dynamic) = 2 Bar.a