Ampler builds a one- or two-variable sensitivity table for a model output, so you can test how inputs move a result — a sensitivity analysis without wiring up a data table by hand.
Quick answer: Click Sensitivity Table on the Ampler ribbon, choose one or two variables, point it at the model output and input cells, set the range and number of steps, and generate the table.
How to use it
Set the output, the input variables, and the range to build the table.
- Click Sensitivity Table and select either one or two variables.
- Add the model output cell references and the model variables (inputs).
- Set the sensitivity range and the number of steps, then generate the table.
One variable tests an input against several outputs; two variables test two inputs against one output.
Keyboard shortcut
Sensitivity Table has no default shortcut. To assign one, open the Settings dropdown on the Ampler ribbon, choose Shortcuts, click Modify on the function, and press your key combination.
Why use it
Building a sensitivity (data) table in native Excel means setting up the grid, the input cell, and the formulas correctly — fiddly and easy to get wrong. Ampler builds the table from the output and input cells you point it at, so you get a sensitivity analysis in a few clicks.
How consultants use it
Sensitivity analysis is a staple of consulting and finance work — showing how a result moves with its key assumptions is central to a recommendation. Three conventions apply:
- Test the key drivers: the output is flexed against the inputs that matter most.
- One or two variables: one input against several outputs, or two inputs against one output.
- Show the range of outcomes: the table makes the result’s sensitivity explicit for the reader.
A sensitivity table turns ‘what if’ into a clear grid in a few clicks.
Tips & best practices
- Point it at the output and the one or two inputs that drive it.
- Set a sensible range and step count for a readable grid.
- Use a two-variable table for the classic input-versus-input matrix.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you do a sensitivity analysis in Excel?
Click Sensitivity Table on the Ampler ribbon, choose one or two variables, point it at the model output and inputs, set the range and steps, and Ampler builds the table.
What is a one- or two-variable sensitivity table?
One variable tests a single input against several outputs; two variables test two inputs against one output — the classic data-table matrix.
How is this different from an Excel data table?
Ampler builds the sensitivity table from the output and input cells you point it at, rather than wiring up a native data table by hand.