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

Oracle 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.

• Easy-to-use Interface
• Powerful graphics and reports
• Ability to identify factors influencing your results
• Collaborate with team members and share data
• OptQuest is an industry-leading optimization tool that runs with Crystal Ball. As an add-in to Crystal Ball, OptQuest enhances simulation models by automatically searching for and finding optimal solutions. At the basic level, OptQuest selects a value for each decision variable, enters those values into your spreadsheet, runs a Monte Carlo simulation on the spreadsheet, records the results, and repeats the process. With OptQuest, you can determine the best combination of decision variables that yields the results you are seeking!
  • Test thousands of scenarios
  • View all the best scenarios
  • 3 Solution Search Models (Scatter, Neural Network and Taboo Solution Searches)
  • Incorporate multiple constraints such as profitability, NPV, quality specs, etc.

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

	Crystal Ball	Decision Optimizer	Crystal Ball + Decision Optimizer	Crystal Ball Enterprise Performance Management
Distribution Gallery
Distribution Fitting
Categories of Distributions
User-Defined Distributions
Publish and Subscribe for Categories
Correlated Assumptions
Monte Carlo Simulation
Process Capability features
Precision Control
Forecast Charts, with split-view
Sensitivity Analysis
Tornado Analysis
CB Tools
Customized Reporting
Example Models
Time-series Forecasting
Multiple, Stepwise, and Forward Linear Regression
Global Optimization - Stochastic
Global Optimization - Deterministic
VBA Macros for Crystal Ball
VBA Macros for OptQuest
VBA Macros for CB Predictor
Operational within Oracle EPM Workspace