Announcement

Collapse
No announcement yet.

World Data

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • World Data

    Getting ready for Worlds, here is team data from every event, the World Skills rankings, and the list of teams registered for IQ Worlds

    I'll try to keep it updated as more teams register.

    Steve
    WorldMS 23, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26 Team#, Team Name, School, City, State, Country, Score Used, Total Matches, Average, Rank, Best Score, Rank, Worlds, Total, Max Programming, Max Driver, Skills Event, Skill Rank, Prog Rank,...

  • #2
    Updated 3/12

    Comment


    • #3
      Steve, this is amazing. Thank you so much for doing it and sharing
      .

      Comment


      • #4
        Steve, Can you help me understand the first 6 columns please?
        Match Best Program Driver Final Calculated

        Comment


        • #5
          Are you just copying and pasting like a madman? How are you doing this???

          Are you scraping the robotevents site like vexdb?

          Very impressive. I've never used the filter command, still using vlookup for everything. Great work overall.

          Comment


          • #6
            The first six columns are the "rank" of the team in the listed categories. The first column shows where a team's average match score ranks against all other teams going to Worlds, in their division.

            Other rankings are for:
            Best non-finals score a team earned all season.
            Max Programming Score
            Max Driver Score
            Average Finals Score

            The last column is the rank of a calculated field, the average of the above five scores, for their entire season.

            Comment


            • #7
              sankeydd, I wrote a program to pull data off the robotevents site. No cut & paste.

              Comment


              • #8
                Originally posted by Steve Hassenplug View Post
                The first six columns are the "rank" of the team in the listed categories. The first column shows where a team's average match score ranks against all other teams going to Worlds, in their division.

                Other rankings are for:
                Best non-finals score a team earned all season.
                Max Programming Score
                Max Driver Score
                Average Finals Score

                The last column is the rank of a calculated field, the average of the above five scores, for their entire season.

                Is there any sort of weighting for strength of partners at competition or is this just straight scores? It would be kind of cool to take into account that some regions have stronger potential partners and thus scores are higher/lower based on your region (ie scores at APAC are much higher then most US competitions.)

                Comment


                • #9
                  Very true. Let me think about this...

                  Comment


                  • #10
                    I added a couple columns. First is the average score for all tournaments that the team is in. Second is the difference between that score, and the team's average score.

                    Comment


                    • #11
                      I just added possible divisions, and a summary page.

                      Comment


                      • #12
                        New spreadsheet with Match data
                        Science MSScience, 125. 0, max 1, 89. 9, min Alliance, Skills, Matches #, Team, Name, Score, Rank, driver, programming, combined, Rank, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 1, 12580F, FuzhouNO. 1HS& CFR,, 104. 9, 46, 232, 120, 352, 2,[ 38] 1827B( 29)= 176,[ 78] 15267A( 47)= 166,[ 118] 49651A( 76)= ...

                        Comment


                        • #13
                          Hey Steve, this data is awesome! We're in the Chandra division on ES and have a match with 71832A. Your data has them ranked as "810" in the cells to the right (see Q21). I also don't see them as a team on the left. Did they not get pulled over properly maybe?

                          Also, in this formula, how do you arrive at 115? I assume that is what's driving the overall rank?
                          [32]5420A(35)=115

                          Thanks!

                          Comment


                          • #14
                            uncchs9, good luck with that team.

                            I'm not sure what happened. I'll try to look into it.

                            Comment


                            • #15
                              Hopefully a small request, can you freeze the top rows and the two left most lows of the Elementary Divisions in the same way they are in the Middle School divisions on the WorldsData18 Spreadsheet?

                              https://docs.google.com/spreadsheets...t#gid=84290680

                              Really appreciate all the work your doing, it'll be fun to see if our teams out perform the data. Thanks!

                              Comment

                              Working...
                              X