Skip to content
KN-86 Deckline

AmberCalc — columnar spreadsheet

First-party on-device program #7 (ADR-0042). Status: Stub — design pending.

Charter stub. AmberCalc is canonical per ADR-0042; this doc is a placeholder until the full design lands. See the program roster.

Identity

Section titled “Identity”

A columnar spreadsheet tool. Forensic and audit missions (the BLACK LEDGER domain) drop transaction data into AmberCalc views: rows, calculated columns, filter/sort, and export onward to DOSSIER.

Scope (intended)

Section titled “Scope (intended)”
  • Tabular data: rows + columns, navigation, selection.
  • Calculated columns and filter/sort over a loaded data set.
  • Ingest a mission-provided transaction set; export findings to DOSSIER (dossier.md).

Interfaces

Section titled “Interfaces”
  • Launched via (launch-app :ambercalc …) (NoshAPI Tier 1, ADR-0005) — e.g. BLACK LEDGER’s audit phase hands its transaction set as :payload. Draws on the cartridge/content rows per the canonical grid. Authored in KEC Lisp; source under runtime/programs/ambercalc/.

Open questions

Section titled “Open questions”
  • Formula language: KEC Lisp expressions over cell references, or a constrained mini-DSL?
  • The :payload schema for an ingested data set (column types, headers, units).
  • The export-to-DOSSIER contract — what shape does a “finding” take?
  • Fixed-grid scale: how many columns/rows are usable at 1× vs. a scaled view (per the canonical grid; defer exact figures to design).

References

Section titled “References”