2017-18 BBKL Google Sheets

Anything goes here OT stuff is OK too!

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Wed Jul 05, 2017 4:41 pm

Sensfanjosh wrote:When I added Hossa to IR, he automatically also went into all of my LTIR slots as well-

Also where do we actually name guys as LTIR relief?



When you use the "Inj Res" role, that applies to both IR and LTIR. I got rid of the REL column on the old sheet so you guys just enter the names for LTIR and Relief manually.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7685
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Sensfanjosh » Wed Jul 05, 2017 4:50 pm

Okay when I've added names to the relief spot it doesn't appear to do anything
Image
User avatar
Sensfanjosh
 
Posts: 3403
Joined: Sun Nov 06, 2011 5:09 pm

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Wed Jul 05, 2017 8:23 pm

Added some of those missing names...you should be good with adding those to your roster now. Let me know if anyone is still not able to enter a specific name.

I fixed the goof ups on the LTIR spots. There's a reason I do this beta test with just a few teams because I can't imagine making all these changes times 31. Trying to iron out the kinks before we go league-wide.

I'll continue to work on adding info for all your players.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7685
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby thom54 » Thu Jul 06, 2017 4:19 am

lineups work now! Great drop down option.

Ok, so for my C5 and D7, the alignment in the cell is left, not centered like the rest. Not sure if that's on purpose or not.
User avatar
thom54
 
Posts: 5471
Joined: Mon Mar 12, 2012 4:00 pm
Location: Kingston, ON

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Thu Jul 06, 2017 8:48 am

If I can get the last of these nagging format issues out of the way...I'll finish the missing info you guys have. It looks like we might be good now but let me know if something else seems strange.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7685
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Lee » Fri Jul 07, 2017 9:07 am

I have Frederick Gaudreau listed as a c/w and when I make him active, he doesn't appear on my skaters list.

Also may be a copy / paste error but Fucale is showing as being on Detroit. I did not use cut and paste.

Edit 3: Yup, think I borked my sheet it doesn't like copy pasting
User avatar
Lee
 
Posts: 15649
Joined: Tue Jun 15, 2010 12:29 pm
Location: Calgary, AB

Re: 2017-18 BBKL Google Sheets

Postby kimmer » Fri Jul 07, 2017 9:37 am

U sure suck at computer software related things lee. I tjouhht thoughtu was an IT guy...wtf..
2017-2018 Transactions
CAR Google Sheet

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

Re: 2017-18 BBKL Google Sheets

Postby Lee » Fri Jul 07, 2017 9:46 am

excel = IT

?
User avatar
Lee
 
Posts: 15649
Joined: Tue Jun 15, 2010 12:29 pm
Location: Calgary, AB

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Jul 07, 2017 3:06 pm

Definitely don't cut any cells. Only copy.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7685
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Jul 07, 2017 5:11 pm

Just made another update...as per suggestion from Mr. Dawson.

When you enter a name in any LTIR slots, you're only able to enter the name of a player that you've assigned to the "Inj Res" role and they appear in those IR slots.

And with the relief slots, you can only enter players you've entered in the "Active" and "Reserve" roles.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7685
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sun Jul 09, 2017 8:30 am

Lee wrote:I have Frederick Gaudreau listed as a c/w and when I make him active, he doesn't appear on my skaters list.

Also may be a copy / paste error but Fucale is showing as being on Detroit. I did not use cut and paste.

Edit 3: Yup, think I borked my sheet it doesn't like copy pasting




I took the positions from Fantrax so there's quite a few guys with the C/W designation. That does screw up what I'm trying to with the filtering function when you pick your "Active" players.

I can change a few guys around to a single position so you can put them in your lineup. As I mentioned, I'd like to integrate Mik's in-season positional updates to the database. I want to make sure players are being listed properly as either C or W.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7685
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Tony » Mon Jul 17, 2017 1:25 pm

Do cap hits get updated when fantrax updates them?
Image
Click banner to view current roster and picks
User avatar
Tony
 
Posts: 10103
Joined: Mon May 03, 2010 10:29 pm
Location: Nevada

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Thu Jul 20, 2017 4:53 pm

Fantrax is fairly unreliable for salary info. I'm getting all that data from CapFriendly and I'm updating that info manually. That'll be an ongoing process.

I've not seen or heard other complaints or seen any other errors from the sheets other than the information needing to be updated. I think I'll work on getting sheets out to the rest of the league starting tonight. I appreciate everyone's patience while we did this trial run.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7685
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Tony » Thu Jul 20, 2017 6:13 pm

If you need me (us) to do anything, don't hesitate to ask.
Image
Click banner to view current roster and picks
User avatar
Tony
 
Posts: 10103
Joined: Mon May 03, 2010 10:29 pm
Location: Nevada

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Jul 21, 2017 7:19 am

Okay, everyone has a sheet. Forum link is updated as well so you can view the folder for this season.

I'll be out of town most of this weekend but send me any questions or feedback that you may have.

The issues I'm already aware of:
1. Any missing salary, birthdate and/or GP information. That's an ongoing process. Everyone will have some missing information here and there.
2. The issue with any players that aren't listed as "C", "W", "D" or "G" for their position. It will affect you being able to put them in your lineup. I'll assign them a single position. I think most of the issues remain with forwards being listed as "C, W". Those positions were from Fantrax.

Let me know of any player names you're unable to enter on your sheet. That tells me who isn't in my database. I'll add them as soon as possible.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7685
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby foofnik » Fri Jul 21, 2017 7:26 am

I can enter names but 0 info shows up at all, tells me it's out of range
User avatar
foofnik
 
Posts: 861
Joined: Sun May 31, 2015 2:58 pm
Location: Long Island, New York

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Jul 21, 2017 7:38 am

Good catch, looks like I need to make sure the database is importing to each of your sheets. Some of the import links stay intact and some don't.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7685
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby thom54 » Fri Jul 21, 2017 7:53 am

Shoalzie wrote:Good catch, looks like I need to make sure the database is importing to each of your sheets. Some of the import links stay intact and some don't.



is it that YOU need to enter in the new contracts to your database- so there's one master sheet? AKA I cannot just toss in the information from capfriendly on my Roster sheet?
User avatar
thom54
 
Posts: 5471
Joined: Mon Mar 12, 2012 4:00 pm
Location: Kingston, ON

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Jul 21, 2017 8:21 am

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

Re: 2017-18 BBKL Google Sheets

Postby foofnik » Fri Jul 21, 2017 8:31 am

When I put Sekera on LTIR, what status do I set him as? IR?
User avatar
foofnik
 
Posts: 861
Joined: Sun May 31, 2015 2:58 pm
Location: Long Island, New York

PreviousNext

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 2 guests