Page 7 of 12

Re: 2017-18 BBKL Google Sheets

PostedCOLON Mon Sep 25, 2017 9:10 pm
by 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!

Re: 2017-18 BBKL Google Sheets

PostedCOLON Mon Sep 25, 2017 9:11 pm
by hong57
btw.. when is roster submission?

Re: 2017-18 BBKL Google Sheets

PostedCOLON Tue Sep 26, 2017 6:36 am
by 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

Re: 2017-18 BBKL Google Sheets

PostedCOLON Wed Sep 27, 2017 1:49 pm
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Sep 29, 2017 5:17 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Sep 29, 2017 1:28 pm
by dave1959
Evan Rodrigues and Michael Chaput both listed as C/W on Fantrax.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Sep 29, 2017 1:51 pm
by foofnik
Panarin dual on FT, obviously a W
Kloos dual, should be C - https://www.nhl.com/player/justin-kloos-8480082

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 5:49 am
by Shoalzie
dave1959 wroteCOLONEvan 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 5:51 am
by Shoalzie
foofnik wroteCOLONPanarin 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 5:55 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 6:07 am
by Loki
Loki wroteCOLONNick 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. :lol:

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 6:12 am
by Shoalzie
Loki wroteCOLON
Loki wroteCOLONNick 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. :lol:

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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 7:46 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 8:20 am
by dave1959
Is someone with fantrax access assisting you with the changes?

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 9:17 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 1:30 pm
by Matthew
My googledocs says casey desmith is waiver exempt, but he is 26.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 1:37 pm
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 1:39 pm
by Matthew
Shoalzie wroteCOLONCorrect. 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?

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 1:42 pm
by 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).

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sat Sep 30, 2017 1:45 pm
by 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 :-)