Texas 2018
- Riptide
- Exalted Member
- Posts: 202
- Joined: December 4th, 2017, 7:09 pm
- Division: Grad
- State: TX
- Has thanked: 0
- Been thanked: 8 times
- Contact:
Re: Texas 2018
Live Medal Sheet
I'll be updating this next week at state as best as I can (shoutout to Unome for the design!).
Division B and Division C are two separate pages (switch pages at the bottom of the screen).
EDIT: New link to spreadsheet, made some changes
I'll be updating this next week at state as best as I can (shoutout to Unome for the design!).
Division B and Division C are two separate pages (switch pages at the bottom of the screen).
EDIT: New link to spreadsheet, made some changes
Last edited by Riptide on April 21st, 2018, 5:34 am, edited 3 times in total.
UC Berkeley
Seven Lakes High School '19
Seven Lakes High School '19
- Unome
- Moderator
- Posts: 4342
- Joined: January 26th, 2014, 12:48 pm
- Division: Grad
- State: GA
- Has thanked: 239 times
- Been thanked: 95 times
Re: Texas 2018
Nice, although I get the strong feeling that you have no idea how my spreadsheet works.Riptide wrote:Live Medal Sheet
I'll be updating this next week at state as best as I can (shoutout to Unome for the design!).
Division B and Division C are two separate pages (switch pages at the bottom of the screen).
- Riptide
- Exalted Member
- Posts: 202
- Joined: December 4th, 2017, 7:09 pm
- Division: Grad
- State: TX
- Has thanked: 0
- Been thanked: 8 times
- Contact:
Re: Texas 2018
When I made a copy of it, a lot of it got deleted so I just changed up some things on my own. Seems to work out fine, but if you see anything I should change please let me know!Unome wrote:Nice, although I get the strong feeling that you have no idea how my spreadsheet works.Riptide wrote:Live Medal Sheet
I'll be updating this next week at state as best as I can (shoutout to Unome for the design!).
Division B and Division C are two separate pages (switch pages at the bottom of the screen).
UC Berkeley
Seven Lakes High School '19
Seven Lakes High School '19
- Unome
- Moderator
- Posts: 4342
- Joined: January 26th, 2014, 12:48 pm
- Division: Grad
- State: GA
- Has thanked: 239 times
- Been thanked: 95 times
Re: Texas 2018
That's because the public spreadsheet is taking in data from a separate hidden spreadsheet using IMPORTRANGE - on that hidden one, I enter teams by number and use VLOOKUP to get the team names and all. Everything happens on that spreadsheet and gets copied over to the public one (besides the conditional formatting, which has to be on the public one as well).Riptide wrote:When I made a copy of it, a lot of it got deleted so I just changed up some things on my own. Seems to work out fine, but if you see anything I should change please let me know!Unome wrote:Nice, although I get the strong feeling that you have no idea how my spreadsheet works.Riptide wrote:Live Medal Sheet
I'll be updating this next week at state as best as I can (shoutout to Unome for the design!).
Division B and Division C are two separate pages (switch pages at the bottom of the screen).
- Riptide
- Exalted Member
- Posts: 202
- Joined: December 4th, 2017, 7:09 pm
- Division: Grad
- State: TX
- Has thanked: 0
- Been thanked: 8 times
- Contact:
Re: Texas 2018
Ohh that makes sense, I was confused as to what that was. I was thinking of doing something along those lines but didn’t feel like spending the time figuring it out lol.Unome wrote:That's because the public spreadsheet is taking in data from a separate hidden spreadsheet using IMPORTRANGE - on that hidden one, I enter teams by number and use VLOOKUP to get the team names and all. Everything happens on that spreadsheet and gets copied over to the public one (besides the conditional formatting, which has to be on the public one as well).Riptide wrote:When I made a copy of it, a lot of it got deleted so I just changed up some things on my own. Seems to work out fine, but if you see anything I should change please let me know!Unome wrote: Nice, although I get the strong feeling that you have no idea how my spreadsheet works.
UC Berkeley
Seven Lakes High School '19
Seven Lakes High School '19
- antoine_ego
- Exalted Member
- Posts: 387
- Joined: May 24th, 2016, 5:37 pm
- Division: Grad
- State: MA
- Has thanked: 0
- Been thanked: 0
Re: Texas 2018
Another way to do this is to have Data Validation to make a drop down menu of teams. You can type in either the number or the first few letters of the team name and it'll filter through.Unome wrote:That's because the public spreadsheet is taking in data from a separate hidden spreadsheet using IMPORTRANGE - on that hidden one, I enter teams by number and use VLOOKUP to get the team names and all. Everything happens on that spreadsheet and gets copied over to the public one (besides the conditional formatting, which has to be on the public one as well).Riptide wrote:When I made a copy of it, a lot of it got deleted so I just changed up some things on my own. Seems to work out fine, but if you see anything I should change please let me know!Unome wrote: Nice, although I get the strong feeling that you have no idea how my spreadsheet works.
Rest in Peace Len Joeris
Acton-Boxborough Regional High School Captain 17-19
[b]2016 Air Trajectory Nationals - 3rd 2018 Hovercraft Nationals - 6th 2018 Mousetrap Nationals - 6th 2018 Nationals - Team 9th Place! 2019 Astronomy Nationals - 3rd! 2019 Nationals - Team 9th Place! [/b]
- windu34
- Staff Emeritus
- Posts: 1384
- Joined: April 19th, 2015, 6:37 pm
- Division: Grad
- State: FL
- Has thanked: 2 times
- Been thanked: 42 times
Re: Texas 2018
Good luck to all Texas teams competing today! If I am anxious about the outcome, I can only imagine what it must be like for you all...
Boca Raton Community High School Alumni
University of Florida Science Olympiad Co-Founder
Florida Science Olympiad Board of Directors
[email protected] || windu34's Userpage
University of Florida Science Olympiad Co-Founder
Florida Science Olympiad Board of Directors
[email protected] || windu34's Userpage
-
- Exalted Member
- Posts: 518
- Joined: March 5th, 2017, 7:49 pm
- Division: C
- State: NJ
- Pronouns: He/Him/His
- Has thanked: 45 times
- Been thanked: 85 times
Re: Texas 2018
Is there a live stream or a live spreadsheet?
West Windsor-Plainsboro High School South '21
2021 Nationals: Astronomy - 1st, Geologic Mapping - 1st, Team - 6th
2021 Nationals: Astronomy - 1st, Geologic Mapping - 1st, Team - 6th
- antoine_ego
- Exalted Member
- Posts: 387
- Joined: May 24th, 2016, 5:37 pm
- Division: Grad
- State: MA
- Has thanked: 0
- Been thanked: 0
Re: Texas 2018
pb5754[] wrote:Is there a live stream or a live spreadsheet?
I'm excited to see the results.Riptide wrote:Live Medal Sheet
I'll be updating this next week at state as best as I can (shoutout to Unome for the design!).
Division B and Division C are two separate pages (switch pages at the bottom of the screen).
EDIT: New link to spreadsheet, made some changes
Rest in Peace Len Joeris
Acton-Boxborough Regional High School Captain 17-19
[b]2016 Air Trajectory Nationals - 3rd 2018 Hovercraft Nationals - 6th 2018 Mousetrap Nationals - 6th 2018 Nationals - Team 9th Place! 2019 Astronomy Nationals - 3rd! 2019 Nationals - Team 9th Place! [/b]
Who is online
Users browsing this forum: No registered users and 2 guests