Entering the 'Get Adjustments' Formula Directly
When the Filter Adjustments checkbox in the 'Get Adjustments' window is not checked, the inserted Excel formula for 'Get Adjustments' is as follows:
= SFGetAdjustments(System, Database, Model, ModelAnalysis, StartingCase, EndingCase,TypeCall, Outcode,TimeContext)
When the Filter Adjustments checkbox in the 'Get Adjustments' window is checked, the inserted Excel formula for 'Get Adjustments' uses the 'SFGetFilteredAdjustments' function instead, if the 'SFGetAdjustments. SFGetFilteredAdjustments' contains two more parameters in the end for Element name and Attribute name.
= SFGetFilteredAdjustments(System, Database, Model, ModelAnalysis, StartingCase, EndingCase,TypeCall, Outcode, TimeContext, ElementName, AttributeName)
The following table lists the formula arguments.
Get Adjustment 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. |
| TypeCall (string) | This has a value of "Single" for single periods and multiple values or "Multiple" for multiple periods and a single value. |
| 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. |
| Element (string) | This can be a single Element name or a cell reference to a single Element name. |
| Attribute (string) | Attribute name of the specified element. |