+ Reply to Thread
Results 1 to 5 of 5

excel to calculate golf teams by average score ?

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    excel to calculate golf teams by average score ?

    Let me start this by saying I know nothing about excel. 62 yrs. old barely turn a computer on. Now that you know where I'm coming from, here's my question. Can excel be programmed to do this, take as many as 48 individual golf scores, assign scores into 4 man groups (2-12 teams) with the team total scores as close to equal as possible (know they won't be equal but as close as possible) example: 70,77,82,72,99,100,76,88 - 99+88+76+70=333 100+82+77+72=331 (as equal as possible). Can excel do this?

  2. #2
    Valued Forum Contributor
    Join Date
    03-21-2013
    Location
    cyberia
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: excel to calculate golf teams by average score ?

    With 48 scores that would make an interesting problem to approach analytically to get the overall best combinations.

    Maybe it's easier than my initial impression, but I'd need to think about that a bit more.

    In the meantime, and given the essentially practical nature of your problem, you could try a Monte Carlo (aka trial and error) approach with your computer doing the donkey work.

    Do you know how to run a VBA macro in Excel? There's plenty of info from Google, Excel forums etc. on how to do this, and it's actually very easy.

    Put your 8, or 48, or whatever multiple of 4, golf scores down Column A, without any gaps, and without any header.

    Run the following VBA macro, first on the 8 scores that you posted and then on a larger set.

    It should give you something like you want. Can be made more accurate by increasing the number of trials, but consequently also the time taken.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: excel to calculate golf teams by average score ?

    Quote Originally Posted by kalak View Post
    With 48 scores that would make an interesting problem to approach analytically to get the overall best combinations.

    Maybe it's easier than my initial impression, but I'd need to think about that a bit more.

    In the meantime, and given the essentially practical nature of your problem, you could try a Monte Carlo (aka trial and error) approach with your computer doing the donkey work.

    Do you know how to run a VBA macro in Excel? There's plenty of info from Google, Excel forums etc. on how to do this, and it's actually very easy.

    Put your 8, or 48, or whatever multiple of 4, golf scores down Column A, without any gaps, and without any header.

    Run the following VBA macro, first on the 8 scores that you posted and then on a larger set.

    It should give you something like you want. Can be made more accurate by increasing the number of trials, but consequently also the time taken.
    Please Login or Register  to view this content.
    I know nothing about which u speak.

  4. #4
    Valued Forum Contributor
    Join Date
    03-21-2013
    Location
    cyberia
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: excel to calculate golf teams by average score ?

    Quote Originally Posted by mstoney View Post
    I know nothing about which u speak.
    Try Google!
    Excel Help!

    Plenty of good books around.

    I only aimed to address the problem you posted. But not feasible to give general Excel instruction.

  5. #5
    Valued Forum Contributor
    Join Date
    03-21-2013
    Location
    cyberia
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: excel to calculate golf teams by average score ?

    Here's a sample Excel file of what I think your situation is.

    Golf scores are down column A. There's 20 there already. Just click the button to see what happens.

    You can clear column A and put in as many scores as you like, so long as they are 8 or 12 or 16, etc. i.e. multiples of 4.
    Attached Files Attached Files

+ 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