Booster pumps are used to increase the pressure of a fluid in a piping system. They are commonly used in water supply systems, irrigation systems, and industrial processes. The head calculation of a booster pump is crucial to ensure that it can provide the required pressure to overcome the losses in the system and deliver the desired flow rate. This paper will discuss the calculation of booster pump head using Microsoft Excel.

The head of a booster pump is calculated using the following formula:

H = Hf + Hs + Hm

Below is an example Excel spreadsheet for calculating booster pump head:

To calculate the booster pump head using Excel, we can create a simple spreadsheet with the following inputs:

The calculation of booster pump head is an important step in designing a piping system. Using Excel, we can create a simple and efficient tool to perform these calculations. By inputting the required parameters, we can quickly calculate the total head required for the booster pump. This calculation can be used to select the correct pump and ensure that it can provide the required pressure to overcome the losses in the system and deliver the desired flow rate.

| Input | Value | Unit | | --- | --- | --- | | Flow rate (Q) | | m^3/s | | Length of pipe (L) | | m | | Diameter of pipe (D) | | m | | Elevation of suction point (Zs) | | m | | Elevation of discharge point (Zd) | | m | | Friction factor (f) | | - | | Velocity of fluid (V) | | m/s |