Overview
The Problem
Tracker Journey
Dashboard Journey
How It Works
Hub View
Employee Productivity
Timeline & Delta
Dashboard Deep Dive
The Vision
Value by Role
What’s Next
Closing
1 / 11
scroll or use arrow keys
Hub Operations Suite · v3.9.1

One file.
Full sort visibility.

A self-built, browser-native operations tool that unifies iGate scan metrics, SOR staffing data, CURE cube scoring, and SEAS reporting into a single file — live, during the sort, with no installation required.

US-CHEMA · Twilight Sort iGate · SOR · CURE · SEAS Tracker + Dashboard + Home
Built by Rafael Almeida · Employee 6068314 · CHEMA Twilight

Flying blind during the sort.

Before this tool existed, supervisors at every level were operating on lagging information, gut feel, and end-of-night surprises.

01

No live unified view

iGate, SOR, and CURE lived in separate systems with no single place to see the full picture mid-sort. Decisions were made on partial data or none at all.

Result: late interventions, missed targets
02

Data fidelity was invisible

When coordinators punched borrowed employees late or scanners used the wrong ID, there was no way to see the drift in real time. Errors only surfaced after the sort.

Result: PPH and hours totals you couldn’t trust
03

No institutional memory

Each sort was an island. Without historical snapshots across nights and weeks, it was impossible to distinguish a one-off bad night from a structural trend.

Result: pattern blindness across sorts

From a single upload tab
to a full operations suite.

Every version added capability without breaking what came before. Built iteratively, sort by sort.

Phase 1
v1.0 – v1.5
Foundation. File upload, basic Hub KPIs, iGate scan metrics, PPH color bands.
Phase 2
v1.6 – v1.10
Intelligence. CURE cube scorecard, History & Trends tabs, cross-sort heatmap, IndexedDB persistence.
Phase 3
v1.11 – v1.14
Integration. Dashboard added, Suite container architecture, Outbounds tab, Volume Reconciliation.
Phase 4
v1.15 – v1.18
Live analysis. Timeline batch upload, inferred timestamps, Net Volume Δ heatmap, 23:00 wrap window.
Phase 5
v3.9.1
Accessibility. Home landing page, role cards, sort-label sync, JSON export guidance for all levels.

Built in parallel. Merged at v3.0.

While the Tracker tracked live ops, a separate post-sort Dashboard evolved independently — growing from 8 tabs to a full analytics engine before the two tools were unified in the Suite.

Phase 1 — v1.1–v1.4
Foundation
8-tab build: Upload, Overview, Work Areas, Staffing, Misloads, LIB, Cube, Compare A/B. Drag-and-drop file routing, coord group rules (PD1–4, PD5–8, PD9–12, Primary, Smalls). Suite color palette established.
Phase 2 — v1.5–v1.9
Data Depth
SEAS Twilight integration (volume, misloads, LIB, employee data). iGate Scan Metrics added. PPH conditional formatting. Dynamic header from SOR filename. Export JSON + PDF redesigned. Employee Data tab introduced.
Phase 3 — v1.9.7–v2.0
Persistence
IndexedDB layer added (hub_ops_trends_db). Trend Analysis tab with 11 Chart.js charts. Snapshot engine captures full KPI record per sort. Smalls Data tab. Snapshot enriched for day-of-week prediction.
Phase 4 — v2.1–v2.2
Prediction & Merge
DOP Generator: weighted same-DOW rolling average of last 4 sorts (40/30/20/10%). Confidence range, coord staffing table. Simulator Accuracy chart. Embedded into Suite as v2.2 — parity target for the Tracker.
v1.1 → 8 tabs, 5 upload slots
v1.9 → iGate + SEAS + Employee Data
v2.0 → IndexedDB + Trend Analysis
v2.2 → Merged into Suite

Three sources. One file. Zero installs.

Drop your exports into the tool. Everything else is automatic.

Data sources

iGate Exports

