2017-18 BBKL Google Sheets

[hong57]

thanks for the work every year.. the sheets are more advanced and more user friendly every year.. they are actually way better than what my bank's IT staff can do for automation!

[hong57]

btw.. when is roster submission?

[CAM]

Ok, thanks Scott.

Sam Miletic is missing

as well there seem to be an issue with Sean Collins. I know there is two of them and it use to be "Sean Collins!!!" That doesnt work anymore. The only info that shows up is the word exempt with no other populated info. thanks

[Shoalzie]

Yeah, Miletic is a new player...I need to add him.

Since there's two Sean Collins(s)...I've got them listed with their middle initial. I think the one on your roster is "Sean B. Collins"...he's the forward. "Sean P. Collins" is the defenseman.

[Shoalzie]

Just for everyone's information...if you have some rookies/minor leaguers with inaccurate contract info, I will correct it as soon as I can. You aren't responsible for that...I'll still have some bookkeeping work to do beyond Saturday's deadline. They don't have to exactly right at this moment but I will correct them. Those are the existing players that still have CapGeek information while CapFriendly will has different information on their site. I will get every player's cap info converted over to CapFriendly's info.

Make me aware of players you intend on having in your lineup who may have inaccurate contract info, get your contract slides posted and let me know of any position issues you may have. Anyone still waiting on me to address any outstanding issues...I'll get to you as soon as I can.

Thanks for your cooperation.

[dave1959]

Evan Rodrigues and Michael Chaput both listed as C/W on Fantrax.

[foofnik]

Panarin dual on FT, obviously a W
Kloos dual, should be C - https://www.nhl.com/player/justin-kloos-8480082

[Shoalzie]

Evan Rodrigues and Michael Chaput both listed as C/W on Fantrax.

Rodrigues played 30 games and his FOR was 0.645.
Chaput played 68 games and his FOR was 0.514.

My assumption is both should be centers. I don't have the ability to change positions on Fantrax.

[Shoalzie]

Panarin dual on FT, obviously a W
Kloos dual, should be C - https://www.nhl.com/player/justin-kloos-8480082

Panarin listed as both C/W is pretty weird. He took 10 faceoffs last year in 82 games.

[Shoalzie]

FYI, I'll post the waiver, IR and weekly roster move threads tomorrow morning.

Waivers will start at noon tomorrow. Any (legal) roster submitted by 10 p.m. tonight...those players will go on waivers.

[Loki]

Nick Bjugstad - C on sheet, W on Fantrax
Brayden Point - C on sheet, W on Fantrax
Devin Shore - W on sheet, C on Fantrax

FYI I still have this discrepancy between the sheet and Fantrax. thankfully I can still make a valid roster submission with it how it is, but it may make things difficult through the year.

[Shoalzie]

Nick Bjugstad - C on sheet, W on Fantrax
Brayden Point - C on sheet, W on Fantrax
Devin Shore - W on sheet, C on Fantrax

FYI I still have this discrepancy between the sheet and Fantrax. thankfully I can still make a valid roster submission with it how it is, but it may make things difficult through the year.

Bjugstad played 54 games and his FOR was 0.551.
Point played 68 games and his FOR was 0.457.

Both players do qualify as centers.

Shore played 82 games and his FOR was 0.405...just missed out on being a center. Needs to be 0.450 to be a center.

[Shoalzie]

Any salary issues with IR and LTIR should be resolved on everyone's sheet. Also, I had to make a tweak to the salary information at the top of the weekly sheet. Your team cap number should be correct.

I should be available all day today if you have any questions or issues with your sheet. I won't start reviewing the submitted rosters until after 10 but thank you to those who have sent theirs in already.

[dave1959]

Is someone with fantrax access assisting you with the changes?

[Shoalzie]

If you guys need a position change on Fantrax, I don't have access. It's not required for what we're doing for today. You guys need legal lineups in on Fantrax by Wednesday.

I'm mostly concerned that you are compliant with the 50/90 rule, compliant with the cap and your Google sheet has the same players as you have on Fantrax.

[Matthew]

My googledocs says casey desmith is waiver exempt, but he is 26.

[Shoalzie]

Correct. He's waiver exempt because he's not played any NHL games. He wasn't on my sheet that calculates waiver and contract slide status.

If anyone has a player that you don't think needs to clear waivers, please let me know. I will check to make sure every player that is getting waived for tomorrow is indeed eligible.

[Matthew]

Correct. He's waiver exempt because he's not played any NHL games. He wasn't on my sheet that calculates waiver and contract slide status.

If anyone has a player that you don't think needs to clear waivers, please let me know. I will check to make sure every player that is getting waived for tomorrow is indeed eligible.

I thought this only applied to players that were drafted in the waiver draft, not players simply 'signed' afterward.

You are saying he should be exempt then?

[Shoalzie]

Any signed player regardless of age...they are exempt if they've never played an NHL game. So a guy like DeSmith...he's exempt until he plays a game.

I think the spirit of that rule was so that you can send down a player you pick at the waiver draft they might be over the age limit (anyone that turns 26 by October 1).

[Matthew]

It was in the spirit of the waiver draft. DeSmith wasnt taken in the waiver draft. he was taken after during our signing kafuffle.

But if them the rules, im okay with him being exempt