Spreadsheet: 59757d1260318114-league-spreadsheet-vs2_league_spreadsheet_test
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 3 |  |  | 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
Blue
bill | 300 | 29 | 1 | 300 | 55 | 1 | 300 | 29 | 1
bob | 277 | 47.5 | 2 | 296 | 50 | 2 | 277 | 47.5 | 2
[NAME] | 274.5 | 23 | 3 | 280 | 40 | 3 | 274.5 | 23 | 3
yellow
[NAME] | 266.5 | 37.5 | 2 | 258 | 23 | 2 | 266.5 | 37.5 | 2
erin | 276.5 | 15 | 1 | 268 | 25 | 1 | 276.5 | 15 | 1
elwood | 261.5 | 16 | 3 | 245 | 30 | 3 | 261.5 | 16 | 3
purple
[NAME] | 281.25 | 30.75 | 1 | 282 | 34.5 | 1 | 281.25 | 30.75 | 1
pete | 267.5 | 17.25 | 2 | 269.5 | 32.5 | 2 | 267.5 | 17.25 | 2
[NAME] | 264.25 | 30 | 3 | 253.5 | 31.5 | 3 | 264.25 | 30 | 3
red_team
[NAME] | 277.5 | 14.5 | 2 | 268 | 24 | 2 | 277.5 | 14.5 | 2
ron | 274 | 15 | 3 | 250 | 25 | 3 | 274 | 15 | 3
ray | 279 | 27.5 | 1 | 300 | 50 | 1 | 279 | 27.5 | 1
green
gary | 285 | 26 | 1 | 290 | 45 | 1 | 285 | 26 | 1
grendel | 271 | 31.25 | 2 | 271.5 | 37 | 2 | 271 | 31.25 | 2
greg | 263 | 21.5 | 3 | 263 | 38 | 3 | 263 | 21.5 | 3
orange
oliver | 288.5 | 30 | 1 | 300 | 55 | 1 | 288.5 | 30 | 1
[NAME] | 245 | 21.75 | 3 | 234 | 15 | 2 | 245 | 21.75 | 3
bob | 254.25 | 10 | 2 | 234 | 15 | 2 | 254.25 | 10 | 2
pink
fawn | 290 | 24.5 | 1 | 289 | 44 | 1 | 290 | 24.5 | 1
rabbit | 283 | 22 | 2 | 271 | 39 | 2 | 283 | 22 | 2
deer | 262.5 | 19.5 | 3 | 260 | 35 | 3 | 262.5 | 19.5 | 3
chartreuse
lizzard | 269 | 25 | 3 | 284 | 36 | 2 | 269 | 25 | 3
snake | 284.5 | 28 | 1 | 300 | 52 | 1 | 284.5 | 28 | 1
gecko | 272 | 21 | 2 | 255 | 30 | 3 | 272 | 21 | 2
amber
monkey | 281.5 | 15 | 1 | 278 | 25 | 1 | 281.5 | 15 | 1
sloth | 267 | 15 | 2 | 247 | 25 | 2 | 267 | 15 | 2
dog | 263 | 13 | 3 | 245 | 22 | 3 | 263 | 13 | 3
mauve
sheep | 287.5 | 24.5 | 1 | 289 | 45 | 1 | 287.5 | 24.5 | 1
cow | 261 | 38.5 | 3 | 237 | 33 | 3 | 261 | 38.5 | 3
goat | 269 | 20 | 2 | 254 | 36 | 2 | 269 | 20 | 2
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