Scrubber Design Calculation Excel Best Guide

Program the mathematical equations sequentially down the rows. Use cell naming components to make formulas readable. Excel Formula Logic =(Pres*MW_g)/(8.314*(Temp+273.15)) Converts operating states to actual density. Flow Ratio Factor ( Flvcap F l v ) =(L_mass/G_mass)*SQRT(Rho_g/Rho_l) Establishes the X-axis value for GPDC charts. Bed Area ( ) =Gas_ACFM/Target_Velocity Computes required physical footprint. Bed Height ( ) =LN(C_in/C_out)*HTU_value Calculates necessary structural media depth.

By building a structured spreadsheet with these five sections, you can create a high-performance scrubber design tool that ensures environmental compliance and operational efficiency. To help you get the most accurate results, tell me:

D=4Aπcap D equals the square root of the fraction with numerator 4 cap A and denominator pi end-fraction end-root 3. Calculate Packing Height (NTU/HTU Method) The total height of the packed bed (

This is where Excel's mathematical capabilities shine. The diameter of a packed scrubber depends heavily on the flooding velocity. The classic method relies on the correlation. The x-axis parameter is calculated as:

X=LGρgρlcap X equals the fraction with numerator cap L and denominator cap G end-fraction the square root of the fraction with numerator rho sub g and denominator rho sub l end-fraction end-root Calculate the Flooding Correlation Factor ( scrubber design calculation excel best

NTU=ln[(1−mGL)(y1−mx2y2−mx2)+mGL]1−mGLNTU equals the fraction with numerator l n open bracket open paren 1 minus the fraction with numerator m cap G and denominator cap L end-fraction close paren open paren the fraction with numerator y sub 1 minus m x sub 2 and denominator y sub 2 minus m x sub 2 end-fraction close paren plus the fraction with numerator m cap G and denominator cap L end-fraction close bracket and denominator 1 minus the fraction with numerator m cap G and denominator cap L end-fraction end-fraction Height of a Transfer Unit (HTU)

I can provide more targeted parameters or help structure your specific calculation modules. Environment Agency - Citizen Space Wet Scrubber Application Guide

is the most practical way to handle complex correlations for tower sizing, pressure drop, and efficiency. Key Design Parameters for Excel Calculation

): The critical ratio determining the driving force for mass transfer. Flow Ratio Factor ( Flvcap F l v

The most common source of scrubber design errors is unit mismatch (e.g., mixing Standard Cubic Feet per Minute (SCFM) with Actual Cubic Feet per Minute (ACFM)).

Eckert’s Generalized Pressure Drop Correlation: This is the industry standard formula to implement in Excel to predict pressure drop based on gas/liquid loading. 5. Liquid-to-Gas (L/G) Ratio

Packed towers are the industry standard for high-efficiency gas absorption, such as removing SO₂, NH₃, or H₂S. The design is based on the mass transfer concept of HTU (Height of a Transfer Unit) and NTU (Number of Transfer Units). The key formula is:

| Feature | Why It Matters | |--------|----------------| | for packing types | Prevents manual entry errors | | Unit converters (e.g., scfm to acfm) | Saves time, avoids unit mismatch | | Flooding check with color coding (green = safe, red = flooded) | Instant visual feedback | | Sensitivity analysis with data tables | See how diameter changes with gas flow ±20% | | Graphical output (pressure drop vs. gas rate) | Validates design against classic curves | | Protection for formula cells | Users can’t break core logic | By building a structured spreadsheet with these five

Using Excel's or Solver tools, you can easily define the target percentage of flooding (typically set between 50% to 80%) and let the software calculate the ideal column diameter automatically. 3. Mass Transfer & Packing Height

Should allow users to select from standard packing types (e.g., Raschig rings, saddles) with pre-loaded packing factors ( cap F sub p Removal Efficiency Modeling

Run this sanity check before trusting the output: