水利工程中运输问题的计算机简化解法及探讨 |
| |
作者姓名: | 宿辉 李芳 |
| |
作者单位: | 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 维普 万方数据 等数据库收录! |
|