Managing products and portfolios : Financial planning using time grid attribute : Working with the time grid editor : Importing to time grid sheets
  
Importing to time grid sheets
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.
See also
Time grid menu options
Working with the time grid editor