2017-18 BBKL Google Sheets

Anything goes here OT stuff is OK too!
BUTTON_POST_REPLY
User avatar
hong57
PostsCOLON 7106
JoinedCOLON Mon May 03, 2010 7:38 pm

Re: 2017-18 BBKL Google Sheets

Post 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!
Image
#91 - John Tavares
User avatar
hong57
PostsCOLON 7106
JoinedCOLON Mon May 03, 2010 7:38 pm

Re: 2017-18 BBKL Google Sheets

Post by hong57 »

btw.. when is roster submission?
Image
#91 - John Tavares
CAM
PostsCOLON 3734
JoinedCOLON Fri May 24, 2013 5:42 pm

Re: 2017-18 BBKL Google Sheets

Post 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
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
dave1959
PostsCOLON 5138
JoinedCOLON Wed Oct 02, 2013 8:43 pm
LocationCOLON Ontario

Re: 2017-18 BBKL Google Sheets

Post by dave1959 »

Evan Rodrigues and Michael Chaput both listed as C/W on Fantrax.
User avatar
foofnik
PostsCOLON 1572
JoinedCOLON Sun May 31, 2015 2:58 pm
LocationCOLON Long Island, New York

Re: 2017-18 BBKL Google Sheets

Post by foofnik »

Panarin dual on FT, obviously a W
Kloos dual, should be C - https://www.nhl.com/player/justin-kloos-8480082
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Loki
PostsCOLON 1938
JoinedCOLON Mon Sep 26, 2016 4:38 pm
LocationCOLON Melbourne, AUS

Re: 2017-18 BBKL Google Sheets

Post 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:
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
dave1959
PostsCOLON 5138
JoinedCOLON Wed Oct 02, 2013 8:43 pm
LocationCOLON Ontario

Re: 2017-18 BBKL Google Sheets

Post by dave1959 »

Is someone with fantrax access assisting you with the changes?
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Matthew
PostsCOLON 13682
JoinedCOLON Wed Oct 08, 2014 3:29 pm

Re: 2017-18 BBKL Google Sheets

Post by Matthew »

My googledocs says casey desmith is waiver exempt, but he is 26.
ANAHEIM DUCKS | FANTRAX |
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Matthew
PostsCOLON 13682
JoinedCOLON Wed Oct 08, 2014 3:29 pm

Re: 2017-18 BBKL Google Sheets

Post 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?
ANAHEIM DUCKS | FANTRAX |
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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).
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Matthew
PostsCOLON 13682
JoinedCOLON Wed Oct 08, 2014 3:29 pm

Re: 2017-18 BBKL Google Sheets

Post 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 :-)
ANAHEIM DUCKS | FANTRAX |
BUTTON_POST_REPLY

Return to