# POker league points system

1. ## POker league points system

Hello guys,
Great site.

I am writing a poker league table in excel.

I want to represent finishing places as points and have them alter event by event depending on how many peeps are playing.
I found this formula which does the job perfectly but I can't make it work in excel

2x(n-p+1) Where n=number of players; p=position

10 players gives 1st place 2x(10-1+1)=20 pts where as
4 players gives 1st place 2x(4-1+1)=8 pts

As well as the points I want to display total prize money won etc (which is easliy done by a noob like me) the problem I have is making the cells work out the points when I input the total players into one cell.

Halp

2. ## Re: POker league points system

Hi,

Not quite sure if this is what you'r after, but assuming the total no. of players is in A1 and the position is in B1, then

``Please Login or Register  to view this content.``
Rgds

3. ## Re: POker league points system

Sorry, I will give you some more meat (veggie option too)

I envision:

Sheet 1
TOP ROW (by column)- date; player names (twelve players atm)
2nd row (by coloumn) date of first input; player's position in event

Sheet 2
1 column (by row) - player names; played; points

I'm not sure if this is feasible or the best but I am open to suggestions

4. ## Re: POker league points system

Hi,

Can you upload the workbook and indicate what results you want in a sample of the cells.

Rgds

5. ## Re: POker league points system

Here it is. Ignore Sheet 1.
Where can we put the formulae?

6. ## Re: POker league points system

Ahhh. and there will only ever be 10 players max. (just thinking about the function length)

7. ## Re: POker league points system

Hi,

2x(n-p+1) Where n=number of players; p=position

And for third place does that imply a score for 10 players would be
2*(10-3+1)=16

Rgds

8. ## Re: POker league points system

It does yes. Is it going to be feasible?

9. ## Re: POker league points system

Hi,

See the revised file

I've added a total score table to the right of the positions on the events sheet. Just copy the formulae in Q6:AD6 down as necessary.

HTH

10. ## Re: POker league points system

By JOve! You've done it!

I will make it look pretty and post the finished article back here for your members to use if required.

Thank you very much Richard

11. ## Re: POker league points system

Here is the latest revision with a few tweaks here and there.

I am going to try and make some sort of table for cash prizes later.
Thanks Again

EDIT: The file below is not the correct one forgot i saved Richard's version to my desktop :D. See the post after this for rev2.

12. ## Re: POker league points system

REV2 is attached

13. ## Re: POker league points system

Apologies. Would you mark this as solved please. Thanks again.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1