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

 

Crystal Ball Example ModelOracle Crystal Ball Suite (Decision Optimizer Edition) is a complete risk analysis and simulation package for Microsoft Excel that enables you to assign probabilities to outcomes and analyze which variables most impact your decision.

Crystal Ball is the easiest way to perform Monte Carlo simulations in your own Excel spreadsheets and models because it automatically calculates thousands of different "what if" cases, saving the inputs and results of each calculation as individual scenarios. Analysis of these scenarios reveals the range of possible outcomes, their probability of occurring, which input has the most effect on your model and where you should focus your efforts.

 

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