┌─────────────────────────┐ │ Inlet Gas Parameters │ │ (Qg, T, P, yin, yout) │ └────────────┬────────────┘ │ ▼ ┌─────────────────────────┐ │ Calculate Gas Density │ │ & Mass Flows │ └────────────┬────────────┘ │ ▼ ┌─────────────────────────┐ │ Determine Equilibrium │ │ & Operating Line │ └────────────┬────────────┘ │ ▼ ┌─────────────────────────┐ │ Calculate Tower Diameter│ │ (Generalized Pressure │ │ Drop Correlation) │ └────────────┬────────────┘ │ ▼ ┌─────────────────────────┐ │ Calculate NTU & HTU │ │ to find Total Height │ └─────────────────────────┘ Driving Force and Absorption Factor For dilute systems obeying Henry's Law (
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
Highlight input fields clearly with a distinct background fill (e.g., light blue or yellow).
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. scrubber design calculation excel best
Provides clear outputs for diameter, height, and pressure drop.
awap=1−exp[-1.45(σcσl)0.75(L′apμl)0.1((L′)2apρl2g)-0.05((L′)2ρlσlap)0.2]the fraction with numerator a sub w and denominator a sub p end-fraction equals 1 minus exp open bracket negative 1.45 open paren the fraction with numerator sigma sub c and denominator sigma sub l end-fraction close paren to the 0.75 power open paren the fraction with numerator cap L prime and denominator a sub p mu sub l end-fraction close paren to the 0.1 power open paren the fraction with numerator open paren cap L prime close paren squared a sub p and denominator rho sub l squared g end-fraction close paren to the negative 0.05 power open paren the fraction with numerator open paren cap L prime close paren squared and denominator rho sub l sigma sub l a sub p end-fraction close paren to the 0.2 power close bracket = Total specific surface area of packing σcsigma sub c = Critical surface tension of packing material σlsigma sub l = Surface tension of liquid L′cap L prime = Liquid mass velocity (
: Highly rated for its user-friendliness, this tool provides a preliminary calculation of single-stage spray towers Furthermore, engineers must calculate the pressure drop to
Embed a hidden sheet with all conversions (scfm to acfm, °F to °R, psi to psf). Use =CONVERT(value, "from_unit", "to_unit") if you have Excel’s Analysis ToolPak.
), temperature, pressure, pollutant concentration, and molecular weight. Liquid-to-gas ( ) ratio, solvent density, and viscosity.
This determines your blower size and operational cost. High pressure drops generally mean better cleaning but higher electricity bills. Sly Air Pollution Control 2. Best Practices for Your Excel Layout awap=1−exp[-1
Determine the tower's cross-sectional area based on a target (e.g., 500 feet per minute for some plate towers) or by staying within a safe percentage of the flooding velocity (typically 50%–85%). Determining Scrubber Height :
Calculate tower cross-sectional area and round up to standard commercial tower diameters using the CEILING function. Section 3: Utility Requirements