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



People using this Best Practice also downloaded


More Best Practices from Stephen Hall


Related categories

Any questions on Physical Properties Excel Workbook?

The user community and author are here to help. Go ahead!

4.0 / 5 (4 votes)

please wait...