基于Excel规划求解的泵站加压灌溉管网优化设计研究

Optimal Design of Pressure Irrigation Pipe Network for Pumping Station Based on Excel Programming

以管网系统年费用最小为目标函数,水泵扬程H和连续管径D为设计变量,建立了确定性的泵站加压灌溉管网优化设计模型,并应用Excel规划求解法对所建立的模型进行了求解。实例表明,在管网布置形式已知的情况下,与传统的经济流速法相比,Excel规划求解法是一种实用价值较高的模型求解方法,该方法不仅能够节省一定的工程投资,还提高了设计人员的设计水平和效率。

Taking the minimum annual cost of pipeline system as the objective function,the pump lift H and continuous pipe diameter D as design variables,a definitive design optimization model of pressurized irrigation pipe network for pumping stations is established and solved by Excel planning and solving method.The example shows that,compared with the traditional economic flow rate method,Excel planning and solving method is a practical and highly-valuable solution when the pipe network layout is known.It can not only save a lot of engineering investments but also increase designer's design level and efficiency.