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

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].
Specification and checks
| Format | Excel workbook (.xlsx), no macros |
| Version | v1.0 |
| Works in | Excel 2010 or later, Windows and Mac |
| Units | SI, US and British, mixed freely |
| Includes | Guide tab with method and references, calculator, print-ready report |
| Checked against | An 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 version | Try the free vapour pressure calculator |
Compatibility, licence and support
| File | Excel 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. |
| Licence | Single user. A team licence (up to 5 named users) is 3 × the shop price; site licences on request — licence terms. |
| Updates | Updates to this major version are included; download them again from the link in your receipt. |
| Support | Email [email protected] with your order number — questions on the method, your inputs or your results are welcome. |
| Refunds | If 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. |