Scrubber Design Calculation Excel Best May 2026

Use Data Validation to select:

The diameter is dictated by the gas velocity. If the velocity is too high, the scrubber will flood; too low, and it becomes inefficient and expensive.

Use the Sherwood–Eckert generalized pressure drop correlation. scrubber design calculation excel best

In the field of chemical and environmental engineering, the design of wet scrubbers is a critical task. While specialized simulation software exists, Microsoft Excel remains the industry standard for preliminary sizing, vendor verification, and detailed process calculations. Its transparency and flexibility make it the "best" platform for understanding the underlying physics of scrubber operation.

This text outlines the essential steps to create a robust, best-practice scrubber design calculator in Excel, focusing on Packed Bed Scrubbers (the most common type for gas absorption). Use Data Validation to select: The diameter is

A best-in-class Excel sheet forces discipline here. Never hardcode values inside formulas.

| Parameter | Units | Typical Range | Why Critical | |-----------|-------|---------------|---------------| | Gas flow rate (Q_g) | ACFM or m³/h | 500–100,000 | Sizes vessel diameter | | Inlet dust/gas temp | °F or °C | 60–1000°F | Affects gas density, viscosity | | Pressure drop (ΔP) | inWC or Pa | 4–100+ | Drives energy & fan cost | | Liquid-to-gas ratio (L/G) | gal/1000ft³ or L/m³ | 2–20 | Key for mass transfer | | Particulate size (d_p) | microns | 0.5–200 | Determines collection efficiency | A best-in-class Excel sheet forces discipline here

Best Practice: Use Excel’s Data Validation (List or Decimal) + Named Ranges (e.g., Q_gas) so formulas read =Q_gas * rho_gas.

A basic sheet works. A best sheet includes these Excel power features.

For random packing (Leva’s method):
ΔP (inWC/ft packing) = C1 * (L/G)^C2 * (Gas mass velocity)^C3
Store constants (C1, C2, C3) in a lookup table for different packing types (2" Pall rings, 1" Intalox, etc.).