2017-18 BBKL Google Sheets

[Shoalzie]

A few logos are tough to see...some don't read well at a small size. In the end, it's just extra info. Not essential but just thought if would be handy.

I like the NHL logo for UFAs...CapFriendly does that. If those other logos weren't on Chris Creamer's site, I would've left them off. I just used the league logos and not the individual teams. That would've been overkill.

I'm also using the waiver exempt and slide logos from CapFriendly.

[Lee]

Can't wait to dig in

[Shoalzie]

I'll have time tonight to set you guys up. I'll post a few how to's as well.

[Loki]

Sheet is looking awesome, can't wait to mess around with it

[Shoalzie]

Sheet sharing has been sent out and I've posted some how to's in the opening post. Please ask me any questions you have. I tried to keep these sheets fairly simple.

You'll noticed I've utilized data validation, drop down menus and filtering. These are features that I liked from the sheets Josh (SJ) has made for ADHL. With data validation when you enter any name, you will get the closest matches for your player's name. You can select the name that appears or finish typing the name. Only names that appear in my database can be entered. Any name that is missing from the database, please let me know.

[Loki]

Looks great Scott. There's a few of my recent draft picks (Georgi Ivanov, Jiri Karafiat, Nate Knoepke) missing from the database from the looks of it but other wise working well. Some recently signed contracts missing information but I imagine that will all get filled in later.

I haven't been able to change the cells in the P column of the Preseason tab to set anyone into the lineup though.

[Lee]

missing :
ryan peckford
brady lyle
Jonah Gadjovich
Alex Formenton
Grant Mismash
Scott Walford
Nick Henry
Kyle Olson
Evan Barratt
David Farrance
Alexei Toropchenko
Jarret Tyszka

Row 93 is buggered - telling me I can't edit a protected cell

Missing contracts for:
Dillon Dube
Nathan Noel
Joanthan Huberdeau
Tim Gettinger
Jack Kopacka
Anthony Peluso
Dmitry Orlov
Luke Witkowski
Zach Trotman
Lucas Johansen
Kale Clague
Simon Bourgue
Dennis Cholowski
Al Montoya
Jonathan Bernier

Status for unsigned players:
Adam Ollas Mattsson
Connor Chatham
Erik Gustafsson (II)
Rihards Bukarts
Bobby Butler
Matt Murphy
Kameron Kielly
Alan Lyszczarczyk
Loik Leveille
Antoine Samuel
Edwin Minney
Kieffer Bellows
Ryan Poehling
Keith Petruzzelli
John Marino
Denis Smirnov
Hayden Hawkey
Jack Sadek
Miro Heiskanen
Andrej Meszaros
Eetu Tuulola
Igor Shvyryov
Andy Miele
Ahti Oksanen
Dominik Uher
Bill Arnold

The following players are listed as 117 years old:
Ryan Poehling
Keith Petruzzli
Denis Smirnov
Miro Heiskanen

Cant edit anyone into lineup
Trying to slide Laberge, How?

[Shoalzie]

Any of the draftees that didn't get drafted into the NHL will need to be added on my end. I'll get you guys squared away this week.

You can call those sheets whatever you want...but remember that first sheet is what I need to look at for the roster submission in September.

[Loki]

Thanks Scott. Oh yeah didn't realise a bunch of players were missing birthdates too.
Elias Pettersson
Lias Andersson
Robert Thomas
Georgi Ivanov
Dominik Lakatos
Jiri Karafiat
Jason Robertson
Daniil Vovchenko
Nate Knoepke

[Shoalzie]

Man, you don't waste any time Lee...I just got your sheet to you.

Row 93 isn't for data...it's supposed to be blank.

Any player that I don't have their birthdate entered, it appears 117 as their age...that will be corrected.

As I told Brendan, I'll work on your guys info now that I have the sheets in your hands.

[Shoalzie]

Trying to slide Laberge, How?

I can post that thread now but just like last year, you tell me who you want to slide and I'll do that in the database.

[Lee]

Ah okay I thought we did that last year.

[Shoalzie]

Fill in your sheets as much as you can and I'll fill in the missing info. I'm well aware of what info is missing. I have you the sheets now without the completed database or I make you wait all summer until I give you the sheets while I fill in the information.

I'll add the missing BBKL draftees tonight. The next several weeks will be finishing up the database. You guys will have to be patient...and I'll make it a priority to get the players on you initial teams using the new sheets set up.

[Shoalzie]

Players that unexpectedly appear as if they need to clear waivers is based on if there's information missing for the player. I have formulas using the player's birthdate, GP and contract status. If any of those pieces of info are missing, they'll appear as being not exempt. I encountered this exact problem when I started using the sheet when I had missing info for my players. The problems go away as data is entered.

[timwebb1212]

How do we do the lineup? You say put it in Column L but I can't edit that

[Sensfanjosh]

Missing:
Aleksi Heponiemi
Kirill Maksimov
Mario Ferraro
Tyler Inamoto
Adam Ahman

Lance Bouma's contract was bought out and needs to be updated
Josh Anderson (CLB) doesn't show him as belonging to CLB
Nikita A. Popugayev doesn't show up as NJD property
Christoval Nieves apparently needs to clear waivers?

Also, just trying to see what all the new colour coding etc. means, green downward arrow means what?
How do we set our lineups C1, C2 etc?

[Tony]

I can make Glendening active as he's dual C/W. I also don't have a clue how to set my lineup... maybe I'm just old.

[Shoalzie]

Also, just trying to see what all the new colour coding etc. means, green downward arrow means what?

It's in the opening post...I mentioned the arrow icon there. I'm using a couple icons from CapFriendly.

https://capfriendly.com/teams/predators

For example, Fiala and Gaudreau has the green down arrow...that means waiver exempt. I'm using that icon for us.

Also, there's a blue downward diagonal arrow that they use for slide risk players. I'm using that as our designation for players you've elected to slide.

How do we set our lineups C1, C2 etc?

Good catch Josh...I did lock the L10 through L32 cells so you couldn't set up you line chart. That was a goof on my part. I fixed yours...I'll fix everyone elses tonight.

[Sensfanjosh]

Also, just trying to see what all the new colour coding etc. means, green downward arrow means what?

It's in the opening post...I mentioned the arrow icon there. I'm using a couple icons from CapFriendly.

https://capfriendly.com/teams/predators

For example, Fiala and Gaudreau has the green down arrow...that means waiver exempt. I'm using that icon for us.

Also, there's a blue downward diagonal arrow that they use for slide risk players. I'm using that as our designation for players you've elected to slide.

How do we set our lineups C1, C2 etc?

Good catch Josh...I did lock the L10 through L32 cells so you couldn't set up you line chart. That was a goof on my part. I fixed yours...I'll fix everyone elses tonight.

Thanks, that's my bad, working good now.

[Sensfanjosh]

When I added Hossa to IR, he automatically also went into all of my LTIR slots as well-

Also where do we actually name guys as LTIR relief?