Results 1 to 4 of 4

Find a Backgammon Winner & runner up

Threaded View

  1. #1
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Find a Backgammon Winner & runner up

    Hi all,
    I play backgammon on a regular basis at a club which is growing rapidly. We usually have no problems working out who the winner is. But as the numbers of players are growing we run into a few problems. First off we always run out of time and never know what format to play. so I have started a workbook which allows us to determine how many teams to play and to what amount of points, it also calculates if semi finals & finals are included (Setup sheet). So next problem is once we know the correct format ( Template or Template(2) ), select the number of teams & players to display the correct format, Select the number of points to play to B5, this adds the correct drop down lists to the points table. Then select the names in column B. Then as matches completed, enter the scores in the sections below the grey section. The ones above have formulas to mirror the score for the other player.
    So for those of you who don't know how to play backgammon, on a 5 point match the winner gets the 5 points, and the loser gets however many games he/she won. so for each entry you find one of the players names, enter how many games won & lost, and the table will enter the reverse score for the opponent ie. Dave played Sean, Dave W5 L3, Sean W3 L5.
    Now that part is easy, now for the difficult part. as you can see there is 3 tables as we could have up to 30 players. We need to find a winner from each team and a runner up. They then go onto play a semi final and then a final. This could be just one team or 2 or 3 depending on number of players. I will worry about that section later.
    What I am stuck on is determining the winner & runner up for each table.
    How the winner is calculated:
    If we have 1 player who has won the maximum amount of games column Y then they are the winner.
    2nd place could be the player with the 2nd largest wins, but if there is more than one player with the same wins then the decision is made on points difference column AC, if they have the same points difference then decision made on points won column AA. But if they are the same (and it does happen) then the decision is made on the match score between those players
    ie if Sean won with 7 matches
    Dave T won 6 matches, 6 points diff, 30 points won
    Dave H won 6 matches, 6 points diff, 30 points won
    Dave T & Dave H had a draw, but their match Dave T won 5, Dave H won 3, therefore Dave T gets 2nd place

    I have spent hours trying to work out some formulas to determine the winner and runner up and have gone slightly brain dead with it all.
    I am hoping some of you guys who are far better than I with formulas can help me. I will confess I have developed more of my VBA skills than formulas, but would prefer to stick with formulas if possible.
    Macros need to be enabled as it uses functions to calculate the number of wins & losses (Column Y & Z) of course if you can find a formula for this then even better.

    I would prefer no named ranges as I will be copying the template each week to a new sheet and this will only cause problems.
    Winner can be shown either with conditional formatting, same with runner up, or in different cells. I will leave it to you to come up with the best solution you can.
    Columns AC onwards are not critical and can be changed/deleted, these were just helper columns.

    If you need anymore information let me know.

    Thanks in advance for any help.
    Attached Files Attached Files
    Regards
    Sean

    Please add to my reputation if you think i helped
    (click on the star below the post)
    Mark threads as "Solved" if you have your answer
    (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:
    [code] Your code here [code]
    Please supply a workbook containing example Data:
    It makes its easier to answer your problem & saves time!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Winner board
    By shg in forum Suggestions for Improvement
    Replies: 1
    Last Post: 01-06-2014, 12:22 PM
  2. how to return 2 winner
    By cboys00 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-03-2012, 09:36 PM
  3. [SOLVED] Find a winner
    By MADx in forum Excel General
    Replies: 5
    Last Post: 10-18-2008, 09:58 PM
  4. [SOLVED] Sharing Violation Error while opening Excel file with Win Runner
    By prabhu in forum Excel General
    Replies: 0
    Last Post: 04-20-2006, 01:55 PM
  5. I cannot get on-line, using road runner.
    By j33denise in forum Excel General
    Replies: 1
    Last Post: 01-27-2006, 11:40 PM

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