Modeling and Design Optimization of Looped Water Distribution Networks using MS Excel: Developing the Open-Source X-WHAT Model
Cost-effective water distribution network (WDN) design is crucial for reliable urban water supply. This paper introduces the open-source Excel for Water system Hydraulic Analysis Tool (X-WHAT) for WDN simulation and preliminary design. Unlike traditional spreadsheet approaches based on Hardy-Cross iteration, X-WHAT use...