Project Decision Log (Construction) — Executive Dashboard + Connected Registers (Excel)
The Project Decision Log is a complete, construction-ready Excel system built for Construction Project Managers, General Contractors, Owner’s Reps, and project teams who need one place to control decisions, approvals, risks, change orders, actions, and supporting documentation.
Instead of losing critical approvals inside emails, meeting notes, and scattered trackers, this workbook gives you a single structured decision governance system: every decision is logged with impact, linked to risks and change orders, assigned into action items, tied to meetings and documents, and rolled up automatically into an Executive Dashboard for real-time visibility.
What this template helps you control
✅ Decision governance (end-to-end)
Log each decision with: owner/approver, status, deadlines, cost impact, schedule impact, risk level, linked change orders, supporting documents, and rationale.
✅ Real-time executive visibility
The dashboard consolidates decision health into KPIs and charts (counts, status distribution, category/priority breakdown, risk levels, trends, and budget variance).
✅ Risk management linked to real decisions
Risks are tied to decision IDs, scored (Probability × Impact), prioritized, assigned to owners, and tracked through mitigation + contingency.
✅ Change orders + budget impact connected
Change Orders and Budget Impact entries link back to decision IDs (and CO numbers), allowing full traceability from “why we changed” to “how much it cost” and “what it did to the schedule.”
✅ Action items with accountability
Every action has an owner, due date, status, % complete, dependencies, blockers, and deliverables—so decisions actually get executed.
✅ Meeting minutes that connect to decisions
Record decision meetings, attendees, what was agreed, action items assigned, and follow-ups—then link them to decision IDs.
✅ Document control and audit trail
Track each supporting document with revision, issued/received, location/path, review requirement, review dates, and superseded versions.
✅ Issues and lessons learned (continuous improvement)
Capture project issues with resolution + impact, and convert outcomes into lessons learned with root causes and recommendations.
Included sheets (what you get)
✅ Executive Dashboard
A management-ready dashboard that automatically visualizes:
- Total decisions, open risks, action items, and budget variance
- Decision status distribution and action item status distribution
- Category & priority breakdown, risk level distribution
- Monthly decision trend and budget variance by category
- A KPI summary table (cycle time, open critical decisions, mitigation rate, schedule adherence, etc.)
✅ Decision Log (Master Register)
Your central source of truth with full decision details and traceability:
- Category, phase, priority, status
- Decision maker, approvals, dates, deadlines
- Cost and schedule impacts + impact level
- Linked risk IDs, linked change orders, and supporting docs
- Notes/rationale and last updated tracking
✅ Risk Register
Decision-linked risk scoring and response management:
- Probability, impact, risk score, risk level
- Risk owner, mitigation strategy, contingency plan
- Status, review dates, residual risk, notes
✅ Issue Tracker
Track operational issues and confirm closure:
- Linked decision, owner, due date, status, resolution date
- Escalation flag + impact on cost/schedule
✅ Change Orders
Track scope/cost/schedule changes with approvals:
- Original vs revised cost, cost variance
- Original vs revised schedule, schedule variance
- Approval level, approved by/date, supporting docs, status
✅ Budget Impact Tracker
Budget transparency for decision-driven cost movement:
- Original budget, approved changes, revised budget
- Actual cost, variance ($) and variance (%)
- Contingency used, funding source, approval date, health + notes
- Built-in budget summary totals
✅ Timeline Tracker (Milestones & Schedule Impact)
Milestone tracking tied to decision IDs:
- Original vs revised dates, variance days
- Actual dates, % complete, health
- Critical path flag, dependencies, responsible, blockers, notes
✅ Action Items Tracker
Execution layer for decisions:
- Priority, owner, trade/department
- Due date, status, % complete, completion dates
- Blockers, dependencies, deliverables, notes
✅ Meeting Minutes Log
A structured meeting record with decision traceability:
- Meeting details, attendees, decisions made
- Linked decision IDs, action items assigned, next meeting date, attachments/notes
✅ Stakeholder Register
Stakeholder mapping + communication controls:
- Influence/interest levels, engagement strategy
- Communication frequency, preferred channel
- Key concerns, decision authority, status, notes
✅ Approval Matrix
A ready reference for decision authority:
- Approval levels by category and cost threshold
- Escalation path, max response time, documentation required, notification lists
✅ Lessons Learned
Convert outcomes into reusable knowledge:
- What happened, what went well, what to improve
- Root cause + recommendation + applicability + impact rating + status
✅ Document Register
Document control with revision history and review workflow:
- File location/path, review required, review date
- Superseded-by tracking + notes
✅ Instructions + Dropdown Lists + Chart Data (backend)
- Clear user guidance
- Standardized dropdowns for consistency
- Dedicated chart data ranges powering the dashboard visuals
Why this works in real construction environments
✅ One source of truth for governance: decisions, risks, actions, budget, schedule, and documents
✅ Traceability: Decision ID becomes the “thread” linking everything together
✅ Executive-ready reporting without rebuilding weekly slides from scratch
✅ No-macro Excel workflow (formula-driven + dropdowns + structured registers)
✅ Audit-friendly: who decided what, when, why, impact, approvals, and proof documents
How to use it (simple workflow)
✅ Step 1: Enter decisions into the Decision Log (Decision ID is your anchor)
✅ Step 2: Link risks, issues, COs, and budget lines using the Linked Decision field
✅ Step 3: Assign execution work in Action Items and record outcomes in Meeting Minutes
✅ Step 4: Track documents in Document Register and approvals in Approval Matrix
✅ Step 5: Review the Executive Dashboard for current status, trend, and budget/schedule impact
