Those explanations were perfect, and I was able to identify the issues and make the fixes in the automated scoring.
Quote:
Originally Posted by tindleroot
The gaps of missing data that I'm referring to are missing points for mostly district teams (regionals are almost perfect except for a few instances of missed qualification win points). In the "Raw Picks" tab, Column J (District Points) are shown as 0 for all CHS teams except 1262 and 1610. This problem maintains over all of the districts. Some teams also have ranking points missing from one of their two events, such that they are awarded approximately half points for ranking.
|
For this one, I found an issue in how the district points calculation was being done. Long story short, the calculation was being done at the district level and not the event level, which lead to issues throughout the sheet.
I have made the appropriate fixes to make sure that the district points are being calculated at the event level and then are being rolled up to the district level.
Quote:
Originally Posted by tindleroot
Looking further, it appears that many district teams are also missing points for robot awards and high scores. 1024 won two robot awards this year and also had the high score at all three of their district points, so if I'm reading the chart correctly their column K on the raw picks sheet should have 45 points but instead has 0.
|
The issue is that the district system started handing out awards for teams that had qualified for states, but we were not recognizing that award. This ultimately threw and error and caused the teams' scores to go to 0.
Unfortunately, when new awards flow into the system, they're going to cause some havoc until we go in and assign points for them.
In this case, I have given this "award" 0 points, and the issue should now be fixed.
Quote:
Originally Posted by tindleroot
That's the best help I can give at identifying the problem. I am really happy that you guys made the system to simplify scoring throughout the season, and I will keep checking it against First Pick's scores (calculated manually by me) to make sure all points are being awarded properly.
|
I appreciate you keeping track of your score to help keep the automated system honest, and I appreciate everyone's help in ironing out issues in the system.
Let me know if there are any other concerns,
- Sunny G.