Steam tables are an important ingredient in many engineering calculations and in case of Excel based calculations, great quality improvement and time saving can be achieved if steam table data can be retrieved automatically rather than input manually. This is especially true if a calculation needs to be updated and steam conditions have to be varied.
Many commercial solutions can be found on the internet and these are either standalone programs or compiled excel addins. However, it is less known that there is a freeware alternative using the industrial standard IAPWS-IF97. It was coded in visual basic by Bernhard Spang from Hamburg in Germany.
Water97_v13.xla is an Add-In for MS Excel which provides a set of functions for calculating thermodynamic and transport properties of water and steam using the industrial standard IAPWS-IF97. For more information about IAPWS-IF97, underlying equations and references see www.cheresources.com.
Functions are available for calculating the following properties in the single-phase (vapor or liquid) state for temperatures 273.15 K ≤ T ≤ 1073.15 K and pressures 0 < p ≤ 1000 bar
- specific internal energy
- specific enthalpy
- specific entropy
- specific isobaric heat capacity
- specific isochoric heat capacity
- dynamic viscosity
- thermal conductivity
Additionally there are functions for calculating the boiling point temperature as a function of pressure and the vapor pressure as a function of temperature as well as for the above eight properties for the saturated liquid and vapor state both as a function of temperature and pressure between 273.16 K or 611.657 Pa and 647.096 K or 220.64 bar (critical point).
The addin may be redistributed for free, but may not be changed or sold without the author’s explicit permission. It is provided “as is” without warranty of any kind.