Megawatsoft
MegaWatSoft
Home
Steam Tables>
Psychrometrics>
CO2 Tables>
Excel Add-Ins>
Web Applications>
Contact Us







HomeSteam TablesSteam 95 and Steam 97 Excel






IAPWS-95 and IAPWS-97 Excel Add-Ins

Steam Tables (IAPWS-95 and IAPWS-97)
(32 bit & 64 bit)


Steam95 and Steam97 Excel Add-In Package

For Excel 2003 / 2007 / 2010 (32 bit & 64 bit) / 2013 (32 bit & 64 bit)



Introduction
Features
Screenshots
VBA
Downloads
Price Info
Buy
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:
  1. Steam95 Excel Add-In based on the scientific formulation (IAPWS-95), and
  2. Steam97 Excel Add-In based on the industrial formulation (IAPWS-IF97).


Main features of the libraries:
  • Professional quality, industrial strength software;
  • Based on the international standard formulations;
  • Accurate and thoroughly tested;
  • Create User Defined Functions (UDF) which use Steam95 and/or Steam97 functions;
  • Developed in C++ for maximum speed;
  • Easy to install and easy to use;
  • For installation and use of the library no administrator rights required;
  • After installation no computer restart required;
  • 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. The library is fully integrated in Excel, and available functions can be used in the same way as any other Excel function.
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.
It is fully integrated with Excel and can be used in the same way as any other Excel function.

The following figure shows a sample spreadsheet included in the download package.



Steam97 Excel Add-In - Sample calculations in Excel


Used Formulations (Steam97)

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














Copyright © 2002-2014 MegaWatSoft Inc., all rights reserved.
Other product and company names herein may be the trademarks of their respective owners.