Tutorial 1
Wednesday, May 12th, 2004
EXCEL SOLVER
:
http://www.solver.com
or
http://www.frontsys.com/
.
Reference: D.Fylstra,L.Lasdon, J.Watson, and A.Warren. Design and Use of the Microsoft Excel
Solver,
INTERFACES
28: 5 September October 1998 (pp. 2955)
LINDO:
A linear and integer programming solver that can be used interactively or called from another
application.
LINDO is a versatile tool for solving linear, integer, and quadratic programming
problems.
http://www.lindo.com
. Downloadable trial version.
LINGO:
Solver and Modelling Language. A set of linear, nonlinear and integer optimizers linked to
a modelling language.
Can be tied to MS access and MS Excel for data retrieval and storage.
http://www.lindo.com
. Downloadable trial version.
GAMS:
The General Algebraic Modeling System (GAMS) is a highlevel modeling system for mathe
matical programming problems. GAMS is tailored for complex, large scale modeling applications.
http://www.gams.com/
. Downloadable student version.
AMPL:
A Modelling Language for Mathematical Programming. Commercial Package for formulating,
solving, and analyzing math programming problems.
http://www.ampl.com/
MPL:
MPL (Mathematical Programming Language) is an advanced modeling system that allows the
model developer to formulate complicated optimization models in a clear, concise, and efficient
way. Models developed in MPL can then be solved with any of the multiple commercial optimizers
available on the market today.
http://www.maximalsoftware.com/mpl/
XpressMP:
XpressMP is a suite of optimization software, used to solve optimization problems.
Used:
as a component by software vendor to embed optimization functionality within their own
products
by consultants to offer optimization solutions to their clients
by business analysts
and other endusers within large organizations to solve their own optimization problems directly.
http://www.dashoptimization.com
MATLAB:
Provides with features for solving linear programming problems.
Using the Excel Solver: Installation Instructions
:
•
Open Excel, click Tools. In the Tools menu, click AddIns
•
If the Solver AddIn is not listed in the AddIns dialog box, click Browse and locate the drive,
folder, and file name for solver.xla, which is the addin program for the Excel solver. Usually
this file is located in the
Library\Solver
folder. (For example, on my computer, it is in the
directory
C:\Program Files\Microsoft Office\Office\Library\Solver
. If you can’t
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Spring '08
 OBEIDI
 Linear Programming, Optimization, modelling language, Solver Parameters window

Click to edit the document details