Chapter 36. Penalties and the Evolutionary Solver
Questions answered in this chapter:
What are the keys to using the Evolutionary Solver successfully?
How can I use the Evolutionary Solver to assign 80 workers in Microsoft Finance to a job in one of four workgroups?
Answers to this chapter’s questions
This section provides the answers to the questions that are listed at the beginning of the chapter.
What are the keys to using the Evolutionary Solver successfully?
Previously, this book stated that the Evolutionary Solver should be used to find solutions to optimization problems in which the target cell, changing cells, or both involve nonsmooth functions such as IF, ABS, MAX, MIN, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, and AVERAGEIFS. Before solving ...
Get Microsoft Excel 2013: Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
