An easy MS Excel software to use for water distribution system design: A real case distribution network design solution

Abstract

Development of an MS Excel Visual Basic for Applications (VBA) program for water distribution network (WDN) design is presented in this paper. The tool solves a given closed-loop WDN by Hardy-Cross algorithm. Both VBA programming and MS Excel’s data validation modules are employed to provide easy-to-use environment for engineers and also in the education of engineers, and moreover, software solutions in the market are expensive and hard to obtain. A step by step solution to a part of Uskudar which is a county of Istanbul network is also provided. The color-coded instructions for the correction of the network system will be helping for the users. The tool is open source and can be used for the design of WDNs by engineers and students.

KEYWORDS:

• Water distribution networks
• Hardy-Cross algorithm
• MS Excel
• Visual Basic for Applications
• easy application

Disclosure statement

No potential conflict of interest was reported by the author(s).

Supplemental data

Supplemental data for this article can be accessed at https://doi.org/10.1080/23249676.2020.1831975

Additional information

Notes on contributors

Orhan Gokyay

Orhan Gokyay has received his Bachelor’s degree in Environmental Engineering from Marmara University in 1999. He earned his MS degree in Environmental Engineering from Marmara University in 2001 and PhD in Environmental Technology from Boğaziçi University in 2009. He is currently a faculty member of Environmental Engineering at Marmara University, İstanbul, Turkey. His current research interests include management of sludges generated from wastewater treatment plants, water supply and distribution networks, wastewater collection and soil recovery.