2018-19 BBKL Google Sheets

Anything goes here OT stuff is OK too!

2018-19 BBKL Google Sheets

Postby Shoalzie » Mon May 14, 2018 9:14 am

This is just a public preview of the new-look sheet...
https://docs.google.com/spreadsheets/d/ ... sp=sharing

What I'm hoping for is to give each of your sheets out during or after the draft. There's a bit of work I need to complete behind the scenes before I release this league-wide.

I'd like to do a screencast or YouTube video and explain how this new sheet works. I don't get the sense anyone wants some long typed-out instructions. It's meant to be an easier sheet to use than before and the big change as I've teased in the past, the rosters are fully automated. You just need to set your weekly lineups. The players are already entered into your sheets.

I've started updating contracts for '18-19 so if you're still using your old sheets, you'll notice players may appear as free agents and not have any salaries if their current contract expires in July.

You'll notice with my sheet, I have several veterans that are free agents this summer so the way I have this set up, you can only put players into your lineup who have a contract. All players that aren't entered into your lineup will show up in the "Minors" section of the sheet.

I'm still using the green downward arrow icon that CapFriendly uses. Any player you see listed with that icon means that player is "Waiver Exempt".

I'll give you a more complete explanation of how these sheets work when I give them to you.

I'll credit Josh for some of my design choices as I've liked what he's done with his sheets for ADHL.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8647
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2018-19 BBKL Google Sheets

Postby dave1959 » Mon May 14, 2018 9:36 am

I like that all pertinent info is in the first 2 columns
User avatar
dave1959
 
Posts: 3408
Joined: Wed Oct 02, 2013 8:43 pm
Location: Ontario

Re: 2018-19 BBKL Google Sheets

Postby Lee » Mon May 14, 2018 9:38 am

Always happy to beta test for you, Scott
User avatar
Lee
 
Posts: 16482
Joined: Tue Jun 15, 2010 12:29 pm
Location: Calgary, AB

Re: 2018-19 BBKL Google Sheets

Postby Da_Hawks » Mon May 14, 2018 10:49 am

So much prettier!!! Wow. Nicely done Shoalzie. Looking forward to the full release.
Image
User avatar
Da_Hawks
 
Posts: 722
Joined: Mon Dec 18, 2017 9:27 am
Location: Ottawa

Re: 2018-19 BBKL Google Sheets

Postby Tony » Mon May 14, 2018 11:01 am

Image
Image
Click banner to view current roster and picks
User avatar
Tony
 
Posts: 10687
Joined: Mon May 03, 2010 10:29 pm
Location: Nevada

Re: 2018-19 BBKL Google Sheets

Postby koomzzz » Mon May 14, 2018 11:06 am

Only issue I have would be the largeness of the headers and logos and such. If we can customize those ourselves, i'm cool. I approve of automation, I'm concerned about the slower processors and how they handle it. but it looks great, thanks scott!
User avatar
koomzzz
 
Posts: 799
Joined: Wed May 25, 2016 2:15 pm
Location: South Carolina

Re: 2018-19 BBKL Google Sheets

Postby Shoalzie » Mon May 14, 2018 11:43 am

The reason behind the bigger text is for those who will use their phones to update these sheets. The only work you guys would have to do is enter your players into the lineup. The sheet will do the rest of the work.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8647
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2018-19 BBKL Google Sheets

Postby kimmer » Mon May 14, 2018 1:04 pm

thats amazing scott
love the big text
2017-2018 Transactions
CAR Google Sheet
Image
- A true liberator of the apprehensive voice -
User avatar
kimmer
 
Posts: 16546
Joined: Thu Sep 02, 2010 2:25 pm
Location: Markham, Ontario

Re: 2018-19 BBKL Google Sheets

Postby Malette18 » Mon May 14, 2018 1:38 pm

Looks nice and clean.
User avatar
Malette18
 
Posts: 320
Joined: Wed Sep 27, 2017 1:29 pm
Location: Ottawa, ON

Re: 2018-19 BBKL Google Sheets

Postby Florida Chris » Mon May 14, 2018 4:22 pm

Love it
User avatar
Florida Chris
 
Posts: 2023
Joined: Tue May 04, 2010 7:06 am

Re: 2018-19 BBKL Google Sheets

Postby Loki » Mon May 14, 2018 4:33 pm

