Keyword index
Every syntax keyword by type — finite, contextual, free — plus what deliberately is not part of the syntax.
This page is the alphabetic index of the sheet language: every keyword that has syntactic meaning, with the section it belongs to and its type — finite (a closed set), contextual (meaning depends on the surrounding operands), or function.
It closes with the explicit “not syntax” list: behavior people sometimes assume but that the language deliberately does not have.
How to read the index
| Type | Meaning |
|---|---|
| finite | a closed, enumerable set of words |
| contextual | the word’s meaning depends on its neighbours (for example and versus &) |
| function | a function name (the full list is in Built-in functions) |
Keywords
| Word | Section / meaning | Type |
|---|---|---|
a | percentages (as a % of) | contextual |
and | logic / bits | contextual |
as | percent / conversion / base / DMS | contextual |
base | bases (base 2) | contextual |
binary | bases | finite |
business day(s)/workday(s) | work calendar | finite |
celsius/fahrenheit/kelvin/rankine | temperatures | finite (units) |
count/median/stdev/rand | statistics functions | function |
day(s) week(s) month(s) year(s) | dates / time | finite |
decimal/base10 | bases | finite |
degrees | function | function |
distance | geography | contextual |
dollar and currency names | currencies | finite (alias) |
Easter/Christmas | special dates | finite |
else | conditional | contextual |
fps/frames | video timecode (also the fps speed alias = ft/s) | contextual |
fraction | percentages | contextual |
grand total | tags & subtotals grand total | finite |
hex/hexadecimal/base16 | bases | finite |
if | conditional / percent | contextual |
in | conversion / rate / weather (weather in) | contextual |
int/bin/oct/hex | base functions | function |
is | percentages | contextual |
iso8601 | timestamps / ISO output | contextual |
laptime | clocks / elapsed time | contextual |
location | geography | contextual |
longitude | geography | contextual |
of | percent / density | contextual |
off/on | percentages | contextual |
or | logic / bits | contextual |
at | PPI / price (… at 96 ppi, … at €3 per kg) | contextual |
multiple/multiplier | percentage phrase keywords | contextual |
octal | bases | finite |
per | rates / price | contextual |
percent/percentage | percentages | contextual |
radians | function | function |
sales tax/VAT/GST | configured sales tax | contextual |
subtotal | tags & subtotals subtotal | finite |
then | conditional | contextual |
timespan | duration notation / explicit as timespan | contextual |
timestamp | Unix timestamps | contextual |
to | conversion / percent / base | contextual |
total | the sum command | finite |
tomorrow/today/yesterday | dates | finite |
weather | weather | finite |
what | percentages | contextual |
workday(s) | work calendar | finite |
x | multiplier (postfix 1.5x), % / multiplier phrases | contextual |
xor | bits | contextual |
Free input
These are validated user input rather than keywords, so they are not enumerated:
<place>— weather/geography place names, up to 100 characters;- names of sheet values, constants and custom units — 1–6 ASCII words, at most 40 characters;
<Answer Token>— the generated marker.
What is NOT syntax
- Interface localization changes neither the syntax nor the numeric separators — only the regional format does, and separately.
- No GPS: coordinates are either explicit or resolved by name through geocoding.
- Surface, not route:
distance betweenis a Haversine distance on the sphere, not a road or air route. - Cooking densities are approximate, not laboratory values.
- Display ≠ evaluation: format, pattern, signs and symbols change the view only, never the value.
- No AI inference, cloud or sync: all calculations are local; the network is used only for rates, weather and geocoding — separately and explicitly.
- Offline catalogs: the timezone, holiday, sales-tax, income-tax and CPI datasets are bundled with the app; PDF export and printing are entirely offline.
- No platform-specific forms: the app is macOS (Apple Silicon, arm64), and the syntax does not depend on the OS.
Related
- Built-in functions — the 27 function names.
- Tags, subtotals & statistics — the tags and subtotals keywords in full.
- Dates & times — the temporal keywords in full.
- Finance & investments — the finance phrases in full.
- Sheet language — where each keyword type appears.
- Privacy & network — the network allowlist behind “no cloud”.