Last updated: 12-06-2026 → true daily data for PTMT. Any plant not listed had no run recorded on these days.
Published with flags
19 warning(s)
Claude Sanity Check

Claude reviews the already-computed tier results and explains each issue in plain English, telling you exactly what to fix in the source sheet. No figure is recalculated — it works from the audit output only.

Completeness score

8/10
Files
48/55
Machines
2/2
Months
8/10 files · 48/55 machines · 2/2 months
Plain-English summary AI summary of detected issues

The data load is mostly complete at 8 of 10 files and 48 of 55 machines, but two workbooks returned no data at all for their respective periods, HDPE for June and Tanks for May, so those sections should be checked to confirm the source files are correctly populated and accessible. Utilisation and efficiency figures are unavailable across PIPE, MOULDING, GARDEN, and TANK for both months because planned-hours baselines are missing for PIPE and MOULDING, and the GARDEN and TANK files do not record run hours in a compatible format, meaning only output numbers can be relied upon from those areas. Seven PTMT machines are flagged as outliers with outputs ranging from near zero to over eleven times the group median, so the actual production counts for PTMT 80-5, 125-1, 150-2, 350-1, 350-2, 450-1, and N-200A should be verified against physical records before those figures are used in any performance reporting.

Tier 1 · Completeness

4
warning No data read from HDPE daily (2026-06) — workbook returned nothing for this period.
HDPE · 2026-06 · 1_vKZGOctS_ADPxDD2OypxasHVQ5MgmHjTWcvWKEDyi8
warning No data read from Tanks daily (2026-05) — workbook returned nothing for this period.
Tanks · 2026-05 · 1Zl8dvEZkQKGAkyWDTgLznC_yISNVznPf3pgUodHttm8
warning PTMT: 7 of 55 roster machine(s) had no run in this window (PTMT 130-TON, PTMT 150-6, PTMT 250-3, PTMT 80-2, PTMT Blow Mould 1, PTMT Blow Mould 2, PTMT GRINDER-2 (S)) — normal for a short window, but flagged so a never-reporting machine is visible against the full roster.
PTMT
info Month 2026-06 is the current period and still in progress — partial or no data is expected.
2026-06

Tier 2 · Reconciliation

9
warning PIPE 2026-05: 7 of 7 machine(s) have no planned-hours baseline — run hours + output are shown but utilisation/efficiency are hidden.
warning MOULDING 2026-05: 24 of 24 machine(s) have no planned-hours baseline — run hours + output are shown but utilisation/efficiency are hidden.
warning PIPE 2026-06: 7 of 7 machine(s) have no planned-hours baseline — run hours + output are shown but utilisation/efficiency are hidden.
warning MOULDING 2026-06: 24 of 24 machine(s) have no planned-hours baseline — run hours + output are shown but utilisation/efficiency are hidden.
warning GARDEN 2026-05: daily file records output only (no run hours), so utilisation/efficiency are not available — output is shown.
warning GARDEN 2026-06: daily file records output only (no run hours), so utilisation/efficiency are not available — output is shown.
warning HDPE 2026-06: the daily report is present but no production has been recorded for this period yet.
warning TANK 2026-05: production report is present but no output has been recorded for this period yet.
warning TANK 2026-06: tank output is recorded per item (no machine or run hours), so utilisation/efficiency are not available — output is shown.

Tier 3 · Validity

PASS
No issues detected.

Tier 4 · Plausibility

7
warning PTMT 80-5: output 7 is 0.1× the PTMT – Injection (standard) median (50) — looks like an outlier.
PTMT · PTMT 80-5
warning PTMT 125-1: output 5 is 0.1× the PTMT – Injection (standard) median (50) — looks like an outlier.
PTMT · PTMT 125-1
warning PTMT 150-2: output 6 is 0.1× the PTMT – Injection (standard) median (50) — looks like an outlier.
PTMT · PTMT 150-2
warning PTMT 350-1: output 466 is 9.4× the PTMT – Injection (standard) median (50) — looks like an outlier.
PTMT · PTMT 350-1
warning PTMT 350-2: output 569 is 11.5× the PTMT – Injection (standard) median (50) — looks like an outlier.
PTMT · PTMT 350-2
warning PTMT 450-1: output 368 is 7.4× the PTMT – Injection (standard) median (50) — looks like an outlier.
PTMT · PTMT 450-1
warning PTMT N-200A: output 5 is 0.0× the PTMT – Injection (N-line) median (113) — looks like an outlier.
PTMT · PTMT N-200A
Every figure passes four checks — completeness, reconciliation, validity, plausibility — before it is published. Detection is fully deterministic; AI is used only to match machine codes and write this summary.