build_executive_report
Creates a single-sheet executive report with key statistics, charts, and risk callouts for decision-makers. Replaces the target sheet on re-run.
Instructions
ModelRisk: Build a single-sheet executive report for a decision-maker. Drops a curated dashboard onto a new sheet with: title band, headline numbers (mean / P5 / P50 / P95 / stdev — colored by volatility), histogram + cumulative chart of the primary output, tornado of top N sensitivity drivers, a stats table for the primary plus any secondary outputs, and auto-generated risk callouts framed in plain English ('90% confident X lands between A and B', 'tail risk Y% above mean', 'primary driver is Z'). Idempotent — re-running replaces the sheet. Use this when the user asks for a decision-maker-facing summary rather than raw stats.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| title | No | Report title shown in the top band. Default: 'Simulation Report — <primary_output>'. | |
| subtitle | No | Subtitle shown beneath the title. Default: '<N> iterations · <today's date>'. | |
| sheet_name | No | Target sheet name. Default 'Executive_Report'. Replaced if it already exists. | Executive_Report |
| top_drivers | No | How many inputs to show in the tornado mini-chart. | |
| workbook_name | No | Workbook name. Omit for the active workbook. | |
| primary_output | Yes | The single output the report focuses on (e.g. 'NPV', 'TotalCost'). Headline numbers and the histogram + tornado are about this output. | |
| secondary_outputs | No | Additional outputs to include in the stats table. The primary output is always first; these appear below. | |
| contingency_percentile | No | The 'high-side' percentile to highlight in the headline. Default 0.90 (P90). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||