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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.