RESEARCH ARTICLES | RISK + CRYSTAL BALL + ANALYTICS

Oracle Crystal Ball Spreadsheet Functions For Use in Microsoft Excel Models

Oracle Crystal Ball has a complete set of functions that allows a modeler to extract information from both inputs (assumptions) and outputs (forecast). Used the right way, these special Crystal Ball functions can enable a whole new level of analytics that can feed other models (or subcomponents of the major model).

Understanding these is a must for anybody who is looking to use the developer kit.

Crystal Ball utlizes several powerful functions and features to extract information and descriptive statistics. We are going to review these techniques and present the CB.GetForeStatFN in full detail, including Six Sigma Capability Metrics.

Crystal Ball utlizes several powerful functions and features to extract information and descriptive statistics. We are going to review these techniques and present the CB.GetForeStatFN in full detail, including Six Sigma Capability Metrics.

Overview of  techniques to accelerate Excel Models and custom applications.... I have included a few fun user defined functions as examples.

  • 12 June 2010
  • Author: mckibbinusa
  • Number of views: 622
  • Comments: 0

Overview of  techniques to accelerate Excel Models and custom applications.... I have included a few fun user defined functions as examples.

RSS
12