Student Progress Tracker
2023Reads a roster of coaching students from Google Sheets, looks up each player's current rank, and reports who has actually improved since they started.
- Python
- Google Sheets API
- xlsxwriter
The report, running
Ported from PythonEvery verdict is computed by the ported comparison, not written into the data.
Building the report…
The coaching org tracked students in a spreadsheet: name, starting rank, tracker link. Working out who had progressed meant opening every link by hand, which is exactly the sort of chore that stops getting done.
The script reads the sheet, parses Riot IDs out of the tracker URLs with a regex, queries current rank across the NA, EU and AP regions, and compares it against where each student started — spanning the act and episode boundaries that reset ranks.
It writes two files rather than one: students with usable data, and students whose data is missing or stale. Separating them was the difference between a report someone reads and a report someone has to audit.
What it does
- Google Sheets as the input surface, so coaches kept their existing workflow
- Rank comparison across act and episode boundaries
- Splits confident results from stale data instead of silently mixing them