Unosmium Results and the SciolyFF

For anything Science Olympiad-related that might not fall under a specific event or competition.
User avatar
Tailsfan101
Member
Member
Posts: 829
Joined: April 14th, 2017, 4:33 pm
Division: Grad
State: ID
Has thanked: 130 times
Been thanked: 117 times
Contact:

Re: Unosmium Results and the SciolyFF

Post by Tailsfan101 »

A small note, but on the 2019 ID C spreadsheet, "Capital" is misspelled.

I'm really liking the format for the spreadsheet! Good job!
"Blessed are you when people insult you and persecute you, and falsely say all kinds of evil against you because of Me. Rejoice and be glad, for your reward in heaven is great; for in the same way they persecuted the prophets who were before you." Matthew 5:11-12

I have no regrets.
RoboMarth
Member
Member
Posts: 71
Joined: August 7th, 2014, 7:51 pm
Division: Grad
State: OH
Has thanked: 25 times
Been thanked: 32 times

Re: Unosmium Results and the SciolyFF

Post by RoboMarth »

Tailsfan101 wrote:A small note, but on the 2019 ID C spreadsheet, "Capital" is misspelled.

I'm really liking the format for the spreadsheet! Good job!
Fixed! Thanks, glad it works :)
User avatar
sciolyperson1
Exalted Member
Exalted Member
Posts: 1072
Joined: April 23rd, 2018, 7:13 pm
Division: C
State: NJ
Pronouns: He/Him/His
Has thanked: 529 times
Been thanked: 600 times
Contact:

Re: Unosmium Results and the SciolyFF

Post by sciolyperson1 »

All Div B:

Northmont:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Dodgen:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Eagle View:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Cornell:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Harvard:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

LISO:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Rustin:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Garnet Valley:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

And finally, I have an issue: for Centerville, many teams NSed the competition (weather, I think). For the teams that did participate, the events that no showed were placed as 46th (45 teams participated, while 58 signed up). Should we include the teams that didn't go at all, or should we mark them as exhibition? (link below)
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Overall results were pretty fun to put it ngl, I only did the invies that were listed above because I either had the master scoresheet, or ezra provided a download as csv sheet. Some comps (nj states and regs) have pdfs, which could possibly be converted into a spreadsheet format, but would take too much effort (im lazy -__-), For those who run invitationals: it would be great to update your websites one last time, with the results. Shout out to Cornell Invy lol, they're one of the only ones who actually updated it (and Cornell nats too!)
SoCal Planning Team & BirdSO Tournament Director
WW-P HSN '22, Community MS '18
Sciolyperson1's Userpage
RoboMarth
Member
Member
Posts: 71
Joined: August 7th, 2014, 7:51 pm
Division: Grad
State: OH
Has thanked: 25 times
Been thanked: 32 times

Re: Unosmium Results and the SciolyFF

Post by RoboMarth »

sciolyperson1 wrote:All Div B:

Northmont:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Dodgen:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Eagle View:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Cornell:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Harvard:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

LISO:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Rustin:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Garnet Valley:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

And finally, I have an issue: for Centerville, many teams NSed the competition (weather, I think). For the teams that did participate, the events that no showed were placed as 46th (45 teams participated, while 58 signed up). Should we include the teams that didn't go at all, or should we mark them as exhibition? (link below)
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Overall results were pretty fun to put it ngl, I only did the invies that were listed above because I either had the master scoresheet, or ezra provided a download as csv sheet. Some comps (nj states and regs) have pdfs, which could possibly be converted into a spreadsheet format, but would take too much effort (im lazy -__-), For those who run invitationals: it would be great to update your websites one last time, with the results. Shout out to Cornell Invy lol, they're one of the only ones who actually updated it (and Cornell nats too!)
Oh wow that's a lot of results, thanks! I'll try to get them all added soon. Could you give me (zqianem@gmail.com) edit access for these? There are some school names I want to standardize to make it easier to track teams across tournaments.

For Centerville, marking them as exhibition is probably the best thing to do (although a bit awkward, might want to add something for this situation in the future), if only to explain why the team numbers go up to 58.
User avatar
gz839918
Admin Emeritus
Admin Emeritus
Posts: 233
Joined: April 27th, 2019, 6:40 pm
Division: Grad
State: WI
Pronouns: He/Him/His
Has thanked: 453 times
Been thanked: 371 times
Contact:

Re: Unosmium Results and the SciolyFF

Post by gz839918 »

Raymond Park is from Indiana, not Ohio, and one of its team names is spelled incorrectly... unfortunately the original Northmont scoresheet that was distributed after awards messed up their name lol

