Click to copy
I am comfortable copy-pasting and following instructions, but I am not a developer.
There is nothing to install for this one and no commands to type: it all happens inside Claude. If any instruction below implies a Terminal, translate it into the equivalent click path for me instead.
- Plain English. Define jargon the first time it appears.
- One step at a time, then wait for me to confirm before the next one.
- Tell me what success looks like at each step, and diagnose any error before moving on.
Follow the instructions below with those rules applied.
If you can browse the web, open and read this page in full first, it has the complete guide and every prompt you will run (the vault is under the-vault anchor): https://consultance.ai/library/allocator-manager-dd#the-vault . If you cannot open links, tell me and I will paste the page in, do not guess the prompts.
I want to SET UP the real workflow so Claude reviews an external manager on the actual manager materials, not just a chat demo. Walk me through it step by step. Treat me like an allocator or family-office CIO who has never built a Claude Project or installed an Office add-in, and define every term once.
**Route me before you set anything up.** There are three surfaces and the right one depends on what I am holding, so ask me first and then commit to one:
- **Claude app, private Project.** One manager, a handful of documents I can upload. Nothing to install. This is the common case, and if it fits me, say so plainly and do not talk me into anything heavier.
- **Claude Code, pointed at a folder.** A data room export, many files, spreadsheets to parse, several managers, or the same pass every quarter. It reads the documents off disk instead of me pasting them, and the outputs land as files I can compare on the next re-underwrite. Two ways in: the Claude desktop app's Code tab (no terminal), or the terminal install, which you walk me through one command at a time.
- **Excel add-in**, optional on top of either, so the sizing in prompt 09 and the tie-out in prompt 10 live in real formulas.
If I describe a folder, a data room, or several managers while asking for the Project path, tell me I am in the wrong place and move me to Claude Code before we start.
## Before any confidential material goes in
The manager materials go only to my own Claude account, never to the pack's author. Load confidential material only into an account whose data terms my firm has approved: a Team or Enterprise plan, or a personal plan with model training turned off in the privacy settings. Respect each manager's and data provider's terms.
## Path 1 (common case), a private Claude Project
Walk me through ONE step at a time, waiting for me to confirm each:
1. **What I need.** A Claude account. Pick **Claude Opus 5.5** in the model picker. Nothing to install.
2. **Create the workspace.** In Claude, create a new **Project** named for the manager. A Project is a workspace with its own knowledge. It is private to me unless I share it (sharing exists on Team and Enterprise).
3. **Load the materials.** The DDQ, PPM or LPA, audited financial statements, administrator returns series, quarterly letters with their exposure appendices, and any loan tape.
4. **Run prompt 01.** Pick my allocator type, the job, the asset class (hedge fund or private credit), and data source (A) upload. Give my thesis in two or three lines and name the person who signs.
5. **First-session drill: run prompt 02 before my own data.** It is a small test fund with known answers. Good output is five MATCH lines: the 2024 return fails to tie (8.4% audited against 9.6% marketed), the 2025 row reads OPEN because its audit is missing, the drawdown rebuilds to -3.1% against the -1.3% shown, the second lien breach is flagged, the two normal loan items are NOT flagged, and the PME test comes to 1.124. Any MISMATCH means stop and tell me which line.
6. **Run the pack on my manager.** CONVERSATION mode (the default) runs only the checks my thesis needs. FULL RUN goes 03 to 12: the one-page frame, the letters against the exposure appendices, investment DD, drawdown, operational DD, fees, sizing, the reconciliation gate, the memo with the case against on page two, and the red team.
7. **Gate it.** Prompt 10 ties every return to the audit and blocks the memo on a number that does not tie. An operational FAIL in prompt 07 is never overridden by a strong return. A named human signs the allocation. Not investment advice.
## Path 2, Claude Code on a folder
Claude Code needs a paid plan (Pro, Max, Team or Enterprise) or a Console account. The free Claude plan does not include it. If I am on the free plan, say so and offer the Project path.
1. Easiest: download the Claude desktop app and use its Code tab. No terminal.
2. Terminal instead: on Mac or Linux paste `curl -fsSL https://claude.ai/install.sh | bash`. On Windows PowerShell paste `irm https://claude.ai/install.ps1 | iex`. Success looks like the installer finishing and `claude` starting when I type it. If `claude` is not found, close and reopen the terminal.
3. Open the manager's folder, start Claude Code there, and paste prompt 01. Then continue from Path 1 step 5.
## Path 3 (optional), Claude for Excel
1. It needs a paid Claude plan (Pro, Max, Team or Enterprise) and Excel for Microsoft 365, Excel on the web, or Excel on Mac 16.46 or later.
2. Search for "Claude for Microsoft 365" in Microsoft AppSource and select "Get it now". Then open it from Home, Add-ins on Windows, or Tools, Add-ins on Mac, and sign in. Tell me where the button is in my version.
3. In prompt 01 choose data source (E) a mix, and say the workbook lives in Excel. For prompt 09 and prompt 10 say "build this into my workbook as real formulas".
4. Choose Claude Opus 5.5 if the add-in lists it, otherwise the most capable model it offers.
## Path 4 (optional), the public record desk in Claude Code
Prompts 13 to 15 build a small tool that pulls the manager's own SEC filings at a fixed date: every Form D fund they filed, a registered fund's monthly returns from N-PORT tied to the audited year, 13F concentration, and a luck test on the record. It uses edgartools (https://github.com/dgunning/edgartools, MIT). No key and no account: the SEC asks only for a name and email with every request.
1. Claude Code as in Path 2, in a new empty folder.
2. Install uv, the tool that sets up Python for the project, one command at a time. Mac or Linux: `curl -LsSf https://astral.sh/uv/install.sh | sh`. Windows PowerShell: `powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"`. Close and reopen the terminal. Success looks like `uv --version` printing a version.
3. Paste prompt 13. It creates the environment with `uv venv -p 3.12 .venv` and `uv pip install -p .venv/bin/python "edgartools==5.59.1" "pytest==9.1.1"`, which fetches Python 3.12 if the Mac only has the older system Python. These are the Mac and Linux paths; on Windows the environment folder is .venv\Scripts. Give it your own name and email for the SEC.
4. Good output: `4 passed` from pytest and an `ls -R` showing the scripts and tests. If a test fails, it stops and fixes the script; do not let it loosen a test.
5. Then prompt 14 with the manager's legal name from Form ADV (not the brand name) and the review date, then prompt 15. Anything it finds is tagged against your thesis like every other prompt.
## Rules for walking me through this
- One step at a time. Define every term once: Project, knowledge, DDQ, ODD, administrator, high water mark, side letter, `<review_gate>`, `{{TOKEN}}`.
- Do NOT tell me a step is "not possible." If I am on the Free plan, or on Excel 2016, 2019, iPad or Android, say plainly that the add-in will not run there and offer Excel on the web or the Project path.
- Claude Opus 5.5 for every judgment step. Claude Sonnet 5 only for a first read of a very large document set where speed or usage limits matter. Never switch model in the middle of a prompt.
- If the materials outgrow the surface we picked, stop and say so rather than working from the part you could read.
- A named human signs the allocation. Claude runs the review and ties the numbers; a person owns the decision. Not investment advice.
First message: ask me one question only, "What are you actually holding right now: one manager's documents you can upload, or a folder or data room with many files?" My answer decides the surface. Confirm the surface back to me in one line, then start step 1 on that path.