2017-18 BBKL Google Sheets

Anything goes here OT stuff is OK too!

2017-18 BBKL Google Sheets

Postby Shoalzie » Thu Jun 29, 2017 6:07 pm

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.
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 » Thu Jun 29, 2017 6:34 pm

Sounds awesome man, thanks again. Can't wait to try them out
User avatar
Loki
 
Posts: 899
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2017-18 BBKL Google Sheets

Postby Lee » Thu Jun 29, 2017 6:36 pm

MVP
User avatar
Lee
 
Posts: 15809
Joined: Tue Jun 15, 2010 12:29 pm
Location: Calgary, AB

Re: 2017-18 BBKL Google Sheets

Postby thom54 » Thu Jun 29, 2017 6:43 pm

Lee wrote:MVP
User avatar
thom54
 
Posts: 5700
Joined: Mon Mar 12, 2012 4:00 pm
Location: Kingston, ON

Re: 2017-18 BBKL Google Sheets

Postby Handsome&FairMike » Thu Jun 29, 2017 9:07 pm

Seriously - you're love for fantasy hockey and skills are unparalleled.
User avatar
Handsome&FairMike
 
Posts: 2732
Joined: Fri Jul 11, 2014 9:41 am
Location: Toronto, ON

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sun Jul 02, 2017 7:51 am

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.
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 Sensfanjosh » Sun Jul 02, 2017 7:56 am

Sign me up
Image
User avatar
Sensfanjosh
 
Posts: 3461
Joined: Sun Nov 06, 2011 5:09 pm

Re: 2017-18 BBKL Google Sheets

Postby Tony » Sun Jul 02, 2017 10:22 am

Whatever you need, Scott.
Image
Click banner to view current roster and picks
User avatar
Tony
 
Posts: 10210
Joined: Mon May 03, 2010 10:29 pm
Location: Nevada

Re: 2017-18 BBKL Google Sheets

Postby thom54 » Sun Jul 02, 2017 11:09 am

me too
User avatar
thom54
 
Posts: 5700
Joined: Mon Mar 12, 2012 4:00 pm
Location: Kingston, ON

Re: 2017-18 BBKL Google Sheets

Postby timwebb1212 » Sun Jul 02, 2017 1:33 pm

Sounds good
User avatar
timwebb1212
 
Posts: 720
Joined: Wed Aug 10, 2016 9:40 pm

Re: 2017-18 BBKL Google Sheets

Postby Loki » Sun Jul 02, 2017 4:14 pm

Yep I'm keen
User avatar
Loki
 
Posts: 899
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sun Jul 02, 2017 4:37 pm

Okay, there's our initial group...thanks for volunteering.
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 cliff11 » Mon Jul 03, 2017 9:40 am

nice work man
User avatar
cliff11
 
Posts: 2348
Joined: Sat May 08, 2010 12:39 pm

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Mon Jul 03, 2017 9:49 am

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.
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 » Tue Jul 04, 2017 7:46 am

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.
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 thom54 » Tue Jul 04, 2017 7:54 am

big fan of moving the Cap summary info up to the top of the Lineup page !
User avatar
thom54
 
Posts: 5700
Joined: Mon Mar 12, 2012 4:00 pm
Location: Kingston, ON

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Tue Jul 04, 2017 7:55 am

Yeah...I know Mik wasn't a big fan of that from last year. That was the weak spot of last year's layout.
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 Sensfanjosh » Tue Jul 04, 2017 9:06 am

Looks pretty slick to me
Image
User avatar
Sensfanjosh
 
Posts: 3461
Joined: Sun Nov 06, 2011 5:09 pm

Re: 2017-18 BBKL Google Sheets

Postby dave1959 » Tue Jul 04, 2017 9:44 am

Shoalzie wrote: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.


Looks fantastic.
User avatar
dave1959
 
Posts: 2880
Joined: Wed Oct 02, 2013 8:43 pm
Location: Ontario

Re: 2017-18 BBKL Google Sheets

Postby kyuss » Tue Jul 04, 2017 10:10 am

Shoalzie wrote:Yeah...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?
User avatar
kyuss
 
Posts: 11330
Joined: Thu May 06, 2010 12:54 pm

Next

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 4 guests