兵工自动化
兵工自動化
병공자동화
Ordnance Industry Automation
2015年
9期
69-71
,共3页
Excel%火力分配%规划求解%军事运筹
Excel%火力分配%規劃求解%軍事運籌
Excel%화력분배%규화구해%군사운주
Excel%fire distribution%planning solving%military operation
为避免相对复杂的编程，采用 Excel 软件自带的“规划求解”方便地解决炮兵最优任务分配问题。分析射击单位数等于目标数目及射击单位多于目标数目2种情况下炮兵射击任务分配模型的约束条件与目标函数，根据具体的算例讨论用Excel程序中“规划求解”解决炮兵射击任务最优分配方案的具体步骤。算例结果表明：Excel规划求解确定射击任务最优分配方案的方法操作简单，便于掌握，适合非编程人员使用。
為避免相對複雜的編程，採用 Excel 軟件自帶的“規劃求解”方便地解決砲兵最優任務分配問題。分析射擊單位數等于目標數目及射擊單位多于目標數目2種情況下砲兵射擊任務分配模型的約束條件與目標函數，根據具體的算例討論用Excel程序中“規劃求解”解決砲兵射擊任務最優分配方案的具體步驟。算例結果錶明：Excel規劃求解確定射擊任務最優分配方案的方法操作簡單，便于掌握，適閤非編程人員使用。
위피면상대복잡적편정，채용 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 ofartillery 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 solveartillery 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.
