|
|
Operations
Research Models and Methods |
|
-Functions |
|
This
add-in performs operations on a function of continuous variables.
The function may depend on many variables and be constructed
of arbitrary combinations of Excel functions. The add-in uses
numerical methods to compute the gradient and Hessian matrices
(matrixes of first and second partial derivatives). It also
computes integrals and moments. The add-in uses a gradient
search method to find values of the variables that maximize
or minimize the function. |
|
Add-in - Click the add-in
name to download a zipped .xla file. |
Add-in Name |
File |
Date |
|
functions.xla |
2/06/2011 |
Demonstration Files -
Click the demo name to download a .xls file. |
Demo Name |
File Name |
|
|
fun_demo.xls |
|
|
|
|
|