+ Reply to Thread
Results 1 to 13 of 13

POker league points system

  1. #1
    Registered User
    Join Date
    03-18-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    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
    Last edited by Sgt.Trojan; 04-06-2009 at 04:25 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,964

    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
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-18-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    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. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,964

    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. #5
    Registered User
    Join Date
    03-18-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: POker league points system

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

  6. #6
    Registered User
    Join Date
    03-18-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: POker league points system

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

  7. #7
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,964

    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. #8
    Registered User
    Join Date
    03-18-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: POker league points system

    It does yes. Is it going to be feasible?

  9. #9
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,964

    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
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    03-18-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Thumbs up 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. #11
    Registered User
    Join Date
    03-18-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    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.
    Attached Files Attached Files
    Last edited by Sgt.Trojan; 03-20-2009 at 06:04 PM. Reason: Incorrect file attached

  12. #12
    Registered User
    Join Date
    03-18-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: POker league points system

    REV2 is attached
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    03-18-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: POker league points system

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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