Home › Shop › Solvent Recovery and Batch Distillation Performance
Excel tool

Solvent Recovery and Batch Distillation Performance

Recovery, purity, duty and batch time for binary solvent recovery by batch distillation — Rayleigh, constant reflux and constant distillate, compared.

Binary solvent recovery by batch distillation, assuming a constant relative volatility: enter the charge amount and composition, the target final still composition, the relative volatility (directly or from two Antoine equations), and — for a rectifying column — the number of theoretical stages and the reflux, and see the distillate and residue amounts and compositions, the recovery, the solvent recovered and lost in kg, the duties, the batch time, and the heating steam and cooling water used.

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
Solvent Recovery and Batch Distillation Performance — sample pages

What it does

Mass balance and recovery

distillate and residue amounts and compositions, recovery of the light component, solvent recovered and lost in kg.

Relative volatility entered directly

Relative volatility entered directly, or computed from two Antoine equations at the system temperature (the pressure unit cancels).

Cut-policy comparison table and

Cut-policy comparison table and three charts: the still and distillate composition against the fraction distilled, recovery and distillate purity against the reflux ratio, and a comparison of the three modes.

Selectors for the operating

Selectors for the operating mode and the volatility basis; rows you do not need disappear; Default/Manual on the secondary inputs; typical-range checks on every input; SI, US, British and industry units switchable on every row.

Built for engineers

  • Visible formulas — nothing hidden, so you can check every step.
  • Fully referenced — methods from the standard references, with the book, edition and page named in the Guide tab.
  • 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].

Solvent Recovery and Batch Distillation Performance 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 againstChecked against an independent Python model (rigorous scipy quadrature and the IAPWS-IF97 steam properties) across all mode and volatility combinations, four unit systems, and a large set of edge and invalid-input cases; the workbook reproduces the model with no formula errors in LibreOffice.
Free versionBrowse the free calculators

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.