Eastside's Hockey Elite Collide

CALCULATOR

Pretty simple, guys.

Copy/Paste from your roster page on the website the player you wish to sign to a new deal.

R/C Dustin Jeffrey 636805 1 1988/2/27 CAN 6'3 205 52 50 99 70 52 70 93 70 67 73 70 64 70 76 73 71 71

NEW SALARY IS WHAT YOU ARE LOOKING FOR.

PM me with any questions you might have.

New link to another version of the calculator:

https://docs.google.com/spreadsheets/d/ ... d=63361058

Same instructions as above apply.

I hope the updated version will be unveiled soon. I really need that info.

AP21 (ARZ) wrote:I hope the updated version will be unveiled soon. I really need that info.

We're working on it, Alex. I know it's frustrating moving forward, but we'll get there.

Plus, we won't be getting to free agency any time soon (not like real life), b/c our draft takes way longer than the NHL draft. So don't worry that you're going to wake up one day next week and find half your team has gone UFA b/c you missed a deadline. Not gonna happen.

Player salaries affect most, if not all, of my decisions as a general manager. Ideally, I would have used that information to establish a plan before the start of the offseason or at least before the draft. I understand all the work that is involved, but I'd appreciate it if such changes were confirmed a little more in advance next time.

Yeah, there are some ideas I've put on the backburner because I want to figure out how it'll affect things with the cap first. Would be good to know for the draft since it seems like there's plenty of action to be had with picks this year.

Ok, folks, here is the new salary calculator, courtesy of our very own GM Down Under, Dan. He's going to clean up the formatting a bit to make it look oh-so-pretty, but for now what you need to focus on is the column on the right (column 'AJ'), that has the newly configured salary number.

https://docs.google.com/spreadsheets/d/ ... cslist_api

All pending UFAs should be in the file. If not, you can just add the requisite stats yourself to figure out what you owe.

Ignore salaries for goaltenders; we handle goalie salaries via arbitration, the rules for which can be found in the rulebook. We'll begin arbs for goalies later this summer.

So, feel free to start posting salary extensions on your team's thread in the Extensions forum. Note that we will not be putting salaries through until AFTER the draft is complete. So there is no rush and no need to panic. Yet.

I've cleaned it up now. The NewFormula sheet is what you want. AG2 shows the new formula salary in millions of $. The OldFormula sheet is just for reference and shows what the old formula would give for the same player. Column AH2 in NewFormula references the, uh, old new salary, for lack of a better phrase, so you can compare them side-by-side.

The sheets already have every pending UFA entered so you don't need to copy/paste anything, and they're protected so you can't edit existing players. But if you're curious, you can scroll down to the end and enter new players in rows 451+.

I'm trying to compile some stats in the "Stats" sheet. As you can see, on average the new formula gives slightly lower salaries than the old one, especially for players > 76 OV. I think that's good because some of the new salaries were a bit high.

On the other hand, individual players' salaries might vary by up to $2M. There's nothing I can really do about this - the old formulas were very 'grainy' so if you had a guy right on the edge of a salary bracket, his salary could change by $2-3M just by going up one point in OF/DF. So please don't freak out if your favourite player is due a lot more money than he was under the old system, that was going to be inevitable.

... but I will still say sorry to Hugo for Paul Stastny's new salary, and you're welcome to Martin for Grigorenko, Bern for Jensen and Tommy for Couturier. Still, even though Stastny is the most extreme case, you can see that Ladd and Kesler are getting discounts, so for most teams the changes will average out and league-wide they certainly will.

By the way, the other major difference to the formula is that "specialists" will get more money than before. Case in point is Chris Summers. This is intentional.

Incidentally, I added a page on the site to list all pending free agents: http://www.ehechockey.com/ufa.php?pending=1

2 things:

First, if a player is listed as a RFA in EHM, is he or do we have different criterias?

So, the calculator applies for long term contracts, right? But we could offer only the 1 year Q.O. if we want, right?

Thanks guys!

flyergp21 wrote:2 things:

First, if a player is listed as a RFA in EHM, is he or do we have different criterias?

So, the calculator applies for long term contracts, right? But we could offer only the 1 year Q.O. if we want, right?

Thanks guys!

