Related Resources: Fluids Engineering

### Centrifugal Pump Requirements Spreadsheet Calculator

How the Worksheet Works

Calculates:

• Friction head loss on suction
• Friction head loss on discharge
• 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