ESTATES / OPERATIONS INTELLIGENCE

Work-order dashboard

Backlog, priorities, costs and data quality

Fictional training data · Reference date: 6 November 2026 · GBP

Synthetic data only. No real UCL buildings, suppliers or work orders are represented. This is an embedded snapshot, not a live connection.

Active backlog by building

Orders by status

Average recorded days open by category

Excludes missing raised dates and completed records without completion dates.

Matched estimated and actual costs

Work-order explorer

Click a column heading to sort.

Data quality

Calculation rules and limitations
  • 125 source rows contain 123 distinct work-order IDs. Duplicate IDs are removed by default, keeping the first row. Toggle this to see their effect.
  • Active means Open, In progress or On hold. Overdue means active with a target before 6 November 2026. Missing targets are excluded, not treated as on time.
  • High / critical overdue includes both High and Critical priorities. The reference date is fixed, not today's date.
  • Category normalisation trims whitespace, changes electrical to Electrical, and proposes grouping Heating / Ventilation and Air Con under HVAC. Raw labels are preserved in the table and CSV. The category filter uses these proposed groups.
  • Average recorded days open uses the supplied field, excluding missing raised dates and completed records with missing completion dates. Both active and completed orders are otherwise included.
  • Estimated total sums selected estimates. Recorded actual sums non-blank actuals, including those on active orders. Missing actuals are not assumed to be zero-cost work.
  • The cost chart uses only orders with both costs. Variance is actual minus estimate. Percentage variance divides by matched estimates, not all estimates.
  • The £245,000 estimate is retained and flagged by default. Exclude it to compare its effect. Its validity is not assumed.
  • Completion dates after the reference date are flagged as snapshot conflicts. Source statuses are retained. No historical status or missing date is invented.
  • All metrics follow filters and search. This standalone HTML contains the data and works offline. Share the file itself; recipients can download and open it in a browser.

Source: Pack3_02_Synthetic_Estates_Work_Orders.xlsx · Snapshot only · No external libraries or network requests