Excel用于排水管网的设计及优化

采用以Excel为数据库的编程方法对排水管网进行了优化设计。Excel可与其他应用软件实现资源共享，支持VBasic编程，便于排水管网优化设计计算。对污水管道采用两相优化理论设计，对雨水管道采用与地面坡度一致法进行优化计算。将污水、雨水、合流制管网及混合管网统一为排水管网，用一套程序同时完成各种体制的排水管网的优化设计计算。

Design and Optimization of Excel Used for Drainage Network

The programming method of taking Excel as database was used to optimize design for drainage network. Resources sharing can be realized between Excel and other application softwares, and the Vbasic programming is supported, so it is convenient for optimization design calculation of the drainage network. The two-phase optimization theory was adopted for designing the sewage pipe, and the ground slope consensus method was used for optimization calculation of rain water pipe. The sewage pipe, rain water pipe, combined system and mixing system are integrated as a drainage network, and one set of procedures can complete the optimization design calculation for drainage network with different systems.