|
|
 |
Operations
Research Models and Methods |
| |
-
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. |
|
| Add-in - Click the add-in
name to download a zipped .xla file. |
Add-in Name |
File |
Date |
|
optimize.xla |
2/06/2011 |
| Associated Add-ins - Click
the add-in name to transfer to the add-in page. |
Add-in Name |
File |
|
|
mp_models.xla |
The Optimize add-in has a feature that searches for the
global optimum for nonlinear models. |
|
combinatorics.xla |
The Optimize add-in is used as the solution procedure
for more complicated combinatorial problems. |
|
layout.xla |
The Optimize add-in is used to find optimum layouts. |
| Demonstration Files -
Click the demo name to download a .xls file. |
Demo Name |
File Name |
|
|
optimize.xls |
|
|
opt_mpdemo.xls |
|
|
opt_tsp.xls |
|
|
opt_tree.xls |
|
|
opt_uncap_loc.xls |
|
|
| |
|
|
