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.
• This excel spreadsheet may contain macros which will need to be enabled in your excel application, see web page: Enable macros in Downloaded excel files
• Units utilized within calculators are either SI or Imperial (some enable both SI and Imperial) and member (you) are responsible for conversions. Ensure that you verify units utilized in excel application meet your requirements before downloading.

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