Spreadsheet: 232305d1367381338-toggling-between-datasets-compare-players-example
Sheet: Data Sets

1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 0.6666666666666666 | 1.138888888888889 | 1.555555555555556 | 0.725 | 1.17948717948718 | 2.5 | 0.9210526315789473 | 0.35 | 0.3888888888888889 | 0.1578947368421053 | 4.45
 |  |  |  |  |  | 2012/13 Raw Data |  |  |  |  |  |  |  |  |  |  |  | Per Game |  |  |  |  |  |  |  |  |  |  |  | Player Rating
Ref # | Player | Position | Team | Status | Ref # | GP | G | A | PTS | +/- | PIM | Hits | BLKS | PPG | PPA | GWG | SOG | G | A | PTS | +/- | PIM | Hits | BLKS | PPG | PPA | GWG | SOG | PR | PR/G | G | A | PTS | +/- | PIM | Hits | BLKS | PPG | PPA | GWG | SOG
1 | [NAME] | C | PIT | MUST | 1 | 36 | 15 | 41 | 56 | 26 | 16 | 21 | 18 | 3 | 14 | 1 | 124 | 0.4166666666666667 | 1.138888888888889 | 1.555555555555556 | 0.7222222222222222 | 0.4444444444444444 | 0.5833333333333334 | 0.5 | 0.08333333333333333 | 0.3888888888888889 | 0.02777777777777778 | 3.444444444444445 | 6.266001848594161 | 6.962224276215735 | 0.6250000000000001 | 1 | 1 | 0.9961685823754789 | 0.3768115942028985 | 0.2333333333333333 | 0.5428571428571428 | 0.2380952380952381 | 1 | 0.1759259259259259 | 0.7740324594257179
2 | [NAME] | C | TAM | FF | 2 | 39 | 26 | 24 | 50 | -5 | 28 | 55 | 16 | 9 | 7 | 2 | 132 | 0.6666666666666666 | 0.6153846153846154 | 1.282051282051282 | -0.1282051282051282 | 0.717948717948718 | 1.41025641025641 | 0.4102564102564102 | 0.2307692307692308 | 0.1794871794871795 | 0.05128205128205128 | 3.384615384615385 | 5.861847722147617 | 6.012151509894992 | 1 | 0.5403377110694184 | 0.8241758241758242 | -0.1768346595932803 | 0.6086956521739131 | 0.5641025641025641 | 0.4454212454212454 | 0.6593406593406594 | 0.4615384615384615 | 0.3247863247863248 | 0.7605877268798616
3 | [NAME] | RW | TAM | HIT | 3 | 39 | 9 | 40 | 49 | -1 | 12 | 18 | 23 | 3 | 15 | 2 | 90 | 0.2307692307692308 | 1.025641025641026 | 1.256410256410256 | -0.02564102564102564 | 0.3076923076923077 | 0.4615384615384616 | 0.5897435897435898 | 0.07692307692307693 | 0.3846153846153846 | 0.05128205128205128 | 2.307692307692307 | 5.028055635005971 | 5.156980138467662 | 0.3461538461538462 | 0.900562851782364 | 0.8076923076923077 | -0.03536693191865606 | 0.2608695652173913 | 0.1846153846153846 | 0.6402930402930403 | 0.2197802197802198 | 0.989010989010989 | 0.3247863247863248 | 0.5185825410544511
4 | [NAME] | C/RW | CHI | PSY | 4 | 39 | 20 | 26 | 46 | 15 | 4 | 9 | 7 | 8 | 6 | 2 | 114 | 0.5128205128205128 | 0.6666666666666666 | 1.17948717948718 | 0.3846153846153846 | 0.1025641025641026 | 0.2307692307692308 | 0.1794871794871795 | 0.2051282051282051 | 0.1538461538461539 | 0.05128205128205128 | 2.923076923076923 | 4.856300371620556 | 4.980820893969801 | 0.7692307692307692 | 0.5853658536585366 | 0.7582417582417582 | 0.5305039787798409 | 0.08695652173913043 | 0.09230769230769231 | 0.1948717948717949 | 0.5860805860805861 | 0.3956043956043956 | 0.3247863247863248 | 0.6568712186689715
5 | [NAME] | LW | PIT | SVB | 5 | 40 | 20 | 26 | 46 | 29 | 39 | 90 | 11 | 8 | 5 | 5 | 87 | 0.5 | 0.65 | 1.15 | 0.725 | 0.975 | 2.25 | 0.275 | 0.2 | 0.125 | 0.125 | 2.175 | 7.258507139424455 | 7.258507139424455 | 0.75 | 0.5707317073170732 | 0.7392857142857142 | 1 | 0.8266304347826087 | 0.9 | 0.2985714285714286 | 0.5714285714285715 | 0.3214285714285714 | 0.7916666666666667 | 0.4887640449438201
6 | [NAME] | LW/RW | WAS | MUST | 6 | 40 | 26 | 18 | 44 | 2 | 30 | 100 | 18 | 14 | 7 | 4 | 178 | 0.65 | 0.45 | 1.1 | 0.05 | 0.75 | 2.5 | 0.45 | 0.35 | 0.175 | 0.1 | 4.45 | 7.354004652725902 | 7.354004652725902 | 0.9750000000000001 | 0.3951219512195122 | 0.7071428571428572 | 0.06896551724137931 | 0.6358695652173912 | 1 | 0.4885714285714286 | 1 | 0.45 | 0.6333333333333334 | 1
7 | [NAME] | C | ANA | SVB | 7 | 38 | 13 | 30 | 43 | 14 | 37 | 75 | 35 | 3 | 9 | 2 | 86 | 0.3421052631578947 | 0.7894736842105263 | 1.131578947368421 | 0.3684210526315789 | 0.9736842105263158 | 1.973684210526316 | 0.9210526315789473 | 0.07894736842105263 | 0.2368421052631579 | 0.05263157894736842 | 2.263157894736842 | 6.396775642001259 | 6.733448044211852 | 0.5131578947368421 | 0.693196405648267 | 0.7274436090225563 | 0.5081669691470054 | 0.8255148741418764 | 0.7894736842105263 | 1 | 0.2255639097744361 | 0.6090225563909774 | 0.3333333333333333 | 0.5085748078060319
8 | [NAME] | C/LW | CAR | LL | 8 | 39 | 16 | 26 | 42 | 6 | 46 | 32 | 22 | 2 | 5 | 4 | 123 | 0.4102564102564102 | 0.6666666666666666 | 1.076923076923077 | 0.1538461538461539 | 1.17948717948718 | 0.8205128205128205 | 0.5641025641025641 | 0.05128205128205128 | 0.1282051282051282 | 0.1025641025641026 | 3.153846153846154 | 5.733401399758173 | 5.880411692059664 | 0.6153846153846154 | 0.5853658536585366 | 0.6923076923076923 | 0.2122015915119363 | 1 | 0.3282051282051282 | 0.6124542124542125 | 0.1465201465201465 | 0.3296703296703296 | 0.6495726495726496 | 0.7087294727744166
9 | [NAME] | C | NYI | LEO | 9 | 40 | 24 | 18 | 42 | -5 | 16 | 25 | 17 | 9 | 7 | 4 | 133 | 0.6 | 0.45 | 1.05 | -0.125 | 0.4 | 0.625 | 0.425 | 0.225 | 0.175 | 0.1 | 3.325 | 5.321648651753676 | 5.321648651753676 | 0.9 | 0.3951219512195122 | 0.675 | -0.1724137931034483 | 0.3391304347826087 | 0.25 | 0.4614285714285714 | 0.6428571428571429 | 0.45 | 0.6333333333333334 | 0.7471910112359551
10 | Nicklas Backstrom | C | WAS | PSY | 10 | 40 | 6 | 36 | 42 | 8 | 18 | 25 | 29 | 2 | 14 | 1 | 66 | 0.15 | 0.9 | 1.05 | 0.2 | 0.45 | 0.625 | 0.725 | 0.05 | 0.35 | 0.025 | 1.65 | 4.956747560722243 | 4.956747560722243 | 0.225 | 0.7902439024390244 | 0.675 | 0.2758620689655172 | 0.3815217391304348 | 0.25 | 0.7871428571428571 | 0.1428571428571429 | 0.8999999999999999 | 0.1583333333333334 | 0.3707865168539325
11 | [NAME] | LW | EDM | DOMI | 11 | 37 | 13 | 28 | 41 | 3 | 29 | 21 | 15 | 4 | 9 | 3 | 127 | 0.3513513513513514 | 0.7567567567567568 | 1.108108108108108 | 0.08108108108108109 | 0.7837837837837838 | 0.5675675675675675 | 0.4054054054054054 | 0.1081081081081081 | 0.2432432432432433 | 0.08108108108108109 | 3.432432432432432 | 5.149096624171571 | 5.566590945050346 | 0.5270270270270271 | 0.6644693473961767 | 0.7123552123552124 | 0.1118359739049394 | 0.6645123384253819 | 0.227027027027027 | 0.4401544401544402 | 0.3088803088803089 | 0.6254826254826255 | 0.5135135135135136 | 0.7713331308836927
12 | [NAME] | C | CHI | LEO | 12 | 39 | 19 | 21 | 40 | 23 | 23 | 19 | 13 | 2 | 3 | 4 | 118 | 0.4871794871794872 | 0.5384615384615384 | 1.025641025641026 | 0.5897435897435898 | 0.5897435897435898 | 0.4871794871794872 | 0.3333333333333333 | 0.05128205128205128 | 0.07692307692307693 | 0.1025641025641026 | 3.025641025641026 | 5.271762311108472 | 5.406935703700997 | 0.7307692307692308 | 0.4727954971857411 | 0.6593406593406592 | 0.8134394341290894 | 0.5 | 0.1948717948717949 | 0.3619047619047619 | 0.1465201465201465 | 0.1978021978021978 | 0.6495726495726496 | 0.6799193316047248
13 | [NAME] | RW | TOR | LEO | 13 | 40 | 14 | 26 | 40 | -1 | 16 | 10 | 19 | 4 | 11 | 3 | 138 | 0.35 | 0.65 | 1 | -0.025 | 0.4 | 0.25 | 0.475 | 0.1 | 0.275 | 0.075 | 3.45 | 4.902088853783968 | 4.902088853783968 | 0.525 | 0.5707317073170732 | 0.6428571428571428 | -0.03448275862068965 | 0.3391304347826087 | 0.1 | 0.5157142857142857 | 0.2857142857142858 | 0.7071428571428572 | 0.475 | 0.7752808988764045
14 | Nazem Kadri | C/LW | TOR | PSY | 14 | 40 | 17 | 23 | 40 | 17 | 19 | 52 | 17 | 5 | 3 | 1 | 91 | 0.425 | 0.575 | 1 | 0.425 | 0.475 | 1.3 | 0.425 | 0.125 | 0.075 | 0.025 | 2.275 | 4.975157339311787 | 4.975157339311787 | 0.6375000000000001 | 0.5048780487804878 | 0.6428571428571428 | 0.5862068965517241 | 0.4027173913043478 | 0.52 | 0.4614285714285714 | 0.3571428571428572 | 0.1928571428571428 | 0.1583333333333334 | 0.5112359550561797
15 | [NAME] | RW | PHI | CCV | 15 | 39 | 17 | 22 | 39 | -8 | 27 | 16 | 10 | 8 | 8 | 2 | 101 | 0.4358974358974359 | 0.5641025641025641 | 1 | -0.2051282051282051 | 0.6923076923076923 | 0.4102564102564102 | 0.2564102564102564 | 0.2051282051282051 | 0.2051282051282051 | 0.05128205128205128 | 2.58974358974359 | 4.444858337430745 | 4.558829064031533 | 0.6538461538461539 | 0.4953095684803002 | 0.6428571428571428 | -0.2829354553492485 | 0.5869565217391304 | 0.1641025641025641 | 0.2783882783882783 | 0.5860805860805861 | 0.5274725274725275 | 0.3247863247863248 | 0.581964851627773
16 | [NAME] | LW | NYI | SVB | 16 | 39 | 13 | 26 | 39 | -7 | 4 | 22 | 22 | 7 | 7 | 0 | 131 | 0.3333333333333333 | 0.6666666666666666 | 1 | -0.1794871794871795 | 0.1025641025641026 | 0.5641025641025641 | 0.5641025641025641 | 0.1794871794871795 | 0.1794871794871795 | 0 | 3.358974358974359 | 4.031518633276245 | 4.134890905924354 | 0.5 | 0.5853658536585366 | 0.6428571428571428 | -0.2475685234305924 | 0.08695652173913043 | 0.2256410256410256 | 0.6124542124542125 | 0.5128205128205129 | 0.4615384615384615 | 0 | 0.7548256986459233
17 | P-A Parenteau | RW | COL | CCV | 17 | 40 | 15 | 24 | 39 | -9 | 34 | 44 | 10 | 5 | 7 | 1 | 91 | 0.375 | 0.6 | 0.975 | -0.225 | 0.85 | 1.1 | 0.25 | 0.125 | 0.175 | 0.025 | 2.275 | 4.314563045866175 | 4.314563045866175 | 0.5625 | 0.526829268292683 | 0.6267857142857143 | -0.3103448275862069 | 0.7206521739130435 | 0.4400000000000001 | 0.2714285714285714 | 0.3571428571428572 | 0.45 | 0.1583333333333334 | 0.5112359550561797
18 | [NAME] | C | WAS | CCV | 18 | 40 | 12 | 26 | 38 | -4 | 43 | 43 | 24 | 6 | 13 | 1 | 55 | 0.3 | 0.65 | 0.95 | -0.1 | 1.075 | 1.075 | 0.6 | 0.15 | 0.325 | 0.025 | 1.375 | 5.217964385119424 | 5.217964385119424 | 0.45 | 0.5707317073170732 | 0.6107142857142857 | -0.1379310344827586 | 0.9114130434782608 | 0.43 | 0.6514285714285715 | 0.4285714285714286 | 0.8357142857142857 | 0.1583333333333334 | 0.3089887640449438
19 | [NAME] | C | VAN | ORPH | 19 | 40 | 11 | 27 | 38 | 19 | 20 | 17 | 8 | 1 | 9 | 1 | 66 | 0.275 | 0.675 | 0.95 | 0.475 | 0.5 | 0.425 | 0.2 | 0.025 | 0.225 | 0.025 | 1.65 | 4.261245377145042 | 4.261245377145042 | 0.4125 | 0.5926829268292684 | 0.6107142857142857 | 0.6551724137931034 | 0.4239130434782609 | 0.17 | 0.2171428571428572 | 0.07142857142857144 | 0.5785714285714286 | 0.1583333333333334 | 0.3707865168539325
20 | Pavel Datsyuk | C | DET | CCV | 20 | 38 | 13 | 25 | 38 | 13 | 14 | 20 | 28 | 7 | 6 | 6 | 85 | 0.3421052631578947 | 0.6578947368421053 | 1 | 0.3421052631578947 | 0.3684210526315789 | 0.5263157894736842 | 0.7368421052631579 | 0.1842105263157895 | 0.1578947368421053 | 0.1578947368421053 | 2.236842105263158 | 5.665252141624839 | 5.963423306973514 | 0.5131578947368421 | 0.5776636713735559 | 0.6428571428571428 | 0.4718693284936479 | 0.3123569794050343 | 0.2105263157894737 | 0.7999999999999999 | 0.5263157894736842 | 0.4060150375939849 | 1 | 0.5026611472501479