2017-18 BBKL Google Sheets

Anything goes here OT stuff is OK too!
BUTTON_POST_REPLY
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

2017-18 BBKL Google Sheets

Post 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.
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 »

Sounds awesome man, thanks again. Can't wait to try them out
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2017-18 BBKL Google Sheets

Post by Lee »

MVP
User avatar
thom54
PostsCOLON 7459
JoinedCOLON Mon Mar 12, 2012 4:00 pm
LocationCOLON Kingston, ON

Re: 2017-18 BBKL Google Sheets

Post by thom54 »

Lee wroteCOLONMVP
Handsome&FairMike
PostsCOLON 4810
JoinedCOLON Fri Jul 11, 2014 9:41 am
LocationCOLON Wolfville, NS

Re: 2017-18 BBKL Google Sheets

Post by Handsome&FairMike »

Seriously - you're love for fantasy hockey and skills are unparalleled.
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 »

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.
DETROIT RED WINGS | ROSTER | FANTRAX
Sensfanjosh
PostsCOLON 4043
JoinedCOLON Sun Nov 06, 2011 5:09 pm

Re: 2017-18 BBKL Google Sheets

Post by Sensfanjosh »

Sign me up
Image
User avatar
Tony
PostsCOLON 11222
JoinedCOLON Mon May 03, 2010 10:29 pm
LocationCOLON Nevada

Re: 2017-18 BBKL Google Sheets

Post by Tony »

Whatever you need, Scott.
Image
Click banner to view current roster and picks
User avatar
thom54
PostsCOLON 7459
JoinedCOLON Mon Mar 12, 2012 4:00 pm
LocationCOLON Kingston, ON

Re: 2017-18 BBKL Google Sheets

Post by thom54 »

me too
User avatar
timwebb1212
PostsCOLON 720
JoinedCOLON Wed Aug 10, 2016 9:40 pm

Re: 2017-18 BBKL Google Sheets

Post by timwebb1212 »

Sounds good
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 »

Yep I'm keen
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 »

Okay, there's our initial group...thanks for volunteering.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
cliff11
PostsCOLON 2644
JoinedCOLON Sat May 08, 2010 12:39 pm

Re: 2017-18 BBKL Google Sheets

Post by cliff11 »

nice work man
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 »

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

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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
thom54
PostsCOLON 7459
JoinedCOLON Mon Mar 12, 2012 4:00 pm
LocationCOLON Kingston, ON

Re: 2017-18 BBKL Google Sheets

Post by thom54 »

big fan of moving the Cap summary info up to the top of the Lineup page !
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...I know Mik wasn't a big fan of that from last year. That was the weak spot of last year's layout.
DETROIT RED WINGS | ROSTER | FANTRAX
Sensfanjosh
PostsCOLON 4043
JoinedCOLON Sun Nov 06, 2011 5:09 pm

Re: 2017-18 BBKL Google Sheets

Post by Sensfanjosh »

Looks pretty slick to me
Image
User avatar
dave1959
PostsCOLON 5138
JoinedCOLON Wed Oct 02, 2013 8:43 pm
LocationCOLON Ontario

Re: 2017-18 BBKL Google Sheets

Post 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.
User avatar
kyuss
PostsCOLON 14876
JoinedCOLON Thu May 06, 2010 12:54 pm

Re: 2017-18 BBKL Google Sheets

Post 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?
BUTTON_POST_REPLY

Return to