IAPWS-IF97

Water and Steam Properties

EXCEL Add-In Library

EXCEL Water and Steam Properties

IAPWS IF-97
Water and Steam Properties
EXCEL Add-In Library

$239
  • One (1) Installation License
  • For Personal or Commercial Use
  • One-Year Email Support
  • Free Upgrades

REQUIREMENTS

  • Windows Versions: Windows 11, Windows 10
  • Excel Versions: 2016 and later versions.
  • Library available in 32-bit and 64-bit versions.

FEATURES

  • Implements the latest mathematical formulation from the IAPWS-IF97 to calculate properties of water and steam.
  • Calculates 31 thermodynamic and transport properties of water and steam and 10 partial derivatives.
  • More than 400 User Defined Functions (UDF) to be used as an add-in library in EXCEL to generate steam tables or diagram plots.
  • Calculations are valid all over the range of the IAPWS-IF97.
  • It allows for 14 combinations of thermodynamic properties to be entered.
  • Each function validates against the range of values entered in case of an invalid input or result.
  • Includes functions for the SI (metric) and I-P (English) System of Units.
  • Numerical results obtained are suitable for engineering, scientific, industrial or academic use.

IAPWS-IF97 Water and Steam Properties
EXCEL Add-In Library


High-precision calculations of thermodynamic and transport properties of water and steam based on the latest IAPWS-IF97 formulation and IAPWS releases.

MAIN FEATURES

  • Performs all the calculations implementing the latest mathematical formulations from the IAPWS (International Association for the Properties of Water and Steam) Industrial formulation (Revision 2007):
  • Allows for 14 different combinations of thermodynamic properties to be entered as input parameters:
    • Temperature / Pressure
    • Temperature / Specific Enthalpy
    • Temperature / Specific Internal Energy
    • Temperature / Specific Entropy
    • Temperature / Specific Volume
    • Temperature / Vapor Fraction
    • Pressure / Specific Enthalpy
    • Pressure / Specific Internal Energy
    • Pressure / Specific Entropy
    • Pressure / Specific Volume
    • Pressure / Vapor Fraction
    • Specific Enthalpy / Specific Entropy
    • Specific Enthalpy / Specific Volume
    • Specific Internal Energy / Specific Volume

  • Supports input parameters and calculation results in both the SI (metric) and the I-P (English) system of units.
  • For each combination of input thermodynamic properties, it validates the appropriate input values in the valid range of computations.

RANGE OF VALIDITY

The valid range of calculations for thermodynamic properties is defined by the IAPWS (International Association for the Properties of Water and Steam) as shown on Figure 1, together with the correspondent division of regions.


Figure 1. Valid range for the IAPWS-IF97 and regions.

SYSTEM OF UNITS

Thermodynamic variables in the SI (metric) system of units can be entered and/or the calculation results can be displayed in the following units:

  • Pressure: Pa
  • Temperature: K
  • Specific Enthalpy: J/kg
  • Specific Entropy: J/(kg·K)
  • Specific Internal Energy: J/kg
  • Specific Volume: m³/kg
  • Vapor Fraction: kg/kg

Thermodynamic variables in the I-P (English) system of units can be entered and/or the calculation results can be displayed in the following units:

  • Pressure: psi
  • Temperature: °F
  • Specific Enthalpy: Btu/lbm
  • Specific Entropy: Btu/(lbm·°R)
  • Specific Internal Energy: Btu/lbm
  • Specific Volume: ft³/lbm
  • Vapor fraction: lb/lb

Thermodynamic and transport properties calculated

  • Pressure
  • Temperature
  • Specific Enthalpy
  • Specific Entropy
  • Specific Internal Energy
  • Specific Volume
  • Density
  • Speed of Sound
  • Dynamic Viscosity
  • Kinematic Viscosity
  • Thermal Conductivity
  • Thermal Diffusivity
  • Specific Isobaric Heat Capacity
  • Specific Isochoric Heat Capacity
  • Isentropic Exponent
  • Isobaric Cubic Expansion Coefficient
  • Isothermal Compressibility
  • Prandtl Number
  • Vapor Fraction
  • IAPWS-IF97 Region
  • Specific Helmholtz Energy
  • Specific Gibbs Energy
  • Compression Factor
  • Relative Pressure Coefficient
  • Isothermal Stress Coefficient
  • Joule-Thomson Coefficient
  • Dielectric Constant
  • Refractive Index
  • Surface Tension
  • Vapor Pressure
  • Saturation Temperature

Partial derivatives:

  • Derivate of volume on pressure with constant temperature - (dvdP)T
  • Derivate of internal energy on pressure with constant temperature - (dudP)T
  • Derivate of entropy on pressure with constant temperature - (dsdP)T
  • Derivate of enthalpy on pressure with constant temperature - (dhdP)T
  • Derivate of volume on temperature with constant pressure - (dvdT)P
  • Derivate of internal energy on temperature with constant pressure - (dudT)P
  • Derivate of entropy on temperature with constant pressure - (dsdT)P
  • Derivate of enthalpy on temperature with constant pressure - (dhdT)P
  • Derivate of pressure on temperature with constant specific volume - (dPdT)v
  • Derivate of pressure on specific volume with constant temperature - (dPdv)T

Range of Input/Output Variables (SI)

Property

Valid range

Units

Temperature

273.15 ≤ T ≤ 2273.15

K

Pressure

610 ≤ P ≤ 100.0E6

Pa

Specific Enthalpy

-41.5878 ≤ h ≤ 2810.0E3

J/kg

Specific Internal Energy

-282.7252 ≤ u ≤ 6327.862E3

J/kg

Specific Entropy

-8.5823 ≤ s ≤ 13905.8727

J/(kg·K)

Specific Volume

1.00007E-4 ≤ v ≤ 1719.8658

m³/kg

Vapor Fraction

0 ≤ x ≤ 1.0

kg/kg


Range of Input/Output Variables (I-P)

Property

Valid range

Units

Temperature

32.0 ≤ T ≤ 3632.0

°F

Pressure

0.088473 ≤ P ≤ 1450.4

psi

Specific Enthalpy

-0.0178795 ≤ h ≤ 3171.5306

Btu/lbm

Specific Internal Energy

-0.12155 ≤ u ≤ 2720.491

Btu/lbm

Specific Entropy

-0.0020498 ≤ h ≤ 3.32136

Btu/(lbm·°R)

Specific Volume

1.601958E-2 ≤ v ≤ 27549.6

ft³/lbm

Vapor Fraction

0 ≤ x ≤ 1.0

lb/lb

References

  • Revised Release on the IAPWS Industrial Formulation 1997 for the Thermodynamic Properties of Water and Steam, IAPWS (2007).
  • Release on the IAPWS Formulation 2008 for the Viscosity of Ordinary Water Substance, IAPWS (2008).
  • Release on the IAPWS Formulation 2011 for the Thermal Conductivity of Ordinary Water Substance IAPWS (2011).
  • 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, IAPWS (2001).
  • Wagner, W.; Pruß, A.: The IAPWS Formulation 1995 for the Thermodynamic Properties of Ordinary Water Substance for General and Scientific Use. J. Phys. Chem. Ref. Data 31, 387-535 (2002).
  • Wagner, W.; Kretzschmar, H.-J.: International Steam Tables. Springer, Berlin (2008).

REQUEST EVALUATION DEMO

Please fill out the following form to request an evaluation demo version of IAPWS-IF97 Water and Steam Properties EXCEL Add-In Library.
Once you have submitted the form, your request will be processed by our team and an email will be sent to the address provided.





DOCUMENTS


Notice

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to the use of cookies. Please refer to our Cookie Policy, revised Privacy Policy and Terms and Conditions.