1 reply to this topic

[Rspinks]

All,
I am new and find it fasinating with all the information and resources on this site. I have been looking for spreadsheets which will allow me to generte a phase diagram either for a single component or a composition. For single components i find most charts do not allow me to pin point specific regions and i then am interpertating the result with a best guess. I would prefer to generate a more specific result which would provide me more flexability in my decisions to applicate sample systems.

I also am looking for a spread sheet allowing me to determine the dew point to be better to applicate sample system design to ensure either liquid or gas requirements are met.

I deal with refining for the most part in the analytical business primarily with (diesel, gasoline, LPG's, etc.)

I appreciate any help in direction for these useful tools.

Regards,
Randy

[PaoloPemi]

You may find Excel pages which can calculate dew point or bubble point for simple mixtures of hydrocarbons.
However as I use mainly Excel in my work (natural gas plants) and I tested these solutions I would suggest a different approach, that is a process library, it is a software which integrates with Excel and exports methods as Excel Macros, that is : you write in a Excel's cell
=StrLD(1)
and Excel returns the density of liquid phase of stream 1 with the required units
I have two different tools, Prode Properties (see prode.com) and NIST Refprop (see nist.gov), previously I did use Prode mainly for phase equilibria and NIST for density.
However , when I purchased the extended version of Prode I discovered that Prode has extended versions of Peng Robinson and Soave Redlich Kwong which are more accurate (for properties as density, cp, latent heat etc.) than those normally available in simulators so I started to prefer Prode.
Actually i am able to solve little plants as gas dehydration units (with CPA-PR model), there is a rigorous tower model, results have been compared against other simulators and I believe they are quite accurate.
In addition Prode includes many utilities available in simulators, you can regress VLE/LLE data, print a phase envelope, a hydrate formation curve etc.