Lattice Normalize

Years of spreadsheets, exports and scanned documents rarely agree. Moving them into a new system should not mean losing track of what changed.

The approach

Normalize maps source files into one schema, holds uncertain values for a person and checks the accounting at every step. The same files and mapping produce the same output hash.

What it makes possible

In the eight-row sample, three rows are clean, three need review and two are set aside. All eight remain accounted for. If the counts do not reconcile, the run fails.