Booster Pump Head Calculation Xls Access

Please note that this is a simplified example and actual calculations may require more complex formulas and considerations.

Hm = 10-20% of H

Hs = Zs - Zd

| 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 | booster pump head calculation xls

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

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

Hf = f * (L/D) * (V^2/2g)

The margin of safety is added to account for any uncertainties in the system:

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.

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 Please note that this is a simplified example

Suppose we want to calculate the booster pump head for a water supply system with the following inputs:

H = Hf + Hs + Hm

Using the calculations above, we get:

| Input | Value | Unit | Formula | | --- | --- | --- | --- | | Flow rate (Q) | 0.01 | m^3/s | | | Length of pipe (L) | 1000 | m | | | Diameter of pipe (D) | 0.1 | m | | | Elevation of suction point (Zs) | 10 | m | | | Elevation of discharge point (Zd) | 20 | m | | | Friction factor (f) | 0.02 | - | | | Velocity of fluid (V) | 1.5 | m/s | | | Friction head loss (Hf) | =0.02* (1000/0.1)* (1.5^2/2*9.81) | m | =(F2* (F3/F4)* (F7^2/2*9.81)) | | Static head (Hs) | =F5-F6 | m | =(F5-F6) | | Margin of safety (Hm) | =0.1*(Hf+ Hs) | m | =0.1*(F8+F9) | | Total head (H) | =F8+F9+F10 | m | =(F8+F9+F10) |

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