Crystal Ball^® 7.2.2

Release Notes

December 2006

Introduction
Crystal Ball Issues
OptQuest Issues
Crystal Ball Developer Kit Issues
Fixed in Crystal Ball 7.2.1 and 7.2.2

Introduction

Crystal Ball 7.2.2 is the current version of Crystal Ball. It has been developed to run on the Microsoft .NET Framework 1.1 with Service Pack 1, technology from Microsoft for developing secure and advanced Windows applications.

Crystal Ball 7.2 introduced new process capability features to support Six Sigma and other quality programs. It also included bug fixes and many performance enhancements. For more information on the new features see http://www.crystalball.com/cb_features.html. Crystal Ball 7.2.1 and 7.2.2 include many more bug fixes, listed below.

The following are a few known issues you should be aware of as you begin using Crystal Ball 7.2.2.

Note: If you are upgrading from an earlier version of Crystal Ball, it is also important for you to read the Crystal Ball 7.2.2 Migration Guide.

Crystal Ball Issues

Only Microsoft .NET Framework 1.1 Service Pack 1 can be used

If you have Microsoft .NET Framework 2.0 installed, warning and error messages might appear when you try to start this version of Crystal Ball. You might also find that Crystal Ball does not load at all when you start it. If this happens, choose Start > Programs > Crystal Ball 7 > Application Manager. Be sure this setting is checked in the Crystal Ball Application Manager: "Run Excel with Microsoft's .NET Framework v1.1." Then, click OK and restart Crystal Ball.

Notice that errors can result if you try to check the .NET Framework setting in the Application Manager and do not have the required permissions to make that change.

If you have not yet installed Microsoft .NET Framework 1.1 with Service Pack 1, follow the instructions in your Crystal Ball Installation and Licensing Guide, located at the root of your Crystal Ball CD or in the Docs folder under the folder where Crystal Ball is installed (by default, C:\Program Files\Decisioneering\Crystal Ball 7). The main installation document is named CB7 Install&Licensing.pdf. If your organization uses concurrent licensing, see InstallConcurrent.pdf.

For details on using Crystal Ball with Microsoft .NET Framework 1.1 with Service Pack 1, see Microsoft .NET Framework FAQs.

Extreme Speed introduced in Crystal Ball 7.1

If you are using the Professional or Premium Edition of Crystal Ball version 7.1 or later, the new Extreme Speed feature available in those editions is switched on by default. While Crystal Ball simulations run 10 to 100 times faster at Extreme speed, there are a few compatibility issues to consider.

For more information on Extreme Speed see Appendix C of the current Crystal Ball User Manual or "About Extreme Speed" in the Crystal Ball online help.

Go To button

When a calculation error occurs and a specific cell is identified, a Go To button appears in the error dialog. You can click it to move to the incompatible cell.

Extreme Speed and custom functions

Note: The following compatibility issue is not included in Appendix C of the current Crystal Ball User Manual.

In Extreme Speed, circular references with short Iteration settings (on the Tools > Options > Calculation tab) might not match Excel's because of differences in calculation algorithms. For most consistent results, set Iteration to at least 1,000.

Extreme Speed and non-English Analysis Toolpak functions

Note: The following compatibility issue is not included in Appendix C of the current Crystal Ball User Manual.

Currently, non-English names of the Analysis Toolpak functions are not supported in Extreme Speed simulations.

Certainty grabbers in forecast windows are now anchored at both ends. A grabber is anchored when users enter a value or click and move the grabber. Clicking the grabber without moving it toggles the anchor state of the grabber. Ctrl-clicking or Shift-clicking a grabber anchors or unanchors both grabbers, depending on the previous state of the clicked grabber. When both grabbers are positioned to infinity, both grabbers are unanchored. When just one grabber is positioned to infinity, the anchor state of the grabber at infinity is set to the opposite of the other grabber.

Anchoring both grabbers changes the certainty. Changing the certainty with both grabbers unanchored adjusts both grabbers centered on the median. When one grabber is anchored, the certainty value sets the free grabber’s position. When typing in a minimum or maximum certainty range, Crystal Ball sets only the location of the corresponding grabber; the modified grabber is anchored and the certainty value is updated.

