2017-18 BBKL Google Sheets

Anything goes here OT stuff is OK too!
BUTTON_POST_REPLY
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 »

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.
DETROIT RED WINGS | ROSTER | FANTRAX
Sensfanjosh
PostsCOLON 4043
JoinedCOLON Sun Nov 06, 2011 5:09 pm

Re: 2017-18 BBKL Google Sheets

Post by Sensfanjosh »

Okay when I've added names to the relief spot it doesn't appear to do anything
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 »

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.
DETROIT RED WINGS | ROSTER | FANTRAX
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 »

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

Re: 2017-18 BBKL Google Sheets

Post 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.
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 »

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
kimmer
PostsCOLON 18090
JoinedCOLON Thu Sep 02, 2010 2:25 pm
LocationCOLON Ontario, Canada

Re: 2017-18 BBKL Google Sheets

Post by kimmer »

U sure suck at computer software related things lee. I tjouhht thoughtu was an IT guy...wtf..
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2017-18 BBKL Google Sheets

Post by Lee »

excel = IT

?
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 »

Definitely don't cut any cells. Only copy.
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 »

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

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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Tony
PostsCOLON 11222
JoinedCOLON Mon May 03, 2010 10:29 pm
LocationCOLON Nevada

Re: 2017-18 BBKL Google Sheets

Post by Tony »

Do cap hits get updated when fantrax updates them?
Image
Click banner to view current roster and picks
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 »

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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Tony
PostsCOLON 11222
JoinedCOLON Mon May 03, 2010 10:29 pm
LocationCOLON Nevada

Re: 2017-18 BBKL Google Sheets

Post by Tony »

If you need me (us) to do anything, don't hesitate to ask.
Image
Click banner to view current roster and picks
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 »

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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
foofnik
PostsCOLON 1572
JoinedCOLON Sun May 31, 2015 2:58 pm
LocationCOLON Long Island, New York

Re: 2017-18 BBKL Google Sheets

Post by foofnik »

I can enter names but 0 info shows up at all, tells me it's out of range
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 »

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.
DETROIT RED WINGS | ROSTER | FANTRAX
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 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?
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 »

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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
foofnik
PostsCOLON 1572
JoinedCOLON Sun May 31, 2015 2:58 pm
LocationCOLON Long Island, New York

Re: 2017-18 BBKL Google Sheets

Post by foofnik »

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

Return to