Main Index Computation Index
Operations Research Models and Methods / Computation

Unit Using Add-ins

Version of Excel

To use the programs in this package, you must have access to a Macintosh or IBM compatible computer with the Microsoft Excel program installed. For the Windows operating system, the version of Excel must be 97 or later. For the Macintosh operating system the version must be 98 or later. The Solver Add-in that comes with Excel should also be installed to solve deterministic optimization problems.

Installing Add-ins

The Add-ins files may be placed anywhere on the hard disk or even on a floppy disk. One procedure is to create a directory (or folder) entitled "jensen.lib" and place it in the directory called "Macro Library" created by the Microsoft installation program. The Macro Library directory is in the Microsoft Excel directory. The add-in files are then placed in the "jensen.lib" directory.

To use an Add-in first open the Excel program. Choose the "Add-Ins" command from the Tools menu. A dialog box showing the current list of Add-ins appears as in the figure below. Add-ins are identified by name. A check in the box next to the name means that the add-in is installed, while an unchecked box means that it is not installed.

When any one of the add-ins are installed a new menu item, OR_MM, is added to the Worksheet menu. TheOR_MM menu lists references to Visual Basic programs provided by the add-in. Selecting any one of these produces a dialog box that accepts additional information required by the program.

In addition to the programs reached through the menu, an add-in may provide new functions that are found as User Defined functions in the Excel function list. These functions are used just like the normal built in functions of Excel.

An more convenient alternative to installing the add-ins in this package through the tools menu is to use the OR_MM Control add-in.

Add-in Names

The names of the OR/MS Add-ins with their associated file names are in the list below. The right column of the table shows the names used to represent the files in the Add-in List. If a name does not appear, use the Browse command to locate the associated file name listed on the left. The add-in is installed by clicking on the check box adjacent to the name. Remember that add-ins consume part of the memory allotted to Excel. Add-in also increase the time required for Excel to launch. If you experience trouble, a possible remedy is to decrease the number of add-ins installed.

 File Name

 Name in Add-in List


 OR/MM Control




 Math Programming Models


 LP/IP Solver


 Network Solver


 Random Variables

Stochastic Models


 Markov Chain


 Markov Process




 Decision Analysis

Teach LP
Teach Network
Teach Transportation
Teach IP
Teach NLP
Process Flow Analysis
Materials Requirements Planning
Facility Layout


OR_MM Controller

The easiest way to add and delete add-ins is with the OR_MM Control add-in. Once this is installed, the item "OR_MM" appears on the main menu of Excel. Selecting this item shows a dialog showing all the add-ins except the manufacturing add-ins (the last three on the list). Listed add-ins can be installed and removed by simply clicking a checkbox. See the instructions for this add-in.

Main Index Computation Index

Operations Research Models and Methods
by Paul A. Jensen and Jon Bard, University of Texas, Copyright by the Authors