Excel规划求解在多水源管网计算中的应用

Application of Excel solver in multiple water pipe network calculation

基于哈代—克罗斯法算法原理,将管网结构参数登录在Excel平台上进行规划求解,由此得到管段流量、水头损失及各节点水压等参数。此法收敛精度高,简单易操作,迭代速度快,为管网的优化运行、调度以及改扩建提供了科学依据。

With the Hardy-Cross algorithm principle,we type the network structure parameters on the Ex-cel platform,from which we obtain such parameters as section flow,head loss and the node pressure. This method has such strength as high convergence accuracy,easy operation and fast iteration speed,which provides scientific basis for pipe network optimization,running and expansion.