This is a cross post from this the Risk Map page to allow the spreadsheet to be attached.
This is great but there are a couple of changes I am struggling to incorporate. Firstly the grid needs to be 5 x 5 to support likelyhood values of:
And Impacts of:
I have added these to the Setup tab and altered column F in Risk Register Tab to:
It’s not clear to me if I need to alter the formula for column G and I have almost no knowledge of VBA to know it that needs adjusting at all.
The other aspect I would like to see changed is to make this project centric, not programme, to highlight different tasks with risks as opposed to whole projects, which would then see make this spreadsheet awesome. That said it's probably enought to change the Project column to the actual Risk.