That looks awesome, great work Scott
User avatar
Loki
 
Posts: 1276
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2018-19 BBKL Google Sheets

Postby Shoalzie » Thu Jul 12, 2018 1:53 pm

Sheets are coming very soon...I've got mine and Matt's (BUF) created. I wanted to use Matt's roster since he's got Svechnikov and I could test out my formulas for sliding contracts. Throughout this coming weekend I'll create the other 29 sheets for the league and get them out to you.

If you have a different e-mail address that you'd like access your sheet, let me know. If not, I'll just use the e-mail from last year.

I will be updating contract information and filling in info for the new draftees. You will have missing information on your roster and sheets...I appreciate your patience. I'd like to get contracts entered before I deal with the new draftees.

I'll answer any questions you have about the sheets but I can do a tutorial later if enough people have the same questions.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8647
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2018-19 BBKL Google Sheets

Postby Shoalzie » Sat Jul 14, 2018 8:37 am

Updated the link on the forum to share the entire folder...I'm setting you guys up with sharing rights to your sheets.

When you get access to your sheets, keep in mind that you can only add players to your lineup that have contracts. If they're "Unsigned" in my database, that won't show up in the drop down list. I also need to add position designations to the 2018 draftees. They might not show up in your sheet. Your full list of current players is on the "Roster" sheet.

Please make sure that if you drop players in Fantrax, make sure you post something in the drop thread.

With the sheets up and running, I'll be hitting the contract info hard so hopefully you'll have the ability plug guys into your lineup and check your situation against the cap.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8647
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI


Re: 2018-19 BBKL Google Sheets

Postby Shoalzie » Sat Jul 14, 2018 11:39 am

Don't be alarmed the #REF! message under "MUST CLEAR WAIVERS". It'll be like that until you fill out your lineup. The list pairs down as you put players in your lineup and then you'll see names appear. Hopefully when you have a full lineup, you don't have more than 15 players that need to clear waivers.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8647
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2018-19 BBKL Google Sheets

Postby Lee » Sat Jul 14, 2018 11:57 am

Not able to add Teuvo as a winger
User avatar
Lee
 
Posts: 16482
Joined: Tue Jun 15, 2010 12:29 pm
Location: Calgary, AB

Re: 2018-19 BBKL Google Sheets

Postby Shoalzie » Sat Jul 14, 2018 12:12 pm

I see why...I've got my sheets made for rosters of 90 players. I'm going through all your sheets and seeing many of us are over 90 right now. I need to tweak some of my formulas on the Preseason sheet so it includes the extra players.

Thankfully I don't need to do that to other weeks since you can't have more than 90 players during the season.

The other thing I see is the count of the players is a little screwed up.

It wouldn't be a sheet release without fixing some bugs. Patience fellas...thankfully I have all summer to get these right.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8647
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2018-19 BBKL Google Sheets

Postby Loki » Sat Jul 14, 2018 5:31 pm

It looks great so far Scott. I have a bunch of players who don't seem to have position info and some that do that I can't assign to positions (Chris Tierney, Elias Pettersson, Antti Raanta, Devin Shore, Ryan Murray, Troy Stecher, Ryan Pulock). I suspect maybe if they don't have a contract extension in the system yet they can't be assigned to a position? Either way, loving how it's coming along, great job
User avatar
Loki
 
Posts: 1276
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2018-19 BBKL Google Sheets

Postby KapG » Sun Jul 15, 2018 10:05 am

You are amazing Scott
User avatar
KapG
 
Posts: 10099
Joined: Tue May 04, 2010 5:46 pm
Location: Toronto (beach area)

Re: 2018-19 BBKL Google Sheets

Postby Shoalzie » Sun Jul 15, 2018 12:34 pm

I just replaced all of your "Preseason" sheets with correct formulas. If you already started filling out your lineup, I apologize for clearing that out. This was the quickest way to implement those changes.

Updates on contracts, positions and player info will be periodic. I'll do as much as I can but at least you guys have your sheets for this summer. The only thing you have to do with these sheets is fill out your lineup each week. Your rosters will update as you make trades or drop players and your info will update as I update it.

Thanks for you patience...fire away with any questions or concerns. I'm aware of any and all missing contracts or player info.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 8647
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Next

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 6 guests

cron