Page 1 of 12

2017-18 BBKL Google Sheets

PostedCOLON Thu Jun 29, 2017 6:07 pm
by Shoalzie
2017-18 BBKL Google Sheets:
https://drive.google.com/drive/folders/ ... sp=sharing

"Draft" Sheet:
* All draft picks that your team owns will appear in the appropriate cells based on the particular draft and round. This information will be entered remotely and update on a regular basis.

"Roster" Sheet:
* Enter all the names of players on your current roster in cells A3 to A92.
* After roster submission, make sure to enter names of players that are traded, waived or dropped in cells A94 to A143. Removing names from this sheet will affect sheets from previous weeks.

"Preseason" (Weekly Lineup) Sheet:
* Re-enter the names of players on your current roster in cells A2 to A91. You can only enter names that appear on your "Roster" sheet.

* In column I (Roles), assign a role to each player (Active, Reserve, Minors or Inj Res).
* All players assigned "Active" as their role will appear in cells M10 to M32. These players' salaries will count towards your salary cap.
* All players assigned "Reserve" as their role will appear in cells M33 to M35. These players' salaries will also count towards your salary cap.
* All players assigned "Minors" as their role, their salaries will not count towards your salary cap.
* All players assigned "Inj Res" as their role will appear in cells M37 to M46. These players' salaries will also count towards your salary cap. Include both players on IR and LTIR as players you assign "Inj Res".

* 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.

* "Line Chart": Assign your active players to an appropriate position in column L and their names will appear in the line chart. Filling out the lineup chart is optional.

* "Must Clear Waivers": Starting in cell R20, any player that is assigned "Minors" as their role and do not have the green down arrow in column F, that player will appear as one that needs to clear waivers to be placed in the minors. Players in this list, must clear waivers that week. Players that do clear waivers can still appear in this list in any week following their assignment to the minors.

* "Sliding Contracts": Starting in cell S20, players whose contract that is chosen to slide for this season will appear in this list. Any player that is eligible to have their contract slide, see column M on the "Roster" sheet. In column H in the weekly lineup sheet, an icon will appear if the player has been given this designation. You can only assign players you choose to slide to "Minors" as their role. These players don't count towards your 50 contracts.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Thu Jun 29, 2017 6:34 pm
by Loki
Sounds awesome man, thanks again. Can't wait to try them out

Re: 2017-18 BBKL Google Sheets

PostedCOLON Thu Jun 29, 2017 6:36 pm
by Lee
MVP

Re: 2017-18 BBKL Google Sheets

PostedCOLON Thu Jun 29, 2017 6:43 pm
by thom54
Lee wroteCOLONMVP

Re: 2017-18 BBKL Google Sheets

PostedCOLON Thu Jun 29, 2017 9:07 pm
by Handsome&FairMike
Seriously - you're love for fantasy hockey and skills are unparalleled.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sun Jul 02, 2017 7:51 am
by Shoalzie
Put a lot of time in on it yesterday...I'm almost there. I'll continue to work on it today. I've got plans on the 3rd and 4th so Wednesday...it's beta day!

Lee and Cliff have already expressed interest. Tim, you've not had a sheet to use so I'll get you in on the beta as well. I'd like to get another 4 or 5 volunteers. It's more for testing the performance of the information updates and making sure all the tweaks to the weekly sheet are working properly.

There will be a few new things about the weekly sheet...I'll outline that on Wednesday. The roster sheet is pretty much the same. The only difference is you don't have to enter the position of the player...just the names. The draft page is the same but it now includes the 2019 picks.

I've position info in the database and I'll work with Mik on integrating his position updates. Any time he does an update, I can update that info on my end or I can have his updates go directly into the database. We can figure something out.

So, the first 4 or 5 volunteers to chime in...I'll get you set up on Wednesday. I have all your e-mails from last year's sheets so I don't need that info from you guys.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sun Jul 02, 2017 7:56 am
by Sensfanjosh
Sign me up

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sun Jul 02, 2017 10:22 am
by Tony
Whatever you need, Scott.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sun Jul 02, 2017 11:09 am
by thom54
me too

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sun Jul 02, 2017 1:33 pm
by timwebb1212
Sounds good

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sun Jul 02, 2017 4:14 pm
by Loki
Yep I'm keen

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sun Jul 02, 2017 4:37 pm
by Shoalzie
Okay, there's our initial group...thanks for volunteering.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Mon Jul 03, 2017 9:40 am
by cliff11
nice work man

Re: 2017-18 BBKL Google Sheets

PostedCOLON Mon Jul 03, 2017 9:49 am
by Shoalzie
I'll post my sheet tomorrow when I get a free moment...just as a preview. I'll get you beta users set up Wednesday night after I get home from work.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Tue Jul 04, 2017 7:46 am
by Shoalzie
Here's my in-progress sheet:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

I'll explain all the new features when I give you guys your sheets tomorrow.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Tue Jul 04, 2017 7:54 am
by thom54
big fan of moving the Cap summary info up to the top of the Lineup page !

Re: 2017-18 BBKL Google Sheets

PostedCOLON Tue Jul 04, 2017 7:55 am
by Shoalzie
Yeah...I know Mik wasn't a big fan of that from last year. That was the weak spot of last year's layout.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Tue Jul 04, 2017 9:06 am
by Sensfanjosh
Looks pretty slick to me

Re: 2017-18 BBKL Google Sheets

PostedCOLON Tue Jul 04, 2017 9:44 am
by dave1959
Shoalzie wroteCOLONHere's my in-progress sheet:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

I'll explain all the new features when I give you guys your sheets tomorrow.
Looks fantastic.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Tue Jul 04, 2017 10:10 am
by kyuss
Shoalzie wroteCOLONYeah...I know Mik wasn't a big fan of that from last year. That was the weak spot of last year's layout.
glad you remembered about my whining! :)

thx for the change, much appreciated personally.


If I have to nitpick again.. not sure importing icons from other leagues helps if they're given the same relevance/layout as NHL icons, would probably look cleaner only with NHL logos all of same small size?