FY 2026-27 → totals are summed from the daily production files for Garden Pipe, HDPE, Injection Moulding, Pipe & Fitting, PTMT, Tanks. No daily workbook exists for Jul 2026, Aug 2026, Sep 2026, Oct 2026, Nov 2026, Dec 2026, Jan 2027, Feb 2027, Mar 2027 — those months show no data.
Published with flags
47 warning(s)

Spreadsheet updates

When each source workbook's data last changed, as detected by the dashboard. Checked 16-06-2026 09:16.

No spreadsheet changes detected in the last 7 days.
All workbooks & last-changed times (19)
Workbook Grain Data last changed
Garden Pipe daily — 2026-04
Garden Pipe
daily 15-06-2026 11:24
PTMT daily — 2026-04
PTMT
daily 15-06-2026 11:24
Pipe & Fitting daily — 2026-04
Pipe & Fitting
daily 15-06-2026 11:24
HDPE daily — 2026-05
HDPE
daily 15-06-2026 11:24
Garden Pipe daily — 2026-05
Garden Pipe
daily 15-06-2026 11:24
PTMT daily — 2026-05
PTMT
daily 15-06-2026 11:24
Pipe & Fitting daily — 2026-05
Pipe & Fitting
daily 15-06-2026 11:24
Moulding M/C Summary (26-27)
Injection Moulding
monthly 15-06-2026 11:24
HDPE M/C Summary (26-27)
HDPE
monthly 15-06-2026 11:24
Garden Pipe M/C Summary (26-27)
Garden Pipe
monthly 15-06-2026 11:24
Pipe M/C Summary (26-27)
Pipe & Fitting
monthly 15-06-2026 11:24
Pipe & Fitting daily — 2026-06
Pipe & Fitting
daily Not yet observed
PTMT daily — 2026-06
PTMT
daily Not yet observed
Garden Pipe daily — 2026-06
Garden Pipe
daily Not yet observed
HDPE daily — 2026-04
HDPE
daily Not yet observed
HDPE daily — 2026-06
HDPE
daily Not yet observed
Tanks daily — 2026-04
Tanks
daily Not yet observed
Tanks daily — 2026-05
Tanks
daily Not yet observed
Tanks daily — 2026-06
Tanks
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

11/15
Files
87/91
Machines
2/2
Months
11/15 files · 87/91 machines · 2/2 months
Data reported through: PTMT to 15-06-2026 · Garden Pipe to 09-06-2026 · Tanks to 09-06-2026 · Pipe & Fitting to 04-06-2026 · Injection Moulding to 04-06-2026 · HDPE to 01-05-2026
Plain-English summary AI summary of detected issues

The data is largely present but carries a warning because several gaps were found across files and machines. Four workbook periods returned no data at all (HDPE daily for April and June, Tanks daily for April and May), the Moulding section cannot be checked machine by machine because its daily codes do not match the monthly roster, four PTMT machines show no activity this window, and 25 moulds listed on the master roster have no readings for this period. These items should be investigated to confirm whether the gaps reflect genuine downtime or missing data entry before relying on this dashboard for production decisions.

Tier 1 · Completeness

30
warning No data read from HDPE daily (2026-04) — workbook returned nothing for this period.
HDPE · 2026-04 · 1TTxcpSQyVyleermiOhYlxlcd3RE0Pay0dRHLnXSEohs
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-04) — workbook returned nothing for this period.
Tanks · 2026-04 · 1osCJ1ZF2okCdHXbhkBthvJ7T7x21warW1-NMGm-5xbc
warning No data read from Tanks daily (2026-05) — workbook returned nothing for this period.
Tanks · 2026-05 · 1Zl8dvEZkQKGAkyWDTgLznC_yISNVznPf3pgUodHttm8
warning MOULDING: daily data is reported by a machine code that doesn't map to the monthly roster (24 reporting) — per-machine completeness against the grid isn't available for this view.
Injection Moulding
warning PTMT: 4 of 55 roster machine(s) had no run in this window (PTMT 130-TON, PTMT Blow Mould 1, PTMT Blow Mould 2, PTMT Blow Mould 3) — normal for a short window, but flagged so a never-reporting machine is visible against the full 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-06 is the current period and still in progress — partial or no data is expected.
2026-06

Tier 2 · Reconciliation

14
warning PIPE 2026-04: 7 of 7 machine(s) have no planned-hours baseline — run hours + output are shown but utilisation/efficiency are hidden.
warning MOULDING 2026-04: 23 of 23 machine(s) have no planned-hours baseline — run hours + output are shown but utilisation/efficiency are hidden.
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-04: daily file records output only (no run hours), so utilisation/efficiency are not available — output is shown.
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-04: the daily report is 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 TANK 2026-04: production report is present but no output 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

4
warning MOULDING A04(NU-150): output 579 kg is 0.1× the Moulding median (7,051 kg) — looks like an outlier.
Injection Moulding · MOULDING A04(NU-150)
warning MOULDING A01(NU-200): output 620 kg is 0.1× the Moulding median (7,051 kg) — looks like an outlier.
Injection Moulding · MOULDING A01(NU-200)
warning PTMT 80-2: output 183 kg is 0.0× the PTMT – Injection (standard) median (4,966 kg) — looks like an outlier.
PTMT · PTMT 80-2
warning PTMT 110-1: output 697 kg is 0.1× the PTMT – Injection (standard) median (4,966 kg) — looks like an outlier.
PTMT · PTMT 110-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.