Traceboard

An MES lot-tracking dashboard. Nothing loads until you choose a source below — all parsing happens on this machine.

or drop a CSV / Excel (.xlsx) file anywhere on this window

01Lot Summary

02Current Process — Lots by Stage

Lots and WIP pieces still at each Major Process.

03Lot Aging

Bucket thresholds (assumption — no SLA field in source data): Active ≤ d Stagnant ≥ d

Priority flags

04Risk — Lots Requiring Action

Click a chip to filter. Requiring Action = Bottleneck + Stagnant + Priority. Watch is early warning only.

Click a lot number to record a follow-up. Actions stay on this machine; resolving one does not clear MES risk.

Lot No. ↕	Order No. ↕	Process ↕	Days ↕	Risk Reason	Priority	Follow-up

05Customer / Order Summary

Lots per customer, including how many currently need action.

Customer	Lots	WIP	Completed	Completion	Requiring Action

All lots (raw + computed columns)

Prio	Lot No.↕	Order No.↕	Major Process↕	Minor Process↕	Export	Qty (P)	Qty (F)	Days↕	Aging	Risk

WIP Matrix

Rows are layers; columns are process families. Click a cell to list lots.

Lots — Last Process → Current → Next Process

Lot No.	Order No.	Drawing No.	Last Process	Current Process	Next Process	Route Position

Flow

Remaining cycle time, yield, cost-center load, and order ship status.

01Daily snapshot tape

One bar per day on live imports. Height is WIP lots; labels are moves and stagnant count.

02Cost-center load

WIP lots mapped to the BOM cost center (7010–7040, 1101).

Yield strip

Qty (F) / Qty (P) for Standard vs Split lots.

03Remaining cycle time

BOM lead time from the current step through packing. X-factor = idle days ÷ that step’s LT.

Lot No. ↕	Order No. ↕	Family ↕	Process ↕	Minor	Idle d ↕	Step LT ↕	X-factor ↕	Remain d ↕	Cost center ↕

04Order ship board

Per order: WIP vs done, worst remaining cycle time, and Incoming / split blockers.

Order No.	Family	Lots	WIP	Done	Worst remain d	Blocked by