Page 4 of 6

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 8:37 am
by thom54
Shoalzie wrote: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!

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 9:00 am
by Lee
Shoalzie wrote: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

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 9:31 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 9:32 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 9:47 am
by Shoalzie
I see...I'll do what I can.

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 10:04 am
by Lee
<3

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 10:48 am
by 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?

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 10:58 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 1:45 pm
by bills09
Patrick Sharp no salary
Calle Jarnkrok listed as C/W

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 1:55 pm
by Arian The Insider
Thanks Scott. Works great as usual.

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 1:59 pm
by The BBKL Insider
awesome work scott, I love it.

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 7:10 pm
by Shoalzie
Lee wrote:
Shoalzie wrote: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...

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Jul 21, 2017 11:15 pm
by 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.

Re: 2017-18 BBKL Google Sheets

PostPosted: Sat Jul 22, 2017 6:58 am
by Shoalzie
I owe Thom some contract updates...I'll get to that on Sunday when I get back to town.

Re: 2017-18 BBKL Google Sheets

PostPosted: Sat Jul 22, 2017 7:09 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostPosted: Mon Jul 31, 2017 3:34 pm
by 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

Re: 2017-18 BBKL Google Sheets

PostPosted: Mon Jul 31, 2017 4:19 pm
by Shoalzie
He's there...just hadn't entered all of his info yet.

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Aug 04, 2017 6:44 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Aug 04, 2017 6:45 am
by Handsome&FairMike
Did you send them to everyone scott?

Re: 2017-18 BBKL Google Sheets

PostPosted: Fri Aug 04, 2017 6:47 am
by The BBKL Insider
Shoalzie wrote: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?