Spreadsheet Info

Current Spreadsheet:

Current Spreadsheet (updated Mar. 3)

Pre-trade-deadline Spreadsheet (updated Feb. 18)

Post-waiver2 Spreadsheet (updated Jan. 18)

Post-waiver1 Spreadsheet (updated Nov. 21)

Post-draft Spreadsheet (updated Oct. 16)

Pre-draft Spreadsheet (updated Oct. 1)

Pre-season Spreadsheet (updated Sep. 6)

Changelog:

Mar. 3

• Updated games played info as of Mar 3.

• Updated team rosters to reflect changes from the Trade Window.

• Updated draft pick matrix.

Feb. 19

• Fixed problem with stat-updates

• Updated games played info as of Feb 19.

• Minor formatting changes to the Lineup tab

Jan. 18

• Updated team rosters to reflect changes from Waiver Draft #2

• Updated draft pick matrix

• Updated games played info as of Jan 18.

Jan. 8

• Updated games played info as of Jan 8.

• Added a tab showing the lineups in the rounds where players were actually picked. This is for informational purposes only, and may not be 100% accurate.

Nov. 21

• Updated a team rosters after Waiver #1

• Updated draft pick matrix and Waiver #2 draft-order

Nov. 12

• Updated a few contracts, added a few players.

• Adjusted Jack Campbell's salary to $700k from $900k (increasing Schuts' cap room by $200k)

Oct. 16

• Added live 2010/2011 stats

• Updated a few contracts, added a few players.

• Updated games played (for 'Rookies') as of Oct. 16 (Note: this does not update 'live')

• Removed the transaction tab. See here instead.

Oct. 2

• [2nd update] Added games played back to Lineups page.

• [2nd update] Changed the Projections to be the average of: TSN, ESPN, Dobber, 3yr pts-avg. (These are more complete projections.)

• Added full rosters and draft listing / transactions

Oct. 1

• Added colouring to the 'players' tab for injured players.

Sep. 30

• Added a few more contracts (pretty well up to date)

• Cleaned out the FA's (they show up at the bottom instead of the top now)

Sep. 19

• Added keepers

Sep. 15 (salarycap_10_sep.xls)

• Added all trades upto trade deadline

• Added NHL Games Played (see Players tab)

• Added TSN 2010/2011 projections and 3-year PPG average (see Players tab)

Sep. 6

• Added 2 new trades

Sep. 5

• • Updated with new draft order

  • Updated off-season trades

  • Added new salaries

Aug. 1 (salarycap_10_pre.xls)

• • Initial 2010-2011 release

Guide:

NOTE: If prompted when opening the spreadsheet, you must click 'Allow Macros' in order to enable full functionality.

If any of the below features do not work as explained, this is likely the reason..

Also, OpenOffice 'calc' can open the spreadsheet and work fine for the most part, but the macros do not work, so many features do not work.

I have a copy of Excel XP (2002) if anyone needs this, let me know. This is what I use, although the spreadsheet will work fully with any version of Excel, 2002 or newer.

Sortable player columns:

• • Go to the 'Players' tab - note the buttons frozen to the top row of the spreadsheet.

  • Use the left-most buttons to sort players by:

    • 2010/2011 NoVarks salary

    • 2010/2011 points (live)

    • 2010/2011 points per game (live)

    • Projected 2010/2011 points (???)

    • 3-year average (2007 - 2010) points

    • 2009/2010 season points

    • 2011/2012, 2012/2013 NoVarks salaries

    • Free Agent (blue) / Taken players (green)

  • Players are always grouped by position: D/F/G.

  • Use the right-most buttons to jump from group to group Defence/Forwards/Goalies:

  • Use the stat 'Update' button to retrieve live statistics throughout the season.

  • Enable 'Auto' stat updates to automatically retrieve statistics each time the spreadsheet is opened.

Roster worksheet:

• Go to the 'Lineups' tab

• In any of the rosters, DOUBLE-click directly to the right of the round number.

• Start typing the surname of a player until the spreadsheet 'auto-completes' the name of the player you're looking for and press ENTER.

• Notice the player's position and salary automatically fill in to the right of the players name.

• To delete or replace a player in a roster, SINGLE-click the players name and press the DELETE key.

• Notice the information below the roster automatically updates (cap space used/remaining, positions filled, etc.)

• Do not type in any of the other cells.

• Hover over salary cell to show the next 3 year's salary info:

Keepers:

• • This information will also be available in the 'Lineups' tab

  • Keeper players will be identified in BOLD text.

  • The 'contract year' for each keeper player will be noted to the right of that player's salary (ie. 2,3 or 4 - players in first year have not been 'kept' yet, and therefore aren't yet identified as keepers)

  • The number of games played by a 'Rookie' are shown in the same column.

    • The color scheme is described at the bottom of this tab.

    • 'Rookie Keepers' are indicated in BOLD.

Draft Pick Matrix:

• • Go to the 'Draft Picks' tab

  • Draft matrix is shown for 2 seasons in advance.

  • If picks are traded, the changes will be reflected in these matrices.

  • This matrix determine the future draft order(s), working from top to bottom for each round.

Transaction List:

• Go to the 'Transaction' tab to view:

  • Draft picks

  • Trades

  • Waiver moves

  • Roster moves