PowerScore V4 (Demo)
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
For the Rover Ruckus Season there are significant changes coming to the FTC Scoring System. We are watching those changes closely, and will be updating powerscore as necessary in response to those changes. Please watch our twitter feed for updates.
PowerScore V4
Credit:Astromechs - FTC3409www.kcastromechs.org
Attribution:You're more than welcome to copy and use this for your team use. 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) in your list of attributions, and you let us know about any improvements you make so that we can consider adding them as well. ftc@kcastromechs.org
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.
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.
Stats Calculated:PowerScore:PowerScore is the main stat calculated. PowerScore is very similar to Offensive Power Rating (OPR), though there is a subtlety in that the PowerScore calculation is a multi-round split of scores, while OPR is traditionally calculated via a least squares solution linear algebra approach. Both methods yield similar answers, though the PowerScore approach lends itself to additional visualizations. Also, in the experience of the authors of this spreadsheet (the Astromechs), PowerScore numbers "feel" slightly more accurate in most tournaments, though this is of course an arguable point.
X:X-Factor. This is a measure of the "consistency" of a team. The maximum possible is 1.00. Higher values indicate a team has been scoring consistently in their matches, while values near 0 or below indicate a team that has been less consistent. Note that for a team to be consistent, they don't have to score high; higher X-Factor numbers only indicate that a team is consistent regardless of how high or low the score is. From a mathematical standpoint, X-Factor is actually 1-(coefficient of variance) across the PowerScores for the matches played.
Rank:Rank is the current position for the team in the qualification rankings. Rank in this spreadsheet is actually calculated on a "normalized" basis, using the normalized QP/RP described below. The consequence is that the rank calculated during a tournament may not match the rank shown by the scoring system, however the rank shown in this spreadsheet is actually closer to where the team will likely end up in the final rank order.
Rounds:Number of "rounds" that have been played, in otherwords how many times a team has played. For the tournament, this is the average across all teams of how many times each team has played. For a single team, this is the number of matches the team has actually played.
QP/RP:Qualifying Points and Ranking Points. In this spreadsheet these are calculated on a "normalized" basis based on the number of rounds played by each team. In other words, this spreadsheet calculates QP and RP for the team, and then divides each by the number of rounds played. The reason for this is that this tends to give a more accurate picture while a tournament is going on of where a team should REALLY be ranked, and helps reduce cases where a team seems to "jump" over other teams simply because they've played more times, just to fall back again once the additional teams play.
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.
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).
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.
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.
Sheet Color Codes:
Yellow indicates a sheet where raw data should be entered.
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.
Red indicates a calculation sheet that should not be modified unless you're trying to update the core calculation used for PowerScore. If you do find changes to the core calculations that are useful, please let us know.
Version Summary:
V4Many improvements and fixes. An entirely new way of calculating that is both more efficient and lends itself to some cool visualizations. All of the summary pages have new features, including the ability to view and sort by multiple statistics. "Alliances" gives a way to understand how alliance powerscores work out, and can possibly help when looking at selection scenarios. Introduced the experimental "x-factor" stat (which is really just a deviation measurement) to help identify teams who have high consistency in match performance.
V3Yeah, yeah. We know. V3 never actually got released, though we did use it internally. Improvements included individual powerscores for auto, teleop, and endgame, as well as a number of visualization improvements, including the sparkline graphs and the "Alliances" tab. Unfortunately the V3 method of calculation was just not very clean nor efficient, so we never felt comfortable releasing to the public.
V2The biggest change from v1 was 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 also removed the complexity of supporting a dual division event in 1 spreadsheet. Still some known inefficiencies in the calculations, but for the most part it worked very well.
V1Initial version of the PowerScore calculation. Had native support for dual divisions in one spreadsheet, but in the end the complexity of that wasn't worth the trouble.
Main menu