Top
 

Oracle Crystal Ball Standard Edition

SKU: OCB10ASL-EN

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

Simulation & Time-Series Forecasting for Excel 32/64bit

Crystal Ball Example Model
Oracle Crystal Ball
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
     



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      

 

Customers who bought this item also bought

Oracle Crystal Ball Maintenance

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

$218.90 $207.96

Palisade StatTools StatTools Professional

The Professional edition allows 10,000 data points for a single variable.

Your price: $332.50
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
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