Hi all.
I need to create a model with Solver tool but as it allows
only 200 variable cells, do I have to program the solution
or is there any other way to do it? If not, is there
another similar software to Excel/Solver to do it with the
same easyness?
thanx
Henrique

Hi Henrique;

I found these two articles at Microsoft but did not find
an imediate answer. You will probably have to do multiple
solver routines via VBA but you might check out the
articles deeper than I did.

Thanks,

Greg


http://office.microsoft.com/en-
us/assistance/HA011245961033.aspx

http://office.microsoft.com/en-us/results.aspx?
Query=solver&Scope=HP,HA,RC,FX,XT&Origin=EC0102724 91033&App
=O10


-----Original Message-----
Hi all.
I need to create a model with Solver tool but as it
allows
only 200 variable cells, do I have to program the
solution
or is there any other way to do it? If not, is there
another similar software to Excel/Solver to do it with
the
same easyness?
thanx
Henrique
.

http://www.frontsys.com

are the authors of solver and make a commerical version that has more
capability.

--
Regards,
Tom Ogilvy



"Henrique Campos" wrote in message
...
Hi all.
I need to create a model with Solver tool but as it allows
only 200 variable cells, do I have to program the solution
or is there any other way to do it? If not, is there
another similar software to Excel/Solver to do it with the
same easyness?
thanx
Henrique

LINDO Systems makes a large scale optimization add-in to Excel called
What'sBest for linear, integer and nonlinear problems. You can get
more information at www.lindo.com

Regards,
Mark

================================================== ===============
Mark Wiley e-mail:
LINDO Systems, Inc. Tel: (312)988.7422
1415 North Dayton Fax: (312)988.9065
Chicago, IL 60622 URL: http://www.lindo.com
================================================== ===============

"Henrique Campos" wrote in message ...
Hi all.
I need to create a model with Solver tool but as it allows
only 200 variable cells, do I have to program the solution
or is there any other way to do it? If not, is there
another similar software to Excel/Solver to do it with the
same easyness?
thanx
Henrique

Check out Direct Optimizer - a nonlinear optimization Add-In
for Excel. As an example of its performance, I solved
the famous Extended Rosenbrock test function (the "banana
valley" function) for 100000 variables in less than 20 hours
using a 266 MHz Pentium II PC with it.

You can download Direct Optimizer for free from http://www.directoptimizer.com

- Jorma

"Henrique Campos" wrote in message ...
Hi all.
I need to create a model with Solver tool but as it allows
only 200 variable cells, do I have to program the solution
or is there any other way to do it? If not, is there
another similar software to Excel/Solver to do it with the
same easyness?
thanx
Henrique