2019-20 Google Sheets

Anything goes here OT stuff is OK too!
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2019-20 Google Sheets

Post by Shoalzie »

I'm trying to wrap up the first big wave of FA signings from July 1 and pick off the new ones that happen each day.

I will point out that any signing CapFriendly announces with unconfirmed terms, I'll initially get the player entered as if they signed but leave the salary blank.

I obviously can't control when these guys sign...I'm waiting on some players on my team to sign just like many of you.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
kimmer
PostsCOLON 18090
JoinedCOLON Thu Sep 02, 2010 2:25 pm
LocationCOLON Ontario, Canada

Re: 2019-20 Google Sheets

Post by kimmer »

Teddy Blueger - $750,000 x 2 yrs
Dominic Toninato - $775,000 x 1 yr
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2019-20 Google Sheets

Post by Shoalzie »

Yup, new contracts...I'll be getting to those fairly soon.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Loki
PostsCOLON 1938
JoinedCOLON Mon Sep 26, 2016 4:38 pm
LocationCOLON Melbourne, AUS

Re: 2019-20 Google Sheets

Post by Loki »

Loving the new sheets, but when you get a chance Scott can you please push through the Letang trade so I can set my lineup and see what I'm working with? Thanks :)
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2019-20 Google Sheets

Post by Shoalzie »

Yup, I see that was the last trade I hadn't gotten to. You guys are all set.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Loki
PostsCOLON 1938
JoinedCOLON Mon Sep 26, 2016 4:38 pm
LocationCOLON Melbourne, AUS

Re: 2019-20 Google Sheets

Post by Loki »

Shoalzie wroteCOLONYup, I see that was the last trade I hadn't gotten to. You guys are all set.
Awesome, thanks heaps :)
User avatar
kyuss
PostsCOLON 14876
JoinedCOLON Thu May 06, 2010 12:54 pm

Re: 2019-20 Google Sheets

Post by kyuss »

where is the link to the 2019-2020 sheets?
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2019-20 Google Sheets

Post by Shoalzie »

kyuss wroteCOLONwhere is the link to the 2019-2020 sheets?


All the sheets are in this folder:

https://drive.google.com/drive/folders/ ... YYBUH45l67


I need to update the links on our forum but with Mike unavailable for most of this summer and he's the only other admin...I need him to allow me back in the admin control panel. I'll update that when I can.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
kyuss
PostsCOLON 14876
JoinedCOLON Thu May 06, 2010 12:54 pm

Re: 2019-20 Google Sheets

Post by kyuss »

ok thanks, I added that link to the thread starter
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2019-20 Google Sheets

Post by Shoalzie »

Finally made it through all the July signings. There's a few contracts are still unconfirmed on CapFriendly but those players will still appear as signed but they won't have a cap hit associated with them. I will update that when terms are official.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2019-20 Google Sheets

Post by Shoalzie »

I want to point this out to everyone...on your weekly sheet, the contract count (cell Q7), that's the count minus the players that are currently sliding. If you have any players listed under "SLIDING CONTRACTS", those players are not counted towards your contract count.

Your total contract count is actually the amount in Q7 plus the number of players under "SLIDING CONTRACTS" (starting in cell L44). It can also be found on "Roster" at the top of the page.
DETROIT RED WINGS | ROSTER | FANTRAX
Sensfanjosh
PostsCOLON 4043
JoinedCOLON Sun Nov 06, 2011 5:09 pm

Re: 2019-20 Google Sheets

Post by Sensfanjosh »

Thanks so much for all the work Scott!
Image
User avatar
hong57
PostsCOLON 7106
JoinedCOLON Mon May 03, 2010 7:38 pm

Re: 2019-20 Google Sheets

Post by hong57 »

thanks scott it is amazing
Image
#91 - John Tavares
User avatar
dave1959
PostsCOLON 5138
JoinedCOLON Wed Oct 02, 2013 8:43 pm
LocationCOLON Ontario

Re: 2019-20 Google Sheets

Post by dave1959 »

Any chance we can update the Google docs thread for the new sheets
User avatar
kimmer
PostsCOLON 18090
JoinedCOLON Thu Sep 02, 2010 2:25 pm
LocationCOLON Ontario, Canada

Re: 2019-20 Google Sheets

Post by kimmer »

you lit Scott
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2019-20 Google Sheets

Post by Shoalzie »

dave1959 wroteCOLONAny chance we can update the Google docs thread for the new sheets


I'm temporarily locked out of my admin control panel where I can make those changes to the forums. I assume Mike is the only one who can correct that.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
dave1959
PostsCOLON 5138
JoinedCOLON Wed Oct 02, 2013 8:43 pm
LocationCOLON Ontario

Re: 2019-20 Google Sheets

Post by dave1959 »

damn...sure hope he comes back
User avatar
Matthew
PostsCOLON 13682
JoinedCOLON Wed Oct 08, 2014 3:29 pm

Re: 2019-20 Google Sheets

Post by Matthew »

Can someone unpin 2018-19 Google sheets, and pin the 19-20 Google sheets link to the front page here?
ANAHEIM DUCKS | FANTRAX |
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2019-20 Google Sheets

Post by Shoalzie »

I would've done it a while ago but Mike needs to get me access to my admin control panel so I can make updates to the forum. He's been contacted.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Florida Chris
PostsCOLON 2589
JoinedCOLON Tue May 04, 2010 7:06 am

Re: 2019-20 Google Sheets

Post by Florida Chris »

Shoalzie wroteCOLONI would've done it a while ago but Mike needs to get me access to my admin control panel so I can make updates to the forum.

Whats happening with Mr Mike... Mike if your reading this, how about you give the powers to someone of your choice, and just come back and enjoy just being a Gm....
BUTTON_POST_REPLY

Return to