Points should be awarded to all players taking part and 1st out gets 1 pt, 2nd 2 pts etc etc. So in a 100 runner tourney winner gets 100 pts, 200 runners winner obv gets 200 pts. Players who go deep in big fields are therefore rewarded relative to field size. This is simplistic i know but eliminates the need to worry about buy ins and prize funds etc.
To level the field completely eliminating any weighing of buy in, field size etc just base the league on % of field beaten. I couldn't get the spreadsheet to work perfectly so winning doesn't always get 100 points (percent passed) but a rough working copy would give this. Runners Finish Position % Beaten By (% You Beat) Points Awarded 51 51 100 0 51 40 78 22 51 30 59 41 51 25 49 51 51 10 20 80 51 5 10 90 51 2 4 96 51 1 2 98 Runners Finish Position % Beaten By (% You Beat) Points Awarded 500 500 100 0 500 400 80 20 500 300 60 40 500 250 50 50 500 100 20 80 500 51 10 90 500 30 6 94 500 25 5 95 500 5 1 99 500 2 0 100 500 1 0 100 Simply put this is: Points Awarded = 100 - ((Finish Position / Total Runners) / 100) Posted by Machka
Comments
Aaron.
aaRob
wait a minute.
I couldn't get the spreadsheet to work perfectly so winning doesn't always get 100 points (percent passed) but a rough working copy would give this.
Points Awarded
Points Awarded
Points Awarded = 100 - ((Finish Position / Total Runners) / 100)
brilliant aaron, you are so funny.
aye, that wobbly guy... trying to be witty... he has to post at least 1,501 posts before he get's a "lol" here.
the formula contained a circular reference
PS -Aaron - I need you to try & help me with a little techie problem next door, if you don't mind. Can you contact me, please?