AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
This means that the Solver works with a group of cells called decision variables that are used in computing the formulas in the objective and constraint cells. In Excel, you can use Solver to find an optimal value (maximum or minimum, or a certain value) for a formula in one cell called the objective cell, subject to certain constraints or limits, on the values of other formula cells on the worksheet. Then, one or more other variables are changed repeatedly, subject to the specified constraints, until you discover the best values for the target variables. Instead of setting a specific target value for a variable, the goal is to find the optimum value for one or more target variables, under certain constraints. Solver is a Microsoft Excel add-in program you can use for optimization in what-if analysis.Īccording to O'Brien and Marakas, optimization analysis is a more complex extension of goal-seeking analysis.
0 Comments
Read More
Leave a Reply. |