lowie375/vsd

An archive of 2018-2020 FRC scouting spreadsheets

VSD

About

The VSD is a series of spreadsheets created by L375 (Nanjou), which were used to track and analyze FRC match data at various events from 2018 through 2020.

The content in this repository is considered archived and will not be updated except to fix critical issues.

All content in this repository is licensed under the terms of the MIT license.

VSD18 (POWER UP)

The VictoriaScoutingDatabase or VSD (now known as VSD18) is the first spreadsheet in the VSD series. It was created to analyze data from matches in the 2018 FRC season's game POWER UP. It is run solely using formulas, making it the least advanced of the VSDs.
In the original version of VSD18, the Data Processor sheet was extremely laggy. I made a quick patch for the version present in this repository using two simple macros, thus why VSD18 is macro-enabled, even though it was not initially built as such.
This spreadsheet will require some manual setup.

VSD19 (DESTINATION: DEEP SPACE)

VSD2019 (now known as VSD19) is the second spreadsheet in the VSD series, created to analyze data from matches in the 2019 FRC season's game DESTINATION: DEEP SPACE. VSD19 heavily improves upon its predecessor, introducing many new data tracking categories and making use of a new macro-based processor to eliminate the extreme lag present in the original VSD18.
This spreadsheet will require some manual setup, though not as much as VSD18 does.

VSD20 (INFINITE RECHARGE)

VSD20 is the third spreadsheet in the VSD series, created to analyze data from matches in the 2020/2021 FRC season's game INFINITE RECHARGE. VSD20 makes use of The Blue Alliance's API to pull team information and some match data from FIRST's database, while also streamlining the spreadsheet's configuration through the use of more macros and allowing for inputs in even more data tracking categories.
This spreadsheet requires minimal manual setup due to its integration with TBA and macros, though a TBA read API key will be required to make use of the full suite of automated setup features (and TBA-powered features).

Dependencies (included in VSD20 download): VBA-JSON and VBA-Dictionary

Setup

VSD18

• Download + unzip the VSD18 spreadsheet
• Enable macros when prompted
• Follow the steps listed here

VSD19

• Download + unzip the VSD19 spreadsheet
• Enable macros when prompted
• Follow the steps under the Configuring the VSD section of the README sheet

VSD20

• Download + unzip the VSD20 spreadsheet
• Enable macros when prompted
• Follow the steps under the VSD Configuration section of the GUIDE sheet