Long description

In the dialog box:

  • Set Objective field allows to enter the cell address for the objective function value. The address in the screenshot is dollar sign D solar sign 5.

  • To field has three radio buttons labeled “Max,” “Min,” and “Value of” out of which the Max button is selected. This field helps to specify max or min.

  • By Changing Variable Cells field allows to enter the location of the values for the variables. The location in the screenshot is dollar sign B dollar sign 4 colon dollar sign C dollar sign 4.

  • A box titled “Subject to the constraints colon” is seen underneath with buttons to add, change, delete, reset all, and load/save.

  • A checkbox “Make unconstrained variables non-negative” is seen under the box and is ticket. This ...

Get Quantitative Analysis for Management, 13/e 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.