Could not load:
Pipe M/C Summary (26-27), Garden Pipe M/C Summary (26-27), Moulding M/C Summary (26-27)
Figures for these plants are absent from this view. Other plants loaded successfully.
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
32 warning(s)
Spreadsheet updates
When each source workbook's data last changed, as detected by the dashboard. Checked 30-07-2026 04:27.
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 · 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.
No spreadsheet changes detected in the last 7 days.
All workbooks & last-changed times (51)
| Workbook | Grain | Data last changed |
|---|---|---|
|
Pipe M/C Summary (26-27)
Pipe & Fitting
|
monthly | 25-07-2026 06:23 |
|
Pipe & Fitting daily — 2026-06
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/91
Machines
1/3
Months
19/21 files · 82/91 machines · 1/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 present and usable, but several areas need attention before figures can be fully trusted. The most notable gaps are the HDPE June and July files returning no data at all, nine PTMT machines showing no recorded runs in this window, and the June 2026 period having ended with no data loaded yet. Additionally, efficiency cannot be calculated for PIPE Grinder-3 due to a missing ideal output rate in Report-5, the MOULDING August daily report could not be read due to a layout issue, and GARDEN utilisation is suppressed for May and July for the same reason, so the factory manager should follow up on those source files directly.
Tier 1 · Completeness
6
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
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
Month 2026-06 has ended but holds no data yet.
2026-06
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
PASSNo 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.