+ Reply to Thread
Results 1 to 3 of 3

Risk Matrix

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    3

    Risk Matrix

    Hi! I was wondering if someone could help me. I'm trying to create a matrix like this:
    http://www.robertsongeoconsultants.c...sues/fig3c.jpg

    I have a table like this below.
    Concept ID Risk Number
    AB1 3
    AB2 4
    AB3 3
    AB4 5
    AB5 4
    AB6 3
    AB7 4

    I was wondering is there a function that could take the Risk Number of 3 and produce a result of (AB1, AB3, AB6)
    or like a risk number of 4 and the function produces (AB2, AB5, AB7)
    So it produces all the results in a list with commas or just with a space.
    Thanks so much if anyone could help!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Risk Matrix

    what is the logic of this? if you were doing it manually, what steps would you go through?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-17-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Risk Matrix

    The table with the concept ID and risk number are different types of concept designs for a project with their associated risk assigned by the user.
    The risk being the probability that the concept has a detrimental effect to the project.
    So, a complex jet turbine engine has a high risk of 5 with a concept ID of AA2 for example.

    The risk matrix is a graphical way of showing someone all the concept designs and where they lie in terms of their risk to the project.

    http://1.bp.blogspot.com/-ciu26vJnA9...isk-matrix.gif

    As shown by the above, the concepts on the top right would be high risks while the bottom left will be low risk.

    Essentially i'm trying to figure out a way to collect all the different concepts that have the same risk, so they can be shown on this risk matrix.

    So all the medium risk concept designs are collected together (AB2, AB5, AB7) with a risk number of 3.

    These would be then shown on the risk matrix in the 3 cell.

    So a function that looks down the list and collects the concept ID's with 3 and puts them in a list.

    Im thinking more that a VBA code will be more appropriate.

    Thanks!
    Will

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1