replace_constant_with_distribution
Replace a hard-coded numeric value in a cell with a Vose probability distribution for Monte Carlo simulation. Use after finding hard-coded candidates to convert static inputs into parametric variables.
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.
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>",
"cell": "<cell>",
"function_name": "<function_name>",
"parameters": "<parameters>",
"input_name": "<input_name>"
},
"name": "replace_constant_with_distribution"
}
}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 |