7th September 2007

Steam Properties Excel Add-In

posted in engineering |

Warning: copy() [function.copy]: Filename cannot be empty in /home/jlhdes/public_html/wp-content/plugins/mytube/mytube.php on line 220

If you are not a mechanical engineer or someone that deals with steam based calculations daily then you can skip reading the rest of this.

What I’ve set up is an Excel Add-In that adds the steam tables as functions to be used like any other functions within your excel applications. I’ll leave it on the site, on the off chance that someone will actually find it to download.

This simple little add-In adds dozens of functions to your install of Microsoft Excel. The functions return steam properties so you can use them in your calculations without having to reference a steam table.

Installation instructions are included in the download.

The following functions will be added to your excel:

tempP - Returns the Steam Temperature (F) at given Pressure in PSIG
sensP - Returns the Sensible Heat (Btu/lb) at given Pressure in PSIG
latentP - Returns the Latent Heat (Btu/lb) at given Pressure in PSIG
condvolumeP - Returns the Condensate Volume (ft3/lb) at given Pressure in PSIG
steamvolumep - Returns the Steam Volume (ft3/lb) at given Pressure in PSIG
PressureT - Returns the Steam Pressure (PSIG) at given Temperature (F)
SensT - Returns the Sensible Heat (Btu/lb) at given Temperature (F)
LatentT - Returns the Latent Heat (Btu/lb) at given Temperature (F)
condvolumeT - Returns the Condensate Volume (ft3/lb) at given Temperature (F)
steamvolumeT - Returns the Steam Volume (ft3/lb) at given Temperature (F)
tempL - Returns the Steam Temperature (F) at given Latent Heat in BTU/LB
PressureL - Returns the Steam Pressure (PSIG) at given Latent Heat in BTU/LB
sensL - Returns the Steam Sensible Heat (Btu/LB) at given Latent Heat in BTU/LB
condvolumeL - Returns the Cond Volume (Ft3/LB) at given Latent Heat in BTU/LB
steamvolumeL - Returns the Steam Volume (Ft3/LB) at given Latent Heat in BTU/LB
PressureS - Returns the Steam Pressure (PSIG) at given Sensible Heat in BTU/LB
tempS - Returns the Steam Temperature (F) at given Sensible Heat in BTU/LB
latentS - Returns the Steam Latent Heat (Btu/LB) at given Sensible Heat in BTU/LB
condvolumeS - Returns the Cond Volume (Ft3/LB) at given Sensible Heat in BTU/LB
steamvolumeS - Returns the Cond Volume (Ft3/LB) at given Sensible Heat in BTU/LB
PressureC - Returns the Steam Pressure (PSIG) at given Cond Volume in Ft3/LB
tempC - Returns the Steam Temperature (F) at given Cond Volume in Ft3/LB
latentC - Returns the Steam Latent Heat (Btu/LB) at given Cond Volume in Ft3/LB
SensC - Returns the Steam Sensible Heat (Btu/LB) at given Cond Volume in Ft3/LB
steamvolumeC - Returns the Steam Volume (Ft3/LB) at given Cond Volume in Ft3/LB
PressureSV - Returns the Steam Pressure (PSIG) at given Steam Volume in Ft3/LB
tempSV - Returns the Steam Temperature (F) at given Steam Volume in Ft3/LB
latentSV - Returns the Steam Latent Heat (Btu/LB) at given Steam Volume in Ft3/LB
SensSV - Returns the Steam Sensible Heat (Btu/LB) at given Steam Volume in Ft3/LB
condvolumeSV - Returns the Cond Volume (Ft3/LB) at given Steam Volume in Ft3/LB

This entry was posted on Friday, September 7th, 2007 at 10:34 am and is filed under engineering. You can follow any responses to this entry through the RSS 2.0 feed. All comments are subject to my NoFollow policy. Both comments and pings are currently closed.

There are currently 7 responses to “Steam Properties Excel Add-In”

Why not let me know what you think by adding your own comment! All the cool kids are doing it.

  1. 1 MyAvatars 0.2 On September 12th, 2007, dockarl said:

    BINGO!

    You’ve just produced something that’s more than likely extremely useful to folks in my Industry (the sugar industry). We’ve got a majot prob in most of the factories with steam balance (ie we have to blow off abt 40% of our energy output as steam to keep the factory running) and I think this will be usefulm to the eng’s that deal with changing factories - I’ve passed it on to a few folks there.

    Cheers,

    Matt

  2. 2 MyAvatars 0.2 On September 20th, 2007, John Honeck "JLH" said:

    Thanks Matt, I haven’t heard a complaint yet, it works great.

  3. 3 MyAvatars 0.2 On September 21st, 2007, dockarl said:

    Hmm.. it’s weird - I submitted this to a sugar technologist’s mailing list but it hasn’t come through yet - I’ll try again :-D

    Cheers,

    M

  4. 4 MyAvatars 0.2 On September 21st, 2007, John Honeck "JLH" said:

    What’s really weird is that Akismet tagged you as Spam. Then again it caught Matt Cutts earlier this week as spam also. Maybe it has something against Matts? Both of you are already approved commenters. Time for a Sphinn Title like, “Akismet hates all Matts”

  5. 5 MyAvatars 0.2 On September 21st, 2007, dockarl said:

    That is totally strange too… I’ve often wondered how akismet goes about ‘tagging spammers’ - is it as simple as someone marking a legit comment as spam once being the kiss of death for your IP? I dunno..

    M

  6. 6 MyAvatars 0.2 On September 13th, 2008, Gautam said:

    Matt, the addin works great. But could you publish the same tables in SI system, that would rock!

  7. 7 MyAvatars 0.2 On September 14th, 2008, John Honeck "JLH" said:

    Who’s Matt?

  • Please Support

    • Marquette University

  • Sponsored

125x125

  • Donations


    • ;

Enter your email address:

Delivered by FeedBurner

rss posts
Spread the Word
Sphinn
delicious
digg
technorati
reddit
magnolia
stumbleupon
yahoo
google

  • Readers