TableSheets

TableSheets is Archivo’s spreadsheet app, with formulas, formatting, charts and multi-sheet workbooks. It reads and writes standard spreadsheet files.

Formulas & math

Enter formulas from the formula bar, an in-cell editor, or Archivo’s dedicated math-formula entry point under Insert ▸ Math formula… for typeset expressions.

Charts & data

Charts are embedded objects that live on the sheet alongside your data. Large workbooks are cached locally so they open quickly and save incrementally as you edit.

3D model formulas

Workbooks can pin 3D models — geometry built from cell ranges, or stored CAD files and .a3d scenes — and compute from them with live formulas. Each takes a pin (its title; blank works when the workbook has exactly one) and an optional node query (a part name, a glob like "Bolt*", or an IFC class):

• =MODEL3D.VOLUME(pin, node) — volume in model units³ (approximate on open meshes)
• =MODEL3D.AREA(pin, node) — surface area in model units²
• =MODEL3D.COUNT(pin, node) — how many parts match the query
• =MODEL3D.DIM(pin, node, axis) — a bounding dimension ("x"/"y"/"z"; blank = longest)
• =MODEL3D.BBOX(pin, node) — width × height × depth as a 1×3 spill
• =MODEL3D.MASS(pin, node, density) — volume × density (you manage the units)
• =MODEL3D.NODES(pin, node) — matching part names as a spill column

Results recalculate automatically when the model’s driving cells change. Underscore spellings (=MODEL3D_VOLUME, …) work everywhere the dotted names do. Exports to .xlsx keep the last-calculated values — Excel itself can’t compute these functions. The reverse direction — cells driving an imported model’s parts — is covered under 3D, CAD & BIM.

Templates

Built-in templates give you a structured starting point — budgets, trackers and similar — that you fill in rather than build from scratch.

Printing

TableSheets prints and exports through a vector generator, so the on-screen preview matches the exported PDF. See Rendering & print.