Entering the 'Get Transfer Values' Formula Directly
The inserted Excel formula for the 'Get Transfer Values' command is shown below.
=SFGetValueTrans(System, Database, Model, ModelAnalysis, StartingCase, EndingCase, TransferName, Attribute, UOM, Transfer Template, Outcode, TimeContext)
The following table lists the formula arguments.
Get Transfer Values 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. |
| Transfer Name (String) | This is a transfer name or a cell reference to a single transfer name. |
| 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. |
| Transfer Template (string) | This is the name of the transfer template. |
| Outcode (number) | For Outcode values, see "Output Code (Outcode) Table". |
| TimeContext (string) | The time context for the retrieval of the value. Valid values are By Case, By Time, and By Time Range. |