Top
 

Oracle Crystal Ball Suite (Decision Optimizer Edition)

SKU: OCB11DSL-EN

Oracle Crystal Ball is the easiest way to perform Monte Carlo simulations in your own Excel spreadsheets and models. Crystal Ball automatically calculates thousands of different "what if" cases, revealing the range of possible outcomes, their probability

$1,995.00
$1,895.25
Products specifications
Min. OS Requirement Windows XP
Language 7 languages (EN, FR, JP, DE, ES, CN, KR)
Add-In Requires Excel
Available for Mac No, requires Parallels Emulation
Price includes 1st year maintenance
Requires other Software? Requires Microsoft Excel to run
Scripting Support Built In
Simulation Monte Carlo
VBA Support Built In
CSV Support
XML Support
Distribution Fitting Built In
User Defined Distributions
Distribution Gallery 22 Base distributions + Advanced Custom Parameters
Monte Carlo Sampling
Latin HyperCube Sampling
Process Capability (6 Sigma)
Sensitivity Analysis
Tornado Analysis
Precision Control
Probability calculations functions
Correlation
Correlation Methods Normal Copula Only (Iman- Conover)
SIP Math Support Crystal Ball is SIPMath compatible because it allows for sequential sampling of datasets (SIPs). SIP Libraries can be exported using a 3rd Party Macro.
Decision Trees We recommend : Palisade PrecisionTree
Stats Tools 3rd party option. We recommend Minitab, Analyse-it and Palisade StatsTools
MS Project Support Requires free Crystal Ball Project Macro to be installed
Charting Built In
Charts can be customized
Automated Reporting
Multi-Core Support
Developper Kit
Example Models
Network Licensing Available
Data Base Integration 30+ Data Sources with CDATA Connectors
Supported DBs Standard ODBC sources from Excel + 3rd party connectors
User Defined Distribution Library Distributions can be generated and saved to shared network drive and can be made available to other Crystal Ball users on the network
Linear Optimization Methods
Non-Linear Optimization Methods
Requirements / Soft Constraints
Max Requirements Unlimited
Max Decision Variables Unlimited
PSI support
Solution Filtering
Efficient Frontier
Scenario Analysis Support Ability to create stochastic decision matrices using Decision Optimizer
Convergence Testing
Genetic Algorithims
Ranges for Decision Variables
Main Solver Engine OptQuest
Optimize multiple statistics Optimization can be done on 11 different statisics (Mean, Variance, Standard Deviation, Skewness, Kurtosis, Percentile, Min/Max, Mode, Range, Coef. Variation, Probability, Certainty ) + 15 SigSigma Capability Metrics
Optimization Goal Types Minimize, Maximize & Set Target
Static Optimization Support
Dynamic Optimization Support
Stochastic Optimization Support
Time Series as distributions
Time Series Fitting
Time Series Methods 5 Non-Seasonal Methods + 6 Seasonal Methods, Complete ARIMA (1500 Models) and Stochastic Multiple Linear Regression
Multiple Linear Regression Stochastic Linear Regression (Forecast Independent Variables and recombine into a simulated dependant variable using the regression equation)
Seasonal Methods Seasonal Multiplicative, Seasonal Additive, Holt-Winter's Additive, Holt-Winter's Multiplicative, Damped Trend Additive, Damped Trend Multiplicative
Non-Seasonal Methods Double Moving Average, Single Exponential Smoothing, Double Exponential Smoothing, Single Moving Average, Damped Trend
GBM Support
Cubic Spline For Outlier Adjustments. Option can be set to neighbour interpolation also
Heteroscedastic Models
ARIMA Support Yes, Full ARIMA Model (1331 Non-Seasonal + 27 Seasonal Methods)
AutoARIMA
Data Sensoring Outlier Detection Methods: Mean and Standard Deviation, Median Absolute Deviations, Interquartile Deviation
Time-Series Event Support
Define Time Series
Markov Chains
Automatic Data Transform
Manual Data Transform Methods
Manual Deseasonalization
Manual Detrending
Visualize Simulated Output
Exception Reporting
Time Series Scenario Analysis
Error Measures RMSE, MSE, MAD, MAPE, Theil's U, Durbin-Watson
Time Series Fit Criteria BIC, AIC, RMSE, MSE, MAD, MAPE, Theil's U, Durbin-Watson
Product description

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.

  • 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

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
 
 
 
 
 
 
Global Optimization - Deterministic
 
 
VBA Macros for Crystal Ball
 
 
 
VBA Macros for OptQuest  
 
 
 
VBA Macros for CB Predictor
 
Operational within Oracle EPM Workspace      

 

Customers who bought this item also bought

Oracle Crystal Ball Decision Optimizer Maintenance

Protect your investment!

Oracle Maintenance includes support and product updates. A must to always be with the latest and greatest Oracle Crystal Ball has to offer.

Level 1 and Level 2 product support / Product Updates and Download Rights

Extend your Maintenance by up to 2 years.

$438.90 $416.96

DecisionTools Suite - Industrial Edition

The DecisionTools Suite Industrial includes @RISK for Monte Carlo simulation, PrecisionTree for decision trees, and TopRank for “what if” sensitivity analysis. In addition, the DecisionTools Suite comes with StatTools for statistical analysis and forecasting, NeuralTools for predictive neural networks, and Evolver and RISKOptimizer for optimization.

$3,565.00 $3,386.75

Backup Media CD

Technology Partnerz will ship a backup CD with all your downloadable purchases for safe keeping. 7 day delivery.

Your price: $20.00
Additional information
Products specifications
Min. OS Requirement Windows XP
Language 7 languages (EN, FR, JP, DE, ES, CN, KR)
Add-In Requires Excel
Available for Mac No, requires Parallels Emulation
Price includes 1st year maintenance
Requires other Software? Requires Microsoft Excel to run
Scripting Support Built In
Simulation Monte Carlo
VBA Support Built In
CSV Support
XML Support
Distribution Fitting Built In
User Defined Distributions
Distribution Gallery 22 Base distributions + Advanced Custom Parameters
Monte Carlo Sampling
Latin HyperCube Sampling
Process Capability (6 Sigma)
Sensitivity Analysis
Tornado Analysis
Precision Control
Probability calculations functions
Correlation
Correlation Methods Normal Copula Only (Iman- Conover)
SIP Math Support Crystal Ball is SIPMath compatible because it allows for sequential sampling of datasets (SIPs). SIP Libraries can be exported using a 3rd Party Macro.
Decision Trees We recommend : Palisade PrecisionTree
Stats Tools 3rd party option. We recommend Minitab, Analyse-it and Palisade StatsTools
MS Project Support Requires free Crystal Ball Project Macro to be installed
Charting Built In
Charts can be customized
Automated Reporting
Multi-Core Support
Developper Kit
Example Models
Network Licensing Available
Data Base Integration 30+ Data Sources with CDATA Connectors
Supported DBs Standard ODBC sources from Excel + 3rd party connectors
User Defined Distribution Library Distributions can be generated and saved to shared network drive and can be made available to other Crystal Ball users on the network
Linear Optimization Methods
Non-Linear Optimization Methods
Requirements / Soft Constraints
Max Requirements Unlimited
Max Decision Variables Unlimited
PSI support
Solution Filtering
Efficient Frontier
Scenario Analysis Support Ability to create stochastic decision matrices using Decision Optimizer
Convergence Testing
Genetic Algorithims
Ranges for Decision Variables
Main Solver Engine OptQuest
Optimize multiple statistics Optimization can be done on 11 different statisics (Mean, Variance, Standard Deviation, Skewness, Kurtosis, Percentile, Min/Max, Mode, Range, Coef. Variation, Probability, Certainty ) + 15 SigSigma Capability Metrics
Optimization Goal Types Minimize, Maximize & Set Target
Static Optimization Support
Dynamic Optimization Support
Stochastic Optimization Support
Time Series as distributions
Time Series Fitting
Time Series Methods 5 Non-Seasonal Methods + 6 Seasonal Methods, Complete ARIMA (1500 Models) and Stochastic Multiple Linear Regression
Multiple Linear Regression Stochastic Linear Regression (Forecast Independent Variables and recombine into a simulated dependant variable using the regression equation)
Seasonal Methods Seasonal Multiplicative, Seasonal Additive, Holt-Winter's Additive, Holt-Winter's Multiplicative, Damped Trend Additive, Damped Trend Multiplicative
Non-Seasonal Methods Double Moving Average, Single Exponential Smoothing, Double Exponential Smoothing, Single Moving Average, Damped Trend
GBM Support
Cubic Spline For Outlier Adjustments. Option can be set to neighbour interpolation also
Heteroscedastic Models
ARIMA Support Yes, Full ARIMA Model (1331 Non-Seasonal + 27 Seasonal Methods)
AutoARIMA
Data Sensoring Outlier Detection Methods: Mean and Standard Deviation, Median Absolute Deviations, Interquartile Deviation
Time-Series Event Support
Define Time Series
Markov Chains
Automatic Data Transform
Manual Data Transform Methods
Manual Deseasonalization
Manual Detrending
Visualize Simulated Output
Exception Reporting
Time Series Scenario Analysis
Error Measures RMSE, MSE, MAD, MAPE, Theil's U, Durbin-Watson
Time Series Fit Criteria BIC, AIC, RMSE, MSE, MAD, MAPE, Theil's U, Durbin-Watson