[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)
Template Structure (recommended workbook tabs)
Gas Outlet (y2) Liquid Inlet (x2) │ │ ▼ ▼ ┌──────────────────────────────┐ │ │ │ Packed Bed Zone │ Z = │ │ ◄── Height (Z) = HTU × NTU │ (Gas/Liquid Mass Transfer) │ │ │ └──────────────────────────────┘ │ │ ▼ ▼ Gas Inlet (y1) Liquid Outlet (x1)
Where Q_g is the actual gas flow rate (m³/s) and v is the superficial velocity (m/s). Typical velocities range from 1.5–3 m/s for wet scrubbers. scrubber design calculation excel best
Instead of guessing the L/G ratio, use Excel’s or Solver .
): An empirical factor used in pressure drop and flooding calculations. 2. Step-by-Step Calculation Methodology
). Excessively high pressure drops increase the electrical load on the system's induced draft fan. [Workbook Structure] ├── Tab 1: Cover & Instructions
: This widely used template is ideal for chemical absorption. It includes input fields for gas/liquid properties, packing types (like Intalox Saddles), and calculates column diameter, pressure drop, and motor power requirements. Available on platforms like Course Hero EPA Wet and Dry Scrubbers Cost Calculation Spreadsheet : Provided by the
A professional-grade scrubber design spreadsheet should be divided into logical sections to ensure accuracy and ease of use:
To build a robust scrubber design spreadsheet, you must include inputs for both gas and liquid phases: Gas Stream Properties ): An empirical factor used in pressure drop
An automated safety warning using IF statements (e.g., =IF(Flood_Fraction>0.8, "WARNING: FLOODING RISK", "DESIGN SAFE") ). Essential Excel Formulas for Your Spreadsheet =SQRT((4 * Gas_Flow_Rate) / (PI() * Target_Velocity)) Use code with caution.
) and surface areas for rings, saddles, and structured grids.