| 用Excel规划求解报亭选址问题 |
| |
| 引用本文： | 胡朝晖,张革伕.用Excel规划求解报亭选址问题[J].商品储运与养护,2011(1). |
| |
| 作者姓名： | 胡朝晖 张革伕 |
| |
| 作者单位： | 南华大学船山学院;南华大学经济管理学院; |
| |
| 摘 要： | 报亭的选址问题是一类目标优化问题,从采用精确重心方法来求解的数学模型来看,此目标问题是一个迭代型规划问题,不能直接用常规的Excel规划方法来求解。文中通过引入过渡变量来逐步进行迭代求解。在每一步通过比较前后2对坐标之间的误差,在有限的时间与迭代次数内,求解到了地址目标。求解结果与手工计算的相吻合。
|
| 关 键 词： | 规划求解 Excel 迭代模型 选址问题 |
The Application of Excel Programming Solver to Newspaper-Kiosk Location |
| |
| HU Zhao-hui,ZHANG Ge-fu.The Application of Excel Programming Solver to Newspaper-Kiosk Location[J].Storage Transportation & Preservation of Commodities,2011(1). |
| |
| Authors: | HU Zhao-hui ZHANG Ge-fu |
| |
| Institution: | HU Zhao-hui1,ZHANG Ge-fu2(1.Chuanshan College of Nanhua University,Hengyang,Hunan 421001,2.Economic and Management School of Nanhua University,China) |
| |
| Abstract: | Newspaper-Kiosk location is a kind of object optimization problem.From the view of mathematical modeling in the form of exact gravity to resolve,this problem is a kind of iterative programming problem.It can not be resolved by normal Excel programming approach directly.This paper resolved this problem,step by step,by introducing 2 transitional variables.The location value of the location was obtained through comparing 2 couple of coordinates per step,within limited time and limited iterative times.The resul... |
| |
| Keywords: | programming solver Excel iterative model location problem |
| 本文献已被 CNKI 等数据库收录！ |
|
