- Joined
- Jan 18, 2018
- Messages
- 1
- Reaction score
- 0
Hi
I currently play for a local snooker league. We are looking to handicap people so have come up with a simple formula that all players start on 0 and if they lose the get 2 points added to there handicap and if they win they get 2 points taken away. I just need a simple formula to put in the spredsheet were each week i put in "L" or "W" and it calculates the running handicap. So for exaple if after four week a player has lost all four matches they will be on a handicap of "8" if they won all four they will be on "-8". Hope this makes sense. Can anyone help.
CIA
I currently play for a local snooker league. We are looking to handicap people so have come up with a simple formula that all players start on 0 and if they lose the get 2 points added to there handicap and if they win they get 2 points taken away. I just need a simple formula to put in the spredsheet were each week i put in "L" or "W" and it calculates the running handicap. So for exaple if after four week a player has lost all four matches they will be on a handicap of "8" if they won all four they will be on "-8". Hope this makes sense. Can anyone help.
CIA