Here is the formula; I tested it and didn't see any issues with the rest of the spreadsheet. ENJOY.
This of course as you can see goes into the GS Column of the spread sheet starting with the cell in row 3 then so on down to row 17. Once you get the GS column cells filled you can do a copy of that cell then highlight the rest of the columns in that row and paste it in. I know this season is already more then half over. so if Cedric doesn't get this in before next season, I thought I would place it out here for everyone that wants to use it.
Example of use : =IF(GS2=2,1,) basically if team 1 plays team 2 and you put the 2 in whichever week they play them, then in team 2s row a 1 is automatically filled in for that same week, this is true all the way down to row 17. That is why team16's formula is so big, it has to watch all the other rows looking for its number to be filled in.
=IF(GS2=2,1,)
=IF(GS2=3,1,(IF(GS3=3,2,)))
=IF(GS2=4,1,(IF(GS3=4,2,(IF(GS4=4,3)))))
=IF(GS2=5,1,(IF(GS3=5,2,(IF(GS4=5,3,(IF(GS5=5,4)))))))
=IF(GS2=6,1,(IF(GS3=6,2,(IF(GS4=6,3,(IF(GS5=6,4,(IF(GS6=6,5)))))))))
=IF(GS2=7,1,(IF(GS3=7,2,(IF(GS4=7,3,(IF(GS5=7,4,(IF(GS6=7,5,(IF(GS7=7,6)))))))))))
=IF(GS2=8,1,(IF(GS3=8,2,(IF(GS4=8,3,(IF(GS5=8,4,(IF(GS6=8,5,(IF(GS7=8,6,(IF(GS8=8,7)))))))))))))
=IF(GS2=9,1,(IF(GS3=9,2,(IF(GS4=9,3,(IF(GS5=9,4,(IF(GS6=9,5,(IF(GS7=9,6,(IF(GS8=9,7,(IF(GS9=9,8)))))))))))))))
=IF(GS2=10,1,(IF(GS3=10,2,(IF(GS4=10,3,(IF(GS5=10,4,(IF(GS6=10,5,(IF(GS7=10,6,(IF(GS8=10,7,(IF(GS9=10,8,(IF(GS10=10,9)))))))))))))))))
=IF(GS2=11,1,(IF(GS3=11,2,(IF(GS4=11,3,(IF(GS5=11,4,(IF(GS6=11,5,(IF(GS7=11,6,(IF(GS8=11,7,(IF(GS9=11,8,(IF(GS10=11,9,(IF(GS11=11,10)))))))))))))))))))
=IF(GS2=12,1,(IF(GS3=12,2,(IF(GS4=12,3,(IF(GS5=12,4,(IF(GS6=12,5,(IF(GS7=12,6,(IF(GS8=12,7,(IF(GS9=12,8,(IF(GS10=12,9,(IF(GS11=12,10,(IF(GS12=12,11)))))))))))))))))))))
=IF(GS2=13,1,(IF(GS3=13,2,(IF(GS4=13,3,(IF(GS5=13,4,(IF(GS6=13,5,(IF(GS7=13,6,(IF(GS8=13,7,(IF(GS9=13,8,(IF(GS10=13,9,(IF(GS11=13,10,(IF(GS12=13,11,(IF(GS13=13,12)))))))))))))))))))))))
=IF(GS2=14,1,(IF(GS3=14,2,(IF(GS4=14,3,(IF(GS5=14,4,(IF(GS6=14,5,(IF(GS7=14,6,(IF(GS8=14,7,(IF(GS9=14,8,(IF(GS10=14,9,(IF(GS11=14,10,(IF(GS12=14,11,(IF(GS13=14,12,(IF(GS14=14,13)))))))))))))))))))))))))
=IF(GS2=15,1,(IF(GS3=15,2,(IF(GS4=15,3,(IF(GS5=15,4,(IF(GS6=15,5,(IF(GS7=15,6,(IF(GS8=15,7,(IF(GS9=15,8,(IF(GS10=15,9,(IF(GS11=15,10,(IF(GS12=15,11,(IF(GS13=15,12,(IF(GS14=15,13,(IF(GS15=15,14)))))))))))))))))))))))))))
=IF(GS2=16,1,(IF(GS3=16,2,(IF(GS4=16,3,(IF(GS5=16,4,(IF(GS6=16,5,(IF(GS7=16,6,(IF(GS8=16,7,(IF(GS9=16,8,(IF(GS10=16,9,(IF(GS11=16,10,(IF(GS12=16,11,(IF(GS13=16,12,(IF(GS14=16,13,(IF(GS15=16,14,(IF(GS16=16,15)))))))))))))))))))))))))))))