ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
SPAMALYTICS v2.4
FRC STRATEGY TOOL		Click here to go to the Google Sheet
3
4
5
6
This file is a TEMPLATE. To use it, go to the ORIGINAL Google Sheet. Go to FILE (SHARE on mobile) and select "MAKE A COPY." This will place a new, separate copy of the sheet in your own Google Drive, where you can then work on your sheet. CREDITS
7
8
9
 SPAMALYTICS is a project of FRC 180 SPAM Robotics.

 CONTRIBUTORS
 George Wallace
Warren Boudreaux
Jennifer Woods
10
11
12
13
TAB USAGE INSTRUCTIONS:
14
MATCH LIST: Paste or enter by hand the match list for your event. Once done, it's recommended to hide this tab.
15
16
17
MATCH DATA: The data from every match that has been played so far. If using an ImportRange function to sync with a Data Input sheet instead, this tab can be hidden.
18
19
20
SUMMARY: Cumulative data for the tournament. "Effective Score" and "Sort" columns analyze teams based on the collapsible coefficient rows. "Effective Score" represents our best model of the game. Customizing the "Sort" coefficients can help in creating a pick list.
21
22
23
MATCH STRATEGY: Plan an upcoming match. Put a match number in the yellow box, and the table will populate with the relevant statistics.
24
25
26
TEAM REPORT: Look up all matches played by a particular team. Put a team number in the yellow box, and the table will populate with the relevant statistics.
27
28