From: Christopher on 10 Aug 2010 22:53 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 11 Aug 2010 09:53 "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
|
Pages: 1 Prev: How to use 'zoom' on Y-axis and Z-axis view? Next: COM Automation |