Checking for updates

Users with Crystal Ball 7.1 or later can now use the Windows Start menu to check for updates and install them, if found. Choose Start > Programs > Crystal Ball 7 > Check For Updates. Users of earlier versions of Crystal Ball must go to www.crystalball.com and click the Downloads link to install the latest upgrade.

Minimum value is used for bimodal medians

When discrete probability distributions, such as Yes-No, have two median values, the displayed value is the minimum instead of some value interpolated between the two. The decision to compute the median this way was based on the need to preserve both the integrity of the inverse CDF calculation and the consistency between the median and 50th percentile calculations.

Restored results are not resaved with simulation results

If restored results are used with results from the current simulation – in an overlay chart, for example – the restored results are not resaved with Analyze > Save Results. When the saved results are later restored, only the results from the current simulation are restored.

Likewise, if preferences – for example, chart preferences – are set for the restored results, those preference settings are not saved either.

If an assumption's input parameter refers back to the assumption cell, the reference is static

If a cell reference refers to an assumption cell, the cell reference is replaced by the base value (value at the start of the simulation) for the duration of the simulation. This makes the cell reference static.

Upgrading Windows XP to Service Pack 2 removes Crystal Ball from the list of installed programs

If a user with local administrative privileges installs Crystal Ball on a Windows XP machine, and then an administrator with domain administrative privileges upgrades the system to Windows XP with Service Pack 2, Crystal Ball will be removed from the Start menu and disappears from the list of installed programs in the Add/Remove Programs dialog.

Error installing Crystal Ball 7.2.2 on Windows 2000 with Office 2003 and no Service Pack 1

If a user attempts to install Crystal Ball 7.2.2 on a Windows 2000 machine with Microsoft Office 2003 installed without Service Pack 1, Internal Error 2870 appears and the installation fails. This happens only with English and Spanish versions of Crystal Ball 7.2.2. To avoid this error, install Service Pack 1 for Microsoft Office 2003 and then install Crystal Ball.

"System clock set back" errors

If a computer's system clock is set back at some point to a date earlier than the current date, Crystal Ball's sophisticated licensing system recognizes this. When you try to start Crystal Ball with a time-limited license under these conditions, startup fails and a "system clock set back" message appears. Under some system clock conditions, a "license not found" message appears and a checkout error is written to the Crystal Ball log file. The reason that a license file cannot be found can also be determined by clicking on the View Existing License link in the Welcome screen of the CB License Manager. A dialog states why the license cannot be found -- whether it be a system clock error, feature start date in the future, and so on.

Issues with preferences and the memory warning dialog

If you run an Extreme Speed simulation multiple times on a large or complex model, you might find that you receive the "Sufficient memory may not be available..." warning dialog. This dialog lets you disable the Store Assumption Values run preference and change the number of trials to run. Notice that these changes in the warning dialog reset those preferences in the Run Preferences dialog on the Trials and Options tabs. They are then applied to other models unless you reset them after the large model has run.

Restored results with capability metrics

The following rules apply when you calculate capability metrics, store the results in a .cbr file, and then restore the results:

1. The restored results use the preference settings on the machine where the results are restored, which might be different from the settings when the original simulation was run and stored.
   
2. Crystal Ball refits the data when the results are restored, so results might differ somewhat from the original results.

Incompatibilities when running models in earlier versions of Crystal Ball 7.x

Certain Crystal Ball distribution types are not compatible with pre-7.1 versions of Crystal Ball 7.x. For example, if you create a model in Crystal Ball 7.2, 7.2.1, or 7.2.2 that includes linked custom distributions, #NUM! appears in the assumption cells when you run a simulation in Crystal Ball 7.0 at Normal Speed with the following custom distribution types: continuous range, discrete range, sloping continuous range, and sloping discrete range.

LOOKUP functions can affect speed

Crystal Ball now supports LOOKUP functions in both Normal and Extreme Speed. However, if you use more than a thousand in a model, this can slow down the initial parsing time and cause the simulation to run slowly.

