Spreadsheet: 63525d1264438101-league-spreadsheet-copy-of-ccfsa_2010_league_2010_jan_18
Sheet: Schedule

Schedule
 |  |  |  |  |  |  |  | On the setup Sheet, specify how many pairings happen each week
week | team no | team name | vs | team no | team name |  |  | E.g. 20 teams per week would be 10 pairings
2 | 12 | Twisted_Up |  | 1 | McNellys_Rangers |  |  | Then, create that many lines per week
2 | 11 | Rut_Necks |  | 2 | Spot_Smokers |  |  | and enter the team numbers in the yellow cells
2 | 3 | Killer_Vs |  | 10 | Fletched_Tite |  |  | leave no blank lines.
2 | 9 | Spots_with_Speed |  | 4 | Passing_Time |  |  | use formatting to separate weeks by color
2 | 5 | Lucky_Stables |  | 8 | Out_of_Towners
2 | 7 | RDs_Whitetails |  | 6 | Wise_Guys |  |  | The purple cells have formulas and must be copied down
3 | 2 | Spot_Smokers |  | 12 | Twisted_Up
3 | 1 | McNellys_Rangers |  | 3 | Killer_Vs |  |  | There should always be the same number of pairings per week
3 | 4 | Passing_Time |  | 11 | Rut_Necks
3 | 10 | Fletched_Tite |  | 5 | Lucky_Stables |  |  | The number of pairings per week must be the same as the number
3 | 6 | Wise_Guys |  | 9 | Spots_with_Speed |  |  | entered on the Setup Sheet.
3 | 8 | Out_of_Towners |  | 7 | RDs_Whitetails
4 | 12 | Twisted_Up |  | 3 | Killer_Vs |  |  | color key
4 | 2 | Spot_Smokers |  | 4 | Passing_Time |  |  | data entry
4 | 5 | Lucky_Stables |  | 1 | McNellys_Rangers |  |  | calculated
4 | 11 | Rut_Necks |  | 6 | Wise_Guys
4 | 7 | RDs_Whitetails |  | 10 | Fletched_Tite
4 | 9 | Spots_with_Speed |  | 8 | Out_of_Towners
5 | 4 | Passing_Time |  | 12 | Twisted_Up
5 | 3 | Killer_Vs |  | 5 | Lucky_Stables
5 | 6 | Wise_Guys |  | 2 | Spot_Smokers
5 | 1 | McNellys_Rangers |  | 7 | RDs_Whitetails
5 | 8 | Out_of_Towners |  | 11 | Rut_Necks
5 | 10 | Fletched_Tite |  | 9 | Spots_with_Speed
6 | 12 | Twisted_Up |  | 5 | Lucky_Stables
6 | 4 | Passing_Time |  | 6 | Wise_Guys
6 | 7 | RDs_Whitetails |  | 3 | Killer_Vs
6 | 2 | Spot_Smokers |  | 8 | Out_of_Towners
6 | 9 | Spots_with_Speed |  | 1 | McNellys_Rangers
6 | 11 | Rut_Necks |  | 10 | Fletched_Tite
7 | 6 | Wise_Guys |  | 12 | Twisted_Up
7 | 5 | Lucky_Stables |  | 7 | RDs_Whitetails
7 | 8 | Out_of_Towners |  | 4 | Passing_Time
7 | 3 | Killer_Vs |  | 9 | Spots_with_Speed
7 | 10 | Fletched_Tite |  | 2 | Spot_Smokers
7 | 1 | McNellys_Rangers |  | 11 | Rut_Necks
8 | 12 | Twisted_Up |  | 7 | RDs_Whitetails
8 | 6 | Wise_Guys |  | 8 | Out_of_Towners
8 | 9 | Spots_with_Speed |  | 5 | Lucky_Stables
8 | 4 | Passing_Time |  | 10 | Fletched_Tite
8 | 11 | Rut_Necks |  | 3 | Killer_Vs
8 | 2 | Spot_Smokers |  | 1 | McNellys_Rangers
9 | 8 | Out_of_Towners |  | 12 | Twisted_Up
9 | 7 | RDs_Whitetails |  | 9 | Spots_with_Speed
9 | 10 | Fletched_Tite |  | 6 | Wise_Guys
9 | 5 | Lucky_Stables |  | 11 | Rut_Necks
9 | 1 | McNellys_Rangers |  | 4 | Passing_Time
9 | 3 | Killer_Vs |  | 2 | Spot_Smokers
10 | 12 | Twisted_Up |  | 9 | Spots_with_Speed
10 | 8 | Out_of_Towners |  | 10 | Fletched_Tite
10 | 11 | Rut_Necks |  | 7 | RDs_Whitetails
10 | 6 | Wise_Guys |  | 1 | McNellys_Rangers
10 | 2 | Spot_Smokers |  | 5 | Lucky_Stables
10 | 4 | Passing_Time |  | 3 | Killer_Vs
11 | 10 | Fletched_Tite |  | 12 | Twisted_Up
11 | 9 | Spots_with_Speed |  | 11 | Rut_Necks
11 | 1 | McNellys_Rangers |  | 8 | Out_of_Towners
11 | 7 | RDs_Whitetails |  | 2 | Spot_Smokers
11 | 3 | Killer_Vs |  | 6 | Wise_Guys
11 | 5 | Lucky_Stables |  | 4 | Passing_Time