Water Distribution Network Analysis Using Excel
Publication: Journal of Hydraulic Engineering
Volume 130, Issue 10
Abstract
The analysis of water distribution networks has been and will continue to be a core component of civil engineering water resources curricula. Since its introduction in 1936, the Hardy Cross method has been used in virtually every water resources engineering text to introduce students to network analysis. The technique gained widespread popularity primarily because it is amenable to manual calculation techniques. However, the same subtle elegance that facilitates manual calculations often obscures the primary engineering and physical principles of water distribution systems relative to the nuances of algorithm implementation. Herein, the authors illustrate the application of commonly available spreadsheet software (MicroSoft Excel) to more concisely and effectively solve typical undergraduate network distribution problems using linear theory. Application development is much more efficient and straightforward than the corresponding Hardy Cross implementation enabling students to concentrate upon the engineering system and relevant design issues. The technique presented utilizes commonly available technology and is presented as a supplement to alternatives discussed in recent literature.
Get full access to this article
View all available purchase options and get full access to this article.
References
2.
Gottfried, B.S. ( 2000). Spreadsheet tools for engineers: EXCEL 2000Version, McGraw–Hill, New York.
3.
Hodge, B. K., and Taylor, R. P. (2002). “Piping-system solutions using mathcad.” Comput. Appl. Eng. Educ., 10(2), 59–78.
4.
Huddleston, D. H. (2002). “Spreadsheet tools utilized to introduce computational field simulation concepts to undergraduate engineering students.” Comput. Educ. J., 12(1), 6–11.
5.
Jewell, T. K. (2001). “Teaching hydraulic design using equation solvers.” J. Hydraul. Eng., 127(12), 1013–1021.
6.
Mays, L.W. ( 2001). Water resources engineering, Wiley, New York.
7.
Swamee, P. K., and Jain, A. K. (1976). “Explicit equations for pipe-flow problems”. J. Hydraul. Div., Am. Soc. Civ. Eng., 102(5), 657–664.
8.
Weiss, P. T., and Gulliver, J. S. (2001). “What do students need in hydraulic design projects?” J. Hydraul. Eng., 127(12), 984–991.
9.
Wood, D., and Charles, C. (1972). “Hydraulic network analysis using linear theory,” J. Hydraul. Div., Am. Soc. Civ. Eng., 98(7), 1157–1179.
Information & Authors
Information
Published In
Copyright
Copyright © 2004 ASCE.
History
Published online: Oct 1, 2004
Published in print: Oct 2004
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.