Worlds Divisions OPR Sheet (Schedule Strength and Rank)

[logank013]

I'm sure many of you have been looking close at your divisions, and I got bored so I made a google sheet again that I think will be intriguing to many people. Each google sheet looks at 5 main things for each team in the division. (I am only posting 3 divisions right now. The other 5 should be posted in an edit by 4/24/16 11:59 pm )

The query is probably the best tool when looking at 1 specific team. Unfortunately, you have to download the sheet to use the query.

1. Alliance OPR (Rank 1 = Best)- This takes the 3 OPRs of your alliance and averages them out.
2. Alliance OPR (-team avg.) (Rank 1 = Best)- This is the same as the Alliance OPR but takes your team out of the equation. It takes a look only at your 2 alliance partners for each match.
3. Alliance OPR Up/Down (Rank 1 = Best)- This takes a look at the Alliance OPR and the Alliance OPR (-team avg.). When looking at these two statistics, it tells you if you are bringing down your alliances' average OPR (negative) or if you are raising your alliances' average OPR (positive).
4. Opponent Alliance OPR (Avg.) (Rank 75 = Best)- This takes the OPRs of the 3 opposing alliance members and averages them. So if you are on the Red alliance of match 1, it takes finds the OPRs of the 3 Blue robots and averages them.
5. Schedule Strength (Rank 1 = Best)- This takes the Alliance OPR and subtracts the Opponent Alliance OPR. If it is positive, it means your alliance has a better OPR that match than the other alliance. If it is negative, the other alliance has a better OPR average than your alliance.

Archimedes Division
Carson Division
Carver Division
Curie Division
Galileo Division
Hopper Division
Newton Division
Tesla Division

If you have any questions about my abbreviations (many are odd) or about the data, feel free to comment or PM me. Thanks and Enjoy.