Spreadsheet Info

Current Spreadsheet (updated Mar. 7)

Archives:

Pre-Waiver 2 Spreadsheet (updated Jan. 24)

Mid-season Spreadsheet (updated Jan. 1)

Post-Waiver 1 Spreadsheet (updated Nov. 29)

Pre-Waiver 1 Spreadsheet (updated Nov. 20)

Opening-day Spreadsheet (updated Oct. 18)

Pre-season Spreadsheet (updated Sep. 26)

Changelog:

Mar 7

• Updated Transactions tab, cleaned up Olympic Pool tab.

Feb 16

• Added selections for Olympic Pool

Feb 1

• Updated rosters after waiver draft 2. See 'Draft Picks' tab & 'Transactions' for full details.

• Updated Olympic rosters

Jan 24

• Added a couple new salaries

• Changed 'Lineup' tab to show eligible rookies (games played as of Jan 21). Added team colours to the rosters to look pretty.

• Added a copy of roster in a separate tab to show Olympic reps.

Jan 1

• Updated transaction lists and a few recent salaries

• Marked the roster page with Olympic representatives

Dec 18

• Updated many free-agent salaries according to www.capgeek.com

• Added 3-year sortable salary data

Nov 29

• Updated rosters after waiver draft 1. Note the changes in the 'Draft Picks' tab.

Nov 20

• Spelling corrections and roughly 10 new players added

Nov 5

• Automatic stats update when opening spreadsheet. (Uncheck the 'Auto Update' checkbox to disable this)

• Added current points to lineup sheet. These are absolute points only - they don't consider bench players, trades, etc. Use PoolExpert for official standings.

Nov 2

• Fixed sort buttons

Nov 1

• Added 09/10 stats

• Added blue coloring for free agents, green coloring for taken players.

• Added a button to update current season stats.

• Added sort button for Free Agent vs. taken

• Added about 10 new/missed salaries

Oct 18

• Added about 30 new/missed salaries

Oct 6

• Added Moore, Afinogenov, Lang, Sydor, Niedermeyer, Malholtra, etc.

Sept 20

• Added Kessel, Dubinsky, Sykora, Seidenberg

Sept 14

• • Added a few new contracts (Stafford, Comrie, etc.)

  • Updated 09/10 salaries for bought-out players with new contracts (ie. Prospal). Added clause 11a. to the Charter to clarify how buyouts affect NoVarks salaries.

Sept 9

• • Added about 50 missed salaries

  • Added about 30 new guys (rookies, or guys from europe)

  • Deleted a bunch of retirees / euro exports

  • Added projected points for F/D. New sortable column in 'Players' tab.

  • Moved Byfuglien from a D to F (was a mistake carried over from last year)

Sept 5

• • Fixed sort buttons on 'Players' tab.

  • Added about 20 new salaries

Sept 1

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

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:

    • 09/10 NoVarks salary

    • 09/10 points

    • 09/10 Pool Points per Game

    • Projected 09/10 points (McKeens)

    • 3-year average (06 - 09) points

    • 08/09 season points

    • 2010, 2011 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

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.

Keepers:

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

  • Keeper players will be identified in BOLD text and a shaded background

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

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.

  • In future drafts, we will use this to determine the draft order.

    • Working from top to bottom for each round.

    • ie. the draft order in the sample would be Rnd1: NW, AS, PC, JM, DE, JL (from SH), CJ, GM, JD, JL, WK, SL. Rnd2: NW, AS, PC...