2013/2014 Roster Submission [Wednesday, Sept 25]

[MSP4LYFE]

Vancouver Canucks Roster Submission for Week 1:

https://docs.google.com/spreadsheet/ccc ... nU2c#gid=2

To be Waived: Kris Newbury

Spent before relief: $59,123,000
LTIR Relief: $0
Total Spent: $59,123,000
Cap Space: $5,177,000
Space from Floor: $15,123,000

Total Contracts: 42
Total Players: 56

[kyuss]

NSH: still missing a bunch of DOBs

Done, added those BODs missing for non-contracted players

[shooker]

Would there be any issues linking to a player page, as I have it in my spreadsheet? (IE, click a player name and it takes you to their Elite Prospects page )

https://spreadsheets.google.com/pub?key ... utput=html

I do the same thing. Player names linked to their NHL.com profile or for prospects linked to HF profile, I also have their cap hits linked to cap geek. My spreadsheet is linked and formula'd to the tits. I spent a lot of time on it this offseason.

[Shoalzie]

Newbury will go on waivers at noon. I'm still waiting on the other rosters to be official for their players to be waived. I'd have to imagine they'd have to go on by Tuesday.

[MSP4LYFE]

Sorry for the late submission Scott, I didn't have time to do it any sooner because of work.

[thom54]

https://docs.google.com/spreadsheet/ccc ... NUnc#gid=3

WSH all DOB up to date. Lineup done. Week1 done. Work's been nuts.

Spent before relief: $65,522,000
LTIR Relief: $1,667,000
Total Spent: $63,855,000
Cap Space: $445,000
Space from Floor: $19,855,000

Total Contracts: 32
Total Players: 46

[Shoalzie]

Sorry for the late submission Scott, I didn't have time to do it any sooner because of work.

It happens. The submission stuff is Mike's baby...the waiver wire and draft pick are my duties.

[Lee]

Hey Mike, can you walk me through the process of completing a trade on the new spreadsheet? I need to remove Khokhlachev, Backlund and Reinhart and add Gagner. Should I clear those players rows and add a new spot for Gagner at the bottom?

[Chuck Norris]

Hey Mike, can you walk me through the process of completing a trade on the new spreadsheet? I need to remove Khokhlachev, Backlund and Reinhart and add Gagner. Should I clear those players rows and add a new spot for Gagner at the bottom?

Go in and manually delete the data from Columns A-G and then add in Gagner's info to any empty slot and assigned him a role. If you like a clean sheet with no gaps then copy/paste the data from A-G accordingly. Dont touch any other columns other than those or else you fuck up the sheet!

[Mike]

Chuck's advice is pretty sound. I like to sort by 5 criteria (and every time I update the template your teams will be sorted by this) which is, by priority:

Position: C - W - D - G
Waiver eligibility: Yes, No
Cap hit: High - low
DOB: old - young
GP: high - low

I do this by copy + pasting the data into excel (since google won't let you sort with that specificity).

[Lee]

Awesome, thanks guys. Would you mind checking my sheet to make sure I have it set up properly in terms of making sure Vokoun is on IR and Gagner is LTIR with proper replacements ( Booth and Zatkoff) ?

[Mike]

DId you trade for Booth just recently? Only players who are not already on your roster can be used as LTIR replacements. That means recent acquisitions be it through trade or waiver pickup or promotion from minors.

[Lee]

DId you trade for Booth just recently? Only players who are not already on your roster can be used as LTIR replacements. That means recent acquisitions be it through trade or waiver pickup or promotion from minors.

Really ? Has it always been like that? Mr Bruins has Mikael Samuelsson listed as an LTIR replacement. Also, define recent. I traded for him on July 17th.

[Mike]

DId you trade for Booth just recently? Only players who are not already on your roster can be used as LTIR replacements. That means recent acquisitions be it through trade or waiver pickup or promotion from minors.

Really ? Has it always been like that? Mr Bruins has Mikael Samuelsson listed as an LTIR replacement. Also, define recent. I traded for him on July 17th.

Yes, it has always been like that.

Re Mr. Bruin/samuelsson: I told him the same thing.

Recency: we do not have a specific date for off season, though going back to July 17th would certainly violate the spirit of the rule. I suggest a common sense approach would be to say anyone acquired between roster submission and week 1 submission would be eligible.

[Lee]

By the same token, Matt Irwin, Victor Bartley, or Markstrom shouldn't be able to be used as replacements, no?

[Mike]

They all waiver exempt? If so yep.

[Mike]

Also if you want to make 4 people replacements for one you can do that, I didn't build that in nicely to the spreadsheet because the sheet would get rather long. Just put the 4th as REL4 and it'll look like he's replacing nobody, but his salary will get discounted. Not pretty but it'll work.

[Lee]

Ok, makes it a bit more understandable. I'll replace Booth with Huberdeau, and assume that I don't have to send Huberdeau to the minors once Gagner is back?

[Mike]

Ok, makes it a bit more understandable. I'll replace Booth with Huberdeau, and assume that I don't have to send Huberdeau to the minors once Gagner is back?

Nope just need to remove him as a REL and count his salary.

[Nick]

Technically that's exactly what does happen though lee.


Player a is injured, placed on LTIR

Player X is waiver exempt, sent down to minors, called up as injury call up until player a is no longer injured.

Player a gets healthy, made active, player x gets sent down to minors , and than brought back up.

The moves are not an issue as player x is waiver exempt.