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.
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.