| 水利工程中运输问题的计算机简化解法及探讨 |
| |
| 作者姓名： | 宿辉 李芳 |
| |
| 作者单位： | 1. 河北工程学院,河北,邯郸,056021
2. 邯郸市漳滏河灌溉管理处,河北,邯郸,056021 |
| |
| 摘 要： | 水利工程中需要调配大量的物资,要得到最优的物资运输方案,需进行复杂的线性规划计算,多次迭代,往往耗费大量的时间,通过对“线性规划”数学模型的分析,详细说明了如何利用Excel软件的规划求解功能来解决运输问题及其他相关的数学规划问题。
|
| 关 键 词： | 线性规划 运输问题 数学模型 Excel |
| 文章编号： | 1672-1683(2004)06-0055-03 |
| 修稿时间： | 2004年3月26日 |
Inquiry on Simplification Solution of Computer for Transportation Problems in Hydraulic Engineering |
| |
| Authors: | SU Hui LI Fang |
| |
| Abstract: | It is necessary to allocate a large quantity of materials in hydraulic engineering. To obtain tne optimized plan of material transportation it must carry on complex linear programming and repeating iterativeness, which usually wastes a lot of time. This paper based on analyses of the mathematical model of linear programming, and elaborates how to make use of the programming solution's function possessed by the software " Excel" to resolve the transportation problem and other related mathematical programming problem. |
| |
| Keywords: | linear programming transportation problem mathematical model Excel |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
