paper: New Scouting Database from Team 2834

[Ed Law]

Week 5 results are out. It is in version 5e.

Caution: There are some discrepancies that has not been resolved in the data from usfirst.org website.

Silicon Valley finals match score not posted
North Star finals match results incomplete
Troy match 78 results not included in QS numbers

When resolved, they will be updated in future posting.

I will be busy at Michigan State Championship and will not be able to setup links for other regionals for Week 6. I will post results of Week 6 after this weekend.

[Vikesrock]

Originally Posted by Ed Law

North Star finals match results incomplete

Oddly enough they are. Match 2 was actually a 0 to 0 win for the Blue Alliance. Blue ended with a score of 0 after penalties, but Red had a DQ so they lost, forcing a third and deciding match.

[Ed Law]

Originally Posted by Vikesrock

Oddly enough they are. Match 2 was actually a 0 to 0 win for the Blue Alliance. Blue ended with a score of 0 after penalties, but Red had a DQ so they lost, forcing a third and deciding match.

Thanks for letting me know. That was strange. I can't tell and my spreadsheet can't tell who won that match when it is 0-0. I thought that was a tie and required a 4th match that was not posted. I knew the outcome from the Awards page.

[RMiller]

Originally Posted by Ed Law

Thanks for letting me know. That was strange. I can't tell and my spreadsheet can't tell who won that match when it is 0-0. I thought that was a tie and required a 4th match that was not posted. I knew the outcome from the Awards page.

Can you manually edit the spreadsheet to have something like 0.000001 as a score? I am not familiar with the spreadsheet and do not have Excel installed on this computer otherwise I would check.

[Ed Law]

Week 6 results are out. All previous missing and wrong data from FIRST have been corrected and incorporated in this version. Keep in mind that the True World Ranking is from the whole season's performance and not an indication of strength going into Championship. The latest OPR may be a better indication of that.

I will be posting another file once the division data is out. I will also add the web links to the divisions on Thursday so teams can update the OPR numbers during the competition.

Let me know if you have any questions.

[Travis Hoffman]

Originally Posted by Ed Law

Week 6 results are out. All previous missing and wrong data from FIRST have been corrected and incorporated in this version. Keep in mind that the True World Ranking is from the whole season's performance and not an indication of strength going into Championship. The latest OPR may be a better indication of that.

I will be posting another file once the division data is out. I will also add the web links to the divisions on Thursday so teams can update the OPR numbers during the competition.

Let me know if you have any questions.

Like! Ahead of Saturday, too.

[techvikesmom]

Where can I find your spreadsheet?? I have found in the previous weeks and I would love to find it today!! Thanks for the all the great input!!

[Vikesrock]

Originally Posted by techvikesmom

Where can I find your spreadsheet?? I have found in the previous weeks and I would love to find it today!! Thanks for the all the great input!!

If you go the very first post in this thread and click the link you will be brought to a page with a number of different versions of the database on it. The latest one is "Team 2834 2011_Scouting_Database week 6 "

Here is another copy of the link in the first post:
http://www.chiefdelphi.com/media/papers/2174?

Here is a direct download link for the latest version:
http://www.chiefdelphi.com/media/papers/download/3056

[techvikesmom]

thank you for the links!!!

[Ed Law]

The divisions data is now included. I fixed the calculation for weighted average for 2011. You can select the option you prefer to rank teams.

Today is tax return due date. I looked at the number of downloads for the presentation file that explains the scouting database. Guess what the number is. (1040)

[Travis Hoffman]

Originally Posted by Ed Law

The divisions data is now included. I fixed the calculation for weighted average for 2011. You can select the option you prefer to rank teams.

Today is tax return due date. I looked at the number of downloads for the presentation file that explains the scouting database. Guess what the number is. (1040)

Thanks, Ed!

Can you please explain in more detail the calculation on the WM Results tab, column G, "Wt. Avg. CCWM", when calculated in "default" mode? How is that number obtained? How is the weighting done?

Here are your Top 25, sorted by that metric:

