| |
These are Excel add-in files (.xla) of the OM/IE 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. 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. 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.
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 |
|
|
|
|
|
|
| |
11/21/08 |
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.
|
|
|
|
8/13/08 |
Estimate
The Estimate add-in creates
a worksheet to hold the data for capital budget estimates
or life-cycle cost estimates. Capital budgeting uses
the Work Breakdown Schedule (WBS) to describe
the activities in a project. Life-Cycle costing uses
the Cost Breakdown Schedule to itemize the costs
and revenues that will contribute to the cash flows of
the project during its life. Individual estimates may
be point estimates or described by probability distributions. |
|
|
| |
7/9/07 |
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. Models
with uncertainty are analyzed with the help of the Random
Variables add-in. For
a one-page summary click here. |
|
|
|
7/9/07 |
Equity
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.
This was formerly part of the Portfolio add-in. Use
the description there until a new one is provided. |
|
|
| |
7/9/07 |
Capital
Budgeting
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 models can consider
risk as measured by standard deviation. The Multiperiod problem
extends capital budgeting to multiple periods. |
|
|
| |
7/9/07 |
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.
|
|
|
| |
11/5/08 |
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.
|
|
|
| |
7/9/07 |
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. |
|
|
| |
7/9/07 |
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.
|
|
|
| |
9/9/08 |
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. |
|
|
| |
11/27/07 |
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. The program creates
a graph of the project network and a Gantt chart showing
the schedule. With restricted resources, the add-in generates
schedules which optimize resource usage and cash flows.
Activity durations may be specified as random variables.
Then the Monte Carlo method is used for simulation analysis. |
|
|
|
|
Routing
This program models and solves the vehicle routing problem
for several vehicles visiting several delivery sites.
A primary goal is to reduce the total distance required
to serve all the sites. The vehicles may have several
resources, such as capacity, weight or space. Deliveries
consume resources. One goal is to serve all the delivery
sites without exceeding the resources available. The
delivery sites may have time windows. A goal is to arrive
at the site before the early delivery time and leave
after the late delivery time. The various goals are related
through numeric penalties. The goal of the optimization
is to minimize the sum of the weighted goal violations.
Use the latest version of the Optimal Sequencing add-in
(just below) with this Routing add-in. |
|
|
2/20/08 |
Optimal Sequencing
This program is used to search for solutions for the Routing
add-in. The current versions uses simple random and
improvement heuristics. The heuristics are described for
the TSP problem of the Optimize add-in. |
|
Archive |
| |
|
|
|
|
