The fundamental operating parameter that dictates removal efficiency and operational cost.
From vendor data for SO₂–water system, HTU ≈ 0.8 m
Break down long engineering formulas (like the Onda correlation) into intermediate rows to make troubleshooting easier. Tab 3: Reference Data Tables Store empirical engineering data here. scrubber design calculation excel best
+-----------------------------------+ | 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
In practice, many engineers use generalized pressure drop correlations developed by packing manufacturers. +-----------------------------------+ | 1
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
❌ . ✅ Solution: Create a Packing_Data table (Packing type, Void fraction, Packing factor F_p, C1, C2, C3). Reference via INDEX-MATCH . Calculate Column Diameter | --> Flooding correlation (60-80%
Incorporate conditional formatting or IF statements that trigger warnings when inputs fall outside valid ranges. For example:
Cheresources' spreadsheet includes message warnings for conditions such as "scrubber is out of range of the correlation" or "the wetting rate is too low."