An MS Excel tool for teaching hydraulic analysis of water distribution networks (WDNs) was developed. The tool is able to perform both steady‐state and extended period simulations of a WDN. The tool does not require installation and offers a portable solution to WDN design problem in undergraduate environmental engineering studies.

No abstract

No abstract

No abstract

This paper presents implementation of an MS Excel add‐in incorporating Visual Basic for Applications for teaching pipe flow calculations in undergraduate and graduate level. The add‐in contains a total of 108 functions for several purposes ranging from continuity equation to branching pipes and pipe network problems. Tip texts and a number of userforms were developed for easy use of the tool. A user's guide was also prepared that includes the theory of hydraulic calculations and numerical methods involved. Being an add‐in for MS Excel, the tool is a perfect candidate for implementing as an educational tool in undergraduate and graduate level education.