A workbook can contain new test data while showing old calculated results. Manual calculation settings, stale external inputs, or incomplete export steps can leave a polished quality report out of date. Verify the calculation state before distributing the workbook or its PDF summary.
Microsoft’s Excel recalculation guidance describes automatic and manual calculation behavior. The practical implication is to check the actual calculation settings and complete the required recalculation rather than assuming that opening or saving a file refreshed every result.
Identify all result dependencies
List imported measurements, lookup tables, limits, pivoted summaries, formulas, and external workbook links. Distinguish refreshing an external dataset from recalculating formulas that use the dataset. Both may be required, and they are not the same operation.
Record the intended data cutoff and recipe or limit revision. Check that the workbook uses those inputs before recalculation. Recomputing against an obsolete lookup table produces a fresh calculation of the wrong question.
Use visible reconciliation controls
| Control | Purpose |
|---|---|
| Imported row count | Confirms the expected dataset arrived |
| Distinct board and attempt counts | Checks population identity |
| Known example calculations | Verifies important formula behavior |
| Summary-to-detail totals | Detects stale or incomplete summaries |
Inspect formulas at the boundaries of newly added data. A summary that references a fixed range may omit the latest rows even after successful recalculation. Check whether table expansion, named ranges, and chart ranges include the intended records. Inspect hidden filters that may exclude a new lot or station.
Run a controlled report release
- Refresh the approved inputs.
- Confirm calculation settings and recalculate as required.
- Review errors and reconciliation controls.
- Save the calculated workbook.
- Export and inspect the actual distributed artifact.
Compare important totals in the PDF or value-only export with the workbook. A separate export script may read stored values rather than calculate formulas, so its output must be checked through the actual delivery path. Do not assume that a formula-aware desktop application and a file-reading library behave identically.
Keep calculation errors visible until resolved. Replacing every error with an empty string can make a dashboard look clean while concealing missing inputs or broken references. If a blank is an intentional presentation choice, retain an independent error count for review.
Preserve the workbook version, source dataset identity, and released output together. The useful evidence is not simply that someone pressed a recalculate command, but that the resulting report reconciles with the intended inputs and that its delivered form carries those same results.
Move from reading to a build-ready project
Use the fabrication and assembly checklists to prepare drawings, production files and test requirements.
Open the DFM checklist