Common problems |
This page in 2007 Top Previous Next |
|
Map Workbook gives incomplete result This is a limitation of Excel, not OAK. It is discussed further under known limitations. Compare gives incomplete result This is a limitation of Excel, not OAK. It is discussed further under known limitations. Formula | Reconstruct delivers fewer levels of This behaviour is by design and is discussed in the article called Mixed levels within OAK Concepts The Confine to Active Path option option on the This option is only offered if the selection consists of a single cell. Formula | Prune makes no change to a formula OAK4 | Formula | Prune will turn the formula =IF(A1>B2,C3,D4) into either =C3 or =D4, depending on whether A1 is bigger than B2 or not. In order to know which option to take, OAK has to evaluate the logical expression A1>B2. If that results in an error, OAK will be unable to make a choice. The error is most likely to be the legitimate consequence of the values that happen to be in the spreadsheet; A1 or B2 could be #DIV/0, it could be due to limitations of Excel when asked to evaluate the expression, or a defect in OAK. Whatever the cause, OAK will do nothing, leaving the formula unchanged. USING OAK WITH CRYSTAL BALL Crystal Ball is a popular add-in to Excel that performs Monte Carlo simulations. It was manufactured by Decisioneering, which was acquired by Hyperion. Hyperion eventually became part of Oracle. Like OAK, Crystal Ball relies on Microsoft's .NET framework. OAK uses version 2, and takes precautions to overcome the bias of versions of Excel before 2007 to stick to .NET 1.1. Some versions of Crystal Ball do the opposite; they make strenuous efforts to ensure that it is a .NET 1.1 environment that is available to the product. These two approaches conflict, with the result that OAK won't work in these circumstances. The fix is simple: upgrade to the latest version of Crystal Ball. Crystal Ball release 11 is happy to work with .NET 2, and it and OAK work harmoniously together. |