2017-18 BBKL Google Sheets

Anything goes here OT stuff is OK too!

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Aug 04, 2017 6:51 am

Handsome&FairMike wrote:Did you send them to everyone scott?



I used everyone's e-mail from last year. Let me know if you're using something different.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7688
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby timwebb1212 » Fri Aug 04, 2017 7:54 pm

Is the Salary Cap calculator on the "Preseason" tab correct? I'm not saying it isn't, but it's telling me I have 8.5M in space (although that doesn't include Gudbranson's 3.5) and I didn't think I had that much lol.

EDIT: Ok figured out that what was throwing me off is FT still shows Hartnell at his previous contract
User avatar
timwebb1212
 
Posts: 720
Joined: Wed Aug 10, 2016 9:40 pm

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Aug 25, 2017 5:42 am

Any of the missing contract info for all active players should be filled in now. I have some other active contracts I want to confirm on CapFriendly but you guys should have a good idea of your cap and contract situation if you've filled out your sheet.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7688
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Lee » Fri Aug 25, 2017 7:14 am

I'll check it. I had a bunch but was waiting for severson to sign before bothering you again.


thanks Scott.
User avatar
Lee
 
Posts: 15662
Joined: Tue Jun 15, 2010 12:29 pm
Location: Calgary, AB

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Fri Aug 25, 2017 8:32 am

I've focused on some of the main guys first and then I circled around and got the ELC and short term minor league players next. I think I've got every player currently under NHL contract covered. There's several RFAs and UFAs sitting out there.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7688
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby bills09 » Fri Aug 25, 2017 11:57 am

Incorrect salary for Cammalerri and Hunwick
Image
bills09
 
Posts: 8549
Joined: Mon May 03, 2010 5:10 pm
Location: Pickering, Ontario

Re: 2017-18 BBKL Google Sheets

Postby Loki » Fri Aug 25, 2017 9:06 pm

Thanks Scott, I'm missing a 1 year $650k contract for Patrick Cannone - https://www.capfriendly.com/players/patrick-cannone
Otherwise I think I'm all good
User avatar
Loki
 
Posts: 807
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2017-18 BBKL Google Sheets

Postby Loki » Sat Aug 26, 2017 2:23 am

It seems the forwards on my preseason sheet have gotten broken somehow too, they aren't coming up correctly to be assigned positions :(
Was working perfectly when I last checked it a few weeks back
User avatar
Loki
 
Posts: 807
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2017-18 BBKL Google Sheets

Postby Chuck Norris » Sat Aug 26, 2017 3:15 am

Some players with improper positions on my sheet:

Adam Lowry W -> C
Ryan Mantha W -> D

Matt Iacopelli is missing all the biographical details.
User avatar
Chuck Norris
 
Posts: 4057
Joined: Mon May 03, 2010 7:17 pm

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Aug 26, 2017 1:57 pm

Loki wrote:It seems the forwards on my preseason sheet have gotten broken somehow too, they aren't coming up correctly to be assigned positions :(
Was working perfectly when I last checked it a few weeks back



If you have more than 5 centers assigned as active, you'll get an error in your lineup. The position eligibility thing needs to be ironed out. I'll work with Mik on that.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7688
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Aug 26, 2017 2:04 pm

bills09 wrote:Incorrect salary for Cammalerri and Hunwick


Hunwick's contract is correct. He signed a 3 year, $6.75 million deal with Pittsburgh. His cap hit and AAV is supposed to be $2,250,000.

Cammalleri hadn't been updated...still had his old contract before the buyout. I hadn't reviewed the Kings players yet.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7688
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Sat Aug 26, 2017 2:11 pm

Chuck Norris wrote:Matt Iacopelli is missing all the biographical details.



Yeah, some of my sheets have him as Matt and some are Matheson so some of his info wasn't pairing up.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7688
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby bills09 » Sat Aug 26, 2017 4:44 pm

Shoalzie wrote:
bills09 wrote:Incorrect salary for Cammalerri and Hunwick


Hunwick's contract is correct. He signed a 3 year, $6.75 million deal with Pittsburgh. His cap hit and AAV is supposed to be $2,250,000.

Cammalleri hadn't been updated...still had his old contract before the buyout. I hadn't reviewed the Kings players yet.



Thank you Scott for the update for some reason I thought Hunwick was closer to 3M but you are correct.
Image
bills09
 
Posts: 8549
Joined: Mon May 03, 2010 5:10 pm
Location: Pickering, Ontario

Re: 2017-18 BBKL Google Sheets

