Get 'Attribute Data Table Values' of Elements

The Attribute Data Table Values option retrieves Attribute table data related to an item in a database table’s column.

On the menu, click Attribute Data Table Values.

To get Attribute data table values:

In Excel, select the cell into which you want the information to be brought.
From the SF tab Get Data section, select Attribute Data Table Values.
The Get Attribute Data Table Values window opens.
Click the System down-arrow and select the system where the Sigmafine Server is running.
Click the Database down-arrow and select the database.
This selection is dependent on the Sigmafine Server selection.
Click the Model down-arrow and select the model.
This selection is dependent on the Database selection.
Click the Model Analysis down-arrow and select the Model analysis.
This selection is dependent on the Model selection.
Note: For System, Database, Model and Model Analysis, you can click the Cell Reference button to select from a list of cells referencing the selected item.
Click on the Time Context down-arrow and select whether to select Attributes based on case, time stamp or time range.
If you select 'By Case', an additional box appears: 'Case'.
In the Case box, type the Case you want to use for the beginning of the search period, or click the ellipsis button to select the Case from a list of available cases.
Alternatively you can click the Search button to search for and select the Case from the Case Search window. See Get List of Case Times to Use for more details.
Check the Element or Transfer checkbox to indicate the type of values you want pulled for the specified attribute (selected in the 'Attribute' box).
Click on the Attribute down-arrow and select the Attribute you want to get Element and/or transfer values.
In the box below the Element and Transfer checkboxes, type the element/transfer name, or click the ellipsis button to select the name from a list.
Alternatively you can use one of the following:

Position the cursor in the Element or Transfer box in the window and then click the cell in the spreadsheet containing the names of the elements.
Click the Search button to open the Element Search or Transfer Search window in which you can search for and select the element/transfer.
When a valid element/transfer is selected, the 'Available Columns' box displays the Attribute names of the element/transfer.

Using the Available Columnsand Selected Columns list boxes, select each Attribute that you want to appear in the spreadsheet. Ensure that only those Attributes that you want to appear are in the 'Selected Columns' list.
Attributes will appear in the spreadsheet in the order in which they appear in the Selected Columns list box.
To move an Attribute to the 'Selected Columns' list
In the Available Columns list box, select the attribute.
Click the right-arrow to move it to the Selected Columns list.
To remove an Attribute from the 'Selected Attributes and UOMs' list
In the Selected Columns list box, select the attribute.
Click the left-arrow to move it to the Available Columns list.
Attributes appear in the spreadsheet in the order in which they appear in the 'Selected Columns' list box. If you want to rearrange the order, use the following applicable steps.
To move an Attribute up one place in the Selected Columns list
In the Selected Columns list box, select the attribute.
Click the up-arrow.
To move an Attribute down one place in the Selected Columns list
In the Selected Columns list box, select the attribute.
Click the down-arrow.
Check the Show Attribute Name checkbox to display Attribute names in the spreadsheet.
Check the Show Case Time checkbox to display Case start times in the spreadsheet.
In the Output box, type the reference of the cell in which the information is to start appearing in the spreadsheet, or click the ellipsis button to select the cell from another window.
Select whether to add the information to the spreadsheet in rows (Row) or columns (Column).
Click OK to add the returned information to the spreadsheet and close the window.
Click the Apply button if you want add the returned information to the spreadsheet but keep the window open.
Click the Cancel button if you want to close the window without adding the returned information to the spreadsheet.