[tindleroot]

Originally Posted by ttldomination

Just a couple of questions so that I can better understand the issues here:

1) When you say "gaps of missing data", what exactly are you referring to?

2) Can you provide an example of picks that are missing awards and eliminations information at events? This'll help me chase down the issues much quicker.

Thanks,
- Sunny G.

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.

Without much more knowledge than educated guesses about how, when, and where you pull data and parse through it, I can't really help trace back the problem, but to me it looks like random teams are missing random points, and these missing points are traced to the ranking points in almost every case.

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.

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.