How to Perform Pipeline Design Calculations in Excel (2 Examples)

Method 1 – Finding Pipe Diameter for Pipeline Design Calculations

Steps:

• Enter the given data.

• Use the following formula to find the discharge rate (Q). To find this, multiply the number of people with the water demand and the peak factor. We are converting it to the cubic meter per second unit.

• Insert the following formula to find the maximum allowable head loss:

• Enter the following formula to get the initial diameter of the pipe:

• Select a pipe from the available pipes. The closest pipe in the list below is 0.15 meters. We will select this.

• Find the diameter and the actual head loss from the Hazen-Williams head loss equation:

• Use the following formula to find the actual head loss:

• Enter the following formula to find the hydraulic grade line (HGL):

• Enter the following formula to calculate the residual head:

• Enter the following formula to find the residual status:

• Enter the following formula to return the flow’s velocity. We can see that the velocity exceeds the limit of 3.1 m/s, so we need to increase the diameter.

• We have chosen the next pipe diameter of 0.175 meters. Now, the velocity is inside the limit.

• To calculate the diameter of the pipe for the next region.

Method 2 – Calculating Minimum Pipe Spacing for Pipeline Design

Steps:

• Create a table to enter the data.

• Enter the given data. The clearance distance is 25 millimeters.

• Enter the following formula to calculate the minimum pipe spacing for the pipeline design calculations:

Download the Practice Workbook

You can download the Excel file from the link below.

<< Go Back to Excel Templates