Review the Capsule CRM pipeline with honest weighted totals

**Objective:** Review the open sales pipeline for `{owner-name}` (leave blank for everyone) for deals expected to close within `{close-within-days}` days (default 90), including any that are already past their expected close date.

**Step 1: Learn the pipeline**

Call `capsule-crm-get-milestone` with no filters. Note each milestone's name, probability and complete flag. Milestones with complete = true are closing milestones (Won and Lost). Order the open milestones by probability, lowest first; this is the pipeline order.

**Step 2: Pull open deals**

Call `capsule-crm-get-opportunity` with expected-close-date.to = today plus {close-within-days} days, owner-name = {owner-name} when given, and max-records = 500. Leave expected-close-date.from empty so overdue deals are included. Drop any row with a closed-on-date or whose milestone-name is a closing milestone.

**Step 3: Analyse**

* Weighted value = value x probability / 100. Use the deal's own probability; fall back to its milestone's probability when empty.
* Group by milestone in pipeline order: count, total value, weighted value.
* Never add values across different currencies. Total each currency separately.
* Flag: expected close date before today; no value; probability 0 on an open milestone; no expected close date.

**Step 4: Report**

1. A table by milestone: milestone, count, total value, weighted value (per currency).
2. The ten deals with the highest weighted value: name, party, owner, milestone, value, probability, expected close date.
3. The flagged deals, grouped by flag, each with its name, party and owner.
4. Two or three sentences on where the pipeline is thin or overloaded.

**Rules & Guidelines:**

* This prompt is read-only. Do not call `capsule-crm-add-note`, `capsule-crm-update-note`, `capsule-crm-add-task`, `capsule-crm-update-task`, `capsule-crm-add-opportunity`, `capsule-crm-update-opportunity`, `capsule-crm-add-case`, `capsule-crm-update-case`, `capsule-crm-add-party` or `capsule-crm-update-party`.
* Report the numbers as they are stored. Do not re-forecast probabilities.

**Validation:**

* If no open deals match, say so and state the filters you used.
* If {owner-name} matches no deals, call `capsule-crm-get-user` with name.contains = {owner-name} and suggest the closest real user names.
* If the read returns exactly max-records rows, say the pipeline is truncated.