Spreadsheet

Current Spreadsheet:

• Download Post-Waiver Draft#2 spreadsheet (last updated Feb. 12)

• Download Post-Waiver Draft#1 spreadsheet (last updated Jan. 15)

• Download Post-Draft spreadsheet (last updated Nov. 27)

• Download Pre-Season spreadsheet (last updated Sep. 22)

Changelog:

Feb. 12

• Updated rosters, pick matrix, etc. after Waiver Draft #2

• Updated GP numbers

• Added a few (re) signings

Feb. 5

• Updated GP numbers

Jan. 15

• Updated GP numbers

• Added a few (re) signings

Dec. 24

• Updated GP numbers

• Fixed keeper status re: Will/Schuts trade

Dec. 4

• Updated rosters, pick matrix, etc. after Waiver Draft #1

• Updated GP numbers

Nov. 27

• Updated GP numbers

• Updated Waiver order

• Added salary updates (Turris)

Nov. 20

• Updated GP numbers

• Added salary updates (contract extensions, etc.)

Nov. 6

• Updated GP numbers

• Added salary updates (contract extensions, etc.)

Oct. 30

• Updated GP numbers

Oct. 23

• Updated GP numbers

Oct. 16

• Updated and corrected GP numbers - numbers should be noticeably more accurate than before

• Added latest salary updates

Oct. 3

• Removed the transaction list. Use the online link instead.

• Fixed draft matrix to reflect Pat/Jesse's final trade.

• Fixed a couple rookie GP numbers.

Oct. 2

• Branched new copy, post-draft

• Added draft picks, updated transaction list

• Added/updated a few salaries (Doughty)

• Updated player columns - added live stats (they should start working next week)

Sep. 22

• Fixed incorrect 3yr-PPG data. Replaced with proper averages.

• Adjusted 2012/2013 draft pick matrix - there will only be 16 draft rounds, not 17.

Sep. 19

• Fixed Keeper status for Rinne & Eriksson

• Fixed formatting and auto-complete problems on Lineups tab

Sep. 18

• Updated keeper rosters, and resulting FA list.

• Updated draft pick ordering after latest trades and supplemental draft picks - see Transactions / Draft Picks tabs.

• Added several contracts/extensions - Note: also added a few guesses for unsigned RFA's and draft picks (ie. Doughty, Turris, Huberdeau, Strome, etc.).

• Added TSN projections and 3-year PPG averages.

• Added 2 sortable columns in the Players tab. One sorts down (A), and the other sorts up (N).

  • You can enter your own information/formulas in these columns and sort your data accordingly.

  • Note: I also have McKeens projections available. I can load them into one of these spare columns and re-issue the spreadsheet, if demand warrants.

  • Note: In the next while, I will provide a few tips for Excel newbies explaining how to fill these columns with your own formulas, based on the data in the other columns (eg. Bang-4-Buck, etc.)

Sep. 8

• Entered pre-season trade transactions

• Updated draft pick ordering - see Transactions / Draft Picks tabs

Sep. 2

• Updated draft pick ordering - see Transactions / Draft Picks tabs

• Entered pre-season trade transactions

• Added 13th team for Lewis. (Let me know if shit's too small to read.)

• Added a sort button for 'Column A' of Players tab

• Added a few contracts/extensions

• Changed Hallman to a different green colour. I'm not sold on this shit yet.

Aug. 18

• Added Parise, Weber, Callahan, + ~60 other new contracts

• Removed a couple dead players

Jul. 20

• Added Stamkos, + ~100 other new contracts

Jul. 10

• • Preliminary 2011-2012 release

Guide:

NOTE: The novarks spreadsheet is heavily dependent on Macros, and thus your copy of Excel must be configured to allow macros to run.

This is what I recommend:

1. Configure the macro security setting to medium.

   1. In Excel 2002 or 2003, you can find this option from the menu: Tools --> Options --> Security --> Macro Security --> 'medium'.

   2. In Excel 2007 or 2010, this option can be found by clicking the top-left 'Office' button, then --> Excel Options --> Trust Center --> Trust Center Settings --> Macro Settings --> 'Disable all macros with notification'

2. You'll be prompted every time you open this spreadsheet: click 'Allow Macros'.

FYI, OpenOffice 'calc' can open the spreadsheet and work fine for the most part, but the macros do not work at all, 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:

    • Custom sortable column (descending sort)

    • 2011/2012 NoVarks salary

    • (GP) NHL Games Played (blank if no longer considered a 'rookie')

  • 2011/2012 points (live - when season starts)

  • 2011/2012 points per game (live - when season starts)

    • Projected 2011/2012 points (TSN)

    • 3-year average PPG (2008 - 2011) points

  • 2010/2011 season points

    • 2009/2010 season points

    • 2012/2013, 2013/2014, 2014/2015 NoVarks salaries

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

    • Custom sortable column (ascending sort)

  • 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.)

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

Keepers:

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

  • 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 with an 'R' to the right of their salary.

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.