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.