Our Tuesday golf group is trying to set up a spreadsheet to keep up with our match, calculate how many points someone has to pull the next week and who wins the money by way of percentages.
If Ray has to pull 28 points
Wayne has to pull 16
Edd has to pull 19
LYNN 28
MOE 22
CHRIS 22
JIM 28
HARRY 23
PETE 28
KYLE 9
STEVE 22
If anybody pulls 2 or 3 points over what they are required to pull they get one point added on the next week. If they pull 4,5,6,7 points over their required amount they have to pull 2 points more the next week and if they pull 8 points or more they would have to pull 3 points more the next week.
The same is on the negative side, if they pull 2 or 3 points less than they were required to pull, they would have to pull one less the next week etc.
Also, the percentages of winning that week that needs to be calculated would be
if we have 6 or less players we would divide the pot by these percentages for first second and third places. 50 30 20
7 or more players 40 30 20 10
I have no idea how to set this up, can anybody help me?
Bookmarks