Project Control — pjt-cawang

Continue prompt

{
  "project": "pjt-cawang",
  "mission": "Execute the weekly progress reporting loop (WhatsApp chat/photo analysis -> S-curve in Excel -> PPTX deck for owner meeting) for Pompa 2 and Fire System, maintain and populate the programmatic python-pptx PCM deck generator for VSD and IPAL, and synchronize off-VM contract and field milestones into the vault.",
  "read_first": [
    "/data/vault/wiki/projects/pjt-cawang.md (primary project family note detailing weekly reporting loops, Pompa 2, VSD, IPAL, and client naming rules)",
    "/data/vault/projects/pjt-cawang-pcm.md (specification of the programmatic PCM deck generator, shared pcm_engine.py, slide architecture, and VSD/IPAL content schemas)",
    "/data/vault/wiki/patterns/Excel and Python on Windows.md (mandatory execution rules for Python 3.12 and Excel COM on Windows when editing legacy workbooks like VSD-1.xlsx)",
    "/data/vault/wiki/projects/cctv-bendung.md (CCTV sibling project at PJT II UW IV with margin model and bid context)",
    "/data/vault/wiki/projects/pjt2-scada.md (SCADA webapp at PJT II RG1 pump station; client domain conventions and infrastructure context)",
    "output/census-latest.json (confirms invisible, off-VM, vault-only status with zero on-VM containers or git repositories)"
  ],
  "verification_anchor": {
    "command": "cat /data/vault/wiki/projects/pjt-cawang.md && echo '---' && head -n 25 /data/vault/projects/pjt-cawang-pcm.md",
    "expect": "Markdown documents with frontmatter (title: \"PJT Cawang (family)\", status: developing) detailing SMS construction projects (Fire System, Pompa 2, VSD, IPAL) at Perum Jasa Tirta II, the weekly WhatsApp reporting loop, and the python-pptx PCM deck generator architecture."
  },
  "project_context": {
    "what_it_is": "PJT Cawang is an umbrella family of SMS construction, rehabilitation, and electrical engineering projects at Perum Jasa Tirta II (PAB DKI Cawang site). The sub-projects include Pompa 2 rehabilitation, Fire System, Variable Speed Drive (VSD), and IPAL (waste water treatment), supported by automated weekly progress report workflows and programmatic Pre-Construction Meeting (PCM) deck generators.",
    "domain_notes": "All client-facing deliverables, decks, and correspondence must use the official client name 'Perum Jasa Tirta II' (never the informal site abbreviation 'Cawang' alone). Deliverables are primarily in Bahasa Indonesia. The project encompasses two primary off-VM automation workflows: (1) a weekly progress reporting loop that processes field WhatsApp chat exports and photos into S-curve spreadsheets and owner meeting decks, and (2) a 28-slide programmatic PCM deck generation suite using python-pptx with a shared layout engine (pcm_engine.py) and per-project data modules (content_vsd.py, content_ipal.py)."
  },
  "tech_stack": {
    "codebase": "none on VM101 (off-VM / vault-only project; tracking and specifications live in vault, automation scripts execute on Windows host)",
    "presentation_automation": "python-pptx (shared engine pcm_engine.py + project content files content_vsd.py and content_ipal.py, producing 28-slide PCM decks)",
    "spreadsheet_automation": "openpyxl (for reading/generating weekly logs) and Microsoft Excel COM via pywin32 (Visible=True, SaveCopyAs for legacy workbooks like VSD-1.xlsx and S-curves)",
    "runtime_environment": "Python 3.12 on Windows (C:\\Users\\dimas\\AppData\\Local\\Programs\\Python\\Python312\\python.exe; avoid default empty Hermes venv on PATH)",
    "reporting_skill": "weekly-progress-report-from-whatsapp (custom skill for parsing chat exports and updating progress logs)"
  },
  "current_state": {
    "summary": "Active off-VM project family (status: developing, updated 2026-08-11). Weekly reporting loop active for Pompa 2 and Fire System (week anchors: Fire W-7 = 2026-05-26, Pompa W-1 = 2026-05-21; field groups dropped LAPORAN templates in July 2026, requiring free-form chat and photo analysis). Programmatic PCM deck generators established for VSD and IPAL (28 slides each); awaiting incoming SPMK/contract, final RAB S-curves, technical datasheets, and drawings to populate real data. No code or workbooks reside on VM101 disk.",
    "source_of_this_status": "Vault pages /data/vault/wiki/projects/pjt-cawang.md (updated 2026-08-11) and /data/vault/projects/pjt-cawang-pcm.md (updated 2026-07-23), cross-referenced with output/census-latest.json invisible_projects."
  },
  "repo_locations": {
    "gitea": "none (no Gitea repository on VM101; project artifacts are managed off-VM in OneDrive folders)",
    "local_clone": "none on VM101 (off-VM project tracked via vault pages /data/vault/wiki/projects/pjt-cawang.md and /data/vault/projects/pjt-cawang-pcm.md)",
    "windows_project_roots": "Pompa 2: C:\\Users\\dimas\\OneDrive - Business\\SMS\\PJT Cawang\\Pompa 2\\Claude\\; Fire System: C:\\Users\\dimas\\OneDrive - Business\\SMS\\PJT Cawang\\Fire System\\PCM\\; VSD: C:\\Users\\dimas\\OneDrive - Business\\SMS\\PJT Cawang\\VSD\\; IPAL: C:\\Users\\dimas\\OneDrive - Business\\SMS\\PJT Cawang\\IPAL\\; Shared PCM engine: C:\\Users\\dimas\\OneDrive - Business\\SMS\\PJT Cawang\\pcm_engine.py"
  },
  "key_files": {
    "/data/vault/wiki/projects/pjt-cawang.md": "Primary on-VM project family note documenting reporting loops, Pompa 2, VSD, IPAL, and client naming rules",
    "/data/vault/projects/pjt-cawang-pcm.md": "Detailed specification of the python-pptx PCM Deck Generator, slide structures, and content schemas for VSD and IPAL",
    "/data/vault/wiki/patterns/Excel and Python on Windows.md": "Windows Python and Excel COM execution rules, preventing formula corruption and OneDrive conflicts",
    "C:\\Users\\dimas\\OneDrive - Business\\SMS\\PJT Cawang\\pcm_engine.py": "Shared python-pptx layout engine with color palettes, slide frames, table styles, and S-curve chart helpers",
    "C:\\Users\\dimas\\OneDrive - Business\\SMS\\PJT Cawang\\VSD\\content_vsd.py": "Project data dictionary (BRAND, WBS, SPEK, GANTT, SCURVE) for VSD PCM deck generation",
    "C:\\Users\\dimas\\OneDrive - Business\\SMS\\PJT Cawang\\IPAL\\content_ipal.py": "Project data dictionary for IPAL PCM deck generation",
    "VSD-1.xlsx": "Legacy Excel workbook holding VSD kurva-S (must be edited via Excel COM only)"
  },
  "next_steps": [
    "When processing weekly WhatsApp field updates for Pompa 2 or Fire System, parse free-form chat messages and photos directly (do not expect the dropped LAPORAN template), obtain user approval for proposed S-curve deltas in chat, and inspect deck tail slides to prune stale June template slides before exporting PPTX.",
    "For VSD and IPAL PCM decks, ingest incoming SPMK/contract details into CONTENT[\"BRAND\"], finalized RAB values into CONTENT[\"LINGKUP\"] bobot % and SCURVE arrays, and vendor technical datasheets into SPEK_TEKNIS_1 / SPEK_TEKNIS_2 in content_vsd.py and content_ipal.py.",
    "Place project technical drawings and logos (owner_logo.png, vendor_logo.png) into the respective assets/ directories and rebuild 28-slide PCM decks via build_pcm.py using Python 3.12 on Windows.",
    "When editing legacy S-curve workbooks (such as VSD-1.xlsx), execute modifications strictly through Windows Excel COM (Visible=True on local temp copy, SaveCopyAs with (v2) suffix) following [[Excel and Python on Windows]].",
    "Synchronize contract milestones, reporting week anchors, and progress percentages back into /data/vault/wiki/projects/pjt-cawang.md."
  ],
  "constraints": [
    "Client naming convention: User-facing labels, decks, and reports must always say \"Perum Jasa Tirta II\" (or \"PJT II PAB\"), never \"Cawang\" alone (path name ≠ project name).",
    "Report language: All client and owner-facing report content, slides, and S-curve documentation must be in Bahasa Indonesia.",
    "User approval convention: Always propose S-curve progress percentage updates to the user in chat and obtain explicit approval before modifying workbooks or presentation decks.",
    "Template drop handling: Both field WhatsApp groups dropped the formal LAPORAN template in July 2026; a parser result of reports: [] is an artifact of the missing template, so the agent must analyze free-form chat messages and photos instead of failing.",
    "Deck tail inspection: The Pompa deck generator tends to leak stale June template slides; always inspect and verify the tail of generated decks before releasing to the user.",
    "Legacy workbook editing: For VSD-1.xlsx and other legacy client spreadsheets, never write via openpyxl directly; write via Excel COM (Visible=True on a local staged copy) to prevent formula loss and OneDrive AutoSave corruption.",
    "Off-VM boundary: Do not invent on-VM repositories or Docker containers on VM101; this is an off-VM reporting and deck automation project whose state on VM101 is tracked via Obsidian vault notes.",
    "Python runtime on Windows: Always execute automation scripts with Python 3.12 (C:\\Users\\dimas\\AppData\\Local\\Programs\\Python\\Python312\\python.exe), never the default PATH python (Hermes venv)."
  ],
  "known_staleness_warning": "The primary vault page (/data/vault/wiki/projects/pjt-cawang.md) was last updated on 2026-08-11 (14 days ago), and the PCM deck generator spec (/data/vault/projects/pjt-cawang-pcm.md) was last updated on 2026-07-23. Because weekly reporting cycles and PCM contract milestones occur off-VM in WhatsApp groups and OneDrive folders, the on-VM vault notes may lag behind recent field progress, SPMK issuances, or S-curve advancements.",
  "handoff_metadata": {
    "created": "2026-08-25",
    "created_by": "project-control automated continue-prompt generator",
    "all_facts_sourced_from": "census-latest.json + /data/vault/wiki/projects/pjt-cawang.md + /data/vault/projects/pjt-cawang-pcm.md + /data/vault/wiki/patterns/Excel and Python on Windows.md + /data/vault/wiki/projects/cctv-bendung.md + /data/vault/wiki/projects/pjt2-scada.md"
  }
}
pjt-cawang

Continue prompt

Detail

Observed Signals

1. What's Left

2. Continue / Drop Suggestion

3. Dynamic Milestone Estimate
