A Spreadsheet Teaching Tool For Analysis Of Pipe Networks
Author | El-Bahrawy, Aly Nabih |
Available date | 2009-11-25T13:07:09Z |
Publication Date | 1997 |
Publication Name | Engineering Journal of University of Qatar |
Citation | Engineering Journal of University of Qatar, 1997, Vol. 10, Pages 33-50. |
Abstract | Spreadsheets are used widely in engineering to perform several analysis and design calculations. They are also very attractive as educational tools due to their flexibility and efficiency. This paper demonstrates the use of spreadsheets in teaching the analysis of water pipe networks, which involves the calculation of pipe flows or nodal heads given the network layout, pipe characteristics (diameter, length, and roughness), in addition to external flows. The network performance is better understood if students can change pipe characteristics and/or external flows and be able to monitor the corresponding changes in pipe flows and head losses. The solution of the analysis problem is characterized by the possibility of solving it using different system variables (i.e. flows, head, incremental flows, and incremental heads), resulting in different system of equations, in addition to different methods of solution (i.e. Newton Raphson, linearization, or single adjustment). The developed spreadsheets can be used to introduce the network design concept as a series of analysis problems, performed by trial and error, to satisfy operational constraints. |
Language | en |
Publisher | Qatar University |
Subject | Pipe network analysis Spreadsheets Teaching tool |
Type | Article |
Pagination | 33-50 |
Volume Number | 10 |
Files in this item
This item appears in the following Collection(s)
-
Civil & Architectural Engineering [778 items ]
-
Engineering Journal of Qatar University - [From 1988 TO 2005] [221 items ]