Spreadsheet: 62270d1263244234-league-spreadsheet-2010league_1_11_10
Sheet: Scores

week | team | shooter | score | x's | points won
1 | Blue | bill | 300 | 55 | 1
1 | Blue | bob | 296 | 50 | 1
1 | Blue | [NAME] | 280 | 40 | 1
1 | green | gary | 280 | 45
1 | green | grendel | 245 | 23 |  |  |  | enter scores into this sheet.
1 | green | greg | 236 | 22 |  |  |  | order does not matter
1 | orange | oliver | 300 | 55 | 1 |  |  | just make sure you don't miss out any fields and don't leave blank rows.
1 | orange | bob | 254 | 20
1 | orange | [NAME] | 214 | 10 |  |  |  | once you've entered_team all scores for one week, you can copy and paste
1 | purple | [NAME] | 289 | 44 |  |  |  | the week, team and shooter colum, then amend the week number
1 | purple | pete | 271 | 39 | 1 |  |  | and start entering values.
1 | purple | [NAME] | 260 | 35 | 1 |  |  | this way you don't have to select each player manually
1 | red_team | ray | 300 | 50 | 1
1 | red_team | [NAME] | 268 | 24 |  |  |  | Cells with missing information will light up
1 | red_team | ron | 250 | 25
1 | yellow | erin | 268 | 25 |  |  |  | You can sort this list as you like
1 | yellow | [NAME] | 258 | 23 | 1 |  |  | play with the dropdown filter and stuff.
1 | yellow | elwood | 245 | 30 | 1 |  |  | e.g. to see the highest ever individual scores.
1 | green | gary | 300 | 45 | 1
1 | green | grendel | 298 | 51 |  |  |  | To see who won points for a week, look at the Results sheet and enter the week.
1 | green | greg | 290 | 54 |  |  |  | The results sheet will calculate who won points.
1 | purple | [NAME] | 275 | 25 | 1 |  |  | These points will then have to be entered_team manually in this sheet.
1 | purple | pete | 268 | 26 | 1
1 | purple | [NAME] | 247 | 28
1 | orange | oliver | 300 | 55
1 | orange | [NAME] | 254 | 20 | 1
1 | orange | bob | 214 | 10
1 | pink | fawn | 289 | 44 |  |  |  | Order does not matter!
1 | pink | rabbit | 271 | 39
1 | pink | deer | 260 | 35
1 | chartreuse | snake | 300 | 52 | 1
1 | chartreuse | lizzard | 284 | 36 | 1
1 | chartreuse | gecko | 255 | 30 | 1
1 | amber | monkey | 278 | 25 | 1
1 | amber | sloth | 247 | 25 | 1
1 | amber | dog | 245 | 22
1 | mauve | sheep | 289 | 45
1 | mauve | cow | 237 | 33
1 | mauve | goat | 254 | 36
2 | Blue | bill | 300 | 3
2 | Blue | bob | 258 | 45
2 | Blue | [NAME] | 269 | 6
2 | green | gary | 265 | 9
2 | green | grendel | 245 | 6
2 | green | greg | 258 | 6
2 | orange | oliver | 256 | 5
2 | orange | bob | 254 | 5
2 | orange | [NAME] | 215 | 52
2 | purple | [NAME] | 269 | 2
2 | purple | pete | 235 | 2
2 | purple | [NAME] | 254 | 52
2 | red_team | ray | 258 | 5
2 | red_team | [NAME] | 287 | 5
2 | red_team | ron | 298 | 5
2 | yellow | erin | 285 | 5
2 | yellow | [NAME] | 275 | 52
2 | yellow | elwood | 278 | 2
2 | green | gary | 295 | 5
2 | green | grendel | 296 | 45
2 | green | greg | 268 | 4
2 | purple | [NAME] | 292 | 52
2 | purple | pete | 296 | 2
2 | purple | [NAME] | 296 | 5
2 | orange | oliver | 298 | 5
2 | orange | [NAME] | 297 | 5
2 | orange | bob | 295 | 5
2 | pink | fawn | 291 | 5 | 1
2 | pink | rabbit | 295 | 5 | 1
2 | pink | deer | 265 | 4
2 | chartreuse | snake | 269 | 4
2 | chartreuse | lizzard | 254 | 14
2 | chartreuse | gecko | 289 | 12 | 1
2 | amber | monkey | 285 | 5 | 1
2 | amber | sloth | 287 | 5 | 1
2 | amber | dog | 281 | 4
2 | mauve | sheep | 286 | 4
2 | mauve | cow | 285 | 44 | 1
2 | mauve | goat | 284 | 4