Smart questions
Smart answers
Smart people
Join Eng-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips now!
  • 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!

Join Eng-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

JBando (Chemical) (OP)
20 May 03 13:42
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,

Mutt (Chemical)
20 May 03 14:24
There is a free download on 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.
JBando (Chemical) (OP)
20 May 03 19:42
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

quark (Mechanical)
21 May 03 5:48
Helpful Member!  jproj (Chemical)
21 May 03 9:46
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.  

psafety (Specifier/Regulator)
21 May 03 12:00
Are you looking for saturated or superheat conditions?  I might be able to help you.  

JBando (Chemical) (OP)
21 May 03 17:46

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.

JBando (Chemical) (OP)
22 May 03 13:33
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,

joerd (Chemical)
23 May 03 3:11
Check out Thread770-51434



tommyg141 (Marine/Ocean)
30 Jun 03 14:02

Can you please shoot me a copy of your tables.
Many Thanks

arifpatel (Mechanical)
5 Jul 03 16:06

Please e mail me copy of your steam table to me

TD2K (Chemical)
9 Jul 03 10:01
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.

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!

Back To Forum

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