← All projects

Concept · Build · Operate

Resource Planning Dashboard

Models every staffing event as a discrete record and re-aggregates the workforce shape on demand. Turns the WhatsApp-truth that project controls quietly maintains into the official truth, without losing the audit trail.

Stack
HTML SPA, IndexedDB, Day.js
Outcome
Sub-second recompute on full workforce reconciliation
Year
2026

What it does

Most workforce histograms in EPC project controls are wrong by ten to twenty percent on any given day, because the underlying spreadsheet cannot reconcile a transfer, a leave event, an absence, and a project move that all happened in the same fortnight. The dashboard models each of those as a distinct event against a resource record, then re-aggregates in real time.

Features that matter

  • Period reconciliation — set any start/end window, get the live count with full event audit trail
  • S-curve forecast — projected build-up against the approved manning curve
  • Sticky-right action column — every register row has Edit and Revoke inline, no modal cascade
  • Calm dashboard treatment — fast, quiet, no chartjunk

Why this works

Project Controls teams keep two truths: the official manning plan, and the WhatsApp group. The dashboard makes the WhatsApp group authoritative without losing the audit trail.