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.

An extended period modeling of water supply systems using hydraulic simulators

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

Better Water Demand and Pipe Description Improve the Distribution Network Modeling Results

Real-Time Water Distribution System Hydraulic Modeling Using Prior Demand Information by Formal Bayesian Approach.

A New Method For On-Line Demand Calibration Of Wds Hydraulic Model

Efficient Numerical Approach for Simultaneous Calibration of Pipe Roughness Coefficients and Nodal Demands for Water Distribution Systems

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

Distribution Network Assessment using EPANET for Intermittent and Continuous Water Supply

Integrated Model Driven by Agent-Based Water End-Use Forecasting to Evaluate the Performance of Water and Wastewater Pipeline Systems

Online state estimation in water distribution systems via Extended Kalman Filtering

Streaming Smart Meter Data Integration to Enable Dynamic Demand Assignment for Real-Time Hydraulic Simulation

Hydraulic Simulation of Water Supply Network Leakage Based on EPANET

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

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

EPANET based simulation on variable pressure mode with VFPs in water supply system

Hydraulic Responses and Flow Regulation in Multi-Demand Water Transfer Systems

[Development and Application of a Multi-Species Water Quality Model for Water Distribution Systems with EPANET-MSX].

Enhancing Long-Term Water Quality Modeling by Addressing Base Demand, demand Patterns, and Temperature Uncertainty Using Unsupervised Machine Learning Techniques.

Real-Time Model of a Large-scale Water Distribution System

Simulation of Pipe Networks Using EPANET to Optimize Water Supply: A Case Study for Arjawinangun Area, Indonesia

Simulation of Intermittent Water Distribution Networks by EPA-SWMM: Comparing Model Results and Field Experiments