Include strict data validation (e.g., Data > Data Validation ) to ensure flow rates or temperatures are positive numbers. Section 2: Hydraulics & Sizing (Automated)
Do you prefer your model to run completely in or Imperial units?
In every formula, add IFERROR . For example:
Customization: You can easily add "What-If" scenarios to see how the design reacts to a 20% increase in gas flow. scrubber design calculation excel best
[Tab 1: Dashboard] ---> [Tab 2: Calculations] ---> [Tab 3: Engineering References] ---> [Tab 4: Documentation] (Inputs & Outputs) (Formulas & Physics) (Packing Factors & Constants) (Revision History) Tab 1: Input & Output Dashboard
A spreadsheet is only as good as its validation. Always verify your Excel outputs against known empirical benchmarks or pilot plant data before finalizing a fabrication design.
✅ No macros? No problem – our sheet uses only standard Excel formulas (compatible with Excel 2016+ and Google Sheets). Include strict data validation (e
Dedicate this area to raw process variables. Never hardcode numbers inside formulas; reference these input cells instead. Gas molecular weight Inlet/outlet concentrations Selected packing factor ( Fpcap F sub p Zone 2: Lookup Tables (Gray Reference Sheets)
D=4⋅Aπcap D equals the square root of the fraction with numerator 4 center dot cap A and denominator pi end-fraction end-root Step C: Tower Height (Number of Transfer Units Method) For dilute systems, the height of the packed bed (
): Apply your safety/derating factor (e.g., 60% of flooding) to find the design velocity ( For example: Customization: You can easily add "What-If"
For a comprehensive scrubber design, Excel is the industry standard for preliminary calculations, though specialized software like Aspen Plus is used for complex fluid dynamics.
This traditional graphical method can be adapted for Excel using curve-fitted polynomial equations to find the flooding point based on the Liquid-Gas Flow Factor ( Flgcap F l g
To verify the logic of your Excel calculation formulas, assume a process stream where the calculated and the system requires an . The total packed bed height ( ) is verified by multiplying these two variables directly: