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