Write the formula engine behind Sheetwise's cells: a tokenizer and a recursive-descent parser with correct precedence, precise error positions, cell references and functions.
Arithmetic
Numbers, + − × ÷ ^, parentheses and signs, with the right precedence and an error position for every mistake.
Cells and functions
Cell references from a map, and SUM, MIN, MAX and ABS with argument checks.
Ranges like A1:A10
Let functions take ranges of cells, the way every spreadsheet user expects.
How to parse formulas, JSON and patterns by hand: split input into tokens, write the grammar down, turn each rule into a function, handle precedence, and report exact error positions.