Hub Summary & Employee Summary pulled repeatedly during the sort

Hub Summary (19).xlsx
Employee Summary (19).xlsx
SOR-US-CHEMA-...-T.xlsx
Timeline tab

Batch Upload

Drop all files at once. The tool reads the (N) suffix to order snapshots and infers timestamps from Last Scan data.

Higher N = later pull
Timestamps inferred
Live output

Full Sort View

KPIs, PPH metrics, volume delta heatmap, employee productivity, and trend charts — all populated automatically.

No manual sequencing
Data stays local
Runs in any browser
No server, no login
Data never leaves your machine
Single HTML file

Hub state at a glance.

Current Hub State — Plan vs Actual
Target Volume
15,200
DOP plan
Net Outbound
13,847
−1,353 vs plan
Gross Volume
14,290
Loose + Bags
Scan Hours
47.3
iGate total
SOR Paid Day
4.0 hrs
per person
Active Scanners
38
employees
Net Volume Δ Heatmap — by 30-min mark
Belt 18h00
base
Δ 18h30 Δ 19h00 Δ 19h30 Δ 20h00 Net Vol
PD-01 1,204 −312 +487 +623 +401 2,403
PD-03 987 +12 −198 +514 +288 1,603
PD-07 1,843 +712 +589 −44 +421 3,521
AIRSORT 2,103 +344 −421 −287 +633 2,372
SLS01 612 +201 +388 +23 −144 1,080
Drop
Gain

Every scanner. Every belt. Every number.

PPH tracked per employee, per belt, in real time. Color-coded to the same scale used across iGate’s own dashboard.

Employee PPH Summary — iGate Scan Metrics
Employee ID Belt Scans Hours PPH First Scan Last Scan
John Doe 4823917 PD-07 1,842 4.0 461 18:04 21:58
Lisa Johnson A4F8X2R9Q1 AIRSORT 2,103 4.2 501 18:01 22:14
Sarah Chen B7K3M5N2P8 PD-07 1,543 4.1 376 18:07 22:02
Michael Torres 9012847 PD-11 1,387 4.0 347 18:03 21:59
Jane Smith C9R4T6W1Y5 PD-01 1,204 3.8 317 18:09 21:53
Priya Patel D2H7K9N4Q6 PD-09 1,122 3.9 288 18:22 22:01
Marcus Williams 5104382 PD-03 987 3.5 282 18:31 21:47
David Rodriguez 6789023 PD-05 743 3.2 232 18:44 21:38
350+ Elite 300–349 Strong 280–299 Developing <280 Needs attention

Watch the sort unfold in real time.

Net Volume Progression — 05.04.26 Twilight
18:00
1,840
18:30
4,280
19:00
6,870
19:30
9,440
20:00
11,890
20:30
13,420
21:42
13,847

No manual sequencing

Drop all 20 Hub Summary and Employee Summary files at once. The tool reads the (N) suffix and infers timestamps from Last Scan data automatically.

Delta view per belt

Instead of raw volume, the heatmap shows how much each belt changed between 30-min slots. Volume spikes and drops become immediately visible.

Wrap window covered

The heatmap covers 18:00 to 23:00 to capture overtime and wrap activity — nothing falls off the edge.

Current net always visible

The rightmost column shows total net volume at the latest inferred timestamp — updated with every batch upload.

Every sort, fully documented.