Postby Loki » Sat Aug 26, 2017 6:45 pm

Shoalzie wrote:
Loki wrote:It seems the forwards on my preseason sheet have gotten broken somehow too, they aren't coming up correctly to be assigned positions :(
Was working perfectly when I last checked it a few weeks back



If you have more than 5 centers assigned as active, you'll get an error in your lineup. The position eligibility thing needs to be ironed out. I'll work with Mik on that.


Ohh I see what the issue is, I've suddenly have 4 guys become centers :/ With the exception of maybe Bjugstad I think the other 3 should be wings
User avatar
Loki
 
Posts: 807
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Wed Aug 30, 2017 5:57 am

We're wrapping up August and there's quite a few of you who have not started using your sheets. I'd at least like some confirmation that you've received your invite to use your sheet. I used everyone's e-mail from last season so please let me know if you're using a different e-mail so I can share your sheet with the proper account.

Just as a refresher...fill out your "Roster" sheet first. All your weekly sheets will reference this sheet. You can't enter a name on your weekly sheet if they aren't on your "Roster" sheet. All you have to do is enter the player's name in column A. All the information (if applicable) will fill-in.

All players eligible to slide their contract, it will say "Eligible" in column M on the "Roster" sheet. If you choose to slide a contract, post that player's name in this thread:

viewtopic.php?f=8&t=14451

When I add that designation to that player in my database, you'll see "Slide" in column N and on the weekly sheet, you'll see a blue arrow in column H and your list of players will appear in cells S20:S29. Those players are exempt from your 50 contracts but still count towards your limit of 90 players.

A green arrow in column F of your weekly sheet means your player is waiver exempt. Any player that isn't exempt that you assign as "Minors" under role...they will appear in cells R20:R29. Those are players that must clear waivers.

All players that have an NHL contract should have their information in the database so you'll know right now who is waiver exempt and who you can slide.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7688
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby CAM » Wed Aug 30, 2017 7:48 am

I have mine up to date and am good to go. Thanks Scott
User avatar
CAM
 
Posts: 3497
Joined: Fri May 24, 2013 5:42 pm

Re: 2017-18 BBKL Google Sheets

Postby Arian The Insider » Wed Aug 30, 2017 8:22 am

Marner and Eberle are set as C's despite being W's

Spacek is set as a W despite being a C.

Otherwise, everything looks good. Thanks Scott.
Click Oilers image below for full team roster
Image
User avatar
Arian The Insider
 
Posts: 5877
Joined: Mon May 03, 2010 7:05 pm
Location: Somalia

Re: 2017-18 BBKL Google Sheets

Postby foofnik » Wed Aug 30, 2017 9:22 am

SJ:
Martel should be $800,000
Sissons should be $693,333
Nicolas Roy should be $815,000
Merkley should be $1,075,833
Hinostroza should be $925,000
Stallard missing team - WPG
Cooper missing team - ANA
Leschyshyn missing team - VGK

In LTIR columns Petry's contract not showing up
User avatar
foofnik
 
Posts: 862
Joined: Sun May 31, 2015 2:58 pm
Location: Long Island, New York

Re: 2017-18 BBKL Google Sheets

Postby Shoalzie » Wed Sep 13, 2017 10:35 am

I know I've got some work still to do with the database...salary, position, team, etc. Players on their ELC will probably have some slight tweeks. I know that CapGeek and CapFriendly's AAV and cap hit numbers are different for some players. Any inaccurate info is probably still leftover from when I entered the CapGeek info last year.

Anyone that hasn't started using their sheet...you probably should look into it soon. Waiver draft starts Monday (will I post the selection thread later today). We'll have roster submission before too long. Everyone needs to get their ducks in a row in regards to Fantrax and their sheet. Please let me know if you have any questions.

Also, for those who primarily use their phones to conduct their league business...I may look into a more mobile-friendly version of the sheet that I can make available to you. I'm working with Kyle (NYR) on helping him out. I'm not opposed to entering your roster on your sheet if that would help out the process. The mobile-friendly version of the sheet will be a more simplified version of the sheet.

It will probably come next year but I will probably have it where all your rosters are automated...no more data entry. All the work will be done on my end. I wanted to look into that for this year but I was more concerned with re-organizing my database.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7688
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2017-18 BBKL Google Sheets

Postby bills09 » Wed Sep 13, 2017 10:43 am

The real MVP
Image
bills09
 
Posts: 8549
Joined: Mon May 03, 2010 5:10 pm
Location: Pickering, Ontario

PreviousNext

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 3 guests