A spreadsheet tool for the analysis of flows in small-scale water piping networks

The analysis of water piping system has been presented by several authors in the past and in recent years proposing several solution algorithms. Among the notable methods are the Hardy cross method, linear approximation method, Newton Raphson method and the hybrid method to mention but a few, to solve a system of partly linear, and partly non-linear hydraulic equations. In this paper, the authors demonstrate the use of Excel solver to verify the Hardy Cross method for the analysis of flow in water piping networks. A single-loop water network derived from real situation was used as numerical example and case study. Detailed numerical data are presented to explain the results of the studied network.

[1]  Y. M. Hamam,et al.  Pressure control for leakage minimization in water supply networks , 2007 .

[2]  Y. M. Hamam,et al.  Locating Pressure Control Elements for Leakage Minimisation in Water Supply Networks by Genetic Algorithms , 1993 .

[3]  H. A. Basha,et al.  Analysis of water distribution systems using a perturbation method , 1996 .

[4]  Philip R. Page,et al.  Parameter-Less Remote Real-Time Control for the Adjustment of Pressure in Water Distribution Systems , 2017 .

[5]  Alejandro Rivas,et al.  The application of spreadsheets to the analysis and optimization of systems and processes in the teaching of hydraulic and thermal engineering , 2006, Comput. Appl. Eng. Educ..

[6]  Daniel P. Loucks,et al.  Impact of changing computer technology on hydrologic and water resource modeling , 1987 .

[7]  M. Spiliotis,et al.  Water Distribution System Analysis: Newton-Raphson Method Revisited , 2011 .

[8]  Philip R. Page,et al.  Real-time Dynamic Hydraulic Model for Potable Water Loss Reduction , 2016 .

[9]  Khalil S. Hindi,et al.  LOCATING PRESSURE CONTROL ELEMENTS FOR LEAKAGE MINIMIZATION IN WATER SUPPLY NETWORKS: AN OPTIMIZATION MODEL , 1991 .

[10]  Adnan M. Abu-Mahfouz,et al.  Pressure Management Strategies for Water Loss Reduction in Large-Scale Water Piping Networks: A Review , 2018 .

[11]  Philip R. Page,et al.  Real-time Adjustment of Pressure to Demand in Water Distribution Systems: Parameter-less P-controller Algorithm☆ , 2016 .

[12]  Hardy Cross,et al.  Analysis of flow in networks of conduits or conductors , 1936 .

[13]  Adnan M. Abu-Mahfouz,et al.  Wireless sensor network-based improved NPW leakage detection algorithm for real-time application in pipelines , 2016 .

[14]  Yskandar Hamam,et al.  State estimation in water distribution network: A review , 2017, 2017 IEEE 15th International Conference on Industrial Informatics (INDIN).

[15]  A. Brameller,et al.  Hybrid method for the solution of piping networks , 1971 .

[16]  Adnan M. Abu-Mahfouz,et al.  Pressure Management of Water Distribution Systems via the Remote Real-Time Control of Variable Speed Pumps , 2017 .

[17]  El Bahrawy,et al.  Use Of Spreadsheets For Rainfall-Runoff Calculations , 1996 .

[18]  Khalil S. Hindi,et al.  Pressure control for leakage minimization in water supply networks Part 1: Single period models , 1991 .

[19]  Daniele B. Laucelli,et al.  Water Distribution Network Pressure-Driven Analysis Using the Enhanced Global Gradient Algorithm (EGGA) , 2011 .

[20]  Pierre Carpentier,et al.  Applied mathematics in water supply network management , 1993, Autom..

[21]  Lindell Ormsbee,et al.  The History of Water Distribution Network Analysis: The Computer Age , 2008 .

[22]  Uri Shamir,et al.  Water Distribution Systems Analysis , 1968 .

[23]  Adnan M. Abu-Mahfouz,et al.  Robustness of Parameter-Less Remote Real-Time Pressure Control in Water Distribution Systems , 2018 .

[24]  Adnan M. Abu-Mahfouz,et al.  Real-time Dynamic Hydraulic Model for Water Distribution Networks: Steady State Modelling , 2016 .