create_copula
Create a copula formula in Excel to generate a correlated u-array for Monte Carlo risk modeling, enabling dependent distributions from specified parameters.
Instructions
ModelRisk: Build a copula formula (e.g. VoseCopulaMultiNormal) that produces a correlated u-array for downstream distribution calls. Copula tools are exempt from the bulk-write guard.
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>",
"u_array_target_range": "<u_array_target_range>",
"function_name": "<function_name>",
"parameters": "<parameters>"
},
"name": "create_copula"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | Yes | ||
| dry_run | No | ||
| workbook | Yes | ||
| parameters | Yes | ||
| function_name | Yes | ||
| u_array_target_range | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | Yes | ||
| formula | Yes | ||
| written | Yes | ||
| previous_formula | No |