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


Steam Table- In Excel

Steam Table- In Excel

Steam Table- In Excel

Hi there:

I am looking for Steam property generation in Excel. Well, the Steam Table as such. It seems ASME table are preferred choice, but I will be able to keep going with any functional form. Any pointers?

thanks well in advance,


RE: Steam Table- In Excel

There is a free download on www.chempute.com that apparently does hydraulic calcs and generates steam properties quite accurately - I haven't used it - I use my own rough VBasic add-in for steam enthalpies and Tsat calcs.

RE: Steam Table- In Excel

Dear Mutt:

I normally use Aspen for most of my simulation, and other property info. however, my present organization do not have any simulator. So, I am looking around for get something free, and easily implementable in Excel.

Using NIST webbook, you can get baisc data. Years ago it used to be free call "Steam67", presently they also charge. So do few others applictions. However, I saw one link to France, but if you are an US or Canadian resident, then you can not download from their site. Furthermore, we have to contact someone in NIST for getting the program! Anyway, I am looking around.....

Thanks for you suggestion


RE: Steam Table- In Excel

I copied a steam table from my Thermodynamics book with pressure, temperature, enthalpy and specific volume (no entropy or internal energy).  Post your e-mail and I can send you a copy.  


RE: Steam Table- In Excel

Are you looking for saturated or superheat conditions?  I might be able to help you.  


RE: Steam Table- In Excel


Thanks a bunch. I did see the site, and go the Excel Add In. Also, I found few other places, including Original Steam 67 Fortran source code! I am looking around.


jprog: Well you have lot of work!
Here is my e-mail address:


Looking for saturated, but I would expect to be able to calculate for superheated steam also. I think both uses Helmoltz (?)  energy function for calculation? I am not sure.

Thanks for your help anyway,
I will put all the information I found
I am glad to see such nice group.


RE: Steam Table- In Excel

Thanks a bunch Jproj. I will reply from other mail shortly.
I am thinking to apply some technique to inter polate the data table. I will update you accordingly.

thanks again,


RE: Steam Table- In Excel


Please e mail me copy of your steam table to me


RE: Steam Table- In Excel

I'd second quark's recommendation.  I'm using it and it does a good job matching my copy of the steam tables for the spot checks I did on the pressure and temperatures.  

As it's an add-in, installation is a snap and it's available then in any spreadsheet you build.

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!


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close