Using Excel's or Solver tools, you can easily define the target percentage of flooding (typically set between 50% to 80%) and let the software calculate the ideal column diameter automatically. 3. Mass Transfer & Packing Height
For advanced applications, use Excel's Solver tool to optimize design parameters. For example, you can set Solver to minimize total cost (capital + operating) by varying scrubber diameter and packing height, subject to constraints on removal efficiency and pressure drop. Spreadsheets in chemical engineering education have demonstrated the use of Solver for optimizing absorption tower design. scrubber design calculation excel best