Link your case view data

To get data from one of the supported views in a case, into Excel:

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

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

3. Choose the Model containing the case.

4. Choose the Case.

5. Choose the Source grid containing the data you want to get. The available options depend on the type of case you have selected. For example, planning cases display Crude Purchases and Sales, while scheduling cases display choices such as imports, exports and tank inventories.

6. Choose the View to import data from. The columns enabled in the view will determine what part of the data in the grid is imported.

7. Select Retain Values if you want the updated values you enter to be retained after publishing and optimizing.

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