Sorry, this page is no longer available
We may earn an affiliate commission when you visit our partners.
Course image
Dr. Mohammed Hasan Almughalles

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

Read more

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.

Enroll now

What's inside

Learning objectives

  • Learning how to do water demand forecasting for the target area
  • Learning how to calculate hydraulic losses for water supply systems and the effect of hydraulic losses in the design of those systems
  • Learning the estimation of maximum flow for a known diameter of pipe and estimation of optimal diameter for a known flow
  • Learning the design of the two type of water supply networks as branched network and looped network

Syllabus

Introduction
Water Demand Forecasting
Water Demand Forecasting-1
Water Demand Forecasting-2
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Uses Excel sheets to simplify calculations, which is a practical skill for civil engineers in designing water supply networks and analyzing different scenarios
Covers water demand forecasting, which is a fundamental aspect of water supply system design and crucial for planning and resource allocation
Explores both branched and looped network designs, providing a comprehensive understanding of different water distribution system configurations and their applications
Examines hydraulic losses using Darcy-Weisbach, Hazen-Williams, and Manning equations, which are essential for accurate modeling and design of water supply systems
Focuses on older methods such as Hazen-Williams, which may be less relevant than more modern methods in certain contexts and software
Requires learners to have access to Microsoft Excel, which may not be readily available to all students and could pose a barrier to entry

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Design of water supply systems overview

According to students, this course offers a solid introduction and practical application for designing water supply systems. Many appreciate the focus on using Excel sheets for calculations, finding it a simple and effective method for tackling design problems. Reviewers highlight that the explanations are generally clear and the examples helpful, making it a good starting point, particularly for those new to the field or needing a refresher. However, some learners with more experience found the content too basic and felt it lacked the necessary depth for handling more complex scenarios or advanced theoretical aspects. Overall, it's viewed as a valuable resource for gaining fundamental skills and practical tools.
Provided Excel tools are functional but basic.
"The Excel sheets are useful as a starting point, but they are quite basic and might need significant modification for real-world projects."
"I had to modify the provided Excel sheets quite a bit to suit my specific project requirements and include more parameters."
"While the sheets work for the examples, I wish the provided tools were a bit more robust and flexible."
"The included Excel sheets are functional but feel somewhat rudimentary compared to professional software."
Concepts explained clearly and logically.
"The instructor explained the hydraulic principles and design steps very clearly throughout the course."
"I understood the steps for network design thanks to the detailed explanations and examples provided."
"The concepts were presented in a logical and easy-to-grasp manner, making complex ideas understandable."
"The explanations were concise and to the point, which helped reinforce my learning."
Provides a clear foundation for new learners.
"This course was a great starting point for someone like me who is new to water supply system design."
"As a student, I found the explanations easy to follow and the examples very helpful in understanding the concepts."
"Perfect for beginners or those needing a basic understanding of the design process and calculations involved."
"It covers the fundamentals in a way that is accessible even without prior extensive knowledge."
Focus on Excel simplifies design tasks.
"The use of Excel sheets in this course is incredibly practical and makes the calculations much faster and less prone to error."
"I can now confidently use the provided Excel sheets as templates for designing simple water supply networks. Very helpful!"
"Learning how to automate design calculations using Excel was a key takeaway for me; it directly applies to my work."
"The approach of using Excel sheets simplifies complex hydraulic calculations significantly."
May not be sufficient for complex projects.
"While it covers the basics well, experienced engineers might find this course too basic; it doesn't go into advanced topics."
"Could use more in-depth coverage on complex network analysis methods or optimization techniques beyond the basics."
"I was hoping for more detail on handling larger, more intricate systems, but the examples are quite simple."
"The theoretical depth is limited; it focuses more on the application using the provided tools."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Design of Water Supply Systems with these activities:
Review Fluid Mechanics Principles
Reviewing fluid mechanics principles will provide a solid foundation for understanding hydraulic losses and pressure calculations in water supply systems.
Browse courses on Fluid Mechanics
Show steps
  • Review key concepts like pressure, viscosity, and flow rate.
  • Work through practice problems related to fluid flow in pipes.
Read 'Water Supply Engineering' by Babbitt and Baumann
Reading 'Water Supply Engineering' will provide a broader understanding of the principles and practices involved in water supply system design.
View Melania on Amazon
Show steps
  • Read chapters related to water demand, hydraulics, and network design.
  • Take notes on key concepts and formulas.
  • Work through example problems to reinforce understanding.
