are generated via Onda's remaining dimensionless groups (Schmidt and Reynolds numbers), Excel can compute the overall height of a transfer unit:
Gdesign=0.70×Gfloodcap G sub d e s i g n end-sub equals 0.70 cross cap G sub f l o o d end-sub Finally, calculate the total cross-sectional area ( ) and column diameter (
Empirical correlations (like the Leva or Billet and Schultes models) to predict gas-side pressure drop per foot of packing. Essential Excel Features for Engineering Accuracy
While dedicated process simulation software exists, a well-structured Excel spreadsheet remains the best tool for daily engineering checks, rapid iterations, and clear documentation. 1. Core Engineering Parameters for Scrubber Design scrubber design calculation excel best
Notes and cautions:
: Total pressure drop includes losses from dry packing, liquid spraying, and internal supports. A common design target is an initial drop of cap H sub 2 cap O of packing. Best Practices for Excel Design Sheets
Column Diameter (D)=4⋅AcπColumn Diameter open paren cap D close paren equals the square root of the fraction with numerator 4 center dot cap A sub c and denominator pi end-fraction end-root 4. Packing Properties Reference Table Core Engineering Parameters for Scrubber Design Notes and
Spray towers are hollow vessels with arrays of spray nozzles. They are simpler and have lower pressure drops than packed towers, making them suitable for high gas volumes and applications where pressure drop is a primary concern, like dust and particulate removal.
Define your process conditions in a dedicated Excel input block: Inlet gas flow rate ( Qgcap Q sub g Operating temperature ( ∘Rraised to the composed with power R Operating pressure ( Contaminant inlet concentration ( yiny sub i n end-sub ) and required outlet target ( youty sub o u t end-sub Gas Density Evaluation The average molecular weight of the gas mixture ( MWavgMW sub a v g end-sub ) is calculated from its mole fractions (
Excel doesn't have CFD or AI—yet. But for robust, transparent, and immediate scrubber design calculations, it remains the undisputed tool for the working chemical engineer. Packing Properties Reference Table Spray towers are hollow
NTU=ln(y1−m⋅x2y2−m⋅x2⋅(1−S)+S)1−Scap N cap T cap U equals the fraction with numerator l n open paren the fraction with numerator y sub 1 minus m center dot x sub 2 and denominator y sub 2 minus m center dot x sub 2 end-fraction center dot open paren 1 minus cap S close paren plus cap S close paren and denominator 1 minus cap S end-fraction (Where is the slope of the equilibrium line, is the inlet liquid concentration, and is the stripping factor).
HTU represents the mass transfer efficiency of the specific packing material used. It depends on gas and liquid physical properties, flow rates, and packing characteristics ( Cfcap C sub f 4. Total Packing Height The total height of the packing bed ( ) is the product of these two values: H=NTU×HTUcap H equals NTU cross HTU Step-by-Step Excel Sheet Architecture