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

GÖKYAY O.

JOURNAL OF APPLIED WATER ENGINEERING AND RESEARCH, vol.8, no.4, pp.290-297, 2020 (ESCI) identifier identifier

  • Publication Type: Article / Article
  • Volume: 8 Issue: 4
  • Publication Date: 2020
  • Doi Number: 10.1080/23249676.2020.1831975
  • Journal Name: JOURNAL OF APPLIED WATER ENGINEERING AND RESEARCH
  • Journal Indexes: Emerging Sources Citation Index (ESCI), Scopus
  • Page Numbers: pp.290-297
  • Keywords: Water distribution networks, Hardy-Cross algorithm, MS Excel, Visual Basic for Applications, easy application, TOOL, IMPLEMENTATION, ALGORITHM, MATLAB
  • Marmara University Affiliated: Yes

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.