
Design water supply networks by estimating pipe diameters and calculating pressures, forecast demand, analyze hydraulic losses with Darcy–Weisbach, Hazen–Williams, and Manning equations in Excel for branched and looped networks.
Forecast water demand with linear and exponential models using Qi and Qi+n at a 2.5% growth rate, illustrated by 200,000 residents at 150 litres per capita per day including leakage.
Use linear and exponential population growth models to forecast future water demand from the 2018 census to 2042, applying current population, annual growth rate, and per capita daily consumption.
Explore how the Bernoulli equation explains hydraulic losses and energy heads, including piezometric head, elevation head, pressure head, and velocity head, in water supply networks.
Explore major and minor hydraulic losses, and derive hf from the Darcy–Weisbach equation using lamda, length, diameter, and flow.
Derive and compare friction losses using Hazen–Williams, Manning, and Darcy equations to calculate hf from flow, length, and diameter, with lambda, Chw, and N as roughness factors.
Learn to calculate friction factors for water systems by lambda from Bar equation, Colebrook-White, or Moody diagram, using k, D, and Re; apply Hazen-Williams Chw and Manning N as needed.
Explore friction losses in a 400 m pvc pipe at 300 mm diameter and 130 l/s flow using Darcy–Weisbach, Hazen-Williams, and Manning equations at 10 C.
Compare friction losses using Hazen–Williams with a corrected Chw for a 300 mm PVC pipe and Manning’s equation, noting hf values of about 3.15, 3.46, and 3.4 m.
Learn about minor losses in hydraulic systems, caused by bends, elbows, valves, enlargers, and reducers. Use the head loss equation h_m = k v^2/(2g) and Q/A based form to compute.
Analyze minor losses with k values for enlargers, reducers, tank inlets and outlets, and branches with different directions, using hm = v^2/(2g) to evaluate a1, a2, and k.
Compute total hydraulic losses by friction losses from the Darcy equation using velocity, diameter, and temperature-based viscosity, then add minor losses from tank entrances and elbows to reach 9.4 m.
Compute downstream and upstream piezometric heads in a 0.4 m pipe, applying Darcy equation losses and Bernoulli energy balance to determine the required upstream pressure head.
Applying the energy balance for upflow, this example shows a 68 meter water column pump head to achieve 30 meter pressure at the city entrance using Bernoulli.
Learn to compute maximum pipe capacity for a known diameter using an iterative method with Reynolds number, lamda factor, and Darcy-Weisbach, illustrated by a 500 mm pipe reaching 0.48 m3/s.
Compute the optimal pipe diameter for a given flow by iterating velocity using the diameter–flow relation, Reynolds number, and lamda; Moody diagram offers an alternative. The example yields 500 mm.
design branched water supply networks by estimating nodal demands from population and per person consumption, compute pipe flows and nodal pressures via mass conservation, and select pipe diameters.
Calculate nodal pressures in a branched water supply network by computing hydraulic losses with Darcy's equation (or Hazen-Williams/Manning), selecting diameters, and determining velocity and Reynolds number in an Excel sheet.
Explain how pressure head equals piezometric head minus elevation head, and how nodal pressures from 2 through 9 vary with diameter changes to reduce friction loss.
Explore looped network design using hardy cross methods, balancing heads or balancing flows with Q and H corrections, to determine pipe flows and nodal pressures in a reservoir-fed system.
Apply the balancing heads method to correct Qs in a looped water supply network, iterating with hf, Reynolds number, and Delta Q using Excel calculations.
Design looped water supply networks using an Excel-based method, assigning pipe diameters and loop directions, computing Q values, and applying hf corrections to update flows.
Iterate Q and delta Q corrections in a looped network design using Excel sheets to update loop flows and shared pipe adjustments.
Use excel sheet-4 to iteratively refine the first flow assumption in a looped network, stopping when delta q is small and final pressure remains stable.
In this course I would like to teach you simple method of Water Supply System design. After this course you will be able to confidently use excel sheets in design of accurate and economic Water Supply Networks.
The course consists of 5 sections:
Section 1: Introduction about Water Supply System, and about the structures and components of the course.
Section 2: Water Demand Forecasting
Section 3: Hydraulic Losses includes:
3.1 Bernoulli Equation
3.2 Friction Losses
3.2.1 Friction losses (hf) from Darcy–Weisbach
3.2.2 Friction losses (hf) from Hazen–Williams & Manning
3.2.3 Friction factors
3.2.4 Example of Friction losses (hf) by Darcy–Weisbach
3.2.5 Example of Friction losses (hf) by Hazen–Williams & Manning
3.3 Minor losses
3.4 Example of hydraulic losses calculation (Friction losses & Minor losses)
3.5 Example of required pressure calculation in water supply system
Section 4: Maximum pipe capacity & Optimal diameter includes:
4.1 Maximum pipe capacity and example by Excel sheet
4.2 Optimal diameter and example by Excel sheet
Section 5: Water Supply Network Design includes:
5.1 Branched Network Design and example by Excel sheet
5.2 Looped Network Design and example by Excel sheet
In this course the excel sheet will be used in the design, because excel sheet simplify the calculation due to the relationships between the cells are by equations so when you change any value, all calculations of design will be automatically changed. You can use the same excel sheet of design, just you have to insert your input data and you will get the results, but just you have to check the results and change the inputs if you need.