Exchange data with Schedule

Note: The features described in this section are part of the AVEVA USC Schedule Excel AddIn.

Get Schedule staging data into Excel

With the Schedule Excel Add-In, you can retrieve data from a staging service. A staging service contains information on the activity and status of one or more plants. Staging data is used to reconcile the prediction of a scheduling simulation of your plant with the actual data coming from the plant.

For more information on the scheduling reconciliation environment see Reconcile the Schedule with Plant Data.

Make sure that the Excel Add-In is configured correctly before trying to connect to the staging service.

You can retrieve these categories of data from a staging service:

• Measurements: these can be levels of tanks, pipe flows, feedstock compositions and property measurements.

• Imports and Exports: data on imports and exports of material.

You can then edit the data after retrieval.

Get measurements

1. Click Get Measurements in the Schedule Staging Data group of the AVEVA™ USC Schedule ribbon tab. The Get Measurements from Staging dialog opens.

2. In the Data Sources box, select each data source from which you want to retrieve data.

3. If you want to retrieve data from a certain point in time, select Time Filter and enter a date and time in the text field. Click the icon if you want to use a calendar widget instead of typing the date directly.

4. Click Get. The sheet is filled with the imported data.

Get imports and exports

5. Click Get Imports and Exports in the Schedule Staging Data group of the AVEVA™ USC Schedule ribbon tab. The Get Imports and Exports from Staging dialog opens.

6. In the Data Sources box, select each data source from which you want to retrieve data.

7. If you want to retrieve data from a certain point in time, select Time Filter and enter a date and time in the text field. Click the icon if you want to use a calendar widget instead of typing the date directly.

8. Choose the View you want to import data for. Different views show different columns of data.

9. Click Get. The sheet is filled with the imported data.