Project Control — rekon-odc-odp

Continue prompt

{
  "project": "rekon-odc-odp",
  "mission": "Execute the FTTH per-station reconciliation workbook automation workflow for Telkom-side fiber infrastructure, filling Rekon.xlsx from Core Connection files using update_rekon.py on the Windows host following per-station counting rules and green-fill conventions while producing versioned output workbooks (Rekon (vN).xlsx).",
  "read_first": [
    "/data/vault/wiki/projects/rekon-odc-odp.md (primary project vault note with fill rules, script references, and output conventions)",
    "/data/vault/wiki/patterns/Excel and Python on Windows.md (mandatory execution rules for Python 3.12 and Excel COM on Windows when modifying workbooks)",
    "/data/vault/wiki/preferences/Operator Profile.md (operator standards for deliverable formatting, Bahasa Indonesia copy-paste readiness, and versioned file suffixes)",
    "/data/vault/wiki/projects/_index.md (vault project index showing active Aug 2026 status)",
    "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/rekon-odc-odp.md",
    "expect": "Markdown document with YAML frontmatter (title: \"Rekon ODC-ODP\", status: developing, tags: [projects, ftth, rekon]) describing FTTH per-station reconciliation workbook automation from Core Connection files via update_rekon.py, green-fill conventions, and Rekon (vN).xlsx output rules."
  },
  "project_context": {
    "what_it_is": "Rekon ODC-ODP is an off-VM FTTH (Fiber to the Home) per-station reconciliation workbook project (Telkom-side work) active as of August 2026. It reconciles optical distribution cabinet (ODC) and optical distribution point (ODP) connection data.",
    "domain_notes": "The workflow processes Core Connection input data to populate the target reconciliation workbook (Rekon.xlsx) via update_rekon.py. Counting and section rules require processing entries per station, marking completed entries with a green-fill cell formatting convention, and saving all deliverables to newly versioned files (e.g. Rekon (vN).xlsx) without ever overwriting the original source workbook."
  },
  "tech_stack": {
    "codebase": "none on VM101 (off-VM / vault-only project; tracking and rules live in vault, automation scripts and workbooks execute on Windows host)",
    "script_automation": "update_rekon.py (Python script to process Core Connection files and fill Rekon.xlsx)",
    "spreadsheet_automation": "Microsoft Excel (.xlsx) with formatting rules (green-fill cell convention for completed entries, per-station counting rules)",
    "runtime_environment": "Python 3.12 on Windows (C:\\Users\\dimas\\AppData\\Local\\Programs\\Python\\Python312\\python.exe; avoiding empty Hermes venv on PATH) and Excel COM/pywin32 for workbook manipulation"
  },
  "current_state": {
    "summary": "Active off-VM reconciliation automation project (status: developing, updated 2026-08-11). Core Connection files are processed into Rekon.xlsx using update_rekon.py following per-station fill rules and green-fill completion formatting. No code, Python scripts, or Excel workbooks reside on VM101 disk.",
    "source_of_this_status": "Vault page /data/vault/wiki/projects/rekon-odc-odp.md (updated 2026-08-11) cross-referenced with output/census-latest.json (invisible_projects) and /data/vault/wiki/projects/_index.md."
  },
  "repo_locations": {
    "gitea": "none (no Gitea repository on VM101; project artifacts are managed off-VM on Windows workstation)",
    "local_clone": "none on VM101 (off-VM project tracked via vault page /data/vault/wiki/projects/rekon-odc-odp.md only)",
    "windows_execution_environment": "Windows host running update_rekon.py against local Core Connection files and Rekon.xlsx"
  },
  "key_files": {
    "/data/vault/wiki/projects/rekon-odc-odp.md": "Primary on-VM project note defining reconciliation workflow, update_rekon.py usage, per-station fill rules, and versioned output rules",
    "/data/vault/wiki/patterns/Excel and Python on Windows.md": "Execution rules for Windows Python 3.12 and Excel COM automation, preventing workbook corruption and OneDrive sync collisions",
    "Rekon.xlsx": "Off-VM source reconciliation workbook (not stored on VM101)",
    "update_rekon.py": "Off-VM Python script that populates Rekon.xlsx from Core Connection files (executed on Windows host)",
    "Core Connection files": "Off-VM source data files holding optical connection records (not stored on VM101)"
  },
  "next_steps": [
    "When executing reconciliation runs on the Windows host, ensure the Python environment uses Python 3.12 (C:\\Users\\dimas\\AppData\\Local\\Programs\\Python\\Python312\\python.exe) instead of the empty default Hermes venv on PATH.",
    "Run update_rekon.py against the latest Core Connection input files to populate the target reconciliation sections per station.",
    "Verify counting rules and section rules during population, ensuring completed reconciliation entries follow the green-fill cell highlight convention.",
    "Save the updated workbook to a new versioned file Rekon (vN).xlsx (e.g. Rekon (v2).xlsx) and verify that the original Rekon.xlsx is untouched.",
    "If modifying workbooks with formulas or legacy formats on Windows, follow [[Excel and Python on Windows]] patterns (stage local copy, write via Excel COM with Visible=True, save with SaveCopyAs to avoid OneDrive sync collisions).",
    "Update /data/vault/wiki/projects/rekon-odc-odp.md with any new fill rules, script updates, or station milestones."
  ],
  "constraints": [
    "Never overwrite the original Rekon.xlsx: all script and manual output must be written to a newly versioned workbook file (e.g., Rekon (vN).xlsx / Rekon (v2).xlsx).",
    "Green-fill convention: completed reconciliation entries must be marked using the green-fill cell highlighting convention.",
    "Per-station processing: reconciliation counting and section rules must be evaluated and filled per individual station.",
    "Off-VM boundary: do not fabricate on-VM repositories or Docker containers on VM101; this is an off-VM Excel/Python reconciliation project tracked via Obsidian vault notes.",
    "Windows Python runtime: always execute Python automation scripts using Python 3.12 (C:\\Users\\dimas\\AppData\\Local\\Programs\\Python\\Python312\\python.exe) rather than the default empty Hermes venv on PATH.",
    "Excel workbook handling: when editing client spreadsheets on Windows, follow [[Excel and Python on Windows]] to prevent OneDrive AutoSave corruption and formula loss (use local staging and Excel COM writes)."
  ],
  "known_staleness_warning": "The vault page (/data/vault/wiki/projects/rekon-odc-odp.md) was last updated on 2026-08-11 (14 days ago). Because update_rekon.py, Core Connection files, and Rekon.xlsx workbooks reside and execute off-VM on the Windows host, the on-VM vault documentation may lag behind ongoing station reconciliation runs or adjustments to fill rules.",
  "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/rekon-odc-odp.md + /data/vault/wiki/patterns/Excel and Python on Windows.md + /data/vault/wiki/preferences/Operator Profile.md + /data/vault/wiki/projects/_index.md"
  }
}
rekon-odc-odp

Continue prompt

Detail

Observed Signals

1. What's Left

2. Continue / Drop Suggestion

3. Dynamic Milestone Estimate
