In a sports ladder (just a list of players, not a league, nor tournament) a player (the challenger) can challenge another (the opponent) who is up to three places above them. If they win, they move above that player. Which could be one, two or three places above depending on the pre match positions.
The outcome will be either win/loss -no draw.
I suspect that a points based solution will not work, but rather a solution that moves names above others in a ranking, based on outcome. Any thoughts would be very welcome as I've drawn a blank on this.
(I've attached the spreadsheet)
Thanks,
James
Bookmarks