2020-21 Google Sheets

Anything goes here OT stuff is OK too!
User avatar
Shep
PostsCOLON 13901
JoinedCOLON Tue May 04, 2010 2:04 pm

Re: 2020-21 Google Sheets

Post by Shep »

When do we update fantrax salaries?
Inaugural GM
[STL] 2009 - 2016
[PHI] 2019 -
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2020-21 Google Sheets

Post by Shoalzie »

Paul helped with that during last season but I can do a mass update with the info from Google.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Shep
PostsCOLON 13901
JoinedCOLON Tue May 04, 2010 2:04 pm

Re: 2020-21 Google Sheets

Post by Shep »

I think you can just refresh AAV. We don't have anything crazy do we?
Inaugural GM
[STL] 2009 - 2016
[PHI] 2019 -
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2020-21 Google Sheets

Post by Shoalzie »

I think I did it right...I see the salaries on my team are updated. Give it a look. If I screwed up, I saved a backup of the database.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Loki
PostsCOLON 1938
JoinedCOLON Mon Sep 26, 2016 4:38 pm
LocationCOLON Melbourne, AUS

Re: 2020-21 Google Sheets

Post by Loki »

Hey Scott, Robert Thomas appears to be not selectable on my sheet today, not sure what's happened. He shows up in waivers but I can't click anything to pop him into the sheet. I think he might have lost his team association as he has no logo. Could you please have a look?
User avatar
KapG
PostsCOLON 11908
JoinedCOLON Tue May 04, 2010 5:46 pm
LocationCOLON Toronto (beach area)

Re: 2020-21 Google Sheets

Post by KapG »

When I load up my google sheet I constantly have to fix my lineup. Like...I’ll have random prospects sitting in my lineup thet I clearly never put there. Not sure what’s going on

Also have donato showing up as a centre. He should be a wing iirc
User avatar
Matthew
PostsCOLON 13682
JoinedCOLON Wed Oct 08, 2014 3:29 pm

Re: 2020-21 Google Sheets

Post by Matthew »

KapG wroteCOLONWhen I load up my google sheet I constantly have to fix my lineup. Like...I’ll have random prospects sitting in my lineup thet I clearly never put there. Not sure what’s going on

Also have donato showing up as a centre. He should be a wing iirc
Wait a few minutes for it to re-load up. Mine starts out weird, and then after a few minutes will correct itself.
ANAHEIM DUCKS | FANTRAX |
User avatar
KapG
PostsCOLON 11908
JoinedCOLON Tue May 04, 2010 5:46 pm
LocationCOLON Toronto (beach area)

Re: 2020-21 Google Sheets

Post by KapG »

Matthew wroteCOLON
KapG wroteCOLONWhen I load up my google sheet I constantly have to fix my lineup. Like...I’ll have random prospects sitting in my lineup thet I clearly never put there. Not sure what’s going on

Also have donato showing up as a centre. He should be a wing iirc
Wait a few minutes for it to re-load up. Mine starts out weird, and then after a few minutes will correct itself.
Oh ok! I’ll try that.

Great setup tho still. Really easy to use
User avatar
Loki
PostsCOLON 1938
JoinedCOLON Mon Sep 26, 2016 4:38 pm
LocationCOLON Melbourne, AUS

Re: 2020-21 Google Sheets

Post by Loki »

KapG wroteCOLONWhen I load up my google sheet I constantly have to fix my lineup. Like...I’ll have random prospects sitting in my lineup thet I clearly never put there. Not sure what’s going on

Also have donato showing up as a centre. He should be a wing iirc
Yeah I have that too sometimes, I thought it was contracts being updated and the list shuffling
User avatar
Jordan (VGK)
PostsCOLON 1062
JoinedCOLON Wed Sep 27, 2017 1:29 pm
LocationCOLON Ottawa, ON

Re: 2020-21 Google Sheets

Post by Jordan (VGK) »

Something weird going on right now with Komarov & Z. Smith not having a position so I can't slot them into my lineup.
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2020-21 Google Sheets

Post by Shoalzie »

I'll take a look. I've got other teams asking questions about players' positions. I wanted to get this all squared away this weekend ahead of roster submission.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Jordan (VGK)
PostsCOLON 1062
JoinedCOLON Wed Sep 27, 2017 1:29 pm
LocationCOLON Ottawa, ON

Re: 2020-21 Google Sheets

Post by Jordan (VGK) »

Shoalzie wroteCOLONI'll take a look. I've got other teams asking questions about players' positions. I wanted to get this all squared away this weekend ahead of roster submission.
Looks like it's fixed now. Merci if you did something
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2020-21 Google Sheets

Post by Shoalzie »

The data is there but it takes time for it to update depending on what sheet it's referencing. I've got too much information that I keep track of and reference so I break it up over multiple sheets and then it all gets linked to one sheet that I use as the database for this league.

You guys won't see the latest information until you view your sheets each time...it'll take a few moments for everything to update when you first open the sheets.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
kyuss
PostsCOLON 14876
JoinedCOLON Thu May 06, 2010 12:54 pm

Re: 2020-21 Google Sheets

Post by kyuss »

Hey Scott, I need Mittelstadt's position fixed when you create Round 1 google sheet, thx
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: 2020-21 Google Sheets

Post by Shoalzie »

I must've missed him while I ran through your list. Saw your note about Zegras in the thread.

I have a "Rd 1" sheet visible for the top 20 teams in the standings. I didn't have time to sort through the standings of who actually made the playoffs.
DETROIT RED WINGS | ROSTER | FANTRAX
BUTTON_POST_REPLY

Return to