Texas 2018

User avatar
Riptide
Exalted Member
Exalted Member
Posts: 197
Joined: December 4th, 2017, 7:09 pm
Division: Grad
State: TX
Has thanked: 0
Been thanked: 0
Contact:

Re: Texas 2018

Post by Riptide » April 14th, 2018, 7:20 pm

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
Last edited by Riptide on April 21st, 2018, 5:34 am, edited 3 times in total.
UC Berkeley '23
Seven Lakes High School '19

User avatar
Unome
Moderator
Moderator
Posts: 4250
Joined: January 26th, 2014, 12:48 pm
Division: Grad
State: GA
Location: somewhere in the sciolyverse
Has thanked: 64 times
Been thanked: 29 times

Re: Texas 2018

Post by Unome » April 14th, 2018, 7:51 pm

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).
Nice, although I get the strong feeling that you have no idea how my spreadsheet works.
Userpage
Chattahoochee High School Class of 2018
Georgia Tech Class of 2022

Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.

User avatar
Riptide
Exalted Member
Exalted Member
Posts: 197
Joined: December 4th, 2017, 7:09 pm
Division: Grad
State: TX
Has thanked: 0
Been thanked: 0
Contact:

Re: Texas 2018

Post by Riptide » April 14th, 2018, 7:55 pm

Unome wrote:
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).
Nice, although I get the strong feeling that you have no idea how my spreadsheet works.
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!
UC Berkeley '23
Seven Lakes High School '19

User avatar
Unome
Moderator
Moderator
Posts: 4250
Joined: January 26th, 2014, 12:48 pm
Division: Grad
State: GA
Location: somewhere in the sciolyverse
Has thanked: 64 times
Been thanked: 29 times

Re: Texas 2018

Post by Unome » April 14th, 2018, 8:17 pm

Riptide wrote:
Unome wrote:
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).
Nice, although I get the strong feeling that you have no idea how my spreadsheet works.
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!
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).
Userpage
Chattahoochee High School Class of 2018
Georgia Tech Class of 2022

Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.

User avatar
Riptide
Exalted Member
Exalted Member
Posts: 197
Joined: December 4th, 2017, 7:09 pm
Division: Grad
State: TX
Has thanked: 0
Been thanked: 0
Contact:

Re: Texas 2018

Post by Riptide » April 14th, 2018, 8:48 pm

Unome wrote:
Riptide wrote:
Unome wrote: Nice, although I get the strong feeling that you have no idea how my spreadsheet works.
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!
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).
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.
UC Berkeley '23
Seven Lakes High School '19

User avatar
antoine_ego
Exalted Member
Exalted Member
Posts: 387
Joined: May 24th, 2016, 5:37 pm
Division: Grad
State: MA
Has thanked: 0
Been thanked: 0

Re: Texas 2018

Post by antoine_ego » April 15th, 2018, 4:28 am

Unome wrote:
Riptide wrote:
Unome wrote: Nice, although I get the strong feeling that you have no idea how my spreadsheet works.
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!
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).
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.
Rest in Peace Len Joeris
[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]
Acton-Boxborough Regional High School Captain 17-19

JT880
Member
Member
Posts: 19
Joined: June 25th, 2017, 7:16 am
Division: C
State: DC
Has thanked: 0
Been thanked: 0

Re: Texas 2018

Post by JT880 » April 21st, 2018, 11:11 am

Is there going to be a livestream up for awards tonight?
Washington D.C.

2018 Events
Hovercraft, Optics, Thermodynamics, Dynamic Planet, Mousetrap Vehicle

User avatar
windu34
Moderator
Moderator
Posts: 1364
Joined: April 19th, 2015, 6:37 pm
Division: Grad
State: FL
Location: Gainesville, Florida
Has thanked: 1 time
Been thanked: 22 times

Re: Texas 2018

Post by windu34 » April 21st, 2018, 11:16 am

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
Florida State Tournament Director 2020
National Physical Sciences Rules Committee Member
kevin@floridascienceolympiad.org || windu34's Userpage

Circuit Lab Event Supervisor for 2020: UT Austin (B/C), MIT (C), Solon (C), Princeton (C), Golden Gate (C), Nationals (C)

pb5754
Member
Member
Posts: 450
Joined: March 5th, 2017, 7:49 pm
Division: C
State: NJ
Has thanked: 10 times
Been thanked: 16 times

Re: Texas 2018

Post by pb5754 » April 21st, 2018, 3:45 pm

Is there a live stream or a live spreadsheet?
West Windsor-Plainsboro High School South '21

User avatar
antoine_ego
Exalted Member
Exalted Member
Posts: 387
Joined: May 24th, 2016, 5:37 pm
Division: Grad
State: MA
Has thanked: 0
Been thanked: 0

Re: Texas 2018

Post by antoine_ego » April 21st, 2018, 3:53 pm

pb5754[] wrote:Is there a live stream or a live spreadsheet?
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
I'm excited to see the results.
Rest in Peace Len Joeris
[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]
Acton-Boxborough Regional High School Captain 17-19

Locked

Return to “2018 Regionals & States”

Who is online

Users browsing this forum: No registered users and 1 guest