Excel Engineering
Open source freeware engineering.

Google

X Steam Tables for MS Excel


Free open source IAPWS IF97 steam and water properties for industrial use implemented as VBA scripts.
 - No installation,
   Scripts are stored in the
Excel (Ooo) workbook!
 - Open source.

That the water properties are implemented as scripts in the workbook are a unike advantage. No distrubution problems, just open it anywhere.  Please view the Excel X-Steam information page for further specifications and development tasks. Download for free from the download page.

Information

Steam and water properties for MS Excel according to the IAPWS IF97 standard formulation. (www.iapws.org)

A complete implementation. Uses short intuitive calling names. The steam tables are implemented as Excel VBA scripts and stored inside a workbook. (No extra .DLL file or installation required to run the excel spread sheet. The excel calcualtion can be distrubuted)

OBS!!
XSteam are Excel Macros, Make sure "Tool:Macros:Security..." are set to medium before opening the file and answer "Enable Macros" in the security warning displayed when opening the file!

The code are open source. You are free to use, modify and distribute the code as long as authorship is properly acknowledged (freeware). Download it from the Download menu.

Advantages

  • Complete implementation. For a list of calling functions se bellow.

  • No installation or .dll files needed, everything is stored in the Excel, OpenOffice document.

  • Since the macros are stored in the workbook calculations can be distrubuted to anyone without them having to install any programs etc.

  • Simple to use

  • Fast calculations
     

Molliere chart produced with the steam tables.
(Download the excel chart from the download menu for free.)

Installation

The macros in XSteam are stored inside a workbook. If you want to be able to use the Macros in all your workbooks without storing a copy of XSteam in each workbook the macros could be installed to your add in directory. See XSteam Excel Installation

Calling syntax

A list of valid XSteam calling functions are provided bellow and in the Excel/Open office Calc document. XSteam functions take 1 or 2 arguments.

• Example: h_pt(1,20) Returns the enthalpy of water at 1 bar and 20 degC

• Example: TSat_p(1) Returns the saturation temperature of water at 1 bar.

For a list of valid Steam Table functions se
the XSteam Information or the Calling spreadsheet in the excel file.
 

 

Last updated 2006-07-20