Forum Discussion
Excel Optimisation
Hi people. I am facing a typical issue. I have one excel financial model. Can you suggest any tool for optimization of multiple parameters with certain constraints .is it doable in Excel with any ad...
A search for multi+objective+optimization+Excel produces pages of results. I couldn't determine whether FrontlineSolvers (the company behind Solver) offers multi-objective optimisation or not. Many add-ins appear to be MOGA (genetic algorithms). The primary output of multi-objective optimisation is the Pareto frontier and you still will have to decide on further criteria to select one design or set of operating conditions over another.
A further thought, you could start exploring options by treating all but one of the objectives as constraints and move the bounds between optimisation runs to gain some insight as to the trade-offs that are available.
