Evolutionary algorithm for a spreadsheet

2018 3 20
1 个回答
更新时间：2018 3 20
2 次查看（30 天）

0 个投票

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

1 个投票

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!

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Genetic Algorithm 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by