WDNETXL AN EXCELBASED SOLUTION TO BRING WATER DISTRIBUTION

WDNETXL AN EXCEL-BASED SOLUTION TO BRING WATER DISTRIBUTION NETWORK ANALYSIS CLOSER TO USERS O. Giustolisi, L. Berardi, D. Laucelli Technical University of Bari, Bari (Italy) o. giustolisi@poliba. it, l. berardi@poliba. it, d. laucelli@poliba. it

Italian Hydroinformatics Group www. hydroinformatics. it The Italian Hydroinformatics Group at Technical University of Bari works in the areas of: ü data modeling applied to natural systems ü analysis and modeling of water systems ü hydrology and geological engineering Research and transfer of results

Italian Hydroinformatics Group www. hydroinformatics. it

WDNet. XL Users and Motivations Who is it for? ü technician and manager of water systems ü researchers which don't develop modeling codes ü students at all levels (engineers/managers of tomorrow) WDNet. XL is currently used by students at Technical University of Bari (Ms. C in Civil and Environmental Engineering) to carry out water system design and optimization within the course. WDNet. XL allows for interactive lessons where students are involved in real time on the networks analysis through the user-friendly environment of MS-Excel The implementation of WDNet. XL functions as MS-Excel add-in allows to: ü transfer and disseminate just in time of tools developed by technical research; ü use a familiar and unique work environment for different applications; ü use a work environment that allows for analysis of input/output data; ü customize the work environment to peculiar needs; ü customize functions to specific needs.

WDNet. XL How does it work? Example: function in MS-Excel for network analysis WDN_simulation_xls(Analyses!B 6; pipes!B 4: T 37; nodes!B 4: L 27; coords!B 4: D 27; assets!B 4: D 15; assets!E 4: E 15; Analyses!C 9; Analyses!D 9: E 9; Analyses!G 9)

WDNet. XL The Graphic User Interface

WDNet. XL Implemented Functions WDNet. XL offers a full range of MS-Excel functions to analyze a water distribution network ü Steady-State Simulation ü Extended Period Simulation (EPS) ü Analysis of Valve System and relevant topology ü Steady-state and EPS simulation of WDN under pipe failure scenarios. ü Optimal pipe sizing of WDN, based on evolutionary techniques ü Optimal valve system design , based on evolutionary techniques ü Optimal sampling design based on topological considerations ü … and more in progress by technical research WDNet. XL is ü fully integrated in MS-Excel format ü readily usable without any additional software ü easily upgradeable and customizable

WDNet. XL Main innovative features ü ü ü Advanced hydraulic simulation with pressure-driven demands; Advanced hydraulic simulation of water losses at pipe level; Topological analysis embedded in the hydraulic simulation; Analysis of control devices by non-heuristic algorithms; Analysis of variable tank levels within the single simulation (G-GGA); Use of Enhanced GGA (EGGA) for large networks (e. g. , simulation of a network of 160, 000 nodes in a few tenths of second); Analysis of the valve systems and optimal design; Analysis of network reliability under failure conditions considering the valve system; Analysis and optimal sampling design for calibration; Analysis and optimal design of district areas; Implementation of different types of water demands; Using GPU, rehabilitation planning and more. . . not yet published.

WDNet. XL Visualization and Editing

WDNet. XL Graphical outcomes ü ü Failure scenarios EPS simulation Valves design Topological analysis

WDNet. XL Results in MS-Excel tables ü ü EPS simulation Failure scenarios Valve system Pipe sizing

WDNet. XL User manual and remote user support (by website) www. hydroinformatics. it

WDNet. XL Documentation

WDNet. XL Summary and conclusions ü WDNet. XL is a software designed for engineers and managers of today and tomorrow (engineering students); ü The mission is to transfer up-to-date research results to users in an efficient and user-friendly manner; ü WDNet. XL implements several tools for analyzing water networks developed and tested by IHG; ü The package WDNet. XL is constantly evolving and is easy to update; ü The use of WDNet. XL is easy to learn because it is implemented in MSExcel (fully customizable); ü WDNet. XL produces different types of outcomes that can be used for traditional (paper) and innovative (hypertext and website) technical drawings.

Research & Transfer ANN MOGA-XL ANN-MOGA is a paradigm for optimal construction of artificial neural networks (ANN) ü it is based on a MOGA approach for the construction of ANN; ü it allows the modeling of complex phenomena by ANN also for non-expert users; ü models retrieved are a trade-off between accuracy and complexity (number of parameters); ü models produced are not affected by overfitting and curse of dimensionality, as usual for ANN; ü (under certain conditions) it allows the selection of ANN models based on physical insights; ANN MOGA-XL is a MS-Excel add-in ü It can be used as a MS-Excel function ; ü It does not need any additional software; ü It is easily upgradeable and customizable;

Research & Transfer EPR MOGA-XL EPR is a data-mining technique that combines the effectiveness of GA with the robustness of numerical regression ü it produces models as symbolic mathematical expressions; ü it implements a multi-objective research paradigm based on GA; ü the optimal models returned are a trade-off between accuracy and parsimony; ü it allows the physical interpretation of the produced modeling structures; ü it allows the modeling of complex phenomena, both dynamic and static; ü it has a wide range of applications, from hydraulic engineering to environmental engineering, from geotechnical to structural engineering. EPR MOGA-XL is a MS-Excel add-in ü It can be used as a MS-Excel function ; ü It does not need any additional software; ü It is easily upgradeable and customizable;

Italian Hydroinformatics Group www. hydroinformatics. it u q y An ! ? n o i t s e