2018-19 BBKL Google Sheets

Anything goes here OT stuff is OK too!
BUTTON_POST_REPLY
User avatar
kyuss
PostsCOLON 14876
JoinedCOLON Thu May 06, 2010 12:54 pm

Re: 2018-19 BBKL Google Sheets

Post by kyuss »

Scott can you add at least the next week with some advance so that it is possible to play around with the roster/lineup before the roster lock day?
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2018-19 BBKL Google Sheets

Post by Shoalzie »

You guys can unhide the future sheets...I just need update a couple formulas.

The waiver list and the player count was done incorrectly but I didn't catch the error until I gave you all the sheets.

This won't be an issue next season.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
kyuss
PostsCOLON 14876
JoinedCOLON Thu May 06, 2010 12:54 pm

Re: 2018-19 BBKL Google Sheets

Post by kyuss »

I did for the last two weeks, but noticed for some reasons the system that way only counts 81 of my players.

Anyways, can we have new spreadsheet for week #21 updated with the last trades? to be able to play with our lineups and see where we stand as the trade deadline approaches..
Handsome&FairMike
PostsCOLON 4810
JoinedCOLON Fri Jul 11, 2014 9:41 am
LocationCOLON Wolfville, NS

Re: 2018-19 BBKL Google Sheets

Post by Handsome&FairMike »

#mikproblems
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2018-19 BBKL Google Sheets

Post by Shoalzie »

The sheets do work...just need to fix two cells.

I'll do my best to keep up with our deadline trades this weekend. I'll catch up on draft picks post-deadline.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
kyuss
PostsCOLON 14876
JoinedCOLON Thu May 06, 2010 12:54 pm

Re: 2018-19 BBKL Google Sheets

Post by kyuss »

ok let me know when I can use week #21, or what I need to do myself to make it available in the correct form (with the current players)
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2018-19 BBKL Google Sheets

Post by Shoalzie »

You can un-hide the Week 21 sheet and use it now...I just need to edit two particular cells for everyone's sheet. That's been the story all season. The rosters and positions are updated...I'll do my best to keep up with you guys leading into Monday.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
kyuss
PostsCOLON 14876
JoinedCOLON Thu May 06, 2010 12:54 pm

Re: 2018-19 BBKL Google Sheets

Post by kyuss »

Shoalzie wroteCOLONYou can un-hide the Week 21 sheet and use it now...
I can't add Rodrigues and Rittich, so it's not beneficial to use it until I can. The counter saying 81 players doesn't give me troubles, but not having the correct players means you can't use it to see how much cap room you have and what lineup you could ice at the moment
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2018-19 BBKL Google Sheets

Post by Shoalzie »

You're good now...thought I had updated my roster sheet from yesterday's trades. Got the BUF-OTT swap in there as well.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
kyuss
PostsCOLON 14876
JoinedCOLON Thu May 06, 2010 12:54 pm

Re: 2018-19 BBKL Google Sheets

Post by kyuss »

thanks!
User avatar
Bruyns
PostsCOLON 7177
JoinedCOLON Wed Apr 10, 2013 10:18 am

Re: 2018-19 BBKL Google Sheets

Post by Bruyns »

Shoalzie wroteCOLONYou're good now...thought I had updated my roster sheet from yesterday's trades. Got the BUF-OTT swap in there as well.
Can you check again? I still see Hamonic on my roster, just wanted to check if I can afford another move without LTIRing Hall retroactively.
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2018-19 BBKL Google Sheets

Post by Shoalzie »

I un-hid your Week 21 sheet...it should be there. Sometimes when I make changes between the times you view your sheets, it'll take a moment to show any updates.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Bruyns
PostsCOLON 7177
JoinedCOLON Wed Apr 10, 2013 10:18 am

Re: 2018-19 BBKL Google Sheets

Post by Bruyns »

Shoalzie wroteCOLONI un-hid your Week 21 sheet...it should be there. Sometimes when I make changes between the times you view your sheets, it'll take a moment to show any updates.
I was looking at 20, that was likely the issue.

Thanks!
User avatar
kimmer
PostsCOLON 18090
JoinedCOLON Thu Sep 02, 2010 2:25 pm
LocationCOLON Ontario, Canada

Re: 2018-19 BBKL Google Sheets

Post by kimmer »

I've pretty much just been unhiding them myself for my sheet lol
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2018-19 BBKL Google Sheets

Post by Shoalzie »

Up until Week 18, I'd go through unhide your next week's sheet and put the correct formulas in...team-by-team.

Next season, I'll quadruple/quintuple check my work so all you guys need to do is unhide your own sheets each week and fill them out yourself. I can probably have the sheets ready in the week or two but I'm just going to wait until the NHL season is done since we have a trade freeze after Monday. You guys can have your new sheets when moves can be done again and it can go towards next season. This extra time I'll use to make sure everything works as planned before I replicate them for each of you.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
kimmer
PostsCOLON 18090
JoinedCOLON Thu Sep 02, 2010 2:25 pm
LocationCOLON Ontario, Canada

Re: 2018-19 BBKL Google Sheets

Post by kimmer »

Might wanna come take a look at my CAR google sheet scott
I still have Jaccob Slavin on my roster tab which shouldn't be the case.
I dealt him a while ago on Oct 27 2018 for Jost + 2nd and wonder if there are more deals that haven't been updated on google sheet
My recent deal involving Aston-Reece haven't been updated either
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2018-19 BBKL Google Sheets

Post by Shoalzie »

The Roster tab has been screwy. I threw it together at the end when I did this stuff. That list is supposed to repopulate based on a variable signifying what week we're in...meaning, you'll see the most recent rosters. I just looked at my sheet and that's showing an old roster...still showing players that I've traded.

As long as your weekly lineup sheets are still working, just ignore that Roster tab. I'm changing that around for next season.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2018-19 BBKL Google Sheets

Post by Shoalzie »

With the sheets for the playoffs...I didn't really have anything set up for you guys beyond the regular season. Just copy Week 21 if you want. The only playoff team with a roster change during this past week was Mike losing Justin Braun to waivers. There shouldn't be any roster moves until our season is over.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
kyuss
PostsCOLON 14876
JoinedCOLON Thu May 06, 2010 12:54 pm

Re: 2018-19 BBKL Google Sheets

Post by kyuss »

Shoalzie wroteCOLONWith the sheets for the playoffs...I didn't really have anything set up for you guys beyond the regular season. Just copy Week 21 if you want.
if you want? it's the only way to check up the lineup vs cap & roster limitations..
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2018-19 BBKL Google Sheets

Post by Shoalzie »

I'm saying you can use Week 21 if you want re-use your lineup or copy the sheet and just edit the lineup for your new week.

I do have sheets for Week 22 and Week 23 but I made those not knowing how many weeks our schedule would be.

Do we typically have a 21 week regular season?
DETROIT RED WINGS | ROSTER | FANTRAX
BUTTON_POST_REPLY

Return to