Return to Index
Operations Research Models and Methods
 
excel head


Excel

Subunit Operations Research Models and Methods
  - Excel Solver
 

All models formed through the Math Programming add-in can be solved with the Solver add-in that comes with Excel. The add-in comes free with Excel. More capable versions can be purchased from Frontline Systems.

To use this add-in it must be installed on your computer. If it is installed the item "Solver" is on the Tools menu in versions previous to Excel 2007. Its menu appears on the Analysis tab in versions beginning with Excel 2007.If the Solver does not appear, use the custom installation procedure on the Microsoft Office disk to install it.

Add-in
Add-in Name
File
Solver
solver.xla
This add-in should automatically load when Excel is opened. Its menu is under the Tools menu in versions previous to Excel 2007. Its menu appears on the Analysis tab in versions beginning with Excel 2007.

 

Associated Add-ins - Click the add-in name to transfer to the add-in page.
Add-in Name
File
  
mp_models.xla
 All models created in this add-in can be solved with the Excel solver. For nonlinear programming models the Excel solver is the only method of solution.
Various add-ins
Other add-ins that construct math programming models can use the Solver add-in for solutions.

 

Demonstration Files - Click the demo name to download a .xls file.
Demo Name
Various add-in demos
Any demo that creates and solves math programming models.

 

Instructions - Click page name to transfer to an instruction page.
Page Name
Date
  
 

 
 
gray line
  
Return to Top
tree roots

Operations Research Models and Methods
Internet
by Paul A. Jensen
Copyright 2010 - All rights reserved