Houston Pit Map Lookup

Competition Championship Event
1

Hello,

Due to the randomization of the pits this year, it’ll be really hard to find teams. I made a spreadsheet for my team’s division and ended up expanding it to all divisions + a whole pit view.
Here are some screenshots and at the bottom is a link to the google sheet, just go to File->“Make a copy” and it’ll be free for you to edit.
Please let me know if there are any bugs or teams are missing or the map is wrong!

Feature 1 - Division Map: (Screenshot of Carver)

  1. Look up teams by typing anything next to their number on the right and it’ll highlight their pit location in yellow.
  2. Put in a match number and it’ll pull up all 6 teams, highlighting in their alliance color
    https://i.imgur.com/RxUVLsW.png
    Feature 2 - Pit Map:
  3. Type in team numbers on the left, you can enter up to 13 teams at once, and it’ll highlight all of their pit locations.
    https://i.imgur.com/v2Knmki.png

Link: https://docs.google.com/spreadsheets/d/1yTvx2UVro1Dq1jf2VKfmOfkWvONZ-VcZQ4fbbOOosFw/edit?usp=sharing

Note: If you’re going to want to integrate the division map into a different google sheet (like 4944 is by adding it into our scouting app) you’ll want to copy over both the division map and the division match sheets. (Ex: If you want Newton, copy both the NewtonMap sheet and the NewtonMatches sheet)

  • Will Ness
1 Like
2

This is awesome, thank you so much. I want this for every event.

3

Brilliant. Please if its as simple as running a quick script to get the data when Detroit is released make a workbook for that too.

4

This is amazing…Thank you very much.

5

Looks good! How about Detroit?

6

As of now I’m planning to make one for Detroit. It should be easier to make than Houston’s since all the divisions are roughly the same shape.

7

This is great, thanks so much!
Don’t know if you’re looking for suggestions but adding a comment to each team number showing the team name and location would be cool.

8

This. Is. Awesome. Thank you so much!

9

@ Those looking for this for Detroit, someone already made one before I could get back from Houston :smiley: , plus it looks a lot better

10

Thanks for this.

11

[strike]Very well put together. I added one formula on my copy to High-Light our team in the Match Schedules. I Created a new Conditional Format to Range O2:T113. The Custom Formula is

=if(and(or(O2=$B$1), not(isblank(O2))),1,0)

and then set the cell color to Yellow. Now When I put 3244 in cell B1 our team is high-lighted.

Thanks[/strike]

sorry wrong thread

12