Related Resources: Fluids Engineering
Centrifugal Pump Requirements Spreadsheet Calculator
NOTE: Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.
Engineering Excel Spreadsheet Downloads
Fluid Flow Design and Engineering
Hydraulic and Pneumatic Design and Engineering
Centrifugal Pump Requirements Spreadsheet Calculator
Requires a Premium Membership to download
Preview: Centrifugal Pump Requirements Spreadsheet Calculator
Download: Centrifugal Pump Requirements Spreadsheet Calculator
How the Worksheet Works
Calculates:
- Friction head loss on suction
- Friction head loss on discharge
- Dynamic head
- NPSH
- System power
- Calculates and creates Pump vs Head Curve
- Considers fittings and valves for both suction and discharge of pump
- Allows for three separate application calculations
Reynolds No. =
|
Fluid Velocity x Fluid Density x Actual Diameter | |
Fluid Viscosity
|
If Re > 2100 (Formula taken from Std T2.3 Std 5, Approximate Moody Formula) |
Friction Factor = |
0.0055 x [ 1 + ( 20,000 x Pipe Roughness + 1000000 )]^0.33
|
|
[ ( Pipe Diameter Reynolds No. )]
|
or
If Re < 2100 |
Friction Factor = |
64
|
|
Reynolds No.
|
Pressure Drop = |
5100 x Friction Factor x Velocity^2
|
|
Diameter
|
Type of Pipe
|
Pipe Roughness (mm)
|
Drawn Tubing
(Copper, Glass, Stainless Steel, etc.) |
0.0015
|
Commercial Steel Pipe
|
0.046
|
Asphalt Dipped Cast Iron Pipe
|
0.122
|
Galvanized Iron Pipe
|
0.152
|
Bare Cast Iron Pipe
|
0.26
|
Concrete Pipe
|
0.3 - 3.0
|
Riveted Steel Pipe
|
0.9 - 9.0
|