IAPWS-IF97

Water and Steam Properties

EXCEL Add-In Library

Software Box

IAPWS-IF97

Water and Steam Properties

EXCEL Add-In Library

$239
  • One (1) Installation License
  • For Personal or Commercial Use
  • One-Year Email Support
  • Free Upgrades
BUY 32-bit Version BUY 64-bit Version
Secure Ordering by FastSpring

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).

Example of Calculation Results in Excel

Input combination: Pressure, Temperature

Example of Calculation Results in Excel

Example of Calculation Results in Excel

Input combination: Temperature, Specific Enthalpy

Example of Calculation Results in Excel

Example of Calculation Results in Excel

Input combination: Temperature, Specific Entropy

Example of Calculation Results in Excel

Example of Calculation Results in Excel

Input combination: Pressure, Vapor Fraction

Example of Calculation Results in Excel

Example of Plot Data

Specific Volume as a function of Temperature and Vapor Fraction

Example of Plot Data

Example of Plot Data

Specific Enthalpy as a fiunction of Temperature and Vapor Fraction

Example of Plot Data

Example of Plot Data

Dynamic Viscosity at Saturation line

Example of Plot Data

Example of Plot Data

Sound Velocity at Saturation line

Example of Plot Data

Request Evaluation Demo

Please fill out the following form to request an evaluation demo version of WS-EXCEL.
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