Spreadsheet: 62335d1263308284-league-spreadsheet-2010league_rev1_jan8_2010-1-
Sheet: Teams

 |  |  |  | before week |  |  | before week |  |  | before week |  |  | before week |  |  | before week |  |  | before week |  |  | before week |  |  | before week |  |  | before week
 | current values are before week 12 |  |  | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 8 | 8 | 8 | 9 | 9 | 9 | 10 | 10 | 10
named ranges | current average score | current avg x's | current rank | avg score before week 2 | [NAME] before week 2 | rank before week 2 | avg score before week 3 | avg Xs before week 3 | rank before week 3 | avg score before week 4 | avg Xs before week 4 | rank before week 4 | avg score before week 5 | avg Xs before week 5 | rank before week 5 | avg score before week 6 | avg Xs before week 6 | rank before week 6 | avg score before week 7 | avg Xs before week 7 | rank before week 7 | avg score before week 8 | avg Xs before week 8 | rank before week 8 | avg score before week 9 | avg Xs before week 9 | rank before week 9 | avg score before week 10 | avg Xs before week 10 | rank before week 10
McNellys_Rangers
[NAME] | 300 | 50 | 2 | 300 | 50 | #N/A | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2
[NAME] | 300 | 50 | 3 | #N/A | #N/A |  | 300 | 50 | 3 | 300 | 50 | 3 | 300 | 50 | 3 | 300 | 50 | 3 | 300 | 50 | 3 | 300 | 50 | 3 | 300 | 50 | 3 | 300 | 50 | 3
[NAME] | 300 | 53 | 1 | 300 | 56 | #N/A | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1
Spot_Smokers
[NAME] | 300 | 51.5 | 2 | 300 | 53 | 2 | 300 | 51.5 | 2 | 300 | 51.5 | 2 | 300 | 51.5 | 2 | 300 | 51.5 | 2 | 300 | 51.5 | 2 | 300 | 51.5 | 2 | 300 | 51.5 | 2 | 300 | 51.5 | 2
[NAME] | 286 | 37.5 | 3 | 287 | 25 | 3 | 286 | 37.5 | 3 | 286 | 37.5 | 3 | 286 | 37.5 | 3 | 286 | 37.5 | 3 | 286 | 37.5 | 3 | 286 | 37.5 | 3 | 286 | 37.5 | 3 | 286 | 37.5 | 3
[NAME] | 300 | 53 | 1 | 300 | 56 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1
Killer_Vs
[NAME] | 288.5 | 34 | 2 | 281 | 18 | 2 | 288.5 | 34 | 2 | 288.5 | 34 | 2 | 288.5 | 34 | 2 | 288.5 | 34 | 2 | 288.5 | 34 | 2 | 288.5 | 34 | 2 | 288.5 | 34 | 2 | 288.5 | 34 | 2
[NAME] | 296.5 | 38.5 | 1 | 295 | 27 | 1 | 296.5 | 38.5 | 1 | 296.5 | 38.5 | 1 | 296.5 | 38.5 | 1 | 296.5 | 38.5 | 1 | 296.5 | 38.5 | 1 | 296.5 | 38.5 | 1 | 296.5 | 38.5 | 1 | 296.5 | 38.5 | 1
[NAME] | 281.5 | 33 | 3 | 278 | 16 | 3 | 281.5 | 33 | 3 | 281.5 | 33 | 3 | 281.5 | 33 | 3 | 281.5 | 33 | 3 | 281.5 | 33 | 3 | 281.5 | 33 | 3 | 281.5 | 33 | 3 | 281.5 | 33 | 3
Passing_Time
[NAME] | 299.5 | 50 | 2 | 299 | 50 | 2 | 299.5 | 50 | 2 | 299.5 | 50 | 2 | 299.5 | 50 | 2 | 299.5 | 50 | 2 | 299.5 | 50 | 2 | 299.5 | 50 | 2 | 299.5 | 50 | 2 | 299.5 | 50 | 2
[NAME] | 299.5 | 46.5 | 3 | 299 | 43 | 3 | 299.5 | 46.5 | 3 | 299.5 | 46.5 | 3 | 299.5 | 46.5 | 3 | 299.5 | 46.5 | 3 | 299.5 | 46.5 | 3 | 299.5 | 46.5 | 3 | 299.5 | 46.5 | 3 | 299.5 | 46.5 | 3
[NAME] | 298.5 | 51.5 | 3 | 299 | 53 | 1 | 298.5 | 51.5 | 3 | 298.5 | 51.5 | 3 | 298.5 | 51.5 | 3 | 298.5 | 51.5 | 3 | 298.5 | 51.5 | 3 | 298.5 | 51.5 | 3 | 298.5 | 51.5 | 3 | 298.5 | 51.5 | 3
Lucky_Stables
Heather Ellis | 238 | 28.5 | 3 | 231 | 7 | #N/A | 238 | 28.5 | 3 | 238 | 28.5 | 3 | 238 | 28.5 | 3 | 238 | 28.5 | 3 | 238 | 28.5 | 3 | 238 | 28.5 | 3 | 238 | 28.5 | 3 | 238 | 28.5 | 3
[NAME] | 263.5 | 29 | 2 | 258 | 8 | #N/A | 263.5 | 29 | 2 | 263.5 | 29 | 2 | 263.5 | 29 | 2 | 263.5 | 29 | 2 | 263.5 | 29 | 2 | 263.5 | 29 | 2 | 263.5 | 29 | 2 | 263.5 | 29 | 2
[NAME] | 296 | 50 | 1 | #N/A | #N/A |  | 296 | 50 | 1 | 296 | 50 | 1 | 296 | 50 | 1 | 296 | 50 | 1 | 296 | 50 | 1 | 296 | 50 | 1 | 296 | 50 | 1 | 296 | 50 | 1
Wise_Guys
[NAME] | 285.5 | 42 | 2 | 287 | 34 | 1 | 285.5 | 42 | 2 | 285.5 | 42 | 2 | 285.5 | 42 | 2 | 285.5 | 42 | 2 | 285.5 | 42 | 2 | 285.5 | 42 | 2 | 285.5 | 42 | 2 | 285.5 | 42 | 2
[NAME] | 273.5 | 34.5 | 3 | 273 | 19 | 3 | 273.5 | 34.5 | 3 | 273.5 | 34.5 | 3 | 273.5 | 34.5 | 3 | 273.5 | 34.5 | 3 | 273.5 | 34.5 | 3 | 273.5 | 34.5 | 3 | 273.5 | 34.5 | 3 | 273.5 | 34.5 | 3
[NAME] | 287.5 | 31.5 | 1 | 277 | 13 | 2 | 287.5 | 31.5 | 1 | 287.5 | 31.5 | 1 | 287.5 | 31.5 | 1 | 287.5 | 31.5 | 1 | 287.5 | 31.5 | 1 | 287.5 | 31.5 | 1 | 287.5 | 31.5 | 1 | 287.5 | 31.5 | 1
RDs_Whitetails
[NAME] | 298 | 49.5 | 2 | 298 | 49 | 2 | 298 | 49.5 | 2 | 298 | 49.5 | 2 | 298 | 49.5 | 2 | 298 | 49.5 | 2 | 298 | 49.5 | 2 | 298 | 49.5 | 2 | 298 | 49.5 | 2 | 298 | 49.5 | 2
[NAME] | 266 | 30.5 | 3 | 267 | 11 | 3 | 266 | 30.5 | 3 | 266 | 30.5 | 3 | 266 | 30.5 | 3 | 266 | 30.5 | 3 | 266 | 30.5 | 3 | 266 | 30.5 | 3 | 266 | 30.5 | 3 | 266 | 30.5 | 3
[NAME] | 299.5 | 49 | 1 | 299 | 48 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1
Out_of_Towners
[NAME] | 300 | 52.5 | 1 | 300 | 55 | #N/A | 300 | 52.5 | 1 | 300 | 52.5 | 1 | 300 | 52.5 | 1 | 300 | 52.5 | 1 | 300 | 52.5 | 1 | 300 | 52.5 | 1 | 300 | 52.5 | 1 | 300 | 52.5 | 1
[NAME] | 300 | 47.5 | 3 | 300 | 45 | #N/A | 300 | 47.5 | 3 | 300 | 47.5 | 3 | 300 | 47.5 | 3 | 300 | 47.5 | 3 | 300 | 47.5 | 3 | 300 | 47.5 | 3 | 300 | 47.5 | 3 | 300 | 47.5 | 3
[NAME] | 300 | 50 | 2 | #N/A | #N/A |  | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2 | 300 | 50 | 2
Spots_with_Speed
[NAME] | 267 | 34 | 2 | 280 | 18 | 2 | 267 | 34 | 2 | 267 | 34 | 2 | 267 | 34 | 2 | 267 | 34 | 2 | 267 | 34 | 2 | 267 | 34 | 2 | 267 | 34 | 2 | 267 | 34 | 2
[NAME] | 287 | 36.5 | 1 | 289 | 23 | 1 | 287 | 36.5 | 1 | 287 | 36.5 | 1 | 287 | 36.5 | 1 | 287 | 36.5 | 1 | 287 | 36.5 | 1 | 287 | 36.5 | 1 | 287 | 36.5 | 1 | 287 | 36.5 | 1
[NAME] | 245 | 29.5 | 3 | 236 | 9 | 3 | 245 | 29.5 | 3 | 245 | 29.5 | 3 | 245 | 29.5 | 3 | 245 | 29.5 | 3 | 245 | 29.5 | 3 | 245 | 29.5 | 3 | 245 | 29.5 | 3 | 245 | 29.5 | 3
Fletched_Tite
[NAME] | 300 | 53 | 1 | 300 | 56 | #N/A | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1 | 300 | 53 | 1
Don French | 257 | 50 | 3 | #N/A | #N/A |  | 257 | 50 | 3 | 257 | 50 | 3 | 257 | 50 | 3 | 257 | 50 | 3 | 257 | 50 | 3 | 257 | 50 | 3 | 257 | 50 | 3 | 257 | 50 | 3
[NAME] | 292 | 50 | 2 | #N/A | #N/A |  | 292 | 50 | 2 | 292 | 50 | 2 | 292 | 50 | 2 | 292 | 50 | 2 | 292 | 50 | 2 | 292 | 50 | 2 | 292 | 50 | 2 | 292 | 50 | 2
Rut_Necks
[NAME] | 281 | 50 | 2 | #N/A | #N/A |  | 281 | 50 | 2 | 281 | 50 | 2 | 281 | 50 | 2 | 281 | 50 | 2 | 281 | 50 | 2 | 281 | 50 | 2 | 281 | 50 | 2 | 281 | 50 | 2
[NAME] | 254 | 50 | 3 | #N/A | #N/A |  | 254 | 50 | 3 | 254 | 50 | 3 | 254 | 50 | 3 | 254 | 50 | 3 | 254 | 50 | 3 | 254 | 50 | 3 | 254 | 50 | 3 | 254 | 50 | 3
[NAME] | 295 | 50 | 1 | #N/A | #N/A |  | 295 | 50 | 1 | 295 | 50 | 1 | 295 | 50 | 1 | 295 | 50 | 1 | 295 | 50 | 1 | 295 | 50 | 1 | 295 | 50 | 1 | 295 | 50 | 1
Twisted_Up
[NAME] | 296.5 | 41.5 | 2 | 294 | 33 | 2 | 296.5 | 41.5 | 2 | 296.5 | 41.5 | 2 | 296.5 | 41.5 | 2 | 296.5 | 41.5 | 2 | 296.5 | 41.5 | 2 | 296.5 | 41.5 | 2 | 296.5 | 41.5 | 2 | 296.5 | 41.5 | 2
[NAME] | 299.5 | 49 | 1 | 299 | 48 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1 | 299.5 | 49 | 1
Palmer Addison | 279 | 33 | 3 | 274 | 16 | 3 | 279 | 33 | 3 | 279 | 33 | 3 | 279 | 33 | 3 | 279 | 33 | 3 | 279 | 33 | 3 | 279 | 33 | 3 | 279 | 33 | 3 | 279 | 33 | 3
To add more teams, create an entry in the [NAME] sheet first
Then copy and paste the team block above (select whole rows!!)
Enter the team name, no spaces
create a range name for the team the same as the team name entry in the Setup sheet.
Highlight the three players, then [NAME] and enter the team name. Use _ instead of spaces
enter the player names. Players can have the same name as long as they are in different teams
e.g. There can be a [NAME] in Team Blue and another [NAME] in Team Orange. Doesn’t matter.
The formulas will sort which team which [NAME] belongs to as long as a range name is set up here …
But no two Bobs in one team, please.
Remember to protect the sheet after you've made changes