Sequence Calculator
Toggle Help & Examples
Variables & Aliases:
row, col: Current position.
a, b, c...: References the value of that column in the current row.
above, prior, previous, last: All reference the value directly above the current cell (cell(0, -1)).
seed: reference the seed value (same as cell(0, -1) for the first row and cell(0, -2) for the second row).
Functions:
cell(x, y): Relative lookup. x = horizontal offset, y = vertical offset. (Must be ≤ 0).
- Math: Use
PI, SQRT2, sin(), abs(), pow(base, exp), etc., without the 'Math.' prefix.
Further Examples:
- Arithmetic sequence:
above + 10 (Seed is start value).
- Fibonacci-style:
last + cell(0, -2).
- Running total of Col A:
a + last.