This Heat Exchanger Design Playbook spreadsheet from 3D-LABS follows ASME standards and gives instant, checkable results for practising engineers — no manual derivation required.
Heat Exchanger Design Playbook — Shell, Tube, Plate and Air-Cooled covers complete thermal-hydraulic design of shell-and-tube heat exchangers per TEMA/ASME, gasketed plate heat exchangers, brazed plate, and air-cooled fin-fan exchangers with sizing equations, fouling factors, and pressure drop calculations.
What standards does this book reference?
TEMA Class R/C/B (2019 edition) for shell-and-tube mechanical design, ASME VIII Div 1:2023 for pressure boundary design, ISO 15547-1:2005 (plate heat exchanger thermal and pressure drop methods), and API 661:2006 (air-cooled heat exchangers for general refinery use).
What is the heat exchanger sizing formula?
Q = U x A x F x LMTD, where Q is duty (kW), U is overall heat transfer coefficient (W/m2-K), A is heat transfer area (m2), and F is the LMTD correction factor (0.75-0.98 for multi-pass exchangers from TEMA charts). Overall U: 1/U = 1/hi + r_wall/k_wall + 1/ho + Rf_i + Rf_o, where Rf_i and Rf_o are fouling resistances (m2-K/W from TEMA Table RGP-T-2.4 — e.g. cooling water 0.000176 m2-K/W).
What tube-side heat transfer coefficient formula is used?
Dittus-Boelter equation for turbulent flow (Re greater than 10,000): Nu = 0.023 x Re^0.8 x Pr^n, where n = 0.4 for heating and n = 0.3 for cooling. Tube-side coefficient hi = Nu x k / Di. TEMA recommends tube-side velocity 0.9 to 2.4 m/s for liquids (TEMA Cl. RCB-2.31). For laminar flow (Re less than 2300): Sieder-Tate correlation with viscosity correction is used.
How do I access this book after purchase?
eBook PDF: Instant download via email and 3D-LABS dashboard. Paper Book: Printed and shipped to India.
What’s Included
An instant Excel download with the complete formula set, a worked numerical example, and reference to the governing standard — ready to adapt to your own project inputs.

