Skip to content

Spreadsheet totals that are calculated, not guessed

Short answer

Totals, averages and maximums are computed over every row by the tool. The model is told the result rather than asked to work it out.

The problem it exists for

Language models are famously unreliable at arithmetic. Ask one for a column total and it will produce a number that looks right, which is worse than refusing.

How it works

  • The spreadsheet is parsed and the requested aggregate is calculated across all rows.
  • The computed figure goes to the model, which reports it rather than deriving it.
  • This holds for the whole file, not for a sample that fitted in a prompt.

What it does not do

  • Column identification can go wrong on merged or stacked headers — name the column exactly.
  • Comparisons between individual rows are generated, not computed, and are the usual source of errors.
  • Formulas are read as their computed values, not as formulas.

Other ways people ask this

  • browser spreadsheet calculations

Related