Three articles on the approximation functions for the properties of
H2O have been published and associated computer code has been produced:
||Light Water Approximations
Water Properties in Excel:
- Based on the above water property fits, Excel spreadsheet functions were created by Glen R. McGee using Visual Basic for Applications (VBA) to calculate water properties. This is recommended to anyone using Excel to analyse thermalhydraulic data.
- ReadMe file (pdf 12kb) - supporting documentation, short but contains important and useful information.
- T_mach2o.xls (xls 86kb) - sample file containing the functions in action.
- sample-wjg.xls (xls 340kb) - another sample file showing the functions in action and a comparison to the IAPWS funtions, also included (see below).
Other available light water property software include:
- IAPWS Water97_v13.xla – Excel Add-In for Properties of Water and Steam
in SI-Units authored by Bernhard Spang, Hamburg, Germany
available at http://alexmichinel.com/index.php?p=1_9 or http://www.falchemist.com/2010/automation/vba/steam-tables-in-excel-vba/
- These IAPWS functions are unquestionably the more definitive ones over the McMaster based ones. For heavy number crunching where speed is of the essence, or where analytical slopes are needed, or where smooth transitions across the saturation line are needed, the McMaster based fits are the better bet perhaps.