paper: New Scouting Database from Team 2834

[cygnus.x1]

The SpaceCookies (FRC1868) will be in Atlanta and I'll be using it with the team. Not sure if we'll have real-time updating or not. Depends on the network connectivity there.

Thanks for updating the spreadsheet!

[Ed Law]

I have updated the Championship data with Thursday results for all divisions. I have also set up all the links including the elimination rounds. So if you have access to the internet at the Championship, you can just refresh the data and everything will be updated automatically. If you have any questions or need anything, please PM me or stop by our pit.

[Ed Law]

I updated the Championship data with Friday results. Good luck to all tomorrow!

[Jacob Plicque]

Thanks Ed for all the work that you have done on the scouting database. It is being used by Team 86 in Archimedes. I enjoyed meeting you in person on Friday.

[Ed Law]

I updated the final results of each division and recalculated the OPRs.

[Nathan Streeter]

Originally Posted by Ed Law

I updated the final results of each division and recalculated the OPRs.

Excellent, thank you! It's been really cool to use this spreadsheet for a statistical analysis of teams - our scouting team even used it for "pre-scouting" the Archimedes teams. Do you intend to update the spreadsheet by adding the championship data to the list of event ratings in the query sheet? Thank you very much for sharing all this information!

[Ed Law]

Originally Posted by Nathan Streeter

Excellent, thank you! It's been really cool to use this spreadsheet for a statistical analysis of teams - our scouting team even used it for "pre-scouting" the Archimedes teams. Do you intend to update the spreadsheet by adding the championship data to the list of event ratings in the query sheet? Thank you very much for sharing all this information!

Hi Nathan,

Yes I do plan to include the championship division data to the Query sheet like last year. It is on my list of things to do.

I am also thinking about the possibility of publishing a true world ranking taking into account all the district/regional/championship data so all interactions will be taken into account. Then there is no argument about strong or weak events or whether the world ranking should be based on average, most recent or weighted average. Do you think there is interest in such data? If there is, then I will look into whether my program can handle solving such a hugh system of equationos.

Ed

[Ed Law]

Version 5 is out. This will be my final version for this year unless somebody notices an error that I need to fix.

The OPR and CCWM now includes the Atlanta divisions' results also.

This version also fixed errors from version 4. This year I am including the Michigan State Championship and Atlanta data to calculate the OPR and CCWM rankings.

[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! :-)

[cje36]

ok my email is cje36f@gmail.com
send me a message with the scouting database spread sheet please!

[Ed Law]

Sorry it took so long before posting this. We had back-to-back week one and week two events and we had to maintain the First in Michigan website updating the results, I barely have any time left.

I tried to publish the database in Excel 2003-2007 format but there was an error and it would not convert. Besides the file was too big. The 2010 format takes up less space and I also zipped it. If you are using 2003-2007 Excel, you can download a utility from Microsoft to read this. If you have any trouble, please post here. I also posted the World ranking.

If you find any error, please let me know.

[Nathan Streeter]

No problem at all - thanks a bunch for doing... it's really useful!