Home › Shop › CO2 Absorption and Stripping System
Excel tool

CO2 Absorption and Stripping System

Hot potassium carbonate CO2 removal: carrying capacity, circulation, regeneration heat, split-flow balance, packed-height check, slip sensitivity and water balance.

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

  • 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
CO2 Absorption and Stripping System — sample pages

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].

CO2 Absorption and Stripping System 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 (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 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.