Return to Index
Operations Research Models and Methods

Excel Add-ins



Teach OR



Teach OR Excel Add-ins

These are Excel add-in files (.xla) of the Teach OR collection. They are compressed and stored with the (.zip) suffix. Download by clicking on the file name of the add-in in the left most column.

In late June 0f 2007, I revised the add-ins to work with Excel 2007 for Windows. These add-ins are dated on and after June 27, 2007. The navigation is quite different in Excel 2007. Where many of the instructions include screen shots of menu bars, these bars are no longer part of Excel 2007. Read the changes necessary on the Excel 2007 page.

Excel 2008 does not support VBA and the add-ins will not work with Excel 2008.

The add-ins will load in Excel 2010 for Windows 7. I expect them to operate correctly. Let me know about any problems.

As the add-ins are improved and corrected, we update the versions on the web. The Date Modified entries below show the dates of the latest revisions. Click the Revisions link on the left to see the purpose of each revision. If you replace an add-in with a newer version, be sure to delete or change the name of the old version. Otherwise, Excel may link to the old version rather than the new.

Links are provided to the instructions for each add-in. Click on the add-in name or the leaf on the right to reach the instructions. Add-ins are not used like regular Excel workbook files. They must be installed through the add-in dialog on the tools menu or through the Add Teach add-in. Review the General Instructions for loading add-ins.

File Name
Date Modified
Add-in Name



Add Teach Add-in
When called, this add-in lists all the Teach OR add-ins that are in the same directory as the Add Teach add-in. Add-ins are installed and removed with a simple click of a button. The add-in also loads demonstration files that illustrate the add-ins. To use this feature these files must be stored in a the same directory as the add-ins. See the instructions for details.

Teach Linear Programming
The add-in teaches three solution algorithms for linear programming, the Tableau Simplex method, the Revised Simplex method and the Interior Point method.

Teach Transportation
This add-in is concerned with solving the Transportation problem with the primal simplex method. The program works on problems with up to 10 suppliers or demanders.

Teach Network
This add-in considers the primal simplex method for network flow programming problems. Included are algorithms for the pure and the generalized minimum cost flow problems.

Teach Integer Programming
Three methods for solving integer programming problems are shown: branch and bound, Gomory cuts and Benders' Algorithm.


Teach Nonlinear Programming
This add-in demonstrates procedures used to solve unconstrained nonlinear programming problems. Two procedures are available, gradient search and conjugate gradient search. The convexity of the objective function at specified points is determined.

Teach Dynamic Programming
The add-in provides a structure for the various model components for dynamic programming. The student provides the various components using Excel functions. The optimization algorithms use recursion and reaching to find optimum solutions.


Jensen Library
Download the archive from the ORMM add-in page.



Return to Top

tree roots

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