A=LmM⋅Gmcap A equals the fraction with numerator cap L sub m and denominator cap M center dot cap G sub m end-fraction Lmcap L sub m Gmcap G sub m are the liquid and gas molar flow rates. Calculating NTU
NTU=ln[yin−m⋅xoutyout−m⋅xin]NTU equals l n open bracket the fraction with numerator y sub i n end-sub minus m center dot x sub o u t end-sub and denominator y sub o u t end-sub minus m center dot x sub i n end-sub end-fraction close bracket is gas mole fraction, is liquid mole fraction, and is the slope of the equilibrium line. . For 99% removal efficiency, Finding HTU (Mass Transfer Coefficient)
Incorporate logical verification parameters using conditional formatting to flag unsafe operational ranges.
A best-in-class Excel sheet forces discipline here. Never hardcode values inside formulas. scrubber design calculation excel best
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.).
Base resistance of the structural media.
The total packing height (Z) is the product of these two:Z = HTU × NTU Key Features of a "Best-in-Class" Excel Sheet A=LmM⋅Gmcap A equals the fraction with numerator cap
Design Velocity (Ud)=fflood⋅UfDesign Velocity open paren cap U sub d close paren equals f sub f l o o d end-sub center dot cap U sub f
A robust Excel calculator must account for the (flow rate, temperature, density, viscosity) and the liquid stream properties (flow rate, solvent concentration, density). The heart of the calculation lies in determining the Liquid-to-Gas ratio (L/G) , a critical parameter that dictates the efficiency of mass transfer. Furthermore, engineers must calculate the pressure drop to ensure the fan selected for the system has sufficient power to overcome the resistance of the scrubbing media. In packed towers, calculating the flooding point —the velocity at which the gas prevents the liquid from flowing down—is essential to avoid operational failure.
): Usually entered in actual cubic feet per minute (ACFM) or cubic meters per hour ( ), then converted to mass flow rate ( For 99% removal efficiency, Finding HTU (Mass Transfer
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.
Template Structure (recommended workbook tabs)
: Pressure drop calculations per foot of packing using the Reed correlation. Sheet 4: Mechanical & Mist Eliminator Sizing Chevron or mesh pad mist eliminator velocity parameters. Liquid distributor hole spacing and nozzle pressure drops. 6. Verification and Sanity Checks
Whether you are dealing with a (like an acid-base neutralization) or a pure physical absorption system
The design of a scrubber involves several key steps: