基于Excel建立城市污水管网设计流量计算模型

Establishment of Designed Discharge Computation Model in Municipal Sewage Network Based on Excel

在分析城市污水管网结构的基础上,运用递归计算方法,建立了设计流量计算模型。结合实例,采用Excel附带的编程语言VBA编写递归计算程序,验证了模型的可行性。

Based on analysis of urban sewage system＇s structure, a designed discharge computation model is presented by using recursive algorithm, VBA language which is combined with Excel is used for programming to compute the pipeline designed discharge. The model＇s application in a project demonstrates it is effective.