|
Nie obrażaj więc mojej inteligencji poprzez czynione na pokaz zaniżanie własnej.
Water97_v13.xla – Excel Add-In for Properties of Water and Steam in SI-Units
Email: b.spang@hamburg.de
Copyright 2000-2002 by Bernhard Spang. All rights reserved. May be redistributed for free, but may not be changed or sold without the author's explicit permission. Provided "as is" without warranty of any kind.
Introduction
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
Installation
The functions are provided as an Add-In file (water97_v13.xla) for MS Excel. After downloading and decompressing the archive file which contains "water97_v13.xla" you may load "water97_v13.xla" in Excel every time you need it by going to Tools...Add-ins or by simply double clicking on "water97_v13.xla" in Explorer. The water property functions are then available just like built-in functions. In the function Wizard list they can be found under User Defined. See also the documentation for MS Excel for more information about add-in files.
Reference of available functions
Functions are available for calculating the following properties in the single-phase state for temperatures 273.15 K £ T £ 1073.15 K and pressures 0 < p £ 1000 bar
- density - 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 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).
1. Density in single-phase state
a) Usage: densW(T; P)
b) Argument(s): T temperature in K P pressure in bar
c) Unit: density in kg/m3
d) Range of validity: 273.15 K £ T £ 1073.15 K and 0 < p £ 1000 bar
e)Error: densW = -1, temperature and/or pressure outside range
f) Example: density of water at 1 bar and 20 °C formula in worksheet cell: =densW(20+273.15; 1)
2. Specific internal energy in single-phase state
a) Usage: energyW(T; P)
b) Argument(s): T temperature in K P pressure in bar
c) Unit: specific internal energy in kJ/kg
d) Range of validity: 273.15 K £ T £ 1073.15 K and 0 < p £ 1000 bar
e)Error: energyW = -1, temperature and/or pressure outside range
f) Example: specific internal energy of water at 10 bar and 400 K formula in worksheet cell: =energyW(400; 10)
3. Specific enthalpy in single-phase state
a) Usage: enthalpyW(T; P)
b) Argument(s): T temperature in K P pressure in bar
c) Unit: specific enthalpy in kJ/kg
d) Range of validity: 273.15 K £ T £ 1073.15 K and 0 < p £ 1000 bar
e)Error: enthalpyW = -1, temperature and/or pressure outside range
f) Example: specific enthalpy of water at 10 bar and 400 K formula in worksheet cell: =enthalpyW(400; 10)
4. Specific entropy in single-phase state
a) Usage: entropyW(T; P)
b) Argument(s): T temperature in K P pressure in bar
c) Unit: specific entropy in kJ/(kg K)
d) Range of validity: 273.15 K £ T £ 1073.15 K and 0 < p £ 1000 bar
e)Error: entropyW = -1, temperature and/or pressure outside range
f) Example: specific entropy of water at 10 bar and 400 K formula in worksheet cell: =entropyW(400; 10)
5. Specific isobaric heat capacity in single-phase state
a) Usage: cpW(T; P)
b) Argument(s): T temperature in K P pressure in bar
c) Unit: specific isobaric heat capacity in kJ/(kg K)
d) Range of validity: 273.15 K £ T £ 1073.15 K and 0 < p £ 1000 bar
e)Error: cpW = -1, temperature and/or pressure outside range
f) Example: specific isobaric heat capacity of steam at 1 bar and 120 °C formula in worksheet cell: =cpW(120+273.15; 1)
6. Specific isochoric heat capacity in single-phase state
a) Usage: cvW(T; P)
b) Argument(s): T temperature in K P pressure in bar
c) Unit: specific isochoric heat capacity in kJ/(kg K)
d) Range of validity: 273.15 K £ T £ 1073.15 K and 0 < p £ 1000 bar
e)Error: cvW = -1, temperature and/or pressure outside range
f) Example: specific isochoric heat capacity of steam at 1 bar and 120 °C formula in worksheet cell: =cvW(120+273.15; 1)
7. Dynamic viscosity in single-phase state
a) Usage: viscW(T; P)
b) Argument(s): T temperature in K P pressure in bar
c) Unit: dynamic viscosity in Pa s
d) Range of validity: 273.15 K £ T £ 1073.15 K and 0 < p £ 1000 bar
e)Error: viscW = -1, temperature and/or pressure outside range
f) Example: dynamic viscosity of water at 1 bar and 20 °C formula in worksheet cell: =viscW(20+273.15; 1)
8. Thermal conductivity in single-phase state
a) Usage: thconW(T; P)
b) Argument(s): T temperature in K P pressure in bar
c) Unit: thermal conductivity in W/(m K)
d) Range of validity: 273.15 K £ T £ 1073.15 K and 0 < p £ 1000 bar
e)Error: thconW = -1, temperature and/or pressure outside range
f) Example: thermal conductivity of water at 1 bar and 20 °C formula in worksheet cell: =thconW(20+273.15; 1)
9. Boiling point as a function of pressure
a) Usage: tSatW(P)
b) Argument(s): P pressure in bar
c) Unit: boiling point in K
d) Range of validity: 611.657 Pa £ p £ 220.64 bar
e)Error: tSatW = -1, pressure outside range
f) Example: boiling point of water at 1 bar in °C formula in worksheet cell: =tSatW(1)-273.15
10. Vapor ... |
Menu
|