Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i get the Genetic Algorithm in Excel Solver?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i get the Genetic Algorithm in Excel Solver?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i get the Genetic Algorithm in Excel Solver?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i get the Genetic Algorithm in Excel Solver?
is there a "Genetic" algorithm in Excel ... must be worth millions ;)
"Alimaliyu" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i get the Genetic Algorithm in Excel Solver?
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 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i get the Genetic Algorithm in Excel Solver?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA Algorithm | Excel Programming | |||
FFT function/algorithm used by Excel | Excel Worksheet Functions | |||
Dijkstra Algorithm In Excel | Excel Programming | |||
How can I monitor CPU time of algorithm I developed in Excel vba? | Excel Discussion (Misc queries) | |||
Algorithm for computing Excel PercentRank | Excel Worksheet Functions |