SOLVER- programming or not?

[Henrique Campos]

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

 

[GJones]

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=EC010272491033&App
=O10

 

[Tom Ogilvy]

http://www.frontsys.com

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

 

[Mark Wiley]

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: [email protected]
LINDO Systems, Inc. Tel: (312)988.7422
1415 North Dayton Fax: (312)988.9065
Chicago, IL 60622 URL: http://www.lindo.com
=================================================================

 

[Jorma Kuha]

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