MM_SENSITIVITY creates sensitivity indexes of loop Analysis from one range. The function returns the row of the input range which corresponds to the selected index of the loop Analysis. 

MM_SENSITIVITYLABELS adds labels to analysis sensitivity indexes of loop Analysis.

Syntax

=MM_SENSITIVITY(Range, [Index])

• Range
  Target range. A table (usually) used as the values of the sensitivity scenarios in the loop Analysis.

• Index (optional)
  Index of the range to be displayed in Excel. Default value is set to 1.

=MM_SENSITIVITYLABELS(Range, Index)

• Range
  Range of sensitivity labels. Range must have only one column or one row.

• Index
  Index of the label to be displayed in Excel.
  
  

Remarks

• MM_SENSITIVITY function returns a range with one row. It is similar to the MM_LOOP function, except the latter can only return a single cell. Besides the loop Analysis is extended by AOC dimensions. See the article about AOC/AOS for more information.

• A model can contain only one MM_SENSITIVITY function.

• A model can contain only one MM_SENSITIVITYLABELS function.

• MM_SENSITIVITYLABELS function is the equivalent of MM_LOOPLABELS but for MM_SENSITIVITY labels.

Example

Here is an example of a grid with sensitivity scenarios to be included in the loop Analysis:

To include those sensitivity scenarios in the loop Analysis, the MM_SENSITIVITY function takes the grid Sensitivities as input:

=MM_SENSITIVITY(MM_TABLE(B4),1)

This function will return the row range of the grid Sensitivities for the selected index of loop Analysis. It will return the first row starting with "Central" in Excel.

To add labels to sensitivity scenarios, use the MM_SENSITIVITYLABELS function on the first column of the grid Sensitivities as shown below:

=MM_SENSITIVITYLABELS(B4:B11,1)

This function will return the label "Central" in Excel. In Mind, it will replace the sensitivity indexes with their corresponding labels in the loop Analysis (the first 8 indexes from loop Analysis will be named after the first column of the grid Sensitivities.

You can see here that the first 8 indexes from loop Analysis are named with their respective labels.

If you select "Sensitivity 6", the table MM_SENSITIVITY table will display its corresponding row in the grid Sensitivities :

If you select an index that corresponds to an AOC index, the table MM_SENSITIVITY table will return the row corresponding to the sensitivity scenario selected in the sensitivity drop-down list.