|
As
add-ins are revised, dates and the purposes of the revisions
are listed below. To check the version
of the add-in that you are using, find the date of the
add-in by choosing the About Add-in item on the submenu
for the add-in. Add-ins that do not have a submenu, LP
Solver and Net Solver, have an About Add-in button on
the dialog for the add-in. Clicking this button reveals
the version date.
If you find that you are using
an older add-in than is available at this site, download
the add-in. Add-ins are stored in the zip format, so you
will have to un-zip the file. Once unzipped, replace any
old add-ins of the same name. Otherwise, Excel may use
the old version rather than the new. |
3/14/2011 |
Corrections to the MP Model
Builder add-in. |
3/12/2011 |
Nonlinear programming models
were added to the MP Model Builder add-in. The new versions
of the Excel Solver required modifications of the and
Math Programming MP Model Builder add-ins. |
2/26/2011 |
The DEA add-in was modified
to work with the
MP Model Builder add-in. The MP Model Builder add-in,
Jensen LP/IP solver add-in, and Math Programming add-in
were modified to work with the new DEA add-in and with
each other. |
2/20/2011 |
The MP Model Builder add-in,
Jensen LP/IP solver add-in, and Math Programming add-in
were modified to allow more than 32000 nonzero coefficients
in the LP constraint matrix. The Jensen Network Solver
add-in was modified to have more than 32000 arcs. |
2/11/2011 |
Changed all the add-ins to correct
formats for the Excel Solver 2010 and 2011. Several program
changes were also made. Important: Download the latest
add-in versions. |
1/29/2011 |
Modifications to the Math Programming
Model Builder and Math Programming Models add-ins. The
change fixes an error in the solver selection for the
Excel Solver 2010 and 2011 add-ins. |
1/26/2011 |
Modifications to the Math Programming
Model Builder and Jensen LP/IP Solver to show dual variable
solutions. |
1/24/2011 |
Corrections to the Math Programming
Model Builder, add ORMM, Jensen LP/IP
Solver, and Math Programming Models add-ins. |
1/16/2011 |
Added the Math Programming Model
Builder add-in. Modified the add ORMM, Jensen LP/IP Solver,
and Math Programming Models add-ins. |
10/28/10 |
Improved the Teach Transportation
add-in, particularly in regard to the Run option. |
10/4/10 |
Modified the feature that
colors rows for the Gantt chart. Removed an artificial
limit that restricted the number of time intervals in
a Gantt chart. |
9/15/10 |
Extensive modifications of the methods for
downloading add-in and demonstration files. All downloads
are handled through the new Excel page. |
8/21/10 |
Modified the Optimize
add-in to fix an error that incorrectly listed the
solutions with the x best objective values, where x is
a specified number. The best solution was identified
correctly however. Thanks to Bill Lesso for pointing
this out. |
8/13/10 |
Modified the Math Programming
add-in to fix an error that occurred when the
Math Programming
add-in was called from another program. Made new Jensen
zipped collections. |
7/5/10 |
Modified the OMIE Control
add-in to include the DEA Data check box. Made new Jensen
zipped collections. |
6/28/10 |
Added a new add-in and demo
file for the Data Envelopment Analysis (DEA) method. Be
sure to download the new Math Programming Models add-in
to use with this add-in. It must be installed to use the
DEA add-in. |
6/28/10 |
Modified the Math Programming
Models add-in to accommodate the requirements of the
DEA add-in described in the OM/IE section. Made new Jensen
zipped collections. |
4/27/10 |
Modified the Routing add-in
to allow simpler models that do not include time or time
windows. The complex models with time and time windows
are still available. All demonstration files are updated. |
4/18/10 |
Modified the Routing and Opt_Sequence
add-ins to correct errors and improve functionality. The
demonstration files will no longer work with the new add-ins.
They are being updated. |
4/11/10 |
Added a customer worksheet to
the Routing model. Modified the Routing add-in to correct
errors and improve functionality. |
3/29/10 |
Updated the Routing and
Opt_Sequence add-ins especially involving geographic coordinates.
Added interface for Google Earth. |
3/7/10 |
Corrections to the Routing and
Opt_Sequence add-ins |
2/22/10 |
Corrections to the Inventory
and Routing add-ins. |
2/17/10 |
Updated all add-ins to correct
an error that might occur for large problems. Download the new Jensen library
and replace your add-ins. |
1/26/10 |
Added geographic coordinates
and a number of corrections to the Routing add-in |
12/21/09 |
More revisions of the Routing
and Optimal Sequencing add-in ins the OM/IE section. |
12/3/09 |
Major revision in the Routing
add-in in the OM/IE section. The Opt_Sequence add-in was
also modified. |
11/15/09 |
Changed the Recover Solution
option in DP Solver for deterministic DP. Minor fixes for
DP Models
and DP Data. |
11/8/09 |
Added a check to Teach DP add-in
to generate error message when tables use more than the
maximum number of worksheet columns. |
10/30/09 |
Added a Resource deterministic
DP model to DP Data. Fixed errors in DP Models and DP Solver. |
10/19/09 |
Added error analysis and error
correction to the DP Solver add-in. |
10/7/09 |
In DP Solver add-in, made the
detailed printout of
intermediate results more flexible. This is handy for finite
horizon problems. Corrected errors. |
9/6/09 |
Added final values to states
for finite horizon problems. |
8/10/09 |
Corrections of Birth-Death Model
in DP Data and DP Models. |
7/12/09 |
Added change options to the
DP Solver add-in. |
7/10/09 |
Corrected an error in computing
sensitivity the LP/IP solver add-in. |
6/12/09 |
Corrections to the Inventory
model to the DP Data add-in. Made corrections to DP Data,
DP Models, DP Solve add-ins. |
6/9/09 |
Added Inventory model to the
DP Data add-in. Made corrections to DP Data, DP
Models, DP Solve add-ins. |
5/7/09 |
Fixed a Run Time error in Math
Programming add-in |
5/5/09 |
Changes and corrections to DP
Data, DP Models, DP Solve add-ins. New zipped versions
of the complete Jensen library. |
3/30/09 |
Changes and corrections to DP
Data, DP Models, DP Solver, and Markov Analysis add-ins. |
3/10/09 |
Added Random Walk to DP Data
add-in. |
2/24/09 |
Added an LP solution method
to the
DP Solver. |
2/12/09 |
Corrected and expanded three
add-ins for Dynamic Programming: DP Data, DP Models, and
DP Solver. |
1/27/09 |
Added three add-ins for Dynamic
Programming: DP Data, DP Models, and DP Solver. These add-ins
replace and considerably improve the Markov Data, Markov
Models, and Decision Process add-ins. Documentation of
the add-ins will be added when available. |
11/6/08 |
Changed the Markov Data, Markov
Models, Markov Analysis and Markov Decision Process add-ins. Generally
the changes increase efficiency, but some errors are corrected.
Models constructed with the older versions of the Markov
Decision Process add-in will no longer work. |
10/20/08 |
Changed the Markov
Models and Markov Decision Process add-ins. The
Decision Processes add-in now can solve models using the
Policy iteration method. This method finds solutions to
average cost models in addition to discounted cost
models. |
9/20/08 |
Changed the Markov Data, Markov
Models, Markov Decision Process and Markov Analysis add-ins. |
6/25/08 |
Changed the Decision Analysis
and Demo add-ins to fix an error in the Decision Analysis
demo. |
6/20/08 |
Changes
to the add-ins in the Markov series to make them
more compatible. Changed the LP/IP Solver add-in
to show LP dual variables when required. Changed
the Add-ORMM add-in to include the Markov Data add-in. |
6/16/08 |
Added
the Markov Data add-in. Complete revisions of the
Markov Model, Markov Analysis and Markov Decision
Process add-ins. Download all four add-ins for compatibility. |
4/27/09 |
Removed size limitation on models
for the Teach LP add-in. Limitations imposed by
Excel and limited size for matrix inversion may cause errors
for larger models. |
4/6/08 |
Changes
to the Markov Decision Process add-in. |
4/1/08 |
Created
a Markov
Decision Process add-in. Replaced the Stochastic
Analysis add-in with the Markov Analysis add-in.
Replaced the Stochastic Models add-in with the Markov
Models add-in. Changed the ORMM Control
to accommodate the changes. |
3/20/08 |
Extensive
changes to the Markov
Decision Process model in the Stochastic
Analysis add-in. |
3/12/08 |
Added
a Markov Decision Process model to the Stochastic
Analysis add-in. |
2/28/08 |
Changed the Math Programming
add-in, so that the number of variables for a
math program are limited by the number of columns of
the worksheet, rather than 200. |
2/26/08 |
Added a new stand-alone Multiple
Vehicle Routing add-in to the OM/IE collection. |
12/20/07 |
Added a Multiple Vehicle
Routing option to the Combinatorics add-in. |
12/10/07 |
Modifications to the Math
Programming add-in to allow new interactions for
stochastic programming. Extensive modification of LP/IP
add-in to allow direct solution of LP/IP models with
side constraints. Elimination of all problem size limitations
except the number of IP variables. The number of IP variables
is still limited to 50. |
10/30/07 |
Corrections to the Vary option
of the MP_Models add-in. |
10/19/07 |
Changes to Teach NLP add-in |
10/17/07 |
Changes to Teach DP add-in |
9/17/07 |
Changes in the Optimize add-in. |
9/7/07 |
Changes in the Simulation add-in. |
8/16/07 |
Changed the Project add-in.
Corrected errors in schedule search process. Changed some
options regarding cash flows. |
7/9/07 |
Changed all the demo files to
show current colors. Changed some add-ins. |
7/3/07 |
Changed all the add-ins to maintain
consistent colors. |
6/30/07 |
Made a number of changes to
accommodate Excel 2007. |
2/20/07 |
Corrected the P&G game. |
2/8/07 |
Modified the Math Programming add-in to
allow recent changes in the Portfolio add-in. |
1/31/07 |
Corrected the LP/IP add-in to
correct errors in the Mixed integer programming solution
algorithms. (This is an important correction please change
the Jensen LP/IP add-in.) |
1/12/07 |
Modified the Simulation
add-in to create games. Changed the Inventory model
of the Simulation add-in. Modified
the Inventory game
and Proctor and Gamble games. |
1/10/07 |
Added an Inventory game
that allows the decision making to control stochastic inventories.
Changed the Proctor and Gamble game. |
1/10/07 |
Made changes to the Simulation add-in
with regard to the evaluation of average inventory costs
and average backorder costs for the inventory model. Included
control variables in the general model to allow the creation
of games. |
9/20/06 |
Fixed an error in LP/IP Solver
dealing with artificial variables. The error made the program
indicate infeasibility erroneously. New Jensen archive
loaded to reflect the changes. |
8/9/06 |
New Jensen archive loaded to
reflect changes in the Economics, Estimation and Project
Managment add-ins. |
6/4/06 |
Modifications to the Simulation add-in. |
6/1/06 |
Changed the Simulation add-in
to allow step-by-step simulation with user providing control
inputs. |
5/25/06 |
Added the Equity add-in to the
OM/IE collection. |
1/4/06 |
Corrected an error Queue add-in
for computing the departing coefficient of variation in
a Non-Markovian queuing network. |
1/1/06 |
Corrected a formatting error
in Random Variables add-in. |
10/27/05 |
Corrected an error in Economics add-in
for counting sign changes in cash flow. |
10/21/05 |
Correct the LP/IP add-in
for L-shaped method. |
10/17/05 |
Correct the LP/IP add-in
to indicate "Infeasible IP" when the LP relaxation at node
0 of the enumeration tree is infeasible. |
9/22/05 |
Correct the Random Variables add-in so that it now simulates cells with a dollar format. |
9/22/05 |
Correct an "Out
of Range" error in Jensen LP/IP Solver. |
7/30/05 |
Modified the Jensen
LP/IP Solver to perform the L-shaped method. Modified the
Math Programming add-in to provide the data structure necessary
for the L-shaped method. Several other features of both
programs were modified to provide more accuracy. |
7/22/05 |
Modified Jensen
Network Solver to output flows differently. This corrects
and error for the Mac. |
7/18/05 |
Corrections
and improvements to the Side Model feature of
the Math Programming add-in and the Random
Variables add-in. |
7/9/05 |
Corrections
and improvements to the Side Model feature
of the Math Programming add-in. |
7/5/05 |
Corrected an
error in the Moments feature of Random Variables
add-in. Added a change option to the Side Model feature
of the Math Programming add-in. |
6/28/05 |
Added several
new features to the Process Flow add-in. |
6/21/05 |
Added a Side Model
option to the Math Programming add-in. Description will
come later. |
6/21/05 |
Minor corrections
to the Hurricane workbook. |
6/21/05 |
Corrections to
the Random Variables add-in to accept large numbers on
the Simulate Random Variables option. Better histogram
automatic limits. |
6/3/05 |
Corrections to
the Random Variables add-in for interaction with the Simulation
add-in. |
6/1/05 |
Corrections for
transformations with negative multipliers in the Random
Variables add-in. |
5/28/05 |
Corrections and
improvements
to the Random Variables add-in. |
5/16/05 |
Added the Indexed distribution
to the Random Variables add-in. Significantly revised how
the User and Indexed distribution are
used in the Function and Moments features. |
4/25/05 |
Corrections to the
Jensen Network Solver based on suggestions from John George
from Texas A&M University. Also changed Jensen LP/IP
Solver and Math Programming. |
4/21/05 |
More corrections
to the Jensen Network Solver, Jensen LP/IP Solver, Math
Programming and Random Variables add-ins. |
4/21/05 |
Corrections to the
Jensen Network Solver, Jensen LP/IP Solver and Math Programming
add-ins. |
4/20/05 |
Removed size limits
from Jensen Network Solver and Jensen LP/IP Solver. Changed
limits in the Math Programming add-in. |
4/19/05 |
Removed the
limitations for size from the Jensen LP/IP Solver. Added
upper bounds to IP solutions. Changed Math Programming
add-in accordingly. Also updated the Jensen Network Solver. |
4/16/05 |
Changed the Jensen
Network Solver to handle larger problems with more integer
variables. The limits are now 1000 arcs, 200 nodes and
200 integer variables. Also reduced the time to put solutions
on the worksheet, a major time consumer for larger problems.
The changes were suggested by John George, Department
of Computer Science, Texas A&M University, and Marieke
van der Lans and Maarten van Schaik, University of Twente
(the Netherlands). |
3/31/05 |
Corrections and
improvements to the function feature of the Random Variables
add-in. Modified Optimize to be compatible with function
feature of Random Variables. |
3/25/05 |
Add Scenarios
and Displays to the Function Feature of the Random Variables
add-in. |
3/16/05 |
Corrections to
the Random Variables add-in. |
3/13/05 |
Added enhanced
Monte Carlo simulation for functions of random variables
to the Random Variables add-in. |
3/13/05 |
Modified Math
Programming add-in to provide a new entry point useful
for the Function Monte Carlo option of the Random Variables
add-in. |
3/13/05 |
Corrected an
error in the Optimization add-in that occurred when calling
an algorithm during an enumeration procedure. |
2/15/05 |
Added calendar and
color options to the Project Management add-in. Changed
Random Variables add-in to be compatible to Project Management
add-in. |
2/10/05 |
Added dates to the
Project Management add-in. |
2/2/05 |
Corrections to the
the Random Variables add-in and simulation added to the
Project Management add-in. |
1/26/05 |
Revised Random Variables
add-in to allow degenerate forms of triangular and Beta
distributions. This version is necessary for the Project
Management add-in. New Jensen library file created. |
1/19/05 |
Updated Library
to reflect changes in Project Management add-in. |
1/9/05 |
Updated Library
to reflect changes in Project Management add-in. |
12/30/04 |
Improved Random
Variables add-in to create a chart of the histogram for
a Monte Carlo simulation. Update library for this change
and changes to the Economics add-in. |
12/28/04 |
Updated Library
to reflect changes in Project Management add-in. |
12/26/04 |
Updated Library
to reflect changes in Project Management add-in. |
11/26/04 |
Corrected TeachIP,
TeachNLP and Functions add-ins to correct an error occurring
with Chinese Excel. Corrections suggested by Baocheng Zhang,
graduate student in School of Management of Tianjin University,
China. |
11/18/04 |
Made more improvements
and corrections to the Functions add-in. |
11/16/04 |
Revised a number
of add-ins in the ORMM collection to use graphic buttons.
These are more reliable than the buttons formerly used. |
11/15/04 |
Corrected an error
in the Queue simulation option of the Queuing add-in. |
11/14/04 |
Made more improvements
and corrections to the Functions add-in. |
11/06/04 |
Made corrections
to the Functions add-in. Allowed mult-variable integration
with Simpson's Rule. |
11/05/04 |
Significantly improved
the Functions add-in by adding new integration methods. |
10/16/04 |
Added a new Functions
add-in. Modified the ORMM Control add-in to refer to the
Functions add-in. Modified the Layout add-in. |
9/18/04 |
Created a new archive
with Project Management and new OMIE Control |
8/9/04 |
Added improved restart
for Teach LP add-in. |
8/5/04 |
Added corrections
to the error analysis portion of the Hurricane macros. |
7/20/04 |
Changed Math Programming
add-in to correct a minor error |
7/15/04 |
Replaced the Jensen
archive to include changes to the Portfolio add-in. |
7/9/04 |
Replaced the Jensen
archive to include changes to the Portfolio add-in. |
7/1/04 |
Changed Math Programming,
LP/IP Solver, Network Solver to make them compatible with
the Portfolio add-in and correct some errors. |
6/29/04 |
Added the hurricane
tracking and forecasting workbook. |
6/15/04 |
Added a parametric
analysis feature to the Math Programming add-in. |
6/5/04 |
Made changes to
OM/IE add-ins |
|
Previous changes
deleted from list |