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, cilt.8, sa.4, ss.290-297, 2020 (ESCI) identifier identifier

  • Yayın Türü: Makale / Tam Makale
  • Cilt numarası: 8 Sayı: 4
  • Basım Tarihi: 2020
  • Doi Numarası: 10.1080/23249676.2020.1831975
  • Dergi Adı: JOURNAL OF APPLIED WATER ENGINEERING AND RESEARCH
  • Derginin Tarandığı İndeksler: Emerging Sources Citation Index (ESCI), Scopus
  • Sayfa Sayıları: ss.290-297
  • Anahtar Kelimeler: Water distribution networks, Hardy-Cross algorithm, MS Excel, Visual Basic for Applications, easy application, TOOL, IMPLEMENTATION, ALGORITHM, MATLAB
  • Marmara Üniversitesi Adresli: Evet

Özet

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.