SPREADSHEET VERIFICATION CHECKLIST
Question to answer:
Source file and version:
What one row represents:
Definition of each measure:
Observation period and exclusions:

[ ] Counts match the original data.
[ ] Every eligible row is included exactly once.
[ ] Numerator and denominator refer to the same population and period.
[ ] Formula ranges include all intended rows and exclude headers/totals.
[ ] Blank, zero, duplicate and missing values have explicit treatment.
[ ] Formulas were checked independently from the generated explanation.
[ ] Percentages and percentage-point differences are labelled correctly.
[ ] Conclusions distinguish observations from possible explanations.
[ ] Limitations appear beside the conclusion.

FICTIONAL SAMPLE CHECK
Rows: four weekly cohorts, each observed for a full seven days.
Enquiries: 40 + 60 + 50 + 50 = 200.
Bookings within seven days: 8 + 18 + 10 + 14 = 50.
Pooled booking rate: 50 / 200 = 25%.
Spreadsheet formula with the supplied CSV in A1:C5: =SUM(C2:C5)/SUM(B2:B5)
Wrong example, do not use: =SUM(C2:C5)/SUM(B2:B4), which omits Week 4 enquiries.