You can import matrixes that contain data, such as matrix attribute values or time grid values from an .xls file to a time grid sheet.
Before you begin
▪ To import information to time grid sheets, you need a file in .xls format. The .xls file must include a column that corresponds to a unique ID attribute in the targeted elements, and a matrix for each element. If the .xls file contains more data than the time grid sheet setup, any extra values are ignored.
▪ The time grid sheet must be in edit mode.
Procedure
1 Select the time grid attribute in the element, and then , and then clickclick the link to a time grid sheet.
2 Click Import.
3 Select the import settings:
▪ Select the .xls file to import from.
▪ Select the worksheet in the .xls file to import from.
▪ Select the time grid sheet to import to.
▪ Click Import.
The selected .xls file is displayed.
4 Select a column in the worksheet to map to a unique ID attribute in the target elements.
5 Select the column to import to the time grid sheet.
6 Click Import.
Results
The matrixes from the .xls file are imported to the specified time grid sheet in the elements.