A stage calculation for liquid-liquid (solvent) extraction on the immiscible-solvent basis: enter the feed and solvent flows, the solute contents and your distribution coefficient, and see the extraction factor, the theoretical and actual stages for a target recovery or the recovery of the stages you have, the raffinate and extract compositions, the minimum solvent ratio, the column height and the solvent you lose.
USD 49 one-time purchase

What it does
Extraction factor E =
Extraction factor E = K'·S'/F' in weight-ratio coordinates, with solute-free flows worked out from your mass-percent inputs, and with solute already in the recycled solvent allowed for.
Theoretical stages, actual stages
Theoretical stages, actual stages from your overall stage efficiency (rounded up, with the recovery the rounded stages give), number of transfer units, and contacting height from your HETS.
Raffinate and extract weight
Raffinate and extract weight ratios, mass percents and stream flows, solute extracted and solute left.
Minimum solvent-to-feed ratio for
Minimum solvent-to-feed ratio for the recovery and how far above it you are.
Solvent loss with the
Solvent loss with the raffinate from your solubility and entrainment figures, per hour and per year.
Capacity check of a column
combined superficial velocity against a flooding velocity that you enter, percent of flooding against your design limit, and the diameter that runs at the limit.
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].
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 | Checked against an independent Python model (simultaneous root solution, not the sheet's passes) and against a published handbook worked example of the countercurrent shortcut method; every selector combination, SI, US, British and industry units, result-unit switching and edge and invalid-input cases recalculated with 0 formula errors in LibreOffice. |
| Free version | Browse the free calculators |
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. |