2018-19 BBKL Google Sheets

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

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

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

#mikproblems

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

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

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

[kyuss]

You 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

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

[kyuss]

thanks!

[Bruyns]

You'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.

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

[Bruyns]

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.

I was looking at 20, that was likely the issue.

Thanks!

[kimmer]

I've pretty much just been unhiding them myself for my sheet lol

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

[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

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

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

[kyuss]

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.

if you want? it's the only way to check up the lineup vs cap & roster limitations..

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