A Spreadsheet Teaching Tool For Analysis Of Pipe Networks

QSpace/Manakin Repository

A Spreadsheet Teaching Tool For Analysis Of Pipe Networks

Show full item record


Title: A Spreadsheet Teaching Tool For Analysis Of Pipe Networks
Author: El Bahrawy, Aly N.
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.
URI: http://hdl.handle.net/10576/8017
Date: 1997

Files in this item

Files Size Format View
abstract.pdf 2.197Kb PDF View/Open
abstract.doc 20.5Kb Microsoft Word View/Open
06-97-10-0002-fulltext.pdf 515.6Kb PDF View/Open

This item appears in the following Collection(s)

Show full item record

Search QSpace


Advanced Search

Browse

My Account