I am a sportswriter and I am making a ratings system for area high school teams....I've got everything set up in my spreadsheet except this - in my ratings system teams are ranked upon their score in the ratings formula, lower being better, but if a team who has beaten the second team in head to head competition and is rated behind the second team by x (i haven't decided yet) or less number of points, the first team will "leapfrog" the second team in the rankings (but not in the ratings). Later in the season the first tema may fall too far behind the second team to qualify for the "leapfrog".
Ex. Wilcox Central beats Thomasville, but is still behingd in the ratings, but only by 5, low enough to qualify for the leapfrog. So Wilcox Central will jump to one spot ahead of Thomasville in the rankings. Later after Wilcox Central loses to Dallas County, they fall behind Thomasville by 15, too much to qualify for leapfrog, so the rankings stay the same. Make Sense??
Will someone please help me??