Dashboard Tabs
Overview 11 KPI tiles: Net Volume, Hub PPH, Headcount, Paid Day, Misload Rate, LIB, Cube %, Cost/Piece and more.
Staffing SOR-based area breakdown, coord group performance, plan vs actual by work area.
Employee Data iGate Scan Metrics + SEAS employee metrics: PPH, misload count, LIB, scan efficiency per employee.
Cube CURE-powered cube scorecard by OS — Util %, TFCS≥95, load count, destination names, 4 OS KPI tiles.
Trend Analysis 11 trend charts across sorts: Net Volume, PPH, Hours, Misloads, Cube Util, and more. Powered by IndexedDB snapshots.
DOP Generator Predicts next sort’s volume, PPH, paid day, and headcount using a weighted rolling average of the last 4 same-DOW sorts.
Compare A/B Side-by-side sort comparison with ~40 KPI rows across Overview, Staffing, Misloads, LIB, and Cube sections.
Overview — KPI Snapshot · 05.04.26 Twilight
Net Volume
13,847
pkgs
Hub PPH
293
pkg / hr
Cube Util
64.1%
goal 62.2%
Headcount
38
employees
Misload Rate
1/4,820
SEAS source
LIB Count
7
this sort
Trend Analysis — Net Volume across sorts
04/28 Mon
12,340
04/30 Wed
14,102
05/02 Fri
13,580
05/04 Sun
13,847
DOP Generator predicts next Mon: ~12,600–13,100 · confidence window from 4-sort weighted avg

One sort is a snapshot.
Twenty sorts is a story.

The long-term value of this tool is not any single night — it’s the accumulation of clean, consistent, comparable data across every sort.

01

Trend detection

Which belts consistently underperform? Which shifts lose productivity after 20:00? Which employee groups need structured development? The answers emerge from the data, not from memory.

Hub → History → Trends tabs
02

Cross-sort comparison

Compare cube scores, paid day hours, PPH averages, and volume flow patterns across multiple sort dates. Identify outliers, validate improvements, and build the case for structural changes.

CURE → Cube tab → Dest × Date heatmap
03

Data fidelity as a discipline

When coordinators punch in on time and scanners use their own IDs, the data tells the true story. This tool makes the gap between good data and bad data visible — which changes behavior.

Employee Summary accuracy → PPH confidence

The right view for the right person.

The Suite is a single file, but it surfaces different insights depending on who is looking at it.

Frontline Supervisor
Real-time area accountability
See PPH by employee and belt, live during the sort
Identify low-PPH scanners before they impact totals
Confirm borrowed employees are punched into the right area
Watch outbound volume build by belt across the night
Manager / FT Supervisor
Hub-level command picture
Hub KPIs vs DOP plan at every moment of the sort
Volume reconciliation — are the numbers adding up?
Delta heatmap — where did volume spike or drop?
DOP calculator to model staffing vs target scenarios
Save end-of-sort snapshots for historical reference
District Manager / Region
Trends and strategic clarity
Sort-over-sort volume and PPH trend lines
Cube scorecard with CURE-driven destination analysis
Cross-sort heatmap — which destinations trend high or low
Historical paid day and staffing efficiency comparison
Dashboard export for offline review and reporting

The foundation is built.
The pipeline is next.

v3.9.1 is not a finish line. It’s the platform everything else is built on.

Data Aggregator

A companion project in development that automates the collection and organization of iGate, SOR, and CURE exports across sort dates — eliminating manual download and folder management.

In progress — Dispatch project

Multi-sort trend engine

As JSON exports accumulate from each sort night, the Trends and History tabs grow richer. The goal is a rolling picture of CHEMA performance that updates automatically each night.

Enabled by JSON Export workflow

Broader sort coverage

The tool is built around the Twilight sort but designed to generalize. Day and Night sorts can be tracked with the same pipeline by changing the SOR filename suffix.

-T • -D • -N already supported

Wider distribution

The standalone tracker is already being distributed to part-time supervisors. Future versions can be adopted by other hubs with minimal configuration — facility code is read from the SOR filename automatically.

tracker_v1.17.html already shared

Built from scratch.
No budget. No mandate.

This project started because the data existed but the view didn’t. Every version added one more layer of visibility until the full picture came into focus. The sort doesn’t change. The data does. Now we can see it.

Rafael Almeida · Employee 6068314
CHEMA Twilight · Hub Operations
Thanks to Coleton Forsythe, Paul Redmond, and Shawn Walsh