paper: New Scouting Database from Team 2834

[quinxorin]

Question: why is the OPR rank for teams listed in Worldrank (and on the query page) different from the rank on the OPR Results page? For example, OPR Results gives 67 a rank of 2, but the query and Worldrank gives them a rank of 4.

[Ed Law]

Originally Posted by quinxorin

Question: why is the OPR rank for teams listed in Worldrank (and on the query page) different from the rank on the OPR Results page? For example, OPR Results gives 67 a rank of 2, but the query and Worldrank gives them a rank of 4.

Good observation! It was not a mistake.

On the sheet "Query", it gives the true World Ranking. If you go to cell M32, you will see that it is reading data from sheet "Worldrank". I felt that when somebody does a query of a particular team, they are probably more interested in the true world ranking, how they compare with other teams.

On the sheet "OPR results", it is still using the regional by regional calculation of OPR and then using either highest, most recent, simple average or weighed average OPR depending on the value used in cell G2. A blank value in G2 means using weighted average at week 6. My rationale in keeping those options is if somebody goes to that sheet that has OPR numbers of each regional, they are probably more interested in comparing between different regionals. To get the true world ranking of all the teams on one page, one can go to sheet "Worldrank".

I hope I answered your question.

[quinxorin]

It did.

[Nathan Streeter]

Any possibility that 2834 will be posting a 2011 spreadsheet weekly? I certainly would be interested in using it to better understand how teams are performing across all of FIRST! :-)