Case 01 / Software

Handover Tracking System

One screen that shows where each of the 381 handover bundles stands, who it is waiting on, and how long it has been there.

Role
Designer and developer
Used by
Project team, Al Masjid Al Haram Expansion
Scope
381 bundles
Built with
HTML, JavaScript, Excel import and export, Claude API

The review chain it follows

Every bundle moves through the same sequence of notifications, reviews and site steps, each with an agreed duration. The tracker holds those durations, so a delay shows up as days over standard instead of a feeling that something is late.

MOFNotificationstart
MOFHLGA issued3 days
AuthorityReply to contractor2 days
ContractorSite visit1 day
AuthoritySite observation report4 days
AuthorityReply to contractor2 days
ContractorApprove or rejectdecision

What it does

  • All bundles in one list, filterable by status, zone and report type (HLGA or site observation).
  • Bulk update from Excel. Drop the latest status file and every bundle updates at once.
  • Single-bundle update with a new status, a decision owner and a note.
  • Email parsing. Paste the text of an email and the app proposes the bundle changes; the user confirms them.
  • Follow-up view by month and notification date, with counts of late, rejected and signed bundles.
  • Rejected bundles and bundle notes kept in their own views.
  • Reports. Status distribution, completion rate, work by zone and a printable status report.
  • Acceptance minutes and documents tracked alongside each bundle, with Excel export of everything.

Screens

Bundle trackerIllustrative data
150Signed
120In review
78Awaiting authority
33Not inspected
BundleStatusSite obs.HLGADays
Bundle 014SignedDoneIssued31
Bundle 027In reviewDoneIssued18
Bundle 053Awaiting authorityDonePending96
Bundle 088Not inspectedPendingPending7
Bundle list. Illustrative data, not project figures.
Screenshot slotReplace with a capture of the real tracker using demo data or blurred names.
Follow-up view. Late, rejected and signed counts by month.
Screenshot slotExcel bulk-update screen.
Bulk update. One file updates every bundle.
Screenshot slotCharts and printable status report.
Reports. Status distribution and completion.

The sequence above is shown with roles, not names. Durations are the agreed standards used in the tracker.