You can use subroutines and functions in the Crystal Ball Developer Kit to automate certain Crystal Ball operations.
The following Crystal Ball functions are available as spreadsheet functions for use in Microsoft Excel models:
CB.GetAssumFN — Retrieves information for a specific assumption cell
CB.GetAssumPercentFN — Returns the value corresponding to a percentile for an assumption cell
CB.GetCertaintyFN — Returns the certainty level of achieving a forecast value at or below a specific threshold
CB.GetForeDataFN — Returns the value for the given trial for a specific forecast
CB.GetForePercentFN — Returns the value corresponding to a percentile for a specific forecast
CB.GetForeStatFN — Returns statistic for a specific forecast cell
CB.GetRunPrefsFN — Returns a Run Preference setting
CB.IterationsFN — Returns the number of trials run in a simulation
These spreadsheet functions can be inserted directly into Crystal Ball model workbooks. For more information, see the spreadsheet functions section of the Oracle Crystal Ball Developer's Guide.