Mon & Thu CSV top-up · upserts only, never wipes · source of truth for Post Race Analysis
Older RAPRO exports stored horse names in ALL-CAPS (e.g. WHISKY MOON).
Newer exports use Title Case (Whisky Moon). This creates duplicate rows in the database,
splitting starts and wins across two versions of the same horse.
Run this once after uploading any CSV to merge ALL-CAPS rows into their Title Case counterparts. Safe to run multiple times — completely idempotent.
Recomputes lifetime Speed Rating averages for every horse and re-classifies them into ELITE / QUALITY / ABOVE_AVG / AVERAGE / POOR. This runs automatically after each CSV upload — use this only if you need to refresh manually.