Team 2194 is happy to share our Scouting Analysis Spreadsheet again this year. We’ve been using this format for many years, and it has helped us analyze scouting data to make decisions for match strategy and making pick lists.
The spreadsheet is formatted to work with PWNAGE ScoutingPASS, but it could work with any system if you format your data to work with our “Match Input” Tab. There are many macros, so you’ll need to enable macros to use the file. There’s an instruction tab that should (hopefully) explain everything.
Here’s the link to the files in Google Drive.
https://drive.google.com/drive/folders/1vtjSxebfZWaPfXW7-0J41sTaQBHWqnCy?usp=sharing
The folder contains four files:
-2194 Scouting Analysis-Crescendo
-2194 Scouting Analysis-Crescendo – with sample data (the data is fictitious)
-SCAN QR Codes HERE
-Create Match Schedule from TBA (this file helps copy/paste the match schedule into a format that works with our analysis spreadsheet)
NEW this year is a tab called “SUPER SCOUT”. It can be used for subjective, qualitative scouting when watching the match from an overall perspective. A macro button filters the teams so only the teams in the current match are shown. It’s a convenient way to take notes throughout the day and have them all in one place.
Note that when you download the files, Windows might block the macros by making the file “untrusted”. If that happens, go to Windows File Explorer, right click on the file, click Properties, then at the Security section at the bottom of the General Tab, click the box to UNBLOCK the file.
Below are sample pictures of the output (the data is fictitious).