Excel规划求解在炮兵射击任务最优分配中的应用  

Application of Excel Programming for Optimal Task Assignment of Artillery Fire

作　　者：王兆胜[1] 

机构地区：[1]南京炮兵学院自行火炮系,南京211132

出　　处：《兵工自动化》2015年第9期69-71,共3页Ordnance Industry Automation

摘　　要：为避免相对复杂的编程,采用Excel软件自带的"规划求解"方便地解决炮兵最优任务分配问题。分析射击单位数等于目标数目及射击单位多于目标数目2种情况下炮兵射击任务分配模型的约束条件与目标函数,根据具体的算例讨论用Excel程序中"规划求解"解决炮兵射击任务最优分配方案的具体步骤。算例结果表明:Excel规划求解确定射击任务最优分配方案的方法操作简单,便于掌握,适合非编程人员使用。In order to avoid complicated programming, it is convenient to solve the artillery optimal task assignment problem by using the Excel built-in ＂planning solving＂. Constraint condition and objective function of model of artillery fire task assignment are analyzed in 2 cases of fire units are equal targets and fire units is more than targets, specific steps with the ＂planning solving＂ of Excel program to solve artillery optimal task assignment is discussed in details, examples shown that operation is simple to determine optimal task assignment with the planning solving of Excel program, is convenient to master, and is suitable for non professional programmers.

关 键 词：EXCEL 火力分配 规划求解 军事运筹 

分 类 号：TJ303[兵器科学与技术—火炮、自动武器与弹药工程]