# excel to calculate golf teams by average score ?

1. ## 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. ## 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. ## Re: excel to calculate golf teams by average score ?

Originally Posted by kalak
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. ## Re: excel to calculate golf teams by average score ?

Originally Posted by mstoney
I know nothing about which u speak.
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. ## 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.

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