Excel Hot | Scrubber Design Calculation

Scrubber Design Calculation using Excel

$$ D = \sqrt\frac4 \times Q\pi \times v $$ scrubber design calculation excel hot

Step A: Flow Parameter (X-axis) $$F_p = X = \fracLG \times \sqrt\fracρ_gρ_l$$ Excel: =(L_G_ratio)*(SQRT(gas_density/1000)) (assuming liquid density ~1000 kg/m³) Scrubber Design Calculation using Excel $$ D =

• Use the scrubber diameter and gas flow rate to calculate the scrubber height (m or ft).
• Use a formula such as: H = (6 * Q_g) / (π * D^2 * V_g) where H is the scrubber height, Q_g is the gas flow rate, D is the scrubber diameter, and V_g is the gas velocity.

Looking for a pre-built template? Check out engineering resources like the Microsoft Support Guide for help with complex cell logic or Torch-Air's Engineering Blog for the full physics breakdown. Use the scrubber diameter and gas flow rate

Building the Ultimate "Scrubber Design Excel Hot" Template

You can download generic calculators, but here is how to build the professional-grade version that stands out.

• Excel Hot Tip: Hardcode Antoine constants for water (A=8.07131, B=1730.63, C=233.426 for mmHg) to calculate absolute humidity at outlet saturation.

Tab 2: Calculation Engine

• Contains the raw formulas linked to the Input tab.
• Solver Add-in Integration: A macro button to run Excel Solver. This optimizes the Throat Diameter to meet a user-defined "Target Pressure Drop" (e.g., design for exactly 15 in. w.c. pressure drop).

We can now create an Excel spreadsheet to perform these calculations.