Showing each plant's latest reporting day — Injection Moulding 28-07-2026, PTMT 28-07-2026, Pipe & Fitting 27-07-2026, Tanks (WB) 24-07-2026, Tanks (KH) 23-07-2026, Tanks (VN) 22-07-2026, Garden Pipe 01-07-2026, HDPE 01-05-2026. A plant with no recent daily data isn't shown.
Published with flags
57 warning(s)

Spreadsheet updates

2 updated

When each source workbook's data last changed, as detected by the dashboard. Checked 30-07-2026 03:41.

stale rollup Monthly summary out of date

A published "Compound 6-10" rollup no longer matches its own daily Mixer-Logbook detail — the daily figures are authoritative until the source sheet is corrected.

CPVC F · Apr 2026 — daily detail is authoritative; the monthly rollup cells are understated and should be corrected in the source sheet.
SWR / AGRI F · Apr 2026 — daily detail is authoritative; the monthly rollup cells are understated and should be corrected in the source sheet.
CPVC F · May 2026 — daily detail is authoritative; the monthly rollup cells are understated and should be corrected in the source sheet.
SWR / AGRI F · May 2026 — daily detail is authoritative; the monthly rollup cells are understated and should be corrected in the source sheet.
CPVC F · Jun 2026 — daily detail is authoritative; the monthly rollup cells are understated and should be corrected in the source sheet.
Updated in the last 7 days
Pipe M/C Summary (26-27)
Pipe & Fitting · monthly · 22 rows
updated
25-07-2026 06:23
Pipe & Fitting daily — 2026-06
Pipe & Fitting · daily · 639 rows
updated
25-07-2026 05:25
All workbooks & last-changed times (51)
Workbook Grain Data last changed
Pipe M/C Summary (26-27) new
Pipe & Fitting
monthly 25-07-2026 06:23
Pipe & Fitting daily — 2026-06 new
Pipe & Fitting
daily 25-07-2026 05:25
Tanks (KH) daily — 2026-05
Tanks (KH)
daily 20-07-2026 09:50
Garden Pipe M/C Summary (26-27)
Garden Pipe
monthly 18-07-2026 06:25
Tanks (WB) daily — 2026-06
Tanks (WB)
daily 16-07-2026 09:35
Tanks (WB) daily — 2026-05
Tanks (WB)
daily 16-07-2026 09:35
Tanks (WB) daily — 2026-04
Tanks (WB)
daily 16-07-2026 09:35
Tanks (VN) daily — 2026-06
Tanks (VN)
daily 16-07-2026 09:35
Tanks (VN) daily — 2026-05
Tanks (VN)
daily 16-07-2026 09:35
Tanks (VN) daily — 2026-04
Tanks (VN)
daily 16-07-2026 09:35
Tanks (KH) daily — 2026-06
Tanks (KH)
daily 16-07-2026 09:35
PTMT daily — 2026-06
PTMT
daily 15-07-2026 11:50
Garden Pipe daily — 2026-06
Garden Pipe
daily 13-07-2026 17:20
Moulding M/C Summary (26-27)
Injection Moulding
monthly 06-07-2026 02:47
Pipe & Fitting daily — 2026-05
Pipe & Fitting
daily 02-07-2026 04:49
Pipe & Fitting daily — 2026-04
Pipe & Fitting
daily 30-06-2026 12:46
Garden Pipe daily — 2026-04
Garden Pipe
daily 30-06-2026 07:39
PTMT daily — 2026-05
PTMT
daily 29-06-2026 11:34
PTMT daily — 2026-04
PTMT
daily 29-06-2026 11:34
HDPE daily — 2026-05
HDPE
daily 15-06-2026 11:24
Garden Pipe daily — 2026-05
Garden Pipe
daily 15-06-2026 11:24
HDPE M/C Summary (26-27)
HDPE
monthly 15-06-2026 11:24
Pipe & Fitting daily — 2026-07
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2025-04
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2025-05
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2025-06
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2025-07
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2025-08
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2025-09
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2025-10
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2025-11
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2025-12
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2026-01
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2026-02
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2026-03
Pipe & Fitting
daily Not yet observed
Pipe & Fitting daily — 2026-08
Pipe & Fitting
daily Not yet observed
PTMT daily — 2026-07
PTMT
daily Not yet observed
PTMT daily — 2026-08
PTMT
daily Not yet observed
Garden Pipe daily — 2026-07
Garden Pipe
daily Not yet observed
Garden Pipe daily — 2026-08
Garden Pipe
daily Not yet observed
HDPE daily — 2026-04
HDPE
daily Not yet observed
HDPE daily — 2026-06
HDPE
daily Not yet observed
HDPE daily — 2026-07
HDPE
daily Not yet observed
HDPE daily — 2026-08
HDPE
daily Not yet observed
Tanks (KH) daily — 2026-04
Tanks (KH)
daily Not yet observed
Tanks (KH) daily — 2026-07
Tanks (KH)
daily Not yet observed
Tanks (KH) daily — 2026-08
Tanks (KH)
daily Not yet observed
Tanks (VN) daily — 2026-07
Tanks (VN)
daily Not yet observed
Tanks (VN) daily — 2026-08
Tanks (VN)
daily Not yet observed
Tanks (WB) daily — 2026-07
Tanks (WB)
daily Not yet observed
Tanks (WB) daily — 2026-08
Tanks (WB)
daily Not yet observed
Times are when the dashboard first detected each sheet's current data — not Google's edit time, which this connection can't read.
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

