Unosmium Results and the SciolyFF

[Havocgamer49]

Ok, so here are the Asheville Regionals for Division C, can someone look through it and see if I did anything wrong?

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

[BennyTheJett]

Looks great! Quick question: Did you mean "Henderson Early Collage" on the teams?

[Tailsfan101]

Ok, so here are the Asheville Regionals for Division C, can someone look through it and see if I did anything wrong?

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

A few notes:
-The correct location is "University of North Carolina - Asheville".
-Sort the teams by team number (which, in this case, is alphabetical). Do not separate the JV teams from the varsity teams in numbering. For example, West Henderson High School is teams 18 and 19.
-Henderson County Early College is misspelled (as BennyTheJett said)
-School abbreviations are only needed for schools that exceed the length of Column 3B, and RoboMarth's SciolyFF automatically abbreviates common suffixes, i.e. M.S., H.S.
-You don't have to list the city for teams unless there are multiple teams in the same state with the same name (e.g. St. Mark Catholic School, NC). Also, not all those teams are from the city of Asheville.
-The subdivisions are not necessary, as the JV teams can merely be listed as exhibition.
-For the NC regionals, use the second page of results for JV teams (the combined rankings in which JV scores affect varsity scores). Your varsity rankings are correct.

Thanks for doing this! Every contribution makes a difference.

[Havocgamer49]

Looks great! Quick question: Did you mean "Henderson Early Collage" on the teams?

Indeed I did.....

Ok, so here are the Asheville Regionals for Division C, can someone look through it and see if I did anything wrong?

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

A few notes:
-The correct location is "University of North Carolina - Asheville".
-Sort the teams by team number (which, in this case, is alphabetical). Do not separate the JV teams from the varsity teams in numbering. For example, West Henderson High School is teams 18 and 19.
-Henderson County Early College is misspelled (as BennyTheJett said)
-School abbreviations are only needed for schools that exceed the length of Column 3B, and RoboMarth's SciolyFF automatically abbreviates common suffixes, i.e. M.S., H.S.
-You don't have to list the city for teams unless there are multiple teams in the same state with the same name (e.g. St. Mark Catholic School, NC). Also, not all those teams are from the city of Asheville.
-The subdivisions are not necessary, as the JV teams can merely be listed as exhibition.
-For the NC regionals, use the second page of results for JV teams (the combined rankings in which JV scores affect varsity scores). Your varsity rankings are correct.

Thanks for doing this! Every contribution makes a difference.

I still do not understand how to use a second page of results, should I duplicate the rankings page and have a new one for only JV teams? If you could explain that to me in a bit more detail that would help a lot.

Thanks for the tips, I will be sure to use them.

[onoga17]

I am currently working on results for the UC Davis(Aggie) invitational and have run into a potential problem. There were originally 45 teams set to attend the tournament, but 2 didn't show up, thus the numbering system got slightly messed up so that there is still a team 45 for example, but 17 and 34 are missing.

I was wondering if there would be any issue if I inputed "ns" for the no show team scores since these show up correctly as a 44 in the original scoresheet when they would be a 46 if the system assumed a 45 team tournament. I'm using the google spreadsheet so I don't think there's a way I can really check this myself. Thoughts?

[Giantpants]

I am currently working on results for the UC Davis(Aggie) invitational and have run into a potential problem. There were originally 45 teams set to attend the tournament, but 2 didn't show up, thus the numbering system got slightly messed up so that there is still a team 45 for example, but 17 and 34 are missing.

I was wondering if there would be any issue if I inputed "ns" for the no show team scores since these show up correctly as a 44 in the original scoresheet when they would be a 46 if the system assumed a 45 team tournament. I'm using the google spreadsheet so I don't think there's a way I can really check this myself. Thoughts?

I believe that as long as there are only 43 teams listed, it should make NS the proper value of 44. It bases the value of NS, PP, etc. on the number of teams listed, not the final team number. Just make sure that you only have 43 teams listed!

