Hello,
I'm running a chess club at my university, and I have created an excel sheet that lists ranks according to what games have been played, and who has won. I have attached the excel file, and I will try to clearly explain my dilemma.
I can highlight a single name, cut it, then right cick choosing "insert cut" and it will bump names accordingly. What I have to do manually, is calculate the rank change that results from a win/loss. I would like to be able to enter in who won/lost on sheet#1, and have excel automatically rearrage by cuting and pasting the name where it should be located on sheet#2. Also, I would like to have the win ratio per person updated on the bottom half of sheet #2. I suspect this can be done using visual basics, but I am not experienced with it.
the basic formula of the system, is that is player #10 wins against player #2, he will drop half the distance to become #6. So basically, "rank - (10-2)/2". In the case of an odd number, the rank would round up to the nearest even number for calculation purposes.
Example, if 10 beats 2, then the equation would be 10-(10-2)/2, resulting in rank #6.
If 10 beats 1, then the equation would be 10-(10-2)/2, resulting in 6. 10-(10-1)/2 is 5.5, which does not work.
Someone ranked higher, who loses to someone lower will decrease by 1 rank.
If someone lower loses to a higher player, no change is made to ranks.
If someone is willing to help me, I can provide more clarification. I would also be open to new ideas. Thank you,
Jake
Bookmarks