how do i get the Genetic Algorithm in Excel Solver?

  • Thread starter Thread starter Alimaliyu
  • Start date Start date
A

Alimaliyu

I need to use the Genetic algorithm feature in Solver to globally solve a
non-linear blending problem. I have used What's Best to obtain a local
optimum which is not satisfactory. I need help.
Regards
Alimaliyu
 
Since you've posted this in the programming forum, I'm going to assume you're
doing this with VBA. If so, you may want to post your code so that someone
can assist.
 
I need to use the Genetic algorithm feature in Solver to globally
solve ...


Solver Uses Generalized Reduced Gradient Algorithm
http://support.microsoft.com/kb/82890

My guess is that you've locked onto a local minimum (or maximum) and not
the global solution.

Try different starting values, or keep adding tighter constraints in the
direction you think is a better solution.

Make sure your model isn't using functions like IF, Max, Min, Lookup,...etc
= = = = =
HTH Dana DeLouis
 
Alimaliyu,

The solver that is included in Excel does not have a genetic algorithm
(only a generalized reduced gradient search). However, a Global solver
is availible in What'sBest if you have the Global option. You can
select WB!|Options|Global Solver and check the box for Global Solver
to use it. As an alternative, a lot of blending models can be
linearized. There may be a way to reformulate the model in a linear
fashion.

Regards,
Mark Wiley
LINDO Systems
 
Linear reformulation is out of the question.
The GA in Excel solver comes with the Premium Solver version which has to be
installed separately and costs more than my Sony Vaio. thanks for your
responses, I'll just use Matlab, but my life could've been much easier.
Alimaliyu
 
Back
Top