Heat Exchangers Design & Calculation Excel Workbook
Excel workbook for heat exchanger design & performance analysis. Optimize efficiency and gain valuable insights. Practical tool for engineers & professionals.
Course Content
Heat Exchangers Design & Calculation Excel Workbook is an all-levels Udemy course taught by WR Training. It runs 28m, is taught in English, and includes a certificate of completion. Learners rate it 3.9 out of 5 from 66 reviews, with 586 students enrolled. It is a paid course, last updated June 2025.
Heat Exchanger Design & Calculation Excel Workbook: Your Essential Engineering Toolkit
Streamline heat exchanger design, selection, and maintenance with this comprehensive Excel workbook. Designed for engineers, designers, and technical professionals in the oil & gas, chemical, petroleum, and refining industries, this powerful toolkit puts critical data and calculations at your fingertips.
Key Features & Benefits
- Comprehensive Technical Data: Access physical properties of common process fluids (water, steam, hydrocarbons, and more) including saturation properties, thermal conductivity, specific heat capacities, and fouling factors.
- Advanced Engineering Calculations: Perform accurate pressure loss calculations for both tube and shell sides in shell and tube heat exchangers. Calculate geometrical parameters for various shell and tube configurations.
- Standards Compliance: Design data compliant with DIN 28184 & 28191 and TEMA Standards ensures reliability and industry best practices.
- Efficient Selection & Sizing Tools: Step-by-step guidance for selecting the optimal shell and tube heat exchanger. Utilize geometrical data tables for precise sizing and specification.
- Valuable Charts & Diagrams: Ready-to-use heat exchanger charts, figures, and diagrams for quick reference. Includes numerous conversion tables.
- User-Friendly & Organized: Well-structured worksheets for easy data retrieval and tool access.
- Ideal For: Design, operation, maintenance, and inspection tasks. Perfect for process engineers, chemical engineers, mechanical engineers, plant designers, maintenance professionals, and engineering students.
Core Calculation Modules
This workbook provides detailed calculations for:
I/ Spreadsheet Calculations:
- Fluid Properties: Calculate properties of water and steam (saturation properties with temperature & pressure), dynamic and kinematic viscosity, weight density, gas compressibility factor, specific gravity, boiling point, vapor pressure (pure and mixture), and thermal conductivity for various fluids.
- Overall Heat Transfer Coefficient (U): Calculate approximate and detailed U-values, including those derived from heat transfer coefficients and refinery process data (liquid/gaseous hydrocarbons).
- Heat Transfer Coefficients (α): Calculate approximate and tube/shell side heat transfer coefficients as a function of flow velocity.
- Heat Calculations: Determine heat load, heat exchange area, corrected effective temperature differences, temperature efficiency factor, and outlet temperatures.
- Pressure Losses: Calculate tube side and shell side pressure losses, including nozzle and baffle effects.
- Geometrical Calculations: Calculate tube side flow cross-section, velocity, number of tubes, and pressure drop. Calculate shell side flow cross-section, velocity, number of baffles, and tube rows.
- Geometrical Data: Access geometrical data for shell & tube heat exchangers according to DIN 28184 - 28191 and TEMA Standards.
- Dimensionless Numbers: Calculate relevant dimensionless numbers for heat exchanger analysis.
II/ Charts & Diagrams:
- TEMA Heat Exchanger Tables: Quick access to TEMA standard data.
- Exchanger Nomenclature: Understand standard exchanger designations (AES, AEP, AJW, AKT, BEM, CFU).
- Heat Exchanger Design Procedure: A clear outline of the design process.
- Heat Exchanger Selection Guidelines: Best practices for selecting the right exchanger.
- Tube Patterns & Baffles: Visual aids for understanding different tube layouts and baffle configurations.
- LMTD Calculations: Calculate Log Mean Temperature Difference.
- TEMA Data Sheets: Access TEMA data sheets for shell & tube heat exchangers.
- TEMA Class Comparison: Understand the features of TEMA class R, C, and B heat exchangers.
- Shell & Tube Exchanger Features: Explore exchanger features based on design type.
- Conversion Tables: Quick reference for various units.
Who is this workbook for?
- Anyone involved in heat exchanger design, selection, or troubleshooting.
- Engineering students and technical trainees.
- Process, chemical, and mechanical engineers.
- Plant designers and maintenance professionals.
Why Choose This Workbook?
- Save Time: Access all essential formulas, data, and standards in one place.
- Improve Accuracy: Minimize errors with built-in calculations and up-to-date standards.
- Work Smarter: Streamline project workflows with ready-to-use engineering tools.
Equip yourself with the Heat Exchanger Excel Workbook and make your next project faster, easier, and more reliable!
WR Training – Your Partner in Process Engineering & Plant Excellence
IMPORTANT NOTES: This workbook requires Microsoft Excel and basic Excel knowledge. Macros must be enabled for Visual Basic for
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.