Excel规划求解在决策分析中的应用

Application of Excel Programming Solver in Optimum Decision Aanlysis

介绍了一种求解线性规划和非线性规划的方法.用Excel软件处理规划求解问题,论证Excel在需要大量进行处理数据研究中的实用性.

This paper introduces a method to solve linear programming problem and non-linear programming problem. A few practical examples are given, in which Excel is applied to the solution of programming, thus the practicability of this software in researches is expounded where a great number of data have to be treated.