Team 2834 Scouting Database 2009 Championship
 

I have updated the database to show which teams are going to Atlanta. When the divisions are annouced, I will create 4 separate tabs for them. There will be links to update results from the internet. I hope there will be internet access there. Otherwise I will have to update it manually again. Actually there are two macros to help you calculate approximate ranking and calculate OPR and CCWM. Read the instructions tab for details.

If you plan to use this at the World Championship and you have any questions, please stop by Team 2834's pit.

Ed

Re: paper: New Scouting Database from Team 2834
 

Scouting database updated with Championship divisions. Links are not set up yet to update standings and match results. I also corrected the BAE results with the regional winners and finalists but I still don't have data of the final match.

I will post division strength in a separate post.

Ed

Re: paper: New Scouting Database from Team 2834
 

Hi Ed,

Thanks for the info. The BAE finals match 3 score was 98-55.

Thanks,

Re: paper: New Scouting Database from Team 2834
 

Oops, I forgot to change the sort macro in version 2 after I inserted the 4 championship divisions column. The sorting macro is now fixed in version 3. Sorry for the inconvenience.

Ed

Re: paper: New Scouting Database from Team 2834
 

Version 4 is out. I put in all the matches and links to usfirst.org. This is a version you can use tomorrow and Saturday morning during the qualifying rounds. I couldn't get internet access today there, so we will have to update the match results by hand.

Good luck tomorrow.

Ed

Re: paper: New Scouting Database from Team 2834
 

I just noticed that the Oregon results were wrong. It is too late for me to change it tonight. I will fix it Friday night. The OPR and CCWM are correct, only the alliance selection data was wrong.

That wrong data has been there for a while. If anybody notice anything wrong, please post it here to let me know so I can fix it. Thanks.

Ed

Re: paper: New Scouting Database from Team 2834
 

Version 5 is out. I regenerated all the regional data. The problem was some of the regional data that FIRST published had the elimination round schedule all mixed up instead of following the order with quarterfinal, then semifinal then final. My program figure out the selection order based on the elimination round matches and did not anticipate out of order listing and posted some wrong alliance selection info.

I also have updated championship info as of end of Friday. If you want to use this spreadsheet tomorrow, just enter the match results manually and follow the instructions on how to use it. You can also look for me and I will show you how to use it. I will be between the pit and the Curie stand sitting right in front of the Thunder Chickens.

Ed

Re: paper: New Scouting Database from Team 2834
 

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

The spreadsheet can now handle 5 events per team instead of 4 as quite a few Michigan teams went to 5 events (3 districts, state championship and Atlanta).

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

There is a long list of improvement I plan to do for next year. Now is a good time to tell me what kind of improvement you would like to see.

Thank you for the encouragement from many of you as I will only continue to do this if people actually find it useful.

For offseason, we plan to go to MARC and Kettering. We will try to apply to go to IRI but it may be tough to get in as a rookie team even though we have a good record this year. I would be happy to add a sheet for IRI if anyone is interested.

Ed

Re: paper: New Scouting Database from Team 2834
 

This is Obed, a rookie member of 354, wondering how do you put information the scouting database.

Team 2834 Scouting Database for 2010
 

The 2010 Scouting Database from Team 2834 is out. I added links for Week One only. I have to do it manually and it is very time consuming. I wrote a program last summer to add links automatically but it is not working. With the changes in scoring this year, I don't know if they are changing the format. I am going to wait until past Week One before I do the rest. We are going to a Week One competition also so I will not have time to re-publish it on Friday if it does not work. I apologize in advance.

A few words about OPR and CCWM this year. There were some discussions about whether OPR and CCWM have any meaning this year. So far I stayed out of that discussion partly because I was busy working with my team to build our robot. Also I do not want to get into a debate. If you do not think OPR and CCWM is useful this year, don't read on. I am not trying to convince you.

So here is my thought on OPR and CCWM. The number of goals scored this year is meaningless because teams who have a big lead will try to score for their opponents. The winning margin is therefore meaningless also. Unlike last year where the offensive score was based on how many moon rocks and supercells were scored, this year the reported score is not based on goals. The reported score is actually the seeding score. Since teams will try to maximize their seeding score, they will try their best.

The interpretation of OPR this year has to be changed slightly. It is not a measure of how strong their offensive power or how many balls the team can score. It is a measure of how successful the team is to get a high seeding score for their alliance. This is why I think OPR is still meaningful but we have to interpret it differently.

On the other hand, I think CCWM has no meaning this year because of the way the coopertition points are given out. However, my program will still calculate and report CCWM. I do not want to change the program just for this year.

Re: paper: New Scouting Database from Team 2834
 

I am sorry but you need to clarify what you would like to ask. I am not sure what you mean.

All the data came from usfirst.org. I wrote a number of macros and use Excel functions where convenient to organize the data. You can PM me if you would like more information.

Re: paper: New Scouting Database from Team 2834
 

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

Re: paper: New Scouting Database from Team 2834
 

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.

Re: paper: New Scouting Database from Team 2834
 

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.

Re: paper: New Scouting Database from Team 2834
 

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)