应用VBA编制农村集中供水管网计算程序的研究

The Study on the Calculation Program of the Rural Centralized Water Supply Pipe Networks Compiled with VBA

从农村集中供水管网的水力计算出发,通过对主要计算过程的描述,将整个计算过程分成了6个子过程,即用户用水分析、节点信息统计、管段信息统计、材料统计、节点流量推求压力、节点压力推求流量,然后利用VBA分别实现了各部分程序的自动计算。

Starting from the hydraulic calculation of the rural centralized water supply pipe networks, and based on the description of the main computational processes, this paper divides the whole computational process into six parts, including the analysis on users＇ water consumption, the statistics of node information, the statistics of pipeline information, the statistics of materials, the calculation of pressure from the node flow, the calculation of the flow from the node pressure, and realizes the automatic calculation of the program of each part by using VBA （Visual Basic for Application ）.