Robowranglers              148  1  68.0 Newton
Beach Bots                 330  2  59.3 Archimedes
OP Robotics                2056 3  58.4 Curie
Simbotics                  1114 4  57.4 Galileo
HIGHROLLERS                987  5  56.5 Curie
WildStang                  111  6  53.8 Galileo
Swartdogs                  525  7  52.7 Newton
Triple Helix               2363 8  52.1 Curie
Spartonics                 1503 9  51.8 Newton
ThunderChickens            217  10 51.5 Newton
Cheesy Poofs               254  11 51.2 Galileo
Citrus Circuits            1678 12 50.9 Curie
The Children of the Swamp  179  13 49.8 Newton
Team Titanium              1986 14 49.0 Curie
Cyber Blue                 234  15 47.2 Newton
Duluth East Daredevils     2512 16 46.9 Archimedes
Team Driven                1730 17 46.8 Newton
Delphi E.L.I.T.E.          48   18 46.4 Galileo
Miracle Workerz            365  19 45.9 Curie
Robonauts                  118  20 45.7 Archimedes
Kinetic Knights            781  21 45.5 Archimedes
North STARS                1771 22 45.0 Galileo
Team Tators                2122 23 44.3 Newton
Iron Lions                 967  24 43.6 Galileo
WiredCats                  2415 25 43.3 Newton

[Ed Law]

Originally Posted by Travis Hoffman

Thanks, Ed!
Can you please explain in more detail the calculation on the WM Results tab, column G, "Wt. Avg. CCWM", when calculated in "default" mode? How is that number obtained? How is the weighting done?

Here is the quick answer directly from the macro.

    Case 2 To 7
        Range("G1").Select
        ActiveCell.Cells = "Wt.Avg" + cword
        For i = 1 To numrow
            rscale = 0
            rvalue = 0
            For j = 1 To numcol
                If (a(i, j) <> "") Then
                    If (a(i, j) <> 0) Then
                        rscale = rscale + 1 / (mcal - week(j))
                        rvalue = rvalue + a(i, j) / (mcal - week(j))
                    End If
                End If
            Next j
            If (rscale <> 0) Then
                rrvalue(i) = rvalue / rscale
            Else
                rrvalue(i) = -99
            End If
        Next i

When using default, mcal=7 means the weighed average is projected to Week 7. Basically the idea is earlier weeks has less weight than later weeks based on number of weeks to the projected week.
To translate this to English for the exact formula, it will have to wait until I have time after work.

[Travis Hoffman]

VBA fun

Thanks, Ed. I thought it was a "what have you done for me lately" kind of deal.

Another question, one you've been asked before, likely. When I attempt to open your spreadsheet in Excel 2003 (I have the Office 2007 compatibility pack), it always seems to freeze up.

Is there a way to get your spreadsheet to work as an Excel 2003 xls, or perhaps is there a way to re-save it in another 2007 format such that it can be opened in 2003?

[The Lucas]

Originally Posted by Travis Hoffman

VBA fun

Thanks, Ed. I thought it was a "what have you done for me lately" kind of deal.

Another question, one you've been asked before, likely. When I attempt to open your spreadsheet in Excel 2003 (I have the Office 2007 compatibility pack), it always seems to freeze up.

Is there a way to get your spreadsheet to work as an Excel 2003 xls, or perhaps is there a way to re-save it in another 2007 format such that it can be opened in 2003?

I assume it is a space issue since Ed already has to zip it for CD to accept it and Excel 2003 format would be significantly larger. It would be nice if someone could figure out what part of the spreadsheet crashes the 2003 converter (I suspect the OPR Results sheet with all its buttons and some of the colors don't exist in Excel 2003 ).

I have had success opening the spreadsheet in a new Windows version of OpenOffice. I was then able to copy (to Excel 2003 format) the WorldRank sheet and all its precious data

[Ed Law]

Originally Posted by Travis Hoffman

VBA fun

Thanks, Ed. I thought it was a "what have you done for me lately" kind of deal.

Another question, one you've been asked before, likely. When I attempt to open your spreadsheet in Excel 2003 (I have the Office 2007 compatibility pack), it always seems to freeze up.

Is there a way to get your spreadsheet to work as an Excel 2003 xls, or perhaps is there a way to re-save it in another 2007 format such that it can be opened in 2003?

I tried many different ways to save it to Excel 2003 format but it crashed every time no matter what I did. I tried taking out all the colors and macros that I can find but it still crashed.
Yes it was a space issue. The file got too big with more teams and more events. I also added the World ranking sheet.
Does anybody know what the file size limit is?