Crystal Ball 7.1 Reins in Uncertainty
Decisioneering's Crystal Ball 7.1 eliminates the excuses for getting along without a probabilistic add-in to Microsoft Excel.Its been 10 years since IT gadfly Stan Kelly-Bootle called the PC spreadsheet "the Uzi of creative corporate accounting," but too many decisions are still being made on the basis of point-value estimates at the hopeful end of the error range. Decisioneerings Crystal Ball 7.1, released earlier this spring, eliminates the excuses for getting along without a probabilistic add-in to Microsoft Excel. The 7.1 updates Extreme Speed option imposes limits on a users uncertainty models. It cant be used when a model spans multiple linked workbooks, although it can handle multiple worksheets in a single workbook file.
There are also restrictions on user-defined functions if Extreme Speed compatibility is desiredbut for the majority of models, the option lives up to its name. It accelerated my simple earnings-forecast scenario to run 100,000 trials in just a few seconds.