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.
FY 2026-27 → totals are summed from the daily production files for Garden Pipe, HDPE, Injection Moulding, Pipe & Fitting, PTMT, Tanks (KH), Tanks (VN), Tanks (WB). No daily workbook exists for Sep 2026, Oct 2026, Nov 2026, Dec 2026, Jan 2027, Feb 2027, Mar 2027 — those months show no data.
61 flag(s)
24/35 files · 104/107 machines · 1/3 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 30-07-2026 04:24.
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.
Workbook Index — tab catalogue
Read from each workbook's own “Index” sheet (the authoritative description of every Report-N tab). Tabs are keyed by description, not number — the same report number means different things across workbooks. Tabs marked available exist in the sheet but the dashboard does not ingest them yet; changed means a tab's description or frequency differs from when it was first seen.
Pipe & Fitting workbook
2026-08
2 ingested · 21 available — not yet built ·
36 documented
| Report | Description | Frequency | Unit | Owner | Status |
|---|---|---|---|---|---|
| Report-1 | FG Stock — Cpvc Pipe & Fittings | Every Monday | — | — | available |
| Report-1 (A) | Upvc Pipe & Fittings | Every Monday | — | — | available |
| Report-1 (B) | Agri Pipe & Fittings | Every Monday | — | — | available |
| Report-1 (C) | Swr Pipe & Fittings | Every Monday | — | — | available |
| Report-2 | RM Item Stock | Every Monday & Thursday | — | Mr. Shelendra | available |
| Report-3 | BOP Item Stock | Every Monday | — | Mr. Anil | available |
| Report-4 | Packaging Item Stock | Every Monday | — | Mr. Anil | available |
| Report-5 |
All Types Machine — Pipe M/C
↳ Mixer, Grinder, Pulverizer · Mr. Shelendra
↳ Moulding M/C · Mr. Jitendra
|
Daily ·sliceable | — | Mr. Ankur | ingested |
| Report-6 | Compound — Cpvc Pipe | Daily ·sliceable | — | Mr. Shelendra | available |
| Report-7 | Upvc Pipe | Daily ·sliceable | — | — | available |
| Report-8 (A) | Agri Pipe | Daily ·sliceable | — | — | available |
| Report-8 (B) | Swr Pipe | Daily ·sliceable | — | — | available |
| Report-9 | Upvc Fittings | Daily ·sliceable | — | — | available |
| Report-10 | Swr Fittings | Daily ·sliceable | — | — | available |
| Report-11 | All Pipe M/C — M/C & Item Wise Actual Production in KG & Pcs | Daily ·sliceable | kg | Mr. Ankur | available |
| Report-11 (A) | M/C Breakdown Error — Maintenance Trouble Ticket | Daily ·sliceable | — | Report-11 | available |
| Report-12 | All Moulding M/C — M/C & Item Wise Actual Production in KG & Pcs | Daily ·sliceable | kg | Mr. Jitendra | ingested |
| Report-13 | All Pipe Production — Per day Production in Pcs Cpvc Upvc Swr / Agri Hdpe | Daily ·sliceable | pcs | Report-11 | available |
| Report-14 | All Fittings Production — Per day Production in Pcs Cpvc Upvc Swr / Agri Hdpe | Daily ·sliceable | pcs | Mr. Jitendra | available |
| Report-15 | Production , Wastage & Pilverizer — Per day Production, Wastage & Pulverizer in Pcs Cpvc Upvc Swr / Agri | Daily ·sliceable | pcs | — | available |
| Report-16 | M/C Maintenance — M/C Date of Purchase & AMC Applicable | Daily ·sliceable | — | — | available |
| Report-17, 18, 19 | Raw Material, BOP, Packing — April 21-22 Avg. Purchase Price, April ' 22 to till Purchase & Consumption | Monthly | — | Ms. Pooja | documented |
| Report-17, 18, 19 (A) | > Difference in %age of Purchase Qty & Consumption | Monthly | — | Report-17 | documented |
| Report-17, 18, 19 (B) | < Difference in %age of Purchase Qty & Consumption | Monthly | — | — | documented |
| S-20, 21, 22, 23 | Summary Report — Mould Working Report Cpvc Upvc Swr Agri | Monthly | — | Report-20, 21, 22, 23 | documented |
| Report-20 | Mould Working Report — Cpvc Mould | Monthly | — | Report-12 | available |
| Report-21 | Upvc Mould | Monthly | — | — | available |
| Report-22 | Swr Mould | Monthly | — | — | documented |
| Report-23 | Agri Mould | Monthly | — | — | documented |
| Report-24 | Daily Store Entry — Cpvc Fittings | Monthly | — | Mr. Prem Lal | documented |
| Report-25 | Upvc Fittings | Monthly | — | Mr. Prem Lal | documented |
| Report-26 | Swr Fittings | Monthly | — | Mr. Prem Lal | documented |
| Report-27 | Agri Fittings | Monthly | — | Mr. Prem Lal | documented |
| Report-28 | Toolroom Working — Machine wise Details with Manpower & Manhour | Daily ·sliceable | — | Mr. Ajay Kumar | documented |
| Report-29 | Wastage Management — Waste Item, Waste Create in a Week, Responsible Person of Dispose | Daily ·sliceable | — | — | documented |
| Report-30 | Total Manpower & Hours — According to all M/C details | Daily ·sliceable | — | HR- Bhw & Kh Mr. Shelendra Mr. Ankur Mr. Jitendra Mr. Vinod Mr. Gaurav Mr. Ajay | documented |
PTMT workbook
2026-08
1 ingested · 8 available — not yet built ·
14 documented
| Report | Description | Frequency | Unit | Owner | Status |
|---|---|---|---|---|---|
| Report-1 | FG Stock — Cistern, Seat Cover, PTMT | Every Monday | — | Mr. Ashish Bisht | available |
| Report-2 | BOP, Trading | Every Monday | — | Mr. Shyam | available |
| Report-3 | Packing | Every Monday | — | Mr. Shyam | available |
| Report-4 | RM | Every Monday | — | Mr. Alok Roy | available |
| Report-5 | Moulding M/C — Output & M/C Hours | Daily ·sliceable | — | Mr. Alok Roy | ingested |
| Report-6 | M/C & Item Wise Actual Production in KG & Pcs | Daily ·sliceable | kg | Mr. Alok Roy | documented |
| Report-7 | PTMT / Faucets / Acessories / Other | Daily ·sliceable | — | Mr. Alok Roy | available |
| Report-8 | Cistern, Seat Cover / Cabinet | Daily ·sliceable | — | Mr. Alok Roy | available |
| Report-9 | Maintenance — Date of Purchase | Monthly | — | Mr. Ramveer | available |
| Report-10 | Faucets — Mould Utilisation in Hours | Monthly | — | — | available |
| Report-11 | Accessories & Shower | Monthly | — | — | documented |
| Report-12 | Dept. wise Wastage Management | Every Monday | — | — | documented |
| Report-13 | Table & Packing Table — Person, Item, Production | Daily ·sliceable | — | Anuj Sir | documented |
| Report-14 | Line-1,2,3 — Person, Item, Plan & Actual | Daily ·sliceable | — | Anuj Sir | documented |
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
Pipe & Fitting — daily workbooks
Pipe & Fitting · Pipe
Data sheet used
Report-5/Report-12
Months with data
17 month(s)
Records parsed
0
Daily grain; ideal rate/hours joined from the monthly grid baseline. Emits: PIPE, MOULDING. Layout: long/matrix.
2025-04
2025-05
2025-06
2025-07
2025-08
2025-09
2025-10
2025-11
2025-12
2026-01
2026-02
2026-03
2026-04
2026-05
2026-06
2026-07
2026-08
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
5 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
2026-07
2026-08
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
5 month(s)
Records parsed
0
Daily grain; ideal rate/hours joined from the monthly grid baseline. Layout: blocks.
2026-04
2026-05
2026-06
2026-07
2026-08
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
5 month(s)
Records parsed
0
Daily grain; ideal rate/hours joined from the monthly grid baseline. Layout: matrix.
2026-04
2026-05
2026-06
2026-07
2026-08
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 (KH) — daily workbooks
Tanks (KH) · Tank
Data sheet used
PROD. REPORT
Months with data
5 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
2026-07
2026-08
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
Tanks (VN) — daily workbooks
Tanks (VN) · Tank_Vn
Data sheet used
PROD. REPORT
Months with data
5 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
2026-07
2026-08
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: 1Vsba-WDcYwSstEZsX37ntm_N05yPn0T5DzSkls9zRUw
Tanks (WB) — daily workbooks
Tanks (WB) · Tank_Wb
Data sheet used
PROD. REPORT
Months with data
5 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
2026-07
2026-08
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: 1-JVeDFTnFfoMjDMhvkOV5BE1rKjjO00chRKtUpO5iqQ
Daily-grain workbooks register here once their file IDs are added to the source registry.
Planning, Material & Maintenance tabs
On-demand domains — read from the same workbooks as daily data (no extra Drive sharing).
Phase 2A: Demand planning (Report-1).
Phase 2B: Material/BOP/packaging stock readiness (Report-2/3/4).
Phase 2C: Maintenance master (Report-16/8) + Manpower roster (Report-22/6).
None of these are loaded on the / dashboard.
PIPE
Report-1 — demand (CPVC)
Report-1 (A) — demand (UPVC)
Report-1 (B) — demand (AGRI)
Report-1 (C) — demand (SWR)
Report-2 — RM stock
Report-3 — BOP stock
Report-4 — PACK stock
Report-16 — maintenance master
Report-22 (A) — manpower (shift all)
Report-22 (B) — manpower (shift all)
PTMT
Report-1 — demand (faucet)
Report-1(A) — demand (cistern)
Report-1(B) — demand (seatcover)
Report-2 — BOP stock
Report-3 — PACK stock
Report-4 — RM stock
Report-8 — maintenance master
Report-6 (A) — manpower (shift 1st)
Report-6 (B) — manpower (shift 2nd)
Report-6 (C) — manpower (shift 3rd)
Derived Views (Phase 3)
/plan →
/plan — unified per-machine planning board. Joins Phase 2A–2C
on-demand loaders (planning, materials, maintenance, manpower) with existing
production/metrics. No new sheet reads — reuses cached data only. Never
loaded on /.
Feed & Tooling gates show grey until
Phase 2D lands.