Adding Element Connections to a Spreadsheet

The Connections option retrieves a collection of connections between elements that are active for a case. The option adds formulas for the collections to the spreadsheet. These connections represent the relationship or connectivity of elements that are coming in to elements and going out from elements within a model. This includes connectivity involving transfer elements.

To get a collection or connections:

1. In Excel, select the cell into which you want the information to be brought.

2. From the SF tab Get Data section, select Connections.

   The Get Connections window opens.

3. Click the System down-arrow and select the system where the Sigmafine Server is running.

4. Click the Database down-arrow and select the database.

   This selection is dependent on the Sigmafine Server selection.

5. Click the Model down-arrow and select the Model to be examined.

   This selection is dependent on the Database selection.

6. 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.

7. In the Starting Case box, type the Case you want to use for the beginning of the search period.

   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.

8. In the Ending Case box, type the Case you want to use for the ending of the search period.

   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.

9. In the Element box, type the Element name, or click the ellipsis button to select the name from a list.

   Alternatively you can click the Search button to search for and select the Element from the Element Search window.

10. Click the Layers down-arrow and select the layer in which the Element is located.

11. Check the Connect Types you want included.

• Inputs: When checked, all elements that are directed into the referenced Element are included.
• Outputs: When checked, all elements that are directed from the referenced Element are included.
• Attachments: When checked, all elements that hold additional information for the Element are included.

12. Check the Show Connection Type checkbox to include header data in the spreadsheet.

13. Check the Show Connected Element Type checkbox to include the Element type in the spreadsheet.

14. Check the Show Case Time checkbox to display Case start times in the spreadsheet.

15. 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.

16. Select whether to add the information to the spreadsheet in rows (Row) or columns (Column).

17. 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.