Physical Properties Excel Workbook
Originally published: 27/11/2017 14:06
Publication number: ELQ-49500-1
View all versions & Certificate

Physical Properties Excel Workbook

Physical Properties workbook to calculate steam & water thermodynamic properties.

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
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:

*Originally shared on*

This Best Practice includes
1 Downloadable Physical Properties Workbook in Excel

Stephen Hall offers you this Best Practice for free!

download for free

Add to bookmarks


3.8 / 5 (5 votes)

please wait...