Spreadsheet: 90560d1290296623-conditional-indirect-or-lookup-season-stats-test
Sheet: BOS

SEASON STATS 2010 - BOS |  |  | [NAME] |  |  |  |  |  |  |  | Track Time |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | Assits |  |  |  |  | Blocking |  |  |  | Knockdowns |  |  |  |  |  |  | Plus/Minus |  |  |  |  |  |  |  | Plus/Minus Average |  |  |  |  |  |  | Penalties
Skater | Travel Team | Bouts Skated | [NAME] | Pivot | Inside | Outside | Back | Blocker | Blocker +/- | Pivot +/- | Total Possible | Total Jams | % Track Time | total points for | total points against | Offensive score per jam | Defensive score per jam | cummulative per jam | Leads | Lead % | Points | PPJ | Highest PJ | GS Points | Whips | [NAME] | Pushes | Bulldozers | TotS | Hits | Body | [NAME] | Off Block | B on B | J on B | B on J | J on J | Block KD | [NAME] | TotS [NAME] | [NAME] | Lead | Pivot | Inside | Outside | Back | Blocker | Overall | [NAME] | Pivot | Inside | Outside | Back | Blocker | Overall | Minors | Majors | In Box | Average | Pen/Jam | [NAME] | Cut Track | CT/jam | CT Rating
[NAME] | BOS | 3 | 11 | 4 | 26 |  |  | 26 | -4.192307692307693 | -27.25 | 73 | 41 | 0.5616438356164384 | 18 | 127 | 34 | 199 | -165 | 3 | 0.2727272727272727 | 13 | 6.636363636363637 | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 90.9090909090909 | 0 | 90.9090909090909 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 14.10552895675178 | 11 |  | 0 | 0.6123299745549216 | 6.123299745549216 | 2 | 0.04878048780487805 | 0.4878048780487805
[NAME] | BOS | 1 | 4 | 0 | 9 |  |  | 9 | -2.777777777777778 | 0 | 0 | 13 |  | 0 | 25 | 133 | 12 | 121 | 0 | 0 | 3 | 0 | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 269 | 0 | 269 |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 |  |  | 0 |  | 4 | 2 |  | 0 | 0.4615384615384616 | 4.615384615384616 | 0 | 0 | 0
Fannie foul play | BOS | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  | 0
Good Golly Miss Mauly | BOS | 4 | 0 | 29 | 11 |  |  | 11 | -4 | -1.517241379310345 | 102 | 40 | 0.392156862745098 | 58 | 102 | 0 | 145 | -145 | 0 |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 | 3 | 2 |  | 0 | 0.125 | 1.25 | 4 | 0.1 | 1
[NAME] | BOS | 1 | 0 | 0 | 14 |  |  | 14 | -0.5 | 0 | 41 | 14 | 0.3414634146341464 | 0 | 7 | 0 | 165 | -165 | 0 |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 | 0 | 0.1769575281803544 | 4 |  | 0 | 0.2983541091557396 | 2.983541091557396 | 1 | 0.07142857142857142 | 0.7142857142857142
Lolita Gotartly | BOS | 1 | 1 | 1 | 9 |  |  | 9 | -3.333333333333333 | -30 | 0 | 11 |  | 10 | 40 | 111 | 60 | 51 | 1 | 1 | 10 | 0 | 10 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 244 | 0 | 244 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 3 | 0 |  | 0 | 0.2727272727272727 | 2.727272727272727 | 0 | 0 | 0
[NAME] | BOS | 6 | 5 | 28 | 56 |  |  | 56 | -2.714285714285714 | -5.428571428571429 | 182 | 89 | 0.489010989010989 | 79 | 231 | 76 | 459 | -383 | 1 | 0.2 | 24 | 36.4 | 14 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 227.6 | 0 | 227.6 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 22.47509417414309 | 8 |  | 0 | 0.3424167884735179 | 3.424167884735179 | 5 | 0.05617977528089887 | 0.5617977528089888
[NAME] | BOS | 2 | 15 | 0 | 5 |  |  | 5 | -12.76666666666667 | 0 | 73 | 20 | 0.273972602739726 | 23.16666666666667 | 87 | 87 | 149 | -62 | 10 | 0.6666666666666666 | 58 | 4.866666666666666 | 14 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 261.5333333333333 | 0 | 261.5333333333333 |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 8 | 5 |  | 0 | 0.65 | 6.5 | 3 | 0.15 | 1.5
[NAME] | BOS | 3 | 27 | 0 | 1 |  |  | 1 | -78.125 | 0 | 41 | 28 | 0.6829268292682927 | 6.875 | 85 | 32.5 | 217 | -184.5 | 10 | 0.3703703703703703 | 84 | 1.518518518518519 | 15 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 175.8888888888889 | 0 | 175.8888888888889 |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 5.819814671037497 | 4 |  | 0 | 0.3507076668227677 | 3.507076668227677 | 2 | 0.07142857142857142 | 0.7142857142857142
[NAME] | BOS | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  | 0
RollerSlayer | BOS | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  | 0
[NAME] | BOS | 1 | 0 | 0 | 5 |  |  | 5 | -2 | 0 | 73 | 5 | 0.0684931506849315 | 11 | 21 | 0 | 105 | -105 | 0 |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 | 0 | 1 | 0 |  | 0 | 0.2 | 2 | 0 | 0 | 0
[NAME] | BOS | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  | 0
Shelbeast | BOS | 3 | 0 | 4 | 24 |  |  | 24 | -2.041666666666667 | -12.25 | 74 | 28 | 0.3783783783783784 | 34 | 83 | 0 | -16 | 16 | 0 |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 | 16 | 6 |  | 0 | 0.7857142857142857 | 7.857142857142857 | 2 | 0.07142857142857142 | 0.7142857142857142
The Collector | BOS | 1 | 0 | 0 | 12 |  |  | 12 | -2.916666666666667 | 0 | 0 | 12 |  | 0 | 35 | 0 | 28 | -28 | 0 |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  | 3 | 2 |  | 0 | 0.4166666666666667 | 4.166666666666667 | 0 | 0 | 0
Tuesday Welts | BOS | 1 | 0 | 4 | 11 |  |  | 11 | -7.363636363636363 | -20.25 | 0 | 15 |  | 0 | 81 | 0 | 53 | -53 | 0 |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  |  | 0 |  | 4 | 1 |  | 0 | 0.3333333333333333 | 3.333333333333333 | 0 | 0 | 0
ZubNazy | BOS | 1 | 0 | 0 | 11 |  |  | 11 | -4.363636363636363 | 0 | 0 | 11 |  | 0 | 48 | 0 | 29 | -29 | 0 |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  | 3 | 1 |  | 0 | 0.3636363636363636 | 3.636363636363637 | 0 | 0 | 0