Sometimes teams don’t come and their names and presence is still recorded. For example, here, at Cornell 2020, https://unosmium.org/results/2019-11-23 ... tational_c, East Brunswick got a NS in every event, but their team number was still counted, so the value of NS was still 48 even though there were technically only 46 participating teams. If it was like this, it should still be included in the sheet, but if a team is straight up absent and NS’s value is 44, then just make sure you have 43 teams listed, and you’ll be good.

[Tailsfan101]

Looks great! Quick question: Did you mean "Henderson Early Collage" on the teams?

Indeed I did.....

Ok, so here are the Asheville Regionals for Division C, can someone look through it and see if I did anything wrong?

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

A few notes:
-The correct location is "University of North Carolina - Asheville".
-Sort the teams by team number (which, in this case, is alphabetical). Do not separate the JV teams from the varsity teams in numbering. For example, West Henderson High School is teams 18 and 19.
-Henderson County Early College is misspelled (as BennyTheJett said)
-School abbreviations are only needed for schools that exceed the length of Column 3B, and RoboMarth's SciolyFF automatically abbreviates common suffixes, i.e. M.S., H.S.
-You don't have to list the city for teams unless there are multiple teams in the same state with the same name (e.g. St. Mark Catholic School, NC). Also, not all those teams are from the city of Asheville.
-The subdivisions are not necessary, as the JV teams can merely be listed as exhibition.
-For the NC regionals, use the second page of results for JV teams (the combined rankings in which JV scores affect varsity scores). Your varsity rankings are correct.

Thanks for doing this! Every contribution makes a difference.

I still do not understand how to use a second page of results, should I duplicate the rankings page and have a new one for only JV teams? If you could explain that to me in a bit more detail that would help a lot.

Thanks for the tips, I will be sure to use them.

This is really only applicable to North Carolina tournaments, but if you look at the results from sciencenc.com, you will first see a spreadsheet labeled as "Separate". If you scroll down past that spreadsheet, you should see another results sheet labeled "Combined". This is the one you should use for the JV teams. I hope that makes sense!

[Havocgamer49]

Looks great! Quick question: Did you mean "Henderson Early Collage" on the teams?

Indeed I did.....

A few notes:
-The correct location is "University of North Carolina - Asheville".
-Sort the teams by team number (which, in this case, is alphabetical). Do not separate the JV teams from the varsity teams in numbering. For example, West Henderson High School is teams 18 and 19.
-Henderson County Early College is misspelled (as BennyTheJett said)
-School abbreviations are only needed for schools that exceed the length of Column 3B, and RoboMarth's SciolyFF automatically abbreviates common suffixes, i.e. M.S., H.S.
-You don't have to list the city for teams unless there are multiple teams in the same state with the same name (e.g. St. Mark Catholic School, NC). Also, not all those teams are from the city of Asheville.
-The subdivisions are not necessary, as the JV teams can merely be listed as exhibition.
-For the NC regionals, use the second page of results for JV teams (the combined rankings in which JV scores affect varsity scores). Your varsity rankings are correct.

Thanks for doing this! Every contribution makes a difference.

I still do not understand how to use a second page of results, should I duplicate the rankings page and have a new one for only JV teams? If you could explain that to me in a bit more detail that would help a lot.

Thanks for the tips, I will be sure to use them.

This is really only applicable to North Carolina tournaments, but if you look at the results from sciencenc.com, you will first see a spreadsheet labeled as "Separate". If you scroll down past that spreadsheet, you should see another results sheet labeled "Combined". This is the one you should use for the JV teams. I hope that makes sense!

Should I change the rankings of the Varsity teams according to the second spreadsheet.

Ex: John H.S. Varsity got a 9th in Anatomy out of the Varsity teams, but a 12th if we are counting the JV teams, should the value that goes in the spreadsheet be 9 or 12?

[RoboMarth]

12

[onoga17]

I compiled the results from the UC Davis (Aggie) Invitaional here: https://docs.google.com/spreadsheets/d/ ... sp=sharing

Please let me know about any potential issues.