Analyze test data and determine results

I need to deliver the tested batch results to Simon in quality and to Claire in product engineering for sign-off by Wednesday. Confirm each sample row shows test ID, pass/fail status, measured value with units, the test method reference, and that the acceptance criteria sheet links correctly to the reported results.

Before I circulate the test-results workbook, make it easy for reviewers to pick the important failures: surface the overall pass rate and the three worst-performing parameters at the top, group failures by root-cause suspected, and highlight any results that fall just inside tolerance which an engineer might still reject.

I recalculated the test worksheet and one critical tensile test changed from pass to fail. The engineering lead asked for an explanation and the production run waits on approval. I don't know whether the recalculation used updated calibration factors or an overwritten acceptance threshold. What is the most likely reason, what quick checks should I run now, and what should I tell Claire while I investigate?

Test reports keep flipping status because acceptance thresholds are adjusted late by engineering, forcing rework and delaying approvals. Where are we losing accuracy and trust, and what two changes to how thresholds are set, versioned, and communicated would prevent future surprises?