I have set up a badminton results program for our school division which shows all round robin results, calculates the number of wins and then ranks the players based on the number of wins.
The problem I am having is that when two or more players have the same number of wins they all get ranked with the same number. At the end of the round robin these tied ranks have to be broken.
If only two teams are tied, then the whichever team beat the other in the round robin gets the higher rank. If three or more teams are tied, the team with the most wins between the tied group will get the highest rank. If the teams have the same number of wins, then we rank based on +/- scores. ie. If a team scored 28 points and give up 35 points, the team would get a +/- rating of -7.
I have read a number of postings on breaking ties, but many reference that in order to break the tie you must compare a second column in your spreadsheet. In my situation I am not sure how to do this.
The problem I am having is that when two or more players have the same number of wins they all get ranked with the same number. At the end of the round robin these tied ranks have to be broken.
If only two teams are tied, then the whichever team beat the other in the round robin gets the higher rank. If three or more teams are tied, the team with the most wins between the tied group will get the highest rank. If the teams have the same number of wins, then we rank based on +/- scores. ie. If a team scored 28 points and give up 35 points, the team would get a +/- rating of -7.
I have read a number of postings on breaking ties, but many reference that in order to break the tie you must compare a second column in your spreadsheet. In my situation I am not sure how to do this.
