> For the complete documentation index, see [llms.txt](https://docs.securemetrics.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.securemetrics.io/securemetrics-risk-register/excel-template.md).

# Excel Template

The data for the Risk Register Power BI Report is pulled from the Risk Register Excel Template. The Excel template is stored in a cloud location for easy automated refresh and to act as a collaborative source-of-truth. The Excel template has the following columns:

<table><thead><tr><th>Column</th><th>Description</th><th>Example</th><th data-type="checkbox">Required</th></tr></thead><tbody><tr><td>Risk ID</td><td>Unique identifier for the risk row.</td><td>M-01</td><td>true</td></tr><tr><td>Risk Description</td><td>Plain-language description of the risk.</td><td>Yes</td><td>true</td></tr><tr><td>Risk Category</td><td>Category, e.g. Endpoint Security, Cloud Security, Compliance.</td><td>08/26/2025</td><td>false</td></tr><tr><td>Date Opened</td><td>When the risk was first recorded.</td><td>08/31/2025</td><td>false</td></tr><tr><td>Risk Decision Date</td><td>When a treatment decision was made.</td><td>Implementation</td><td>false</td></tr><tr><td>Date Last Updated</td><td>Most recent modification date.</td><td>Percent of workstations covered by endpoint detection and response (EDR)</td><td>true</td></tr><tr><td>Risk Owner (Individual)</td><td>Name of the person accountable for the risk.</td><td>Endpoint Security</td><td>false</td></tr><tr><td>Inherent Risk Probability</td><td>1–5 scale text, e.g. <code>4 - Likely</code> (see Section 7).</td><td>Implementation of EDR</td><td>false</td></tr><tr><td>Inherent Risk Impact</td><td>1–5 scale text, e.g. <code>5 - Severe</code> (see Section 7).</td><td>Number of workstations covered by EDR / Total workstations</td><td>false</td></tr><tr><td>Target Risk Probability</td><td>1–5 scale text. Probability after planned controls.</td><td>0.95</td><td>true</td></tr><tr><td>Target Risk Impact</td><td>1–5 scale text. Impact after planned controls.</td><td>14</td><td>true</td></tr><tr><td>Risk Response Type</td><td>One of: <code>Mitigate</code>, <code>Accept</code>, <code>Transfer</code>, <code>Avoid</code>.</td><td>Mitchell Telatnik</td><td>false</td></tr><tr><td>Risk Response Controls</td><td>Free-text description of the planned controls.</td><td>CrowdStrike, CMDB</td><td>false</td></tr><tr><td>Risk Response Due Date</td><td>Deadline for the response action.</td><td>Percentage</td><td>true</td></tr><tr><td>Cost of Mitigations</td><td>Estimated cost in your currency unit.</td><td>Higher</td><td>true</td></tr><tr><td>Compensating Controls</td><td>One of: <code>Full</code>, <code>Partial</code>, <code>None</code>.</td><td>02/15/2026</td><td>false</td></tr><tr><td>Residual Risk Probability</td><td>1–5 scale text. Actual probability after controls.</td><td>Not driving actionable value</td><td>false</td></tr><tr><td>Residual Risk Impact</td><td>1–5 scale text. Actual impact after controls.</td><td></td><td>false</td></tr><tr><td>Risk Status</td><td>One of: <code>Open</code>, <code>Closed</code>.</td><td></td><td>false</td></tr><tr><td>Notes</td><td>Free-text additional notes.</td><td></td><td>false</td></tr></tbody></table>

### Adding Columns

You can additional columns to the end of the table to capture additional details related to risks. When loaded into the Power BI Template, these columns will carry through into the data model for you to use, however they will not appear as a filter or in visuals out of the box and must be customized.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.securemetrics.io/securemetrics-risk-register/excel-template.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.