Hydraulic Loss Calculations Practice
Practicing hydraulic loss calculations using Darcy-Weisbach and Hazen-Williams equations will improve accuracy and speed in water supply system design.
Show steps
  • Solve problems involving friction losses in pipes of varying materials and diameters.
  • Calculate minor losses due to fittings and valves.
  • Compare results from different equations and analyze discrepancies.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Develop an Excel Sheet for Pressure Calculation
Creating an Excel sheet for pressure calculation will reinforce understanding of the relationships between different parameters in a water supply system.
Show steps
  • Design the Excel sheet layout with input cells for relevant parameters.
  • Implement formulas for calculating pressure losses and required pressure.
  • Test the sheet with different scenarios and validate the results.
Design a Water Supply System for a Small Community
Designing a water supply system for a small community will provide practical experience in applying the concepts learned in the course.
Show steps
  • Estimate water demand for the community based on population and usage patterns.
  • Select appropriate pipe sizes and materials based on flow requirements and pressure considerations.
  • Design the network layout, including pipe routing and placement of valves and fittings.
  • Calculate hydraulic losses and ensure adequate pressure throughout the system.
Read 'Open Channel Hydraulics' by Ven Te Chow
Reading 'Open Channel Hydraulics' will provide a broader understanding of the principles and practices involved in water supply system design.
Show steps
  • Read chapters related to water demand, hydraulics, and network design.
  • Take notes on key concepts and formulas.
  • Work through example problems to reinforce understanding.
Create a Video Explaining Hardy Cross Method
Creating a video explaining the Hardy Cross method will solidify understanding and improve communication skills.
Show steps
  • Review the Hardy Cross method for looped network analysis.
  • Prepare a script and visual aids to explain the method clearly.
  • Record and edit the video, ensuring clarity and accuracy.

Career center

