| Developer Kit Example Models |
The following models use the macros and functions of the Crystal Ball Developer Kit.
|
|
|
Model: Critical Path / Time to Market Analysis
From: Decisioneering (CB 5.5)
Detail: This model analyzes the process, project schedule, or time it would take to get a product to market, with the goal of understanding how uncertainty affects project completion. At the bottom of the Model worksheet, a diagram depicts the flow pattern of the tasks. In terms of Six Sigma, the defect may be defined as the difference between the actual project completion time and the minimum project completion time. The results of this model indicate the likelihood that any particular task will be on the critical path, and the model can then be used to evaluate which pivotal tasks should be addressed to improve the results for the entire project. |
 Download
For:
Crystal Ball
Level:
Moderate |
|
|
Model: Design for Six Sigma Model - Piston Displacement
From: Decisioneering (CB 5.5)
Detail: This model demonstrates how Crystal Ball can be used in the design phase of a project to determine the optimal specifications for production. In this case, the product is a piston assembly. The piston displacement needs to be within a certain range to meet customer requirements. The values that impact the piston displacement are defined as assumptions with the appropriate probability distributions. As a result, you can determine the likelihood of producing assemblies outside of the specification.
NOTE: This model uses macros, so choose to accept macros when you open the file in Excel. |
Download
For:
Crystal Ball
Level:
Moderate |
|
|
Model: Design for Six Sigma Model - Pressure Vessel
From: Decisioneering
Detail: The DFSS example model was designed to demonstrate the use of simulation to obtain early visibility into design performance, resulting in overall reduced costs and improved quality during the design process.
NOTE: This model uses macros, so choose to accept macros when you open the file in Excel. |
Download
For:
Crystal Ball
Level:
Moderate |
|
|
Model: Project Cost Estimation Example
From: Decisioneering
Detail: At the click of a button, this simple VBA example
defines distributions around a list of variables, defines a forecast,
runs a simulation, and exports a forecast chart to the worksheet.
You can add as many project elements as you like, and the VBA code
is provided on a second worksheet within the model. |
Download
For:
Crystal Ball & Dev. Kit
Level:
Simple |
|
|
Model: VBA Iterative Simulation
From: Decisioneering
Detail: This simple VBA example uses an iterative approach
to calculate the average minimum, 10, 20, and 30 percentiles of
the forecast. |
Download
For:
Crystal Ball & Dev. Kit
Level:
Simple |
|
|
Model: Using Simulation with Design of Experiments
From: Decisioneering (CB 5.5)
Detail: This example model studies how three variables (factors) in an injection molding process affect part length (response) and demonstrates the application of combining simulation with a designed experiment. The model uses linear regression to determine the impact of each of the factors on the response and displays the results of a designed experiment in a table on the Model worksheet. The three factors are defined as assumptions with appropriate probability distributions, and simulation of the model results in a distribution of the response and the likelihood of defective parts. You can adjust the controllable factors to minimize the production of defective parts.
NOTE: This model uses macros, so choose to accept macros when you open the file in Excel. |
Download
For:
Crystal Ball
Level:
Moderate |
|
