Excel规划求解的环状给水管网平差  

Adjustment calculation on looped pipe network of water supply with Excel solver

作　　者：彭永丽[1] 蔡建安[2] 汪明明[2] 

机构地区：[1]安徽工业大学工商学院,安徽马鞍山243002 [2]安徽工业大学建筑工程学院,安徽马鞍山243002

出　　处：《南昌工程学院学报》2013年第3期68-72,共5页Journal of Nanchang Institute of Technology

基　　金：国家自然科学基金资助项目(51208001)

摘　　要：Excel规划求解环状给水管网平差,以管段流量为变量,各环闭合差的绝对值之和取得最小值为目标函数进行规划求解,通过设置节点连续性方程为约束条件,节点流量无需手工计算而自动平衡.采用Excel的公式与函数成批运算,便于选择管径取得经济流速,是一种环状给水管网优化设计和水力计算的新方法.同等环状给水管网的算例计算表明,与Hardy.Cross法相比,规划求解法过程简单快捷,求解精度高,4个环闭合差的绝对值之和为2.64×10-5(kPa)With the pipe flow as variable quantity,the minimum of the loop disclosure as the objective function and the node continuity equation as the constraint condition,the Excel solver is used to conduct adjustment calculation of pipe network of water supply without manual computation.The solver,in which the Excel formulas and functions are used in batches,is a new and easy way to select pipe diameter for adjustment calculation on pipe network of water supply.The comparison of examples with the same pipe network shows that the absolute value of disclosure of the four loops only totals 0.0000064（mH2O）,which confirms the easy operation and high accuracy of the solver compared with Hardy Cross method.

关 键 词：给水管网 管网平差 Hardy·Cross法 规划求解 

分 类 号：TU991.32[建筑科学—市政工程]