Research on Water Supply Pipe Network Topology Constriction

EPANET, a network modeling software, is widely used in water pipe network design, operation and management. However, due to lack of pipe diameter property when importing from CAD network topology, the pipe network modeling efficiency has been restricted. The EXCEL VBA function is known as being easy to learn. A program of automatic assignment procedure for pipe diameter of the water network based on VBA is given in the present work. It is easy to understand and greatly enhances the efficiency of network modeling. The EPANET INP file is used to be a data processing carrier. It makes use of VBA functions for data search and calculation and improves software coupled to solve practical engineering problems. It helps to develop and progress the water pipe network model through design, operation and management.