paper: New Scouting Database from Team 2834

[Ed Law]

I also updated the regionals and districts which teams are attending. Hope that helps.

[Ed Law]

OPR results from Week 2 is out. You can download the data from

http://www.chiefdelphi.com/media/papers/2174

If there is any mistake, please let me know.

I need to make some corrections on my recent post on 2/21. The reported score is not the seeding score as I thought before week 1. It is the actual number of goals minus penalties.

I am a little surprised how good the correlation is of OPR to results prediction. At most regionals/districts, the prediction is 70-80% accurate. It also correlates very well with the actual alliance selection. Look at the data and you can be the judge.

Also the correlations are better for Week 2 than Week 1. It probably has to do with the additional 5 seeding points for a win.

[Ed Law]

Forgot to mention that Wisconsin Regional ranking data is missing. I did include the OPR numbers for that event. If anybody has information on when the data will be posted, please let me know.

[Vikesrock]

Originally Posted by Ed Law

Forgot to mention that Wisconsin Regional ranking data is missing. I did include the OPR numbers for that event. If anybody has information on when the data will be posted, please let me know.

The information was up during the event and then disappeared after. The same thing happened for Peachtree both last year and this year.

I have the order, SP and CP points for the event still on my phone, if you want them let me know (PM with your email would probably be best) and I will type them up and send them to you.

EDIT: I didn't realize the Peachtree data had reappeared, last year it never came back up (still missing to this day)

[Ed Law]

Thanks to "Vikesrock" who sent me the Wisconsin data, I have added the ranking information, Seeding Score and Coopertition Bonus but I am still missing the Hanging Points. He mentioned that the Seeding Score may have a slight error since 2194 is listed with the highest Coop points and 111 got the award. If anyone has more information, please let me know.

[cygnus.x1]

Thanks for reviving this spreadsheet Ed!

It's working great. We're off to SVR tomorrow.

[Joe Ross]

I'm having trouble updating the data for Silicon Valley. I change to the tab called SiliconValley and do ctrl-shift-p and I get Run-time error '1004'. If I hit debug, it's failing on the first querytable refresh. I notice that if I'm on one of the regionals with existing data, I see the external data toolbar pop up, but I don't see that on the later regionals. Is there something more I need to do?

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

[Ed Law]

Championship data Version 3 including Thursday and Friday results are uploaded. I fixed one problem with the OPR data calculation. However there is something very strange going on with the links. It keeps changing the link to KC, NH, TN and STX. If the Ctrl Shift P does not work, you will need to manually copy and paste into the spreadsheet.

A lot of these latest problem with the spreadsheet is because the spreadsheet was developed not expecting any regional to have more than 97 teams. Since we have 100 teams in each division, there was not enough room to put the standing data between 1 and 100. There are also more matches than I have allocated room for. I have to add rows and there were a lot of changes in the macros and formulas that I sometimes missed.

After the championship is over, I will need to clean this up and probably delete and redo all the links once and for all.

[faust1706]

wow. that is truly an amazing work of excel. Thanks for posting this, cant even begin to imagine how it was made!

[Siri]

A note to passers-by, this is the 2012 thread. (Took me a minute.) 2013 is here: http://www.chiefdelphi.com/forums/sh...d.php?t=115101

[Ed Law]

Originally Posted by faust1706

wow. that is truly an amazing work of excel. Thanks for posting this, cant even begin to imagine how it was made!

Thanks. It is through a combination of Excel formulas and VBA. Very little is done by hand.
This was the original thread from some years ago. I still put the weekly data here to make it easier for people to find it. Each week I create a new thread to let people know new data is available.