Section,Parameter,Value,Unit Input,Flow rate (Q),100,m³/h Input,Suction level,2,m Input,Discharge level,25,m Input,Suction pressure,1,bar(g) Input,Discharge pressure,2,bar(g) Pipe,Suction length,10,m Pipe,Suction diameter,150,mm Pipe,Discharge length,150,m Pipe,Discharge diameter,150,mm Friction,Roughness,0.03,mm Friction,K_elbow,0.75,- Friction,K_gate valve,0.17,- Result,Static head,33.19,m Result,Friction total,13.25,m Result,Total head,46.44,m Always verify your Excel sheet against a known example:
( H = H_static + H_friction + H_velocity + H_pressure ) pump head calculation excel sheet
Friction factor (Swamee-Jain): =0.25/(LOG10(D2/(3.7*B2) + 5.74/G2^0.9))^2 Flow rate (Q)
Re: =F2*(B2/1000)/1e-6
h_fittings = (K_elbow * n_elbow + K_valve * n_valve) * v²/(2g) Total friction head = pipe loss + fittings loss TDH = H_static + H_friction_total + H_velocity (if any) Section 7: Output & Results | Description | Value | Unit | |-------------|-------|------| | Static head | 33.19 | m | | Suction friction | 0.85 | m | | Discharge friction | 12.40 | m | | Total pump head | 46.44 | m | | Required hydraulic power | (Q * TDH * ρ * g)/3600000 | kW | pump head calculation excel sheet