These are Excel add-in files (.xla) of the ORMM 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.
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.
The add-ins on this page are from the ORMM collection. Click
the icons on the left to view a similar page for the Teach
OR, OM/IE and Template collections. All the collections and
the Demo files are included in the archive. The links to the
archive are at the bottom of this page.
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 Add
ORMM. Review the General
Instructions for loading add-ins.
| File Name |
Date Modified |
Add-in Name |
Instructions |
|
| |
|
|
|
|
| |
6/20/08 |
Add
ORMM
When called, this add-in lists all the ORMM
add-ins that are in the same directory as the Add
ORMM 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.
|
|
|
| |
6/25/08 |
Demonstration
This add-in provides demonstrations of the other add-ins
in the package, excluding the Teaching add-ins. To run
a demonstration, both the Demonstration add-in and the
subject add-in must be installed.
|
|
|
Optimization
Add-ins
|
|
|
Math
Programming Models
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.
|
|
| |
6/20/08 |
LP/IP
Solver
This add-in provides algorithms to solve Linear and
Integer Programming problems. It can be used instead
of the Excel solver for the linear models created by
the Mathematical Programming add-in. The mp_models add-in
must be installed to use this add-in.
|
|
|
| |
7/3/07 |
Network
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. The problem solves
generalized networks and can handle models with integer
restrictions. The mp_models add-in must be installed
to use this add-in.
|
|
|
|
11/10/08 |
Dynamic
Programming Data
This add-in builds
constructs data forms for specific problem
classes of dynamic programming. Both
deterministic and stochastic models are
provided. The DP Data
add-in calls the DP Models add-in to generate
models. This
add-in replaces the earlier Markov Data
add-in.
|
|
|
|
11/18/08 |
Dynamic
Programming
Models
This add-in builds models
for deterministic and stochastic dynamic programming,
Discrete Time and continuous Markov processes,
and also Markov Decision Process Models. The
models are symbolic in that formulas are entered
for transitions, transition rates, transition
probabilities and other relevant components
of a stochastic process model. The models constructed
are analyzed using the DP Solver add-in or
the Markov Analysis add-in. This
add-in replaces the earlier Markov Models
add-in.
|
|
|
|
11/18/08 |
Dynamic
Programming Solver
This program creates a form for holding the data describing
a deterministic or stochastic programming dynamic programming
problem. The program has several methods for finding
the optimum policy. The add-in accepts models created
by the DP Models add-in. The add-in can also build
forms for direct entry of the DP data. This
add-in replaces the earlier Markov Decision
Process add-in.
|
|
|
|
2/2/08 |
Optimize
Many Excel worksheet models depend on a few design variables.
Through formulas, the worksheet contents vary with the values
of the design variables and the modeler uses the worksheet
as a "what if" tool. It is often the goal to find
the best values. This add-in provides combinatorial algorithms
that search for the best values. In addition to stand-alone
forms for general use, the add-in performs combinatorial
search for math. programming models, the traveling salesman
problem, permutations, spanning trees, shortest path trees
and flow trees. The add-in has an option that provides multiple
starting points for nonlinear programming models. Some of
the ideas associated by global optimization are implemented.
The add-in replaces the Enumeration add-in. |
|
|
|
12/21/07 |
Combinatorics
This add-in creates combinatorial models that use the search
methods of the Optimize add-in. The add-in
provides a model for the Quadratic Assignment,
Minimal Spanning Tree, Shortest Path Tree,
Sequencing and Routing for Single Vehicle
and Routing for Multiple Vehicle problems.
Other models will be added in the future. The Optimize
add-in must be installed for the Combinatorics
add-in to work. |
|
|
|
7/9/07 |
Functions
This add-in performs operations on a function of continuous
variables. The function may depend on many variables and
be constructed of arbitrary combinations of Excel functions.
The add-in uses numerical methods to compute the gradient
and Hessian matrices (matrixes of first and second partial
derivatives). It also computes integrals and moments. The
add-in uses a gradient search method to find values of the
variables that maximize or minimize the function. |
|
Probability
Add-ins
|
| |
7/9/07 |
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 problems may be solved through Monte-Carlo simulation.
|
|
|
|
11/10/08 |
Markov
Data
This add-in builds constructs
data forms and Markov models for specific problem
classes. Models are provided for birth death
processes and finite queues. Changing model
parameters automatically adjust the model to
reflect the changes. Large CTMC, DTMC and MDP
models can be constructed. The Markov Data
add-in calls the Markov Models add-in to construct
the model forms. No instructions are
provided at this time, but the add-in is easy
to use.
|
|
|
| |
11/18/08 |
Markov
Models
This add-in builds models for
Continuous Time and Discrete Time Markov processes,
and also Markov Decision Process Models. The
models are symbolic in that formulas are entered for
transitions, transition rates, transition probabilities
and other relevant components of a stochastic process
model. The Markov Chain or Markov Process model is
constructed automatically. The models constructed are
analyzed using the Markov Analysis add-in.
|
|
|
| |
11/6/08 |
Markov
Analysis
This add-in performs a variety
of computations associated with DTMC (Markov Chains)
and CTMC (Markov Processes) including: economic analysis,
steady state analysis, computation of n-step probabilities,
simulation, computation of first passage probabilities
and computation of absorbing state probabilities.
|
|
|
|
11/18/08 |
Markov
Decision Process
A Markov Decision Process (MDP) adds decisions
to Markov analysis . At each state there are two
or more decision options that affect the costs
and transition probabilities of the Markov chain.
The system will operate the system in
the least costly way if the operator chooses decisions
indicated by the optimum policy. This add-in determines
the optimum policy
|
|
|
| |
7/9/07 |
Queuing
The Queuing Add-in computes steady-state
measures associated with Poisson queuing models, non
Markovian queues and networks of queues. Both open and
closed Markovian queues are modeled. The program also
simulates multiple channel queues using two methods,
a discrete next-event simulation and an entity simulation.
Optimization was added on 1/22/04.
|
|
|
| |
6/25/08 |
Decision
Analysis
This add-in constructs and analyzes decision trees.
A tree is defined by decision, chance and terminal
nodes. The tree is described by a network of nodes
and arcs, and can be displayed graphically. Bayes'
analysis is available. Utility functions represent
the decision maker's attitude toward risk.
|
|
|
| |
|
|
simulation.pdf |
|
Simulation
This add-in creates multiline simulations useful for analyzing
a variety of systems that don't fit the model types handled
by the other add-ins. The add-in builds and maintains
worksheets on which simulations are easily built. Packaged
models for time series simulation and inventory simulation
are included. For most simulations, the RV add-in should
also be installed. |
|
Archive |
This is the complete
collection of ORMM, Teach OR and OM/IE add-ins.
The archive also includes the folder demo_xls that
contain the demonstration files. The archive also includes
the folder template_xls.
This folder includes Excel data files (.xls) that do not
require the add-ins. Some of these files include macros.
When downloading new versions of the add-ins, be
sure they replace the old versions on your hard disk.
Click the link on the left to download the archive. |
|
11/18/08 |
|
|
|
11/18/08 |
|
|
