2017-18 BBKL Google Sheets

Anything goes here OT stuff is OK too!

Re: 2017-18 BBKL Google Sheets

Postby hong57 » Mon Sep 25, 2017 9:10 pm

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
 
Posts: 6448
Joined: Mon May 03, 2010 7:38 pm

Re: 2017-18 BBKL Google Sheets

Postby hong57 » Mon Sep 25, 2017 9:11 pm

btw.. when is roster submission?
Image
#91 - John Tavares
User avatar
hong57
 
Posts: 6448
Joined: Mon May 03, 2010 7:38 pm

Re: 2017-18 BBKL Google Sheets

Postby CAM » Tue Sep 26, 2017 6:36 am

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
CAM
 
Posts: 3673
Joined: Fri May 24, 2013 5:42 pm

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Wed Sep 27, 2017 1:49 pm

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 | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8291
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Sep 29, 2017 5:17 am

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 | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8291
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby dave1959 » Fri Sep 29, 2017 1:28 pm

Evan Rodrigues and Michael Chaput both listed as C/W on Fantrax.
User avatar
dave1959
 
Posts: 3304
Joined: Wed Oct 02, 2013 8:43 pm
Location: Ontario

Re: 2017-18 BBKL Google Sheets

Postby foofnik » Fri Sep 29, 2017 1:51 pm

Panarin dual on FT, obviously a W
Kloos dual, should be C - https://www.nhl.com/player/justin-kloos-8480082
User avatar
foofnik
 
Posts: 1082
Joined: Sun May 31, 2015 2:58 pm
Location: Long Island, New York

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Sep 30, 2017 5:49 am

dave1959 wrote: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.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8291
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Sep 30, 2017 5:51 am

foofnik wrote: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.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8291
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Sep 30, 2017 5:55 am

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 | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8291
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Loki » Sat Sep 30, 2017 6:07 am

Loki wrote: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. :lol:
User avatar
Loki
 
Posts: 1144
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Sep 30, 2017 6:12 am

Loki wrote:
Loki wrote: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. :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 | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8291
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Sep 30, 2017 7:46 am

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 | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8291
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby dave1959 » Sat Sep 30, 2017 8:20 am

Is someone with fantrax access assisting you with the changes?
User avatar
dave1959
 
Posts: 3304
Joined: Wed Oct 02, 2013 8:43 pm
Location: Ontario

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Sep 30, 2017 9:17 am

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 | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8291
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Matthew » Sat Sep 30, 2017 1:30 pm

My googledocs says casey desmith is waiver exempt, but he is 26.
Image
Matthew
 
Posts: 8060
Joined: Wed Oct 08, 2014 3:29 pm

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Sep 30, 2017 1:37 pm

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 | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8291
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Matthew » Sat Sep 30, 2017 1:39 pm

Shoalzie wrote: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?
Image
Matthew
 
Posts: 8060
Joined: Wed Oct 08, 2014 3:29 pm

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Sep 30, 2017 1:42 pm

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 | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8291
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Matthew » Sat Sep 30, 2017 1:45 pm

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 :-)
Image
Matthew
 
Posts: 8060
Joined: Wed Oct 08, 2014 3:29 pm

PreviousNext

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 5 guests