一个简单的用于配水系统设计的MS Excel软件：一个真实的配水网络设计解决方案

IF 1.4 Q4 WATER RESOURCES

Journal of Applied Water Engineering and Research Pub Date : 2020-10-01 DOI:10.1080/23249676.2020.1831975

Orhan Gokyay

{"title":"一个简单的用于配水系统设计的MS Excel软件：一个真实的配水网络设计解决方案","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":"{\"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}","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

摘要

介绍了用MS Excel Visual Basic for Applications (VBA)开发的配水网络设计程序。该工具采用Hardy-Cross算法求解给定的闭环WDN。采用VBA编程和MS Excel的数据验证模块，为工程师提供了易于使用的环境，也用于工程师的教育，而且市场上的软件解决方案价格昂贵，难以获得。还提供了逐步解决乌斯库达尔部分地区的办法，这是伊斯坦布尔网络的一个县。颜色编码的说明更正网络系统将有助于用户。该工具是开源的，工程师和学生可以使用它来设计wdn。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

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

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.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

Journal of Applied Water Engineering and Research WATER RESOURCES-

CiteScore

2.90

自引率

16.70%

发文量

期刊介绍： 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.