Hold-Up QC
Reconciles each project's Primary Hold-Up against its computed Stage of Job / Stage of PreCom and the dev-view gate columns — flagging which side is out of date.
Dataset: 49 Programs 2026 Tracker(2).xlsm · change
Projects checked
414
Aligned
373
Flagged
41
−2 likely false positive
Triage
3 assigned · 17 resolved
17 resolved but still flagged — recheck
Stage of Job: Pending Only Permits
Stage of PreCom: PreComm Not Required
Asset feedback pendingshould bePermit pending
The dev-view gates have advanced to "Permit pending", but the Primary Hold-Up still says "Asset feedback pending" — advance the hold-up to match.
Basis: Stage of Job = Pending Only Permits
Reviewer note
Stage of Job has advanced to 'Pending Only Permits' and Open Dependencies explicitly lists 'Land Permit', confirming the project is blocked by a permit — not asset feedback. The 'Asset feedback pending' hold-up is stale and no longer reflects the current bottleneck. Updating it to 'Permit pending' brings it into alignment with both the computed stage and the open dependency.
Action: Change Primary Hold-Up from 'Asset feedback pending' to 'Permit pending'
Stage of Job: Installed Awaiting Commissioning
Stage of PreCom: PreComm Complete
Mapping pendingshould beADMS test pending
The dev-view gates have advanced to "ADMS test pending", but the Primary Hold-Up still says "Mapping pending" — advance the hold-up to match.
Basis: Stage of Job = Installed Awaiting Commissioning
Reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Permits and Pre-Comm
Stage of PreCom: Pending DLT PreComm
Device delivery pendingshould beDLT - Pre-comm pending
Material Delivered Date is set — device is no longer pending.
Basis: Stage of PreCom = Pending DLT PreComm
Reviewer note
Material Delivered Date is set (2026-04-30) and Controller Delivered Date is also set (2026-04-08), meaning device delivery is complete and 'Device delivery pending' is no longer accurate. Stage of PreCom has advanced to 'Pending DLT PreComm', and DLT Site Visit Status is 'NOTN' (not started), confirming the project is now waiting on DLT pre-commissioning. The Primary Hold-Up must be updated to reflect this current blocker.
Action: Change Primary Hold-Up from 'Device delivery pending' to 'DLT - Pre-comm pending'
Stage of Job: Precomm not Met, Return to PEND
Stage of PreCom: Pending DLT PreComm
Device delivery pendingshould beDLT - Pre-comm pending
Material Delivered Date is set — device is no longer pending.
Basis: Stage of PreCom = Pending DLT PreComm
Reviewer note
Material Delivered Date is set (2026-05-13) and Controller Delivered Date is also set (2026-03-04), meaning device delivery is no longer the blocking issue. Stage of PreCom has already advanced to 'Pending DLT PreComm', which is consistent with DLT Site Visit Status = NOTN being the current bottleneck. The Primary Hold-Up of 'Device delivery pending' is therefore stale and should be updated to 'DLT - Pre-comm pending' to match the computed stage.
Action: Change Primary Hold-Up from 'Device delivery pending' to 'DLT - Pre-comm pending'
Stage of Job: Pending Permits and Pre-Comm
Stage of PreCom: Pending Settings
Pending Program Reviewshould beSettings pending
The dev-view gates have advanced to "Settings pending", but the Primary Hold-Up still says "Pending Program Review" — advance the hold-up to match.
Basis: Stage of PreCom = Pending Settings
Reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Only Pre-Comm (Permits Completed)
Stage of PreCom: Pending DLT PreComm
Device delivery pendingshould beDLT - Pre-comm pending
Material Delivered Date is set — device is no longer pending.
Basis: Stage of PreCom = Pending DLT PreComm
Reviewer note
Material Delivered Date (2026-04-13) and Controller Delivered Date (2026-05-27) are both set, meaning device delivery is complete and 'Device delivery pending' is no longer accurate. The computed Stage of PreCom = 'Pending DLT PreComm' confirms the project has advanced past delivery and is now awaiting DLT pre-commissioning. The Primary Hold-Up must be updated to reflect the current blocker.
Action: Change Primary Hold-Up from 'Device delivery pending' to 'DLT - Pre-comm pending'
Stage of Job: Pending Permits and Pre-Comm
Stage of PreCom: Pending DLT PreComm
Device delivery pendingshould beDLT - Pre-comm pending
Material Delivered Date is set — device is no longer pending.
Basis: Stage of PreCom = Pending DLT PreComm
Reviewer note
Material Delivered Date (2026-06-12) and Controller Delivered Date (2026-06-10) are both set, confirming device delivery is complete — making 'Device delivery pending' stale. Stage of PreCom has advanced to 'Pending DLT PreComm', and DLT Site Visit Status is 'NOTN' (Not Started), which is consistent with the next blocker being the DLT pre-commissioning visit. The open dependency on a Permit MiscTSK also aligns with Stage of Job = 'Pending Permits and Pre-Comm', but the primary hold-up label should reflect the PreCom stage.
Action: Change Primary Hold-Up from 'Device delivery pending' to 'DLT - Pre-comm pending'
Stage of Job: Pending Permits and Pre-Comm
Stage of PreCom: IT/DLT information is missing
Permit pendingshould be(fill IT/DLT dev columns)
The computed Stage of Job / Stage of PreCom aren't available, so the hold-up can't be checked — fill the IT/DLT dev-view columns and recompute.
Basis: Stage of PreCom = IT/DLT information is missing
Reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Only Pre-Comm (Permits Completed)
Stage of PreCom: Pending Settings
DLT - Pre-comm pendingshould beSettings pending
The Primary Hold-Up "DLT - Pre-comm pending" is further along than the dev-view gates, which still point to "Settings pending" — update the gate column so the stages catch up.
Basis: Stage of PreCom = Pending Settings
Reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Permits and Pre-Comm
Stage of PreCom: IT/DLT information is missing
Permit pendingshould be(fill IT/DLT dev columns)
The computed Stage of Job / Stage of PreCom aren't available, so the hold-up can't be checked — fill the IT/DLT dev-view columns and recompute.
Basis: Stage of PreCom = IT/DLT information is missing
Reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Installed, Commissioning Not Required
Stage of PreCom: PreComm Not Required
CN24 pendingshould beJob Completed
The dev-view gates have advanced to "Job Completed", but the Primary Hold-Up still says "CN24 pending" — advance the hold-up to match.
Basis: Stage of Job = Installed, Commissioning Not Required
Reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Only Pre-Comm (Permits Completed)
Stage of PreCom: Pending Device
Settings pendingshould beDevice delivery pending
The dev-view gates have advanced to "Device delivery pending", but the Primary Hold-Up still says "Settings pending" — advance the hold-up to match.
Basis: Stage of PreCom = Pending Device
Reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Only Pre-Comm (Permits Completed)
Stage of PreCom: Pending DLT PreComm
PC25 request pendingshould beDLT - Pre-comm pending
The Primary Hold-Up "PC25 request pending" is further along than the dev-view gates, which still point to "DLT - Pre-comm pending" — update the gate column so the stages catch up.
Basis: Stage of PreCom = Pending DLT PreComm
+ Add reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Only Permits
Stage of PreCom: PreComm Complete
PC25 request pendingshould bePermit pending
The Primary Hold-Up "PC25 request pending" is further along than the dev-view gates, which still point to "Permit pending" — update the gate column so the stages catch up.
Basis: Stage of Job = Pending Only Permits
+ Add reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Only Permits
Stage of PreCom: PreComm Complete
PC25 request pendingshould bePermit pending
The Primary Hold-Up "PC25 request pending" is further along than the dev-view gates, which still point to "Permit pending" — update the gate column so the stages catch up.
Basis: Stage of Job = Pending Only Permits
+ Add reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Only Permits
Stage of PreCom: PreComm Complete
PC25 request pendingshould bePermit pending
The Primary Hold-Up "PC25 request pending" is further along than the dev-view gates, which still point to "Permit pending" — update the gate column so the stages catch up.
Basis: Stage of Job = Pending Only Permits
+ Add reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Only Permits
Stage of PreCom: PreComm Complete
PC25 request pendingshould bePermit pending
The Primary Hold-Up "PC25 request pending" is further along than the dev-view gates, which still point to "Permit pending" — update the gate column so the stages catch up.
Basis: Stage of Job = Pending Only Permits
+ Add reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Installed, Commissioning Not Required
Stage of PreCom: PreComm Not Required
CN24 pendingshould beJob Completed
The dev-view gates have advanced to "Job Completed", but the Primary Hold-Up still says "CN24 pending" — advance the hold-up to match.
Basis: Stage of Job = Installed, Commissioning Not Required
+ Add reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Only Permits
Stage of PreCom: PreComm Complete
PC25 request pendingshould bePermit pending
The Primary Hold-Up "PC25 request pending" is further along than the dev-view gates, which still point to "Permit pending" — update the gate column so the stages catch up.
Basis: Stage of Job = Pending Only Permits
+ Add reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Only Permits
Stage of PreCom: PreComm Complete
PC25 request pendingshould bePermit pending
The Primary Hold-Up "PC25 request pending" is further along than the dev-view gates, which still point to "Permit pending" — update the gate column so the stages catch up.
Basis: Stage of Job = Pending Only Permits
+ Add reviewer note
AI adjudication failed for this item — treated as a real finding until re-checked.
Stage of Job: Pending Permits and Pre-Comm
Stage of PreCom: Pending Mapping
IT - Survey WO pendingshould beMapping pending
The dev-view gates have advanced to "Mapping pending", but the Primary Hold-Up still says "IT - Survey WO pending" — advance the hold-up to match.
Basis: Stage of PreCom = Pending Mapping
+ Add reviewer note
IT Survey Status is marked COMP, meaning the IT survey work order is no longer pending, which directly invalidates the current hold-up label. The computed Stage of PreCom has advanced to 'Pending Mapping' and DLT Site Visit Status is NOTN, confirming the project is now blocked on mapping rather than the IT survey. The Primary Hold-Up simply was not updated after IT Survey Status moved to COMP.
Action: Change Primary Hold-Up from 'IT - Survey WO pending' to 'Mapping pending'
Stage of Job: Pending Only Pre-Comm (Permits Completed)
Stage of PreCom: Pending Device
Resource assignment pendingshould beDevice delivery pending
The Primary Hold-Up "Resource assignment pending" doesn't line up with the computed stage ("Device delivery pending") — review this case manually.
Basis: Stage of PreCom = Pending Device
+ Add reviewer note
Both controller_delivered (2026-07-01, future) and material_delivered (blank) confirm the project is blocked on physical device/material delivery, which is exactly what Stage of PreCom = 'Pending Device' reflects. 'Resource assignment pending' has no corresponding gate column supporting it and does not align with the computed stage. The hold-up label needs to be updated to match the gate-driven stage.
Action: Change Primary Hold-Up from 'Resource assignment pending' to 'Device delivery pending', consistent with Controller Delivered date of 2026-07-01 (future) and Material Delivered being blank, which drive Stage of PreCom = Pending Device.
Likely false positives (AI) — 2 hiddendeterministic flag stands; the AI is confident these are aligned
Stage of Job: Pending Permits and Pre-Comm
Stage of PreCom: IT/DLT information is missing
IT - Survey WO pendingshould be(fill IT/DLT dev columns)
The computed Stage of Job / Stage of PreCom aren't available, so the hold-up can't be checked — fill the IT/DLT dev-view columns and recompute.
Basis: Stage of PreCom = IT/DLT information is missing
+ Add reviewer note
The Primary Hold-Up 'IT - Survey WO pending' is fully consistent with Stage of PreCom = 'IT/DLT information is missing' and IT Survey Status being blank — all three signals agree the project is stalled waiting for the IT survey. The deterministic check fired only because the IT/DLT dev columns are blank (causing the stage computation to be indeterminate), but that blank state is itself consistent with the hold-up, not a contradiction of it. No mismatch exists; the correct next action is to update IT Survey Status once the WO is completed, not to change the hold-up.
Action: Fill in the IT Survey Status dev-view column once the survey WO status is known; no change needed to Primary Hold-Up at this time.
Stage of Job: Pending Permits and Pre-Comm
Stage of PreCom: IT/DLT information is missing
IT - Survey WO pendingshould be(fill IT/DLT dev columns)
The computed Stage of Job / Stage of PreCom aren't available, so the hold-up can't be checked — fill the IT/DLT dev-view columns and recompute.
Basis: Stage of PreCom = IT/DLT information is missing
+ Add reviewer note
The Primary Hold-Up 'IT - Survey WO pending' is fully consistent with Stage of PreCom = 'IT/DLT information is missing' and IT Survey Status being blank — all three signals agree the project is stalled waiting for the IT survey. The deterministic check fired only because the IT/DLT dev columns are blank (causing the stage computation to be indeterminate), but that blank state is itself consistent with the hold-up, not a contradiction of it. No mismatch exists; the correct next action is to update IT Survey Status once the WO is completed, not to change the hold-up.
Action: Fill in the IT Survey Status dev-view column once the survey WO status is known; no change needed to Primary Hold-Up at this time.
How this QC works
Stage of Job and Stage of PreCom are computed automatically from the manual dev-view gate columns. Primary Hold-Up is also entered by hand and should match where those stages say the project is.
Hold-up stale= the gates moved on but the hold-up wasn't advanced (e.g. Material Delivered is set, but the hold-up still says “Device delivery pending”). Fix the hold-up.
Dev columns stale= the hold-up was moved forward but a gate column wasn't updated (e.g. hold-up says “Construction scheduled” but pre-comm isn't complete). Fix the gate column.
Data inconsistency= the computed Stage of Job contradicts Open Dependencies (e.g. it reads “Pending Only Permits,” which only happens when a permit dependency is open, but Open Dependencies is “None”). The cached stage is stale — recompute the workbook or correct the dependency cell.
AI QC passdouble-checks every deterministic finding against the live gate values (Sonnet by default, cached per finding). It's advisory: high-confidence false positives are moved to the collapsed section, but the deterministic counts above are never changed — so the History charts stay reproducible. Each false positive it finds is also a signal to harden the underlying rules.
Owner, Resolved & Notes are saved to shared storage, keyed by PM-Location — so triage sticks across refreshes, teammates, and weekly dataset re-uploads. Use the bulk bar to assign or resolve every finding in the current filter at once.
Findings are deterministic; the AI pass and per-card “AI adjudicate” double-check individual cases against the live gate values. Snapshot generated 2026-07-10T06:20:03.363Z.