Manufacturing Ops Strategic Project Control
SOURCE_1Google Spreadsheet (dibagikan lewat tautan)Tersambung
Spreadsheet Project Control (CI Lead), dibagikan lewat tautan sejak 18 Nov 2026 dan diunduh sebagai xlsx. Sheet: Project_List, Task_Detail, Issue_Log, Setting, dll.
Dataset
Setting
Menampilkan 1–12 dari 12 baris
| Baris sheet | High | Open | Issue | Kolom C | Kolom E | Kolom G | Kolom I | Kolom K | Kolom M | Kolom O | On Hold | Not Started | Operations (COO) | P1 People & Culture | 2026-10-05T00:00:00.000Z | Tanggal mulai timeline Gantt (disarankan hari Senin) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | Medium | In Progress | Risk | Cancelled | On Track | Production | P2 Cost & Productivity | 17/11/2026 | Tanggal cut-off status (default = hari ini) | |||||||
| 6 | Low | Closed | Decision Needed | At Risk | Engineering | P3 Digital & Data | 10% | Toleransi On Track (progress boleh tertinggal dari plan) | ||||||||
| 7 | Delayed | QAQC | P4 Quality & Compliance | 25% | Toleransi At Risk (di atas ini = Delayed) | |||||||||||
| 8 | Completed | PPIC | P5 Supply Chain & Planning | |||||||||||||
| 9 | On Hold | Procurement | P6 Infrastructure & NPD | Logika status otomatis: | ||||||||||||
| 10 | Cancelled | Warehouse & Logistics | Completed : progress = 100% | |||||||||||||
| 11 | Fulfillment | Not Started: cut-off < tanggal start dan progress 0% | ||||||||||||||
| 12 | R&D | On Track : progress ≥ planned% − toleransi On Track | ||||||||||||||
| 13 | Finance | At Risk : progress ≥ planned% − toleransi At Risk | ||||||||||||||
| 14 | HC | Delayed : di bawah itu, ATAU sudah lewat tanggal end tapi belum 100% | ||||||||||||||
| 15 | All Dept. | Override : isi kolom 'Status Override' (On Hold / Cancelled) untuk mengunci status | ||||||||||||||
| 16 | Planned% : (cut-off − start + 1) / durasi, dibatasi 0–100% |
Data mentah asli tersimpan apa adanya per pengambilan yang isinya berbeda (1 versi).