Skip to main content
In an XLSX file, each cell can store a fixed value (a number or text) or a formula (=SUM(B2:B9)) together with its last calculated result. A sheet with formulas recalculates when an input changes; a sheet that only stores values is a snapshot of the calculation that never updates.

​
Why it matters when generating documents with AI

  • A model that computes totals and writes them as numbers can get them wrong, and nobody can see where the figure comes from.
  • With formulas, whoever receives the sheet can change an assumption (a price, a rate) and see the effect across the workbook.
  • Assumptions in their own cells, rather than typed inside formulas, make the model auditable.
  • A hard-coded number among identical formulas, or a broken reference (#REF!), breaks the calculation without being obvious at a glance.

​
With Doconda

The Excel files Doconda creates have real formulas (not pasted numbers), with assumptions in their own cells and no calculation errors (Create); when editing, changes are made with formulas too. The review flags formula errors, broken references, links to other files and hard-coded numbers among identical formulas, with the sheet and cells.