{"title":"An easy MS Excel software to use for water distribution system design: A real case distribution network design solution","authors":"Orhan Gokyay","doi":"10.1080/23249676.2020.1831975","DOIUrl":null,"url":null,"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.","PeriodicalId":51911,"journal":{"name":"Journal of Applied Water Engineering and Research","volume":"8 1","pages":"290 - 297"},"PeriodicalIF":1.4000,"publicationDate":"2020-10-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"https://sci-hub-pdf.com/10.1080/23249676.2020.1831975","citationCount":"2","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Journal of Applied Water Engineering and Research","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1080/23249676.2020.1831975","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q4","JCRName":"WATER RESOURCES","Score":null,"Total":0}
引用次数: 2
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.
期刊介绍：
JAWER’s paradigm-changing (online only) articles provide directly applicable solutions to water engineering problems within the whole hydrosphere (rivers, lakes groundwater, estuaries, coastal and marine waters) covering areas such as: integrated water resources management and catchment hydraulics hydraulic machinery and structures hydraulics applied to water supply, treatment and drainage systems (including outfalls) water quality, security and governance in an engineering context environmental monitoring maritime hydraulics ecohydraulics flood risk modelling and management water related hazards desalination and re-use.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
