This is the data entry point. The spreadsheet must capture:
To verify the spreadsheet logic, assume the following inputs:
Calculations:
Conclusion: The spreadsheet formulas should replicate these values exactly.
The following data must be entered into the spreadsheet interface (typically Sheet 1: 'Inputs'). agitator design calculation xls
Sheet 2: "Np Lookup Table"
Sheets 3: "Standard Motors"
Conditional formatting
Formula for solid circular shaft (torsion only):
[
d = \left( \frac16 \times T\pi \times \tau_allow \right)^1/3
]
Torque ( T = P / (2 \pi N) ) (N in rev/sec)
Shear stress ( \tau_allow ) ≈ 40–55 MPa for SS316. This is the data entry point
| Calculation | Result | |-------------|--------| | T = 2892 / (2 × 3.1416 × 2.5) | 184 Nm | | d (with τ=50 MPa) | ~26.5 mm → use 30 mm |
[
t_blend = 5.2 \times \left( \fracTD \right)^2 \times \frac1N
]
Example: ( t_blend = 5.2 \times (2.0/0.67)^2 \times (1/2.5) \approx 18.5 , \textseconds
) Calculations: