Home › Shop › Distillation Column Performance Evaluation
Excel tool

Distillation Column Performance Evaluation

Is the column really as good as its trays? How far is it from the minimum reflux, and what does each extra bit of reflux cost in reboiler duty?

Binary distillation column performance: material balance, minimum reflux, Fenske and Gilliland stages, McCabe-Thiele stepping, feed stage, overall tray efficiency, reboiler duty per tonne and flooding approach.

USD 49 one-time purchase

  • Excel workbook (.xlsx), no macros, version v1.0
  • Excel 2010 or later, Windows and Mac
  • Instant download after payment; updates to this major version included
  • Single-user licence; team and site options
  • Refund if it does not work as described or has an error we cannot fix: contact support within 14 days of purchase — full refund policy
Distillation Column Performance Evaluation — sample pages

What it does

Material balance

Product flows from the compositions and closure of the total and light-key balance against the measured flows.

Volatility and feed condition

Relative volatility entered or from Antoine constants, and feed q from a value, the vapour fraction or the feed temperature.

Minimum reflux and stages

Rmin by the pinch construction and Underwood, Nmin by Fenske, and stages at your reflux by Gilliland and McCabe-Thiele stepping.

Feed stage and tray efficiency

Feed stage by stepping and by Kirkbride against your actual feed tray, with the overall tray efficiency and R/Rmin.

Duty per tonne

Condenser and reboiler duty against the measured values, reboiler duty per tonne and the duty spent above the minimum.

Flooding and reflux what-if

Flooding approach on the top or bottom section, and stages and duty at four multiples of the minimum reflux.

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.

Preview the workbook

An illustration of the sheet layout of this workbook, not a screenshot of calculated results. Select the image to enlarge it. For questions before you buy, email [email protected].

Distillation Column Performance Evaluation Excel workbook sample pages
Layout illustration (not a results screenshot).

Specification and checks

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 againstAn independent Python model in 188 recalculated runs: all 72 selector combinations, SI, US, British and industry units on molar and mass flow bases, result-unit switching and 104 edge and invalid-input cases; about 10,100 values compared, 0 formula errors in LibreOffice.
Free versionTry the free vapour pressure calculator

Compatibility, licence and support

FileExcel workbook (.xlsx), no macros, version v1.0; works in Excel 2010 or later on Windows and Mac. Sheets are protected against accidental edits, with an open password so you can customise.
LicenceSingle user. A team licence (up to 5 named users) is 3 × the shop price; site licences on request — licence terms.
UpdatesUpdates to this major version are included; download them again from the link in your receipt.
SupportEmail [email protected] with your order number — questions on the method, your inputs or your results are welcome.
RefundsIf the tool does not work as described, or has an error we cannot fix, email [email protected] with your order number within 14 days of purchase and we will refund you in full. Refunds are not offered for a change of mind once a file has been downloaded. Read the full refund policy.