Page 3 of 12

Re: 2017-18 BBKL Google Sheets

PostedCOLON Wed Jul 05, 2017 4:41 pm
by Shoalzie
Sensfanjosh wroteCOLONWhen 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Wed Jul 05, 2017 4:50 pm
by Sensfanjosh
Okay when I've added names to the relief spot it doesn't appear to do anything

Re: 2017-18 BBKL Google Sheets

PostedCOLON Wed Jul 05, 2017 8:23 pm
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Thu Jul 06, 2017 4:19 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Thu Jul 06, 2017 8:48 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Jul 07, 2017 9:07 am
by 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

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Jul 07, 2017 9:37 am
by kimmer
U sure suck at computer software related things lee. I tjouhht thoughtu was an IT guy...wtf..

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Jul 07, 2017 9:46 am
by Lee
excel = IT

?

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Jul 07, 2017 3:06 pm
by Shoalzie
Definitely don't cut any cells. Only copy.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Jul 07, 2017 5:11 pm
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Sun Jul 09, 2017 8:30 am
by Shoalzie
Lee wroteCOLONI 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Mon Jul 17, 2017 1:25 pm
by Tony
Do cap hits get updated when fantrax updates them?

Re: 2017-18 BBKL Google Sheets

PostedCOLON Thu Jul 20, 2017 4:53 pm
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Thu Jul 20, 2017 6:13 pm
by Tony
If you need me (us) to do anything, don't hesitate to ask.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Jul 21, 2017 7:19 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Jul 21, 2017 7:26 am
by foofnik
I can enter names but 0 info shows up at all, tells me it's out of range

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Jul 21, 2017 7:38 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Jul 21, 2017 7:53 am
by thom54
Shoalzie wroteCOLONGood 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?

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Jul 21, 2017 8:21 am
by 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.

Re: 2017-18 BBKL Google Sheets

PostedCOLON Fri Jul 21, 2017 8:31 am
by foofnik
When I put Sekera on LTIR, what status do I set him as? IR?