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
Texas 2018
-
Riptide
- Exalted Member
- Posts: 202
- Joined: Mon Dec 04, 2017 7:09 pm
- Division: Grad
- State: TX
- Has thanked: 0
- Been thanked: 8 times
Re: Texas 2018
Last edited by Riptide on Sat Apr 21, 2018 5:34 am, edited 3 times in total.
UC Berkeley
Seven Lakes High School '19
Seven Lakes High School '19
-
Unome
- Moderator
- Posts: 4315
- Joined: Sun Jan 26, 2014 12:48 pm
- Division: Grad
- State: GA
- Has thanked: 219 times
- Been thanked: 76 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: Mon Dec 04, 2017 7:09 pm
- Division: Grad
- State: TX
- Has thanked: 0
- Been thanked: 8 times
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: 4315
- Joined: Sun Jan 26, 2014 12:48 pm
- Division: Grad
- State: GA
- Has thanked: 219 times
- Been thanked: 76 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: Mon Dec 04, 2017 7:09 pm
- Division: Grad
- State: TX
- Has thanked: 0
- Been thanked: 8 times
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: Tue May 24, 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]
-
JT880
- Member
- Posts: 19
- Joined: Sun Jun 25, 2017 7:16 am
- Division: C
- State: DC
- Has thanked: 0
- Been thanked: 0
Re: Texas 2018
Is there going to be a livestream up for awards tonight?
Washington D.C.
2018 Events
Hovercraft, Optics, Thermodynamics, Dynamic Planet, Mousetrap Vehicle
2018 Events
Hovercraft, Optics, Thermodynamics, Dynamic Planet, Mousetrap Vehicle
-
windu34
- Staff Emeritus
- Posts: 1382
- Joined: Sun Apr 19, 2015 6:37 pm
- Division: Grad
- State: FL
- Has thanked: 2 times
- Been thanked: 37 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
kevin@floridascienceolympiad.org || windu34's Userpage
University of Florida Science Olympiad Co-Founder
Florida Science Olympiad Board of Directors
kevin@floridascienceolympiad.org || windu34's Userpage
-
pb5754
- Exalted Member
- Posts: 518
- Joined: Sun Mar 05, 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: Tue May 24, 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]