2017-18 BBKL Google Sheets

[Shoalzie]

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.

[Sensfanjosh]

Okay when I've added names to the relief spot it doesn't appear to do anything

[Shoalzie]

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.

[thom54]

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.

[Shoalzie]

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.

[Lee]

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

[kimmer]

U sure suck at computer software related things lee. I tjouhht thoughtu was an IT guy...wtf..

[Lee]

excel = IT

?

[Shoalzie]

Definitely don't cut any cells. Only copy.

[Shoalzie]

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.

[Shoalzie]

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.

[Tony]

Do cap hits get updated when fantrax updates them?

[Shoalzie]

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.

[Tony]

If you need me (us) to do anything, don't hesitate to ask.

[Shoalzie]

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.

[foofnik]

I can enter names but 0 info shows up at all, tells me it's out of range

[Shoalzie]

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.

[thom54]

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?

[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.

[foofnik]

When I put Sekera on LTIR, what status do I set him as? IR?