ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
SPAMALYTICS v2.3
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. Use an ImportRange function to sync with the Data Input sheet. This tab can be hidden on all but the main Data Input sheet.
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. Pick lists can be customized with the Sort coefficients.
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