Also, RoboMarth, how will you deal with states like Florida, which I believe caps the maximum placement in an event at 20? So, all teams who place worse than 20th in some event receive a 20 in the scoresheet for that event, whatever their true ranking is. Anyways, thank you for your awesome efforts in developing such a useful and aesthetically clean results database. I can't even begin to imagine how much work you put into this...
I ❤ sounds of music! About meRate my tests

Carmel High School ’19
The University of North Carolina at Chapel Hill ’23
“People overestimate what they can do in a day, and underestimate what they can do in a lifetime.” –Unknown
RoboMarth
Member
Member
Posts: 71
Joined: August 7th, 2014, 7:51 pm
Division: Grad
State: OH
Has thanked: 25 times
Been thanked: 32 times

Re: Unosmium Results and the SciolyFF

Post by RoboMarth »

gz839918 wrote:
Raymond Park is from Indiana, not Ohio, and one of its team names is spelled incorrectly... unfortunately the original Northmont scoresheet that was distributed after awards messed up their name lol

Also, RoboMarth, how will you deal with states like Florida, which I believe caps the maximum placement in an event at 20? So, all teams who place worse than 20th in some event receive a 20 in the scoresheet for that event, whatever their true ranking is. Anyways, thank you for your awesome efforts in developing such a useful and aesthetically clean results database. I can't even begin to imagine how much work you put into this...
For Florida, I'm planning on having some sort of "maximum place" field in SciolyFF so that event points for placings would be capped at that value and the PO, NS, and DQ points would also be based on that value. It's a bit tricky because the true ranking is hidden, which runs counter to core principle of SciolyFF that all placings reflect exactly what happened (e.g. exhibition teams actually do affect the placings of other teams, just not the points). So in addition the maximum place field I'm working on developing some consistent way to indicate an "unknown" place that would jive well with the rest of the assumptions of SciolyFF. (Alternatively, Florida and others could just give me the true event rankings, but that probably won't happen lol).

Thank you for the kind words! Having a lot of free time this summer helps, as well as the motivation to keep the GitHub commits per day streak going :P.
User avatar
sciolyperson1
Exalted Member
Exalted Member
Posts: 1072
Joined: April 23rd, 2018, 7:13 pm
Division: C
State: NJ
Pronouns: He/Him/His
Has thanked: 529 times
Been thanked: 600 times
Contact:

Re: Unosmium Results and the SciolyFF

Post by sciolyperson1 »

@RoboMarth, just shared the spreadsheets.

For larger tournaments (https://unosmium.netlify.com/results/20 ... ationals_b) for example, when you hit "print", the event names on the 2nd page is messed up (the event names cover the placements on the first page)
SoCal Planning Team & BirdSO Tournament Director
WW-P HSN '22, Community MS '18
Sciolyperson1's Userpage
RoboMarth
Member
Member
Posts: 71
Joined: August 7th, 2014, 7:51 pm
Division: Grad
State: OH
Has thanked: 25 times
Been thanked: 32 times

Re: Unosmium Results and the SciolyFF

Post by RoboMarth »

sciolyperson1 wrote:@RoboMarth, just shared the spreadsheets.

For larger tournaments (https://unosmium.netlify.com/results/20 ... ationals_b) for example, when you hit "print", the event names on the 2nd page is messed up (the event names cover the placements on the first page)
I've fixed this for now by just disabling printing of table headers on subsequent pages (getting the full height of the rotated events + tournament info to repeat proved too difficult with the sticky header functionality). Though for letter-size paper in portrait, the print layout should be able to handle at least 60 teams before needing another page -- you may need to manually set the zoom/scale in the print preview to ensure all the event columns (up to the yellow team penalties column) are displayed.
sciolycoach
Coach
Coach
Posts: 47
Joined: July 21st, 2008, 1:37 pm
Division: Grad
State: WI
Has thanked: 0
Been thanked: 38 times

Re: Unosmium Results and the SciolyFF

Post by sciolycoach »

Hi All,

This is really a great site, thanks RoboMarth for all of your hard work!

I have a ton of results that I will slowly start putting into Google Docs and sharing with you. I have WI state results (both B and C) at least 10 years back (over 20 years back for C I think) as well as Boyceville (WI) Invite results back quite a ways.

Thanks again for all of your hard work!
Andy Hamm
Boyceville Science Olympiad
Boyceville, WI
RoboMarth
Member
Member
Posts: 71
Joined: August 7th, 2014, 7:51 pm
Division: Grad
State: OH
Has thanked: 25 times
Been thanked: 32 times

Re: Unosmium Results and the SciolyFF

Post by RoboMarth »

Thanks to Andy for the kind words and everyone for submitting results.

Just wanted to let you all know that there's going to be a few days delay in getting the submitted results in as I modify the system to accommodate results that use a different scoring system compared to Nationals. (If you want to stalk my progress until then, most of the work will be occurring in this repository).
Post Reply

Return to “General Competition”

Who is online

Users browsing this forum: No registered users and 1 guest