【摘要】 Excel规划求解环状给水管网平差,以管段流量为变量,各环闭合差的绝对值之和取得最小值为目标函数进行规划求解,通过设置节点连续性方程为约束条件,节点流量无需手工计算而自动平衡.采用Excel的公式与函数成批运算,便于选择管径取得经济流速,是一种环状给水管网优化设计和水力计算的新方法.同等环状给水管网的算例计算表明,与Hardy.Cross法相比,规划求解法过程简单快捷,求解精度高,4个环闭合差的绝对值之和为2.64×10-5(kPa)更多还原

【Abstract】 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.更多还原