There was some discussion years back about a virtual national chmpionship for SCM season which never really took off...some suggested pulling ftom the Top 10 list for this rather than the regional meets.
So here's a question, has anyone ever "scored" SCY or LCM based on Top 10? Now that we have a new scoring system in place it would be interesting to see what the results would be...and might draw a few more teams to rally swimmers to attend if they saw how well they placed.
How about a proportional virtual championship?
Score the LMSC (as before) and divide by the reported membership.
Gives smaller LMSCs a chance to get some credit.
And the same could be done with clubs.
------- secondly,
Kudos to Chris S and his heroic excel efforts (must have been a ton of countif statements) - BUT - how hard would it be for the National Office and Top Ten/competition group to do this work?
They have the data! And furthermore - it's clean and ready for other analyses - Pool All Stars for example - or SCY/LCM/SCM high point, etc.
Writing software should not be a huge task. The national office could ask for volunteer software developers (maybe even sponsor a contest) or put it out to bid. Once the program is written, it should not be too hard to maintain (esp. with clubs and LMSCs table data apart from the TT data).
How about a proportional virtual championship?
Score the LMSC (as before) and divide by the reported membership.
Gives smaller LMSCs a chance to get some credit.
And the same could be done with clubs.
------- secondly,
Kudos to Chris S and his heroic excel efforts (must have been a ton of countif statements) - BUT - how hard would it be for the National Office and Top Ten/competition group to do this work?
They have the data! And furthermore - it's clean and ready for other analyses - Pool All Stars for example - or SCY/LCM/SCM high point, etc.
Writing software should not be a huge task. The national office could ask for volunteer software developers (maybe even sponsor a contest) or put it out to bid. Once the program is written, it should not be too hard to maintain (esp. with clubs and LMSCs table data apart from the TT data).
