January 2011
Beginner to intermediate
720 pages
23h 29m
English
Questions answered in this chapter:
What are the keys to successfully using the Evolutionary Solver?
How can I use the Evolutionary Solver to assign 80 workers in Microsoft Finance to a job in one of four workgroups?
What are the keys to successfully using the Evolutionary Solver?
Previously I stated that the Evolutionary Solver should be used to find solutions to optimization problems in which the target cell and/or changing cells involve nonsmooth functions such as IF, ABS, MAX, MIN, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, and AVERAGEIFS. Before solving a problem with the Evolutionary Solver, you should do the following in the Solver Parameters dialog box: ...