• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Modified Risk Map

Seahorse

Member
This is a cross post from this the Risk Map page to allow the spreadsheet to be attached.

lysenkiy says:
March 27, 2014 at 8:29 pm
Mike,
Could you post your version of the matrix please?

 

Attachments

  • Risk Register Template.xlsm
    28 KB · Views: 82
Yes, simplifies it considerably, many thanks. :)

One issue, if two projects have the same rating Say B2, only one appears in the Risk Matrix in B2.
 
Last edited:
Yes, simplifies it considerably, many thanks. :)

One issue, if two projects have the same rating Say B2, only one appears in the Risk Matrix in B2.
In the sample spreadsheet, how can you get more than one entry with same ratings to show up?

Also, if you want to see a count of the entries instead of the name, is there a way for the marker to be larger with higher counts?
 
Yes, simplifies it considerably, many thanks. :)

One issue, if two projects have the same rating Say B2, only one appears in the Risk Matrix in B2.

I have played with this some more, but I don't seem to be able to insert more than one entry with the same rating in a cell. Any suggestions please?
 
Have a look at this version, attached:
upload_2014-8-6_22-24-33.png
 

Attachments

  • Modified Risk Map Faseeh-Hui.xlsm
    20.8 KB · Views: 108
That's an elegant an simpler approach to the problem that does the job. Thank you Sir. :awesome:
On further testing, changing the status to closed or Ongoing, them populates column G with some odd answers? I have a ripping headache, and don't feel up to nesting IFs!

Correction closed does work, just ongoing, however I am going for a lie down before this headache kills me...
 
Last edited:
What combination of values is odd as it appears ok when I tested it
a Screen shot of the Risk Register page will do
 
Apologies, I was really quite ill yesterday and unable to think straight.

OK, if you change status to "On Going", Matrix coloumn is blanked and your ongoing risk dissapears from the Risk Matrix. I have added an OR to fix that.

=IF(OR(E8="Open",E8="On Going"),C8&"-"&D8,"")
 
Last edited:
Back
Top