Before opening Excel, you must define the fundamental physical and chemical inputs of your system. A robust design calculation focuses on three critical engineering goals: matching the gas-liquid equilibrium, calculating the column diameter to prevent flooding, and determining the packing height required for the target removal efficiency. Gas Stream Properties Volumetric Flow Rate ( Qgcap Q sub g
Calculate vessel diameter based on gas velocity and flow rate. For packed columns, check that you are operating below the flooding point. For example, many designs operate at about 70% of flooding gas velocity.
Built-in design validation to prevent high fan power consumption. Best Practices for Spreadsheet Verification scrubber design calculation excel best
[Tab 1: Dashboard] ---> [Tab 2: Calculations] ---> [Tab 3: Engineering References] ---> [Tab 4: Documentation] (Inputs & Outputs) (Formulas & Physics) (Packing Factors & Constants) (Revision History) Tab 1: Input & Output Dashboard
Include a graph comparing Operating Velocity vs. Flooding Velocity to ensure the design stays in the optimal operating range. 5. Conclusion: What Makes an Excel Sheet the "Best"? Before opening Excel, you must define the fundamental
An overlooked constraint in basic calculators is the operating pressure drop (
where η is efficiency (as a fraction), k is a correlation coefficient (typically 0.1–0.2), R is the liquid-to-gas ratio, and ψ is the inertial impaction parameter. For packed columns, check that you are operating
Computes the exact physical diameter of the scrubber shell based on allowable velocity. =LN(Inlet_PPM / Outlet_PPM) Use code with caution.
The height of the packed bed determines how much contact time the gas has with the liquid. It relies on the concept of transfer units.