clock menu more-arrow no yes mobile

Filed under:

I have a Confession: I Like Spreadsheets

By Andi D.

It's sad but true. I'm a stats junkie, but I have a severe dislike of looking things up twice. So, whenever I do any stat-based research, I stick what I find into a spreadsheet and calculate stuff from there. Needless to say, I've compiled a few. Here are some of the best:

Post-Lockout League Stats (average stats from 2005-06 through 2010-11 for all 1585 NHL players. It literally took a week to compile and killed my last hard drive. I think I may have last edited it sometime in October so the current teams may not be quite right, but control+F should help you find anyone you're looking for.)

Quebec/Colorado Franchise stats (updated last summer - don't miss the tabs at the bottom!)

Post-Lockout Playoff Top 6 Goal Scorers (top 6 goal scorers during the regular season from playoff-bound teams)

2011-12 Injury List (Current through last game)

Ex-Avs (not quite up to date, but a decent list of former Avs and the affects of the Curse)

And of course, my bread and butter, the Current Avalanche Roster (prospects listed under a tab). But if you don't feel like downloading it, here it is broken into two sortable charts for your viewing pleasure. Please note that this chart reflects only the players under contract with the Avs, so prospects that haven't signed yet aren't included.

- 10-11 Avs No. Last Name First Name Pos. Side Team Shot Type Age Height Height (in) Weight
1 5 O'Brien Shane D L Avs L SDD 28 6'-3" 75 230
2 * 44 Wilson Ryan D L Avs L 2-Way 25 6'-1" 73 207
3 8 Hejda Jan D L Avs L SDD 33 6'-4" 76 237
4 * 22 Hunwick Matt D L Avs L PMD 26 5'-11" 71 193
5 * 6 Johnson Erik D R Avs R 2-Way 23 6'-4" 76 232
6 * 3 O'Byrne Ryan D R Avs R SDD 27 6'-5" 77 233
7 46 Elliott Stefan D R Avs R PMD 21 6'-1" 73 180
8 41 Barrie Tyson D R LEM R PMD 20 5'-10" 70 190
9 * 9 Duchene Matt F C Avs L 21 5'-11" 71 200
10 * 26 Stastny Paul F C Avs L 26 6'-0" 72 205
11 * 37 O'Reilly Ryan F C Avs L 21 6'-0" 72 200
12 * 16 McClement Jay F C Avs L 29 6'-1" 73 205
13 92 Landeskog Gabriel F L Avs L 19 6'-1" 73 205
14 11 McGinn Jamie F L Avs L 23 6'-1" 73 210
15 18 Connolly Mike F L Avs L 22 5'-9" 69 180
16 * 40 Olver Mark F L Avs L 24 5'-10" 70 170
17 * 12 Porter Kevin F L Avs L 26 6'-0" 72 190
18 * 55 McLeod Cody F L Avs L 27 6'-2" 74 210
19 * 23 Hejduk Milan F R Avs R 36 6'-0" 72 190
20 * 88 Mueller Peter F R Avs R 23 6'-2" 74 204
21 27 Downie Steve F R Avs R 24 5'-11" 71 191
22 * 54 Jones David F R Avs R 27 6'-2" 74 210
23 17 Kobasew Chuck F R Avs R 29 6'-0" 72 192
24 1 Varlamov Semyon G Avs L 23 6'-2" 74 209
25 35 Giguere Jean-Sebastien G Avs L 34 6'-1" 73 202
26 * 24 Gaunce Cameron D L LEM L SDD 21 6'-1" 73 203
27 2 Chouinard Joel D L LEM L PMD 21 6'-1" 73 186
28 * 4 Liffiton David D L LEM L SDD 27 6'-2" 74 201
29 Richmond Danny D L LEM L 28 6'-1" 73 190
30 Newton Jake D L LEM L SDD 23 6'-3" 75 200
31 38 Hishon Joey F C LEM L 20 5'-10" 70 180
32 47 Brophey Evan F C LEM L 25 6'-2" 74 199
33 42 Malone Brad F L LEM L 22 6'-2" 74 207
34 11 Rissmiller Patrick F L LEM L 33 6'-4" 76 225
35 15 Cohen Zach F L LEM L 25 6'-3" 75 208
36 * 20 Mauldin Greg F L LEM R 29 5'-11" 71 195
37 * 29 Stoa Ryan F L LEM L 24 6'-3" 75 200
38 43 Mercier Justin F L LEM L 24 5'-11" 71 190
39 58 Bordeleau Patrick F L LEM L 25 6'-6" 78 225
40 * 7 Van der Gulik David F R LEM L 28 5'-10" 70 173
41 45 Walker Luke F R LEM R 22 6'-1" 73 174
42 30 Desjardins Cedrick G LEM R 26 6'-0" 72 192
43 31 Cann Trevor G LEM L 22 5'-11" 71 199
44 Sgarbossa Michael F C OHL L 19 5'-11" 71 175
45 * 36 Holos Jonas D R SEL R SDD 24 5'-11" 71 196
46 28 Lindstrom Joakim F L SEL L 28 6'-0" 72 187
47 25 Siemens Duncan D L WHL L SDD 18 6'-3" 75 197
48 64 Pickard Calvin G WHL L 19 6'-1" 73 195

- Last Name Nationality State/ Province DOB D. Year D. Team Pick Exp. Salary Contract 1-Way/2-Way Expiry
1 O'Brien CAN ONT 8/9/83 2003 ANA 250 5 1.1 1 1-Way UFA
2 Wilson CAN ONT 2/3/87 2008 CGY - 2 1.275 1 1-Way RFA
3 Hejda CZE 6/18/78 2003 BUF 106 5 3.25 4 1-Way UFA
4 Hunwick USA MI 5/21/85 2004 BOS 224 4 1.55 1 1-Way UFA
5 Johnson USA MN 3/21/88 2006 STL 1 3 2.6 1 1-Way RFA
6 O'Byrne CAN BC 7/19/84 2003 MTL 79 4 1.8 2 1-Way UFA
7 Elliott CAN BC 1/30/91 2009 COL 49 0 0.79 3 2-Way RFA
8 Barrie CAN BC 7/26/91 2009 COL 64 0 0.615 3 2-Way RFA
9 Duchene CAN ONT 1/16/91 2009 COL 3 2 3.2 1 2-Way RFA
10 Stastny USA QUE 12/27/85 2005 COL 44 5 6.6 3 1-Way UFA
11 O'Reilly CAN ONT 2/7/91 2009 COL 33 2 0.9 1 2-Way RFA
12 McClement CAN ONT 3/2/83 2001 STL 57 6 1.45 1 1-Way UFA
13 Landeskog SWE 11/23/92 2011 COL 2 0 3.575 3 2-Way RFA
14 McGinn CAN ONT 8/5/88 2006 SJS 36 4 0.68 1 2-Way RFA
15 Connolly CAN ALB 7/3/89 2011 SJS - 0 0.9 2 2-Way RFA
16 Olver CAN BC 1/1/88 2008 COL 140 1 0.585 1 2-Way RFA
17 Porter USA MI 3/12/86 2005 PHX 119 3 0.85 1 1-Way RFA
18 McLeod CAN MTB 6/26/84 2006 COL - 4 1.0333 1 1-Way UFA
19 Hejduk CZE 2/14/76 1994 QUE 87 12 2.6 1 1-Way UFA
20 Mueller USA MN 4/14/88 2006 PHX 8 3 1.5 1 1-Way RFA
21 Downie CAN ONT 4/3/87 2005 PHI 29 5 1.85 1 1-Way RFA
22 Jones CAN BC 8/8/84 2003 COL 288 4 2.5 1 1-Way UFA
23 Kobasew CAN BC 4/17/82 2001 CGY 14 8 1.25 2 1-Way UFA
24 Varlamov RUS 4/27/88 2006 WSH 23 3 2.8333 3 1-Way RFA
25 Giguere CAN QUE 5/16/77 1995 HFD 13 13 1.25 2 1-Way UFA
26 Gaunce CAN ONT 3/19/90 2008 COL 50 1 0.6875 2 2-Way RFA
27 Chouinard CAN QUE 4/8/90 2008 COL 167 0 0.575 2 2-Way RFA
28 Liffiton CAN ONT 10/18/84 2003 COL 63 3 0.525 1 2-Way UFA
29 Richmond USA IL 1/8/84 2003 CAR 31 4 0.525 1 2-Way UFA
30 Newton USA CA 9/22/88 2010 ANA - 0 0.9 1 2-Way RFA
31 Hishon CAN ONT 10/20/91 2010 COL 17 0 0.9 3 2-Way RFA
32 Brophey CAN ONT 12/3/86 2005 CHI 68 0 0.5 1 2-Way UFA
33 Malone CAN NBR 5/20/89 2007 COL 105 0 0.6 2 2-Way RFA
34 Rissmiller USA MA 10/26/78 2002 SJS - 5 0.525 1 2-Way UFA
35 Cohen USA IL 2/6/87 2010 COL - 0 0.575 1 2-Way RFA
36 Mauldin USA MA 6/10/82 2002 CBJ 199 2 0.525 1 2-Way UFA
37 Stoa USA MN 4/13/87 2005 COL 34 2 0.8033 1 2-Way RFA
38 Mercier USA PA 6/25/87 2005 COL 168 1 0.525 1 2-Way RFA
39 Bordeleau CAN QUE 3/23/86 2004 MIN 114 0 0.525 1 2-Way RFA
40 Van der Gulik CAN BC 4/20/83 2002 CGY 206 2 0.525 1 2-Way UFA
41 Walker USA CT 2/19/90 2010 COL 139 0 0.575 2 2-Way RFA
42 Desjardins CAN NBR 9/30/85 2006 CHI - 0 0.525 1 2-Way RFA
43 Cann CAN ONT 3/30/89 2007 COL 49 0 0.6125 1 2-Way RFA
44 Sgarbossa CAN ONT 7/25/92 2011 SJS - 0 0.555 3 2-Way RFA
45 Holos NOR 8/27/87 2008 COL 170 1 0.785 1 2-Way RFA
46 Lindstrom SWE 12/5/83 2002 CBJ 41 4 0.6 1 1-Way UFA
47 Siemens CAN ALB 9/7/93 2011 COL 11 0 1.35 3 2-Way RFA
48 Pickard CAN NBR 4/15/92 2010 COL 49 0 0.79 3 2-Way RFA