Heat Exchangers Design & Calculation Excel Workbook

Based on your request to provide information similar to what would be found in a typical Heat Exchanger Design and Selection Excel workbook for training purposes, here's an overview of the contents and structure you might expect:

I. Introduction

• Purpose of the workbook
• Description of the heat exchanger design and selection process
• Overview of the parameters and calculations involved

II. Fluid Properties A. Physical properties 1. Density, viscosity, specific heat capacity 2. Thermal conductivity for water, liquids, and gases 3. Specific and molar heat capacities of fluids B. Inherent properties 1. Prandtl number, Reynolds number, Nusselt number 2. Fouling factors for various fluids

III. Heat Transfer Coefficients (α) A. Overall heat transfer coefficient (uα) 1. Approximate values 2. Calculations based on refinery process data - Liquid hydrocarbons coolers, gaseous hydrocarbons coolers, total hydrocarbons condensers 3. General formula-based calculations B. Tube side (h_i) and Shell side (h_o) heat transfer coefficients 1. As a function of flow velocity - Tube side: laminar, turbulent regimes - Shell side: crossflow, countercurrent configurations

IV. Heat Calculations A. Heat load determination B. Heat exchange area calculation 1. Formula-based methods 2. Corrected effective mean temperature difference (ΔT_hm) 3. Temperature efficiency factor (η_T) C. Outlet temperatures for both hot and cold fluids

V. Pressure Losses in Shell & Tube Heat Exchangers A. Tube side pressure loss 1. ∆P through tubes, nozzles, baffle window, shell tube, and nozzles B. Shell side pressure loss 1. ∆P across baffle window, nozzles

VI. Dimensionless Numbers A. Reynolds number, Nusselt number, Prandtl number, etc.

VII. Charts and Diagrams A. Tema heat exchanger table B. AES, AEP, AJW, AKT, BEM, CFU exchanger nomenclature diagrams C. Heat exchanger design procedure flowchart D. Heat exchanger selection guidelines E. Tube patterns and configurations F. LMTD (Logarithmic Mean Temperature Difference) calculation diagram G. TEMA data sheet for shell & tube heat exchangers H. Comparison of TEMA class R, C, and B heat exchangers I. Features according to type of design J. Conversion tables (e.g., from SI to imperial units)

VIII. Excel Functions and Subroutines

• Macros for automated calculations
• Data validation tools for input data
• Chart generation for visual representation of results

IX. User Instructions A. How to use the workbook B. Steps for designing and selecting a heat exchanger C. Tips for interpreting the results

X. Conclusion A. Summary of key points B. Final thoughts on best practices in heat exchanger design and selection

XI. Disclaimer and Notes

• Warning that the workbook is provided "as is"
• Instructions to enable macros for proper functionality

This structure is designed to guide users through the process of designing and selecting a heat exchanger, with a combination of theoretical knowledge, practical calculations, and visual tools to facilitate understanding and application. It's important to note that while this workbook can serve as a valuable educational tool, actual design and selection should be carried out by qualified professionals in compliance with industry standards and safety regulations.