In use
Roster reconciliation
Python
- The problem. Every week we receive external .xlsx spreadsheets of provider assignments. Checking them against internal .gsheet rosters by hand has been the slow and tedious standard practice for years.
- What it does. Compares external .xlsx with internal .gsheet (4,900 rows, 460 matched students), surfacing every important flag and helpful information including new assignments, provider transfers, and more in one click.