Generate RAID Log Templates and Guidance

Creates and manages RAID logs (Risks, Assumptions, Issues, Dependencies) for project management, applying distinct discipline to each category: risk management (a 5x5 probability-vs-impact matrix from Very Low to Very High, four response strategies - avoid, mitigate, transfer, accept - proactive assessment sessions, and monetary risk valuation where possible), assumption management (target validation dates, documented impact if an assumption proves false, and stakeholder alignment), issue tracking (clear escalation paths, root-cause analysis rather than symptom-chasing, and impact categorization across business, technical, resource, and timeline), and dependency management (internal/external and hard/soft/resource-deliverable typing, critical-path linkage, and clear ownership). It produces a full standard template - a summary dashboard tallying open, in-progress, closed, and high-priority counts per category, plus a Risk Register, Assumption Log, Issue Tracker, and Dependency Matrix, each with its own column structure - and advanced additions: a 5x5 risk heat map scored as probability (1-5) times impact (1-5) banded into Low (1-6), Medium (7-14), and High (15-25) risk, and an escalation matrix defining response time and notification method by severity, from 2 hours and phone-plus-email for Critical down to one week and standard reporting for Low. Automation is covered with Excel/Google Sheets formulas (risk-score calculation, status color coding, days-overdue tracking, open-item counts) and a JSON schema for API integration - a raidLog object with per-risk id, category, probability, impact, computed risk score, owner, status, and target date.

Use it to stand up or run a project's RAID log - risk scoring and heat-mapping, assumption validation tracking, issue escalation, and dependency ownership - rather than tracking these informally in meeting notes or a generic task list.

Input is the project's identified risks, assumptions, issues, and dependencies. Output is a structured RAID log (summary dashboard plus the four category tables), a risk heat map and escalation matrix, spreadsheet formulas for scoring and status automation, a JSON structure for programmatic integration, and stakeholder-facing summary templates (key highlights, immediate action items, upcoming validations).

Templates are built for Excel and Google Sheets (formula-driven risk scoring, color coding, overdue tracking) and expose a JSON schema for API and project-tool integration, designed to plug into a project's existing planning tools rather than stand alone.

For project managers and PMOs who need a disciplined RAID process rather than an ad hoc risk list. It also covers review cadence (a weekly checklist: update item status, log newly identified items, validate assumptions, recheck risk scores, flag overdue targets, communicate high-priority items) and quality indicators to track process health - closure rate, escalation rate, risk-realization rate (how often a logged risk became an actual issue), and on-time assumption validation.

// Risk Score Calculation
=IF(AND(C2<>"",D2<>""),C2*D2,"")

// Status Color Coding
=IF(J2="Closed","Green",IF(J2="In Progress","Yellow",IF(J2="Open","Red","")))

// Days Overdue
=IF(I2<>"",IF(TODAY()>I2,TODAY()-I2,0),"")

// Summary Counts
=COUNTIF(J:J,"Open")