Google Sheets

Google Sheets

Postby Shoalzie » Tue May 09, 2017 1:04 pm

I will not post the link to Tim's sheet so he can work on the draft privately but this is a similar sheet that he is working with. You can view it so you can do your own mock draft if you'd like or you can see who everyone is exposing. Not everyone has posted their protected list on Google yet and you still have until Monday, May 15.

https://docs.google.com/spreadsheets/d/ ... sp=sharing
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7710
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: Google Sheets

Postby CAM » Tue May 09, 2017 1:07 pm

Is this live scott? Like if i make a change on my own google doc before submission it automatically updates?
User avatar
CAM
 
Posts: 3497
Joined: Fri May 24, 2013 5:42 pm

Re: Google Sheets

Postby CAM » Tue May 09, 2017 1:08 pm

Also, what order does the draft use? Alphabetical i would assume not...
User avatar
CAM
 
Posts: 3497
Joined: Fri May 24, 2013 5:42 pm

Re: Google Sheets

Postby kimmer » Tue May 09, 2017 1:13 pm

Can we put a timer on tims draft and we can watch him select his guys LIVE on a publically accessible spreadsheet we can all view but CANT edit except for u and tim? Since we have roster freeze why not

And 5 days of no roster trading may make some of us go insane
Last edited by kimmer on Tue May 09, 2017 1:14 pm, edited 1 time in total.
2017-2018 Transactions
CAR Google Sheet

- A true liberator of the apprehensive voice -
User avatar
kimmer
 
Posts: 15642
Joined: Thu Sep 02, 2010 2:25 pm
Location: Markham, Ontario

Re: Google Sheets

Postby Shoalzie » Tue May 09, 2017 1:13 pm

As a review, everyone has a sheet within their team sheets called "Expansion". Do not change the name of that sheet because that sheet as constructed is being referenced by Tim's draft sheet.

Your "Roster" sheet must have the correct names of your current roster. In rows 3 through 92 is where you should have your current players. You can put former players in rows 94-143 and those players will not appear on your "Expansion" sheet.

All draft eligible players will appear in columns H, N and T. Type a "P" in the blue box next to the player you'd like to protect.

Down in row 42, you can check to see if your protected list is compliant to the 7 F + 3 D + 1 G or 8 skaters + 1 G options. If you're compliant with either option, the box next to the heading will be blank. If not, it will be red with a "!".

In row 47, the 40/70 rule is being check out there. You must expose a minimum of 2 forwards and 1 defenseman that played in either 40 games in '16-17 or has played at least 70 games in the last two seasons.

Your exposed lists will appear on Tim's sheet for him to choose from.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7710
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: Google Sheets

Postby Shoalzie » Tue May 09, 2017 1:14 pm

CAM wrote:Is this live scott? Like if i make a change on my own google doc before submission it automatically updates?




Yes and yes. This example and Tim's sheet will show your list as it appears on your sheet right now.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7710
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: Google Sheets

Postby Shoalzie » Tue May 09, 2017 1:16 pm

CAM wrote:Also, what order does the draft use? Alphabetical i would assume not...



There's no order...just team-by-team. On Tim's sheet, he would put a "V" next the player he wants and it'll appear on the "Expansion Draft" sheet. That sheet will list all the players he would pick and it keeps count of his players by position.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7710
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: Google Sheets

Postby Shoalzie » Tue May 09, 2017 1:17 pm

kimmer wrote:Can we put a timer on tims draft and we can watch him select his guys LIVE on a publically accessible spreadsheet we can all view but CANT edit except for u and tim? Since we have roster freeze why not

And 5 days of no roster trading may make some of us go insane




Tim posts his picks on the 22nd. I'll leave his sheet private unless he wants to make it public.

And yes, we will have a trade freeze during the draft but you can certainly negotiate deals. Just can't be official until after the draft.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7710
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: Google Sheets

Postby Matthew » Tue May 09, 2017 1:27 pm

On the 22nd we should have a slow reveal. Would be fun. One player every 10 minutes or something.
Matthew
 
Posts: 7030
Joined: Wed Oct 08, 2014 3:29 pm

Re: Google Sheets

Postby timwebb1212 » Tue May 09, 2017 1:28 pm

Matthew wrote:On the 22nd we should have a slow reveal. Would be fun. One player every 10 minutes or something.

