Physical Properties Excel Workbook

Description
Template in excel highlighted by VBA functions to calculate steam & water thermodynamic properties. The template also contains calculations to work out viscosity, gas solubility, relative humidity, the compressibility factor for twenty-five compounds, and the surface tension.

This workbook is comprised of 8 worksheets:
Mixture Viscosity
Emulsion Viscosity
Antoine Coefficients
Relative Humidity
IAPWS
Gas Solubility
Surface Tension
Thermo Properties

Macros must be enabled for function subroutines to work.

This template accompanies Chapter 27: 'Physical Properties' of Rules of Thumb for Engineers, 6th Edition by Stephen M Hall, PE. The templates are intended to solve problems outlined in the book, explain techniques for converting U.S. & SI units of measure, demonstrate data look up methods, and provide you with ready-to-use data sheets. The function subroutines can also be copied to other spreadsheets.

You can buy the textbook here:
https://www.amazon.com/Rules-Thumb-Chemical-Engineers-Sixth/dp/0128110376

*Originally shared on pipesizingsoftware.com*