Entering the 'Get Attribute Data Table Values' Formula Directly
The inserted Excel formula for the 'Get Attribute Data Table Values' command is shown below.
=SFGetDataTableValue(System, Database, Model, ModelAnalysis, StartingCase, EndingCase, Element, Attribute, Column, Outcode, TimeContext)
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 or a cell reference to a single Element name. |
| 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". |
| TimeContext (string) | The time context for the retrieval of the value. Valid values are By Case, By Time, By Time Range. |