2019-20 Google Sheets

Anything goes here OT stuff is OK too!

Re: 2019-20 Google Sheets

Postby Shoalzie » Sat May 18, 2019 11:04 am

This weekend, I'm going to start sending out the links to you guys so you can begin using your sheets. I'll also get the draft thread posted.

CapFriendly is now recognizing next year in regards to contracts. I'm going by their estimated cap and floor numbers. All the math on your sheets references variables that I can change once we get the official salary cap numbers. Currently, $83 million is the cap and $61.3 million is the floor.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 9141
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2019-20 Google Sheets

Postby Loki » Sun May 19, 2019 12:20 am

Shoalzie wrote:This weekend, I'm going to start sending out the links to you guys so you can begin using your sheets. I'll also get the draft thread posted.

CapFriendly is now recognizing next year in regards to contracts. I'm going by their estimated cap and floor numbers. All the math on your sheets references variables that I can change once we get the official salary cap numbers. Currently, $83 million is the cap and $61.3 million is the floor.


Thanks Scott, got it and it seems to be working great. Awesome work!
User avatar
Loki
 
Posts: 1447
Joined: Mon Sep 26, 2016 4:38 pm
Location: Melbourne, AUS

Re: 2019-20 Google Sheets

Postby kyuss » Sun May 19, 2019 2:05 am

thx Scott!

A note:
OEL and Da Costa currently show up under UFA rather than signed and unaffiliated
User avatar
kyuss
 
Posts: 12710
Joined: Thu May 06, 2010 12:54 pm

Re: 2019-20 Google Sheets

Postby Shoalzie » Sun May 19, 2019 5:47 am

Now that everyone has a link to their sheet, I'll address the major players who don't have their new contracts entered. Ekman-Larsson falls under that category. I think guys like Seguin and Matthews are among that same group as well. I'll try to knock some of those out today and post the draft selection thread this evening.

My big thing yesterday was when I went through each team's sheet before I shared them with you, I wanted to make sure all your names were appearing. My next task is getting them under the correct category. A lot of that has to do with contract information.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 9141
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2019-20 Google Sheets

Postby Matthew » Sun May 19, 2019 12:38 pm

Nylander has a cap hit of 10 when his cap for next season is ~ 6.9
Image
Matthew
 
Posts: 9456
Joined: Wed Oct 08, 2014 3:29 pm

Re: 2019-20 Google Sheets

Postby Shoalzie » Sun May 19, 2019 2:09 pm

Yup, I saw that too...that will be fixed.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 9141
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2019-20 Google Sheets

Postby cliff11 » Sun May 19, 2019 2:57 pm

nice work on these sheet man they are beautiful
User avatar
cliff11
 
Posts: 2631
Joined: Sat May 08, 2010 12:39 pm

Re: 2019-20 Google Sheets

Postby Shoalzie » Sun May 19, 2019 5:21 pm

kyuss wrote:thx Scott!

A note:
OEL and Da Costa currently show up under UFA rather than signed and unaffiliated




Just a clarification on a player like Da Costa...any player who had previously signed an NHL contract and appeared in at least one game and doesn't currently have an NHL contract will appear as a "FREE AGENT".

Only exceptions are any players that are currently on an NHL team's reserve list (per CapFriendly). For example, I have Ivan Telegin whose contract expired in 2015 but the Jets still owns his rights.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 9141
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2019-20 Google Sheets

Postby Shoalzie » Fri Jun 21, 2019 6:41 am

A few updates to your sheets last night...

I removed the 2019 Entry Draft picks from your "Picks" sheet. I already had the 2021 draft on the sheet so the next two years of entry and waivers are on your sheet. I'll finalize the order in the waiver draft and I need to add the second round picks for the non-playoff teams. "Draft Results" are updated but the team designations won't be updated until next week following the NHL draft.

I changed the cap number to $82 million (per Cap Friendly) even though the final number isn't official. I just need to update the number in one location and it'll update all of your sheets.

Contract info will be an ongoing process as we get closer to July 1 and I'll work on getting the player data entered for all the draftees. I'll formally add them to your rosters next week. I've been made aware of some players having the wrong position designation...I'll be working on that as well.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 9141
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2019-20 Google Sheets

