Chief Delphi
Page 10 of 16 « First < 3456789 10 111213141516 >
Show 100 post(s) from this thread on one page

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   Extra Discussion (http://www.chiefdelphi.com/forums/forumdisplay.php?f=68)
-   -   paper: New Scouting Database from Team 2834 (http://www.chiefdelphi.com/forums/showthread.php?t=70111)

Ed Law 04-04-2011 00:25
Re: paper: New Scouting Database from Team 2834
 
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 04-04-2011 00:29
Re: paper: New Scouting Database from Team 2834
 
Quote:
Originally Posted by Ed Law (Post 1049047)
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 04-04-2011 00:55
Re: paper: New Scouting Database from Team 2834
 
Quote:
Originally Posted by Vikesrock (Post 1049050)
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 04-04-2011 01:05
Re: paper: New Scouting Database from Team 2834
 
Quote:
Originally Posted by Ed Law (Post 1049060)
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 13-04-2011 21:17
Re: paper: New Scouting Database from Team 2834
 
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 13-04-2011 21:45
Re: paper: New Scouting Database from Team 2834
 
Quote:
Originally Posted by Ed Law (Post 1052561)
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 14-04-2011 10:28
Re: paper: New Scouting Database from Team 2834
 
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 14-04-2011 10:38
Re: paper: New Scouting Database from Team 2834
 
Quote:
Originally Posted by techvikesmom (Post 1052715)
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 14-04-2011 21:02
Re: paper: New Scouting Database from Team 2834
 
thank you for the links!!!

Ed Law 18-04-2011 08:53
Re: paper: New Scouting Database from Team 2834
 
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 18-04-2011 11:19
Re: paper: New Scouting Database from Team 2834
 
Quote:
Originally Posted by Ed Law (Post 1053982)
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:

Code:
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 18-04-2011 11:39
Re: paper: New Scouting Database from Team 2834
 
Quote:
Originally Posted by Travis Hoffman (Post 1054021)
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.
Code:
    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 18-04-2011 15:50
Re: paper: New Scouting Database from Team 2834
 
Code:
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 18-04-2011 17:17
Re: paper: New Scouting Database from Team 2834
 
Quote:
Originally Posted by Travis Hoffman (Post 1054114)
Code:
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 :rolleyes: ).

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 18-04-2011 22:46
Re: paper: New Scouting Database from Team 2834
 
Quote:
Originally Posted by Travis Hoffman (Post 1054114)
Code:
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?


All times are GMT -5. The time now is 11:00.
Page 10 of 16 « First < 3456789 10 111213141516 >
Show 100 post(s) from this thread on one page

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi