OMG its after 6am here. lol
I could not sleep, i had to finish this.
So here it is, one big formula that will handle any tourny of any size while automatically adjusting the point system to match
how many players bought-in. lol, i think i even pee'ed a little bit when i finally got this to work. lmao.
Anyway, hope you enjoy it, or atleast use it.
One last thing. How do you want points handled if there are less than 10 players?
say only 4 are in your tourny. does first get 100 and 4 still get 60 even though he is in last?
right now, this formula will pay fewer points for games less than 10 players.
Have a look, see what you think.
if (n<11, if (r<9,(if (r<2,(n-r+1)*10,(n-r)*10)),0),
if (n<15, if (r<9,(if (r=1,140,(if (r=2, 112,(if (r=3, 98,(if (r=4, 84,(if (r=5, 70,(if (r=6, 56,(if (r=7, 42,(if (r=8, 28,0)))))))))))))),0))),
if (n<19, if (r<10,(if (r=1,180,(if (r=2, 144,(if (r=3, 126,(if (r=4, 108,(if (r=5, 90,(if (r=6, 72,(if (r=7, 54,(if (r=8, 36,(if (r=9, 18,0)))))))))))))))),0))),
if (n<23, if (r<12,(if (r=1,220,(if (r=2, 176,(if (r=3, 154,(if (r=4, 132,(if (r=5, 110,(if (r=6, 88,(if (r=7, 66,(if (r=8, 44,(if (r=9, 33,(if (r=10, 22,(if (r=11, 22,0)))))))))))))))))))),0))),
if (n<27, if (r<14,(if (r=1,260,(if (r=2, 208,(if (r=3, 182,(if (r=4, 156,(if (r=5, 130,(if (r=6, 104,(if (r=7, 78,(if (r=8, 52,(if (r=9, 44,(if (r=10, 36,(if (r=11, 30,(if (r=12, 26,(if (r=13, 26,0)))))))))))))))))))))))),0))),
if (r<16,(if (r=1,300,(if (r=2, 240,(if (r=3, 210,(if (r=4, 180,(if (r=5, 150,(if (r=6, 120,(if (r=7, 90,(if (r=8, 60,(if (r=9, 52,(if (r=10, 44,(if (r=11, 38,(if (r=12, 34,(if (r=13, 32,(if (r=14, 30,(if (r=15, 30,0)))))))))))))))))))))))))))),0))) )))))