Calculation Excel Best: Scrubber Design

Y=(Gflood)2Fpμl0.1ρg(ρl−ρg)gccap Y equals the fraction with numerator open paren cap G sub f l o o d end-sub close paren squared cap F sub p mu sub l to the 0.1 power and denominator rho sub g open paren rho sub l minus rho sub g close paren g sub c end-fraction Gfloodcap G sub f l o o d end-sub = Gas mass velocity at flood ( Fpcap F sub p = Packing factor ( m-1m to the negative 1 power μlmu sub l = Liquid viscosity ( = Gravitational constant ( Step 3: Calculate Diameter and Cross-Sectional Area Excel should isolate Gfloodcap G sub f l o o d end-sub

) transfer units to find the overall height of a transfer unit ( HOGcap H sub cap O cap G end-sub Step 5: Pressure Drop Verification Calculate the pressure drop per foot of packing (

Excel Best Practices

If you want an accessible "paper" (PDF guide) paired with a functional Excel tool, this is a community favorite. scrubber design calculation excel best

Include a packing factor table indexed by packing type and size.

Gflood=Yflood⋅ρg(ρl−ρg)gcFpμl0.1cap G sub f l o o d end-sub equals the square root of the fraction with numerator cap Y sub f l o o d end-sub center dot rho sub g open paren rho sub l minus rho sub g close paren g sub c and denominator cap F sub p mu sub l to the 0.1 power end-fraction end-root

An industrial must balance chemical kinetics, thermodynamics, and fluid dynamics to accurately size packed bed columns. To build the best professional-grade calculator, engineers must move beyond basic sizing formulas and integrate rigorous, iterative calculations for pressure drop, flooding velocities, and mass transfer coefficients. Y=(Gflood)2Fpμl0

Follow this architecture for a professional-grade sheet.

Construct a clean, single-page summary suitable for printing or exporting to PDF. Use conditional formatting to trigger visual alerts when safety thresholds are breached:

Introduction Briefly explain the purpose of scrubber design calculations and why Excel is a useful tool for preliminary sizing, mass/energy balances, and cost estimation. Use conditional formatting to trigger visual alerts when

) is calculated using the Number of Transfer Units (NTU) and the Height of a Transfer Unit (HTU) method: Z=HTU×NTUcap Z equals HTU cross NTU

) is determined using equilibrium data for the specific gas-liquid system. In practice, designers operate at times the minimum L/G ratio.

+-----------------------------------+ | 1. Establish Design Basis | --> Flow rates, compositions, temperatures +-----------------------------------+ | v +-----------------------------------+ | 2. Perform Mass & Energy Balance | --> Determine solvent rate (L/G ratio) +-----------------------------------+ | v +-----------------------------------+ | 3. Calculate Column Diameter | --> Flooding correlation (60-80% capacity) +-----------------------------------+ | v +-----------------------------------+ | 4. Determine Packing Height | --> Calculate NTU and HTU (Height = HTU x NTU) +-----------------------------------+ | v +-----------------------------------+ | 5. Evaluate Packing Pressure Drop | --> Verify hydraulic stability (< 0.5 in. H2O/ft) +-----------------------------------+ Step 1: Establish the Design Basis

Step 2: Determine the Generalized Pressure Drop Correlation (GPDC) Y-Value The Generalized Pressure Drop Correlation curve plots against a capacity parameter ( ). At the flooding point, Yfloodcap Y sub f l o o d end-sub can be calculated via the Generalized Leva-Lobo equation:

, this tool is the gold standard for estimating capital and annual operating costs based on waste gas composition and pollutant properties. Spray Tower Rating Spreadsheet : Developed by experts like Meloni Marco