Functions For Use in Microsoft Excel Models

The following Crystal Ball functions are also available as spreadsheet functions for use in Microsoft Excel spreadsheet models.

Table 2. Functions For Use in Microsoft Excel Models

Name	Description
CB.GetAssumFN	Retrieves information for a specific assumption cell. See CB.GetAssum.
CB.GetAssumPercentFN	Returns the value corresponding to a percentile for an assumption cell. See CB.GetAssumPercent.
CB.GetCertaintyFN	Returns the certainty level of achieving a forecast value at or smaller than a specific threshold. See CB.GetCertainty.
CB.GetForeDataFN	Returns the value for the given trial for a specific forecast cell. See CB.GetForeData.
CB.GetForePercentFN	Returns the value corresponding to a percentile for a specific forecast. See CB.GetForePercent.
CB.GetForeStatFN	Returns statistic for a specific forecast cell. See CB.GetForeStat.
CB.GetRunPrefsFN	Returns a Run Preference setting. See CB.GetRunPrefs.
CB.IterationsFN	Returns the number of trials run in a simulation. See CB.Iterations.