Orlando Regional SPAMalytics - 2019
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
SPAMALYTICS v2.0
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
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
INPUT: Enter a match to record. Enter the data from the scouting sheets. 'Save Match Data' runs a script that transfers the data to MATCH DATA. Repeat. This tab can be hidden on all but the main Data Input sheet.
18
19
20
MATCH DATA: The data from every match that has been played so far. Uses an ImportRange function to sync with the Data Input sheet. This tab can be hidden on all but the main Data Input sheet.
21
22
23
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.
24
25
26
MATCH STRATEGY: Plan an upcoming match. Put a match number in the yellow box, and the table will populate with the relevant statistics.
27
28
29
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.
30
31
Loading...