Solved

Risk matrix

Posted on 2015-01-08
7
84 Views
Last Modified: 2015-01-31
I'm working on summarizing a risk register into a risk chart and having issues with the counting the number of probability and impact numbers and having them show up in the right spaces on the summary chart.

Should I use a vlookup?

If the prob is 1 and the impact is 1, then a number 1 should show up in the correct grid, but how do I do them individually and then summarize from the risk register.
0
Comment
Question by:ckwillGWU
  • 3
  • 2
7 Comments
 

Author Comment

by:ckwillGWU
Comment Utility
0
 
LVL 12

Assisted Solution

by:FarWest
FarWest earned 500 total points
Comment Utility
I think you can use pivot table to make summaries and counts of risks for each project (one pivot  table will make them all) and do vlookup from the table to project and total summaries.

in "team" means "project" in risk register?
0
 

Author Comment

by:ckwillGWU
Comment Utility
Yes, team and project are the same. I can't see a clear picture on how to use a pivot table to do this.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 50

Expert Comment

by:teylyn
Comment Utility
Hello,

Assuming that PF means PMO in the register and assuming that you only want to count open and closed,  you can do this:

1. On the Risk Register, remove all empty rows.
2. Click in the Risk Register, then Insert > Pivot Table
3. In the Pivot table field pane drag "Team" to Column Labels
4. Drag "Status" to Row Labels
5. Drag "Status" again to Values.

cheers, teylyn
0
 
LVL 12

Accepted Solution

by:
FarWest earned 500 total points
Comment Utility
please check this with a sample
please note that a column is added to the register to present one value for both prop and impact
to have count for distinct values
Risk-Register2-Pivot.xlsx
0
 

Author Closing Comment

by:ckwillGWU
Comment Utility
This response was partially answered, but probably too much to be done on one question. I will do more research and testing. Thank you all.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now