Available

Heat Exchanger Design Workbook

Heat duty, LMTD and estimated heat-transfer area for preliminary exchanger sizing.

DisciplineTHERMAL
Resource typeCalculation Workbook
Skill levelIntermediate
LanguageEnglish

About this resource

Preliminary exchanger sizing starts with an energy balance and a mean temperature difference. This workbook keeps those steps visible: process-stream conditions enter one sheet, and the heat duty, balance difference, LMTD and estimated heat-transfer area come out in a sequence that can be checked line by line.

Hot-side and cold-side duty are calculated independently and compared, so an inconsistent property or flow input shows up as a balance difference rather than a quiet error. The corrected mean temperature difference and heat-transfer area are reported only for the configurations the workbook implements.

The overall heat-transfer coefficient is an input. Fouling, phase change and detailed shell-and-tube mechanical design stay outside the scope, and the workbook says so on the calculation sheet.

It is intended for preliminary thermal and process engineering work, not for detailed thermal-hydraulic rating.

What is included

  • Heat Exchanger Design Workbook workbook — XLSX · Calculator with live formulas, worked example, assumptions and licence sheets. · Editable
  • PDF user guide — PDF · Three-page guide: inputs, method and equations, worked example, units and limits. · Not editable
  • Heat duty from hot-side and cold-side process conditions
  • Hot-side and cold-side energy balance with the difference reported
  • Log Mean Temperature Difference (LMTD)
  • LMTD correction factor only for implemented and validated configurations
  • Required heat-transfer area from a specified overall heat-transfer coefficient
  • Formula, unit and assumption reference

Software compatibility

  • Microsoft Excel: Excel 2016 or later, desktop or Microsoft 365 · required · edit · format based expectation — Formulas use standard worksheet functions only. The workbook was recalculated and checked before release; desktop Excel behaviour is a format-based expectation.
  • LibreOffice Calc: 7.6 or later · optional · edit · format based expectation — Formulas use standard worksheet functions only. The workbook was recalculated and checked before release; desktop Excel behaviour is a format-based expectation.

Prerequisites and technical context

Intended audience

Working engineer, Early-career engineer, Engineering team, Engineering student

Prerequisites

  • Hot-fluid and cold-fluid inlet and outlet temperatures
  • Mass flow rates for both streams
  • Specific heat capacities at the property basis used
  • An overall heat-transfer coefficient appropriate to the service

Unit systems

  • SI thermal units: °C, kg/s, kJ/kg·K, kW, m², W/m²·K
  • Consistent field units where supported by the workbook

Assumptions

  • Steady-state operation with no heat loss to the surroundings
  • Constant specific heat over the stated temperature range
  • Counter-flow or other explicitly supported arrangement
  • Fouling and wall resistances included in the entered overall coefficient

Technical notes

  • Hot-side and cold-side duty are compared to expose property or flow inconsistencies.
  • The LMTD correction factor is limited to the configurations the workbook implements.
  • The area result is an estimate from the entered coefficient, not a rating.

References

  • No external standards or references listed.

Scope and limitations

Included

  • Heat duty from hot-side and cold-side process conditions
  • Hot-side and cold-side energy balance with the difference reported
  • Log Mean Temperature Difference (LMTD)
  • LMTD correction factor only for implemented and validated configurations
  • Required heat-transfer area from a specified overall heat-transfer coefficient
  • Formula, unit and assumption reference

Not included

  • Detailed shell-and-tube mechanical design, tube-sheet design and pressure-vessel design
  • Vibration limits and mechanical integrity checks
  • Fouling, phase change, multipass and complex configurations beyond the validated cases
  • Pressure-drop calculation and thermal-hydraulic rating
  • Automatic selection of a commercial exchanger model

Limitations

  • Preliminary thermal sizing only.
  • Fluid properties must be supplied or taken from a verified source at the correct conditions.
  • The overall heat-transfer coefficient is an input unless a validated module is provided.
  • Thermal and hydraulic checks are separate; the workbook does not imply a pressure-drop calculation.

Author and review information

Author / publisher: Curious Engineering

Review status: Author checked

Equations are implemented as transparent worksheet formulas with the unit handling shown on each sheet. The shipped worked example uses the default inputs and can be reproduced by hand.

Review scope: Before release, every checked result was recalculated from the workbook and compared with an independent implementation of the same equations, including the worked example, unit conversions and boundary checks. No independent third-party review was commissioned.

Licence and permitted use

Single-user commercial licence

One named user may use this workbook on any number of their own devices for commercial and educational engineering work. Resale, redistribution, publication, sublicensing and inclusion in a paid course or product are not permitted. Adapted copies remain subject to the same terms.

  • Use on your own projects, including paid client work
  • Use for teaching and internal training
  • Adapt the formulas and layout for your own internal templates
  • Keep a personal or company archive copy for business continuity

Not permitted

  • Reselling, sublicensing or distributing the file
  • Publishing the file on a website, shared drive or marketplace
  • Including the file in a paid course, product or template pack
  • Removing the licence, attribution or version notices
Read licence information

Delivery

Orders are confirmed by email before payment. After payment clears, the workbook and PDF guide are sent as a secure download link together with the licence and a short getting-started note. Usually within one business day.

Related resources

  • Pressure Vessel Design Calculator · $19 — An Excel workbook for preliminary internal-pressure thickness calculations on cylindrical shells, with corrosion allowance and a nominal-thickness comparison.
  • Pump Sizing & Selection Calculator · $12 — An Excel workbook for preliminary pump duty: flow conversion, static and friction head, Total Dynamic Head, hydraulic power and estimated shaft power.