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
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.

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

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

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.