2017-18 BBKL Google Sheets

[thom54]

Right. I've got all the information on my end so when players are moved team-to-team, the information goes with them. It's meant so you guys don't have to enter any of this info again.

I can scan your roster and fill in some of the contracts for you if you'd like. I'm going team-by-team on CapFriendly to confirm/update each player but I can focus on players you guys have on your sheets. I'm using all the information CapFriendly provides for current and future projects. I'm not just entering AAV.

yea ok makes sense, sounds pretty labour intensive.

If you think of a way we could help (like 4 people and you for the master list, which would make it easier!) let us know!

[Lee]

Right. I've got all the information on my end so when players are moved team-to-team, the information goes with them. It's meant so you guys don't have to enter any of this info again.

I can scan your roster and fill in some of the contracts for you if you'd like. I'm going team-by-team on CapFriendly to confirm/update each player but I can focus on players you guys have on your sheets. I'm using all the information CapFriendly provides for current and future projects. I'm not just entering AAV.

Hey, I've been holding off on playing with this further until my sheet was updated. WOuld you mind?

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

[Shoalzie]

I'll get the veteran players entered first, Lee. I'm sure you'll have some guys on ELC that you can slide but I'll get to those later.

I think most of us are concerned with what our lineups will look like and how that looks against the cap. As you guys are plugging names into your sheets, I'll see what veterans are missing key info and I'll give them priority.

[Lee]

Okay, was more interested in my kids to see who can slide as I have some players to divest myself of (at 101) and contract status will play a role in who I can keep.

[Shoalzie]

I see...I'll do what I can.

[Lee]

<3

[Sensfanjosh]

Hey Scott, when you move a player from reserve to active etc. (column I moves) it moves everyone at the same position in column M below them around. For example I moved Pateryn from my bench to active, and he went to the top of my list of D, this moved every defensemen on my roster in column M down a row, but each row kept its position designation (D1, D3, D5 etc.) which makes a mess of my team each time I try to make a roster move. Is there anything we can do about this or am I doing something wrong?

[Shoalzie]

You're not doing anything wrong. The filtered lists are alphabetized when they appear in that middle section. If you do make a change to your active players, it'll shuffle your order around. Let's say you selected Zarley Zalapski to be active first and then picked Aaron Miller as active second...Miller would show up first on the list and Zalapski would appear second.

You guys don't need to do the D1, C2, W5, etc. designations...that's all optional. I know I've goofed myself up a couple times with this filtered list thing. I was trying something different but it might end up being a bigger pain in the butt. I'll see how it goes.

[bills09]

Patrick Sharp no salary
Calle Jarnkrok listed as C/W

[Arian The Insider]

Thanks Scott. Works great as usual.

[The BBKL Insider]

awesome work scott, I love it.

[Shoalzie]

Right. I've got all the information on my end so when players are moved team-to-team, the information goes with them. It's meant so you guys don't have to enter any of this info again.

I can scan your roster and fill in some of the contracts for you if you'd like. I'm going team-by-team on CapFriendly to confirm/update each player but I can focus on players you guys have on your sheets. I'm using all the information CapFriendly provides for current and future projects. I'm not just entering AAV.

Hey, I've been holding off on playing with this further until my sheet was updated. WOuld you mind?

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

Check your stuff out now, Lee...

[Lee]

Thank you so much dude, I really do appreciate it.

I have another round of players to add contracts for but I'll send those off to you later.

[Shoalzie]

I owe Thom some contract updates...I'll get to that on Sunday when I get back to town.

[Shoalzie]

As I add some of the ELCs...Lee has done so already...any player with "Eligible" in column M on the Roster sheet...those players can have their contract slide. Post who you want to slide and I'll add that designation to the database.

[kimmer]

Im not able to enter and see Vadim Shipachyov in roster cell

edit: nm, looks like those whose info is incomplete in your system shows up blank

[Shoalzie]

He's there...just hadn't entered all of his info yet.

[Shoalzie]

I'm going to have some free time this weekend to check on progress with your sheets. I'll fill in any missing info for players on your 'Roster' sheet. I've seen about half the teams have started using their sheets. It's early August so no rush...I'm here if you have any questions.'

I also need to get caught up on some of the recent trades you guys have made.

[Handsome&FairMike]

Did you send them to everyone scott?

[The BBKL Insider]

I'm going to have some free time this weekend to check on progress with your sheets. I'll fill in any missing info for players on your 'Roster' sheet. I've seen about half the teams have started using their sheets. It's early August so no rush...I'm here if you have any questions.'

I also need to get caught up on some of the recent trades you guys have made.

Do you want a list of my roster players missing contracts? I can update you?