From: Christopher on
Hello,

I am trying to find a solver in matlab that is compatible with the excel solver. . I read from the internet that the solver platform sdk gives MATLAB users access to a powerful hybrid Evolutionary/Classical Solver that uses genetic algorithm methods such as mutation, crossover, selection and constraint repair, but also uses deterministic, gradient-free direct search methods, classical gradient-based quasi-Newton methods, and even the Simplex method for linear subsets of the constraints. This Solver handles optimization problems with hundreds of constraints, which are typically beyond the capabilities of genetic and evolutionary algorithms alone..

Does the sdk solves optimization like the excel solver? Specifically, does it pick a target cell with an equation, select cells to be changed and then add constraints like the excel solver?

Is it an add-in feature to matlab?

Pls. Can anyone help me. .

Thanks!

From: Steven_Lord on


"Christopher " <christopher.serojano(a)veco.com.ph> wrote in message
news:i3t3ag$2ef$1(a)fred.mathworks.com...
> Hello,
>
> I am trying to find a solver in matlab that is compatible with the excel
> solver. . I read from the internet that the solver platform sdk gives
> MATLAB users access to a powerful hybrid Evolutionary/Classical Solver
> that uses genetic algorithm methods such as mutation, crossover, selection
> and constraint repair, but also uses deterministic, gradient-free direct
> search methods, classical gradient-based quasi-Newton methods, and even
> the Simplex method for linear subsets of the constraints. This Solver
> handles optimization problems with hundreds of constraints, which are
> typically beyond the capabilities of genetic and evolutionary algorithms
> alone..

What specifically do you mean by "compatible with the excel [sic] solver"?

> Does the sdk solves optimization like the excel solver? Specifically, does
> it pick a target cell with an equation, select cells to be changed and
> then add constraints like the excel solver?

Microsoft Excel is a spreadsheet application. MATLAB is not. Therefore the
procedure for solving/minimizing equations will, almost by necessity, be
different in Excel and MATLAB. Very roughly, to use the optimization
functions that are part of Optimization or Global Optimization Toolboxes,
you will need to write a function that contains the objective function that
you want to minimize or solve (along with a constraint function if
necessary/allowed by the solver) and call one of the solver functions with
that function as input.

> Is it an add-in feature to matlab?

Take a look at the Optimization and Global Optimization Toolboxes.

http://www.mathworks.com/products/optimization/

http://www.mathworks.com/products/global-optimization/

You can access demos from those two pages that will show you how you will
need to call the solvers from those products, as well as access the
documentation for more in-depth information if you need it.

--
Steve Lord
slord(a)mathworks.com
comp.soft-sys.matlab (CSSM) FAQ: http://matlabwiki.mathworks.com/MATLAB_FAQ
To contact Technical Support use the Contact Us link on
http://www.mathworks.com