Page 2 of 5
Re: 2020-21 Google Sheets
PostedCOLON Mon Aug 24, 2020 5:13 am
by 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.
Re: 2020-21 Google Sheets
PostedCOLON Mon Aug 24, 2020 10:30 am
by 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.
Re: 2020-21 Google Sheets
PostedCOLON Mon Aug 24, 2020 11:51 am
by kyuss
Shoalzie wroteCOLONAnyone interested in the "PC" version...
Here!
Re: 2020-21 Google Sheets
PostedCOLON Mon Aug 24, 2020 1:23 pm
by tbone
PC version for me too, thx
Re: 2020-21 Google Sheets
PostedCOLON Mon Aug 24, 2020 7:55 pm
by Bruyns
I'll take PC too, thanks!
Re: 2020-21 Google Sheets
PostedCOLON Mon Aug 24, 2020 11:30 pm
by ltcompton
Yes, PC version for me as well please
Re: 2020-21 Google Sheets
PostedCOLON Tue Aug 25, 2020 5:48 am
by Florida Chris
PC for me too, thanks
Re: 2020-21 Google Sheets
PostedCOLON Tue Aug 25, 2020 1:19 pm
by Tony
Florida Chris wroteCOLONPC for me too, thanks
Re: 2020-21 Google Sheets
PostedCOLON Thu Aug 27, 2020 9:30 am
by kimmer
the database is still yet to be completed i assume scott?
not all of my players are available on the sheet
Re: 2020-21 Google Sheets
PostedCOLON Thu Aug 27, 2020 9:42 am
by 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).
Re: 2020-21 Google Sheets
PostedCOLON Thu Aug 27, 2020 10:04 am
by Shoalzie
kimmer wroteCOLONthe 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).
Re: 2020-21 Google Sheets
PostedCOLON Thu Aug 27, 2020 10:10 am
by Shoalzie
Da_Hawks wroteCOLONPC 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.
Re: 2020-21 Google Sheets
PostedCOLON Thu Aug 27, 2020 10:18 am
by Shoalzie
kimmer wroteCOLONthe 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".
Re: 2020-21 Google Sheets
PostedCOLON Thu Aug 27, 2020 10:20 am
by Matthew
Mobile please.
Re: 2020-21 Google Sheets
PostedCOLON Thu Aug 27, 2020 10:44 am
by 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.
Re: 2020-21 Google Sheets
PostedCOLON Fri Aug 28, 2020 10:05 am
by Da_Hawks
Shoalzie wroteCOLONDa_Hawks wroteCOLONPC 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.
Re: 2020-21 Google Sheets
PostedCOLON Fri Aug 28, 2020 12:10 pm
by 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.
Re: 2020-21 Google Sheets
PostedCOLON Fri Aug 28, 2020 5:18 pm
by 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
Re: 2020-21 Google Sheets
PostedCOLON Sat Aug 29, 2020 3:54 am
by 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.
Re: 2020-21 Google Sheets
PostedCOLON Sat Aug 29, 2020 4:22 pm
by Loki
Shoalzie wroteCOLONI 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!
