[Feature] Support for sensitivity grid

[RichardSong99]

Initial checklist

• Is this really a problem?
• I have searched the Github Issues for similar issues, but did not find anything.

Problem

Sensitivity Grids (Data Tables)

What this feature does

A sensitivity grid (also known as a data table) shows how a formula’s result changes when one or two input values are varied. It’s a core what-if analysis tool in financial and business modeling.

How it works

1. Anchor formula

   • The top-left corner of the grid references a formula (e.g., =EBITDA).
   • This is the calculation that will be re-evaluated.

2. Input cells

   • The user designates one or two model input cells (e.g., Revenue and EBITDA margin).
   • These are the variables that will be substituted with the header values in the grid.

3. Headers define scenarios

   • One-way table: trial values for a single input are listed in a column (or row).
   • Two-way table: trial values for one input go across the top row, and trial values for the other go down the first column.

4. Calculation

   • For each combination of header values, the grid substitutes them into the input cells, recalculates the anchor formula, and writes the result into the body of the grid.

Example

Inputs

• Revenue = $100
• EBITDA margin = 50%
• EBITDA formula = Revenue × Margin = $50

One-way grid

• Vary margin from 40% to 65%.
• Results show EBITDA from $40 to $65.

Two-way grid

• Vary margin (40%–65%) vs. Revenue ($80–$120).
• Results show EBITDA under all scenarios.

This lets users see at a glance how outputs change under different assumptions.

Key behaviors

• Supports both one-variable and two-variable tables.
• Automatic or manual recalculation (toggle for performance).
• Formatting preserved when recalculating.
• Import/export compatible with Excel data tables.

Sensitivity.Grid.Example.mp4

Sensitivity grid example.xlsx