Excel的规划求解及其在最优化问题中的应用

On the Programming Solution of Excel and Its Application in Optimization Problem

最优化问题常用Lingo、Mathematica和MATLAB等专业软件求解,运用时需要一定的计算机基础.事实上,常用办公软件Excel也具备求解最优化问题的能力.文章通过实例,探索利用Excel规划求解工具求解最优化问题的方法和步骤.结果表明,利用Excel中规划求解工具可方便、快捷地求解最优化问题.

Optimization problem solving often use the professional software of Lingo,Mathematica and MATLAB,which needs a cer-tain basis in its application. In fact,the commonly used office software Excel also has the ability to calculate optimization problem.This pa-per explores the methods and steps with Excel programming solver tool to solve the optimization problem by real example. The result showsthat using Excel programming solver tool can solve the optimization problem conveniently and quickly.