Learners who complete Design of Water Supply Systems will develop knowledge and skills that may be useful to these careers:
Water Distribution Manager
Water Distribution Managers oversee the operation and maintenance of water supply systems, ensuring reliable delivery of water to consumers. A deep understanding of water demand, hydraulic losses, and network design is essential for effective management. This course can lead to success in your role. By learning how to forecast water demand, calculate hydraulic losses, and design efficient networks, you can optimize system performance and minimize disruptions. The Excel-based design approach may be useful for analyzing system behavior and making informed decisions.
Hydraulic Engineer
Hydraulic Engineers specialize in the flow and conveyance of fluids, particularly water. They design and analyze systems for water distribution, irrigation, and flood control. A strong understanding of hydraulic principles and network design is fundamental to their work. This course can help you master the calculation of hydraulic losses, optimize pipe diameters, and design both branched and looped water supply networks. The use of Excel sheets can simplify complex calculations and improve the accuracy of your designs, essential for effective hydraulic engineering.
Water Resources Engineer
A Water Resources Engineer focuses on managing and protecting water resources, a role where understanding water supply systems is crucial. These engineers design systems for water distribution, wastewater collection, and stormwater management. This may be a good fit for you. The course's emphasis on water demand forecasting, hydraulic losses, and network design directly applies to the daily tasks of a Water Resources Engineer. By learning how to use Excel sheets for design, you can streamline calculations and improve the accuracy and efficiency of your designs. You can apply this course to real-world water supply challenges.
Sanitary Engineer
Sanitary Engineers focus on the treatment and distribution of potable water, the collection and treatment of wastewater, and the management of solid waste. Designing efficient and safe water supply systems is a core component of their responsibilities. With this course, you can learn the principles of water demand forecasting, hydraulic losses, and network design, essential for ensuring the delivery of clean water. The practical application of Excel sheets for design simplifies the process and enhances your ability to optimize water distribution networks.
Municipal Engineer
Municipal Engineers work for local governments, planning and managing public works projects, including water supply systems. They must understand the principles of water distribution and network design to ensure the efficient and reliable delivery of water to the community. This course can help you learn about water demand forecasting, hydraulic losses, and network design. The ability to use Excel sheets for design simplifies the process and enhances your ability to optimize water supply networks for municipal needs.
Civil Engineer
Civil Engineers plan, design, and oversee the construction and maintenance of infrastructure projects, including water supply systems. Understanding the principles of water supply design is essential for civil engineers involved in urban development and infrastructure projects. This course can help you understand water demand forecasting, hydraulic losses, and network design, providing a strong foundation for designing efficient and reliable water distribution systems. You can create Excel-based tools for calculations, enhancing your ability to analyze and optimize water supply networks.
Utilities Engineer
Utilities Engineers work for utility companies, managing the infrastructure for water, electricity, and gas distribution. Designing and maintaining water supply systems is a critical part of their role. This course can lead to success in your role. A solid understanding of water demand forecasting, hydraulic losses, and network design enables you to optimize system performance and minimize disruptions. The Excel-based design tools taught in the course may be useful for analyzing system behavior and making informed decisions.
Environmental Engineer
Environmental Engineers work to protect the environment and human health through the design of solutions for water and air pollution control, waste disposal, and public health issues. Designing efficient and sustainable water supply systems is a critical aspect of their work. This course can advance your knowledge of water demand forecasting, hydraulic losses, and network design will allow you to develop more effective and environmentally friendly systems. The Excel-based design approach taught in the course may be useful in optimizing water use and minimizing environmental impacts.
Irrigation Engineer
Irrigation Engineers design and manage irrigation systems for agricultural purposes, ensuring efficient water use for crop production. A deep understanding of water demand, hydraulic losses, and network design is essential for effective irrigation system design. This course can help you master these skills. By learning how to forecast water demand, calculate hydraulic losses, and design efficient networks, you can optimize irrigation systems for maximum crop yield. The Excel-based design approach may be useful for analyzing system performance and making informed decisions.
Environmental Consultant
Environmental Consultants advise organizations on environmental issues, including water resource management. They may assess the impact of development projects on water supply systems and recommend mitigation measures. This course may be useful for you. Knowledge of water demand forecasting, hydraulic losses, and network design can help you evaluate the sustainability and efficiency of water supply systems. The ability to use Excel-based design tools can aid in conducting quick assessments and providing informed recommendations.
Researcher
Researchers in civil, environmental, or agricultural engineering conduct studies to improve water resource management, water supply systems, and irrigation technologies. These Researchers often hold advanced degrees, such as a masters, or a doctorate. A strong understanding of water supply systems, including water demand forecasting, hydraulic losses, and network design, is essential for conducting meaningful research. By gaining expertise in these areas, you can contribute to the development of more efficient, sustainable, and resilient water management practices, informing policy and engineering design. You can perform your research using the Excel based methods learned in the course.
Sustainability Consultant
Sustainability Consultants advise organizations on sustainable practices, including water conservation and efficient water use. A comprehensive understanding of water supply systems is helpful for assessing and improving the sustainability of water management practices. This course may be useful for you. The course's coverage of water demand forecasting, hydraulic losses, and network design provides valuable insights for identifying opportunities to reduce water consumption and minimize environmental impacts. The ability to use Excel-based design tools can aid in quantifying the benefits of sustainable water management strategies.
Construction Manager
Construction Managers oversee the construction of various projects, including water supply systems. While the Construction Manager doesn't perform detailed design work, understanding the fundamentals of water supply systems is crucial for effective project management. You may find this course helpful. The course's coverage of water demand forecasting, hydraulic losses, and network design provides valuable context for overseeing construction activities. Familiarity with Excel-based design tools aids in monitoring progress and ensuring that the constructed system meets design specifications.
Project Manager
A Project Manager in the construction or engineering sector oversees the planning, execution, and completion of projects, including water supply infrastructure. This course may be helpful for you. While the Project Manager doesn't necessarily perform detailed design work, understanding the technical aspects of water supply systems is crucial for effective management. The course's coverage of water demand forecasting, hydraulic losses, and network design provides valuable insights for overseeing these types of projects. Familiarity with Excel-based design tools can aid in monitoring progress and ensuring accuracy.
Water Treatment Specialist
Water Treatment Specialists operate and maintain water treatment plants, ensuring the delivery of clean and safe water to consumers. While the role primarily focuses on treatment processes, understanding the broader water supply system is beneficial. This course may be useful for you. The course's coverage of water demand forecasting and hydraulic losses provides context for understanding how treatment plant operations impact the overall water supply. Familiarity with network design principles can aid in troubleshooting system issues and optimizing plant performance.

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Design of Water Supply Systems.
While primarily focused on open channel flow, this book provides fundamental hydraulic principles that are relevant to water supply systems. It covers topics such as flow resistance, energy losses, and hydraulic structures. Understanding these principles is essential for designing efficient and reliable water conveyance systems.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Similar courses are unavailable at this time. Please try again later.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser