20 Man, 15 Week Schedule Help

I'm trying to create what should I think be a simple schedule for an upcoming golf league. The schedule should be accomplishing the following:

There are 20 players over a 15 week season.
Each week, you are partnered with someone different.
There should be no duplicate 2 man pairings.

Its' ok if your in the same foursome with someone twice. But you should only ever be partnered with the same person once.

Attached is what I was trying to put together, but I can't quite get the schedule/logic correct.

Any help is appreciated.

Thanks

C5 =VLOOKUP(MOD($A5+C$4,$A$3),$T$5:$U$24,2)
down and to the rigth

Thanks, but your hitting the same issue I was trying to work it out.

In your sample, for example.

Players 1 and 16 will be paired up twice in weeks 15 and 5. Similar players 2 and 17 in those same 2 weeks.

You will also see players 15 and 20 also playing twice together in weeks 5 and 15.

There is likely more duplicates but that's what I see quickly.

I think its just the logic that is off or can it not be done?

20 players, 15 weeks. I would think each person should have 6 people they are never partnered with?

Ok,

So I thought I had this correct, but I actually do have duplicates being created. I don't think the issue is within the actual grid setting each person's partner for the week. That will give each person 1 of the 20 players only once.

And I think the issue is in trying to determine the right number of group pairings to avoid a duplicate.

In the attached you can see what I mean and I have highlighted the 5 duplicates that I seeming, although their could be more I'm not seeing.

i would go to this simple way, but i am not sure if it is meet your requirement or not?

Success!!

I learned how to do it. 20 Man, 15 week, with no duplicate pairings. The trick was to set up a 20x20 grid, and then really only use half it to set the pairings. I then just needed to modify the actual tee times to try and balance them so the same person is not alway's teeing off last.

@MarvinP Thanks also for sharing your file. I haven't look to hard at it yet, but I think that should help in setting up and monitoring the handicaps as well. We plan to update our's every 4 weeks in this league.

I attached how I did the pairings a well if it helps, and when its colored coded it starts to make sense how it goes.