See Section 13 (page 15) of the rulebook. We go by existing salary and a player's greed rating. (As in, no one with Greed over 100 will accept a qualifying offer.)

This is not a way around offering a guy who calculates to make, say, 5M, an offer of 1.5M instead, just to be cheap. You can qualify him, but he'll become an RFA. If you decide you want to try signing him later, you'll need to use the calculator, per the usual.

Not to be cheap, but a team that's close to the cap could decide to qualify a player instead of signing him long term, and then buy some time to make roster moves.

As for RFAs and UFAs, what I'd like to know is when does a player become unrestricted? Like in real life, so I think after 7 complete seasons, or do we go by age? That's why I asked if we can rely on what is stated in EHM.

Yikes. Mike Richards jumped from a little better than $7.5M to $9.2M with the new calculation. That would've been good information to have a couple days ago. And I guess my group of specialists aren't going to be as cap efficient as I had thought.

Vik (Habs) wrote:Yikes. Mike Richards jumped from a little better than $7.5M to $9.2M with the new calculation. That would've been good information to have a couple days ago. And I guess my group of specialists aren't going to be as cap efficient as I had thought.

Seguin $12.2M and Fowler $12.83, so don't feel to bad. Guess I need to get on a budget.

Thanks so much for getting us this before the draft, Dan. I appreciate the time it must of took.

Tampa Bay GM wrote:

Vik (Habs) wrote:Yikes. Mike Richards jumped from a little better than $7.5M to $9.2M with the new calculation. That would've been good information to have a couple days ago. And I guess my group of specialists aren't going to be as cap efficient as I had thought.

Seguin $12.2M and Fowler $12.83, so don't feel to bad. Guess I need to get on a budget.

Thanks so much for getting us this before the draft, Dan. I appreciate the time it must of took.

That's what they were in the old calculator. They're down a little now (though still steep at 11.1 and 10.95).

And yeah, thanks for getting it done before draft time. Definitely good information to have going into it.

Whoops, ty ty.

The "NEW BASE" are the contracts value, right?

Dallas Stars GM wrote:The "NEW BASE" are the contracts value, right?

No, that's just used for the bonus calculations. The new contract values are in column AG ("NEW $(M)").

Vik (Habs) wrote:

Dallas Stars GM wrote:The "NEW BASE" are the contracts value, right?

No, that's just used for the bonus calculations. The new contract values are in column AG ("NEW $(M)").

Bub mistakenly said AJ, but it is AG. That's what messed me up.

So Spezza got a 3M$ extra because he went from 84 to 84.5 average?

Thank you very much, great customer service!

MartyFromOTTAWA wrote:So Spezza got a 3M$ extra because he went from 84 to 84.5 average?

The formula for OV and the formula for the base salary are both completely different. "OV2" is weighted so that an 80-70 player is rated higher than a 75-75 player. This replaces the specialist bonuses. It also doesn't round any numbers down, unlike for (OF+DF/2).

The "New Base" formula goes up smoothly with OV and salary, instead of having a fixed number of brackets. This is important for players like Mikhail Grigorenko. If Grigorenko had literally one point lower in PL (90 instead of 91), his new salary under the old system would have been $4.83M instead of $7.95M. That's the main reason why some guys have huge differences between the old and new systems.

Spezza is getting a huge raise because he's one of the best players in the file. He'll get $10.2M instead of $10.5 under the new system so you're getting a discount.

You are the man Dan, much love.

It looks like the file is locked on "view only" so I can't edit new players. (Yah I suck with computers)

How do I do to unfreeze it?

MartyFromOTTAWA wrote:It looks like the file is locked on "view only" so I can't edit new players. (Yah I suck with computers)

How do I do to unfreeze it?

Rows 452+ are editable up to column y. Copy and paste there.

e: There was a typo in a few of the bonuses and they were coming out too small, it's fixed now.

SharksGM wrote:

MartyFromOTTAWA wrote:It looks like the file is locked on "view only" so I can't edit new players. (Yah I suck with computers)

How do I do to unfreeze it?

Rows 452+ are editable up to column y. Copy and paste there.

e: There was a typo in a few of the bonuses and they were coming out too small, it's fixed now.

