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

Re: 2017-18 BBKL Google Sheets

Post by 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.
DETROIT RED WINGS | ROSTER | FANTRAX
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2017-18 BBKL Google Sheets

Post by Lee »

Can't wait to dig in
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 have time tonight to set you guys up. I'll post a few how to's as well.
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 »

Sheet is looking awesome, can't wait to mess around with it
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 »

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

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
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2017-18 BBKL Google Sheets

Post by 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?
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 »

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

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

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

Lee wroteCOLONTrying 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.
DETROIT RED WINGS | ROSTER | FANTRAX
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2017-18 BBKL Google Sheets

Post by Lee »

Ah okay I thought we did that last year.
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 »

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

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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
timwebb1212
PostsCOLON 720
JoinedCOLON Wed Aug 10, 2016 9:40 pm

Re: 2017-18 BBKL Google Sheets

Post by timwebb1212 »

How do we do the lineup? You say put it in Column L but I can't edit that
Sensfanjosh
PostsCOLON 4043
JoinedCOLON Sun Nov 06, 2011 5:09 pm

Re: 2017-18 BBKL Google Sheets

Post by 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?
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 »

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.
Image
Click banner to view current roster and picks
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 »

Sensfanjosh wroteCOLONAlso, 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.
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 »

Shoalzie wroteCOLON
Sensfanjosh wroteCOLONAlso, 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.
Image
Sensfanjosh
PostsCOLON 4043
JoinedCOLON Sun Nov 06, 2011 5:09 pm

Re: 2017-18 BBKL Google Sheets

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

Return to