Clicking Normal Constraint shows the traditional constraint relations, and clicking the
remaining gallery choices will display new options that you haven’t had in the basic Excel
Solver.
The buttons on the Ribbon play the following roles:
• Clicking the Model button displays or hides the Task Pane (see more on this below).
Click the down arrow to add Dimensional Modeling capability to your model.
• The Simulation Model group of buttons relate to setting up simulation models:
o Clicking the Distribution button gives you a range of pre-defined probability
distributions you may choose to represent uncertainty in your model and access to
our new Distribution wizard.
o Clicking the Correlations button brings up a dialog to allow you to easily create,
edit or delete correlation matrices. The down-arrow allows you to turn the use of
correlations on and off.