Project Management

A Template for Setting Up Your Qualitative Risk Analyses

From the Risk & Reward Blog
I'm a risk enthusiast who likes to discuss techniques, tools and models—and use risk as a practical means to make better decisions in project environments. Join me on the ride!

About this Blog


Recent Posts

The Risk of Changing in Risk Management

(mis)Understanding Contingency

Monty Hall for Projects: To Switch or Not to Switch?

10 Wishes for your Project Risk Management adventures in 2019!

The Curse of the Moving Mountain

Hey everybody!

just posting to let you know my first template upload is available on It is located here and it is a tool intended for us to conceive a risk register and structure a probability scale, an impact scale and an overall qualitative mapping.

Begin by stablishing your probability scale. Very straightforward, and you can have as low as 5 and as much as 7 levels of probability to be assigned.

Moving on to impact, I added some room for using different scales, so you can have a schedule dimension with four leves (say very low, low, medium and high) and a cost dimension with three (low, medium and high) and you can work these things together in the spreadsheet.

In a severity sheet, you can see the probability x impact severities resultiing from the several dimensions of impact you used on the impact scale. As I mentioned on my article on the risk ruler, I am using an additive way for obtaining the scores, i.e., I am multiplying the probability of the event by the various impacts on each dimension.

There is a sheet called register, with some columns to fill in the description and assess the probability and impacts, as well as planning for mitigation and its impact on the aforementioned components of the severity. There is also a possibility to plot the results in a graph.

I hope you guys like it, your feedback is most welcome.

And, again, thank you for reading and joining the discussion!

Posted on: October 01, 2018 01:03 PM | Permalink

Comments (5)

Please login or join to subscribe to this item
Very interesting article, thanks for sharing

You are professional in risk management !! Thanks!!!

Interesting, I'll follow up.

Please Login/Register to leave a comment.


"Far out in the uncharted backwaters of the unfashionable end of the Western Spiral arm of the galaxy lies a small unregarded yellow sun. Orbiting this at a distance of roughly 98 million miles is an utterly insignificant little blue-green planet whose ape-descended life forms are so amazingly primitive that they still think digital watches are a pretty neat idea..."

- Douglas Adams