To calculate the booster pump head using Excel, we can create a simple spreadsheet with the following inputs:
Below is an example Excel spreadsheet for calculating booster pump head:
Hf = 0.02 * (1000/0.1) * (1.5^2/2*9.81) = 2.29 m Hs = 20 - 10 = 10 m Hm = 10% of H = 0.1 * (2.29 + 10) = 1.23 m H = 2.29 + 10 + 1.23 = 13.52 m
H = Hf + Hs + Hm
Using the calculations above, we get: