replace_constant_with_distribution
Replace a hard-coded number in an Excel cell with a probabilistic distribution for risk modeling, overwriting the cell value after candidate identification.
Instructions
ModelRisk: Replace a hard-coded number in a cell with a Vose distribution wrapped by VoseInput. Use after find_hard_coded_inputs identifies candidates. This is the only tool that overwrites a non-Vose cell — it does so by design.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | Yes | ||
| sheet | Yes | ||
| dry_run | No | ||
| workbook | Yes | ||
| input_name | Yes | ||
| parameters | Yes | ||
| function_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | Yes | ||
| formula | Yes | ||
| written | Yes | ||
| previous_formula | No |