Economics and Statistical Evaluations of Using Microsoft Excel Solver in Pipe Network Analysis
| Autor: | Abubakar Ismail, I. A. Oke, O. O. Adeosun, Salihu Lukman, S. O. Ojo, M. O. Nwude |
|---|---|
| Rok vydání: | 2016 |
| Předmět: |
Mathematical optimization
Coefficient of determination Correlation coefficient Computer science Mechanical Engineering Numerical analysis 05 social sciences 050301 education 010501 environmental sciences Solver 01 natural sciences Pipe network analysis Hydraulic head Applied mathematics Hardy Cross method Node (circuits) 0503 education 0105 earth and related environmental sciences Civil and Structural Engineering |
| Zdroj: | Journal of Pipeline Systems Engineering and Practice. 7 |
| ISSN: | 1949-1204 1949-1190 |
| Popis: | As a follow up to previous studies on numerical analysis of engineering systems, this paper utilizes Microsoft Excel Solver in solving pipe network analysis problems. Continuity and head loss equations were developed from three different pipe networks. Flow and head loss in the pipes were determined using Microsoft Excel Solver and Hardy Cross (standard) methods. These flows and head loss in the pipse were evaluated economically using operational cost and statistically [coefficient of determination (CD), total error, model of selection criterion (MSC), average error, and correlation coefficient (R)]. The study revealed that flow in pipes is a function of the method, withdrawal at the node, and length and diameter of the pipe. Statistical evaluation revealed that CD, total error, MSC, root error, and R were 0.041; 4.55; 0.041; 2.13; and 0.2025; and 1.0000; 2.25×10−4; 29.647; 1.60×10−7; and 1.000 for Microsoft Excel Solver and Hardy Cross methods, respectively. Economic evaluations showed that cost ... |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|