# RA - Star Voting Spreadsheet

Document Sample

This is a blank Excel spreadsheet that can be used for voting:
It has been designed for twelve (12) risks -- additional columns and rows may be added to the table (if there are less risks, cells may be left zero).

Risk A    Risk B     Risk C   Risk D   Risk E   Risk F   Risk G     Risk H    Risk I    Risk J    Risk K    Risk L    Total
Risk A                                     0           0        0       0        0         0          0        0         0         0         0        0
Risk B                            0                    0        0       0        0         0          0        0         0         0         0        0
Risk C                            0         0                   0       0        0         0          0        0         0         0         0        0
Risk D                            0         0           0               0        0         0          0        0         0         0         0        0
Risk E                            0         0           0      0                 0         0          0        0         0         0         0        0
Risk F                            0         0           0      0        0                  0          0        0         0         0         0        0
Risk G                            0         0           0      0        0         0                   0        0         0         0         0        0
Risk H                            0         0           0      0        0         0         0                  0         0         0         0        0
Risk I                            0         0           0      0        0         0         0         0                  0         0         0        0
Risk J                            0         0           0      0        0         0         0         0         0                  0         0        0
Risk K                            0         0           0      0        0         0         0         0         0         0                  0        0
Risk L                            0         0           0      0        0         0         0         0         0         0         0                 0

Total        0         0           0      0        0         0         0         0         0         0         0         0

Brief explanation of process (for this example, we will assume 10 people are voting):
- The user will actually fill two squares each time (based on following procedure) for a total of 10
- Take each risk across top and ask committee to compare to the vertical column
- For example, how many think Risk A is more of a risk than Risk B -- if your answer is 7, you would put 7 under column A
and then 3 under column B (in the row for Risk A)
- Continuing, how many think Risk A is more of a risk than Risk C -- if your answer is 1, you would put 1 under column A (opposite Risk C)
and then 9 under column C (in the row for Risk A)
- Continue comparing Risk A to all other risk with two enties (in the column for Risk A and in the.
row for Risk A) -- they should total 10
- This procedure will fill each row below the shaded boxes as well as those above the shaded boxes
- After all are completed, total down each column and across each row

This should give you a prioritized list of the risks.
This is a blank Excel spreadsheet that can be used for voting:
It has been designed for twelve (12) Assets -- additional columns and rows may be added to the table (if there are less risks, cells may be left zero).

Asset A Asset B Asset C Asset D Asset E Asset F Asset G Asset H Asset I                  Asset J   Risk K   Asset L    Total
Asset A                                 0       0       0       0       0       0       0      0                        0         0        0         0
Asset B                         0               0       0       0       0       0       0      0                        0         0        0         0
Asset C                         0       0               0       0       0       0       0      0                        0         0        0         0
Asset D                         0       0       0               0       0       0       0      0                        0         0        0         0
Asset E                         0       0       0       0               0       0       0      0                        0         0        0         0
Asset F                         0       0       0       0       0               0       0      0                        0         0        0         0
Asset G                         0       0       0       0       0       0               0      0                        0         0        0         0
Asset H                         0       0       0       0       0       0       0              0                        0         0        0         0
Asset I                         0       0       0       0       0       0       0       0                               0         0        0         0
Asset J                         0       0       0       0       0       0       0       0      0                                  0        0         0
Asset K                         0       0       0       0       0       0       0       0      0                         0                 0         0
Asset L                         0       0       0       0       0       0       0       0      0                         0         0                 0

Total       0         0             0   0         0         0         0         0         0         0         0         0

Brief explanation of process (for this example, we will assume 10 people are voting):
- The user will actually fill two squares each time (based on following procedure) for a total of 10
- Take each risk across top and ask committee to compare to the vertical column
- For example, how many think Asset A is more critical than Asset B -- if your answer is 7, you would put 7 under column A
and then 3 under column B (in the row for Asset A)
- Continuing, how many think Asset A is more critical than Asset C -- if your answer is 1, you would put 1 under column A (opposite Risk C)
and then 9 under column C (in the row for Asset A)
- Continue comparing Asset A to all other risk with two enties (in the column for Asset A and in the.
row for Asset A) -- they should total 10
- This procedure will fill each row below the shaded boxes as well as those above the shaded boxes
- After all are completed, total down each column and across each row

This should give you a prioritized list of the assets.

DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 6 posted: 12/14/2011 language: pages: 2