PowerScore v2 (Demo)

	A	B	C	D	E
1
2	PowerScore v2
3
4	Credit:	Astromechs - FTC3409			www.kcastromechs.org
5
6	I Want A Copy:	Go Ahead! You're welcome to copy and use this spreadsheet. If you're logged in to google drive, you should be able to "Make a Copy..." on the File menu. Please note that downloading as an excel file is NOT SUPPORTED ... so if you try it don't be surprised if the calculations or formatting on the resulting spreadsheet doesn't work.
7
8	Overview:	PowerScore is a statistical tool used for scouting at FTC events. It is a measure of the individual scoring performance for each team and is based on team scores from qualification rounds. This spreadsheet consists of a number of sheets (see the tabs at the bottom) which drives all of the calculations and reporting. Please read and follow the instructions on each tab to use this spreadsheet properly.
9
10	Caveat about Elimination Rounds:	During elimination rounds data is reported for 3 teams, but only 2 teams will play at any given time. The net result is that elimination rounds don't work out for PowerScore. Please only use this for qualification rounds unless you really know what you're doing and filter out elims to only the teams playing a particular match.
11
12	How to Get Data:	During a tournament, data for the Teams, MatchList, and MatchDetails tabs can be copied directly from the associated web pages on the FTC_SCORE network (if one is available). For those who would like to pull data from moftcscores.net, there is a helper sheet entitled "moftcscores.net" that will help you do the conversion necessary to get to the format used by the FTC_SCORE network pages.
13
14	How to Use at a Tournament:	At a live tournament you probably won't have access to both the internet and the FTC_SCORE network at the same time. The best thing to do is have the spreadsheet ready to go in "Offline Mode". Search for "Google Drive Offline" for instructions on how to get that set up. And yes, we know it's possible to get on the FTC_SCORE network and be tethered to a mobile device. While we don't think that's a necessary step, we know some teams might prefer to use the spreadsheet that way. If you know how to set that up, more power to you. Everyone else, please follow our advise and just set it up for offline mode.
15
16	Sheet Color Codes:	Yellow indicates a sheet where raw data should be entered.
17		Green indicates a summary page where results are shown. You probably don't want to change these pages, but you won't break the core calcuations if you do.
18		Red indicates a calculation sheet that should not be modified unless you're trying to update the core calculation used for PowerScore.
19
20	Changes in v2	The biggest change from v1 is how powerscores are visualized (using a sparkline graph for each team), the format of the team summary page (showing matches and scores), and general cleanup on the various sheets. We've also removed the complexity of supporting a dual division event in 1 spreadsheet. From now on create two spreadsheets (one for each division) if you have two divisions and want to track PowerScores for both. There are still some known inefficiencies in the calculations, some day we'll fix that - right now it works pretty well.
21
22	Details:	PowerScores are calculated from qualification match scores for each team individually. These calculations are performed in two rounds, and is broken down into 4 distinct steps. These steps are blroken into idividual sheets in this spreadsheet.
23
24			Calculation Round 1		In "Round 1" of the calculation, we determine the "Alliance Score" for each team. This "Alliance Score" is simply the average of the score earned each team's alliances in the rounds they have played. In addition, during this step we also calculate the team rankings (qualifiying points and rating points) for the team rankings as defined in the tournament guidelines.
25				Step 1	Step 1 is simply a calculation of basic stats for each round, breaking the results into the scores for the red and blue alliances.
26				Step 2	Step 2 takes the calculations in step 1 (which were by round) and sums the data by team.
27
28			Calculation Round 2		In "Round 2", we adjust the "Alliance Score" for each team in order to separate out the scoring attributable to each individual team. This is a statistical separation only, and is based upon the relative Alliance Score from each team.
29				Step 3	Step 3 takes the score for each alliance in each round, and assigns a percentage of those scores to the teams that played in that round. The percantages used for this assignment are based on the Alliance Scores for each team, as calucated in step 2. These calculated scores are known as round PowerScores.
30				Step 4	Step 4 then takes the individual round PowerScores and summarizes those PowerScores by team (as an average over the number of rounds played). Finally, there is a pre-tournament PowerScore that can be entered for each team which will help reduce the variability that can show up in the first round of a tournament.
31
32				Note	It should be understood that if you are using this spreadsheet during a tournament, PowerScores for early rounds will be adjusted as later rounds are played. As data from more rounds are available, each team's "Alliance Score" will change, which will affect the splits used in determining PowerScores for each round and ultimately each team.
33
34	Pro Tip:	You'll probably be doing a lot of copying of data. In order to keep the sheets clean and to keep the fonts and colors from changing, you should probably paste data using "paste values only". You can get that option if you right-click and select "Paste special" from the pop-up menu.
35
36	Attribution:	You're more than welcome to copy and use this for your team. You're more than welcome to make changes and improve upon anything we've already done. All we ask is that you credit our team (The Astromechs - Team 3409) and include us in your list of attributions. And - please visit us on the web and/or drop us a line.
37		http://www.kcastromechs.org