What is tprl-standings-scripts?

This project provides Google Sheets scripts that automatically calculate and update race standings for an online racing community called TagPro Racing (organized through a Reddit community). Instead of someone manually adding up scores and tracking rankings week after week, these scripts handle the math and formatting so organizers can focus on running the competitions. The scripts live inside Google Sheets using Apps Script, which is basically JavaScript that runs within Google's spreadsheet tool. The code is split into two parts: weekly scripts that process individual race results, and season scripts that aggregate those weekly results into overall standings. You set it up by creating a Google Sheet, opening the built-in script editor, and copying the code files into it. The season sheet needs a specific layout, an "Events" tab listing each race with its date and a link to that week's results sheet. The people who would use this are organizers running a TagPro Racing league or season. For example, after a weekly race finishes, an organizer would use the weekly script to generate a results sheet. Then the season script pulls data from all those individual event sheets to calculate cumulative standings, showing who's climbing the ranks, who's on a winning or losing streak, and how far each racer sits from their personal best ranking. One notable aspect is how the project handles visual formatting. Rather than hard-coding colors and symbols, it uses a dedicated "Formatting" tab in the spreadsheet. Organizers set up formatting rules on specific cells, like green triangles for rank improvements or red for drops, and the script copies that styling onto the main standings sheet. This means organizers can adjust the visual presentation without touching the code, which is a practical tradeoff for a community project maintained by volunteers.