Portfolio / Rev 2026 Mahe Mishra, home

Projects / PRJ-03

Live

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

How this is generated

Open actions

18

0 on hold

Overdue

7

+1 vs last week w/c 31 Aug: 4 overdue actions w/c 7 Sept: 4 overdue actions w/c 14 Sept: 7 overdue actions w/c 21 Sept: 9 overdue actions w/c 28 Sept: 2 overdue actions w/c 5 Oct: 5 overdue actions w/c 12 Oct: 7 overdue actions w/c 19 Oct: 7 overdue actions w/c 26 Oct: 6 overdue actions w/c 2 Nov: 7 overdue actions w/c 9 Nov: 6 overdue actions w/c 16 Nov: 7 overdue actions

Due before next meeting

1

Meeting 19 Nov

Closed to date

44

Over 28 weeks
Needs the chair's attention
Ref Action Owner Due
A015 Share commissioning plan with estates team 05.11.2026 - ESL - Restarted following board decision. Estates Lead 08.10.2026 Overdue
A028 Confirm workforce model for new outpatient service 05.11.2026 - CTL - Paper submitted to programme board for approval. Clinical Transition Lead 05.11.2026 Overdue
A041 Share interface specification with EPR supplier 05.11.2026 - DGL - Revised programme received and under review. Digital Lead 05.11.2026 Overdue
A051 Prepare briefing note for local councillors 22.10.2026 - CEL - Draft circulated for comment, responses due end of week. Communications Lead 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. Communications Lead 05.11.2026 Overdue
A057 Confirm drawdown profile with finance 05.11.2026 - FNL - Workshop held, comments being consolidated. Finance Lead 05.11.2026 Overdue

Raw data portfolio.csvraid_log.csvactions.csvweekly_history.csv

CS-02 Case study A governance tracker that carries its own audit trail Fortnightly meeting record turned into a chair-ready tracker