Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Peng Robinson Vapor Liquid Ratio

GaTechTheron

Mechanical
Jan 26, 2006
109
I need determine the ratio of liquid to gas, of a flashing LNG mixture. I'm using Peng Robinson EOS, and I cannot use HYSYS, refprop, or any external tool to Excel. I have the flash calculation working, so I have all fugacitys and relative composition of liquid and vapor for all components.

My knowns are the feed composition, temp, pressure, feed flow.

Is there a way to get liquid composition (after flash), or should I assume its the same as the feed? In HYSYS they are nearly the same.

Is there a way to get vapor or liquid flow rates ? I'm trying to avoid a huge system of equations, but I'm not against doing this provided its reasonable to build in excel.

Thanks !
 
Replies continue below

Recommended for you

If this is an adiabatic feed flash, temp will drop after the letdown valve. In this case, you'll have both compositional equilibrium and enthalpy equilibrium problems to converge and it will then be easier to run this on a simulator if you ask me.
If your feed temperature is after the letdown, then you have an isothermal feed flash, and this may be easier to work out the only problem related to compositional equilibrium - see Perry Chem Engg Handbook 7th edn page 13-25 for algorithm for isothermal flash calcs.
 
Hi,
Let you perform the calculation, and you will get your answers.
A calculator is shared (link)
A set of equations/method is also available, bottom of the page under reference "Che guide", click on it.

Pierre
 
Last edited:
in Excel, Python etc. you can easily obtain fugacities, vapor/liquid fraction, mass and volume flows and many other properties with an add-in library, see


it includes many thermodynamic models suitable for LNG including Peng-Robinson, GERG 2008 etc. and a complete set of multiphase flash operations...

Hoping this helps.
 
If this is an adiabatic feed flash, temp will drop after the letdown valve. In this case, you'll have both compositional equilibrium and enthalpy equilibrium problems to converge and it will then be easier to run this on a simulator if you ask me.
If your feed temperature is after the letdown, then you have an isothermal feed flash, and this may be easier to work out the only problem related to compositional equilibrium - see Perry Chem Engg Handbook 7th edn page 13-25 for algorithm for isothermal flash calcs.
Very helpful, and thank you, this calculation is confirming what I was afraid of. My case is isothermial flash. The solution is both iterative, and a very large number of equations for a mixture of say 10-12 components.
 
in Excel, Python etc. you can easily obtain fugacities, vapor/liquid fraction, mass and volume flows and many other properties with an add-in library, see


it includes many thermodynamic models suitable for LNG including Peng-Robinson, GERG 2008 etc. and a complete set of multiphase flash operations...

Hoping this helps.
This is helpful, thank you ! I can use this with other somewhat related problems I'm working to solve.
 

Part and Inventory Search

Sponsor