About Steam95 and Steam97 Excel Add-In Package
The Steam9597 contains two Excel Add-In libraries, Steam95 Excel Add-In based on the scientific formulation for the
properties of water and steam, and Steam97 Excel Add-In based on the industrial formulation for the properties of water and steam.
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:
- pressure,
- temperature,
- enthalpy,
- entropy,
- volume,
- internal energy,
- 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.
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.
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:
- pressure,
- temperature,
- enthalpy,
- entropy,
- volume,
- internal energy,
- 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
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.
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 Steam97 ActiveX DLL.
|
System Requirements
Operating system Windows 2000/XP/Vista.
Excel 97 or better.
User privilages
Installation and use of the library requires standard user privilages or better.
Steam Properties
The following termodynamic and transport properties can be calculated with Steam95 and Steam97 Excel Add-Ins:
| Calculable properties in SI or E units - Steam9597 v1.0.0 |
| |
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 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 < = 10 MPa
Screenshots
The following screenshots demonstrate how to use the library.
1.(a) Start Excel and press "Insert"->"Function" menu item.
1.(b) Alternatively, start Excel and press "Paste Function" toolbar button.
2. Select a function and press OK button.
3. Enter input parameters and press OK button.
NOTE: You don't have to put quotes around property ID they are inserted automatically.
That's it, 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.
'Calculate saturation pressure for given temperature
ps = CallFunction("SatTXsi", t, xLiquid, "p")
Worksheets("Heat of Evaporation").Cells(row, 2).Value = ps
'Calculate specific enthalpy of the liquid on the saturation line
hLiquid = CallFunction("SatTXsi", t, xLiquid, "h")
Worksheets("Heat of Evaporation").Cells(row, 3).Value = hLiquid
'Calculate specific enthalpy of the vapor on the saturation line
hVapor = CallFunction("SatTXsi", t, xVapor, "h")
Worksheets("Heat of Evaporation").Cells(row, 4).Value = hVapor
'Calculate heat of evaporation
delta_h = hVapor - hLiquid
Worksheets("Heat of Evaporation").Cells(row, 5).Value = delta_h
|
Example 2
This excerpt from the code demonstrates how to calculate steam turbine efficiency.
'Calculate specific enthalpy
hIn = CallFunction("SteamPTsi", pIn, tIn, "h")
Worksheets("Steam Turbine").Cells(row, 3).Value = hIn
'Calculate specific entropy
sIn = CallFunction("SteamPTsi", pIn, tIn, "s")
Worksheets("Steam Turbine").Cells(row, 4).Value = sIn
Worksheets("Steam Turbine").Cells(row, 5).Value = pOut
Worksheets("Steam Turbine").Cells(row, 6).Value = tOut
'Calculate specific enthalpy
hOut = CallFunction("SteamPTsi", pOut, tOut, "h")
Worksheets("Steam Turbine").Cells(row, 7).Value = hOut
'Calculate specific enthalpy
hs = CallFunction("SteamPSsi", pOut, sIn, "h")
Worksheets("Steam Turbine").Cells(row, 8).Value = hs
'Calculate steam turbine efficiency
eta = (hIn - hOut) / (hIn - hs) * 100
Worksheets("Steam Turbine").Cells(row, 9).Value = eta
|
Downloads
The setup program will automatically install the library in Excel.
Steam95 & Steam97 Excel Add-In libraries
Quick reference documents
Price info
Prices subject to change without notice!
| Steam9597 Excel Add-In Package version 1.0.0 |
| 1-4 licenses |
US $ 399.95 per copy |
| 5 > licenses |
US $ 349.95 per copy |
| Company wide license |
US $ 9995.00 |
Note: when purchasing a license you receive one year subscription for free.
The subscription includes updates and e-mail technical support.
If you have any questions, please don't hesitate to contact our sales:
sales@megawatsoft.com
General Information
For immediate access to 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, your
password (required during installation) and the retail version download location.
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.
For software registration we employ the services of one of the leading American
registering firms RegSoft.com.
Details about the company you can find at the RegSoft.com's website
http://www.regsoft.com/.
How to order
Internet ordering
Available ordering options:
- Credit Card
- PayPal
- FAX Ordering
- Phone
To view an order form, preview order options or buy specific number of licenses for
Steam9597 Excel Add-In
click the button:
or to purchase a Company wide license click here:
.
Voice Ordering System (Phones)
We also understand that Internet sales and support methods are not comfortable for everyone.
RegSoft.com's Voice Ordering System is an excellent alternative for registering software online
and for obtaining answers to ordering questions. Payments may be accepted by mail or phone. You
will need following information:
Product ID: 74689.
In the United States:
Toll-Free Order Phone Number : 1-877-RegSoft (1-877-734-7638)
International Order Phone Number: +1-770-319-2718
|