Return to Index
Operations Research Models and Methods
Computation Section
Using Add-ins

Unit 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. The original add-ins were programmed in Visual Basic for Applications (VBA) for Excel 97 and the Windows OS, and for Excel 98 and the Mac OS. As different versions of Microsoft Office and VBA become available, I attempt to update the add-ins to work with the new versions of VBA. I try to use features of VBA that are common to the early version of VBA and work on both Windows and Mac machines. As far as I know, the add-ins work for most versions since 1997, but once I adopt the later version for my computer, I do not test the add-ins extensively on the old ones. The add-ins have been tried in Excel 2007 and 2010 for Windows. The latest version of Excel for Macs is Excel 2004. The add-ins are the same for Windows and Mac OS.

If you have trouble with an add-in with an early Excel, you may be able to debug it with the VBA editor.

The Solver Add-in that comes with Excel should also be installed to solve deterministic optimization problems.

Unit Installing Add-ins

The Add-ins files may be placed anywhere on your hard disk. One procedure is to create a directory (or folder) entitled "jensen.lib" and place it in the directory called "Add-ins" created by the Microsoft installation program. The add-in files are then placed in the "jensen.lib" directory. Alternatively, the add-in files may placed in any directory on the hard disk. It is important to put all the add-ins in the same directory.

When you download a new version of an add-in or the entire library, it is important that you replace the old files with the new ones. Leaving two copies of the add-ins on your computer will generally cause confusion regarding the add-in that is loaded by Excel.

To use an Add-in first open the Excel program. Choose the "Add-Ins" command from the Tools menu. (For Excel 2007 and 2010 a different method is used. See below) 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. If an add-in that you want does not appear in the list use the Select... or Browse... button to move to the directory in which the ORMM add-ins are stored. The most convenient way to use the ORMM add-ins is to first install the Add ORMM add-in. All the others can be installed from the dialog box of the Add ORMM add-in.

When any one of the ORMM add-ins are installed a new menu item, OR_MM, is added to the Worksheet menu. The OR_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 listed as User Defined Functions in the Excel function list. These functions are used just like the normal built in functions of Excel.

Unit Add-in Names

The names of the 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-ins 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.

ORMM Add-ins

 File Name

 Name in Add-in List




 Math Programming Models


 LP/IP Solver


 Network Solver

DP Data
DP Models
DP Solver


 Random Variables


 Stochastic Analysis




 Decision Analysis


Teach OR Add-ins

 File Name

 Name in Add-in List


 Add Teach OR

Teach LP
Teach Network
Teach Transportation
Teach IP
Teach NLP
Teach DP

OM/IE Add-ins

 File Name

 Name in Add-in List



Capital Budgeting
Project Management
Process Flow
MRP (Materials Requirement Planning)
Facility Layout
Opt. Sequencing
DEA Data


The easiest way to add and delete add-ins is with the Add ORMM add-in. Once this is installed, the item "OR_MM" appears on the main menu of Excel. Selecting the Add ORMM item produces a dialog showing all the add-ins. Listed add-ins can be installed and removed by simply clicking a checkbox. See the instructions for this add-in. Excel 2007 has a different location for add-in menus. See the article in this section.

Similar control add-ins are provided for the Teach OR and the OM/IE collections.


Return to Top

tree roots

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

Next Page