How ReconNimble tests spreadsheet guidance before publication

Formula fixtures

Supported formula families are tested for Excel and Google Sheets where behaviour differs. Fixtures cover exact match, missing values, locked ranges, dynamic headers and normalized permalink signatures.

Reconciliation fixtures

CSV, TSV and XLSX fixtures cover reordered rows, different header names, missing records, duplicate keys, numeric/date normalization, field conflicts, multi-source presence and bounded fuzzy candidates.

Author and reviewer accountability

Every guide record identifies an author and reviewer, contains visible source and testing notes and stores reviewed and published dates separately. An editor can return a draft to Review when the live product or documentation changes.

Images and downloads

Each launch draft includes a unique lightweight illustration with dimensions and alt text. Downloadable workbooks contain fictional sample data and instructions; the VLOOKUP PDF is rendered and visually inspected before packaging.

Corrections and limitations

Material corrections update the reviewed date. We do not publish fake customer claims, fake expert identities, invented time-saved totals or a formula as proof of business correctness. Formula, Excel-version, locale and plan limitations are visible where they affect decisions.

Launch publication state

The package contains thirteen substantial guide drafts in Review status. They remain outside the sitemap and public guide index until the site owner checks the live examples and deliberately publishes them.