create_sensitivity_table
Build one- or two-variable sensitivity tables in Excel by evaluating an expression over supplied value grids.
Instructions
Create a 1- or 2-variable sensitivity table in the workbook.
Evaluates expression over supplied value grids.
Args: file_path: Workbook path. sheet_name: Worksheet containing the base formula or output cell. output_cell: Cell that contains or references the expression to evaluate. expression: Expression that will be evaluated relative to variable names. var1_name, var1_values: Name and values for variable 1. var2_name, var2_values: Optional name/values for a second variable (two-way table).
Returns: dict: Summary including output range and written values.
Notes: - Mutates workbook by inserting the table; confirm overwrite semantics when the target output area overlaps data.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| var1_name | Yes | ||
| var2_name | No | ||
| expression | Yes | ||
| sheet_name | Yes | ||
| output_cell | Yes | ||
| var1_values | Yes | ||
| var2_values | No |