CB.SensPrefsND Example

The following example runs a simulation, selects cell B2, defines that cell as the target forecast for a sensitivity chart, creates and names the sensitivity chart, indicates the sensitivity should be shown as Contribution to Variance, limits display to the four most sensitive assumptions with sensitivities greater than 0.1, and finally opens the chart.

CB.Simulation 1000
Range("B2").Select
CB.SensPrefsND cbSenTargetFore
CB.SensPrefsND cbSenTitle, "My Sensitivity Chart"
CB.SensPrefsND cbSenMeasure, cbMesContributionToVar
CB.SensPrefsND cbSenDisplayOnlyHighest, True, 4
CB.SensPrefsND cbSenDisplayGreaterThan, True, 0.1
CB.OpenSensitiv