基于Excel的数学模型求解

摘要

Excel不仅是一款优秀的办公自动化软件,而且在数学模型求解方面具有专业数学软件不可比拟的优势,它既可以用于线性规划模型的采解,也可以用于图论、动态规划和某些非线性规划模型的求解.通过三个实例,以图表的方式列举了Excel在层次分析法、最大流问题和动态规划模型求解中的具体操作.%Excel is not only a good office automation software, and has the advantage in solving the mathematical model. It can be used either for linear programming model, also can be used in graph theory and dynamic planning and some nonlinear programming model. In this paper, three examples are enumerated the Excel chart in analytic hierarchy process, the maximum flow problem and the dynamic programming model of the specific operation.