Entering the 'Get Connections' Formula Directly
The inserted Excel formula for the 'Get Connections' command is shown below.
= SFGetConnections (System, Database, Model, ModelAnalysis, StartingCase, EndingCase, Element, Attribute, Outcode, Layer)
The following table lists the formula arguments.
Get Attribute Values Formula Arguments
| Argument | Description |
|---|---|
| System (string) | Sigmafine Server name. |
| Database (string) | Database name. |
| Model (string) | Model name. |
| ModelAnalysis (string) | Model analysis name. |
| StartingCase (string) | Date/time of the starting case |
| EndingCase (string) | Date/time of the ending case. |
| Element (string) | This can be a single Element name, a cell reference to a single Element name or a cell reference to a row or column of Element names. |
| Attributes (string) | Attribute name of the specified element. |
| Column (string) | This is the column name from the data table. |
| Outcode (number) | For Outcode values, see the "Output Code (Outcode) Table". |
| Layer (string) | The layer in which the Element is located. |