This program is developed for internal use in our company. However, we have been asked by some of our clients to make it public. Therefore we have decided to publish it for free general use. We have checked the result of the calculations thoroughly, but we will not take any responsibility in case there should be any errors.
The program is used in conjunction with EXCEL 5 or higher using the macro language VISUAL BASIC FOR APPLICATIONS. The program will not work with EXCEL 4 or older versions.
The program is including a number of functions for water and steam, both for thermodynamical and physical data. All the background material has been taken from the book "Properties of Water and Steam. Wolfgang Wagner and Alfred Kruse, Springer-Verlag, 1998."
The base for the data is "IAPWS Industrial Formulation 1997 for the Thermodynamic Properties of Water and Steam". The data are valid for the temperature varying from 0 ºC to 800 ºC and the pressure from 0.006 bar(a) to 1000 bar(a). The data are in SI or SI derived units.
As pressure unit the bar absolute is used. The unit for energy is the kJ.
For thermal conductivity we have used data from a former book with 1967 equations corrected to be reasonably in accordance with the present book data.
The basic data have been used to calculate other derived units as Prandtl Number, isentropic exponent etc.