| Property | Window | Current | Recommended action |
|---|---|---|---|
| 9312 | May 22-25 (Memorial weekend + overlaps Shavuos 5/21-23) | UNBOOKED · pricing not surged | Push to $700-900/night with 3-night minimum. Shavuos overlap pulls extra Frum traffic — under-pricing leaves money on the table. |
| 9332 | Same | UNBOOKED · pricing not surged | Same. If 9332 listing quality is the broken lever, this is the wrong week to fight that — just match 9312. |
Action_List row 37 captures this as 🔴 High. Q21 queued.
Cloud Claude built it (rows 17-31, 5 holidays × 3 years). Two things to verify before Mildred uses it:
June 10-12 — that looks off. Shavuos 5787 is around May 31 – June 2 2027 (Diaspora). Worth a quick verify.Sep 25 – Oct 4 — Sukkos 5787 first day is the eve of Oct 1 (= Oct 2 by day-count). Range looks a few days early.Fix path: I open the workbook, correct the dates + reformat the Min Nights column as integers, push the file back. ~5 minutes. Tell me when you want me to do it (I'll wait — you're in there).
Questions_For_Sam| Q | Question | My recommendation |
|---|---|---|
| Q5 | Wife W2 floor: confirm $1,667/mo ($20K base ÷ 12)? | Confirm — that matches Chanie's stated salary basis. Cashflow_Assumptions is built on this. Just paste "Confirmed" into D5. |
| Q6 | Mildred handoff timing on STR_Brief? | Recommend Tuesday 5/19 at the existing weekly sync (10:30 AM EDT). Walk her through the brief, lock the cadence with her. Gives her a week to use it before Memorial Day post-mortem. |
| Q8 | STR opex: confirm $1,100/mo Utilities + $600/mo HOA placeholders? | Pull last 3 months' Duke Energy + Toho Water bills from Chase 6651/2528 export — verify before locking. I can do this from the CSVs you committed last night (Chase2528 + Chase6651 Activity 20260511.CSV). Say go and I'll produce the actuals. |
| Q10 | Hospitable.com timing? | Bump to August if summer (Jul-Sep) bookings stay at zero. Forward 6-mo book is currently 13 nights total — if that doesn't move by mid-June, Hospitable is the lever. Park for now. |
| Q12 | Tuition cadence: 10-mo (Sep-Jun, $0 Jul-Aug) or 12-mo even spread? | Use 10-mo. Tuition isn't actually paid Jul-Aug — Cashflow_Projection should reflect the real Aug/Sep $1K swing so you can plan summer cash. 12-mo even is a smoothing fiction. |
Per your message: "if the zero balance it's a card that I have open unless it's costing me annual fee and should not really need to know about that."
| Row | Card | Likely annual fee | Recommended action |
|---|---|---|---|
| R4 | Chase Chase - PV 6377 | $95 if Sapphire Preferred · $0 if Freedom Unlimited variant | Verify in Chase app → annual fee date. If $95, set a 30-day pre-renew alert. Keep Active=TRUE. |
| R14 | Amex Busn SPG - HSC | $95–$695 depending on variant (Bonvoy Business, Platinum, Gold) | This is the one most likely to have a fee. Verify + decide: keep for the perks, or close. |
| R19 | Z- Citi Simplicity Card 0157 | $0 (Citi Simplicity is no-AF) | Keep Active=TRUE. No alert needed. ✅ |
| R20 | C - US Bank Busn 7496 | Varies — most US Bank Business cards are $0; some are $95 (Triple Cash, Leverage) | Check. |
| R21 | Citi®/AAdvantage - 6965 (Barclay) | $99–$595 depending on Citi/AAdvantage variant | Likely has a fee. Verify + decide. |
| ? | 6th card (Cloud Claude's note got cut off) | — | Need to identify — I'll resolve when you hand off. |
What I propose:
Include in Debt KPI = FALSE on the ones that are at $0 (already done — Cloud Claude flagged them in column AB).This is 2 new columns + 1 alert rule, not a redesign. Say go when ready.
| DONE | Operating OS triage — DASHBOARD rebuilt, 5 superseded, 15 re-triaged. The 2-month-stale P0 I flagged in session 33 is closed. |
| DONE | 5 new tabs in Financial OS: Questions_For_Sam, Audit_Findings, ADR_Analysis, Income_Log, Bookings_Log, Original_Pro_Forma, Claude_Code_Prompt — 37 tabs total |
| DONE | 9332 mortgage variance resolved — was an escrow catch-up (tax + insurance miscalc). $4,706 in Obligations_Master is the correct figure. Action_List row 32 closed. |
| DONE | Pool Heat already active on Airbnb (row 26) · Pesach 2027 priced (row 27) · Sukkos 2026 priced (row 28) — three "high priority" rows closed |
| DONE | Sources_&_Provenance now has 8 new rows (A38:G47) for Citi 2550, ADRs, forward bookings, I/O mortgages, escrow catch-up, Buchanan pro-forma, wife W2, EG Inv #20028 |
| HELD | File rename (HookStreet_Operating_OS_v1.xlsx → Hookstreet_Operations.xlsx) — held by Cloud Claude per my coordination ask. Why held: the rename breaks path references in docs/ARCHITECTURE.md, docs/briefings/2026-05-12.md, and CLAUDE.md. We have to refresh those docs in the same commit as the rename. Tell me when you want to fire it — I'll do the rename + doc updates in one push. |
| Phase | What I do | What you do | Time | When |
|---|---|---|---|---|
| 0 — Workbook lock | Verify 9332 mortgage figure, fix Jewish calendar dates, fix Min Nights column type, ack the 6th zero-bal card, confirm Wife_View wiring plan | Answer Q5/Q6/Q8/Q10/Q12 · Revoke v1 share fully · Price Memorial Day · Sit with Mildred Tue 5/19 | 1-2 hrs me + ~30 min you (spread) | This week |
| 1 — Build new Google Sheets | Create Hook Street Financial OS v3 + Hook Street Operating OS v3. Port all 37 + 13 tabs. Set up named Tables (9 + 7). Recreate formulas in Sheets syntax. Set tab colors per Sharing_Map. Set up Sources_&_Provenance fresh. | Watch me work. Spot-check a few KPIs against Excel. | 4-5 hrs me | Next week (~5/19-23) |
| 2 — Build Apps Script v3 | Single bound project. ~50 v1 functions ported (sendFinancialDigest, WEEKLY_SEND, MONTHLY_SEND, etc.) + 4 Operating OS functions (syncCalendar, scanEmailForActions, sendOpsDigest, markDone) + 1 new function per cross-sheet need. | Authorize OAuth scopes once. Set Schwab credentials in PropertiesService once. | 6-8 hrs me | Week of 5/26 |
| 3 — Parallel shadow | New triggers fire to sam+v3@hookstreetcapital.com alongside v1. I diff outputs daily. Track drift. | Glance at the v3 alias inbox; ignore anything that looks wrong; tell me if you see weird numbers. | 30 days passive | 5/27 → 6/26 |
| 4 — Cutover | Disable v1 BOS triggers in script project 1_cgriwCQ.... Switch v3 to-line from sam+v3@ to sam@. Archive v1 Sheet (rename to ARCHIVED — Monthly Obligations v1 — 2026-06, revoke editor access, leave read-only). | Confirm by reply you trust the v3 numbers. Watch first 3 days post-cutover. | 1 hr me + 1 hr you | ~6/27 |
| 5 — Decommission | Delete v2 BOS triggers from script 1ROnmAAhtTYE.... Delete the v1 sheet's Apps Script project entirely (keep the data, kill the automation). | One final share check. | 15 min me | ~6/30 |
Total elapsed: 6-7 weeks from today. Most of that is the 30-day parallel-shadow which doesn't need your time.
| Layer | Where | Who reads | Who writes |
|---|---|---|---|
| Financial truth (debt, obligations, cashflow, STR P&L, Wife_View source) | New Google Sheet "Hook Street Financial OS v3" | Sam only | Sam manual + Apps Script for derived KPIs · Mildred via Expense_Inbox tab only (Blue, blue-input column) |
| Operating truth (calendar, STR ops, vendor stack, action queue, people, Mildred handoff) | New Google Sheet "Hook Street Operating OS v3" | Sam + Mildred (via tab colors — Blue tabs) | Sam + Mildred + Apps Script (syncCalendar, scanEmailForActions) |
| Wife's view | Separate Google Sheet "Family — Calm View" with IMPORTRANGE pulling Wife_View from Financial OS | Wife | Sam (writes the source cells); Wife sees read-only view |
| Mildred's view (if she needs more than what's in Operating OS Blue tabs) | Separate Google Sheet "STR Ops — Mildred" with IMPORTRANGE pulling Blue tabs from Operating OS | Mildred | Mildred writes to Operating OS Blue tabs; her sheet shows what she needs |
| Automation (digests, calendar sync, alerts, voice intake) | One Apps Script v3 project, bound to Financial OS sheet | — | Runs on triggers; Sam reads outputs as emails |
| Code repo (Apps Script source + this workspace) | zee78900/hookstreet-workspace (PRIVATE) | Sam + Desktop Claude | Desktop Claude commits; Sam reviews |
| Briefings + outputs | outputs/ folder + Cloudflare Pages at ops.hookstreetservices.com (gated by Cloudflare Access, Sam-only Google login) | Sam (iPad) | Desktop Claude generates; auto-deploys on push |
| What's firing today | Where it lives | When it stops | Replaced by |
|---|---|---|---|
| MIS Morning Brief 9:55 AM weekdays | MIS clasp 1yBMztL4 | NEVER (separate system, stays) | — |
| MIS Trade Action 2:05 PM | Same | NEVER | — |
| MIS Power Hour 3:00 PM | Same | NEVER | — |
| BOS Daily Snapshot ~7:40 AM | v1 clasp 1_cgriwCQ | Phase 4 cutover (~6/27) | Apps Script v3 sendFinancialDigest @ 7 AM |
| BOS Weekly Review Sun ~7:53 AM | Same | Same | Apps Script v3 WEEKLY_SEND |
| BOS Operations Summary Sun ~7:05 AM | Same | Same | Apps Script v3 sendOpsDigest (Operating OS) |
| BOS Monthly Overview day 1 | v2 clasp 1ROnmAAhtTYE | Phase 5 cleanup (~6/30) | Apps Script v3 MONTHLY_SEND |
| Mildred Start-of-Day 7:30 AM | v1 clasp | Phase 4 | v3 sendOpsDigest + Mildred subscribes to Operating OS via her sheet |
| Quick Capture form intake | v1 clasp | Phase 4 | v3 scanEmailForActions + voice intake routes to Action_List |
| Time | What | From | To |
|---|---|---|---|
| 7:00 AM | Financial Digest (obligations due in next 7 days · overdue · cards >80% util · cash runway) | v3 sendFinancialDigest | sam@ |
| 7:30 AM | Operating Digest (today's queue from Operating OS DASHBOARD · this week from ACTION_TRACKER · meetings on calendar) | v3 sendOpsDigest | sam@ + Mildred (CC, her version filtered) |
| 7:45 AM | Morning Brief (the proactive one — Calendar today · obligations next 7 · open P0 loops · MIS regime · urgent emails · clarifying questions · default actions if no reply · 1 rotated backburner item) | v3 new function (from docs/daily-cadence-system/PROACTIVE_MORNING_BRIEF_SPEC.md) | sam@ — REPLY changes today's picture |
| 9:55 AM Mon-Fri | MIS Morning Brief | MIS clasp (unchanged) | sam@ |
| 2:05 PM Mon-Fri | MIS Trade Action | MIS clasp | sam@ |
| 3:00 PM Mon-Fri | MIS Power Hour | MIS clasp | sam@ |
| 5:30 PM (future) | End-of-Day Wrap — what landed, what slid, tomorrow's pre-positioned 3 | v3 new function | sam@ |
| When | What | Who |
|---|---|---|
| Sun 7 AM | BOS Operations Summary (auto) | v3 → sam@ |
| Sun 7:30 AM | BOS Weekly Review (auto — loop closure check, top of week) | v3 → sam@ |
| Sun 6 PM | MIS Sunday Week-Ahead (unchanged) | MIS clasp → sam@ |
| Sun morning (you) | Read CONTEXT.md last session entry + scan SCOPE_BACKLOG · plan 3 priorities for the week | Sam |
| Tue 10:30 AM | Mildred sync (30 min max) — STR_Brief walked through, last week's wins, open loops on her plate, new asks, lock 7-day plan | Sam + Mildred (live call) |
| Tue afternoon | Mildred runs the STR_Brief actions, logs in tbl_ActionTracker | Mildred |
| Fri Sam EOD / Mildred EOW | Mildred writes 5-bullet rollup email — what shipped, what's blocked, next week's plan | Mildred → Sam |
| When | What | Who |
|---|---|---|
| 1st of month | BOS Monthly Overview (auto — net worth delta · debt service totals · savings progress · cashflow projection 20-mo) | v3 → sam@ |
| 1st of month | Sam refreshes Citi 2550 balance + min-due in Obligations_Master R27 (Action_List row 34) | Sam · ~5 min |
| 1st of month | Sam refreshes Wife_View B6 cash on hand (Action_List row 35) | Sam · ~3 min |
| End of month | Strategic Deep Insights briefing (3/6/12-month outlook) | Desktop Claude triggered by "do deep insights" / "monthly close" |
| 1st of month | Mildred pulls Chase 6651 + 2528 statements, exports as CSV to STR-Operations/ | Mildred |
| Re-pull Rocket Money 6-month export → update Cashflow_Assumptions | Sam · 20 min |
| Re-pull all bank CSVs (Chase 6651 + 2528 + primary cards) → STR cashflow tabs | Sam · 20 min |
| Sources_&_Provenance refresh sweep — any "Days Since Refresh" > 90? | Sam · 10 min spot check |
| Sharing audit — verify no domain grants snuck back in | Sam + Desktop Claude |
Obligations_Master (Sam)Installments (Sam)Pipeline tab (to be built — Phase 1+) — runs lead → contract → invoice → paidExpense_Inbox (to be built — Phase 1+) → SUMIF rolls into Cashflow_Assumptions Variable bucketFuture Client Onboarding Playbook (NOTES rows 47-75) — 8-element engagement letter + Day-1 ACH + Weekly status note + Phase gates| Person | Sees | Writes to | Cadence |
|---|---|---|---|
| Sam (you) | Everything (owner) | Financial OS Grey tabs + Operating OS all tabs + Apps Script outputs | Daily intake of 3 emails + Tuesday Mildred sync + Sunday plan + monthly refresh + quarterly deep work |
| Chanie (wife) | Separate "Family — Calm View" Sheet only (5 KPIs · no debt, no business) | Nothing (read-only) | Glances anytime · no requirement |
| Mildred (VA) | Operating OS Blue tabs (CALENDAR_RAW, STR_Brief, vendor stack, ACTION_TRACKER, WAITING_ON, PEOPLE) — NOT Financial OS at all · NOT Wife_View | Mildred_STR_Brief · ACTION_TRACKER rows assigned to her · Expense_Inbox (future) | Daily 9-5 EAT · Tuesday weekly sync · Friday EOW rollup |
| Desktop Claude Code (me) | Repo + both workbooks + .claude/ memory | Repo commits · doc updates · workbook diffs (when handed off) · briefings to outputs/ | Session-by-session · responds to your prompts |
| Cloud Excel Claude (in-workbook) | Whichever workbook is open with you | Excel tabs · Claude Log · Cross_Workbook_Briefing · Questions_For_Sam | Whenever you're in Excel |
| Apps Script v3 (post-migration) | Both Google Sheets (read) + Calendar (read) + Gmail (search) | Email outputs · derived KPI cells · Wife_View source cells | Time triggers · onEdit triggers · onFormSubmit triggers |
| This workspace repo | PRIVATE ✅ |
| 11 Sam-content repos | All PRIVATE ✅ |
| 3 marketing repos (services-site, abnbcalc, lawn-coop) | PUBLIC by design ✅ |
| v1 Google Sheet sharing | ⚠ Domain READER (partial revoke) — should be NO domain grant. 30-sec click to finish. |
outputs/ folder | Tracked in PRIVATE repo; will deploy to Cloudflare Pages with Cloudflare Access (Sam-only Google login) |
| Apps Script secrets posture | v1 Code.js verified 0 secrets · v3 will use PropertiesService from day one |
| Wife_View / Mildred_View architecture | Plan locked — separate Sheets with IMPORTRANGE; privacy fails closed, not open |
| Decision | Default if you don't reply |
|---|---|
| Confirm Q5/Q6/Q8/Q12 (5 open questions) | I use my recommendations above |
| Annual fee dates on the 6 cards | I add the column blank and you fill 3 minutes per card when you're in each app |
| Memorial Day pricing — execute now or wait? | Execute now — 10 days out, calendar gap is real money |
| Full revoke of v1 share — tonight or this week? | This week max — file rename will overwrite it anyway, but the leak is open until then |
| Mildred handoff timing (Q6) | Tuesday 5/19 at the 10:30 AM sync |
| File rename go-time | I do the rename + doc refresh at start of Phase 1 (~5/19) |
| This briefing | outputs/2026-05-12_14-03_briefing_session-34-action-and-future-proofing.html |
| Session 33 close briefing | outputs/2026-05-12_02-13_recap_session-33-close.html |
| v1 vs Excel audit | outputs/2026-05-12_00-10_audit_monthly-obligations-v1-vs-excel.html |
| Cross-workbook handoff | docs/briefings/2026-05-12.md |
| Systems architecture | docs/ARCHITECTURE.md |
| Trading rules | docs/TRADING_RULES.md |
| Workspace audit | docs/WORKSPACE_AUDIT.md |
| Weekly cadence + Mildred plan | docs/CADENCE.md |
| Proactive Morning Brief spec | docs/daily-cadence-system/PROACTIVE_MORNING_BRIEF_SPEC.md |
| Cloudflare private-deploy runbook | docs/HOW_TO/pwa-private-deploy.md |
| v1 sharing audit | outputs/v1-sharing-audit.json |
| 9 archived v1 rows | outputs/2026-05-12_v1-archived-rows.csv |
| v1 Code.js secret grep | outputs/v1-secrets-grep-result.md |
| The two workbooks (on disk, OneDrive-synced to iPad) | Monthly Obligations.xlsx · HookStreet_Operating_OS_v1.xlsx |