Move up Formula

What this spreadsheet does: The formula takes all the moto's finished and averages them to create an average moto score. Any moto's not started should not count as they will artificially alter the average score. After the average is created there is a "modifier" which takes into account the number of entries and adds a small percentage to the race with a low number of entries. The reason for this is: a better average moto finish in a race with a larger turnout is "worth" more than a race with a smaller turnout...this modifier therefore will add a slight amount to the average of the race with less entries. The last part of the formula decides at what average moto score should a rider be moved up. The object of racing is to create a competitive group of entries to make the race a "battle". If a rider is dominating his class then the rest of the entries are not competitive. After discussing this briefly in our Washington meeting a score average for a riders whole season better than 2 is the number threshold where a rider could be considered dominating. So in the formula I put the score of 2.2 in as the threshold. Of course this can be changed to whatever the majority thought was a proper amount...I just wanted to state the reason for using that number. Obviously a score of 1 would be an example of winning every moto.

Move Down Formula

What this spreadsheet does: The move down spreadsheet is a variant of the same thing. Instead of using a average moto score it is based on a percentage of the number of entries. Many riders as they age naturally lose speed and their "competitiveness". As I can see it there is no reliable way being used in the events to address this accurately. What this formula does is create a percentage score for all the moto's entered by a specific rider by their finishing position.
Example: If a race has 10 entries and a rider finished 9th in each moto their score from that race would be 90%. I set the threshold for move down at 89.9%...therefore if a rider averaged 9 of 10 or 10 of 10 during the entire season then they are in a class where they are not competitive and should be moved down...this would, of course, be by the riders approval...some may not wish to be moved down. This would also take into account diminished performance do to age or injuries. I hope you find these helpful.

      Russ Roberts
      25505 18th Ave S.
      Des Moines, WA. 98198
      (253) 946-2430