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.
June 2026 → totals are summed from the daily production files for Garden Pipe, Injection Moulding, Pipe & Fitting, PTMT, Tanks (KH), Tanks (VN), Tanks (WB).
Published with flags
16 warning(s)

Spreadsheet updates

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

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

6/7
Files
101/106
Machines
1/3
Months
6/7 files · 101/106 machines · 1/3 months
Data reported through: Injection Moulding to 30-06-2026 · PTMT to 30-06-2026 · Garden Pipe to 30-06-2026 · Tanks (KH) to 30-06-2026 · Tanks (VN) to 30-06-2026 · Tanks (WB) to 30-06-2026 · Pipe & Fitting to 27-06-2026
Plain-English summary AI summary of detected issues

The data is mostly complete and usable, covering 6 of 7 files and 101 of 106 machines for one confirmed month, but several gaps and flags need attention before the figures can be fully trusted. Key missing items include no data at all from the HDPE daily workbook for June 2026, five PTMT machines with no recorded runs, and planned-hours baselines not set for 12 machines across Moulding and Pipe, which means utilisation and efficiency figures for those machines are unreliable. You should also verify the logged run hours for two machines showing utilisation above 100 percent, confirm whether the low output figures for Moulding A01, PTMT Grinder-2, and Garden M/C-1 are genuine or recording errors, and note that Tank and Tank variant outputs are shown without utilisation or efficiency since those lines record items only with no machine or run-hour data.

Tier 1 · Completeness

5
warning No data read from HDPE daily (2026-06) — workbook returned nothing for this period.
HDPE · 2026-06 · 1_vKZGOctS_ADPxDD2OypxasHVQ5MgmHjTWcvWKEDyi8
warning PTMT: 5 of 55 roster machine(s) had no run in this window (PTMT 130-TON, PTMT 150-6, PTMT 80-2, PTMT Blow Mould 1, PTMT Blow Mould 3) — normal for a short window, but flagged so a never-reporting machine is visible against the full roster.
PTMT
warning Month 2026-06 has ended but holds no data yet.
2026-06
warning MOULDING: 2 machine(s) have no planned-hours baseline set — utilisation/efficiency use the sheet placeholder (0 h). Set them in baselines.json for a real target.
Injection Moulding
warning PIPE: 10 machine(s) have no planned-hours baseline set — utilisation/efficiency use the sheet placeholder (0 h). Set them in baselines.json for a real target.
Pipe & Fitting

Tier 2 · Reconciliation

6
warning PIPE Grinder-3: missing ideal output/hour in Report-5 — efficiency shown as n/a (utilisation still computed).
warning GARDEN 2026-06: output read from the per-machine tabs; run hours joined from the 'Daily Report' matrix — utilisation is shown.
warning HDPE 2026-06: the daily report is present but no production 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.
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_WB 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

2
warning Utilisation over 100% — ran above the planned baseline (ideal 336h, actual 451h). Verify the ideal-hours baseline or the logged hours.
Pipe & Fitting · PIPE Grinder-1 · 2026-06 · tab Report-5 · 1uwuhCylN3h9HizK5qNUCH-sjktE3GEH74Y_UeNq6eec
warning Utilisation over 100% — ran above the planned baseline (ideal 336h, actual 365h). Verify the ideal-hours baseline or the logged hours.
Pipe & Fitting · PIPE Pulverizer-2 · 2026-06 · tab Report-5 · 1uwuhCylN3h9HizK5qNUCH-sjktE3GEH74Y_UeNq6eec

Tier 4 · Plausibility

3
warning MOULDING A01(NU-200): output 544 kg is 0.2× the Moulding median (3,285 kg) — looks like an outlier.
Injection Moulding · MOULDING A01(NU-200)
warning PTMT GRINDER-2 (S): output 625 kg is 0.0× the PTMT – Grinding median (12,545 kg) — looks like an outlier.
PTMT · PTMT GRINDER-2 (S)
warning GARDEN M/C - 1: output 45 kg is 0.0× the Garden Pipe median (26,013 kg) — looks like an outlier.
Garden Pipe · GARDEN M/C - 1
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.