Spreadsheet Templates

included with Rules of Thumb for Chemical Engineers, 5th Edition by Stephen M. Hall, PE

Spreadsheet templates accompany many of the book chapters. They run under Microsoft Excel; most of the templates utilize Visual Basic for Applications (VBA) macros or functions. For this reason, programs like Open Office or Excel 97 for Mac do not support the templates. Note that VBA returned with Excel 2010 for the Mac, and our spreadsheets do work in that version.

The templates solve problems that are explained in the book, demonstrate techniques for converting between U.S. and SI units of measure, illustrate data lookup methods, and provide data sheets ready for use. The function subroutines can be copied to other spreadsheets, making this a truly useful toolbox for practicing chemical engineers.

Right-click Name to download.



01 – Fluid Flow

VBA function subroutines that solve Reynolds number, friction factor and pressure drop problems for both compressible and incompressible flow are provided in this template. The functions are used to solve a range of example problems. Two-phase flow problems are solved.

02 – Heat Exchangers

The primary purpose of this workbook is to demonstrate the use of the Bell-Delaware method for rating shell-and-tube heat exchangers. The method is applicable to exchangers with liquids on shell and tube sides. The worksheets follow the text in the stepwise evaluation of a heat transfer problem that is defined by the hot and cold fluid properties. A data sheet is completed.

03 – Fractionators

Vapor-liquid equilibrium calculations with and without activity coefficients are given culminating in the creation of a McCabe-Thiele diagram.

04 – Absorbers

For a packed gas scrubber, the height of a transfer unit, number of transfer units, and required packing depth are calculated and illustrated.

05 – Pumps

This template provides a range of calculations useful for selecting and sizing centrifugal pumps, and includes data sheets for pumps and control valves. System curves, temperature rise, power, water hammer, and NPSH calculations are included.

06 – Fans, Blowers and Compressors

Calculations are given for estimating the power requirement for reciprocating and centrifugal compressors. There is a VBA function for calculating the compressibility factor for a gas. Then, the power is calculating using a pressure-enthalpy diagram with user inputs for flow, pressure, temperature, number of stages, intercooling temperature, and isentropic efficiency.

08 – Vessels

This template provides blank data sheets for vessels and agitators

11 – Refrigeration

Data sheets for mechanical refrigeration systems and steam jet refrigeration systems are given

15 – Pneumatic Conveying

The procedure described in the text for calculating pressure drop in a dilute phase conveyer is worked out in the spreadsheet

16 – Blending and Agitation

This template includes calculations for blend time, helical ribbon agitator power, settling velocity, gasses and ungassed power, and mechanical design parameters.

17 – Process Evaluation

This template provides a blank data sheet for specifying capacitance type level instruments

20 – Safety

The template constructs a table of flash points for binary mixtures

24 – Energy Conservation

For a given fuel type the template calculates the average cost to make steam. Examples described in the text are included, and a worksheet for preparing a composite curve is presented.

25 – Process Modeling

This workbook illustrates techniques for incorporating variable input data into a process model, using VBA subroutines.

27 – Physical Properties

This template is highlighted by the VBA functions that calculate water and steam thermodynamic properties. It also includes calculations for viscosity, relative humidity, gas solubility, surface tension, and the compressibility factor for 25 compounds.