About Steam 97 Excel Add-In
The Steam97 Excel Add-In library calculates 30 thermodynamic and transport properties
of water and steam in SI and English units. 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,
- and steam quality.
The library is 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;
- Based on the international standard formulation;
- Accurate and thoroughly tested;
- Create User Defined Functions (UDF) which use 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.
|
The following figure shows a sample spreadsheet included in the download package.
Steam 97 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 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.
NOTE:
|
The 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 Steam 97 Excel Add-In:
| Calculable properties in SI or E units - Steam97 Excel Add-In v1.6.0 |
| 1 |
Pressure |
| 2 |
Temperature |
| 3 |
Density |
| 4 |
Specific volume |
| 5 |
Specific enthalpy |
| 6 |
Specific entropy |
| 7 |
Specific internal energy |
| 8 |
Specific isobaric heat capacity |
| 9 |
Specific isochoric heat capacity |
| 10 |
Speed of sound |
| 11 |
Isentropic exponent |
| 12 |
Specific Helmholtz free energy |
| 13 |
Specific Gibbs free energy |
| 14 |
Compressibility factor |
| 15 |
Steam quality |
| 16 |
Region |
| 17 |
Isobaric volume expansion coefficient |
| 18 |
Isothermal compressibility |
| 19 |
Partial derivative (dV/dT)p |
| 20 |
Partial derivative (dV/dP)T |
| 21 |
Partial derivative (dP/dT)v |
| 22 |
Partial derivative (dP/dV)T |
| 23 |
Isothermal Joule-Thomson coefficient |
| 24 |
Joule-Thomson coefficient |
| 25 |
Dynamic viscosity |
| 26 |
Kinematic viscosity |
| 27 |
Thermal conductivity |
| 28 |
Thermal diffusivity |
| 29 |
Prandtl number |
| 30 |
Surface tension |
Range of Validity
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" toolbar button.
1.(b) Alternatively, start Excel and press "Insert"->"Function" menu item.
2. Select a Steam97 library (SI or English units).
3. Select a function and press OK button.
4. 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.
Steam97 VBA Programming
The release version of the Steam97 Excel Add-In library contains "modCallFunction" module which
provides VBA wrapper utility functions.
The utility function CallFunction makes it easy to
call 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.
Steam 97 Excel Add-In library
Quick reference documents
Steam diagrams
Price info
Prices subject to change without notice!
| Steam97 Excel Add-In version 1.6.0 |
| 1-4 licenses |
US $ 249.95 per copy |
| 5-20 licenses |
US $ 224.95 per copy |
| 21 > licenses |
US $ 199.95 per copy |
| Company wide license |
US $ 7995.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 Steam97 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
Steam97 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: 62054.
In the United States:
Toll-Free Order Phone Number : 1-877-RegSoft (1-877-734-7638)
International Order Phone Number: +1-770-319-2718
|