Water (H2O) Steam Properties - Excel Add-In

The H2O Properties Excel add-in provides the thermodynamic and transport properties for water and steam over the entire range of pressure and temperature values as defined by the IAPWS (International Association for the Properties of Water and Steam) IF97 Industrial Formulation. Note that the NIST steam tables (National Institute of Standards and Technology) and ASME steam tables (American Society of Mechanical Engineers) are also based upon the IAPWS IF97 Industrial Formulation.

The user’s inputs may be pressure and quality, pressure and enthalpy, pressure and entropy, entropy and enthalpy, pressure and quality, or temperature and quality. In addition to the standard thermodynamic and transport properties; pressure, temperature, quality, specific enthalpy, specific entropy, specific internal energy, specific volume, isobaric heat capacity, isochoric heat capacity, speed of sound, viscosity and thermal conductivity; the program may also be used to return the steam properties partial derivatives. These partial derivatives of water and steam are useful for steam turbine performance testing and uncertainty calculations, steam boiler performance testing and uncertainty calculations, optimal geothermal steam separator flash pressure calculations, water and steam flow and uncertainty calculations, etc. The inputs and results to the program may be in SI (MPa, bar, kPa, Kelvins, Celsius, kg, etc.) or in US or British customary units (psi, degrees Fahrenheit, BTU, etc.) with the exception of the partial derivative calculations which currently are only available in SI units.

In addition to the water and steam properties for Excel (Windows 1997 or higher) add-in that is available for purchase; a free online water and steam properties calculator is provided in order to support the engineering and education community.

Download now and start your free 30 day trial.

Already downloaded and need help installing? Click here.

You can purchase a single license for the low price of $100 (USD) by using PayPal. Click one of the PayPal buttons below. Upon completion of purchase, your license key will be sent to your PayPal email address. Alternatively, please contact us at sales@infopogo.com for volume licensing, purchase orders, etc.

Logo

The following functions steam properties are implemented in the Excel Add-In:

The following IAPWS documents were used in the program development and are referenced in this manual and in the programs interactive help files.

1. IAPWS R7-97(2012): Revised Release on the IAPWS Industrial Formulation 1997 for the Thermodynamic Properties of Water and Steam. (IAPWS-IF97). (Revised August 2007).

2. IAPWS SR2-01(2014): Revised Supplementary Release on Backward Equations for Pressure as a Function of Enthalpy and Entropy p(h,s) to the IAPWS Industrial Formulation 1997 for the Thermodynamic Properties of Water and Steam. (Revised June 2014).

3. IAPWS SR3-03(2014): Revised Supplementary Release on Backward Equations for the Functions T(p,h), v(p,h) and T(p,s), v(p,s) for Region 3 of the IAPWS Industrial Formulation 1997 for the Thermodynamic Properties of Water and Steam. (Revised June 2014).

4. IAPWS SR4-04(2014): Revised Supplementary Release on Backward Equations p(h,s) for Region 3, Equations as a Function of h and s for the Region Boundaries, and an Equation Tsat(h,s) for Region 4 of the IAPWS Industrial Formulation 1997 for the Thermodynamic Properties of Water and Steam. (Revised June 2014).

5. IAPWS SR5-05(2016): Revised Supplementary Release on Backward Equations for Specific Volume as a Function of Pressure and Temperature v(p,T) for Region 3 of the IAPWS Industrial Formulation 1997 for the Thermodynamic Properties of Water and Steam. (Revised September 2016).

6. IAPWS R12-08: Release on the IAPWS Formulation 2008 for the Viscosity of Ordinary Water Substance.

7. IAPWS R15-11: Release on the IAPWS Formulation 2011 for the Thermal Conductivity of Ordinary Water Substance.

8. IAPWS R1-76(2014): Revised Release on the Surface Tension of Ordinary Water Substance. (Revised June 2014).

9. ASME International Steam Tables for Industrial Use, Third Edition (2014). Introductory text from this document is incorporated into this manual in order to provide general background guidance to the user.