Gas absorber and scrubber performance: removal, minimum L/G, Kremser stages, transfer units, packed height or trays, flooding approach and pressure drop per metre, with a what-if on the liquid rate.
USD 49 one-time purchase

What it does
Equilibrium
A straight-line slope or a Henry constant, with an optional temperature correction you enter.
Material balance
Removal efficiency, solute in the leaving liquid, minimum L/G, actual-to-minimum ratio and absorption factor.
Stages, NTU and height
Theoretical stages by the Kremser equation, transfer units and HTU, required packed height and HETP, or actual trays from an overall efficiency.
Rating check
Enter the installed packed height or tray count and get the predicted outlet, removal and margin over the required size.
Hydraulics
Flooding velocity and approach to flooding, pressure drop per metre and over the column, and liquid loading.
Liquid-rate what-if
Stages, height and flooding approach at four liquid rates, with ranked findings, three charts 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.
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 187 recalculated runs: all 64 selector combinations, SI, US, British and industry units on packed, Henry-constant and trayed cases, result-unit switching and 106 edge and invalid-input cases; about 13,000 values compared, 0 formula errors in LibreOffice. |
| Free tools | 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. |