Excel在排放口最优规划中的应用

Application of Excel in Optimum Planning of Discharge Ports

鉴于电子表格软件Excel提供的“规划求解”(Solver)加载宏可以求解线性、非线性以及混合整数规划等单目标优化的问题的特点,文章开发了排放口最优规划问题求解的应用程序(DPOPMS)。程序包括了多河段BOD-DO耦合矩阵模型的计算、电子表格模型的自动创建、调用“规划求解”加载宏进行规划求解以及规划求解结果的输出等主要功能模块,并将程序应用于汾河太原城区段的污染控制规划,所得的规划结果与实际情况较为吻合。运用该程序进行排放口最优规划,避免了复杂的模型求解过程的算法程序编制,实现较为方便。

Based on Solver macro provided by Microsoft Excel,a program of discharge port optimization planning(DPOPMS) was developed including several major parts as multi-river BOD-DO coupling matrix model,automatically creating of Spreadsheets model,optimization planning of discharge ports by invoking Excel Solver and result display.The program was used for pollution control plan of Taiyuan urban section of Fen River,with results in accordance with the actual fact.