Spreadsheet Templates
included with Rules of Thumb for Chemical Engineers, 6th 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.
Rightclick Name to download.
Chapter  Description 
The template constructs a table of flash points for binary mixtures 

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. Twophase flow problems are solved. 

This template provides blank data sheets for vessels and agitators 

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

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. 

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 pressureenthalpy diagram with user inputs for flow, pressure, temperature, number of stages, intercooling temperature, and isentropic efficiency. 

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

The primary purpose of this workbook is to demonstrate the use of the BellDelaware method for rating shellandtube 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. 

Vaporliquid equilibrium calculations with and without activity coefficients are given culminating in the creation of a McCabeThiele diagram. 

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

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. 

Size a waste heat boiler 

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

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. 

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