Related Resources: Fluids Engineering

Centrifugal Pump Requirements Spreadsheet Calculator

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
Spider Optimizer

© Copyright 2000 - 2021, by Engineers Edge, LLC www.engineersedge.com
All rights reserved
Disclaimer | Feedback | Advertising | Contact