Analysis of water distribution networks using MATLAB and Excel spreadsheet: h‐based methods. Issue 1 (January 2017)

• Record Type: Journal Article
• Authors: Niazkar, Majid; Afzali, Seied Hosein
• Is Part Of: Computer applications in engineering education. Volume 25:Issue 1(2017)
• Page Start: 129
• Page End: 141
• Publication Date: 2017-01
• Subjects: water distribution network -- computer application in water network analysis -- h‐based method -- MATLAB -- Excel spreadsheet; Engineering -- Study and teaching (Higher) -- Periodicals; Engineering -- Computer-assisted instruction -- Periodicals; 620
• DOI: 10.1002/cae.21786
• Languages: English
• ISSNs: 1061-3773

Abstract

ABSTRACT: The need for computer application for solving water distribution networks (WDNs) is inevitable for both educational and practical purposes. In this paper, three h‐based methods for solving WDN including h‐based Newton–Raphson method, finite element method, and gradient algorithm are implemented using MATLAB and Excel spreadsheet. The input data should be first inserted into Excel spreadsheet while MATLAB codes utilize this data to solve the pipe network. The output results are also presented in Excel for convenience. As educational facets of this application was the main focus of this paper, the details of this computer application were step‐by‐step explained with codes. Furthermore, a simple network selected from literature was analyzed using the three h‐based methods. Finally, the presented codes and this computer application are believed to encourage many educators and applicants to assess them for both educational and practical purposes in this engineering field. © 2017 Wiley Periodicals, Inc. Comput Appl Eng Educ 25:129–141, 2017; View this article online atwileyonlinelibrary.com/journal/cae ; DOI10.1002/cae.21786