利用Excel软件进行排水管道水力计算

在市政建设和城市环境治理工程中,排水管道系统占较大的投资比例,因此,合理设计排水管理系统,可以减少工程投资和利于城市排水.排水管水力计算的理论不复杂,但其计算重复,查表频繁.通过建立正确的排水管道水力计算公式,利用Excel软件辅助设计,制成了科学的排水管道水力计算表格,并给出了Excel简洁的计算程序。对“十五”国家级规划教材《给水排水管网系统》中的两个例题进行了验证,对增加的管径计算公式进行了初步讨论，水力计算结果可以满足水管道设计要求,免去了查表的烦琐。

Discussion on applying Excel software to aidding the hydraulic calculation of the drain-pipe

The investment proportion of drain-pipe system is very high in the municipal engineering and the environmental disposal for a city. Therefore, if the design of the drain-pipe system is rational, the engineering investment can be increase and the drain for a city is advantageous. The theory of the hydraulic calculation of the drain-pipe is not complicate, but the design calculation is repeated constantly and the various tables are looked up frequently. The formulae of the corrective hydraulic calculations of the drain-pipe have been established by Excel software aidding the hydraulic calculation, and the scientific calculation tables of the hydraulic of the drain-pipe have been completed. The shortcut programs of the calculation are also given. The two examples of the textbook in water & wastewater pipe network for 15th Country Grade's Plan are verified and the calculation formulae of the pipe-diameter increased are discussed preliminarily. The results of hydraulic calculation can satisfy the needs of the hydraulic calculation in the drain-pipe, and also relieves of the tedious of the tables looked up.