Skip to content
Solve

TABLES_PACKAGE

const TABLES_PACKAGE: IEnginePackage;

Defined in: packages/engine/src/packages/tables/TablesPackage.ts:48

Read a markdown table’s column as data: sum of column "cost" in table above, average of column "cost" above.

A markdown table is the one block the evaluator classifies and then skips, so a note can hold a table of numbers and none of them can be totalled from where they sit. This package addresses the nearest table above the query line, names one of its columns, and reduces that column’s numeric cells, reusing the same cross-line plumbing the lines package built for total above (a per-line LineExecutionContext, extended with getLineText so the skipped table rows can be read back from source).

Trigger-word collision policy (this codebase’s phrase-fusion rule, see MathPhrasesPackage.ts): the whole verb-and-noun is phrase-fused, never the bare verb. average of is already fused to AVERAGE_OF by the math-phrases package; registering the longer average of column in the same phrase trie wins by longest-match, so plain average of 1, 2, 3 is untouched while average of column "x" routes here. sum of is claimed by no one, so sum of column fuses cleanly. Synonyms (total->sum, mean->average) share a token type and parselet, matching how the lines package treats sum/total as one.

Decisions worth stating (also in the docs and changeset):

  • Addressing: nearest table above only. An explicit table label is deferred.
  • Non-numeric cells: skipped, not an error, so a stray label or a blank cell does not break an otherwise-numeric column. A column with no numbers at all is a clear error (except count, which is then zero).
  • Currency and units in cells: not read yet. A cell carrying a $ or a unit is treated as non-numeric and skipped. Plain numbers first, on purpose.