Prev: Coordinates arrays to plaid
Next: Mat-file program with %VAL construct
From: Christopher on 9 Aug 2010 22:08
I have a data in excel which i need to make an optimization analysis. . In excel, using the solver, it's easy. . I just choose a cell with a formula then pick the cells i need to change and add constraints then minimize.. but, in matlab i really dont have a clue. . I was able to import my data to matlab but i dont know if there's like an excel solver function in matlab..

Can Anyone pls help me. .

thank you. .
From: Alan Weiss on 10 Aug 2010 08:30
On 8/9/2010 10:08 PM, Christopher wrote:
> I have a data in excel which i need to make an optimization analysis. .
> In excel, using the solver, it's easy. . I just choose a cell with a
> formula then pick the cells i need to change and add constraints then
> minimize.. but, in matlab i really dont have a clue. . I was able to
> import my data to matlab but i dont know if there's like an excel solver
> function in matlab..
>
> Can Anyone pls help me. .
> thank you. .
If you have Optimization Toolbox, take a look at
http://www.mathworks.com/access/helpdesk/help/toolbox/optim/ug/brhkghv-18.html

Alan Weiss
MATLAB mathematical toolbox documentation
From: Christopher on 10 Aug 2010 20:19
Alan Weiss <aweiss(a)mathworks.com> wrote in message <i3rgpi$ntd$1(a)fred.mathworks.com>...
> On 8/9/2010 10:08 PM, Christopher wrote:
> > I have a data in excel which i need to make an optimization analysis. .
> > In excel, using the solver, it's easy. . I just choose a cell with a
> > formula then pick the cells i need to change and add constraints then
> > minimize.. but, in matlab i really dont have a clue. . I was able to
> > import my data to matlab but i dont know if there's like an excel solver
> > function in matlab..
> >
> > Can Anyone pls help me. .
> > thank you. .
> If you have Optimization Toolbox, take a look at
> http://www.mathworks.com/access/helpdesk/help/toolbox/optim/ug/brhkghv-18.html
>
> Alan Weiss
> MATLAB mathematical toolbox documentation

sir, thank you for your reply. . I have tried most of the solvers sir but it analyzes a single function. . I need an analyzer for a whole data just like the excel solver.. Is it possible?
From: Alan Weiss on 11 Aug 2010 08:23
On 8/10/2010 8:19 PM, Christopher wrote:
> Alan Weiss <aweiss(a)mathworks.com> wrote in message
> <i3rgpi$ntd$1(a)fred.mathworks.com>...
>> On 8/9/2010 10:08 PM, Christopher wrote:
>> > I have a data in excel which i need to make an optimization analysis. .
>> > In excel, using the solver, it's easy. . I just choose a cell with a
>> > formula then pick the cells i need to change and add constraints then
>> > minimize.. but, in matlab i really dont have a clue. . I was able to
>> > import my data to matlab but i dont know if there's like an excel
>> solver
>> > function in matlab..
>> >
>> > Can Anyone pls help me. .
>> > thank you. .
>> If you have Optimization Toolbox, take a look at
>> http://www.mathworks.com/access/helpdesk/help/toolbox/optim/ug/brhkghv-18.html
>>
>>
>> Alan Weiss
>> MATLAB mathematical toolbox documentation
>
> sir, thank you for your reply. . I have tried most of the solvers sir
> but it analyzes a single function. . I need an analyzer for a whole data
> just like the excel solver.. Is it possible?

You can solve multidimensional problems by putting all your decision
variables into one vector (decision variables are the ones that you can
change to minimize your objective function). You can include as many
extra parameters (other variables) as you like using anonymous functions:
http://www.mathworks.com/access/helpdesk/help/toolbox/optim/ug/brhkghv-7.html

Alan Weiss
MATLAB mathematical toolbox documentation
 | 
Pages: 1
Prev: Coordinates arrays to plaid
Next: Mat-file program with %VAL construct