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.

"Alimaliyu" wrote:

> 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

> 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 wrote:
> 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

is there a "Genetic" algorithm in Excel ... must be worth millions


"Alimaliyu" <(E-Mail Removed)> wrote in message
news:2BF8C273-F6C1-47E9-8602-(E-Mail Removed)...
> 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

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


On Jul 26, 6:53*am, Alimaliyu <Alimal...@discussions.microsoft.com>
wrote:
> 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

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