This is crucial for fan and blower sizing. For packed columns, pressure drop per meter of packing multiplied by total packing height gives the total pressure drop.
Use GOAL SEEK to iterate L/G until target outlet concentration is met.
Always convert to actual gas flow using the ideal gas law before any diameter calculations. Include this conversion as a separate, clearly labeled step in your spreadsheet. scrubber design calculation excel best
Total Packing Height (Z)=NTU×HTUTotal Packing Height open paren cap Z close paren equals NTU cross HTU Finding NTU (Driving Force)
), temperature, pressure, and pollutant concentration. Use the Ideal Gas Law to determine the actual gas density at operating conditions. : This is crucial for fan and blower sizing
A logical sequence is: input worksheet, calculation worksheet, and presentation/output worksheet. This makes it easier for others to understand and audit your work.
Before diving into spreadsheet construction, it is helpful to understand the main types of scrubbers and what makes each one unique. The design approach varies significantly depending on which type you are working with. Always convert to actual gas flow using the
One of the most important safety checks in packed bed design is ensuring the tower operates below the flooding point. Many Excel-based scrubber tools incorporate a "Solver" function to determine the column diameter based on a specified percentage of flood—or conversely, to check the flooding percentage for a specified diameter.
This is where Excel's mathematical capabilities shine. The diameter of a packed scrubber depends heavily on the flooding velocity. The classic method relies on the correlation. The x-axis parameter is calculated as:
D = √[ (4 × 1.516) / (π × 2.0) ] ≈ 0.98 m
HTU considers the packing-specific mass transfer coefficients ( kGk sub cap G kLk sub cap L