Hi all, looking for some help with applying a formula that's based upon who all shows up. Everyone who shows up gets one point for showing up. Everyone also gets a point for each KO earned. Top ten gets points based upon where they finish in top ten and # showing as follows (side note: points shown here do not incorporate any other points awarded)
# Playing 1-19 20-29 30-39 40+
--------------------------------------------------------------------------------
1st 29 33 37 42
2nd 26 30 34 38
3rd 23 27 31 35
4th 21 24 28 31
5th 19 21 25 28
6th 17 19 22 25
7th 15 17 19 22
8th 13 15 17 19
9th 10 13 15 17
10th 7 10 13 15
Sorry for the sloppiness of the chart, not too familiar with how to chart or attach on here, but hopefully everything lines up nice for all. I know I'll probably get a switch as part of the formula, which is ok, but I don't know how to incorporate the condition of amount of players into that....
Any help is greatly appreciated! Thanks, and should be able to assist more people now that I've got internet back up and am (mostly) done with a move!