UTILIZING EXCEL SOLVER FOR COMPLEX PIPE NETWORK ANALYSIS AND DEVELOPMENT OF AN EDUCATIONAL TOOL

Abstract

ABSTRACT

This study aims to enhance the analysis methodology for complex pipe networks. An approach was proposed involving the formulation of continuity and head loss equations adapted through the application of both Excel Solver and the Hardy Cross methods. Furthermore, using Solver add-in with the aid of Visual Basic for Application (VBA) helped to extend the study beyond theoretical analysis where an educational tool has been developed, thereby providing a practical resource for further exploration and understanding of such analyzing methods. As the optimization has been conducted and the flow rates values determined, it was observed that there is a significant reduction in the time required for iterative approach while the calculation accuracy was not affected. On the other hand, the developed educational tool has easily and effectively explored the analyzing of simple and complicated piping systems.