Draft workbook
The offline half of the draft room. A board you type picks into on a second screen, with best-available, VORP against replacement level, position scarcity, the ledger, every roster, the standings and the pick log all recalculating as you go — with no network connection at all, which matters more than it sounds: draft night is exactly when a site you depend on is least likely to be the thing you want to depend on.
Build history
What has changed in the workbook itself. Every build is made fresh when you click, so you always get the newest — older builds are described here rather than stored.
- 2026-08-18technicalThe Draft sheet is the whole night
Available and Ledger folded onto the Draft sheet, so nothing about a pick needs a sheet flip: the entry rail on the left, forty best-available with every category the league counts beside it, the ledger on the right, the best man left at each position, and your roster filling itself in at your snake positions. Frozen panes keep the strip and the rail on screen while the list scrolls.
- 2026-08-17technicalPicks are entered in one place, and the board follows
The grid used to be the input, so the cell to type in walked diagonally as the snake turned and best-available was on another sheet — a hunt on every pick. Entry moved to a Draft sheet: one column, rows pre-labelled with the round, pick and team, the current row lit up, who is on the clock in a strip above it, and the top 25 available beside it. The Board became a picture of that list. Value and VORP now carry a colour scale, positions a fixed hue each, and Available shows games played.
- 2026-08-17technicalVORP, position scarcity, and drafted men struck out
Added a Scarcity sheet: replacement level per position (teams × starters), the cliff below the best man left, and how many are gone. VORP on Players and Available scores each man against his own position's replacement, which is what makes a centre and a defenceman comparable. Drafted players now grey out and strike through everywhere, and the Players sheet is filterable so they can be hidden outright.
- 2026-08-17technicalThe workbook reads your own projections
draft-kit.xlsx accepts a saved projection set. Edits are overlaid and the pool re-scored, so the board ranks by the numbers the file actually shows.
- 2026-08-17technicalLedger, rosters, standings and log
The workbook gained the four views the draft portal has, as live formulas — the offline file is now the same tool rather than a subset of it.
- 2026-08-17projectionThree penalty-kill units, and forward lines held to last season
The kill is three units of two forwards and two defencemen, tiered 2.35 / 1.67 / 1.00 minutes. Forward lines now hold to last season's even-strength deployment unless a man is new to the club, so a returning forward keeps his role.