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

 add_ormm.xla

 OR/MM Control

 demo.xla

 Demonstrations

 mp_models.xla

 Math Programming Models

lpip_solver.xla

 LP/IP Solver

 net_solver.xla

 Network Solver

 ran_var.xla

 Random Variables

stochmod.xla
Stochastic Models

 marchain.xla

 Markov Chain

 marproc.xla

 Markov Process

 queue.xla

 Queues

 decanal.xla

 Decision Analysis

teachlp.xla
Teach LP
teachnet.xla
Teach Network
teachtr.xla
Teach Transportation
teachip.xla
Teach IP
teachnl.xla
Teach NLP
teachdp.xla
TeachDP
process.xla
Process Flow Analysis
mrp.xla
Materials Requirements Planning
layout.xla
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