2017-18 BBKL Google Sheets

Anything goes here OT stuff is OK too!

Re: 2017-18 BBKL Google Sheets

Postby koomzzz » Wed Sep 13, 2017 2:42 pm

Shoalzie wrote:
* Any players that need to go on LTIR, enter their name in any of the available LTIR spots as well as enter any names of active players you want to use as cap relief.


No salary shows for relief players when they get entered in, just a heads up
User avatar
koomzzz
 
Posts: 631
Joined: Wed May 25, 2016 2:15 pm
Location: South Carolina

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Wed Sep 13, 2017 2:50 pm

I think everyone's sheets are wrong if yours and a couple others are having the same issue. I'll check it out.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7946
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby koomzzz » Tue Sep 19, 2017 9:40 am

Shoalzie wrote:I think everyone's sheets are wrong if yours and a couple others are having the same issue. I'll check it out.


Piggy backing on this, the cap relief is fixed, but the salary now doesn't reflect what it should be. The formula subtracts the salary without first removing the cap relief. so Cap Space reads (75000000-N2) instead of what probably should be (75000000-N4) which is total salary post cap relief subtraction.
User avatar
koomzzz
 
Posts: 631
Joined: Wed May 25, 2016 2:15 pm
Location: South Carolina

Re: 2017-18 BBKL Google Sheets

Postby thom54 » Tue Sep 19, 2017 9:41 am

koomzzz wrote:
Shoalzie wrote:I think everyone's sheets are wrong if yours and a couple others are having the same issue. I'll check it out.


Piggy backing on this, the cap relief is fixed, but the salary now doesn't reflect what it should be. The formula subtracts the salary without first removing the cap relief. so Cap Space reads (75000000-N2) instead of what probably should be (75000000-N4) which is total salary post cap relief subtraction.


yea same issue with potential LTIR cap relief
User avatar
thom54
 
Posts: 5704
Joined: Mon Mar 12, 2012 4:00 pm
Location: Kingston, ON

Re: 2017-18 BBKL Google Sheets

Postby Loki » Wed Sep 20, 2017 1:41 am

Henrik Haapala is missing his personal information, birthdate etc..., contract info seems OK
Please fix when you get a chance :)

Out of curiosity, will Fantrax C/W eligibility be updated to match the sheet since there's a formula now? Is the formula accurate at the moment? Just need to know how to approach them being different right now between my sheet and Fantrax.
User avatar
Loki
 
Posts: 901
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2017-18 BBKL Google Sheets

Postby hong57 » Wed Sep 20, 2017 4:05 am

Loki wrote:Henrik Haapala is missing his personal information, birthdate etc..., contract info seems OK
Please fix when you get a chance :)

Out of curiosity, will Fantrax C/W eligibility be updated to match the sheet since there's a formula now? Is the formula accurate at the moment? Just need to know how to approach them being different right now between my sheet and Fantrax.


you should drop the player as he is not eligible for the bbkl for coming years ;)
Image
#91 - John Tavares
User avatar
hong57
 
Posts: 6082
Joined: Mon May 03, 2010 7:38 pm

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Wed Sep 20, 2017 12:53 pm

Loki wrote:Henrik Haapala is missing his personal information, birthdate etc..., contract info seems OK
Please fix when you get a chance :)



Yeah, I'll go through each player in the draft and get their missing info filled in.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7946
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Wed Sep 20, 2017 12:56 pm

Loki wrote:Out of curiosity, will Fantrax C/W eligibility be updated to match the sheet since there's a formula now? Is the formula accurate at the moment? Just need to know how to approach them being different right now between my sheet and Fantrax.



I have Mik's FOR formula in place for players from last season. I don't recall his policy on rookies or new players.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7946
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Loki » Wed Sep 20, 2017 4:29 pm

Shoalzie wrote:
Loki wrote:Out of curiosity, will Fantrax C/W eligibility be updated to match the sheet since there's a formula now? Is the formula accurate at the moment? Just need to know how to approach them being different right now between my sheet and Fantrax.



I have Mik's FOR formula in place for players from last season. I don't recall his policy on rookies or new players.


At the moment the discrepancies I have are:
Nick Bjugstad - C on sheet, W on Fantrax
Brayden Point - C on sheet, W on Fantrax
Devin Shore - W on sheet, C on Fantrax

I'm fine with whichever way it goes, just need to know if it's Fantrax that will change to match the sheet before the season starts?
User avatar
Loki
 
Posts: 901
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2017-18 BBKL Google Sheets

Postby foofnik » Wed Sep 20, 2017 4:45 pm

Loki wrote:
Shoalzie wrote:
Loki wrote:Out of curiosity, will Fantrax C/W eligibility be updated to match the sheet since there's a formula now? Is the formula accurate at the moment? Just need to know how to approach them being different right now between my sheet and Fantrax.

Sheet should be accurate. Fantrax will be changed to match. Is my understanding.

I have Mik's FOR formula in place for players from last season. I don't recall his policy on rookies or new players.


At the moment the discrepancies I have are:
Nick Bjugstad - C on sheet, W on Fantrax
Brayden Point - C on sheet, W on Fantrax
Devin Shore - W on sheet, C on Fantrax

I'm fine with whichever way it goes, just need to know if it's Fantrax that will change to match the sheet before the season starts?
User avatar
foofnik
 
Posts: 926
Joined: Sun May 31, 2015 2:58 pm
Location: Long Island, New York

Re: 2017-18 BBKL Google Sheets

Postby kyuss » Wed Sep 20, 2017 4:59 pm

usual rule: if player's FOR was >0.45 last season he will start as C, if < 0.45 will start as W
User avatar
kyuss
 
Posts: 11331
Joined: Thu May 06, 2010 12:54 pm

Re: 2017-18 BBKL Google Sheets

Postby kyuss » Wed Sep 20, 2017 5:27 pm

Shoalzie wrote:
Loki wrote:Out of curiosity, will Fantrax C/W eligibility be updated to match the sheet since there's a formula now? Is the formula accurate at the moment? Just need to know how to approach them being different right now between my sheet and Fantrax.


I have Mik's FOR formula in place for players from last season. I don't recall his policy on rookies or new players.

I don't know about googledoc sheets right now, but fantrax is yet to be updated according to 2016/17 FOR and the 0.45 threshold.
Eventually players will be listed the same on both sources though.

Reminder for the used criteria:
- FOR threshold set at 0.45 (> .45 ==> C)
- last previous season with at least 20 gp determines position (according with the FOR number registered in that season)
- current season's FOR determines position for bbkl-rookies (i.e. players who never reached 20gp in one NHL RS) once they reach 10 gp

We decided to leave the fantrax default position for those players not eligible yet for FOR determination (i.e. rookies who have yet to hit the in-season 10 gp mark).
However, when fantrax assigns a dual to those players it gets problematic to go back and find out which was the player's original position on fantrax (not to mention, for some players fantrax might have assigned a dual right from the start..)
For this reason, we use the in-season FOR to eliminate duals on fantrax no matter how many NHL games that player has played. And for duals players who have zero games in the league, I'll go looking for their position on nhl.com draft list: http://www.nhl.com/ice/draftsearch.htm?sort=overallPick
and set that position as provisional starting position (duals there would be W for us).
User avatar
kyuss
 
Posts: 11331
Joined: Thu May 06, 2010 12:54 pm

Re: 2017-18 BBKL Google Sheets

Postby Loki » Thu Sep 21, 2017 4:41 am

I don't believe Adam Johnson (PIT) has an entry, only the D of the same name
http://www.eliteprospects.com/player.php?player=121852
He's a W on Fantrax but Pittsburgh is playing him as a center in camp
User avatar
Loki
 
Posts: 901
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Sep 23, 2017 6:38 am

Looks like the links to the logos might've finally bitten the dust. I've been linking directly to Chris Creamer's site up until now. I might either find a new site or I'll just save the logos from the site and then upload them to my own web space. Logos will temporarily be missing until I can resolve this issue. Getting your player info wrapped is the higher priority though.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7946
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby foofnik » Mon Sep 25, 2017 9:20 am

Did we ever get a fix for LTIR yet? Sekera still not having his cap hit removed on mine even with a REL player
User avatar
foofnik
 
Posts: 926
Joined: Sun May 31, 2015 2:58 pm
Location: Long Island, New York

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Mon Sep 25, 2017 10:30 am

I bounced around and fixed most sheets. If I didn't get to you, I'll be checking everyone's sheets again to see who I might've missed.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7946
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby CAM » Mon Sep 25, 2017 12:56 pm

Can anyone tell me why i get this error when trying to enter a new claimed player? Is it because he is not in Scott's database yet? He is on Cap Friendly....

There is a Problem!

The data you entered in cell A79 violates the data validation rules set on this cell.
User avatar
CAM
 
Posts: 3570
Joined: Fri May 24, 2013 5:42 pm

Re: 2017-18 BBKL Google Sheets

Postby foofnik » Mon Sep 25, 2017 1:10 pm

CAM wrote:Can anyone tell me why i get this error when trying to enter a new claimed player? Is it because he is not in Scott's database yet? He is on Cap Friendly....

There is a Problem!

The data you entered in cell A79 violates the data validation rules set on this cell.

Not in database yet
User avatar
foofnik
 
Posts: 926
Joined: Sun May 31, 2015 2:58 pm
Location: Long Island, New York

Re: 2017-18 BBKL Google Sheets

Postby CAM » Mon Sep 25, 2017 1:13 pm

Thank you, that is what i guessed, just wanted to make sure....
User avatar
CAM
 
Posts: 3570
Joined: Fri May 24, 2013 5:42 pm

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Mon Sep 25, 2017 2:22 pm

That data validation function is in place so it makes sure you guys enter names correctly and to let me know if a player is missing from my database.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7946
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

PreviousNext

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 3 guests