IRI Application List

[Insanity000]

Originally Posted by Travis Hoffman

I'm not quite understanding your request.

If you scroll to the leftmost column on the first page, you can use that to provide relative ranks of the applicants after you conduct whatever sorting you choose. Just perform your sort and then fill down in the first column 1 through 106.

I see now, you are able to sort by each column from lowest to highest and vice versa. Thanks!

[Travis Hoffman]

Originally Posted by Insanity000

I see now, you are able to sort by each column from lowest to highest and vice versa. Thanks!

If you want to do a multi-criteria sort, right click anywhere in the data table, select "Sort" and then "Custom Sort...".

Also, if you click the + signs next to the state and province locations in the pivot table on the right, that location will expand to show which teams from that location applied.

[Chris Fultz]

This is the download from the website and should have all applications submitted.
It has been checked against the emails / PMs received from teams as well.

FINAL APPLICATION LIST
1 1
2 11
3 16
4 20
5 27
6 33
7 48
8 51
9 67
10 68
11 74
12 107
13 111
14 118
15 125
16 135
17 148
18 179
19 193
20 195
21 217
22 225
23 226
24 233
25 234
26 245
27 316
28 330
29 340
30 359
31 379
32 384
33 456
34 461
35 469
36 503
37 548
38 573
39 624
40 744
41 829
42 865
43 868
44 1023
45 1024
46 1058
47 1086
48 1114
49 1126
50 1218
51 1310
52 1325
53 1511
54 1619
55 1625
56 1640
57 1657
58 1675
59 1711
60 1720
61 1730
62 1741
63 1756
64 1806
65 1817
66 1902
67 1923
68 1987
69 2039
70 2056
71 2122
72 2175
73 2194
74 2337
75 2338
76 2468
77 2502
78 2512
79 2587
80 2590
81 2614
82 2826
83 2852
84 2867
85 2877
86 3015
87 3098
88 3130
89 3641
90 3824
91 3928
92 4039
93 4096
94 4143
95 4265
96 4272
97 4499
98 4587
99 4655
100 4678
101 4967
102 5012
103 5030
104 5188
105 5254
106 5413
107 5484
108 5576

[ehochstein]

Originally Posted by MMmmDUDE

And 2175!

Now you can add 3130 too

[Travis Hoffman]

FINAL RELEASE based on the final 108-team applicant list. I deleted my prior post with the spreadsheet based on the partial applicant list.

************************

For fun, I put together an Excel spreadsheet to summarize some stats for the 108 applicants.

My data source was Ed Law's final post-championship Excel release, which can be found here.

Please note that Einstein results are not factored into this spreadsheet.

Playoff Points are assigned per event based on the "30 for winner, 20 for finalist, 10 for semifinalist" method used by districts.

There is no weighting given to regionals vs. districts vs. district championships vs. divisions (good luck with that), nor is there any consideration for whether playoff points were earned as an alliance captain, 1st pick, or 2nd pick. If you want to play around with those things, more power to ya.

You can sort the information however you like, but instead of defaulting the list to boring old OPR, I did a multi-criteria sort based on the following sort order:

• Average Playoff Points Per Event (largest to smallest)
• Average Event Seed (smallest to largest)
• OPR Rank (smallest to largest)

Finally, here's the breakdown of applicants by location:

[MMmmDUDE]

Originally Posted by ehochstein

Now you can add 3130 too

YES, 3130 has a great team and robot. It has been great competing with them at Northern Lights and winning the Minnesota state championship with them. Go 3130!

[Tyler Olds]

Thanks for taking the time to put this together Travis!

Originally Posted by Travis Hoffman

FINAL RELEASE based on the final 108-team applicant list. I deleted my prior post with the spreadsheet based on the partial applicant list.

************************

For fun, I put together an Excel spreadsheet to summarize some stats for the 108 applicants.

My data source was Ed Law's final post-championship Excel release, which can be found here.

Please note that Einstein results are not factored into this spreadsheet.

Playoff Points are assigned per event based on the "30 for winner, 20 for finalist, 10 for semifinalist" method used by districts.

There is no weighting given to regionals vs. districts vs. district championships vs. divisions (good luck with that), nor is there any consideration for whether playoff points were earned as an alliance captain, 1st pick, or 2nd pick. If you want to play around with those things, more power to ya.

You can sort the information however you like, but instead of defaulting the list to boring old OPR, I did a multi-criteria sort based on the following sort order:

• Average Playoff Points Per Event (largest to smallest)
• Average Event Seed (smallest to largest)
• OPR Rank (smallest to largest)

Finally, here's the breakdown of applicants by location:

[jajabinx124]

Originally Posted by MMmmDUDE

YES, 3130 has a great team and robot. It has been great competing with them at Northern Lights and winning the Minnesota state championship with them. Go 3130!

I hope all 4 MN teams that applied get(2175, 2502, 2512, 3130) in. If they do MN will be well represented at IRI this year

[Travis Hoffman]

A minor omission - my original spreadsheet is missing the number of events attended for 2 teams (5484 and 5576). Fixed the error and posted below.

[JOClarke]

I know that the IRI committee will send teams an email invitation to the event, but does anybody have a date of when this will happen.

[Mike Marandola]

Originally Posted by JOClarke

I know that the IRI committee will send teams an email invitation to the event, but does anybody have a date of when this will happen.

The website said the 22nd which is tomorrow.

[waialua359]

I hate that Hawaii to IRI flights are in the 1300-1500 range! Every year it gets higher and higher.
Good and bad if we make the cut.

[Travis Hoffman]

Originally Posted by Mike Marandola

The website said the 22nd which is tomorrow.

Could you link to where you saw that date listed?

[KosmicKhaos]

Originally Posted by Travis Hoffman

Could you link to where you saw that date listed?

I believe it has been removed now but it was originally under the 2015 IRI Application tab while applications were still open. During the period when they were open it listed some other dates such as when the applications open, when they close, etc. He is correct though, the website, when it had the dates up, said on or close to May 22.

[Travis Hoffman]

Originally Posted by KosmicKhaos

I believe it has been removed now but it was originally under the 2015 IRI Application tab while applications were still open. During the period when they were open it listed some other dates such as when the applications open, when they close, etc. He is correct though, the website, when it had the dates up, said on or close to May 22.

OK. I'd bet the over on that date. Never an easy decision.