Spreadsheet: 62706d1263610617-league-spreadsheet-ccfsa_2010_league
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 score | rank before week 2 | avg score before week 3 | avg Xs before week 3 | rank score | rank before week 3 | avg score before week 4 | avg Xs before week 4 | rank score | rank before week 4 | avg score before week 5 | avg Xs before week 5 | rank score | rank before week 5 | avg score before week 6 | avg Xs before week 6 | rank score | rank before week 6 | avg score before week 7 | avg Xs before week 7 | rank score | rank before week 7 | avg score before week 8 | avg Xs before week 8 | rank score | rank before week 8 | avg score before week 9 | avg Xs before week 9 | rank score | rank before week 9 | avg score before week 10 | avg Xs before week 10 | rank score | rank before week 10
McNellys_Rangers
[NAME] | 300 | 53 | 2 | 300 | 50 | 0.9989999999999999 | 1 | 300 | 53 | 0.9993000000000001 | 1 | 300 | 53 | 0.9993000000000001 | 1 | 300 | 53 | 0.9993000000000001 | 1 | 300 | 53 | 0.9993000000000001 | 1 | 300 | 53 | 0.9993000000000001 | 1 | 300 | 53 | 0.9993000000000001 | 1 | 300 | 53 | 0.9993000000000001 | 1 | 300 | 53 | 0.9993000000000001 | 1
[NAME] | 300 | 47 | 3 | 0 | 0 | -0.002 | 3 | 300 | 47 | 0.9983000000000001 | 2 | 300 | 47 | 0.9983000000000001 | 2 | 300 | 47 | 0.9983000000000001 | 2 | 300 | 47 | 0.9983000000000001 | 2 | 300 | 47 | 0.9983000000000001 | 2 | 300 | 47 | 0.9983000000000001 | 2 | 300 | 47 | 0.9983000000000001 | 2 | 300 | 47 | 0.9983000000000001 | 2
[NAME] | 300 | 54 | 1 | 300 | 56 | 0.9969999999999999 | 2 | 300 | 54 | 0.9973000000000001 | 3 | 300 | 54 | 0.9973000000000001 | 3 | 300 | 54 | 0.9973000000000001 | 3 | 300 | 54 | 0.9973000000000001 | 3 | 300 | 54 | 0.9973000000000001 | 3 | 300 | 54 | 0.9973000000000001 | 3 | 300 | 54 | 0.9973000000000001 | 3 | 300 | 54 | 0.9973000000000001 | 3
Spot_Smokers
[NAME] | 299.5 | 51.5 | 2 | 300 | 53 | 0.9943000000000001 | 1 | 299.5 | 51.5 | 0.9982748333333332 | 2 | 299.5 | 51.5 | 0.9982748333333332 | 2 | 299.5 | 51.5 | 0.9982748333333332 | 2 | 299.5 | 51.5 | 0.9982748333333332 | 2 | 299.5 | 51.5 | 0.9982748333333332 | 2 | 299.5 | 51.5 | 0.9982748333333332 | 2 | 299.5 | 51.5 | 0.9982748333333332 | 2 | 299.5 | 51.5 | 0.9982748333333332 | 2
[NAME] | 285.5 | 24.5 | 3 | 287 | 25 | 0.9499666666666666 | 3 | 285.5 | 24.5 | 0.9515981666666666 | 3 | 285.5 | 24.5 | 0.9515981666666666 | 3 | 285.5 | 24.5 | 0.9515981666666666 | 3 | 285.5 | 24.5 | 0.9515981666666666 | 3 | 285.5 | 24.5 | 0.9515981666666666 | 3 | 285.5 | 24.5 | 0.9515981666666666 | 3 | 285.5 | 24.5 | 0.9515981666666666 | 3 | 285.5 | 24.5 | 0.9515981666666666 | 3
[NAME] | 300 | 51.5 | 1 | 300 | 56 | 0.9923000000000001 | 2 | 300 | 51.5 | 0.9999215000000001 | 1 | 300 | 51.5 | 0.9999215000000001 | 1 | 300 | 51.5 | 0.9999215000000001 | 1 | 300 | 51.5 | 0.9999215000000001 | 1 | 300 | 51.5 | 0.9999215000000001 | 1 | 300 | 51.5 | 0.9999215000000001 | 1 | 300 | 51.5 | 0.9999215000000001 | 1 | 300 | 51.5 | 0.9999215000000001 | 1
Killer_Vs
[NAME] | 290.5 | 33 | 2 | 281 | 18 | 0.9383423728813559 | 2 | 290.5 | 33 | 0.987968238095238 | 2 | 290.5 | 33 | 0.987968238095238 | 2 | 290.5 | 33 | 0.987968238095238 | 2 | 290.5 | 33 | 0.987968238095238 | 2 | 290.5 | 33 | 0.987968238095238 | 2 | 290.5 | 33 | 0.987968238095238 | 2 | 290.5 | 33 | 0.987968238095238 | 2 | 290.5 | 33 | 0.987968238095238 | 2
[NAME] | 294 | 26 | 1 | 295 | 27 | 0.9848 | 1 | 294 | 26 | 0.999863 | 1 | 294 | 26 | 0.999863 | 1 | 294 | 26 | 0.999863 | 1 | 294 | 26 | 0.999863 | 1 | 294 | 26 | 0.999863 | 1 | 294 | 26 | 0.999863 | 1 | 294 | 26 | 0.999863 | 1 | 294 | 26 | 0.999863 | 1
[NAME] | 283 | 17.5 | 3 | 278 | 16 | 0.9261728813559322 | 3 | 283 | 17.5 | 0.9624380340136054 | 3 | 283 | 17.5 | 0.9624380340136054 | 3 | 283 | 17.5 | 0.9624380340136054 | 3 | 283 | 17.5 | 0.9624380340136054 | 3 | 283 | 17.5 | 0.9624380340136054 | 3 | 283 | 17.5 | 0.9624380340136054 | 3 | 283 | 17.5 | 0.9624380340136054 | 3 | 283 | 17.5 | 0.9624380340136054 | 3
Passing_Time
[NAME] | 299.5 | 50.5 | 2 | 299 | 50 | 0.9839999999999999 | 1 | 299.5 | 50.5 | 0.9998404999999999 | 1 | 299.5 | 50.5 | 0.9998404999999999 | 1 | 299.5 | 50.5 | 0.9998404999999999 | 1 | 299.5 | 50.5 | 0.9998404999999999 | 1 | 299.5 | 50.5 | 0.9998404999999999 | 1 | 299.5 | 50.5 | 0.9998404999999999 | 1 | 299.5 | 50.5 | 0.9998404999999999 | 1 | 299.5 | 50.5 | 0.9998404999999999 | 1
[NAME] | 299 | 43 | 3 | 299 | 43 | 0.9829999999999999 | 2 | 299 | 43 | 0.998161050918197 | 3 | 299 | 43 | 0.998161050918197 | 3 | 299 | 43 | 0.998161050918197 | 3 | 299 | 43 | 0.998161050918197 | 3 | 299 | 43 | 0.998161050918197 | 3 | 299 | 43 | 0.998161050918197 | 3 | 299 | 43 | 0.998161050918197 | 3 | 299 | 43 | 0.998161050918197 | 3
[NAME] | 299.5 | 51.5 | 1 | 299 | 53 | 0.9819999999999999 | 3 | 299.5 | 51.5 | 0.9998205 | 2 | 299.5 | 51.5 | 0.9998205 | 2 | 299.5 | 51.5 | 0.9998205 | 2 | 299.5 | 51.5 | 0.9998205 | 2 | 299.5 | 51.5 | 0.9998205 | 2 | 299.5 | 51.5 | 0.9998205 | 2 | 299.5 | 51.5 | 0.9998205 | 2 | 299.5 | 51.5 | 0.9998205 | 2
Lucky_Stables
Heather Ellis | 220.5 | 7 | 3 | 231 | 7 | 0.6360488372093024 | 2 | 220.5 | 7 | 0.721464627118644 | 3 | 220.5 | 7 | 0.721464627118644 | 3 | 220.5 | 7 | 0.721464627118644 | 3 | 220.5 | 7 | 0.721464627118644 | 3 | 220.5 | 7 | 0.721464627118644 | 3 | 220.5 | 7 | 0.721464627118644 | 3 | 220.5 | 7 | 0.721464627118644 | 3 | 220.5 | 7 | 0.721464627118644 | 3
[NAME] | 260 | 11 | 2 | 258 | 8 | 0.7306999999999999 | 1 | 260 | 11 | 0.8543629322033898 | 2 | 260 | 11 | 0.8543629322033898 | 2 | 260 | 11 | 0.8543629322033898 | 2 | 260 | 11 | 0.8543629322033898 | 2 | 260 | 11 | 0.8543629322033898 | 2 | 260 | 11 | 0.8543629322033898 | 2 | 260 | 11 | 0.8543629322033898 | 2 | 260 | 11 | 0.8543629322033898 | 2
[NAME] | 295 | 36 | 1 | 0 | 0 | -0.2793 | 3 | 295 | 36 | 0.9720070000000001 | 1 | 295 | 36 | 0.9720070000000001 | 1 | 295 | 36 | 0.9720070000000001 | 1 | 295 | 36 | 0.9720070000000001 | 1 | 295 | 36 | 0.9720070000000001 | 1 | 295 | 36 | 0.9720070000000001 | 1 | 295 | 36 | 0.9720070000000001 | 1 | 295 | 36 | 0.9720070000000001 | 1
Wise_Guys
[NAME] | 285.5 | 28.5 | 1 | 287 | 34 | 0.9724 | 1 | 285.5 | 28.5 | 0.9997185 | 1 | 285.5 | 28.5 | 0.9997185 | 1 | 285.5 | 28.5 | 0.9997185 | 1 | 285.5 | 28.5 | 0.9997185 | 1 | 285.5 | 28.5 | 0.9997185 | 1 | 285.5 | 28.5 | 0.9997185 | 1 | 285.5 | 28.5 | 0.9997185 | 1 | 285.5 | 28.5 | 0.9997185 | 1
[NAME] | 270 | 18.5 | 2 | 273 | 19 | 0.9226195121951218 | 3 | 270 | 18.5 | 0.9454177819614711 | 2 | 270 | 18.5 | 0.9454177819614711 | 2 | 270 | 18.5 | 0.9454177819614711 | 2 | 270 | 18.5 | 0.9454177819614711 | 2 | 270 | 18.5 | 0.9454177819614711 | 2 | 270 | 18.5 | 0.9454177819614711 | 2 | 270 | 18.5 | 0.9454177819614711 | 2 | 270 | 18.5 | 0.9454177819614711 | 2
[NAME] | 264.5 | 12 | 3 | 277 | 13 | 0.935556794425087 | 2 | 264.5 | 12 | 0.9261433336252188 | 3 | 264.5 | 12 | 0.9261433336252188 | 3 | 264.5 | 12 | 0.9261433336252188 | 3 | 264.5 | 12 | 0.9261433336252188 | 3 | 264.5 | 12 | 0.9261433336252188 | 3 | 264.5 | 12 | 0.9261433336252188 | 3 | 264.5 | 12 | 0.9261433336252188 | 3 | 264.5 | 12 | 0.9261433336252188 | 3
RDs_Whitetails
[NAME] | 299 | 48.5 | 2 | 298 | 49 | 0.9655555183946487 | 2 | 299 | 48.5 | 0.998019050918197 | 2 | 299 | 48.5 | 0.998019050918197 | 2 | 299 | 48.5 | 0.998019050918197 | 2 | 299 | 48.5 | 0.998019050918197 | 2 | 299 | 48.5 | 0.998019050918197 | 2 | 299 | 48.5 | 0.998019050918197 | 2 | 299 | 48.5 | 0.998019050918197 | 2 | 299 | 48.5 | 0.998019050918197 | 2
[NAME] | 257.5 | 11.5 | 3 | 267 | 11 | 0.8608765886287625 | 3 | 257.5 | 11.5 | 0.8594447771285476 | 3 | 257.5 | 11.5 | 0.8594447771285476 | 3 | 257.5 | 11.5 | 0.8594447771285476 | 3 | 257.5 | 11.5 | 0.8594447771285476 | 3 | 257.5 | 11.5 | 0.8594447771285476 | 3 | 257.5 | 11.5 | 0.8594447771285476 | 3 | 257.5 | 11.5 | 0.8594447771285476 | 3 | 257.5 | 11.5 | 0.8594447771285476 | 3
[NAME] | 299.5 | 48.5 | 1 | 299 | 48 | 0.9668999999999999 | 1 | 299.5 | 48.5 | 0.9996684999999998 | 1 | 299.5 | 48.5 | 0.9996684999999998 | 1 | 299.5 | 48.5 | 0.9996684999999998 | 1 | 299.5 | 48.5 | 0.9996684999999998 | 1 | 299.5 | 48.5 | 0.9996684999999998 | 1 | 299.5 | 48.5 | 0.9996684999999998 | 1 | 299.5 | 48.5 | 0.9996684999999998 | 1 | 299.5 | 48.5 | 0.9996684999999998 | 1
Out_of_Towners
[NAME] | 300 | 51 | 1 | 300 | 55 | 0.9645 | 1 | 300 | 51 | 0.9641000000000001 | 1 | 300 | 51 | 0.9641000000000001 | 1 | 300 | 51 | 0.9641000000000001 | 1 | 300 | 51 | 0.9641000000000001 | 1 | 300 | 51 | 0.9641000000000001 | 1 | 300 | 51 | 0.9641000000000001 | 1 | 300 | 51 | 0.9641000000000001 | 1 | 300 | 51 | 0.9641000000000001 | 1
[NAME] | 300 | 46 | 2 | 300 | 45 | 0.9635 | 2 | 300 | 46 | 0.9631000000000001 | 2 | 300 | 46 | 0.9631000000000001 | 2 | 300 | 46 | 0.9631000000000001 | 2 | 300 | 46 | 0.9631000000000001 | 2 | 300 | 46 | 0.9631000000000001 | 2 | 300 | 46 | 0.9631000000000001 | 2 | 300 | 46 | 0.9631000000000001 | 2 | 300 | 46 | 0.9631000000000001 | 2
[NAME] | 300 | 1 | 3 | 0 | 0 | -0.0375 | 3 | 300 | 1 | 0.9621000000000001 | 3 | 300 | 1 | 0.9621000000000001 | 3 | 300 | 1 | 0.9621000000000001 | 3 | 300 | 1 | 0.9621000000000001 | 3 | 300 | 1 | 0.9621000000000001 | 3 | 300 | 1 | 0.9621000000000001 | 3 | 300 | 1 | 0.9621000000000001 | 3 | 300 | 1 | 0.9621000000000001 | 3
Spots_with_Speed
[NAME] | 262 | 15 | 2 | 280 | 18 | 0.9246581314878892 | 2 | 262 | 15 | 0.918853245614035 | 2 | 262 | 15 | 0.918853245614035 | 2 | 262 | 15 | 0.918853245614035 | 2 | 262 | 15 | 0.918853245614035 | 2 | 262 | 15 | 0.918853245614035 | 2 | 262 | 15 | 0.918853245614035 | 2 | 262 | 15 | 0.918853245614035 | 2 | 262 | 15 | 0.918853245614035 | 2
[NAME] | 285 | 21.5 | 1 | 289 | 23 | 0.9548 | 1 | 285 | 21.5 | 0.9995450000000001 | 1 | 285 | 21.5 | 0.9995450000000001 | 1 | 285 | 21.5 | 0.9995450000000001 | 1 | 285 | 21.5 | 0.9995450000000001 | 1 | 285 | 21.5 | 0.9995450000000001 | 1 | 285 | 21.5 | 0.9995450000000001 | 1 | 285 | 21.5 | 0.9995450000000001 | 1 | 285 | 21.5 | 0.9995450000000001 | 1
[NAME] | 220.5 | 8 | 3 | 236 | 9 | 0.7704089965397923 | 3 | 220.5 | 8 | 0.7732192105263157 | 3 | 220.5 | 8 | 0.7732192105263157 | 3 | 220.5 | 8 | 0.7732192105263157 | 3 | 220.5 | 8 | 0.7732192105263157 | 3 | 220.5 | 8 | 0.7732192105263157 | 3 | 220.5 | 8 | 0.7732192105263157 | 3 | 220.5 | 8 | 0.7732192105263157 | 3 | 220.5 | 8 | 0.7732192105263157 | 3
Fletched_Tite
[NAME] | 300 | 56 | 1 | 300 | 56 | 0.9546 | 1 | 300 | 56 | 0.9546 | 1 | 300 | 56 | 0.9546 | 1 | 300 | 56 | 0.9546 | 1 | 300 | 56 | 0.9546 | 1 | 300 | 56 | 0.9546 | 1 | 300 | 56 | 0.9546 | 1 | 300 | 56 | 0.9546 | 1 | 300 | 56 | 0.9546 | 1
Don French | 230 | 12 | 3 | 0 | 0 | -0.0464 | 2 | 230 | 12 | 0.7202666666666667 | 3 | 230 | 12 | 0.7202666666666667 | 3 | 230 | 12 | 0.7202666666666667 | 3 | 230 | 12 | 0.7202666666666667 | 3 | 230 | 12 | 0.7202666666666667 | 3 | 230 | 12 | 0.7202666666666667 | 3 | 230 | 12 | 0.7202666666666667 | 3 | 230 | 12 | 0.7202666666666667 | 3
[NAME] | 280 | 26 | 2 | 0 | 0 | -0.0474 | 3 | 280 | 26 | 0.8859333333333334 | 2 | 280 | 26 | 0.8859333333333334 | 2 | 280 | 26 | 0.8859333333333334 | 2 | 280 | 26 | 0.8859333333333334 | 2 | 280 | 26 | 0.8859333333333334 | 2 | 280 | 26 | 0.8859333333333334 | 2 | 280 | 26 | 0.8859333333333334 | 2 | 280 | 26 | 0.8859333333333334 | 2
Rut_Necks
[NAME] | 258 | 4.5 | 3 | 0 | 1 | -0.0559 | 2 | 258 | 4.5 | 0.8548499999999999 | 3 | 258 | 4.5 | 0.8548499999999999 | 3 | 258 | 4.5 | 0.8548499999999999 | 3 | 258 | 4.5 | 0.8548499999999999 | 3 | 258 | 4.5 | 0.8548499999999999 | 3 | 258 | 4.5 | 0.8548499999999999 | 3 | 258 | 4.5 | 0.8548499999999999 | 3 | 258 | 4.5 | 0.8548499999999999 | 3
[NAME] | 300 | 60 | 1 | 300 | 60 | 0.9430999999999999 | 1 | 300 | 60 | 0.99475 | 1 | 300 | 60 | 0.99475 | 1 | 300 | 60 | 0.99475 | 1 | 300 | 60 | 0.99475 | 1 | 300 | 60 | 0.99475 | 1 | 300 | 60 | 0.99475 | 1 | 300 | 60 | 0.99475 | 1 | 300 | 60 | 0.99475 | 1
[NAME] | 295 | 17 | 2 | 0 | 3 | -0.0579 | 3 | 295 | 17 | 0.9779833333333332 | 2 | 295 | 17 | 0.9779833333333332 | 2 | 295 | 17 | 0.9779833333333332 | 2 | 295 | 17 | 0.9779833333333332 | 2 | 295 | 17 | 0.9779833333333332 | 2 | 295 | 17 | 0.9779833333333332 | 2 | 295 | 17 | 0.9779833333333332 | 2 | 295 | 17 | 0.9779833333333332 | 2
Twisted_Up
[NAME] | 294.5 | 31 | 2 | 294 | 33 | 0.9255775919732441 | 2 | 294.5 | 31 | 0.9893369663865547 | 2 | 294.5 | 31 | 0.9893369663865547 | 2 | 294.5 | 31 | 0.9893369663865547 | 2 | 294.5 | 31 | 0.9893369663865547 | 2 | 294.5 | 31 | 0.9893369663865547 | 2 | 294.5 | 31 | 0.9893369663865547 | 2 | 294.5 | 31 | 0.9893369663865547 | 2 | 294.5 | 31 | 0.9893369663865547 | 2
[NAME] | 297.5 | 41 | 1 | 299 | 48 | 0.9413 | 1 | 297.5 | 41 | 0.9994109999999999 | 1 | 297.5 | 41 | 0.9994109999999999 | 1 | 297.5 | 41 | 0.9994109999999999 | 1 | 297.5 | 41 | 0.9994109999999999 | 1 | 297.5 | 41 | 0.9994109999999999 | 1 | 297.5 | 41 | 0.9994109999999999 | 1 | 297.5 | 41 | 0.9994109999999999 | 1 | 297.5 | 41 | 0.9994109999999999 | 1
Palmer Addison | 271.5 | 14.5 | 3 | 274 | 16 | 0.8566879598662207 | 3 | 271.5 | 14.5 | 0.9120060420168067 | 3 | 271.5 | 14.5 | 0.9120060420168067 | 3 | 271.5 | 14.5 | 0.9120060420168067 | 3 | 271.5 | 14.5 | 0.9120060420168067 | 3 | 271.5 | 14.5 | 0.9120060420168067 | 3 | 271.5 | 14.5 | 0.9120060420168067 | 3 | 271.5 | 14.5 | 0.9120060420168067 | 3 | 271.5 | 14.5 | 0.9120060420168067 | 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