19/21
Files
82/94
Machines
3/3
Months
19/21 files · 82/94 machines · 3/3 months
Data reported through: Injection Moulding to 28-07-2026 · PTMT to 28-07-2026 · Pipe & Fitting to 27-07-2026 · Tanks (WB) to 24-07-2026 · Tanks (KH) to 23-07-2026 · Tanks (VN) to 22-07-2026 · Garden Pipe to 01-07-2026 · HDPE to 01-05-2026
Plain-English summary AI summary of detected issues

The data is largely complete across 19 of 21 files and 82 of 94 machines over the full 3-month window, so overall production figures can be used with reasonable confidence, but some gaps require attention. The two missing HDPE daily files for June and July 2026 are the most significant gap, and several machines across GARDEN, PIPE, and PTMT departments recorded no activity in this period, which may reflect genuine downtime but should be confirmed. Additionally, a large number of moulds in the roster are showing no data rather than zero, and MOULDING and PTMT have machine code mismatches that prevent full per-machine tracking, so the production team should verify whether the silent machines and unmatched codes reflect real gaps or a naming or file issue.

Tier 1 · Completeness

31
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 HDPE daily (2026-07) — workbook returned nothing for this period.
HDPE · 2026-07 · 1M4oXFOmKelpCYpGDatjReTF5scJwcg8saFVPcRRORtA
warning GARDEN: 1 of 4 roster machine(s) had no run in this window (GARDEN M/C - 1) — normal for a short window, but flagged so a never-reporting machine is visible against the full roster.
Garden Pipe
warning MOULDING: daily data is reported by a machine code that doesn't map to the monthly roster (22 reporting) — per-machine completeness against the grid isn't available for this view.
Injection Moulding
warning PIPE: 1 of 8 roster machine(s) had no run in this window (PIPE M/C - 7) — normal for a short window, but flagged so a never-reporting machine is visible against the full roster.
Pipe & Fitting
warning PTMT: 9 of 55 roster machine(s) had no run in this window (PTMT 125-1, PTMT 130-TON, PTMT 150-3, PTMT 450-1, PTMT 80-2, PTMT 80-6, PTMT Blow Mould 1, PTMT Blow Mould 3, PTMT GRINDER-2 (S)) — normal for a short window, but flagged so a never-reporting machine is visible against the full roster.
PTMT
warning PTMT: 1 daily machine code(s) could not be matched to the monthly roster.
PTMT
warning Mould 'A-150-2' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'A-150-3' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'A-150-4' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-150-A' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-150-B' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-200-A' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-200-B' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-200-C' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-250-1' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-250-2' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-250-4' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-250-5' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-250-6' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-250-7' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'C-275-A' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'NU-200' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'U-150-A' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'U-200-B' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'U-250-A' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'U-250-B' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'U-250-C' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'U-350-A' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
warning Mould 'U-450-A' is in the master roster but has no data this period (shown as a gap, not a zero).
Injection Moulding
info Month 2026-07 is the current period and still in progress — partial or no data is expected.
2026-07

