Page 4 of 5

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 6:41 am
by Shoalzie
KapG wroteCOLONPretty sure Lias andersson is suppose to be a winger but is still showing up as being in an illegal position on my google docs. Tyler Johnson I’m pretty sure is suppose to Be a centre but is showing up as being in an illegal position on my google docs as well. This is what the little red mark is saying that’s in the corner of the drop down menu beside the players name right?

Outside of that I’m pretty sure my lineup is done….

Tyler Johnson is in your lineup twice so that needs to be corrected. He is a winger according to our qualification...he finished last 0.41 FOR with threshold being 0.45. I have the correct in the database. Fantrax is not right.

When you see that little triangle in the corner of the player's cell, that means that player you added to that position...their position has changed so that don't qualify for that spot anymore. Lias Andersson is a winger in database so he can be moved away from center.

Sam Gagner is also now a winger.

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 8:38 am
by KapG
Shoalzie wroteCOLON
KapG wroteCOLONPretty sure Lias andersson is suppose to be a winger but is still showing up as being in an illegal position on my google docs. Tyler Johnson I’m pretty sure is suppose to Be a centre but is showing up as being in an illegal position on my google docs as well. This is what the little red mark is saying that’s in the corner of the drop down menu beside the players name right?

Outside of that I’m pretty sure my lineup is done….

Tyler Johnson is in your lineup twice so that needs to be corrected. He is a winger according to our qualification...he finished last 0.41 FOR with threshold being 0.45. I have the correct in the database. Fantrax is not right.

When you see that little triangle in the corner of the player's cell, that means that player you added to that position...their position has changed so that don't qualify for that spot anymore. Lias Andersson is a winger in database so he can be moved away from center.

Sam Gagner is also now a winger.
Got the docs all sorted. If TJ is a winger he needs to be switched in fantrax but he can only be listed as C

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 8:47 am
by Shoalzie
Yup, Fantrax positions will hopefully get resolved before opening night.

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 8:55 am
by KapG
Ok cool. Just didn’t wanna get in trouble for not having a matching lineup ;)

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 9:08 am
by Shoalzie
Actually, I don't use the Fantrax positions when I collect that report. I just need the player name, team designation and lineup status.

If Fantrax has a player listed as a center but you have them on the wing in Google...as long as they're "Active", you're good.

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 10:01 am
by Da_Hawks
Not sure what happened, but the Hawks Google Sheet is not populating anything.

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 10:07 am
by Shoalzie
I've noticed that if you stay on the sheet for a while, the data might fault out on you. Just close the sheet and re-open. It comes back after the first or second attempt.

Don't ask me why it does that...just a bug a suppose.

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 12:52 pm
by KapG
My documents are sound at this point. Just need to have Matt duchene added and Daniel Sprong removed.

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 12:53 pm
by Shoalzie
KapG wroteCOLONMy documents are sound at this point. Just need to have Matt duchene added and Daniel Sprong removed.

I think I did that already...check your sheet.

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 1:02 pm
by KapG
Shoalzie wroteCOLON
KapG wroteCOLONMy documents are sound at this point. Just need to have Matt duchene added and Daniel Sprong removed.

I think I did that already...check your sheet.
You’re right! I just had to reset the app. All set

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 4:22 pm
by Chuck Norris
Hey Josh you said you dropped contracts to get compliant. I thought you could only drop contracts freely before the waiver draft and after the draft you couldnt just drop a contract anymore?

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 4:24 pm
by Shoalzie
You can before roster submission. We changed that recently.

Re: Google Sheets (2021 Release)

PostedCOLON Sun Oct 10, 2021 5:40 pm
by Chuck Norris
Wish i had realized that fuck lol

Re: Google Sheets (2021 Release)

PostedCOLON Mon Oct 11, 2021 5:25 am
by KapG
I’m not sure if it’s going to matter or not, but my roster submission would be under week 1 and not preseason. I don’t think I filled out the preseason one.

Re: Google Sheets (2021 Release)

PostedCOLON Mon Oct 11, 2021 5:38 am
by Shoalzie
The preseason sheet is meant for the offseason and eventually for roster submission. You can fill out the lineup in Fantrax to match your roster submission but it doesn't have to be official for Week 1 until Tuesday night.

Now we start focusing on Week 1. I just ran an update of Fantrax this morning. If you want to use the current lineup as is, use the checkbox. However, if you filled in the lineups manually, the Fantrax lineup won't populate your sheet but that information is there to compare to the lineup you entered.

Re: Google Sheets (2021 Release)

PostedCOLON Mon Oct 11, 2021 6:22 am
by Shoalzie
Kyle, I did you a solid and filled your preseason sheet out to match Week 1...I just wanted something official.

Re: Google Sheets (2021 Release)

PostedCOLON Mon Oct 11, 2021 6:41 am
by KapG
Sorry about that! Appreciate you fixing it up for me Scott.

Re: Google Sheets (2021 Release)

PostedCOLON Mon Oct 11, 2021 10:44 am
by Shoalzie
If you haven't submitted your initial roster and properly filled out your Preseason sheet, your players will miss this first round of waivers start at noon.

The current waiver list has been posted. Claims can begin at the top of the hour.

Re: Google Sheets (2021 Release)

PostedCOLON Tue Oct 12, 2021 11:44 am
by Shoalzie
The mass update on Fantrax with positions hasn't occurred yet. If you have a player you can't put in your Fantrax lineup because of their position assignment, let me know and I'll override the position so you can play them.

Re: Google Sheets (2021 Release)

PostedCOLON Tue Oct 12, 2021 2:05 pm
by Shoalzie
If you're waiting on contracts, CapFriendly finally posted Boyle, Gustafsson and Chiasson's deals. I'll get to those tonight.

Make sure your Fantrax page has the player in your lineup if that's your plan.