Evolutionary algorithm for a spreadsheet

6 次查看(过去 30 天)
Hi, i'm not sure if this is something i should be asking here, but is there any program i can use to minimize a function on a spreadsheet using an evolutionary algorithm? I tried solver from excel, but it couldn't improve the solution any further.
Thanks!

回答(1 个)

Star Strider
Star Strider 2018-3-20
Use the Global Optimization Toolbox ga (link) function. It implements a robust genetic algorithm.
  2 个评论
Watasohara
Watasohara 2018-3-20
I didn't want to do it this way because i'll have to write all the equations in functions, but maybe that's the only way.
Thanks!

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Genetic Algorithm 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by