These are Excel add-in files (.xla) for the OM/IE collection.
They are compressed and stored at this site with the (.zip)
suffix. Download by clicking on the file name of the add-in
in the left most column. The files may be expanded with the
free Aladdin Expander.
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
OMIE. Review the General
Instructions for loading add-ins.
File Name |
Date Modified |
Add-in Name |
Instructions |
|
|
|
|
|
|
|
9/18/04 |
Add
OMIE
When called, this add-in lists all the OM/IE
add-ins that are in the same directory as the Add
OMIE 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.
|
|
|
|
5/30/04 |
Investment
Economics
This add-in performs a variety of procedures to evaluate
investment alternatives. Included are procedures to define
projects and compute measures of effectiveness such as
present worth, annual worth and internal rate of return.
Functions are provided to compute the traditional time
value of money factors. Projects may be defined with tax
and inflation considerations. Cash flows are presented
in either tabular or graphical displays. For a one-page
summary click here. |
|
|
|
7/15/04 |
Portfolio
This add-in uses optimization for two kinds of portfolio
problems. Capital Budgeting selects a portfolio
from a set of candidate projects. A project is described
by its initial investment, annual return, salvage value
and life. The first three of these factors are described
by averages and standard deviations. Markowitz Portfolio
analysis determines an optimum mix if financial securities
considering both security returns and risk. Risk is measured
by the statistical variance of the portfolio. The analysis
uses historical return data to determine the expected
return for each security and the covariance matrix showing
the dependence between securities. |
|
|
|
9/6/04 |
Process
Flow Analysis
The Process Flow Add-in
provides a tool to analyze and design manufacturing
systems. Four principal activities are supported:
process definition, economic analysis, resource requirements
analysis and product mix decisions. Either tree or
network structures are allowed. The add-in links with
the Math. Programming add-in to produce linear and
mixed integer models for decisions. It also links
with the Facility Layout add-in for facility design.
Models for queues, inventories and lot change delays
are included.
|
|
|
|
10/10/04 |
Facility
Layout
This add-in accepts as data:
a list of departments, physical size of departments,
part flows between departments and the size of a proposed
plant. The program uses the CRAFT procedure in an
attempt to find the layout of departments that minimizes
the distance over which parts must flow.
The new version interacts with the Process Flow add-in.
Significant revision was made on 2/13/03. Optimization
was added on 1/22/04.
|
|
|
|
3/14/04 |
Forecasting
The add-in implements several forecasting methods for
data series including: moving average, exponential smoothing,
regression and double exponential smoothing. The add-in
constructs a form that holds the data and uses functions
to compute forecasts and forecast errors. Several data
series can be analyzed on a single worksheet page. An
option allows comparison of several methods for a single
time series. A simulation option creates data simulated
with the Monte Carlo technique. A portfolio option evaluates
and forecasts a portfolio of investments. Adjustments
are provided for series with seasonality. |
|
|
|
2/21/04 |
Inventory
We compute the Economic Lot
Size with or without backorders or lost sales. We
also allow either finite or infinite replenishment
rates. Both deterministic and stochastic models are
considered. The add-in finds the optimum lot size
with cost breaks. Three optimization models that involve
more than one item are solved: multi-item systems,
inventories with common cycle times and machine scheduling.
The add-in includes several models of manufacturing
processes that produce Work-in-Process. Total WIP
and cycle times are computed for combinations of inventories
arranged into systems.
|
|
|
|
2/21/04 |
Materials
Requirement Planning Materials
Requirement Planning (MRP) is a scheduling procedure for
production processes that have several levels of production.
The add-in provides the means to enter data concerning
a production system and determine a schedule with MRP. |
|
|
|
12/26/04 |
Project
Management This add-in
performs the computations of CPM and PERT. Given the activities
of the project, the add-in computes the critical path. A
graphical display is available. With restricted resources,
the add-in generates schedules which attempt to minimize
shortage costs. |
|
Archive |
|
|
Jensen
Library
This is the complete collection of ORMM, Teach
OR and OM/IE add-ins. The archive also
includes the the folder demo_xls. This folder
includes all the demonstrations for the add-ins.
|
|