Spreadsheet: 62706d1263610617-league-spreadsheet-ccfsa_2010_league
Sheet: Preview

Week | 3 |  | preview |  |  |  |  | data entry | enter week number in B1
[NAME] | 12 |  |  |  |  |  |  |  | set up pairing blocks for each pairing and enter the pairing number in the pink cell
number of pairings |  | 6 |  |  |  |  |  |  | all else is calculated.
team # | team name | rank in team | team members | Avg score | [NAME] | Spot | VS | team # | team name | rank in team | team members | Avg score | [NAME] | Spot
Pairing # | 1
2 | Spot_Smokers | 1 | [NAME] | 300 | 51.5 | 0 |  | 12 | Twisted_Up | 1 | [NAME] | 297.5 | 41 | 2
 |  | 2 | [NAME] | 299.5 | 51.5 | 0 |  |  |  | 2 | [NAME] | 294.5 | 31 | 4
 |  | 3 | [NAME] | 285.5 | 24.5 | 0 |  |  |  | 3 | Palmer Addison | 271.5 | 14.5 | 11.2
Pairing # | 2
1 | McNellys_Rangers | 1 | [NAME] | 300 | 53 | 0 |  | 3 | Killer_Vs | 1 | [NAME] | 294 | 26 | 4.800000000000001
 |  | 2 | [NAME] | 300 | 47 | 0 |  |  |  | 2 | [NAME] | 290.5 | 33 | 7.600000000000001
 |  | 3 | [NAME] | 300 | 54 | 0 |  |  |  | 3 | [NAME] | 283 | 17.5 | 13.6
Pairing # | 3
4 | Passing_Time | 1 | [NAME] | 299.5 | 50.5 | 0.4 |  | 11 | Rut_Necks | 1 | [NAME] | 300 | 60 | 0
 |  | 2 | [NAME] | 299.5 | 51.5 | 0 |  |  |  | 2 | [NAME] | 295 | 17 | 3.6
 |  | 3 | [NAME] | 299 | 43 | 0 |  |  |  | 3 | [NAME] | 258 | 4.5 | 32.8
Pairing # | 4
10 | Fletched_Tite | 1 | [NAME] | 300 | 56 | 0 |  | 5 | Lucky_Stables | 1 | [NAME] | 295 | 36 | 4
 |  | 2 | [NAME] | 280 | 26 | 0 |  |  |  | 2 | [NAME] | 260 | 11 | 16
 |  | 3 | Don French | 230 | 12 | 0 |  |  |  | 3 | Heather Ellis | 220.5 | 7 | 7.600000000000001
Pairing # | 5
6 | Wise_Guys | 1 | [NAME] | 285.5 | 28.5 | 0 |  | 9 | Spots_with_Speed | 1 | [NAME] | 285 | 21.5 | 0.4
 |  | 2 | [NAME] | 270 | 18.5 | 0 |  |  |  | 2 | [NAME] | 262 | 15 | 6.4
 |  | 3 | [NAME] | 264.5 | 12 | 0 |  |  |  | 3 | [NAME] | 220.5 | 8 | 35.2
Pairing # | 6
8 | Out_of_Towners | 1 | [NAME] | 300 | 51 | 0 |  | 7 | RDs_Whitetails | 1 | [NAME] | 299.5 | 48.5 | 0.4
 |  | 2 | [NAME] | 300 | 46 | 0 |  |  |  | 2 | [NAME] | 299 | 48.5 | 0.8
 |  | 3 | [NAME] | 300 | 1 | 0 |  |  |  | 3 | [NAME] | 257.5 | 11.5 | 34
 | Standings |  |  |  |  |  |  |  |  |  |  |  |  |  | Standings in Order
 | McNellys_Rangers | 3 |  | This sheet gives an overview of who plays vs who and what the handicaps are. |  |  |  |  |  |  |  |  |  |  | Team Name | Points
 | Spot_Smokers | 2 |  | The Standings overview show the points collected per team up to the week selected above |  |  |  |  |  |  |  |  |  |  | McNelly's Rangers | 3
 | Killer_Vs | 2 |  |  |  |  |  |  |  |  |  |  |  |  | Spot Smokers | 2
 | Passing_Time | 2 |  |  |  |  |  |  |  |  |  |  |  |  | Killer V's | 2
 | Lucky_Stables | 1 |  | player's rank within the team is recaclulated every week |  |  |  |  |  |  |  |  |  |  | Passing Time | 2
 | Wise_Guys | 1 |  | players are sorted by rank here to match up teamA #1 vs teamB #1 |  |  |  |  |  |  |  |  |  |  | RD's Whitetails | 2
 | RDs_Whitetails | 2 |  | ranking changes can be studied on the Teams sheet as the weeks progess |  |  |  |  |  |  |  |  |  |  | Out of [NAME] | 2
 | Out_of_Towners | 2 |  | compare the blue team pecking order between week 2 and week 3 preview |  |  |  |  |  |  |  |  |  |  | Lucky Stables | 1
 | Spots_with_Speed | 1 |  | note that teams end up in different spots each week, because of the pairings …. |  |  |  |  |  |  |  |  |  |  | Wise Guys | 1
 | Fletched_Tite | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Spots with Speed | 1
 | Rut_Necks | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Fletched Tite | 1
 | Twisted_Up | 0 |  |  |  |  |  |  |  |  |  |  |  |  | Rut Necks | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Twisted Up | 0
copy the other team
names into this list
and copy the formula in
B30 down