Solution-focused Excel Risk Log with Dashboard Template

Excel Risk Log with Dashboard and Mitigation Schedule Chart

This Risk Log template supports a Solution-focused Risk Management strategy by combining a powerful Risk Dashboard with Mitigation Data. Show HOW and WHEN your risks will be mitigated, and WHO owns them.

Risk Log Features

This Risk Log template features a range of tools to track and communicate your risk analysis. It offers the usual summarisation of each risk likelihood and impact into a combined score, and it counts the risks in various statuses so that you can get a project overview.

Crucially, it supports project leaders in planning when they are going to close the risks – the Risk Mitigation Schedule.

  1. Risk Log – a standard risk table, with filters
    1. Title – “There is a risk that …”
    2. Project Area – Which part of your project does the risk affect?
    3. Impact – How severe is the impact if the risk materialises?
    4. Likelihood – How likely is the risk to materialise?
    5. Score – How serious is the Risk? This is automatically calculated by combining Impact and Likelihood scores
    6. Impact Description – What happens if the risk materialises (i.e. becomes an Issue)
    7. Owner – Who is in charge of mitigating the Risk?
    8. Mitigation Task – How will the Risk be mitigated?
    9. Target Mitigation Phase – When will the Risk be mitigated?
  2. Dashboard – show executives and sponsors the status at a glance.
    1. Total – the total count of risks.
    2. Open – the count of risks unaddressed.
    3. Improving – the count of risks are in the process of being mitigated and are improving?
    4. Closed – the count of risks that have been closed.
    5. % Mitigated – What percentage of your project risks have been mitigated and closed?
  3. Risk Mitigation Phasing Chart
    1. Shows the cut of which severity of risks are planned for which project phase.
  4. Mitigation Pivot
    1. This pivot table provides data for the Target Mitigation Phase chart.
    2. NB when using Excel, the Pivot Table must be updated before the chart updates.
    3. When using Google Sheets, the pivot and chart are automatically updated.
  5. Owners.
    1. This is a pivot table that shows a count of risks for each owner that you have listed in the Risk Log sheet.
  6. Areas.
    1. This Pivot table counts the risks and scores by risk area.
    2. This is compiled from the entries you have created in the Risk Log sheet.
  7. Template Help.
    1. This sheet offers some simple help steps to guide you through using the template.

Automatic Risk Score Calculated from Likelihood and Impact.

Risk Log Dashboard - Score Matrix v2 with colour code

Risk Log Dashboard – Score Matrix combining Risk Likelihood and Risk Impact with colour coding

Risk Dashboard

Excel Risk Log with Dashboard and Mitigation Schedule Chart

Excel Risk Log with Dashboard and Mitigation Schedule Chart Template

This Risk Log is Google Sheets compatible

This template can be uploaded and used in Google Sheets. NB – not for free distribution – this template is only usable as per the terms of your license.

Google Docs Compatible Risk Log with Dashboard and Mitigation Schedule Chart Template

Google Docs Compatible Risk Log with Dashboard and Mitigation Schedule Chart Template

When uploading to Google Sheets, the Mitigation Scheduling chart may need to be recreated using the values in the “MITIGATION PIVOT” worksheet.

The Risk Log with Dashboard & Scheduled Mitigation Template also comes with a help worksheet.

So how do I download this now? How do you send my templates to me?

It's simple:

  1. Use the button below to "Add to cart".
  2. Click "Checkout" and use one of our secure payment options.
  3. You will then get immediate access to download your templates.
  4. Your receipt and your download links will be emailed to you.
  5. Download your templates and they are ready to use!

Your security is important to us. Find out more about our secure payment options.

Product Information

Published : | SKU: BDUK-13033

Last Updated : September 27th, 2020


Add to Cart