2016-17 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: 2016-17 BBKL Google Sheets

Post by Shoalzie »

I'll check out your sheet later, Lee.

I'll post some FAQ for the sheets now that most of you have access and you're using them.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2016-17 BBKL Google Sheets

Post by Shoalzie »

I fixed your sheet, Lee. I'm going to assume you cut and paste some names...yeah, that screws up the formulas. You can copy and paste but don't cut and paste.
DETROIT RED WINGS | ROSTER | FANTRAX
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2016-17 BBKL Google Sheets

Post by Lee »

boo
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2016-17 BBKL Google Sheets

Post by Lee »

Thanks man, looking good. Any word about slides?
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2016-17 BBKL Google Sheets

Post by Shoalzie »

Right...forgot mention that. We'll do like what we did last year...we'll have a thread where everyone posts who they are sliding. I'll enter the status on the database.

If you want to know who is eligible to slide, the green "!" in column J on the weekly sheets...that's your indicator. If I don't have the birthdate and GP entered for a player, that status won't show up and obviously this only applies to player with a contract. I do have all the active contracts entered.
DETROIT RED WINGS | ROSTER | FANTRAX
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: 2016-17 BBKL Google Sheets

Post by Lee »

Thanks.

Would be nice if we could put over agers that are in the CHL as sliders
User avatar
koomzzz
PostsCOLON 1245
JoinedCOLON Wed May 25, 2016 2:15 pm
LocationCOLON Cleveland, OH

Re: 2016-17 BBKL Google Sheets

Post by koomzzz »

koomzzz wroteCOLONLTIR players aren't included in the cap calculation.

additionally the REL slots for LTIR relief do not populate with a cap hit when you add a player as cap relief. The formula for cap hits on the REL list should include column B, and then look up the 5th value from there, i think that would fix that
to follow up on this. I tried putting Grabovski in LTIR1 slot. once I do so, his salary is subtracted from the total. and adding REL1 to Greening puts his name in the REL1 slot, but no salary next to his name, but since Grabovski's contract already subtracted then I guess not a big deal. But adding REL2 to Raffl, nothing happens, he doesn't appear in the REL2 slot. Just a heads up
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2016-17 BBKL Google Sheets

Post by Shoalzie »

Okay, thanks for clarifying. Let me check that out right now.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2016-17 BBKL Google Sheets

Post by Shoalzie »

Yeah, just an issue with the formula...referencing the wrong columns. Fixed it on your sheet. I'll go through and correct it on everyone else's later.

*NOTE TO SELF*
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Matthew
PostsCOLON 13682
JoinedCOLON Wed Oct 08, 2014 3:29 pm

Re: 2016-17 BBKL Google Sheets

Post by Matthew »

Hey, scott. Could you hook the new gm loki up with a google docs sheet, please?

Thanks.
ANAHEIM DUCKS | FANTRAX |
User avatar
hong57
PostsCOLON 7106
JoinedCOLON Mon May 03, 2010 7:38 pm

Re: 2016-17 BBKL Google Sheets

Post by hong57 »

when is the season gonna start? coz im taking vacation to greece on oct 8.. i wanna make sure my team is ready and beat up everyone as always
Image
#91 - John Tavares
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2016-17 BBKL Google Sheets

Post by Shoalzie »

Matthew wroteCOLONHey, scott. Could you hook the new gm loki up with a google docs sheet, please?

Thanks.

Yup, I've got the Devils sheet made from before for devily. I just need an e-mail, sir...
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Loki
PostsCOLON 1938
JoinedCOLON Mon Sep 26, 2016 4:38 pm
LocationCOLON Melbourne, AUS

Re: 2016-17 BBKL Google Sheets

Post by Loki »

Shoalzie wroteCOLON
Matthew wroteCOLONHey, scott. Could you hook the new gm loki up with a google docs sheet, please?

Thanks.

Yup, I've got the Devils sheet made from before for devily. I just need an e-mail, sir...
Awesome thanks. I'll message you my email now. :)
User avatar
kimmer
PostsCOLON 18090
JoinedCOLON Thu Sep 02, 2010 2:25 pm
LocationCOLON Ontario, Canada

Re: 2016-17 BBKL Google Sheets

Post by kimmer »

When r u gonna update the automated picks tab
I traded multiple picks last few days and spreadsheet not updating it
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2016-17 BBKL Google Sheets

Post by Shoalzie »

You should be good now.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
foofnik
PostsCOLON 1572
JoinedCOLON Sun May 31, 2015 2:58 pm
LocationCOLON Long Island, New York

Re: 2016-17 BBKL Google Sheets

Post by foofnik »

I'm missing the 2018 CHI 1st on mine

http://bbkl.ca/viewtopic.php?f=76&t=13626
User avatar
koomzzz
PostsCOLON 1245
JoinedCOLON Wed May 25, 2016 2:15 pm
LocationCOLON Cleveland, OH

Re: 2016-17 BBKL Google Sheets

Post by koomzzz »

to follow up on the LTIR issue.

1. thanks shoalzie for fixing up the formulas to correct the salaries and players filling cells
2. the salary for LTIR player is removed from the total salary, and then the REL players are also removed

for example: Grabovski's $5mil subtracted from the total, and then an additional $5mil is subtracted for the REL1 and REL2 players. So it says I have almost $13mil in cap space, but in reality I should have $5mil less than that. If this makes any sense
User avatar
Tony
PostsCOLON 11222
JoinedCOLON Mon May 03, 2010 10:29 pm
LocationCOLON Nevada

Re: 2016-17 BBKL Google Sheets

Post by Tony »

Very small thing (and really doesn't matter much at the moment) but I have the younger Erik Nystrom (MTL pick) and is showing up as the older dude.
Image
Click banner to view current roster and picks
User avatar
koomzzz
PostsCOLON 1245
JoinedCOLON Wed May 25, 2016 2:15 pm
LocationCOLON Cleveland, OH

Re: 2016-17 BBKL Google Sheets

Post by koomzzz »

also extremely irrelevant. i'm missing 2017 waiver pick. figured i should at least mention it
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2016-17 BBKL Google Sheets

Post by Shoalzie »

Everyone is missing the 2017 waiver picks...those will be added as well as 2018 when I get a chance.
DETROIT RED WINGS | ROSTER | FANTRAX
BUTTON_POST_REPLY

Return to