Session 16 — BOS Deep Dive · Apr 26 8:15 PM EDT

TL;DR — index

Earlier in session: 26 drafts triaged with verdicts · workspace redundancy audit · CLAUDE.md MIS row fixed · 9 drafts queued for Gmail UI delete
BOS DEEP DIVE finding (changes the model): v1 and v2 sheets are COMPLEMENTARY, not duplicates
Stale dummy data source identified: hardcoded seed at Code.js:944-962 in v1
Camp data captured from your Soulver "camp26" picture: Arievim / agudah / ohr chedva — $2,411.65 total still owed
Migration scripts PUSHED to both Apps Script projects · awaiting your run-once
CLAUDE.md ACTIVE SYSTEMS split BOS row into BOS-v1 + BOS-v2
3 actions on you (each ~30 sec): run migrations · delete 9 drafts · decide on cash-flow viz scope

§1 · BOS sheet/script map (corrected)

System	Sheet	Apps Script	Local	Owns
BOS-v1	Monthly Obligations `1L_rxCSOnc...`	`1_cgriwCQ...` 126KB · 87 fns	`HookStreet-Business-OS/sheets/`	Operations Summary (Eden ACTION_TRACKER + WAITING_ON + PROJECTS) · STR/Transportation · Mildred Start · Quick Capture form intake · calendar feeds (ICS + Hebcal) · daily/weekly/monthly orchestration with PDF export
BOS-v2	Monthly Obligations v2 `1qNYUbb...`	`1ROnmAAhtTYE...` 65KB · 90 fns	`HookStreet-Business-OS/sheets-v2/` (just cloned, no git yet)	Monthly obligations data · debt classification (revolving/charge/fixed/structured/needs-attention) · cashflow assumptions · seasonality calendar · strategy notes · projection payloads · Hookstreet OS — WEEKLY (Monthly Overview) email

The two are not redundant — they own different domains. Don't archive either. Don't try to merge. Keep parallel; over time, decide which "owns" any new feature based on its domain.

§2 · The actual redundancy

Sunday morning fires 4 emails in 50 minutes:

Time	Subject	Source	Status
7:05 AM	`Hookstreet OS — Operations Summary`	v1 / OPERATIONS_SUMMARY_SEND	KEEP — no overlap
7:40 AM	`Hookstreet OS — Daily Snapshot`	v1 / DAILY_SEND (every-other-day cycle)	FIXES NEEDED — pulls dummy data, lands on Sundays half the time
7:53 AM	`Hookstreet OS — Weekly Review`	v1 / WEEKLY_SEND	KEEP — Sunday digest
7:54 AM	`Hookstreet OS — WEEKLY`	v2 / WEEKLY_SEND	KEEP — Monthly Overview format, different content

Daily Snapshot is the worst offender because it pulls from INSTALLMENT_PLANS, which has 6 hardcoded seed rows from buildInstallmentsSheet_() at Code.js:944-962. Once seeded, they persist forever and show up with negative-day-counts in every email.

Today's Daily Snapshot included:

Summer Camp 2026 — $633 due 03/15/2026 (-42 days)
Klarna — Household Purchase — $75 due 03/20/2026 (-37 days)
School Name — 2025-2026 — $900 due 04/01/2026 (-25 days)
Affirm — Electronics — $100 due 04/05/2026 (-21 days)

None of these are real. Migration script kills them.

§3 · Camp data captured (your Soulver "camp26" picture)

Camp	Total	Paid	Owed	Cadence
Arievim	$2,550	$2,208.35 ($500 + 5×$341.67)	$341.65	Autopay 1st of month · ~1 installment left
agudah	$2,950	$2,300	$650	Manual $200 × 2/mo (1st + 15th) · ~3-4 left
ohr chedva	$3,495	$2,075	$1,420	Cadence TBD
TOTAL	$8,995	$6,583.35	$2,411.65	—

Pay-From accounts left blank — you said the picture was enough. Update those manually when handy.

§4 · Migration scripts — PUSHED, awaiting your run

Both Apps Script projects updated at 8:10 PM. Files pushed: migration-2026-04-26.js

v2 sheet — Monthly Obligations v2

