Evolutionary algorithm for a spreadsheet

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!

Answer 1

[Star Strider]

Use the Global Optimization Toolbox ga (link) function. It implements a robust genetic algorithm.

[Watasohara]

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!

[Star Strider]

My pleasure.