Page 1 of 1
Optimizer
Posted: December 15th, 2009, 8:23 pm
by Randomness
the solver in excel is quite weak for some large scale optimisation using the least squares algorithmscould someone please tell me if there are any external vendors that sell some quicker and more robust solver
Optimizer
Posted: December 17th, 2009, 9:31 am
by willsmith
If no luck/replies in Excel, Matlab has non-linear multidimensional optimisation built in (fminsearch) as well as toolkits for using genetic algorithms, neural networks and simulated annealing. Once you wrote your error function it's easy to switch optimisation techniques, they all use a similar calling convention.I guess it depends if your optimisation is one-off (port data to matlab and optimise) or higher frequency (better stay in excel). Will Smith
Optimizer
Posted: December 17th, 2009, 6:46 pm
by MCarreira
NAG is good, not sure if it's overkill / too expensive.You're probably better using Mathematica / Matlab.
Optimizer
Posted: December 17th, 2009, 7:01 pm
by Raver