Scrubber Design Calculation Excel Best Free

This traditional graphical method can be adapted for Excel using curve-fitted polynomial equations to find the flooding point based on the Liquid-Gas Flow Factor ( Flgcap F l g

): Typically in actual cubic feet per minute (ACFM) or cubic meters per hour ( Needed to calculate actual gas density ( ρgrho sub g Contaminant Specs: Component name, molecular weight ( MWgcap M cap W sub g ), inlet concentration ( Yincap Y sub i n end-sub ), and target outlet concentration ( Youtcap Y sub o u t end-sub Liquid Properties: Liquid flow rate ( ), density ( ρlrho sub l ), viscosity ( μlmu sub l ), and the chemical components of the scrubbing liquid.

Alternatively, use the Height Equivalent to a Theoretical Plate (HETP) for equilibrium-based calculations. C. Pressure Drop and Power Lec 20: Scrubber - Example problem

Once your spreadsheet is verified against a known benchmark or textbook problem, lock all calculation cells ( Review > Protect Sheet ). Leave only the primary input cells editable to prevent accidental formula deletion. scrubber design calculation excel best

This guide outlines the core engineering principles, formulas, and step-by-step structures required to build a professional-grade wet scrubber design calculation sheet in Excel. 1. Key Design Parameters and Input Data

Instead of using cell references like A12 , use Gas_Flow_Rate . This makes formulas readable and reduces errors.

This article provides a comprehensive overview of how to structure the ultimate scrubber design Excel template, essential formulas, and best practices to ensure compliant and efficient operations. 1. Why Use Excel for Scrubber Design? This traditional graphical method can be adapted for

SolverOk SetCell:="$M$10", MaxMinVal:=2, ValueOf:=0, ByChange:="$B$5" SolverSolve UserFinish:=True

[Workbook Structure] ├── Tab 1: Cover & Instructions (Version control, scope) ├── Tab 2: Design Dashboard (User inputs, primary outputs, safety factors) ├── Tab 3: Calculations Engine (Formulas, unit conversions, iterations) └── Tab 4: Engineering Data (Packing factors, chemical properties, steam tables)

In Excel: =IF(Actual_L_flow/Cross_area < MWR, "WARNING: Poor wetting", "OK") Pressure Drop and Power Lec 20: Scrubber -

: Keep cells clean and centralized. Color-code user entry fields (e.g., light blue) versus automated calculation cells (white). VLE_Data Sheet : Store equilibrium constants (

Represents the physical height of packing required to achieve one transfer unit. It depends on the packing type, fluid velocities, and diffusion coefficients. HTU can be calculated using the Onda Correlation, which estimates individual gas-side ( HGcap H sub cap G ) and liquid-side ( HLcap H sub cap L

Flg=(LG)×ρgρlFlg equals open paren the fraction with numerator cap L and denominator cap G end-fraction close paren cross the square root of the fraction with numerator rho sub g and denominator rho sub l end-fraction end-root Create cells for Liquid Flow ( ) and Gas Flow ( ) in mass units (

Molecular weight of the carrier gas (usually air) and the concentration of the target pollutant (e.g., SO2cap S cap O sub 2 HClcap H cap C l NH3cap N cap H sub 3 ) in parts per million (ppm) or Liquid Stream Properties