One question, before and after
Monday. A simple question from the top.
Ben has three systems, three exports and until Thursday.
From: Chief executive
“How many repairs are overdue, by ward? I need it for Thursday’s committee.”
Downloads
- housing-export.csv
- contractor-portal-jobs.xlsx
- finance-late-invoices-v3.xlsx
Ward lookup
- Three systems, three ward lists
- One spells it Northfields
Three departments, three different numbers.
The committee hears “we’ll come back to you”.
- HSGHousing system412
- CTRContractor portal538
- FINFinance, late invoices467
Now there is one number, by ward.
Every system feeds one place, with one agreed meaning of overdue.
Overdue today
471, one definition
Furthest behind
Northfield, 96
Answered in the meeting.
Ben spends Thursday on why Northfield is behind, not on exports.
An illustrative council, based on our data work.
- Overdue repairs→ 471Refreshed 06:00 daily
- By ward→ Northfield highestTwo contractors short
- Housing, finance, contractors→ Same figureOne definition
Committee question
Answered from the dashboard during the meeting.
Hours on spreadsheets: 0One source
From: Chief executive
“How many repairs are overdue, by ward? I need it for Thursday’s committee.”
Downloads
- housing-export.csv
- contractor-portal-jobs.xlsx
- finance-late-invoices-v3.xlsx
Ward lookup
- Three systems, three ward lists
- One spells it Northfields
- HSGHousing system412
- CTRContractor portal538
- FINFinance, late invoices467
Overdue today
471, one definition
Furthest behind
Northfield, 96
- Overdue repairs→ 471Refreshed 06:00 daily
- By ward→ Northfield highestTwo contractors short
- Housing, finance, contractors→ Same figureOne definition
Committee question
Answered from the dashboard during the meeting.
Hours on spreadsheets: 0One source