Hi everyone. My name is Mario San Roman and I am a former programmer for Lebotics 5948. As the 2025 season is approaching, I want to share a tool I built for my team earlier this season.
There are many scouting apps by many different teams, and each has their pros and cons; however, I did not want to depend on live service apps as they can lose support at any time in the future. I wanted to create one that is completely reusable, reliable, with ease of access and use for every member of the team regardless of hardware, easily maintainable, and that gives complete freedom and control to each team.
I came up with a new tool with a very cool and completely original and innovative name: FRC Scouting Generator. It is an open-source tool to create a spreadsheet in Google Sheets, which you can then share to the entire team. Not very glamorous. However, it provides everything I described earlier. A spreadsheet is very customizable and gives complete flexibility to each team, allowing them to change anything they don’t like, add anything they need, and providing the reliability and easy access that comes from using the Google service.
After a bit of one-time setup (mainly from setting up access to use the Google Sheets API), you can specify any amount of observations that your team is going to be looking for (which are probably going to change each season) and what event the spreadsheet is for. You can then create the spreadsheet, which comes with the following prepopulated data:
- The teams that are in that event
- The event schedule
- The columns for the observations you set
- Other interactive sheets that the team can use to stay organized and compare data.
- Advanced stats (EPA, OPR, DPR, CCWM) powered by Statbotics and The Blue Alliance. You can continue refreshing the data from these sources as the competition goes on.
Here is an example of the Google Sheets output that is generated when using the default English template. There is also support for Spanish.
For more information you can check out the README on the Github repo that I linked above. Feel free to leave any feedback or any questions you may have.