MSci603__LP modeling F08

MSci603__LP modeling F08 - University of Waterloo Faculty...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Tutorial 1 Wednesday, May 12th, 2004 EXCEL SOLVER : or . 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. . 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. . Downloadable trial version. GAMS: The General Algebraic Modeling System (GAMS) is a high-level modeling system for mathe- matical programming problems. GAMS is tailored for complex, large scale modeling applications. . Downloadable student version. AMPL: A Modelling Language for Mathematical Programming. Commercial Package for formulating, solving, and analyzing math programming problems. 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. Xpress-MP: Xpress-MP 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 end-users within large organizations to solve their own optimization problems directly. MATLAB: Provides with features for solving linear programming problems. Using the Excel Solver: Installation Instructions : Open Excel, click Tools. In the Tools menu, click Add-Ins If the Solver Add-In is not listed in the Add-Ins dialog box, click Browse and locate the drive, folder, and ±le name for solver.xla, which is the add-in program for the Excel solver. Usually this ±le 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 ±nd the ±le, you can download it from the course website: (right click on these links and then click on ”Save Link As” to download these ±les to the above directory).
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/01/2008 for the course MSCI 603 taught by Professor Obeidi during the Spring '08 term at Waterloo.

Page1 / 9

MSci603__LP modeling F08 - University of Waterloo Faculty...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online