Udemyallen

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.

3.9(66)
586students
28m
Certificate
WR Training
WR TrainingProfessional Development for the Energy Sector

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

$ whoami — the devs behind tutorialsearch.io

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.