Project Risk Register & Risk Matrix Dashboard — Excel & Google Sheets
Project Risk Register & Risk Matrix Dashboard — a plug-and-play Excel and Google Sheets template to log, score and track every project risk, with a live 5×5 heat map and a KPI dashboard that update themselves.Stop wrestling a blank spreadsheet into a risk log. This is a working risk-management system in one file: a formatted register, a colour-coded 5×5 matrix, and a live dashboard — all wired together so the moment you type a risk in, everything downstream recalculates.What you get Risk Register (the core). 25 worked example risks across generic project and business categories — supplier delays, scope creep, budget overrun, key-person dependency, data breach, regulatory change, integration failure and more. Every row scores Probability × Impact and auto-classifies the RAG band (Low / Medium / High / Critical) for both inherent and residual risk. Dropdowns for category, response (Avoid / Reduce / Transfer / Accept) and status keep your data clean. 5×5 Risk Matrix heat map. Auto-counts your open risks by Probability × Impact using COUNTIFS — no manual tallying. Every cell is colour-banded, with axis labels, a legend and the band thresholds shown. Dashboard. Live KPIs pulled straight from the register: totals by status, counts by RAG band (inherent and residual), risks by category, and a Top 10 risks by residual score. In-cell bars, not fragile charts — so it survives a Google Sheets import intact. Cover & How-to-Use tab with a 5-step quick start and a scoring legend, plus a Lists tab where you control every dropdown. Why it's different Built by a qualified professional with 25+ years of industrial and operations experience — a real working system, not an AI-farm blank grid. Formula-driven throughout — scores, RAG bands, heat map and dashboard all recalculate on their own. You fill in Probability and Impact; the file does the rest. Works in Microsoft Excel, Google Sheets and LibreOffice Calc. No macros, no add-ons, no sign-up. Instant download. Scoring bands used: Low 1–4 · Medium 5–9 · High 10–14 · Critical 15–25 (Score = Probability × Impact, 1–25).Adapt the categories, scoring bands and thresholds to your own project. A template to help you log, score and track project risks — not professional risk-management advice.
Get it → knowhubs.gumroad.com