I clicked on the link above (Bub's post - #7) but I'm not able to edit anything then on the sheet...

MartyFromOTTAWA wrote:I clicked on the link above (Bub's post - #7) but I'm not able to edit anything then on the sheet...

Ok, I logged out and tested it and found what the problem was, it should work now for rows 452+.

Yep, it works!
Thx man

Now, some values have changed.
For exemple Cohen's salary was set at 3.95M$. It's now at 4M$...

MartyFromOTTAWA wrote:Now, some values have changed.
For exemple Cohen's salary was set at 3.95M$. It's now at 4M$...

Should've signed him yesterday!

For exemple Cohen's salary was set at 3.95M$. It's now at 4M$...

Blame it on the inflation!

MartyFromOTTAWA wrote:Now, some values have changed.
For exemple Cohen's salary was set at 3.95M$. It's now at 4M$...

SharksGM wrote:e: There was a typo in a few of the bonuses and they were coming out too small, it's fixed now.

Richards is now up to $9.5M.

I wrote down the numbers for my resignings yesterday after work and they have all gone up.

TorontoGM wrote:I wrote down the numbers for my resignings yesterday after work and they have all gone up.

I think everyone got a bump. My guys did too.

Tampa Bay GM wrote:

TorontoGM wrote:I wrote down the numbers for my resignings yesterday after work and they have all gone up.

I think everyone got a bump. My guys did too.

Martin Frk's number actually went down.

In Frk's case, he has sub 75 SK and PE and sub 70 LE and CON so he ends up with negative values as bonuses and the small fixes Dan made resulted in even more taken off. On the other hand, Galchenyuk, for example, has his PE and LE bring him down but his SK, FA, and CON all boost his salary.

I mistakenly scaled the bonuses down too much, so they were like $50k even for 75+ OV players. Now they're actually consequential.

They all work like this: (Value - 75)/25 * (percent boost to base salary), to a maximum of about 250k and minimum of -100k. So guys with bad skating, PE, etc. receive discounts, and everyone else gets a boost that scales with their salary, up to a reasonable maximum. CON is most important so it gets a bigger boost and larger ceiling/floor to the bonus.

This will all go in the rulebook eventually.

it keeps going offline for me, is there a trick to it...I am at work, could be why. Computers suck here

BLUESGM wrote:it keeps going offline for me, is there a trick to it...I am at work, could be why. Computers suck here

It's at this link, which is around the middle of the current thread:
viewtopic.php?f=7&t=5099&view=unread#p47653

The link at the top of the thread is dead.

So, having a look at the, uh, Forney issue, part of the reason his new salary is so high is because of the new OV calculation, which gives extra weight to very high top six attributes. So someone with, say, 99 SH/HI and 70 everything else is worth more than a guy with straight 80s, or 80/70 vs 75/75. It's roughly a sliding specialist bonus, except with individual ratings rather than OF/DF lumped together.

I think this makes sense for most of the ratings - I'd rather have someone with great SH/PL/HI than flat across the board - but I'm not so sure when it comes to CH/PO. I don't know that I'd particularly value a player with 90 CH/70 PO or 70CH/90 PO any higher than 80/80. I'm more inclined to just average CH/PO. Any strong feelings on this issue? In Forney's case, it would drop his OV about 1.2 points and his new salary from 8.4 to 7.75, which is still huge but not as huge.

I would be more inclined to average CH/PO, b/c it seems to make sense, and b/c I prefer players that are not so heavily weighted in just one or two attributes.

How many guys does this affect right now?

I haven't counted, but it's probably mostly forwards and a few defensemen who have overdeveloped just one of CH/PO.

Probably Berglund is one?

SharksGM wrote:I haven't counted, but it's probably mostly forwards and a few defensemen who have overdeveloped just one of CH/PO.

Probably Berglund is one?

Right on!

Eller as well.

Updated the link on the top post.

My RFAs are not in the online calculator list. (Justin Sefton, Vaclav Tomek)

anyone having trouble getting this to run?

BLUESGM wrote:anyone having trouble getting this to run?

Not me.

What's happening for you?

Internet Explorer cannot display the webpage.

I will have to give it a whirl from home on chrome....heh, it rhymes.

NashvillePredatorsGM wrote:My RFAs are not in the online calculator list. (Justin Sefton, Vaclav Tomek)

You can add them yourself. I didn't copy anyone under 60 OA, as they will likely just be making league minimum anyway.