To build a model with AOC/AOS, see Analysis of Sensitivities (AOS) and Analysis of Change (AOC)‍ 

Instead of calling every AOC grid in the AOC order grid, you can gather AOC grids into groups and call those groups instead of in your AoC Order grid. Grids dependent on /AOC tables from the same group will have the same behavior regarding AOC functionality.

Excel modeling

Rules to follow to build AOC groups:

• Add /AOCGROUP.(GroupName) to the grid name with GroupName the name of the group.
• You should add the /AOCGGROUP flag specifically to AOC grids (the flag is ignored otherwise).
• You can add directly "/AOCGROUP.(GroupName)" instead of AOC grid names in the AoC Order Grid.

Remarks

For a grid flagged with /AOCGROUP, if both the grid name and the group are input in the /AOCORDER grid, then the grid will switch when the order index is set up for the AOC group.

Example

To define an AOC grid inside an AOC group, you just have to add the flag

/AOCGROUP.(GroupName). Here is an example with grid Table1 built into the AOCGROUP named "name":

Let us consider the following AOC Order grid:

Please note that you need to have the following right to access this feature:
Project AocOrder import

The AOC group "name" includes two AOC grids Table1 and Table2.
The AOC group "nom" includes two AOC grids Table10 and Table11.
The AOC group "midn" includes one AOC grid Table14.

The same AOC order grid with no AOC group in the model could be built as shown below.

You can notice here the benefits of defining AOC group things. It allows for better readability by gathering grids with the same AOC order index and label.

Grids that depend on tables from the same AOC group will have the same behavior regarding the use of stretched values from /AOC tables.

For example, AOC dependent grids from the AOC group midn will use stretched values when scenario "Central" from loop Analysis is selected. When another index is selected, all of the grids dependent on the group midn will use normal values in their calculations.