VG Home Buyers · Internal

Live Systems Index

Every operational dashboard, sheet, and scheduled job that VG runs day to day. This is not on the client portal — it's the back-of-house inventory of the things that produce, refresh, or surface the data.

Generated: 2026-05-13 · hand-curated v1  ·  Source of truth: workspaces/*/config/
Google Sheets · Live Dashboards

Sheets that are refreshed by Python jobs and consumed by the team directly. IDs pulled from each workspace's config — not duplicated by hand.

Construction Cost Intelligence — Live
CCI · Live
The big one. 30+ tabs: Dashboard, Action Center, Work In Progress, per-property tabs (120 Beverly, 1309 Graymill, 185 Fernwood, 2087 Dogwood, 2154 Shackamaxon, 25 Warren, 32 Clinton, 519 Highland, 52 Wildwood), plus PM queues, Estimate Builder, Budget Summary, and the QuickBooks raw-data backing tables.
Sheet ID
1cPFpCUw33Th_vJOy1DvAwao0bc8UqmzDFMdXKUfxN-8
Owner workspace
workspaces/ops-dashboard/
Config
config/google_sheets_targets.json → "live"
Refreshed by
ops-dashboard scripts (on-demand)
Open Sheet ↗ Workspace Docs
PM Workbook — Live
PM · Live
QB + Vendor Payment Tracker driven. 9 per-property tabs in 3-zone layout (PM status / financial / forecast), 16 setup tabs, 43 named ranges. Refreshed nightly at 06:00 via launchd; QB OAuth shared with Actualsboard.
Sheet ID
1dkRm4vk-4uLg86MQuPsfHe22SK8HIPLACikmSbLcmH8
Owner workspace
workspaces/pm-workbook/
Config
config/workbook_config.yaml → "pm-workbook-live"
Refreshed by
com.vg.pm-workbook.refresh (06:00 daily)
Open Sheet ↗ Workspace Docs
PM Workbook — Staging
PM · Staging
Refresh-testing twin of the live PM Workbook. Use this to validate config changes before pointing the scheduled job at live.
Sheet ID
18gXFqauBQLOqq9yB24c51dVMhgfHgMzvc9-8v9ZUO_o
Owner workspace
workspaces/pm-workbook/
Config
config/workbook_config.yaml → "pm-workbook-staging"
Open Sheet ↗
Vendor Payment Tracker (VPT)
VPT
Source-of-truth for vendor payment status. Consumed by the PM Workbook refresh (Tracker tab) to compute financial rollups per property.
Sheet ID
1FEVrSgjbPo-NgIQ3bDoQIumpX5DvzM2Dmj4HnrFSQNY
Used by
pm-workbook refresh (Tracker tab)
Open Sheet ↗
HTML Reports · Generated Snapshots

Dated HTML reports produced by Python generators. Each run writes a new file under published/reports/; the latest dated file is the current view.

Actualsboard
HTML · Report
QB API → HTML actuals-vs-budget report. Portfolio Matrix with phase ordering, CustomerRef property tagging, 8 CCI implementations (WO names, % burned, severity, financial, data-as-of, drill-down, PM progress, badges). Run on demand; QB OAuth shared with PM Workbook.
Owner workspace
workspaces/actualsboard/
Generator
scripts/build_report.py
Latest run
See index for current date (construction + non-construction + per-property detail)
Schedule
On-demand (no cron); older runs auto-pruned to _archive/reports/
Open Actualsboard Archived Runs
Scheduled Jobs · launchd

Cron-style automation managed via launchd. Plist files live at ~/Library/LaunchAgents/. Use launchctl list | grep vg to see status.

PM Workbook · Daily Refresh
06:00 · Daily
Pulls QB actuals + VPT data, regenerates the 9 property tabs in the live PM Workbook. Runs from the pm-workbook venv against scripts/refresh.py --target pm-workbook-live.
Label
com.vg.pm-workbook.refresh
Plist
~/Library/LaunchAgents/com.vg.pm-workbook.refresh.plist
Stdout log
~/Library/Logs/pm-workbook-refresh.out.log
Stderr log
~/Library/Logs/pm-workbook-refresh.err.log
Plist Source