Projects / PRJ-03
Governance action tracker and dashboard
The fortnightly action tracker for an enabling works governance group, built so every row carries its own audit trail and the chair sees what lands before the next meeting.
- Ref
- PRJ-03
- Status
- Live
- Data
- The live tracker runs inside the programme. The public version runs on the synthetic actions table.
- Stack
- Excel · Power Query · Power BI · SharePoint
- Last updated
- 02 Nov 2026
What it does
The enabling works governance group on the programme meets every fortnight. After each meeting I turn the record of the discussion into updates on the master action tracker, and the chair reviews it before it goes any wider.
The value is not the spreadsheet. It is the set of rules that make the spreadsheet trustworthy when twenty people are reading it.
The rules
- One row per action, sequential IDs, never reused.
- Updates newest first. Each line is dated and initialled, so the cell is its own audit trail and nobody has to ask what happened last time.
- Status lives in its own column with a fixed colour for each state. It is never written into the narrative.
- Dates live in their own column too. A due date turns red when it falls after this meeting but before the next one, so the chair sees what will land before the group meets again.
- A new action needs one owner and one deliverable. Escalations, chases and clarifications fold into the existing action as an update rather than spawning a new row.
- Ownership follows the work. If the meeting shows someone else driving an action, the owner column changes, whatever the original description says.
- Short updates. Ten to twenty words, the fact and the next physical step, nothing else.
The dashboard layer
The tracker answers “what is the status of A042”. The dashboard answers the questions the chair actually asks across the whole list. Which owners are carrying the most open actions, which actions have been rolled forward meeting after meeting, and what is overdue. The public version below runs on the synthetic actions table, which follows the same rules.
Live snapshot
Synthetic data, regenerated every Monday
Halden Vale Health Campus Programme
As at Mon 16 Nov 2026 · Week 28 · 9 projects
Open actions
18
Overdue
7
Due before next meeting
1
Closed to date
44
| Ref | Action | Due |
|---|---|---|
| A015 | Share commissioning plan with estates team 05.11.2026 - ESL - Restarted following board decision. | 08.10.2026 Overdue |
| A028 | Confirm workforce model for new outpatient service 05.11.2026 - CTL - Paper submitted to programme board for approval. | 05.11.2026 Overdue |
| A041 | Share interface specification with EPR supplier 05.11.2026 - DGL - Revised programme received and under review. | 05.11.2026 Overdue |
| A051 | Prepare briefing note for local councillors 22.10.2026 - CEL - Draft circulated for comment, responses due end of week. | 05.11.2026 Overdue |
| A052 | Draft site hoarding messages for review 22.10.2026 - CEL - Survey booked, results to come back to the next meeting. | 05.11.2026 Overdue |
| A057 | Confirm drawdown profile with finance 05.11.2026 - FNL - Workshop held, comments being consolidated. | 05.11.2026 Overdue |
Raw data portfolio.csvraid_log.csvactions.csvweekly_history.csv