Sweep tables

Insert → Sweep places a parametric table: you name an input to vary, give it a range, and list outputs to evaluate at each step. The toolbar label reads Parametric table. The gear is Configure.

This is the tabular cousin of a plot series in Sweep mode. Use the table when you want columns of numbers (and maybe a chart later). Use the plot when you only need the curve.

Place a sweep

1. On the Insert tab, choose Sweep, then click the page.
2. Configure opens. The canvas (the finished table) is hidden until you close the panel.

Configure — Sweep

The first section is titled Sweep. The hint: vary the input variable from From to To by Step; the sheet is re-evaluated at each value.

• Input variable — pick a name already on the sheet (the same dropdown style as a plot sweep).
• Input column heading — optional title. Placeholder: Optional title — variable name always shown.
• From, To, Step — the range. Step must be greater than zero.

Configure — Outputs

The second section is titled Outputs. The hint: pick worksheet variables to show side-by-side. Optional column titles appear before the variable name in parentheses, then the unit in square brackets — for example Span (L) [m].

• Each row: Variable dropdown and Column heading (same optional-title placeholder).
• + Add column — appends an output.
• ✕ (tooltip: Remove column) — drops that output.

Click the gear to close Configure. The table fills; a brief Loading… appears while rows evaluate.

How evaluation works

Build the rest of the sheet above the sweep the same way you would for a single run. The sweep temporarily assigns each input value, re-runs everything downstream of that assignment, and writes the outputs into that row. Put the sweep below the formulas it needs, and above anything that should read the table (you cannot reference a sweep cell as a math name — plot the same variables, or copy a result by hand).

Frame results, Given/solve names, and list variables all work as outputs if they sit above the sweep and depend on the input.

Column titles

Leave the heading blank to show just the variable and unit. Set a heading to get Heading (name) [unit]. The unit comes from the variable’s current unit on the sheet.

Plot the same sweep

To draw a curve of one output against the input, insert a Line chart in Sweep mode with the same input, range, and output — or build arrays in math and use List mode. The table and the chart evaluate independently; they do not share a cache.