Overlay chart probability data can be inaccurate for series with less data

Overlay chart data are attached to the frequency axis of the chart, not the probability axis. For this reason, probability data can be inaccurate for all series except the one with the most data.

Extract Data information might not be accurate for the last bin

If you choose the Chart Bins statistic in the Extract Data dialog, information for the last (rightmost) bin might not be accurate. Crystal Ball determines bin location by evaluating whether data is equal to or greater than the minimum and less than the maximum for each bin. If data is equal to the maximum for the highest bin, it is not counted.

Installing and removing Crystal Ball 7.2 prevents the use of Crystal Ball 5.5

If you have been using Crystal Ball 5.5 on a computer where Crystal Ball 7.2 was also installed, removing Crystal Ball 7.2 (as part of the upgrade to Crystal Ball 7.2.2, for example) prevents Crystal Ball 5.5 from starting. To restore full functionality to Crystal Ball 5.5, uninstall it and install it again. Then Crystal Ball 5.5 should co-exist and work with Crystal Ball 7.2.2 when that version is installed.

Using Crystal Ball with multiple versions of Excel installed

Crystal Ball always runs against the default version of Excel, which is typically the most recently installed version of Excel. To run Crystal Ball with another version of Excel, open Windows Explorer and select Tools > Options. Then, in the Folder Options dialog, select the File Types tab and make sure that you set the XLS extension so that it opens with the appropriate version of Microsoft Excel.

If these instructions do not work, perform a Repair on the installation of Excel that you want to be the default version. That is, if Excel 2003 and then Excel 2007 are installed on a machine and you want Excel 2003 to remain the default version of Excel, perform a Repair on Excel 2003. Once the Repair is complete, Excel 2003 should start when you select Crystal Ball from the Start menu.

OptQuest Issues

OptQuest files are not always saved on request

Whenever you modify values or settings in the OptQuest wizard or other dialogs, always click the OK button to ensure that information will be saved in the .opt file.

OptQuest won't work properly if an Excel cell is in Edit mode

If you try to run OptQuest when a cell in Excel is being edited, OptQuest doesn't perform as expected. Be sure to either press Enter to accept your edits or leave the active cell without changing it before you attempt to run a simulation with OptQuest.

Crystal Ball Developer Kit Issues

Several new calls have been added to the Crystal Ball Developer Kit for this version of Crystal Ball. For a list, see Appendix B of the current Crystal Ball Developer Kit User Manual. Then, see Chapter 2 for a description of each new call.

Crystal Ball Developer Kit User Manual is now available online

If you have purchased the Crystal Ball Professional Edition or Premium Edition, you can download the Crystal Ball Developer Kit User Manual directly from Decisioneering's Web site. To do this, start Crystal Ball. Then, choose Help > Crystal Ball > Crystal Ball Developer Kit. A page with a Download link appears in your browser. If you don't have a Crystal Ball Professional or Premium license, an error message appears instead.

Always use CB.CheckData before a CB.Get... call

To ensure that data is properly synchronized, always call CB.CheckData immediately after you insert, delete, move, or otherwise edit cells in a model, particularly before you use one of the CB.Get... functions.

   CB.ExtractDataND cbExtDataType, cbDatStatistics, True
   CB.ExtractDataND cbExtDataType, cbDatValues, True
   CB.ExtractDataND cbExtOK

Issues with CB.DefineAltParms and CB.GetAssum

There are problems in defining and updating assumptions with lognormal distributions with alternate parameter sets created by the CB.DefineAltParms call. For example, if you are defining a lognormal distribution assumption with the log mean and log standard deviation, the low cutoff value or high cutoff value is being assigned to the mean and standard deviation.Workarounds are to avoid cell references; pass in the actual values for the parameters rather than cell references. Also, consider using the DefineAssumND call to define means and standard deviations.

Fixed in Crystal Ball 7.2.1 and 7.2.2

The following are some of the more important errors that were fixed in Crystal Ball 7.2.1 and Crystal Ball 7.2.2. Some of these defects include others that were originally logged under different numbers.