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.
Right-click 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. Two-phase 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.
BSRIA to publish fifth edition of Rules of Thumb building services guidelines by Rebecca Walker — March 11, 2011—BSRIA, the consultancy, test, instruments and research organization, is set to publish the fifth edition of its Rules of Thumb in April. BSRIA has published the fifth edition of its ‘Rules of thumb’, which now comes in a user-friendly spiral-bound format. New additions include greatly increased guidance about space and weight allowances.
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 pressure-enthalpy 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 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. Vapor-liquid equilibrium calculations with and without activity coefficients are given culminating in the creation of a McCabe-Thiele 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.
Rules of Thumb are general principles derived from practice and experience rather than precise theory. The 5th edition of Rules of Thumb has been created by referencing various contemporary sources in the building services industry and can reasonably be held to reflect current design practices. As with our previous guide, it will be useful for approximately calculating values, setting outline targets and rapidly comparing different options to inform the early stages of the design process. This popular publication has been updated and expanded to include more detailed information and now comes in a more user-friendly spiral-bound format.