The Mathematical Programming Addin constructs models that can
be solved using the Solver Addin or one of the solution addins
provided in the collection.
When the Math Programming addin is installed, several new
command lines are added to the OR_MM menu. The menu items
under the title Math Programming create models of the different
types.
Selecting an item from this list causes a dialog box to be
presented which constructs a mathematical programming model.
Select one of the options in the left column of this page
to get detailed instructions for specific forms of the model.
When a worksheet containing buttons is opened on a different
machine than the one on which it was created, the buttons
on the worksheet do not work. An attempt to use them will
result in an error message. The Relink Buttons command deletes
the buttons on a worksheet and creates new buttons linked
to the addins on the new computer.
The models created by the addin are solved with the Excel
Solver, the Jensen Network Solver or the Jensen LP/IP Solver.
All are Excel addins. Documentation for these programs can
be reached by clicking the links on the lower left.
The Solver addin comes with Excel, and it can solve linear
programming, integer programming and nonlinear programming
models. The Math Programming addin automatically builds Solver
models and calls the computational procedures that solve the
problems. All four model types can be can be solved in this
way.
The Jensen LP/IP Solver solves linear or integer programming
problems. It is available for the Linear/Integer Programming
and Network Flow Programming model types.
The Jensen Network Solver can solve generalized network flow
models. Both linear and integer problems can be solved. It
is available for the Network Flow Programming or Transportation
model types.
To build and solve models, the Math Programming addin and
one of the solver addins must be installed. The Math Programming
addin can build models, but not solve them. The solver addins
can solve models, but not build them. Follow the instructions
given elsewhere for installing
addins.
