About Steam95 and Steam97 Excel Add-In Package
The Steam9597 package contains two Excel Add-In libraries for calculation of properties of water and steam:
- Steam95 Excel Add-In based on the scientific formulation (IAPWS-95)
- Steam97 Excel Add-In based on the industrial formulation (IAPWS-IF97)
The libraries are fully integrated in Excel, and available functions can be used in the same way as any other Excel function.
Main features of the library:
- Professional quality, industrial strength software, proven in real world applications
- Based on the international standard formulations (IAPWS-95, IAPWS-IF97)
- License includes 32 bit and 64 bit version of the library
- Developed in C++ for maximum speed, thoroughly tested for accuracy
- Create User Defined Functions (UDF) which use Steam95 and/or Steam97 functions
- Call Steam95 and Steam97 functions from VBA (samples are included in the release version)
- Easy to install and easy to use
- One year free technical support
Steam95 Excel Add-In
The Steam95 Excel Add-In library calculates 30 thermodynamic and transport properties of water and steam.
It allows 11 different combinations of input variables to be used for calculations.
Input variables that can be used are:
- 1 Pressure
- 2 Temperature
- 3 Enthalpy
- 4 Entropy
- 5 Volume
- 6 Internal energy
- 7 Steam quality
The library also provides 7 helper functions for calculation of properties on fluid phase boundaries and retrieval of important constants of water and steam.
Used Formulations (Steam95)
The library uses new scientific formulation for steam tables, called "The IAPWS Formulation 1995 for the Thermodynamic Properties of Ordinary Water Substance for General and Scientific Use", and replaces the previous scientific formulation, IAPS-84.
IAPWS-95 significantly improves accuracy of the calculation of the thermodynamic properties compared with the old formulation.
For transport properties calculations are based on the latest internationally accepted equations also available from IAPWS.
Steam97 Excel Add-In
The Steam97 Excel Add-In library calculates 30 thermodynamic and transport properties of water and steam.
It allows 16 different combinations of input variables to be used for calculations.
Input variables that can be used are:
- 1 Pressure
- 2 Temperature
- 3 Enthalpy
- 4 Entropy
- 5 Volume
- 6 Internal energy
- 7 Steam quality
The following figure shows a sample spreadsheet included in the download package.
Steam 95 and Steam 97 Excel Add-In - Sample calculations in Excel
Used Formulations
The library uses new industrial formulation for steam tables, called "IAPWS Industrial Formulation 1997 for the Thermodynamic Properties of Water and Steam (IAPWS-IF97)", and replaces the previous industrial formulation for steam tables, IFC-67.
IAPWS-IF97 improves significantly both accuracy and speed of the calculation of the thermodynamic properties compared with the old formulation.
For transport properties calculations are based on the latest internationally accepted equations also available from IAPWS.
NOTE:
The Steam95 and Steam97 Excel Add-In libraries cannot be shipped to a third party as a part of your VBA application. If you need a royalty free library please refer to the Steam97 ActiveX DLL.
System Requirements
Operating system Windows 7 / Windows 8 / Windows 8.1 / Windows 10 / Windows 11.
Excel 2010 (32 bit & 64 bit) / 2013 (32 bit & 64 bit) / 2016 (32 bit & 64 bit) / 2019 (32 bit & 64 bit) / 2021 or 365 desktop (32 bit & 64 bit).
User privileges
Installation and use of the library requires standard user privileges or better.
Steam Properties
The following thermodynamic and transport properties can be calculated with Steam95 and Steam97 Excel Add-In libraries:
| Calculable properties in SI or E units - Steam9597 Excel Add-In v3.1 |
|---|
| | Property Name | Steam95 | Steam97 |
|---|
| 1 | Pressure | yes | yes |
| 2 | Temperature | yes | yes |
| 3 | Density | yes | yes |
| 4 | Specific volume | yes | yes |
| 5 | Specific enthalpy | yes | yes |
| 6 | Specific entropy | yes | yes |
| 7 | Specific internal energy | yes | yes |
| 8 | Specific isobaric heat capacity | yes | yes |
| 9 | Specific isochoric heat capacity | yes | yes |
| 10 | Speed of sound | yes | yes |
| 11 | Isentropic exponent | yes | yes |
| 12 | Specific Helmholtz free energy | yes | yes |
| 13 | Specific Gibbs free energy | yes | yes |
| 14 | Compressibility factor | yes | yes |
| 15 | Steam quality | yes | yes |
| 16 | Region | - | yes |
| 17 | Isobaric volume expansion coefficient | yes | yes |
| 18 | Isothermal compressibility | yes | yes |
| 19 | Partial derivative (dV/dT)p | yes | yes |
| 20 | Partial derivative (dV/dP)T | yes | yes |
| 21 | Partial derivative (dP/dT)v | yes | yes |
| 22 | Partial derivative (dP/dV)T | yes | yes |
| 23 | Isothermal Joule-Thomson coefficient | yes | yes |
| 24 | Joule-Thomson coefficient | yes | yes |
| 25 | Dynamic viscosity | yes | yes |
| 26 | Kinematic viscosity | yes | yes |
| 27 | Thermal conductivity | yes | yes |
| 28 | Thermal diffusivity | yes | yes |
| 29 | Prandtl number | yes | yes |
| 30 | Surface tension | yes | yes |
| 31 | Static dielectric constant | yes | - |
Range of Validity
Steam95 Excel Add-In
The entire set of equations of IAPWS-95, used by the application for calculation of thermodynamic properties, is defined by the following temperature and pressure range:
- melting-pressure / sublimation-pressure curve <= T <= 5000 K
- p <= 100000 MPa
Steam97 Excel Add-In
The entire set of equations of the IAPWS-IF97, used by the library for calculation of thermodynamic properties, is defined by the following temperature and pressure range:
- 273.15 K <= T < = 1073.15 K p < = 100 MPa
- 1073.15 K < T < = 2273.15 K p < = 50 MPa
Fig.1 Steam table regions defined in the IAPWS-IF97
Screenshots
The following screenshots demonstrate how to use the library, it's a 4 step process.
1.(a) Start Excel and press the "Insert Function" toolbar button.
1.(b) Alternatively, start Excel and press the "Insert Function" menu item.
2. Select a Steam95 library (SI or English units).
3. Select a function and press the OK button.
4. Enter input parameters and press the OK button.
NOTE: You don't have to put quotes around the property ID, they are inserted automatically.
That's it, the result will be displayed in the selected cell.
Steam95 and Steam97 VBA Programming
The release version of the Steam9597 Excel Add-In library contains "modCallFunction" module which provides VBA wrapper utility functions.
The utility function CallFunction makes it easy to call Steam95.xll and Steam97.xll functions from VBA. For more information please refer to the help file provided in both demo and release versions.
Example 1
This excerpt from the code demonstrates how to calculate heat of evaporation for given saturation temperature.
Example 2
This excerpt from the code demonstrates how to calculate steam turbine efficiency.
Downloads
The setup program will automatically install the library in Excel.
To install the library successfully you must have at least standard user privileges on your computer.
IMPORTANTThe built-in ZIP support on Windows 10 is buggy and sometimes cannot open a valid (not empty) zip file.
Use 7-zip (free and open source) or some other reliable program for zip file processing.
Steam95 and Steam 97 Excel Add-In library
For Excel 2007 / 2010 (32 bit) / 2013 (32 bit) / 2016 (32 bit) / 2019 (32 bit) / 365 desktop (32 bit)
- Download Steam9597 Excel Add-In Package version (3.1) - demo (32 bit)
Steam95 and Steam 97 Excel Add-In library
For Excel 2010 (64 bit) / 2013 (64 bit) / 2016 (64 bit) / 2019 (64 bit) / 365 desktop (64 bit)
- Download Steam9597 Excel Add-In Package version (3.1) - demo (64 bit)
You can also evaluate the Steam Tables library (based on IAPWS-95 and IAPWS-IF97) online, visit Steam Tables Calculator web application. It uses the same calculation engines as the Steam95 and Steam97 Excel Add-Ins.
Quick reference documents
- List of available properties in the Steam95 and Steam97 Excel Add-Ins
- List of available functions in the Steam95 and Steam97 Excel Add-Ins
Steam diagrams
- logP-H diagram in SI units generated with Steam97 Excel Add-In
Price info
Prices subject to change without notice!
- A license includes 32 bit and 64 bit versions of the Steam95 and Steam97 Excel Add-In libraries
- A license also includes the Steam97 Desktop Application (calculate properties, mollier diagrams, printing...)
| Steam9597 Excel Add-In version 3.1 |
|---|
| 1-4 licenses | USD 399.95 per copy |
| 5 > licenses | USD 349.95 per copy |
| Company wide license | USD 11995.00 |
NOTE:
Each license also includes the following:
- One year free e-mail technical support
- One year free minor version updates if available (for example 3.2, 3.x up to, but not including version 4.0)
If you have any questions, please don't hesitate to contact sales. Contact information is provided on the following page:
Contact Us - (opens in a new tab)
General Information
For quick access to the Steam9597 Excel Add-In, you may purchase and download our product using automated and secure online ordering system.
After ordering, you will receive a notification mail with further instructions for how to download and install the software.
The Registration includes a free subscription program. Each Registered user will be receiving bug fixes and technical support for the registered version within one year.
Shipping by the postal mail is not available.
How to order
1. Internet ordering
Available ordering options (open an order form to select):
- Credit Card (Visa®, Mastercard®, American Express®, Discover®)
- PayPal
- Amazon
To buy a specific number of licenses for the Steam9597 Excel Add-In click the button: 
.
To purchase a Company Wide License contact sales. Contact information is provided on the following page:
Contact Us - (opens in a new tab)
2. Bank Direct Payment
If you prefer to pay for the product by "Bank Direct Payment", contact sales. Contact information is provided on the following page:
Contact Us - (opens in a new tab)