 |
|
 |
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
|
 |
||
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
8/20/2000
|
Decision Analysis
The add-in creates chance and decision nodes, and evaluates the decision tree to find the optimum policy. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
8/20/2000
|
Teach Integer Programming
Two methods for solving integer programming problems are shown, branch and bound and Gomery cuts. |
|
|
|
8/20/2000
|
Teach Nonlinear Programmming |
|
|
|
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 |
|