Excel软件辅助排水管网设计计算探讨

关于利用 Excel 软件进行排水管道水力计算有关问题的探讨黄明 1、2 侯晓江 3 (1.合肥工业大学 资源与环境工程学院，安徽 合肥 230009；2.安徽建筑工业学院 环境工程系，安徽 合肥 230022 3.合肥学院总务处，安徽 合肥 230022)摘要：排水管道水力计算的理论不复杂，但其计算重复，查表频繁。本文通过建立正确的排水管道水力计算公式，利用 Excel 软件辅助设计，制成了科学的排水管道水力计算表格，并给出了Excel 简洁的计算程序。还对“十五”国家级规划教材《给水排水管网系统》中的两个例题进行了验证，对增加的管径计算公式进行了初步讨论。水力计算结果可以满足排水管道设计要求，免去了查表的烦琐。关键词：Excel 软件；排水管道；水力计算；公式Discussion on applying Excel software to aidding the hydraulic calculation of the drain-pipe HUANG Ming1、2 HOU Xiao-jiang3 (1.School of Resources and Environment Engineering, Hefei University of Technology, Hefei 230009, China；2. Dep. of Environment Engineering, Anhui Institute of Architecture & Industry, Hefei 230022, China)3. Office of General Affairs, Hefei University，Hefei 230022, China)Abstract ： 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. In this paper, the formulae of the corrective hydraulic calculations of the drain-pipe have been established and by Excel software aidding the hydraulic calculation, 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...