Tareas

Crystal Ball Functions
Some Crystal Ball functions can be used directly from within Excel.
Source: Developer Kit for Crystal Ball 2000 and CB Predictor, Decisioneering Inc., 1999.
Sometimes is ituseful to embed some functions directly into a worksheet; for example, to
automatically extract summary statistics and/or percentiles from a simulation. These can be
specially formatted for a user,who does not have to know anything about the CB interface.
All of these functions (and others) can be accessed from the function wizard in Excel, or typed in
like any other Excel function (ofcourse, the CB add-in must be loaded first). In the function wizard,
the CB functions are in the “Crystal Ball” category.

Probability
Distributions

CB.xxx (distribution parameters)CB.GetForeStatFN
(ForeReference, Index)
Simulation
Results

Model
Information

CB.GetForePercentFN(ForeRefere
nce, Percent)
CB.GetCertaintyFN(ForeReferenc
e, Value)
CB.IterationsFN()
CB.GetAssumFN(AssumRef,
Index)
CB.GetAssumPercentFN(AssumR
eference, Percent)
CB.GetDecVarFN (DecVarRef,
Index)
CB.GetForeFN (ForeRef, Index)
CB.GetCorrelationFN(AssumRef,
Column, Row)

Crystal BallInformation

CB.GetVersionFN()

CB_Functions.doc, 5/31/2004, 12:01 AM

Functions for each of the probability distributions included in CB. See
list in Table 3.1 (page 88) of Evans & Olson book.Returns descriptive statistics for the specified forecast cell.
ForeReference must point to a defined forecast cell (if not, #VALUE
is displayed). Index is a number between 1 and 13. Before a
simulationis run, or after resetting, the results are shown as zeroes.
The values of Index return the following values:
1: number of trials
2: mean
3: median
4: mode
5: standard deviation
6: variance7: skewness
8: kurtosis
9: coefficient of variability
10: minimum
11: maximum
12: range (max-min)
13: standard error
Returns value of a forecast for a specified percentile (cumulative...