Scrubber Design Calculation Excel Hot __full__ 🎁 Secure

This goes far beyond a simple pressure drop sheet. It is structured as a multi-module thermodynamic & hydraulic design tool.

Excel Features to Make Your Sheet "Hot"

1. Goal Seek (Data > What-If Analysis): Use this to automatically adjust column diameter until ΔP = 45 mmH₂O/m (optimal).
2. Dynamic Charts: Plot ΔP vs. % Flooding. Add a vertical line at 70%.
3. Conditional Formatting:
   • Gas velocity > 80% flood → Orange
   • Gas velocity > 100% flood → Red
   • L/G ratio < 1.0 → Red (acid gas breakthrough risk)
4. Drop-down for Packing: Use Data Validation to select from 5 common packing types, auto-populating Fp and K4.

1. Setting Up the Input Sheet

A good design sheet separates inputs from calculations. The first tab should be dedicated to Process Data Input. scrubber design calculation excel hot

Key Input Variables:

• Gas Stream Data:
  • Flow rate (ACFM/SCFM).
  • Inlet Temperature & Pressure.
  • Gas Composition (Molecular Weight, Density, Viscosity).
  • Contaminant Inlet Loading (ppm or lb/hr).
• Liquid Stream Data:
  • Liquid Flow Rate (GPM).
  • Liquid Properties (Density, Viscosity, Specific Gravity).
  • Chemical composition (e.g., % NaOH for acid gas scrubbing).
• Design Targets:
  • Required Removal Efficiency (%).
  • Outlet Emission Limits (ppm).

Step 4: Material Selection Lookup

Embed an XLOOKUP table: | Max Temp (°C) | Material | Corrosion Allowance | | :--- | :--- | :--- | | 70 | PP (Polypropylene) | 3 mm | | 150 | FRP (Vinyl Ester) | 5 mm | | 400 | SS316L | 2 mm | | 900 | Refractory lined CS | 0 mm | This goes far beyond a simple pressure drop sheet

If T_out_gas > 70°C, the Excel sheet should automatically highlight "Material Risk: Upgrade to SS316L." Excel Features to Make Your Sheet "Hot"

3. Pressure Drop (Venturi Scrubber – Best for Hot Gases)

For high-temperature, dirty gases, the Venturi scrubber is king. The classic Calvert Equation for pressure drop (ΔP) is: ΔP = 1.03 * v_g^2 * (L/G) * (ρ_l/ρ_g)^0.5

• Excel Implementation: Create a dynamic lookup that adjusts gas density (ρ_g) for temperature. A common mistake is using density at standard conditions. Use ρ = P*MW / (R*T) in Kelvin.

Tab 3: Mechanical Sizing

• Vessel diameter based on Souders-Brown equation (using gas density at average temperature).
• Height based on Number of Transfer Units (NTU) for mass transfer.
• Critical: Check for flooding velocity using the corrected hot gas density.

Step 3: Liquid-to-Gas Ratio (L/G) Optimization

For hot gases, L/G ratios of 1.0 to 2.5 L/m³ are typical. Create a sensitivity table in Excel (Data > What-If Analysis > Data Table) showing:

• L/G vs. ΔP vs. T_out_gas.
• You will see that increasing water flow initially cools but eventually wastes pumping power.