2016-17 BBKL Google Sheets

[Shoalzie]

Database update...all contracted players now have birthdate and GP.

Any player without a contract on your roster that I haven't filled in their birthdate and GP, you can treat them as waiver exempt. That will be their status regardless.

I will post a FAQ for the sheets tonight.

[Shoalzie]

Got back later than I thought...had to get caught up on the waiver draft first.

[koomzzz]

Something wonky going on with the contracts on my roster page. The "UFA" for Stamkos in 2024-25 is showing up next to Nikita Jevpalovs way down the sheet, but the rest of his info is correct.

[Mike]

Probably a cut + paste error and it's referencing the old cell location.

[koomzzz]

Probably a cut + paste error and it's referencing the old cell location.

thought that was the case, but if i replace Stamkos with someone else, everything shows up perfectly correct.

no matter where i put stamkos, his "UFA" designation is a bunch of rows too low.

sorry mike. no idea why i sent this as a PM first

[Shoalzie]

That's on me for not telling you all how to use these.

[Lee]

My sheet is still jacked. Most of my slide eligibles aren't showing and it's showing Nick Jensen as slide eligible. Maybe we just need to upload a new sheet and I won't cut and paste?

[Shoalzie]

I'll check your stuff on my lunch hour.

Again, I apologize for not giving better instructions.

[KapG]

My sheets nearing completion

Sorry I'm so lazy

Shoalzie, I'd buy you a beer or smoke you up on some shatter if I could. Your time and effort is most appreciated

[kimmer]

I wanna see shoalzie high

Fuck guy lives in detroit
He prolly smokes up after a 6am jog

[dave1959]

thanks for fixing my sheet Scott

[Shoalzie]

Lee, Dave and Koomz...I've addressed your issues.

[koomzzz]

Lee, Dave and Koomz...I've addressed your issues.

Thanks man, sorry about the nagging

[Lee]

Thank you, sir.

[Lee]

I love you Scott.

Erik Gustafsson is borked as well.
Same with Alan Lyszczarczyk

[Shoalzie]

I'll fill you guys in on the players with the same name...there's two Erik Gustafssons.

[Lee]

Okay, I have the CHI one

[Nick]

Although I think I can tweak the layout some more after working on it last night, I'm at least ready to share the current layout of our new Google sheets.

2016-17 Folder:
https://drive.google.com/folderview?id= ... sp=sharing

BLANK Sheets:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Detroit:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

*The Detroit is the working file that I'm using for my roster.

So... do I need to get a sheet sent to me or do I just start populating ?

EDIT: nvm -> sent you an edit permission request.

[Chuck Norris]

Scott this sheet is absolutely amazing! I have no clue how long it took you to do all this but it has to have been a long time - Well done!

Couple minor issues with my sheets:

- Matt Luff isnt recognized - tried full and shortened first name
- Cole Cassels has no brithday but everything else is correct
- A few undrafted/unsigned guys arent recognized
- Parise's final year of contract showing up under Wisnewski - was not cut/paste error as I did not cut/paste when it showed up

Whenever you have time to look.

Thanks!

[kimmer]

Dmitry Orlov
lol that was easy

there aren't only two spellings for that name bro, lol racist much

Dmitry
Dimitri
Dimitry
Dmitri
Dmitry
Dmitrij

and there are more too lol