They said i had to protect him ... you're still in the BOG, correct? Now i'm really confused.

Toit Nups! If you have an automated sheet that just requires GMs to submit an accurately spelled roster every increment, then it seems like the BOEG needs to a.) see if GMs approve my suggested changes to the already-signed off-on model (replaced hits and individual penalty differential with xSV% and GSAA - 10% total of suggested changes) and b.) see if GMs are willing to submit an accurately spelled roster every increment. Oh, and determine the increment. I don't have any complaints if we can have the machine do the math for us!

RAIF has a point here. Just two days ago he was told by one BOG member that:



And now 48 hours later



Has the BOG had a group discussion about this? If so, I’m not sure why everyone’s thoughts aren’t synchronized yet.

My info came from an outside source that listed out the rules of the 2017 Vegas expansion draft, which will be the same rules for the upcoming one in game.
If I'm wrong, I'm wrong. Wouldn't be the first time. But the rules only make mention of NMC and my recall from last time was if a player had a NTC, he had to waive it in order to be left exposed, which means if they don't waive it they must be protected.

1. Import and parse csv.
2. Maintain one sorting sheet, updated accordingly as transactions occur, have 1 solo sheet set up for each team.
3. Team sheets update automatically from the sorting sheet, no work required by GMs other than reporting errors.

Sorting sheet would propogate team sheets by checking the team column, so the only thing that would need manual adjustment, is the team field for each player.

Yep, actually I'm doing it all on one sheet. I can take the CSV download into Excel and tweak the date ranges (Corsica is all messed up there), drop the raw data into a monster data tab and automate the team tabs to grab from there (using Index/Match functions). All we will need is the monthly roster updates from each GM.

You can remove the spelling requirement and such by being the only one in control of the import sheet.
The sorting sheet would be in BOE hands to process trades, and they would only be able to change the teams of players.
The GM sheets would be in their hands, but they wouldn't have any control over them at all. Display purposes only, and everyone would be able to see them.

Segregating them is easier than putting them all in one sheet and adjusting permissions for cells. It will also help with loading times and such.

I see what you're saying, and yeah that's a good strategy

In the scenario of a trade, does the sheetholder (in this case, I think it's @A_K), need to make sure that the dates are cutoff? In other words, if I trade 'Player X' in the middle of the scoring month, will I get his stats up until I trade him or will the team I traded him to get the full share of his stats?

I'm just as confused as RAIF now. Unless I'm reading your message wrong, you're saying players with NTCs must be protected unless they allow the NTC to be waived. If so, I'm positively sure that is not the case. Ex, Matt Beleskey had a NTC yet was left exposed in the expansion draft; the Bruins did not have to ask him to waive anything.

I think Icegirl is correct in her example of Antoine Vermette. The player had a NMC that ended upon the end of the 2016-17 season, which converted to a NTC for the following season; as a result he did not have to be protected. Exact same scenario with Boychuk, his NMC is turning into a NTC and as a result, he does not need to be protected in the expansion draft.

Beleskey who played in the AHL had already waived his NMC, prior to the expansion draft.

Dammit Michael, just let me sound as if I know what I'm talking about

Boychuck must be protected via expansion draft, only way around it is if he gets waived and sent to the minors.

Then why was Vermette not protected in the Vegas expansion draft?

I could be wrong, but I believe he was signed to a NTC, but was then boughtout.
I think Anahiem used a loophole in that sense.

Everything would be tallied off the original csv import from corsica. While the first sheet is in the process of being updated, trades would not be processed on the second sheet, until the third (team sheets) are tallied.

If it takes 72 hours to collect and analyze the data, movements made during those 72 hours would not be processed on the sheets until the rankings are organized.
So if the cutoff is the 30th of the month, there would be no changes to the sheets until the 2nd of the following month. Business as usual for GMs, 3 days of not updating the sheet for the BOE, and maybe 30 mins of work for the person in charge of the first sheet (once everything is set up).

for those still up...
Vermette #Ducks
NMC: now - Jun 16, 2017
NTC: Jun 17, 2017 - Jun 30, 2017
M-NTC: Jul 1, 2017 - end
(8 team trade list)

— CapFriendly (@CapFriendly) August 17, 2016

Wouldn't i still have to protect him even if he is in the minors? That is, if i do have to protect him otherwise.

If he has a NMC, I don’t believe you can put him in the minors. BOG is going to discuss this shortly. A lot of things on our plate right now. Try to remind us every two weeks or so about it and we’ll try to hammer out a decision for ya

Maybe I'm wrong but I'm about 99% sure that ANA protected Vermette in the expansion.

EDIT: they protected the following -
Andrew Cogliano (F)
Ryan Getzlaf (F)
Ryan Kesler (F)
Corey Perry (F)
Rickard Rakell (F)
Jakob Silfverberg (F)
Antoine Vermette (F)
Kevin Bieksa (D)
Cam Fowler (D)
Hampus Lindholm (D)
John Gibson (G)

.. they traded Theodore/Stoner to Vegas for them to not select Vatanen or Manson since they didnt want to ask Bieksa to waive.

That is correct. Vermette was protected. Boychuk needs to be protected in our upcoming expansion draft.

@rangersandislesfan

Also, I'll add since I do remember it being a big deal around here, but I think Vermette waived his NMC still even though he was protected. He had an NMC and a Modified NTC at the same time. The NTC was unique in that he couldn't be traded from the end of the league year until after FA started. So he waived the NMC to give the Ducks more flexibility in the expansion but still had his Modified NTC in effect that prevented the Ducks from trading him during the expansion draft, rookie draft, or prior to the FA period beginning. Believe the dates were something like June 10th until July 10th he couldn't be traded.

Is this the final answer? The real one?

Yes, Boychuk has to be protected as his NMC does not expire until July 1, 2019.