- All Journals
- Al-Qadisiyah University
- Basrah University
- Kirkuk University
- Mosul University
- The Iraqi Borad for Medical Specialization
- University of Anbar
- University of Technology
- Al Mustafa University
- Al-Zahraa University for Women
- Alnoor University
- Kunooz University
- Misan University
- Ninevah University
- Tikrit University
- University of Al-Hamdaniya
- University of Kerbala
Solving Linear Programming Problems By Using Excel’s Solver | ||
| Tikrit Journal of Pure Science | ||
| Article 1, Volume 14, Issue 2, 2009, Pages 87-98 | ||
| Author | ||
| Salim A. Saleh | ||
| Abstract | ||
| This paper describes advanced methods for finding a verified global optimum and finding all solutions of a system of linear programming, as implemented in the Premium Solver Platform, an extension of the Solver bundled with Microsoft Excel. It also describes the underlying tools that allow Excel spreadsheets to be used over linear data, with fast computation of optimization. Also it provides: a brief overview of Excel’s Add-in Solver; basic theory of optimization as implemented within the Solver; advantages of the Excel Solver in linear programming, and three numerical examples outlining the steps involved in carrying out adjustment of Solver to solve the linear programming problems. The reasons to use of Excel for optimization can be considered a viable option are: (a) Excel is readily available in any Windows platform without any additional cost. (b) Excel is easy to use. (c) The data transfer to and from Excel is very flexible. | ||
| Keywords | ||
| operations research; Linear Programming; Excel Solver; Optimization | ||
|
Statistics Article View: 133 PDF Download: 61 |
||