Home › Shop › Shell and Tube Heat Exchanger Performance and Fouling
Excel tool

Shell and Tube Heat Exchanger Performance and Fouling

See how dirty your exchanger really is, what it costs you, and when to clean it.

Actual U, fouling resistance and cleanliness from plant readings — with the duty lost to fouling, its yearly cost and the best cleaning interval.

USD 49

FormatExcel workbook (.xlsx), no macros
Versionv1.0
Works inExcel 2010 or later, Windows and Mac
UnitsSI, US and British, mixed freely
IncludesGuide tab with method and references, calculator, print-ready report
Checked againstShah & Sekulić worked examples 3.6, 3.8 and 13.2; steam and propane condensing duties within 0.1 % of reference data.
Free versionTry the online calculator

Single-user licence. Team and site licences: see options. Instant download after payment; you also get updates to this major version.

Shell and Tube Heat Exchanger Performance and Fouling — sample pages

What it does

Performance from plant readings

Duty from the enthalpy change of each stream (boiling and condensing included), heat balance check, LMTD, F factor, actual U, fouling resistance and cleanliness.

Any arrangement

Counter-current, co-current, 1-2 TEMA E shell or several shells in series.

About 165 built-in fluids

Water and steam, refrigerants, hydrocarbons, solvents, glycols, brines, heat transfer oils, petroleum fractions and gas mixtures.

Clean re-rating

Duty and outlet temperatures if the exchanger were clean, by effectiveness-NTU — the duty you are losing now.

Cleaning economics

Cost of fouling per year, cleaning payback and the optimum cleaning interval.

History and trend

A 40-row log with a fouling trend chart; ranked findings and a print-ready report.

Built for engineers

  • Visible formulas — nothing hidden, so you can check every step.
  • Fully referenced — methods from the standard references, checked against their published worked examples.
  • Safe to share — sheets are protected against accidental edits, with an open password so you can still customise.
  • Built-in input checks — clear warnings for impossible inputs and values outside typical ranges.

For engineering estimates; verify against site data. Code-based methods are aligned with the publicly documented procedure; they are not a licensed reproduction or a certification.