Monte-Carlo Simulation + Optimization for Excel 32/64bit


Crystal Ball Example ModelOracle Crystal Ball EPM is a powerful set of spreadsheet-based simulation and optimization tool that empower you to forecast your business data and turn your financial and operational spreadsheet models into dynamic analytical applications. Leveraging the power and ease of Crystal Ball Decision Optimizer, Oracle Crystal Ball Enterprise Performance Management enables managers, executives and analysts to better manage risk and improve planning/forecast accuracy across the enterprise using EPM and Business Intelligence (BI) applications.

Crystal Ball EPM uses the power of Oracle Hyperion Smart View for Office to access data from your EPM applications, including Hyperion Planning and Essbase directly in Excel to model your risks and predict success. Furthermore, with Oracle EPM Workspace you can share your Crystal Ball workbooks and analysis across the enterprise to enhance and accelerate collaborative decision making by putting the right information in the hands of the right people.



Discover The Power Of Decision Optimizer

Easily add optimization to your Crystal Ball simulation model

Optimize any forecast or output in your model

  • Build simple or complexe models
  • Example models covers the Portfolio Allocation Model, Productio Optimization, Queuing, Supply Chain Optimization
  • Select optimization objectives from your models forecasts
  • Define requirements for feasible solutions
  • Minimize or maximize any forecast

Use Discreet, Continuous or Custom Variables to test your decisions

Create natural language logical constraints

  • Define or modify upper and lower bounds for each decision varable
  • Ability to set continuous or discreet simulations
  • Create multiple constraints
  • Use of simple operators
  • Natural Language
  • Logic based constraints

Flexible settings and options to ensure optimal results

  • Use both stochastic and deterministic simulation to test your models
  • Run either a set of itereration or time limit for the optimization
  • Powerful output and reporting options

Compare Editions

Oracle Crystal Ball
Distribution Gallery
Categories of Distributions
User-Defined Distributions
Publish and Subscribe for Categories
Process Capability features
Forecast Charts, with split-view
CB Tools
Customized Reporting
Extreme Speed  
Global Optimization - Deterministic
VBA Macros for Crystal Ball
VBA Macros for OptQuest  
VBA Macros for CB Predictor
Operational within Oracle EPM Workspace