October 2006
Author David Apgar to Deliver Conference Keynote
David Apgar, author of Risk Intelligence: Learning to Manage What We Don’t Know, will deliver the keynote address at the 2006
Palisade User Conference:
Americas in Miami. The event is
being held at the Ritz Carlton
Coconut Grove on November
13-14, and Apgar will speak on
the first day of the conference.

continue below

Seminar Schedule
:: Regional Seminars
Risk and Decision Assessment Training using @RISK and the DecisionTools Suite
November 6-7, San Jose
December 4-5, Chicago
December 11-12, Houston

:: User Conference Americas
November 13-14, Miami

:: Live Web Training
Risk and Decision Assessment Training using @RISK, Part I
October 30-31
December 14-15

Risk and Decision Assessment Training using @RISK, Part II

November 2-3
December 18-19

full schedule and registration

Ask Amy
Expert Answers to
Technical Questions

Dear Amy,

I love @RISK’s unlimited modeling capacity. However, Excel’s current column limits are impacting the correlation matrix I want to build in @RISK. How can I set up a correlation matrix that exceeds the 256-column limit in Excel?

— V.G.

Dear V.G.,

Rebuilding the structure of the matrix allows you to use a larger correlation matrix with @RISK. Below is a description of how to rebuild and “stack” the matrix.

continue below

Ask Amy continued from above

Note: If you have a version earlier than @RISK 4.5.3, you may need to install a patch that makes @RISK recognize the stacked matrix. To obtain this patch, click here.

To rebuild the matrix, take the following steps:

1. Break your original matrix up into smaller blocks.
Move from left to right breaking up the matrix into smaller blocks. The number of columns in the blocks should be less than the column limit in the version of Excel that you’re using. Each block should have the same number of rows as the original matrix. Make as many of the blocks the same size as possible.

For example, when using @RISK with Excel 97 or higher, work within a limit of 256 columns. With a 400 x 400 correlation matrix, break it up into 2 blocks, each with 400 rows and 200 columns. A 789 x 789 correlation matrix could be broken up into 3 blocks with 789 rows and 750 columns and one block with 789 rows and 39 columns.

2. Stack the blocks vertically to create a new matrix.
Move from left to right placing each block under the one before it. The second block will be placed under the first block, the third block will be placed under the second block and so on. If there is one block that has fewer columns than the other blocks, the smallest block should always be placed at the very bottom of the stack.

3. Add RiskCorrmat.
Once the matrix has been rebuilt and entered into your workbook, the final step is to add the RiskCorrmat function directly to the cells containing your inputs. In your Excel workbook, add the RiskCorrmat function directly to each cell containing the input functions that you wish to correlate. The syntax for the RiskCorrmat function is:

RiskCorrmat (matrix cell range, position, instance)

Note: The matrix cell range reference must be rectangular; it can’t have an irregular shape. If you end up with one section of the matrix that has fewer columns than the rest, make the matrix cell range reference rectangular by including empty cells in the reference.

full KnowledgeBase article with example spreadsheet model
KnowledgeBase articles about Palisade Software

Visit http://www.palisade.com
E-mail comments or suggestions to: sales@palisade.com
2006 Palisade Corporation, 798 Cascadilla Street, Ithaca, NY 14850 USA