Scrubber Design Calculation Excel Best full -

Here’s a professional write-up you can use for a blog, technical document, or LinkedIn post.

Part 3: Building the "Best" Excel Workbook – Step by Step

Follow this architecture for a professional-grade sheet.

5. Liquid Distribution and Wetting Rate

A hidden killer. Even with 100 stages, if liquid doesn’t wet the packing, mass transfer fails.

Calculate minimum wetting rate (m³/m²·h): scrubber design calculation excel best

MWR = 0.08 * (Specific area of packing, a_p) -- in m³/m²·h

In Excel: =IF(Actual_L_flow/Cross_area < MWR, "WARNING: Poor wetting", "OK")

Tab 2: `Packing_Database`

Create a table with: | Packing Type | Material | Size (in) | Fp (ft²/ft³) | a (m²/m³) | ε (void fraction) | |--------------|----------|-----------|--------------|-----------|-------------------| | 1" Pall ring | PP | 1 | 56 | 207 | 0.92 | | 2" Intalox | Ceramic | 2 | 40 | 102 | 0.74 |

Use INDEX-MATCH to pull data into calculations. Here’s a professional write-up you can use for

Practical Example: HCl Removal with 2" Pall Rings

A well-designed Excel sheet would let you input:

Gas flow = 10,000 cfm, HCl inlet = 500 ppm, outlet = 50 ppm
Packing = 2" polypropylene Pall rings

In seconds, Excel returns:

Column diameter = 4.2 ft
Packed height = 8 ft
Pressure drop = 0.65 in H₂O/ft packing
Pump power ≈ 5.2 HP

Part 5: Case Study – HCl Scrubber in Excel

Problem: Design a scrubber to remove 99% of HCl from 10,000 m³/hr of air at 30°C, using water. Packing: 2" ceramic Intalox. Part 3: Building the "Best" Excel Workbook –

Excel steps:

Enter gas flow = 10,000 m³/hr, density = 1.16 kg/m³.
L/G ratio = start at 2 L/m³ (typical for HCl).
From packing DB: Fp = 40, a = 102 m²/m³.
Flooding calc yields G_flood = 2.8 kg/m²·s → Area = 0.99 m² → Diameter = 1.12 m.
Use 1.2 m ID for safety (70% of flood).
NTU = LN(0.02/0.0002) = 4.6 (assuming exit 20 ppm).
HTU from Onda correlation (embedded in Excel) = 0.45 m.
Packing height = 0.45 * 4.6 = 2.07 m. Add 30% safety: 2.7 m.
Pressure drop = 15 mmH2O/m → total = 40.5 mmH2O.
Results: Column = 1.2 m dia × 3.5 m shell (plus sump).

The entire design took 20 minutes in the Excel sheet.

Scrubber Design Calculation Excel Best __full__ -