It works by changing a group of cells related to the target cell to find an optimal value subject to the constraints that you set. Solver helps to find an optimal value in one cell, called the target cell, on your worksheet. It is an add-in licensed from Frontline Systems that has shipped with Excel for many years. In short, Solver is a what-if analysis tool for optimization. The help topic applies to the Solver that ships in Excel 2007 and earlier, but the concepts are very much the same. If you are not familiar with Solver, you can learn more about Solver from Office Online. The purpose of this post is to review the improvements to Solver, and so assumes some familiarity with the tool. In Excel 2010, we have made a number of improvements to Solver that make it easy for beginners to get started and more advanced ones to find solutions to all types of problems. Thanks to Eric Patterson for putting together this post.
0 Comments
Leave a Reply. |