2020-21 Google Sheets

[Shoalzie]

Sorry about that, those links for the template sheets should be working again. I moved the files to another folder and the link went back to being restricted.

[Shoalzie]

Anyone interested in the "PC" version, those can be made available to you right away. I have sheets made for Carolina, Columbus, San Jose and myself.

I'll try to finalize the mobile version this week and start distributing those.

[kyuss]

Anyone interested in the "PC" version...

Here!

[tbone]

PC version for me too, thx

[Bruyns]

I'll take PC too, thanks!

[ltcompton]

Yes, PC version for me as well please

[Florida Chris]

PC for me too, thanks

[Tony]

PC for me too, thanks

[kimmer]

the database is still yet to be completed i assume scott?
not all of my players are available on the sheet

[Da_Hawks]

PC for the Hawks as well.

I assume we only get one version? It does not just transfer over from PC to Mobile, correct? (Not sure how techy this all is).

[Shoalzie]

the database is still yet to be completed i assume scott?
not all of my players are available on the sheet

Do you have a player in particular you're looking for or you think is missing?


I don't know if I explained this before to everyone but how I determine whether a player is a free agent or a prospect, it all depends on if the player has ever signed an NHL contract. If player appears as RFA or UFA, it means that player previously had a signed contract.

All prospects are players (regardless of age) who have never signed an NHL contract. "Unaffiliated" are the players whose rights aren't currently owned by an NHL team (appearing a team's reserve list).

[Shoalzie]

PC for the Hawks as well.

I assume we only get one version? It does not just transfer over from PC to Mobile, correct? (Not sure how techy this all is).

I didn't set this up so you could use both. Maybe if there's time this summer, I can rig something up like that.

The two separate designs were made to better suit whether or not you do your league business more on your phone than on a computer. Check boxes were used in place of data entry for the "mobile" version.

Both designs produce the same information and use my player database.

[Shoalzie]

the database is still yet to be completed i assume scott?
not all of my players are available on the sheet

Just did a quick look and saw all 79 players that I have accounted for you appear on your sheet.

You'll notice your contract count says 21 but you have 22 signed players. Egor Afanasyev is slide eligible so he's excluded from the count. All slide-eligible players are removed from your contract count until you "activate" them (put them in your active lineup). I'll change their status from "slide-eligible" to "waiver exempt".

[Matthew]

Mobile please.

[Shoalzie]

Sure thing...a few of you have been waiting patiently for that version.

I'm close to done on mobile...found one bug last night and wanted to look it over tonight with fresh eyes. I could send those out as soon as tonight.

[Da_Hawks]

PC for the Hawks as well.

I assume we only get one version? It does not just transfer over from PC to Mobile, correct? (Not sure how techy this all is).

I didn't set this up so you could use both. Maybe if there's time this summer, I can rig something up like that.

The two separate designs were made to better suit whether or not you do your league business more on your phone than on a computer. Check boxes were used in place of data entry for the "mobile" version.

Both designs produce the same information and use my player database.

All good Shoalzie. Thanks! I'll stick with PC.

[Shoalzie]

All requests have been fulfilled...16 teams so far including myself. Long offseason, no rush...for the remaining teams, let me know what you want to use.

[Loki]

Just fired it up and it looks great, thanks Scott. One question, is the preseason tab supposed to be editable yet? I can't seem to set the lineup

[Shoalzie]

I re-did the permissions on the mobile sheet and I'll resend those to you. I over-complicated it...you guys should be good.

[Loki]

I re-did the permissions on the mobile sheet and I'll resend those to you. I over-complicated it...you guys should be good.

Working now, thanks again!