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.
47 flag(s)
11/15 files · 87/91 machines · 2/2 months ›
Detected Data Sources
Every workbook the engine reads, mapped to a plant/segment with its grain and the months that currently hold data. All ratios are recomputed from raw hours and output — the stored % cells in the sheets are never trusted.
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.
Pipe M/C Summary (26-27)
Pipe & Fitting · Pipe
Data sheet used
Pipe M/C 26-27
Months with data
2 month(s)
Records parsed
13
2026-04
2026-05
Machine / detail tabs (9)
M/C-1
M/C-2
M/C-3
M/C-4
M/C-5
M/C-6
M/C-7
M/C-8
M/C-9
Reconciled to grid TOTAL (139064.0 vs 139064.0)
Header → field mapping
| Sheet header | Maps to |
|---|---|
| Ideal Hours |
ideal_hours
carried forward across month rows
|
| Actual Hours |
actual_hours
run time
|
| Actual Output (KG) / Output (KG) / Output (PCS) |
total_count
raw produced quantity
|
| Ideal Output |
ideal_rate
ideal kg/hr → ideal_output = actual_hrs × rate
|
| Rejection (KG) / Rejection |
reject_count
% reject recomputed, never read
|
| Runner |
runner_lumps
moulding layout only
|
| Month label column |
period
e.g. APR'26 → 2026-04
|
| Machine / Mould Machine |
machine
carried forward; merged label cell
|
Stored % cells (Utilisation %, Output Efficiency %) are ignored — every ratio is recomputed from raw hours and output.
file: 1EHJvI7KxIahlfZ5ODiAea3Pj2Zk3z1T6cCybZJuDAMQ
Garden Pipe M/C Summary (26-27)
Garden Pipe · Garden Pipe
Data sheet used
GARDEN M/C 26-27
Months with data
1 month(s)
Records parsed
4
2026-04
Machine / detail tabs (4)
M/C-1
M/C-2
M/C-3
M/C-4
Reconciled to grid TOTAL (38950.0 vs 38950.0)
Header → field mapping
| Sheet header | Maps to |
|---|---|
| Ideal Hours |
ideal_hours
carried forward across month rows
|
| Actual Hours |
actual_hours
run time
|
| Actual Output (KG) / Output (KG) / Output (PCS) |
total_count
raw produced quantity
|
| Ideal Output |
ideal_rate
ideal kg/hr → ideal_output = actual_hrs × rate
|
| Rejection (KG) / Rejection |
reject_count
% reject recomputed, never read
|
| Runner |
runner_lumps
moulding layout only
|
| Month label column |
period
e.g. APR'26 → 2026-04
|
| Machine / Mould Machine |
machine
carried forward; merged label cell
|
Stored % cells (Utilisation %, Output Efficiency %) are ignored — every ratio is recomputed from raw hours and output.
file: 1OYQq7YR_-6PyqzppOOamEaJl14VjbOQ6x-O_cpDy0gc
HDPE M/C Summary (26-27)
HDPE · HDPE
Data sheet used
HDPE M/C 26-27
Months with data
1 month(s)
Records parsed
1
2026-05
Machine / detail tabs (6)
M/C-1
M/C-2
M/C-3
M/C-4
M/C-5
M/C-6
Reconciled to grid TOTAL (1370.0 vs 1370.0)
Header → field mapping
| Sheet header | Maps to |
|---|---|
| Ideal Hours |
ideal_hours
carried forward across month rows
|
| Actual Hours |
actual_hours
run time
|
| Actual Output (KG) / Output (KG) / Output (PCS) |
total_count
raw produced quantity
|
| Ideal Output |
ideal_rate
ideal kg/hr → ideal_output = actual_hrs × rate
|
| Rejection (KG) / Rejection |
reject_count
% reject recomputed, never read
|
| Runner |
runner_lumps
moulding layout only
|
| Month label column |
period
e.g. APR'26 → 2026-04
|
| Machine / Mould Machine |
machine
carried forward; merged label cell
|
Stored % cells (Utilisation %, Output Efficiency %) are ignored — every ratio is recomputed from raw hours and output.
file: 1TRpfk3UzsAow4InJ6HyT_smayOdHfyoZ67xmHIwD2tw
Moulding M/C Summary (26-27)
Injection Moulding · Moulding
Data sheet used
Moulding M/C 26-27
Months with data
2 month(s)
Records parsed
44
2026-04
2026-05
Machine / detail tabs (25)
M/C - 1
M/C - 2
M/C - 3
M/C - 4
M/C - 5
M/C - 6
M/C - 7
M/C - 8
M/C - 9
M/C - 10
M/C - 11
M/C - 12
M/C - 13
M/C - 14
M/C - 15
M/C - 16
M/C - 17
M/C - 18
M/C - 19
M/C - 20
M/C - 21
M/C - 22
M/C - 23
M/C - 24
M/C - 25
Reconciled to grid TOTAL (153779.0 vs 155309.0)
Header → field mapping
| Sheet header | Maps to |
|---|---|
| Ideal Hours |
ideal_hours
carried forward across month rows
|
| Actual Hours |
actual_hours
run time
|
| Actual Output (KG) / Output (KG) / Output (PCS) |
total_count
raw produced quantity
|
| Ideal Output |
ideal_rate
ideal kg/hr → ideal_output = actual_hrs × rate
|
| Rejection (KG) / Rejection |
reject_count
% reject recomputed, never read
|
| Runner |
runner_lumps
moulding layout only
|
| Month label column |
period
e.g. APR'26 → 2026-04
|
| Machine / Mould Machine |
machine
carried forward; merged label cell
|
Stored % cells (Utilisation %, Output Efficiency %) are ignored — every ratio is recomputed from raw hours and output.
file: 1ZCHZp5io1ctdvm92xlHI7x5FtBC-nLoAb2FRMkfXzBI
Pipe & Fitting — daily workbooks
Pipe & Fitting · Pipe
Data sheet used
Report-11/Report-12
Months with data
3 month(s)
Records parsed
0
Daily grain; ideal rate/hours joined from the monthly grid baseline. Emits: PIPE, MOULDING. Layout: long.
2026-04
2026-05
2026-06
Header → field mapping
| Sheet header | Maps to |
|---|---|
| Ideal Hours |
ideal_hours
carried forward across month rows
|
| Actual Hours |
actual_hours
run time
|
| Actual Output (KG) / Output (KG) / Output (PCS) |
total_count
raw produced quantity
|
| Ideal Output |
ideal_rate
ideal kg/hr → ideal_output = actual_hrs × rate
|
| Rejection (KG) / Rejection |
reject_count
% reject recomputed, never read
|
| Runner |
runner_lumps
moulding layout only
|
| Month label column |
period
e.g. APR'26 → 2026-04
|
| Machine / Mould Machine |
machine
carried forward; merged label cell
|
Stored % cells (Utilisation %, Output Efficiency %) are ignored — every ratio is recomputed from raw hours and output.
file: 1eNUSktOldFHRtM55VYfLiYp5nLDRk3ovOEdYYKfI0hU
PTMT — daily workbooks
PTMT · Ptmt
Data sheet used
Report-5
Months with data
3 month(s)
Records parsed
0
Daily tab carries an in-sheet ideal column; utilisation uses it directly. Layout: matrix.
2026-04
2026-05
2026-06
Header → field mapping
| Sheet header | Maps to |
|---|---|
| Ideal Hours |
ideal_hours
carried forward across month rows
|
| Actual Hours |
actual_hours
run time
|
| Actual Output (KG) / Output (KG) / Output (PCS) |
total_count
raw produced quantity
|
| Ideal Output |
ideal_rate
ideal kg/hr → ideal_output = actual_hrs × rate
|
| Rejection (KG) / Rejection |
reject_count
% reject recomputed, never read
|
| Runner |
runner_lumps
moulding layout only
|
| Month label column |
period
e.g. APR'26 → 2026-04
|
| Machine / Mould Machine |
machine
carried forward; merged label cell
|
Stored % cells (Utilisation %, Output Efficiency %) are ignored — every ratio is recomputed from raw hours and output.
file: 16zsh5x4MdY8DX3H5_hw5iaOdkGixlUsPzesDVnwgfYo
Garden Pipe — daily workbooks
Garden Pipe · Garden Pipe
Data sheet used
^MACHINE\s*\d+$
Months with data
3 month(s)
Records parsed
0
Daily grain; ideal rate/hours joined from the monthly grid baseline. Layout: blocks.
2026-04
2026-05
2026-06
Header → field mapping
| Sheet header | Maps to |
|---|---|
| Ideal Hours |
ideal_hours
carried forward across month rows
|
| Actual Hours |
actual_hours
run time
|
| Actual Output (KG) / Output (KG) / Output (PCS) |
total_count
raw produced quantity
|
| Ideal Output |
ideal_rate
ideal kg/hr → ideal_output = actual_hrs × rate
|
| Rejection (KG) / Rejection |
reject_count
% reject recomputed, never read
|
| Runner |
runner_lumps
moulding layout only
|
| Month label column |
period
e.g. APR'26 → 2026-04
|
| Machine / Mould Machine |
machine
carried forward; merged label cell
|
Stored % cells (Utilisation %, Output Efficiency %) are ignored — every ratio is recomputed from raw hours and output.
file: 1mbxHLgvvruhI-3_d9zoqevZQxHhjxZY4cN0tIyxkzEo
HDPE — daily workbooks
HDPE · HDPE
Data sheet used
Daily Report
Months with data
3 month(s)
Records parsed
0
Daily grain; ideal rate/hours joined from the monthly grid baseline. Layout: matrix.
2026-04
2026-05
2026-06
Header → field mapping
| Sheet header | Maps to |
|---|---|
| Ideal Hours |
ideal_hours
carried forward across month rows
|
| Actual Hours |
actual_hours
run time
|
| Actual Output (KG) / Output (KG) / Output (PCS) |
total_count
raw produced quantity
|
| Ideal Output |
ideal_rate
ideal kg/hr → ideal_output = actual_hrs × rate
|
| Rejection (KG) / Rejection |
reject_count
% reject recomputed, never read
|
| Runner |
runner_lumps
moulding layout only
|
| Month label column |
period
e.g. APR'26 → 2026-04
|
| Machine / Mould Machine |
machine
carried forward; merged label cell
|
Stored % cells (Utilisation %, Output Efficiency %) are ignored — every ratio is recomputed from raw hours and output.
file: 1TTxcpSQyVyleermiOhYlxlcd3RE0Pay0dRHLnXSEohs
Tanks — daily workbooks
Tanks · Tank
Data sheet used
PROD. REPORT
Months with data
3 month(s)
Records parsed
0
Daily grain; no monthly grid or in-sheet ideal — hours & output are shown and the plant is flagged 'no baseline set'. Layout: tank.
2026-04
2026-05
2026-06
Header → field mapping
| Sheet header | Maps to |
|---|---|
| Ideal Hours |
ideal_hours
carried forward across month rows
|
| Actual Hours |
actual_hours
run time
|
| Actual Output (KG) / Output (KG) / Output (PCS) |
total_count
raw produced quantity
|
| Ideal Output |
ideal_rate
ideal kg/hr → ideal_output = actual_hrs × rate
|
| Rejection (KG) / Rejection |
reject_count
% reject recomputed, never read
|
| Runner |
runner_lumps
moulding layout only
|
| Month label column |
period
e.g. APR'26 → 2026-04
|
| Machine / Mould Machine |
machine
carried forward; merged label cell
|
Stored % cells (Utilisation %, Output Efficiency %) are ignored — every ratio is recomputed from raw hours and output.
file: 1osCJ1ZF2okCdHXbhkBthvJ7T7x21warW1-NMGm-5xbc
Daily-grain workbooks register here once their file IDs are added to the source registry.