I'd be game for that. Maybe go by position rather than team also so there's suspense seeing what position you lost
User avatar
timwebb1212
 
Posts: 720
Joined: Wed Aug 10, 2016 9:40 pm

Re: Google Sheets

Postby kimmer » Tue May 09, 2017 1:30 pm

gonna be a donk show
2017-2018 Transactions
CAR Google Sheet

- A true liberator of the apprehensive voice -
User avatar
kimmer
 
Posts: 15642
Joined: Thu Sep 02, 2010 2:25 pm
Location: Markham, Ontario

Re: Google Sheets

Postby dave1959 » Tue May 09, 2017 1:31 pm

CAM wrote:Is this live scott? Like if i make a change on my own google doc before submission it automatically updates?


yes, it is. (just checked)

nice work Scott!
User avatar
dave1959
 
Posts: 2772
Joined: Wed Oct 02, 2013 8:43 pm
Location: Ontario

Re: Google Sheets

Postby Bruyns » Tue May 09, 2017 1:32 pm

Reminder to update your sheets too, I still have Hunt on mine who I traded to Cam months ago and Vlasic who I just recently traded.
User avatar
Bruyns
 
Posts: 4741
Joined: Wed Apr 10, 2013 10:18 am

Re: Google Sheets

Postby dave1959 » Tue May 09, 2017 1:32 pm

Matthew wrote:On the 22nd we should have a slow reveal. Would be fun. One player every 10 minutes or something.


great idea!
User avatar
dave1959
 
Posts: 2772
Joined: Wed Oct 02, 2013 8:43 pm
Location: Ontario

Re: Google Sheets

Postby Shoalzie » Tue May 09, 2017 2:14 pm

Bruyns wrote:Reminder to update your sheets too, I still have Hunt on mine who I traded to Cam months ago and Vlasic who I just recently traded.




Yup, I noticed you had Vlasic. Everyone please keep your rosters up-to-date. All you need is the player's name on "Roster"...the rest of the data is automated.

This will be the last time you guys have to do anything with these roster sheets. I'm hoping to get you guys set up with new team sheets around when free agency starts. You guys can keep using these sheets for now. I'm going to re-organize my database and finish the prototype for the new sheets. I'm hoping to make these even easier to use and faster to load and update.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7710
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: Google Sheets

Postby Shoalzie » Tue May 09, 2017 2:25 pm

timwebb1212 wrote:
Matthew wrote:On the 22nd we should have a slow reveal. Would be fun. One player every 10 minutes or something.

I'd be game for that. Maybe go by position rather than team also so there's suspense seeing what position you lost



Sure be creative and have fun with it...just start a new thread in this forum and post your picks however you want.
Image
DETROIT RED WINGS | ROSTER | FANTRAX | DRAFT PICKS
User avatar
Shoalzie
 
Posts: 7710
Joined: Mon May 03, 2010 7:28 pm
Location: Portland, MI

Re: Google Sheets

Postby Tony » Tue May 09, 2017 2:31 pm

Thanks Scott. You seriously spoil us...
Image
Click banner to view current roster and picks
User avatar
Tony
 
Posts: 10104
Joined: Mon May 03, 2010 10:29 pm
Location: Nevada

Re: Google Sheets

Postby Arian The Insider » Tue May 09, 2017 3:00 pm

Tony wrote:Thanks Scott. You seriously spoil us...
Click Oilers image below for full team roster
Image
User avatar
Arian The Insider
 
Posts: 5887
Joined: Mon May 03, 2010 7:05 pm
Location: Somalia

Re: Google Sheets

Postby Lee » Tue May 09, 2017 3:51 pm

Tony wrote:Thanks Scott. You seriously spoil us...
User avatar
Lee
 
Posts: 15687
Joined: Tue Jun 15, 2010 12:29 pm
Location: Calgary, AB

Re: Google Sheets

Postby kimmer » Tue May 09, 2017 3:53 pm

I wanna call Justin Trudeau and request to give Scott honourary canadian citizenship
2017-2018 Transactions
CAR Google Sheet

- A true liberator of the apprehensive voice -
User avatar
kimmer
 
Posts: 15642
Joined: Thu Sep 02, 2010 2:25 pm
Location: Markham, Ontario

Next

Return to Expansion Draft

Who is online

Users browsing this forum: No registered users and 1 guest