Spreadsheets

Models live in real spreadsheets: Excel-compatible workbooks whose tables are connected to datasets in the project. When the data changes, update the connections and the formulas hold.

What a model is made of

• A connection: a sheet range that is a copy of a dataset (often a transformation's output — the model's feed).
• Calculated columns on the connection: the variables and the result, as plain Excel formulas (=[@seats]*[@price_per_seat]). Where one segment's economics differ, a variant gives those rows their own formula.
• Checks, on a sheet of their own: what must be true — a total that matches the finest grain, a share that sums to one.
• Hypotheses for the forecast: named claims with a growth per period, accumulating in the scenarios they are active in. History never differs by scenario.

The spreadsheet page

Under Artifacts, filter to Spreadsheets; start a blank one with New → Spreadsheet.

The workbook opens with its formulas, and you can edit it right here: values, formulas, formatting, rows and columns, all saved as you go. Select a cell to see its formula — and, inside a connected table, the dataset it was copied from or the calculated column it belongs to. Cells copied from a dataset belong to it; Unlink makes them the sheet's own.

• When a connected dataset changes, the header and a bar above the grid say so. Update all copies the latest data in and recalculates, as a new version.
• History lists the versions; any one can be viewed, named, or made current again.
• Select a range and choose Insert → Chart over the selection… to start a chart that reads it.
• Details shows what the model reads, any formula errors, and its notes.
• ⋯ → Export → Excel (.xlsx) takes it to Excel, the formulas as written.

Connecting a dataset to a sheet is done by your agent, which knows the modeling practice the platform teaches.

Faster with an agent — "build a bottom-up model of <market> in a spreadsheet: drivers from the datasets, one formula per segment where the economics differ, and a check on the total." Your agent builds the feed, connects it, writes the columns and the checks, and charts it.