Legacy Results Verification

Upload a legacy season workbook or separate CSV files, run them through the current BAC scoring engine, and compare the new-system outputs against the legacy weekly, monthly, and yearly standings without touching production data.

Verification Input

Preferred format: one Excel workbook with sheets named runners, weekly_results, legacy_weekly, legacy_monthly, and legacy_yearly.
CSV fallback also works by uploading those files separately below. Only uploaded files are read; nothing is written back to Google Sheets.

Or upload separate CSV files

What This Checks

  • Weekly points and placings
  • Monthly standings totals and ranks
  • Yearly standings totals, ranks, and cross-distance bonus
  • Age-group grouping mismatches
  • Volunteer-point differences if the upload includes volunteer rows

Expected weekly results columns

week, date, bib/name, distance, handicap, finishTime, wrongHandicap, timeTrial, dnf, volunteer, volunteerPoints

Expected legacy standings columns

weekly: week, runner/name, distance, gender, ageGroup, points, placing

monthly: month, runner/name, distance, gender, ageGroup, points, rank

yearly: runner/name, distance, gender, ageGroup, yearlyTotal/points, crossBonus, volunteerPoints, rank