Great spreadsheet!! It's very helpful.
Only correction that I can make is for Johansen in 2017-18. He's arbitration eligible. I think it's safe to assume that he'll be on the books that year for $7m or more one way or another (arbitration or long term deal).
I can remember the protestations of many that the CBJ "weren't a cap team".
To really move off of the bubble, a top player will have to be shipped along with a bad contract. Among the forwards, Dubinsky, Jenner and Saad probably have the most trade value at this point. Among dmen, I'd think everybody would be on the table, including Murray.
Clarkson, Tyutin, Bob, and Foligno would probably all have to be considered "bad contracts" which would require parting with a value asset ("good contract", prospects, or picks) in order to move. Clarkson, of course, can't be moved nor can he be bought out for all intents and purposes.
While the narrative is that Hartnell would be hard to move, I'm not so sure about that. He's a $4.75 cap hit, but after next year's $5m cash payout, he's due only $3.75m on average over his last 2 years. He's still very effective and would probably be a deadline deal candidate for this season. If some team felt that he were the missing piece of a possible Cup run, then he's very moveable. He'll be effective next year most likely and if a team had to buy him out for his last season, it wouldn't be very painful if he helped them this season and next.
Front office incompetence is coming home to roost with respect to the cap. The absolutely unforgivable failure to insure Horton's contract has placed 7% of the cap in a completely non-performing asset. The failure to lock up Johansen at approximately $6 million will start impacting the cap after next season. Johansen's trade value would be immense if he were locked into four more years at what would have been fair market value when he held out. Starting in 2017-18, it's a $2 to $2.5 million per year mistake if he is signed to a long term deal. The additional $2 million per year over the past two seasons would not have harmed the CBJs cap positions.
The failure to sign Bob longer term right after his Vezina when he was an RFA probably amounts to a $1.5 million per year mistake as well. The childish need to flex CBA leverage with the elite RFAs (Bob and Joey) backfired badly. It ended up costing cap room when it was desperately needed and didn't use the room which was readily available at the time of each contract's signing. Nice strategy, JD and Jarmo!
All told, approximately $7-9 million of extra payroll could be open starting next season had the FO operated competently. Approximately 10-12% of the cap is now gone thanks to their egregious errors. Any trades will now be from a position of weakness rather than strength.