FF Schedule Disaster, Assistance is Much Appreciated!!!

[chalorpas]

Hi, I am completely new to the forum and am not great at excel. After changing the amount of regular season weeks in my fantasy football league, the entire remaining schedule has been changed with lots of repeat matchups. I called ESPN to try to fix it but they couldn't. I have the ability to edit any of the remaining matchups myself and would like to randomly create this schedule while keeping the existing schedule (5 weeks worth) intact and making it so each team plays another team exactly one time. I have been trying to create a formula to do this but I am nowhere near skilled enough. Is this even possible to do??? Can anyone help?

Here is the table with the matchups that have already occurred. For example, Team A played Team C in week 1. If I need to provide any other information please ask.

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

C

D

A

B

L

G

F

M

J

I

N

E

H

K

2

N

M

L

J

G

H

E

F

K

D

I

C

B

A

3

I

J

G

K

H

M

C

E

A

B

D

N

F

L

4

D

K

H

A

M

J

L

C

N

F

B

G

E

I

5

B

A

M

N

F

E

I

L

G

K

J

H

C

D

6

7

8

9

10

11

12

13

14

<tbody>
</tbody>

Thanks!!!!!!!

 

[ztodd]

Each team can play each other team only one time? oh, duh- sorry- you answer that- I read it too fast.

 

[chalorpas]

Each team can play each other team only one time? oh, duh- sorry- you answer that- I read it too fast.

Yeah do you think it is possible? It seems like there could only be a few solutions maybe, I don't know.

 

[ztodd]

I was thinking it would be pretty easy, but 'tis not as easy as i thought. It's kind of like a sudoku puzzle- might need like a sudoku puzzle solver type of algorithm...

 

[chalorpas]

I was thinking it would be pretty easy, but 'tis not as easy as i thought. It's kind of like a sudoku puzzle- might need like a sudoku puzzle solver type of algorithm...

Hm, I looked around a bit but it seems like most sudoku solvers are in sudoku format (3x3 or 4x3). Couldn't find a highly customizable one. Thanks for trying to figure it out.

 

[ztodd]

This might do it if you wanted to download their free trial-

Large Sudoku Puzzles 16x16

 

[ztodd]

This is a fun problem I'll keep working on. After filling in sudoku strategy markings, it looks like there are 9 values each column could still possibly hold on each new row, and 9 places each letter could possibly go in each row, so 9! (nine factorial- in other words, 9x8x7x6x5x4x3x2x1) is probably a good estimate of how many total possible combinations there could be, before eliminating for values existing in the column already. It's probly not exact since it's not quite a 9 x 9 grid that's left, but close enough- so maybe I can find a random # from 1 to 9!, call it n, then somehow find the n'th possible combination, then keep looping through combinations from there until I find a combo that is completely valid.