Postby kimmer » Sat Jun 22, 2019 4:08 pm

Thank you, Scott
2019-2020 Transactions
CAR Google Sheet

- A true liberator of the apprehensive voice -
User avatar
kimmer
 
Posts: 16951
Joined: Thu Sep 02, 2010 2:25 pm
Location: Markham, Ontario

Re: 2019-20 Google Sheets

Postby Matthew » Sun Jun 23, 2019 11:13 am

Hey Scott, thanks for doing all this.

My sheet has boone jenner as a winger (he is a center)
And william nylander and drake batherson as centers (they are wingers)

Thanks!
Image
Matthew
 
Posts: 9456
Joined: Wed Oct 08, 2014 3:29 pm

Re: 2019-20 Google Sheets

Postby Shoalzie » Sun Jun 23, 2019 9:51 pm

Yup, I mentioned positions will be addressed.

Just got back tonight...this week I'll work on getting the new NHL draftees into my database and then I'll add our draftees to your rosters.

I've updated the final salary cap figures.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 9141
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2019-20 Google Sheets

Postby Shoalzie » Tue Jun 25, 2019 9:50 am

All the 2019 NHL draftees and undrafted BBKL prospects have been added to your rosters. Your NHL draftees will appear under "Affiliated Prospects" and the undrafted players go under "Unaffiliated Prospects". I'll work on adding their information in the coming days and weeks. Until these players sign their ELC, they'll remain under the prospect category.

I'll work on updating positions for players and I'll get caught up on the last few days of trades and contracts from CapFriendly.

I also noticed a bug on the "Preseason" sheet where if you have more than 90 players, some of your contracted players can't be added to your lineup. I'll correct that tonight.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 9141
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2019-20 Google Sheets

Postby dave1959 » Tue Jun 25, 2019 1:39 pm

should anyone have more than 90 players??
User avatar
dave1959
 
Posts: 3741
Joined: Wed Oct 02, 2013 8:43 pm
Location: Ontario

Re: 2019-20 Google Sheets

Postby Shoalzie » Tue Jun 25, 2019 2:59 pm

You can during our offseason. Roster submission is when you need to be back down to 50 contracts and 90 players.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 9141
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2019-20 Google Sheets

Postby Shoalzie » Tue Jun 25, 2019 6:04 pm

I'm doing a big update to positions on the database...it'll screw up all your sheets until I'm completed. You might want to steer clear of your sheets for tonight. Thanks.
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 9141
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2019-20 Google Sheets

Postby kimmer » Tue Jul 09, 2019 11:38 am

Just wondering approximately when we will expect to see a final working version
I'm only asking (impatiently) because we need to rely on these to calculate our AAV total and see what moves we need to make to clear/add cap in conjunction to the new cap structure.
2019-2020 Transactions
CAR Google Sheet

- A true liberator of the apprehensive voice -
User avatar
kimmer
 
Posts: 16951
Joined: Thu Sep 02, 2010 2:25 pm
Location: Markham, Ontario

Re: 2019-20 Google Sheets

Postby Arian The Insider » Tue Jul 09, 2019 11:43 am

Aren't Asians good at math?
Click Oilers image below for full team roster
Image
User avatar
Arian The Insider
 
Posts: 6633
Joined: Mon May 03, 2010 7:05 pm
Location: Somalia

Re: 2019-20 Google Sheets

Postby Shoalzie » Tue Jul 09, 2019 12:49 pm

kimmer wrote:Just wondering approximately when we will expect to see a final working version
I'm only asking (impatiently) because we need to rely on these to calculate our AAV total and see what moves we need to make to clear/add cap in conjunction to the new cap structure.




Those sheets have been in your possession since before our draft. Did you not receive the share invite to access it?
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 9141
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: 2019-20 Google Sheets

Postby kimmer » Tue Jul 09, 2019 1:01 pm

I have them
I guess part of the problem is real life rather than the sheets
Need real RFAs to sign...
2019-2020 Transactions
CAR Google Sheet

- A true liberator of the apprehensive voice -
User avatar
kimmer
 
Posts: 16951
Joined: Thu Sep 02, 2010 2:25 pm
Location: Markham, Ontario

PreviousNext

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 5 guests

cron