create_copula
Construct a copula formula to generate a correlated u-array for use in Monte Carlo distribution models within Excel.
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.
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 |