create_aggregate_mc
Build a VoseAggregateMC formula in Excel to simulate aggregate losses by combining a frequency cell and a severity object cell. Set target cell and optional limits to model total risk.
Instructions
ModelRisk: Build a VoseAggregateMC(n, distribution, ...) formula that simulates the aggregate of a (possibly random) number n of i.i.d. severity draws. n and distribution are cell references — n points at a frequency cell, distribution at a severity object cell (built with a VoseObject function).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"workbook": "<workbook>",
"sheet": "<sheet>",
"target_cell": "<target_cell>",
"frequency_object_cell": "<frequency_object_cell>",
"severity_object_cell": "<severity_object_cell>"
},
"name": "create_aggregate_mc"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | Yes | ||
| dry_run | No | ||
| workbook | Yes | ||
| max_limit | No | ||
| min_limit | No | ||
| target_cell | Yes | ||
| distribution_shift | No | ||
| severity_object_cell | Yes | ||
| frequency_object_cell | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | Yes | ||
| formula | Yes | ||
| written | Yes | ||
| previous_formula | No |