Agitator Design Calculation Xls

Agitator design involves calculating process requirements (like power and mixing intensity) and mechanical integrity (like shaft diameter and critical speed). 1. Process Design Calculations

To translate these formulas into a functional Excel or Google Sheets tool, organize the tabs as follows: Tab 1: Input Data Vessel dimensions (Diameter, Liquid height). Fluid properties (Viscosity, Density). Impeller details (Type, Diameter, Quantity). Tab 2: Process Calculations Reynolds number, Power number lookup, Motor power sizing. Tab 3: Mechanical Calculations agitator design calculation xls

Sheet 2: Engine (Hidden Calculations)

  1. Convert Units: Convert rpm to rps ($N = N_rpm/60$) and cP to Pa·s.
  2. Lookups: Use VLOOKUP on the Impeller Type to retrieve the correct Power Number ($N_p$).
  3. Calculate: Compute $N_Re$, Power ($P$), Torque ($\tau$), and Diameter ($d$).
  4. Logic Check: Use an IF statement to flag if $N_Re$ is too low (< 2000) indicating the design correlations may not apply.

Sheet 1: User Inputs

| Cell Ref | Parameter | Value | Unit | | :--- | :--- | :--- | :--- | | B3 | Tank Diameter ($T$) | [User Input] | m | | B4 | Liquid Height ($H$) | [User Input] | m | | B5 | Fluid Density ($\rho$) | [User Input] | kg/m³ | | B6 | Fluid Viscosity ($\mu$) | [User Input] | cP | | B7 | Required Speed ($N_rpm$) | [User Input] | rpm | | B8 | Impeller Diameter ($D$) | [User Input] | m | | B9 | Impeller Type | [Drop Down List] | - | | B10 | Shaft Material Allowable Stress | [User Input] | MPa | Convert Units: Convert rpm to rps ($N =