) and their Henry’s Law constants to dynamically calculate the equilibrium curve and the required liquid flow rate based on your inputs. Step 3: Calculate Column Diameter and Cross-Sectional Area
The most common industrial scrubber. Your Excel sheet must follow this logical flow:
Store physical properties in secondary tabs. Use Excel lookup functions to pull data dynamically based on user selections. Tables containing packing factors ( Fpcap F sub p scrubber design calculation excel best
The fundamental operating parameter that dictates removal efficiency and operational cost.
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. ) and their Henry’s Law constants to dynamically
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
Every scrubber calculation sequence begins with raw process data. You must gather and verify these input values before starting your spreadsheet equations. Gas Stream Properties Volumetric Flow Rate ( Qgcap Q sub g Use Excel lookup functions to pull data dynamically
While I cannot provide a direct file, the best public domain Excel scrubber calculator is the (updated 2021). Search for: "EPA OAQPS Control Cost Manual" + Excel scrubber
A professional scrubber design sheet follows a sequential calculation pathway. Below are the steps, equations, and logic to program into your Excel cells. Step 1: Calculate Gas Density Calculate the actual gas density ( ρgrho sub g ) based on operating temperature and pressure:
A=QgVdesigncap A equals the fraction with numerator cap Q sub g and denominator cap V sub d e s i g n end-sub end-fraction
: Marco Meloni's Excel Sheet provides a robust tool for calculating removal efficiency and pressure losses in single-stage towers.