Entering the 'Get Attribute Summary' Formula Directly
The inserted Excel formula for the 'Get Attribute Summary' command is shown below.
=SFGetSummary (System, Database, Model, ModelAnalysis, StartingCase, EndingCase, Element, Attribute, Mode, UOM, Outcode)
The following table lists the formula arguments.
Get Attribute Summary Formula Arguments
| Argument | Description |
|---|---|
| System (string) | Sigmafine Server name. |
| Database (string) | Database name. |
| Model (string) | Model name. |
| Model Analysis (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. |
| Mode (string) | This is a maximum, average, minimum, or total mode for the returned value. |
| Attribute (string) | Attribute name of the specified element. |
| UOM (string) | This is a specified unit of measure that the value will have. The UOM must be one of the units listed in the attribute's unit-of-measure class. |
| Outcode (number) | Determines the row/column to include. For Outcode values, see "Output Code (Outcode) Table". |