formula required

[macacan]

OK formula required

But first thing is, playing last night and 3 players all in, 1 was busted out with the other 2 splitting the pot.
When I busted the player out I could not split the bounty for the hit.
We have 50 pts for a hit, I adjusted the points later to 25 to each player.
Is there a way for 2 players to bust 1 player out and share the points ?.

OK the next is I need a formula if anyone can help me, I have never used formula's before.
I have always used the easy fill in boxes like setting up the prizes points and cash, points for playing and points for each hit.
This works great at the moment but next season that starts in April we want to use best 10 results from 12.

I presume you can put the formula in somewhere then still add the prizes in cash.

I have also been asked how the league table will work, the table will never be true until the last game so players can never
work out easily how they stand.

This is my points format:

Each player attending will receive 150 points.
50 points for every player you knock out.
There will be a 200 point bounty on the previous winner.

1st 1800 points
2nd 1600 points
3rd 1400 points
4th 1300 points
5th 1250 points
6th 1200 points
7th 1150 points
8th 1100 points
9th 1050 points
10th 900 points
11th 850 points
12th 800 points
13th 750 points
14th 700 points
15th 650 points
16th 600 points
17th 500 points
18th 450 points

Any help would be much appreciated.

macacan

[Corey Cooper]

You can't select 2 hitmen currently, but you will be able to in the next version.  It will split the hit and and associated bounties.  Formulas will automatically take this into account since a player's hits will become fractional (1.5, for example, for a player who busted out one other player and then took part in a another bust-out).

Your formula:

150 + if(r <= 18, 300 + (18-r) * 50) + if(r < 17, 50) + if(r < 10, 100) + switch(r, 3, 50, 2, 200, 1, 350) + (nh * 50)

[macacan]

Your a star Corey.


Might sound daft but how and where do you put the formula.

I been using TD for over 2 years but have only ever used the standard fill in sections for prizes, points, and other stuff


 

[Corey Cooper]

Settings window -> Game tab -> Points for Playing

[macacan]

Settings window -> Game tab -> Points for Playing

Cheers

So I copy and paste the formula into "points for playing", remove anything else in there.
Do I leave my prizes the same with all the points on the prizes tab ?.
What about points for hits ?, leave that aswell ?.

Then when I run stats for that league and that season it will give me best 10 results from 12.

[Corey Cooper]

If your initial description of the formula you need encompasses all points you want to award, then you should remove points awarded via other mechanisms (like the "Points for buy-in" input or the "Points for hit" input).  The formula should do it all.

If you are awarding points via prizes too, you might need to remove those points as well.  For points that are awarded via ranked prizes (prize for 1st place, for example), again, the formula should do that, so remove those points.  If you award points via a prize that is a Bounty on a particular player, the formula can't do that, so leave those points.

Your Tournament Score formula should just be:

points

Your Overall Score formula should be:

sum(top(10, scores))

[macacan]

Cheers


I will run some tests over the next few weeks.