Performance monitoring of a hot potassium carbonate type CO2 removal unit for synthesis gas, from routine plant data (generic chemistry — no process brand is assumed). Enter the feed gas flow and CO2, the treated gas slip, the absorber and regenerator conditions, the solution strength and the lean, semi-lean and rich conversions to bicarbonate, the reboiler steam or duty, and — for the height check — the packed heights, your HTU and your equilibrium CO2 back-pressures.
USD 49 one-time purchase

What it does
CO2 removal
moles and mass removed, removal percent, partial pressures and the margin to your treated-gas specification.
Carrying capacity
the volume of CO2 each cubic metre of solution takes up, from the change in conversion to bicarbonate (K2CO3 + CO2 + H2O = 2 KHCO3), for the lean and the semi-lean streams and on average.
Circulation
the rich conversion from the gas-side balance against your limit, the circulation needed at that limit, and the margin — with a laboratory cross-check.
Split flow
single stage or split flow (cooled lean plus semi-lean); the balance between the two streams, the share of removal in each section and the mixed-stream conversion.
CO2 slip sensitivity
the slip the top bed would give at its installed height as the lean-end equilibrium back-pressure is varied 0.5 to 2 times and the HTU 25 % higher — solved by explicit steps, no circular references, no Solver.
Water balance
water carried in by the feed gas and out by the treated gas and the CO2 product, the net surplus or deficit, and the daily change of the solution.
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 (IAPWS-IF97 properties, the slip solved with a root finder, no shared formula code) in 218 recalculated runs: the default case, all 8 selector combinations, SI/US/British/industry units on three cases, result-unit switching, 45 valid edge cases and 149 invalid-input cases; about 5,600 values compared, 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. |