×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

equation-of-state in Microsoft Excel format

equation-of-state in Microsoft Excel format

equation-of-state in Microsoft Excel format

(OP)
Hi,

Is there a Swave Redlich Kwong, Ping Robinson, etc. equation of state Excel spreadsheet available?

We are looking for specific heat, thermal conductivity, density and viscosity of different mixtures at various temperatures and pressures.

Most of our uses are hydrogen, air, natural gas, nitrogen, ammonia, water, oils, etc.

A link a download would be helpful.

Heater Guy

RE: equation-of-state in Microsoft Excel format

Short of buying a version of HYSYS I dont think you will find anything that you would consider reliable enough to design equipment on.

RE: equation-of-state in Microsoft Excel format

These equation are not difficult to program in  an Excel spreadsheet; you may find them in many physical chemistry books. The problem I see is that you will not find the necessary basic constants for your particular systems, that you have to put into the equations.
M777182

RE: equation-of-state in Microsoft Excel format

(OP)
I found a program called Prode (www.prode.com). The demo version works in Excel. Does anyone have experience with this program. My concern is how well it will work with additional calculations. It seems that the embedded Prode calculations need to be forced (Cntl+Alt+F9) to work.

RE: equation-of-state in Microsoft Excel format

Hi heaterguy,
i have also tried the demo version of prode under excel and found for simple systems (2 components with SRK) acceptable consistency with commercial sim. pcks (hysis).
Can't say how it will work in more complex situations (btw have you seen that eng-tips has a 'Prode Products' forum? but, it's empty...).

On the other hand, i have a couple of spreadsheet once i downloaded (donno where...) with SRK and PR equations implemented to calculate V, enthalpy H and enthropy S.

I could share with you, if i'd only know how...

HTH

_LF

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources