All Categories
    Menu Close

    Oracle Crystal Ball Suite (Decision Optimizer Edition)

    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

    Your price: $1,895.25
    i h
    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 No
    Requires other Software? Requires Microsoft Excel to run
    Scripting Support Built In
    Simulation Monte Carlo
    VBA Support Built In
    CSV Support Yes
    XML Support Yes
    Distribution Fitting Built In
    User Defined Distributions Yes
    Distribution Gallery 22 Base distributions + Advanced Custom Parameters
    Monte Carlo Sampling Yes
    Latin HyperCube Sampling Yes
    Process Capability (6 Sigma) Yes
    Sensitivity Analysis Yes
    Tornado Analysis Yes
    Precision Control Yes
    Probability calculations functions Yes
    Correlation Yes
    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 Yes
    Automated Reporting Yes
    Multi-Core Support Yes
    Developper Kit Yes
    Example Models Yes
    Network Licensing Available No
    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 Yes
    Non-Linear Optimization Methods Yes
    Requirements / Soft Constraints yes
    Max Requirements Unlimited
    Max Decision Variables Unlimited
    PSI support yes
    Solution Filtering yes
    Efficient Frontier yes
    Scenario Analysis Support Ability to create stochastic decision matrices using Decision Optimizer
    Convergence Testing yes
    Genetic Algorithims yes
    Ranges for Decision Variables yes
    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 yes
    Dynamic Optimization Support no
    Stochastic Optimization Support yes
    Time Series as distributions Yes
    Time Series Fitting Yes
    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 No
    Cubic Spline For Outlier Adjustments. Option can be set to neighbour interpolation also
    Heteroscedastic Models No
    ARIMA Support Yes, Full ARIMA Model (1331 Non-Seasonal + 27 Seasonal Methods)
    AutoARIMA Yes
    Data Sensoring Outlier Detection Methods: Mean and Standard Deviation, Median Absolute Deviations, Interquartile Deviation
    Time-Series Event Support Yes
    Define Time Series No
    Markov Chains No
    Automatic Data Transform Yes
    Manual Data Transform Methods No
    Manual Deseasonalization No
    Manual Detrending No
    Visualize Simulated Output Yes
    Exception Reporting Yes
    Time Series Scenario Analysis No
    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
    Customers who bought this item also bought
    Picture of Oracle Crystal Ball Decision Optimizer Maintenance

    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
    Picture of DecisionTools Suite - Industrial Edition

    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,695.00 $3,510.25
    Picture of Oracle Crystal Ball Standard Edition

    Oracle Crystal Ball Standard Edition


    Crystal Ball (standard edition) is the easiest way to perform Monte Carlo simulations in your Excel spreadsheets and models. Crystal Ball 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.

    $995.00 $945.25