ForeReference | Variant | A Microsoft Excel range: Range("B3") | Specifies the forecast cell to be used to define the assumption cell |
AssumReference | Variant | A Microsoft Excel range: Range("B3") | Specifies the desired location for the new assumption cell |
ForeDistType | Integer | Integer value or named constant | Specifies whether the distribution type is determined by fitting to the forecast distribution using current fit options (set with the user interface or CB.Fit) or is a custom distribution. Values can be: cbAsmFromFstDistTypeBestFit [1], best fit distribution parameters, or cbAsmFromFstDistTypeCustom [2], custom distribution from forecast values
|
NameOf (Optional) | String | Title surrounded by quotes ("") | Optional name to use for the new assumption; can be a valid cell address (such as “=A1”) to define a cell reference for the name. |
UseParmRef (Optional) | Boolean | True or False | If True, creates cell references in the worksheet for distribution parameters; default is False |
ParmRefFillDown (Optional) | Boolean | True or False | If True (the default), fills parameter reference cells down; if False, fills them to the right (moving from lower to higher columns) |
ParmRefLabel (Optional) | Boolean | True or False | If True, includes parameter name labels adjacent to parameter value cells for all referenced parameters; default is False |
TruncateCustom (Optional) | Boolean | True or False | When defining an assumption from a forecast using the Crystal Ball user interface, if the forecast trial count exceeds 5,000, users are prompted to use the first 5,000 trials or all trials. This constant is the equivalent of the prompt; if True, the first 5,000 trials are used; if False (the default), all trials are used. |
SequentialCustom (Optional) | Boolean | True or False | If True, defines a sequential custom distribution retaining generated forecast value order; default is False |