Crystal Ball 11.1.2.1
Features
Adding Probability to Risk Calculations
What is the likelihood of reaching a particular goal? What are the critical factors affecting risk? The answer to these and other common "what-if" scenarios can be determined by assigning probability to unknown variables. Excel can't handle the complexity of probability analysis, so you need a better tool: Crystal Ball.
Crystal Ball automates the cumbersome "what-if" process using Monte Carlo simulation, by applying a range of values or a probability distribution to each uncertain variable.
The program generates random values from within the defined probability ranges, and then recalculates the model literally hundreds or thousands of times, storing the results of each "what-if" scenario. This timesaving process alleviates having to manually enter different scenarios over and over again.
Monte Carlo Simulation
Calculates multiple scenarios of a spreadsheet model automatically. Frees users from the constraints of estimates and best-guess values.
Distribution Gallery
Provides an intuitive interface for selecting model input variables; includes 16 discrete and continuous distributions plus custom distribution. Simplifies the quantifying of risk, means you don't have to enter the distribution formula into Excel.
Categories of Distributions
Create predefined distributions, modify your existing distributions and organize them using custom categories. Create your own library of distributions, organized in categories. Re-use distributions from one project to the next.
Publish and Subscribe Feature for Categories
Publish categories and share with many users. Work as a team sharing models and data to get your work done faster.
Process Capability Features
Define spec limits (LSL, USL and Target) in your forecasts, calculate capability metrics and view simulation results and metrics together in one split-view chart. With capability metrics in Crystal Ball you simplify your workflow and better integrate simulation into your Six Sigma and Quality methodology.
Forecast Charts
Graphically display simulation results and statistics. Allows users to track and analyze thousands of possible outcomes; charts are interactive.
Split-View charts
View forecast charts, descriptive statistics and capability metrics side-by-side on the same chart. Enable up to 6 charts and tables in one view. One chart tells the whole story.
Sensitivity and Tornado Analyses
Two separate methods for identifying the most critical model input variables. Enable users to focus on high-risk model input variables.
Distribution Fitting
Uses historical data for defining assumptions. Can fit to continuous and discrete distributions. Allows users to customize model input variables based on real-world results.
Correlation
Models dependencies between uncertain input variables. Provides more accurate modeling and forecasting.
Charting and Reporting
Automates report generation, includes the ability to overlay forecasts and to project trends through time. Creates clear analysis and presentation of all forecasts, improves communication with colleagues, management, and clients.
Precision Control
Provides advanced simulation capabilities. Increases simulation accuracy and flexibility; saves time.
Latin Hypercube Sampling
Alternative simulation method to Monte Carlo. Samples regularly across distribution, excellent for simulations with restriction on number of trials.
Data extraction
Exports data from Crystal Ball memory. Allows users to examine individual simulation results and transfer results to other software programs.
CB Tools
Macro-driven tools that use Crystal Ball; Includes scenario analysis, decision table, data analysis, tornado chart, correlation matrices, 2D-simulation, batch fit, and boot strap. Automates modeling processes with effortless and powerful tools.
CB Predictor
CB Predictor uses established forecasting methods to help identify and extrapolate the trends in your historical data. CB Predictor analyzes your data and produces insightful and accurate forecasts.
Crystal Ball and CB Predictor Developer Kits
The Crystal Ball and CB Predictor Developer Kits bring complete automation and control to these tools from within a Visual Basic for Applications (VBA) program or any other language outside of Excel that supports OLE 2 automation.
Microsoft Certification
Certified Excel macro provider. Eliminates security concerns.