2017-18 BBKL Google Sheets

Anything goes here OT stuff is OK too!

Re: 2017-18 BBKL Google Sheets

Postby thom54 » Fri Jul 21, 2017 8:37 am

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!
User avatar
thom54
 
Posts: 5706
Joined: Mon Mar 12, 2012 4:00 pm
Location: Kingston, ON

Re: 2017-18 BBKL Google Sheets

Postby Lee » Fri Jul 21, 2017 9:00 am

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
User avatar
Lee
 
Posts: 15811
Joined: Tue Jun 15, 2010 12:29 pm
Location: Calgary, AB

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Jul 21, 2017 9:31 am

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.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7948
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Lee » Fri Jul 21, 2017 9:32 am

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
Lee
 
Posts: 15811
Joined: Tue Jun 15, 2010 12:29 pm
Location: Calgary, AB

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Jul 21, 2017 9:47 am

I see...I'll do what I can.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7948
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Lee » Fri Jul 21, 2017 10:04 am

<3
User avatar
Lee
 
Posts: 15811
Joined: Tue Jun 15, 2010 12:29 pm
Location: Calgary, AB

Re: 2017-18 BBKL Google Sheets

Postby Sensfanjosh » Fri Jul 21, 2017 10:48 am

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
Sensfanjosh
 
Posts: 3463
Joined: Sun Nov 06, 2011 5:09 pm

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Jul 21, 2017 10:58 am

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.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7948
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby bills09 » Fri Jul 21, 2017 1:45 pm

Patrick Sharp no salary
Calle Jarnkrok listed as C/W
Image
bills09
 
Posts: 8582
Joined: Mon May 03, 2010 5:10 pm
Location: Pickering, Ontario

Re: 2017-18 BBKL Google Sheets

Postby Arian The Insider » Fri Jul 21, 2017 1:55 pm

Thanks Scott. Works great as usual.
Click Oilers image below for full team roster
Image
User avatar
Arian The Insider
 
Posts: 5974
Joined: Mon May 03, 2010 7:05 pm
Location: Somalia

Re: 2017-18 BBKL Google Sheets

Postby The BBKL Insider » Fri Jul 21, 2017 1:59 pm

awesome work scott, I love it.
Image
User avatar
The BBKL Insider
 
Posts: 21143
Joined: Mon May 03, 2010 8:46 pm
Location: San Juan, Puerto Rico

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Jul 21, 2017 7:10 pm

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...
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7948
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Lee » Fri Jul 21, 2017 11:15 pm

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
Lee
 
Posts: 15811
Joined: Tue Jun 15, 2010 12:29 pm
Location: Calgary, AB

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Jul 22, 2017 6:58 am

I owe Thom some contract updates...I'll get to that on Sunday when I get back to town.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7948
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Jul 22, 2017 7:09 am

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.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7948
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby kimmer » Mon Jul 31, 2017 3:34 pm

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
2017-2018 Transactions
CAR Google Sheet

- A true liberator of the apprehensive voice -
User avatar
kimmer
 
Posts: 15872
Joined: Thu Sep 02, 2010 2:25 pm
Location: Markham, Ontario

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Mon Jul 31, 2017 4:19 pm

He's there...just hadn't entered all of his info yet.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7948
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Aug 04, 2017 6:44 am

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.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7948
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Handsome&FairMike » Fri Aug 04, 2017 6:45 am

Did you send them to everyone scott?
User avatar
Handsome&FairMike
 
Posts: 2736
Joined: Fri Jul 11, 2014 9:41 am
Location: Toronto, ON

Re: 2017-18 BBKL Google Sheets

Postby The BBKL Insider » Fri Aug 04, 2017 6:47 am

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?
Image
User avatar
The BBKL Insider
 
Posts: 21143
Joined: Mon May 03, 2010 8:46 pm
Location: San Juan, Puerto Rico

PreviousNext

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 4 guests