Scrubber Design Calculation Excel Best Info

The Ultimate Guide to Packed Bed Scrubber Design Calculations in Excel

The design of a scrubber involves several key calculations:

| Feature | How to Implement in Excel | |---------|---------------------------| | | Use CONVERT function or a hidden unit table with VLOOKUP . | | Solver/Goal Seek for ΔP | Automate L/G adjustment to meet efficiency at min pressure drop. | | Error trapping | =IF(Flood% > 0.8, "WARNING: Near flooding", "OK") | | Graphical output | Dynamic charts: Efficiency vs. d_p, ΔP vs. gas flow. | | Lookup physical properties | Hidden sheet with water/air properties (density, viscosity, diffusivity) from 0–100°C. |

The most common industrial scrubber. Your Excel sheet must follow this logical flow:

L = (Q x C) / (η x ρ)

A=GGdesigncap A equals the fraction with numerator cap G and denominator cap G sub d e s i g n end-sub end-fraction

where L is the scrubbing liquid flow rate (m³/s), C is the concentration of pollutants (kg/m³), η is the scrubber's efficiency, and ρ is the density of the scrubbing liquid (kg/m³).

ln(Yflood)=C0+C1ln(X)+C2(ln(X))2l n open paren cap Y sub f l o o d end-sub close paren equals cap C sub 0 plus cap C sub 1 l n open paren cap X close paren plus cap C sub 2 open paren l n open paren cap X close paren close paren squared (Note: are empirical constants specific to the packing geometry). The capacity parameter equation is defined as:

Industrial air pollution control is a critical challenge, and wet scrubbers are among the most effective technologies for removing particulate matter and gaseous pollutants from exhaust streams. For process and chemical engineers, mastering scrubber design calculations is essential—and doing so efficiently in Microsoft Excel can transform a complex engineering task into a streamlined, repeatable process. scrubber design calculation excel best

) using the operating line equation and Henry's Law constant ( ), which dictates the gas-liquid equilibrium: y=m⋅xy equals m center dot x

NTU=ln(yinyout)×(11−youtyin) (Simplified for dilute systems)cap N cap T cap U equals l n open paren the fraction with numerator y sub i n end-sub and denominator y sub o u t end-sub end-fraction close paren cross open paren the fraction with numerator 1 and denominator 1 minus the fraction with numerator y sub o u t end-sub and denominator y sub i n end-sub end-fraction end-fraction close paren (Simplified for dilute systems)

IF(D_column > 3, "Consider multi-bed or parallel columns", "Diameter OK")

I can provide the exact empirical equations and packing factors for your configuration. Share public link The Ultimate Guide to Packed Bed Scrubber Design

For packed beds, pressure drop can be calculated using the Ergun equation or, more conveniently, by using manufacturer-provided pressure drop curves imported into a lookup table within the spreadsheet.

). High pressure drops cause excessive fan power consumption and risk structural damage to column internals.

To appreciate the utility of an Excel spreadsheet, one must first understand the complex variables involved in scrubber design. The two most common types—Venturi scrubbers (for particulate) and Packed Tower scrubbers (for gases)—require distinct calculation pathways, though both rely on mass balance and pressure drop correlations.

Copy only the calculation logic into your own workbook, then strip out VBA (if any) and replace with dynamic arrays ( FILTER , SORT ) for Excel 365. d_p, ΔP vs