Adding Transfers to a Spreadsheet

The Transfers option transfer information and add it to the spreadsheet.

To add transfer information to a spreadsheet:

In Excel, select the cell into which you want the information to be brought.
From the SF tab Find Data section, select Transfers.
The Transfer Search window opens.![Figure 720: Transfer Search window](/img/docs/add-tfers-to-ss_transfer Search-WND.png)
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 or time range.
If you select By Case
'Starting Case' and 'Ending Case' entry boxes appear.
In the Starting Case box, type the Case you want to use for the beginning of the search period, or click the ellipsis button to select it from a list.
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.
In the Ending Case box, type the Case you want to use for the ending of the search period, or click the ellipsis button to select it from a list.
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.
If you select By Time Range
'Start Time' and 'End Time' entry boxes appear.
In the Start Time box, type the starting time stamp, reference a cell that contains that time stamp, or click the ellipsis button to select it from a list.
Alternatively, you can click the Search button to select the time stamp from a calendar window.
In the End Time box, type the ending time stamp, reference a cell that contains that time stamp, or click the ellipsis button to select it from a list.
Alternatively, you can click the Search button to select the time stamp from a calendar window.
Click on the Transfer Template down-arrow and select the appropriate transfer template to filter the results and limit the transfer list.
Click the Transfer Type down-arrow and select the transfer transaction type or a cell reference to the transaction type.
Click the Transfer Mode down-arrow and select the mode of the transfer or a cell reference to the mode.
In the Source box, type the name of the Element you want to use as the beginning point, or click the ellipsis button to select it from a list.
Alternatively you can click the Search button to search for and select the Case from the Element Search window.
In the Destination box, type the name of the Element you want to use as the ending point, or click the ellipsis button to select it from a list.
Alternatively you can click the Search button to search for and select the Case from the Element Search window.
In the Material box, type the material name, or click the ellipsis button to select it from a list.
Alternatively you can use one of the following:

Position the cursor in the Material box in the window and then click the cell in the spreadsheet containing the Element with the material name you want.
Click the Search button to open the Element Search window in which you can search for and select the Element with the material name you want.

Check the Properties you want included.

Show Header: When checked, column headers are added to the spreadsheet.
Show Source/Destination: When checked, source and destination columns or rows are added to the spreadsheet.
Show Transfer Type: When checked, a transfer type column or row is added to the spreadsheet.
Show Start/End Time of Transfer: When checked, transfer start and end time columns or rows are added to 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 elements 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.