2016-17 BBKL Google Sheets

[Matthew]

Hook me up, scotty.

[Shoalzie]

I need to attach an e-mail to your sheet, friend.

[Robin Hood]

Scott! This is FUCKING AMAZING.

Thank you so much for doing this. I appreciate you for all the time and effort you are putting into this.

You are a rockstar.

[Shoalzie]

Sheets have been created for every team. If you want access...send me your e-mail.

[thom54]

+1 to Shiv's comment. It's an amazing sheet!

[CAM]

Agree, very well done and very helpful. Thank You!

[CAM]

I seem to have a bunch of January 0, 1900 birthdays therefore calculating waiver eligibility is not working. Is there something i need to do to correct this?

[kimmer]

do u ever read?
he said don't fuckin worry about ANYTHING

don't worry about anything that u see as "bug"
he is slowly updating database
it will be fully automated and don't fukin touch anything other than names tab!! god

[CAM]

No i dont read anything because you fucking spam the fuck out of this entire place with your bullshit uselessness. Why dont you just quit already......oh thats right...

[kimmer]

Lol
Got him mad

[CAM]

yep...u did...

[Lee]

The sad part is that shit birds like Paul don't care that they just make the internet a worse place.

[Shoalzie]

I seem to have a bunch of January 0, 1900 birthdays therefore calculating waiver eligibility is not working. Is there something i need to do to correct this?

I'm working on it. The formulas are in place for when the date is entered, the correct status will appear. I'm still in the data entry process with birthrates and GP. Same goes for contract slide eligibility. Contracts are entered so you don't have to worry about that.

You only have to deal with this just for this summer. I'll only need to update GP and contracts and add the 2017 draft class.

[kimmer]

Not rly worried about that
Problem is guys like u make the real world a worse place

[CAM]

I seem to have a bunch of January 0, 1900 birthdays therefore calculating waiver eligibility is not working. Is there something i need to do to correct this?

I'm working on it. The formulas are in place for when the date is entered, the correct status will appear. I'm still in the data entry process with birthrates and GP. Same goes for contract slide eligibility. Contracts are entered so you don't have to worry about that.

You only have to deal with this just for this summer. I'll only need to update GP and contracts and add the 2017 draft class.

Sounds good Scott. Thanks for the update.

[Tony]

Done (finally). Pretty awesome, Scott.

All cap info looks good. Just have quite a few NHL roster player info rows empty which I apparently don't need to worry about right now.

[hong57]

thanks again scott, words just can't describe how amazing this is, please just accept my kiss

[Shoalzie]

Plugging away on the info...should be done with the veteran players at some point this week and onto prospects by the weekend.

If you haven't sent me your e-mail to get access to your sheet, please do so.

[koomzzz]

LTIR players aren't included in the cap calculation.

additionally the REL slots for LTIR relief do not populate with a cap hit when you add a player as cap relief. The formula for cap hits on the REL list should include column B, and then look up the 5th value from there, i think that would fix that

[Shoalzie]

Okay, I'll check it out.