Google Sheets (2021 Release)

[Shoalzie]

Pretty 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.

[KapG]

Pretty 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

[Shoalzie]

Yup, Fantrax positions will hopefully get resolved before opening night.

[KapG]

Ok cool. Just didn’t wanna get in trouble for not having a matching lineup

[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.

[Da_Hawks]

Not sure what happened, but the Hawks Google Sheet is not populating anything.

[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.

[KapG]

My documents are sound at this point. Just need to have Matt duchene added and Daniel Sprong removed.

[Shoalzie]

My 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.

[KapG]

My 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

[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?

[Shoalzie]

You can before roster submission. We changed that recently.

[Chuck Norris]

Wish i had realized that fuck lol

[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.

[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.

[Shoalzie]

Kyle, I did you a solid and filled your preseason sheet out to match Week 1...I just wanted something official.

[KapG]

Sorry about that! Appreciate you fixing it up for me Scott.

[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.

[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.

[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.