Derived from a collaboration between Dale Gulley from Gulley & Associates and Art Montemayor, this workbook contains invaluable information related to process heat transfer derived almost entirely their combined years of experience.

MS Excel spreadsheet includes:

Notes and Experiences (expanded below)

TEMA Designations

Tube Counts

Heat Balance

Shell and Tube Spec Sheet

Plate Exchanger Spec Sheet

Typical U-values

Shell Side Pressure Drop Calculation

Shell and Tube Rating

Sample Condenser Calculation

Condenser Tube Data

Tubesheet Thickness Calculation

Tubesheet Layouts

Notes and experience section includes the following:

Air Coolers:

1. Air flow accessories - don't overlook these when calculating fan HP2. Box header design - limit of process temperature change3. Connecting bundles of existing coolers for a new service4. Fan drive changes that increase capacity of existing cooler5. Fan drive noise - suggestions on how to reduce6. Maximum motor HP for a fan7. Maximum tube wall temperature for wrap-on fins8. Optimum number of tube rows9. Overall heat transfer rate estimate for hydrocarbons10. When do bare tubes become more efficient than fin tubes?11. When To limit number of tube passes in air coolers12. When to use wind coolers

1. Deciding on what fin spacing to use2. Estimate of nozzle size for HRSG3. Face area estimate for HRSG units4. Maximum exhaust gas temperaure for steel fin tubes5. When to use bare tubes in waste heat boilers

1. Allocation of streams in shell & tube2. Articles published by Dale Gulley3. Avoid these fluids when using lowfin tubing4. Best heat transfer flow pattern5. Check liquid thermal conductivity at high reduced temperatures6. Check piping connections when there is under-performance7. Evaluating an exchanger for a new service8. Check heat release curve data for skipping over dewpoints and bubblepoints9. When will exchangers with low-fins be more economical than exchangers with bare tubes?10. Problems with excess heat exchanger surface11. Purchasing warning for shell & tube exchangers12. What is the minimum velocity inside tubing for slurries?13. Suggestions for low-fins and potential S & T bundle vibration14. Choose shell & tube or multi-tube heat exchangers15. Thermal design problem with shell side long baffle16. Trouble shooting article in Hydrocarbon Processing17. Under-surfaced S&T quote18. When to add shell in Series19. When to consider a long baffle in the shell20. Which stream goes inside the tubes of gas/gas exchangers?21. Weighted MTD22. Why did performance decline in a TEMA type F,G or H type shell?23. Zone those condensers24. Fouling factors for water25. Fouling Factors for Liquid Hydrocarbons

This extensively well written covers all aspects of shell and tube heat exchangers. Many thanks to the author.
I have a small comment:
For removable tube bundles (U tube) I usually use a type "I" shell where one end is capped. It looks like the ketle type except there is no enlargement for liquid vapor disengagement. However no ASME classification is given neither in Perry or elsewhere. The only place I can find it is in the Chinese code. Why is this popular type ignored ?