/
Supportvalsight.ai
Open in ClaudeOpen in ChatGPT

Input Tables

An input table brings simulating and viewing together: values are typed straight into a table on the worksheet and the effect shows up immediately, with no switching between screens.

What it is

An input table looks like an ordinary table, but it has an Input Data mode. In that mode the cells accept typed values, and saving them applies the change across your scenario.

An input table showing editable values per region, engine type and year

Each input table edits one line-item, in one of two views:

ViewWhat you type
Change ViewRelative changes, for example a percentage uplift.
Result ViewAbsolute values, which replace what is there.

When to use it

  • You want a reader to try their own numbers without opening the Scenario Manager.
  • You want to enter many values at once, which is faster in a grid than with sliders.
  • You want to set a total that other tiles then divide up, for example one feeding a split slider.

Use a slider instead for a single value that is better dragged than typed, and a plain table when readers should only read the numbers.

Configuration

  1. Click + Chart in the workspace.

  2. Go to the Simulations category and select Input Table.

    The Simulations category with Input Table in the chart type selection

  3. Choose the Line Item to edit, and the variant to modify.

    The input table configuration, with the line-item and variant selected

  4. Edit the Table title if you want something other than the proposed one.

  5. Choose Change View or Result View.

    An input table in Result View, showing absolute values

  6. Optionally apply filters to narrow the table to the rows that matter. A filter icon appears when you hover over a filtered table.

Entering values

  1. Hover over the input table tile and click Input Data in the top right corner.

  2. Type values into the cells to test an assumption.

    Typing a value into an input table cell

  3. Click Save to apply the change across the scenario. Every linked table updates automatically.

Good to know

  • What you type depends on the view. In Change View a 10 is a relative change; in Result View the same 10 is an absolute value. Check which view a table uses before entering numbers.
  • Nothing is applied until you save. Values typed in Input Data mode take effect on the scenario only when you click Save.
  • A table can be maximized while you work. Expanding it for easier entry does not lose what you have typed.
  • Perspective and sheet filters apply. They adjust the data shown in the table automatically, so the rows you see may depend on the sheet’s current perspective.

An input table maximized on the worksheet

  • Sliders: drag a single line-item’s value instead of typing it.
  • Split Sliders: redistribute a total across its parts while the total stays fixed.
  • Chart Types: the other tiles you can place on a worksheet.
Was this page helpful?