Why spend time building an Excel tool instead of using a commercial software package? The advantages are compelling:

Hydraulic forces acting on the impellers create bending stresses on the shaft.

This equation reveals a crucial insight: the impeller diameter ($D$) has an enormous influence, being raised to the fifth power. A spreadsheet will automatically perform this complex calculation, often with an additional (e.g., 20% or 80% loading) to account for unforeseen losses or variations in process conditions.

Pm=Pηg⋅ηm⋅SFcap P sub m equals the fraction with numerator cap P and denominator eta sub g center dot eta sub m center dot SF end-fraction ηgeta sub g = Gearbox efficiency (typically ηmeta sub m = Motor efficiency (typically = Safety Factor (standard industrial practice uses 4. Structuring Your Excel Spreadsheet ( .xls )

An agitator behaves like a rotating cantilever beam. The shaft must withstand hydraulic forces without bending or breaking. Shaft Bending and Torque The spreadsheet must calculate the torque ( Tqcap T sub q ) and bending moment ( Mbcap M sub b ) caused by hydraulic forces acting on the impeller blades:

NRe=ρ⋅N⋅D2μcap N sub cap R e end-sub equals the fraction with numerator rho center dot cap N center dot cap D squared and denominator mu end-fraction = Agitator speed (rotations per second, rps) = Impeller diameter (meters, m) Step 2: Determine the Power Number ( Npcap N sub p ) and Calculate Impeller Power ( The Power Number ( Npcap N sub p

This guide breaks down the essential formulas and parameters used to build an spreadsheet, helping you automate the design process accurately. 1. Core Process Parameters for Agitator Design

Once the inputs are provided, the spreadsheet executes the formulas in the background. The key outputs, which the user should verify, include:

): Rotational speed in revolutions per minute (RPM) or revolutions per second (RPS). Power Number ( Npcap N sub p

The mixer shaft experiences combined bending and torsional stresses. The minimum shaft diameter ( ) based on pure shear stress limits is given by:

: Power number (e.g., ~5.0 for a Rushton turbine, ~0.3 for a marine propeller). Motor Sizing

The flow regime is generally interpreted based on the following $Re$ values:

P=Kp⋅μ⋅N2⋅D3cap P equals cap K sub p center dot mu center dot cap N squared center dot cap D cubed (where Kpcap K sub p is the laminar power constant) Step 3: Determine Motor Power ( Pmcap P sub m The calculated power (

), which is a constant based on the specific impeller geometry.

Our use of cookies

We use necessary cookies to make our site work. We'd also like to set optional analytics cookies to help us improve it. We won't set optional cookies unless you enable them. Using this tool will set a cookie on, your device to remember your preferences.

Necessary cookies enable core functionality such as security, network management, and accessibility. You may disable these by changing your browser settings, but this may affect how the website functions.

We'd like to set Google Analytics cookies to help us to improve our website by collecting and reporting information on how you use it. The cookies collect information in a way that does not directly identify anyone.

I accept all cookies
)