I’ve a spreadsheet to work out the weekly ranking points of players for the badminton tournaments.
The rule is simple with the best 10 scores over a 12 month’s period. That works reasonably well when the tournaments are on a 12 months interval and on the same week every year but failed when the organisers decided to move the dates from previous year.
From the example attached, the scores for the 12 months are in Col Q to Col DT. Col D to M work out the best 10 and sum them up in Col B.
Let say the next 2 tournaments to play are German Open 2014 and All England 2014 that will replaced the same tournaments in 2013. What if the organisers decided to play the German Open 2 weeks earlier then the German Open 2014 score needed to replace the German 2013.
Any suggestions as how to accommodate this would be much appreciated.
Bookmarks