If absorption is concentrated (CO₂ in MEA, SO₂ in caustic), the NTU equation becomes implicit. Use with Enable Iterative Calculation (max iterations 1000, max change 0.0001).
any spreadsheet that claims to be “one‑click” for all scrubbers – a Venturi, tray tower, and packed bed have fundamentally different hydrodynamics. The best Excel designs are purpose‑built for one scrubber type. scrubber design calculation excel best
Use conditional formatting to highlight cells in red if calculated values exceed safe engineering limits (such as a flooding approach velocity exceeding 80%). If absorption is concentrated (CO₂ in MEA, SO₂
An effective scrubber design spreadsheet must be broken down into distinct, sequential calculation modules. The best Excel designs are purpose‑built for one
Then back-calculate area: A = Gas_flow_rate / G_flood . Diameter = SQRT(4*A/π) .
Automated lookup tables or formulas for gas density, viscosity, and pollutant solubility (Henry's law constants).