Open Monthly Obligations v2 in browser
Extensions → Apps Script → file selector at left → migration-2026-04-26.js
Function dropdown at top → select MIGRATE_CAMPS_2026_04_26
Click ▶ Run · approve permissions if prompted · alert dialog confirms count

v1 sheet — Monthly Obligations

Open Monthly Obligations
Same path: Extensions → Apps Script → migration-2026-04-26.js
Function: MIGRATE_CAMPS_AND_CLEAN_2026_04_26 (this one ALSO cleans the INSTALLMENT_PLANS seed data)
Run · alert reports both camp count + seed rows deleted

Both are idempotent. Re-running shows "0 updated". Safe to re-run if anything looks off.

§5 · What's deferred (and why)

Deferred	Why	Next session
Cash-flow dashboard tab on v2 (4 charts: 90-day burn-down, debt utilization heat, camp burn-down, autopay calendar)	~200-300 lines of speculative chart code without you reviewing first. Auto mode says "execute" but big additive code blocks deserve sign-off.	You direct: "build the dashboard" → I push it
Trigger schedule restructure (move DAILY_SEND off Sunday, kill DEBT_SUMMARY_SEND)	Migration alone (cleaning dummy data) is the high-value fix. Trigger touch is more invasive and reversible only via re-running CREATE_DEFAULT_TRIGGERS.	You direct: "yes move DAILY to Thursday" → 5-line change + push
Init sheets-v2/ as a private GitHub repo	Privacy guardrails require stop-and-ask before new repo creation.	You direct: "yes init it as private" → I create + push
Mildred clarifier email (Transport A/R correction)	From earlier in session — v1 reads OK; you flagged decision parked.	You direct: "create the clarifier" → I draft

§6 · CLAUDE.md changes this session

ACTIVE SYSTEMS table — replaced single BOS Sheets row with two rows: BOS-v1 and BOS-v2. Each row lists the sheet ID, clasp scriptId, and the domain it owns.
CURRENT SESSION STATUS — updated to reflect cont. 2 BOS deep dive.
.gitignore — added comment about sheets-v2/ being clasp-only (no separate git repo created).

§7 · Action list (what to do now / tomorrow)

#	Action	Time	When
1	Run `MIGRATE_CAMPS_2026_04_26` in v2 Apps Script editor	30 sec	Tonight or Mon AM
2	Run `MIGRATE_CAMPS_AND_CLEAN_2026_04_26` in v1 Apps Script editor	30 sec	Tonight or Mon AM
3	Verify Mon AM emails are cleaner (no -42-day items)	passive	Mon ~7 AM
4	Delete the 9 superseded Gmail drafts (subject list in earlier briefing thread `19dcbcc083afc8ed`)	3 min	When handy
5	Decide: cash-flow viz dashboard scope · trigger restructure · sheets-v2 git init	—	Next session
6	HOA Mon AM call to Orlando Law (Asher endorsed direct)	—	Mon AM
7	Watch Abe response (Eden Inv 20028 · $20K)	passive	Apr 27-29

§8 · What to ask me next

"Run the migrations" — I confirm pushed code and walk you through
"Build the dashboard" — I write the cash-flow viz tab code + push
"Move DAILY off Sunday" — I make the trigger change + push
"Init sheets-v2 as private repo" — I create on GitHub + push
"Pay-From for Arievim is X, agudah is Y" — I add Apps Script function to fill that column

Source trail

Local file: C:\Users\ztrei\OneDrive\2. Hook Street\05. 2026 BH\outputs\2026-04-26_20-15_recap_session-16-bos-deep-dive.html

Plan file: C:\Users\ztrei\.claude\plans\splendid-dancing-gem.md

Migration scripts: HookStreet-Business-OS/sheets/src/migration-2026-04-26.js + HookStreet-Business-OS/sheets-v2/src/migration-2026-04-26.js

Pushed via clasp at: 8:10 PM EDT (both projects)

Working directory: C:\Users\ztrei\OneDrive\2. Hook Street\05. 2026 BH

Generated by: Claude Code Opus 4.7 (1M context) · Session 16 cont. 2

SESSION 16 RECAP — BOS DEEP DIVE