Player of the Year Point Formula

[Bishop7734]

Love the product and the forum!  I need some help with a formula and I don't know where to start.  We have a monthly tournament were the players run from 9 - 25 a game.  What I am looking for is something similar to the POY point system by Card Player.
 

• You get points for finishing in first place receives 120 points; second place, 100; third place, 80; fourth place, 60; fifth place, 50; sixth place, 40; seventh place, 30; eighth place, 20; ninth place, 10.
• This is multiplied by number of players 9 players receives 5 points, 10-18 players receives 10 points, 19-24 players receives 15 points and 25 players receive 20 points.
• Multiplied by the buy-in
• Plus points for knockouts.

Please help!

Thank you

[Corey Cooper]

Points for ranking 1st through 9th:

max(0, (10-r) * 10) + max(0, (4-r) * 10)

points for size of tournament:

((1 + if(n > 9, 1) + if(n > 18, 1) + if(n > 24, 1)) * 5)

sum of the previous two multiplied by the buy-in cost:

(...) * bc

add number of hits:

((...) * bc) + nh

Gives:

(max(0, (10-r) * 10) + max(0, (4-r) * 10) + ((1 + if(n > 9, 1) + if(n > 18, 1) + if(n > 24, 1)) * 5)) * bc + nh