VRC LRS division assignment and rankings

VEX Robotics Competition Discussion VRC > Change Up (20/21)
1

VRC LRS HS teams, divisions and rankings

5 Likes
2

VRC LRS MS teams, divisions and rankings

3 Likes
3

Rest in peace HS Jupiter division

4

Some data may not be accurate as some teams have no skills score at all. Excel vlookup cannot detect such situation.

5

I though that the division assignments were suppose to be by skill? Why on earth is 4478D with a score of 252 in Jupiter when the next highest score is 166?

6

that’s because 4478D had no score at all. excel calculation error. lol

7

put a 0 as your fourth arguement. That will make it come back with an #N/A and then use iferror to catch it.

3 Likes
8

good call! thanks. worksheet is now fixed.

1 Like
9

bug fixed. check again. :slight_smile:

1 Like
10

Random question, but what is the “Post Code” field in your spreadsheet?

11

Postal code

1 Like
12

Some of them are quite clearly not postal codes.

13

Oh. Retrieved postal code/zip code from robotevents. Lol

1 Like
14

Some of them come from other countries :exploding_head:

2 Likes