Playing with the 2008-2009 Roster

I built a spreadsheet with Excel and imported it into Google Spreadsheets to help calculate the 2008-2009 opening night roster and it's cost. Currently, the Capitals have 14 people signed for next season. This number does not reflect UFAs (currently with Caps and those not) and RFAs.

Directions to use the spreadsheet:

1. Choose to "Edit this spreadsheet" by clicking on the link at the bottom of the page (permissions should be open)
2. To add a player to roster place a "1" next to their name in the "On Roster" column
3. If you're adding an RFA or UFA, be sure to give them a salary that they're worth for next season.
4. Be sure the Roster total number equals between 20 and 23 with rightful position totals represented
5. Keep the salary cap as low as possible AND get the best team

Giving Green a conservative bump to $5.5m and keeping Huet at around $5m, I'm getting a number around $54m which is awfully darn close to the expected salary cap. Will GM be spending that high or will assets need to be "shifted"? It should make for an interesting off-season.

Have fun.

(Thanks to NHLSCAP for the salary data).