Abstract:Cost-effective water distribution network (WDN) design with acceptable pressure performance is crucial for the management of drinking water in cities. This paper presents a Microsoft Excel tool to model, simulate, and optimize WDNs with looped pipelines under steady-state incompressible flow simulations. Typically, the hardy-cross method is applied using spreadsheet calculations to estimate discharges. This method requires mass-conservative initial estimates and requires successive iterations to converge. In this paper, however, we develop an alternative method that uses the built-in solver capabilities of Excel, does not require initial mass-conservative estimation, and is free of flow corrections. The main objective of this paper is to develop an open-source accessible tool for simulating hydraulic networks also adapted for teaching and learning purposes. The governing equations and the mathematical basis for the hydraulic modeling of the system are mathematically described, considering the topology of the network, mass and energy conservation, cost of tank material, foundation, and cost of pumping energy to fill the tank. The use of this tool is encouraged at the undergraduate and graduate engineering levels, as it offers the opportunity to address complex concepts in a comprehensive way using a spreadsheet that does not require coding expertise. Hence, users can debug all cells and understand all equations used in the hydraulic model, as well as modify them. To demonstrate the model capabilities, three practical examples are presented, with the first one solved step by step, and the results are compared with the EPANET and with the results reported in the literature. Using the optimization method presented in this paper, it was possible to achieve a cost reduction of 151,790 USD (9.8% of the total cost) in a network that supplies a 44,416 population.

Overview of WaterGEMS Software: Applications in Optimizing Water Distribution Systems and Addressing Water Scarcity

An Improved Genetic Algorithm For Optimal Layout Of Flow Meters And Valves In Water Network Partitioning

Global Energy and Leakage Optimization in Water Distribution Systems from Water Treatment Plants to Customer Taps

A decomposition and multistage optimization approach applied to the optimization of water distribution systems with multiple supply sources

A graph decomposition‐based approach for water distribution network optimization

Robust Optimization of Water Infrastructure Planning under Deep Uncertainty Using Metamodels

Energy and Water Management for Industrial Large-Scale Water Networks: A Systematic Simultaneous Optimization Approach

Self-adaptive differential evolution algorithm applied to water distribution system optimization

Establishment and Application of Coupled Model for Optimal Operation of Water Supply Network

Demand-Driven Spatiotemporal Variations of Flow Hydraulics and Water Age by Comparative Modeling Analysis of Distribution Network

A Software Tool for Reliability, Analysis, and Security Assessment of Water Distribution Systems

Water distribution system modelling of GIS–remote sensing and EPANET for the integrated efficient design

Selection of Software for Simulation of Water Distribution Network in Port Area

Study on Water Distribution Network Digital Analysis Platform in H City, Northeast China

An Efficient Approach for Partitioning Water Distribution Networks Using Multi-Objective Optimization and Graph Theory

Establishment and Application of Hydraulic Modeling for Water Distribution System Based on InfoWorks

Design optimization of water distribution networks: real-world case study with penalty-free multi-objective genetic algorithm using pressure-driven simulation

Energy-efficient and Reliable Coordinated Scheduling for Water Distribution Systems: Enhancing Hydraulic Conditions and Water Quality

An enhanced simulation-based iterated local search metaheuristic for gravity fed water distribution network design optimization

Modeling and Design Optimization of Looped Water Distribution Networks using MS Excel: Developing the Open-Source X-WHAT Model

Decision Support System of Water Distribution Network Expansion