【摘要】 水泵与管网联合工作的工况点确定是比较复杂的计算过程。而利用Excel中的规划求解法的基本功能,可快速准确地解决水泵向不同水位水塔供水时的工况点的问题。首先用抛物线方程H=A1+B1Q+C1Q2表示泵流量与扬程曲线,将分支管前的水头损失从相应水泵的扬程中扣除,得到相应的方程;根据能量平衡原理,分别列出向不同水位水塔供水的需要扬程方程。利用Excel中的规划求解功能,可方便、快速求解得到水泵与管网联合工作的工况点,同时得到向各水塔供水的流量。更多还原

【Abstract】 The determination of water pump and pipeline network under the joint work is a more complicated calculation process. Using the basic function of programming solver in Excel,the working point of water pump supplying water for different water level tower was solved rapidly and accurately. Firstly,the equation H = A1+ B1Q + C1Q2was used to express the curve of flow-lift of water pump,head loss before branch pipes was deducted from corresponding pump,and the corresponding equation was obtained. According to the energy balance principle,the equation of water supply for different water level tower was listed. Use of programming solver function in Excel could conveniently and quickly get the working condition of water pump and pipeline network joint work,and water supply flow for each tower was obtained.更多还原