2017-18 BBKL Google Sheets

Anything goes here OT stuff is OK too!
BUTTON_POST_REPLY
User avatar
thom54
PostsCOLON 7459
JoinedCOLON Mon Mar 12, 2012 4:00 pm
LocationCOLON Kingston, ON

Re: 2017-18 BBKL Google Sheets

Post by thom54 »

Shoalzie wroteCOLONRight. 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
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2017-18 BBKL Google Sheets

Post by Lee »

Shoalzie wroteCOLONRight. 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
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2017-18 BBKL Google Sheets

Post 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.
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post by Shoalzie »

I see...I'll do what I can.
DETROIT RED WINGS | ROSTER | FANTRAX
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2017-18 BBKL Google Sheets

Post by Lee »

<3
Sensfanjosh
PostsCOLON 4043
JoinedCOLON Sun Nov 06, 2011 5:09 pm

Re: 2017-18 BBKL Google Sheets

Post 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?
Image
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
bills09
PostsCOLON 9280
JoinedCOLON Mon May 03, 2010 5:10 pm
LocationCOLON Pickering, Ontario

Re: 2017-18 BBKL Google Sheets

Post by bills09 »

Patrick Sharp no salary
Calle Jarnkrok listed as C/W
Image
User avatar
Arian The Insider
PostsCOLON 7304
JoinedCOLON Mon May 03, 2010 7:05 pm

Re: 2017-18 BBKL Google Sheets

Post by Arian The Insider »

Thanks Scott. Works great as usual.
Click Oilers image below for full team roster
Image
User avatar
The BBKL Insider
PostsCOLON 22628
JoinedCOLON Mon May 03, 2010 8:46 pm
LocationCOLON San Juan, Puerto Rico

Re: 2017-18 BBKL Google Sheets

Post by The BBKL Insider »

awesome work scott, I love it.
Image
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post by Shoalzie »

Lee wroteCOLON
Shoalzie wroteCOLONRight. 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...
DETROIT RED WINGS | ROSTER | FANTRAX
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2017-18 BBKL Google Sheets

Post 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.
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post by Shoalzie »

I owe Thom some contract updates...I'll get to that on Sunday when I get back to town.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
kimmer
PostsCOLON 18090
JoinedCOLON Thu Sep 02, 2010 2:25 pm
LocationCOLON Ontario, Canada

Re: 2017-18 BBKL Google Sheets

Post 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
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post by Shoalzie »

He's there...just hadn't entered all of his info yet.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2017-18 BBKL Google Sheets

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
Handsome&FairMike
PostsCOLON 4810
JoinedCOLON Fri Jul 11, 2014 9:41 am
LocationCOLON Wolfville, NS

Re: 2017-18 BBKL Google Sheets

Post by Handsome&FairMike »

Did you send them to everyone scott?
User avatar
The BBKL Insider
PostsCOLON 22628
JoinedCOLON Mon May 03, 2010 8:46 pm
LocationCOLON San Juan, Puerto Rico

Re: 2017-18 BBKL Google Sheets

Post by The BBKL Insider »

Shoalzie wroteCOLONI'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?
Image
BUTTON_POST_REPLY

Return to