These are Excel add-in files (.xla). They are compressed and stored at this site with the (.zip) suffix. Download by clicking on the add-in name. The files may be expanded with the free Aladdin Expander.

Links are provided to the instructions for each add-in. 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-in_Control. Review the General Instructions for loading add-ins.

 

File Name
Date Modified
Add-in Name
Instructions
   
General Instructions for Add-ins
or_ms.xla

8/20/2000


Add-in Control
This add-in allows the user to install and remove add-ins without using the Add-in command of the Tools menu.
mprog.xla
8/22/2000

Math Programming
The Mathematical Programming Add-in constructs linear programming, integer programming, nonlinear programming, network and transportation models that can be solved using the Excel Solver Add-in or one of the solution add-ins provided in this collection.
lpsolver.xla
8/20/2000

Linear Programming Solver
This add-in provides an algorithm that solves Linear Programming problems. It can be used instead of the Excel solver for the Linear Programming models created by the Mathematical Programming add-in.
netsolve.xla
10/24/2000

Network Flow Solver
A network solution algorithm is provided by this add-in. Network algorithms are generally faster than linear programming algorithms for solving problems that can be modeled entirely as networks.
ran_var.xla
8/20/2000

Random Variables
The Random Variables Add-in performs computations associated with probability distributions. Random variables with any of 16 different named distributions may be defined. Functions compute probabilities of events, inverse probabilities and moments. Complex probability problems may be solved through simulation.
marchain.xla
8/20/2000

Markov Chain
The Markov Chain Add-in performs a wide range of computations associated with Markov Chains including: economic analysis, steady state analysis, computation of n-step probabilities, simulation, computation of first passage probabilities and computation of absorbing state probabilities.
marproc.xla
8/20/2000

Markov Process
The Markov Process Add-in performs computations for continuous time Markov Processes. The add-in constructs the embedded Markov chain matrix, computes the steady state probabilities for states, performs economic analyses and performs dynamic simulations.
queue.xla
8/20/2000

Queueing
The Queueing Add-in performs calculations associated with Poisson queueing models and allows simple simulations of models not using the Poisson assumption for arrival and service activities.
dec_anal.xla
8/20/2000

Decision Analysis
The add-in creates chance and decision nodes, and evaluates the decision tree to find the optimum policy.
teachlp.xla
8/20/2000

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.
teachtr.xla
8/20/2000

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 demands.
teachnet.xla
8/20/2000

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.
teachip.xla
8/20/2000

Teach Integer Programming
Two methods for solving integer programming problems are shown, branch and bound and Gomery cuts.
teachnl.xla
8/20/2000

Teach Nonlinear Programmming
This add-in demonstrates procedures used to solve unconstrained nonlinear programming problems. Two procedures are available, gradient search and conjugate gradient search.

teachdp.xla
8/20/2000

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.
   

Link to the original OR Add-ins site
The original site includes links to manufacturing system add-ins for Process Flow Analysis, Facility Layout and Materials Requirements Planning.

 

Return to Contents Page