Scrubber Design Calculation Excel Best May 2026

In the world of chemical, petrochemical, and environmental engineering, the packed bed scrubber (or wet scrubber) is a silent guardian. Its job is simple in concept—remove contaminants from a gas stream using liquid—but complex in execution. A poorly designed scrubber leads to flooding, high pressure drops, liquid carryover, or inefficient mass transfer.

Function ConvertUnits(Value, FromUnit, ToUnit) ' Case logic for "m3/hr to CFM", etc. End Function Instead of manual trial for diameter, use VBA to call Solver: scrubber design calculation excel best

Why? Because Excel offers transparency, rapid iteration, and customizability that black-box software cannot match. When built correctly, an Excel-based scrubber design tool can be 95% as accurate as expensive simulators at 0% of the cost. In the world of chemical, petrochemical, and environmental

Introduction: The Art of Gas Cleaning

ΔP (in H2O/ft packing) = C * (G² / ρg) * (10^(L*D)) Where C and D are packing constants. Or use the generalized method: ΔP = 0.115 * (G^1.85) * (Fp^0.85) for dry packing, plus liquid correction. When built correctly, an Excel-based scrubber design tool

=EXP( -2.5 * LN(X) - 1.2 ) [Approximate; use published tables for accuracy] Then back-calculate area: A = Gas_flow_rate / G_flood . Diameter = SQRT(4*A/π) . Using the Leva correlation (simplest for Excel):

For decades, engineers have relied on rigorous software like Aspen Plus or ChemCAD. However, for quick iterations, feasibility studies, and site-based troubleshooting,