Set up dynamic cases

With dynamic cases, you can quickly explore the effect that changes to one or more variables have on optimization. A dynamic case is a copy of the list of variables you decide to download. You can modify each dynamic case separately and then optimize them all, and check the different results on the same Excel worksheet.

1. In Excel, click the Dynamic Cases button in the Get AVEVA™ USC Plan Data group of the AVEVA™ USC Plan ribbon tab. The Create Data Link from Case Stack dialog opens.

2. Choose the Share containing the cases you want to get data from.

3. Choose the Model containing the cases.

4. Choose the Watch Set containing the rows you want to include.

5. Choose the Cases to include in the stack. Select the check box next to each case you want to include.

6. Choose the number of Dynamic Cases you want to create. Each dynamic case allows you to change quantities and see the effect of changes on optimization.

7. Select the data Columns you want to import.

8. Click OK. The sheet is filled with the imported data.