Tier 2 · Reconciliation

25
warning PIPE Grinder-3: missing ideal output/hour in Report-5 — efficiency shown as n/a (utilisation still computed).
warning PIPE Grinder-3: missing ideal output/hour in Report-5 — efficiency shown as n/a (utilisation still computed).
warning PIPE Grinder-3: missing ideal output/hour in Report-5 — efficiency shown as n/a (utilisation still computed).
warning PIPE 2026-08: the daily report is present but no production has been recorded for this period yet.
warning MOULDING 2026-08: the daily report could not be parsed (date/output layout not recognised).
warning PTMT 2026-08: the daily report is present but no production has been recorded for this period yet.
warning GARDEN 2026-05: output read from the per-machine tabs, but the 'Daily Report' matrix could not be parsed (layout not recognised) — utilisation suppressed.
warning GARDEN 2026-06: output read from the per-machine tabs; run hours joined from the 'Daily Report' matrix — utilisation is shown.
warning GARDEN 2026-07: output read from the per-machine tabs, but the 'Daily Report' matrix could not be parsed (layout not recognised) — utilisation suppressed.
warning GARDEN 2026-08: machine tabs are present but no production has been recorded for this period yet.
warning HDPE 2026-06: the daily report is present but no production has been recorded for this period yet.
warning HDPE 2026-07: the daily report is present but no production has been recorded for this period yet.
warning HDPE 2026-08: the daily report is present but no production has been recorded for this period yet.
warning TANK 2026-05: tank output is recorded per item (no machine or run hours), so utilisation/efficiency are not available — output is shown.
warning TANK 2026-06: tank output is recorded per item (no machine or run hours), so utilisation/efficiency are not available — output is shown.
warning TANK 2026-07: tank output is recorded per item (no machine or run hours), so utilisation/efficiency are not available — output is shown.
warning TANK 2026-08: production report is present but no output has been recorded for this period yet.
warning TANK_VN 2026-05: tank output is recorded per item (no machine or run hours), so utilisation/efficiency are not available — output is shown.
warning TANK_VN 2026-06: tank output is recorded per item (no machine or run hours), so utilisation/efficiency are not available — output is shown.
warning TANK_VN 2026-07: tank output is recorded per item (no machine or run hours), so utilisation/efficiency are not available — output is shown.
warning TANK_VN 2026-08: production report is present but no output has been recorded for this period yet.
warning TANK_WB 2026-05: tank output is recorded per item (no machine or run hours), so utilisation/efficiency are not available — output is shown.
warning TANK_WB 2026-06: tank output is recorded per item (no machine or run hours), so utilisation/efficiency are not available — output is shown.
warning TANK_WB 2026-07: tank output is recorded per item (no machine or run hours), so utilisation/efficiency are not available — output is shown.
warning TANK_WB 2026-08: production report is present but no output has been recorded for this period yet.

Tier 3 · Validity

PASS
No issues detected.

Tier 4 · Plausibility

2
warning PTMT PVC Connection: output 1,298 kg is 11.5× the PTMT – Injection (standard) median (112 kg) — looks like an outlier.
PTMT · PTMT PVC Connection
warning GARDEN M/C - 4: output 136 kg is 0.1× the Garden Pipe median (1,254 kg) — looks like an outlier.
Garden Pipe · GARDEN M/C - 4
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.