assay

DV-0057

excel, formulas, gsheets, lattice: numeric precision differs — EFFECT, NOMINAL

Cause
precision
Category
value
Diverging engines
excelformulasgsheetslattice
Behavior signature
0.050000000000000044
Test count
2
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (2)

EFFECT NOMINAL

Tests (2)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
EFFECT/effect-annual-compounding =EFFECT(0.05, 1) 0.05 gsheets0.0500000 excel0.0500000 lattice0.0500000 ironcalc0.05 hyperformula0.05 libreoffice— formulas0.0500000 pycel#NAME?
NOMINAL/nominal-annual =NOMINAL(0.05, 1) 0.05 gsheets0.0500000 excel0.0500000 lattice0.0500000 ironcalc0.05 hyperformula0.05 libreoffice— formulas0.0500000 pycel#NAME?