Scioly.org

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

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.

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!

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).

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.

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.

Is there going to be a livestream up for awards tonight?

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...

Is there a live stream or a live spreadsheet?

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.