Page 6 of 10
Re: 2016-17 BBKL Google Sheets
PostedCOLON Tue Sep 13, 2016 8:42 am
by Matthew
Hook me up, scotty.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Tue Sep 13, 2016 9:45 am
by Shoalzie
I need to attach an e-mail to your sheet, friend.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Tue Sep 13, 2016 9:48 pm
by 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.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 6:34 am
by Shoalzie
Sheets have been created for every team. If you want access...send me your e-mail.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 6:36 am
by thom54
+1 to Shiv's comment. It's an amazing sheet!
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 7:08 am
by CAM
Agree, very well done and very helpful. Thank You!
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 8:10 am
by 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?
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 8:16 am
by 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
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 8:25 am
by 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...
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 8:33 am
by kimmer
Lol
Got him mad
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 8:53 am
by CAM
yep...u did...
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 8:57 am
by Lee
The sad part is that shit birds like Paul don't care that they just make the internet a worse place.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 9:17 am
by Shoalzie
CAM wroteCOLONI 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.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 9:17 am
by kimmer
Not rly worried about that
Problem is guys like u make the real world a worse place
Re: 2016-17 BBKL Google Sheets
PostedCOLON Wed Sep 14, 2016 9:54 am
by CAM
Shoalzie wroteCOLONCAM wroteCOLONI 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.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Thu Sep 15, 2016 1:36 am
by 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.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Thu Sep 15, 2016 2:03 am
by hong57
thanks again scott, words just can't describe how amazing this is, please just accept my kiss
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Sep 19, 2016 5:52 am
by 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.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Thu Sep 22, 2016 10:57 am
by 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
Re: 2016-17 BBKL Google Sheets
PostedCOLON Thu Sep 22, 2016 10:59 am
by Shoalzie
Okay, I'll check it out.