Pump Head Calculation Excel [2021] Jun 2026

Add a section to avoid cavitation:

Use → List: "Mild Steel", "Stainless", "HDPE", "PVC". Then use VLOOKUP to fetch roughness values (e.g., 0.15 mm for steel, 0.01 mm for PVC). pump head calculation excel

Start by creating a dedicated "Input" section with distinct cell formatting (e.g., Blue fonts for inputs) so users know where to type. Add a section to avoid cavitation: Use →

| Diam (mm) | Flow (L/s) | Velocity (m/s) | f (Darcy) | hf (m/100m) | |-----------|------------|----------------|-----------|-------------| | Diam (mm) | Flow (L/s) | Velocity

This accounts for the pressure difference between the destination tank and the source tank. If you are pumping into a pressurized vessel, the pump must work harder.

Define these variables in specific cells (e.g., Column B) for easy adjustment. Gallons per minute (GPM) or Pipe Characteristics: Length ( ), inner diameter ( ), and material (to determine roughness).