Gaw to be New EHEC Chief Financial Analyst
Moderator: SharksGM
- Virtual Jarmo
- Posts: 8716
- Joined: Fri Sep 18, 2009 5:43 pm
- Location: Cleveland, OH
- Contact:
Gaw to be New EHEC Chief Financial Analyst
The EHEC League Office will continue its transformation with the appointment of Tim Gaw as Chief Financial Analyst. He will join newly-appointed Deputy Commissioner Pat Webber to create a much stronger, much more reliable League Committee. Gaw's duties in the role as Chief Financial Analyst will be to serve as the Salary Cap Watchdog and he will work in research and development for future financial changes. He will also be the deciding tiebreaking vote for trades if Pat and I disagree. He will not be responsible for any simming.
One of the things I've asked Tim to work on is an Excel spreadsheet that we can embed into everyone's GMCP to calculate formula contracts. That would make things significantly easier on Pat and I. It would be a plug-and-play system where the GMs would enter the necessary values and Excel would spit out the salary. I'm not sure if we can write it up so it automatically pulls the values, but, anything will be easier than what we're currently doing.
We are also going to change pro-ration. That will be announced soon. And will hopefully be tracked automatically on the site.
I will also be consulting with Pat and Tim to come up with the 2013-14 salary cap. It will likely increase, but we have yet to determine how much.
Now that our first draft class is done with ELCs and E5 bonuses, and the 2011 class will reach that point next offseason, we will have to consider those two factors. We are also going to re-evaluate the AHL maximum and most likely lower it. Exceptions will remain goaltenders and underagers. It won't affect players signed in free agency last year, but will affect players signed this year.
But a big thank you to Tim for agreeing to help me out.
One of the things I've asked Tim to work on is an Excel spreadsheet that we can embed into everyone's GMCP to calculate formula contracts. That would make things significantly easier on Pat and I. It would be a plug-and-play system where the GMs would enter the necessary values and Excel would spit out the salary. I'm not sure if we can write it up so it automatically pulls the values, but, anything will be easier than what we're currently doing.
We are also going to change pro-ration. That will be announced soon. And will hopefully be tracked automatically on the site.
I will also be consulting with Pat and Tim to come up with the 2013-14 salary cap. It will likely increase, but we have yet to determine how much.
Now that our first draft class is done with ELCs and E5 bonuses, and the 2011 class will reach that point next offseason, we will have to consider those two factors. We are also going to re-evaluate the AHL maximum and most likely lower it. Exceptions will remain goaltenders and underagers. It won't affect players signed in free agency last year, but will affect players signed this year.
But a big thank you to Tim for agreeing to help me out.
Adam Burke
Former Commissioner, Current Jackets GM and Owner of Eastside's Hockey Elite Collide
Former Commissioner, Current Jackets GM and Owner of Eastside's Hockey Elite Collide
- GM Office Q
- Posts: 932
- Joined: Fri Sep 18, 2009 7:59 pm
- Commish Bub(NYR)
- Posts: 6507
- Joined: Sat Sep 26, 2009 11:30 am
- Location: Maine
Re: Gaw to be New EHEC Chief Financial Analyst
Calgary.Flames wrote:The future looks bright!
- SharksGM
- Site Admin
- Posts: 8501
- Joined: Tue Sep 22, 2009 9:21 pm
Re: Gaw to be New EHEC Chief Financial Analyst
You could do a cap calculator on the site. It would be possible to have something like have roster.php link to a 'player.php', which would read each player's data from players.ehm, listing attributes and statistics. You could do the same with a fastsim playes.ehm and have a button to calculate a new contract.
Keeping track of pro-rationed cap hits would be a much bigger pain in the ass. I look forward to Tim implementing it
. Good luck buddy!
Keeping track of pro-rationed cap hits would be a much bigger pain in the ass. I look forward to Tim implementing it

Re: Gaw to be New EHEC Chief Financial Analyst
That's the easy part now that we've spent a season calculating it through Excel. Especially now that pro-rating starts from opening night rather than after January.SharksGM wrote:Keeping track of pro-rationed cap hits would be a much bigger pain in the ass. I look forward to Tim implementing it. Good luck buddy!
(# of days in the season - # of days left in the season)/# of days in the season x AAV = portion of cap hit owed by new team. So much easier to deal with players traded multiple times in the season as well.
- Virtual Jarmo
- Posts: 8716
- Joined: Fri Sep 18, 2009 5:43 pm
- Location: Cleveland, OH
- Contact:
Re: Gaw to be New EHEC Chief Financial Analyst
Yeah! What Tim said!
We're doing pro-ration all year. So, the pro-rated cost of acquiring a player would be the # of days left in the season x his daily salary.
Case in point, I believe last season had 186 days. So (Salary / 186) * days left in season = pro-rated salary and the acquiring team's cap hit on that player. (Salary / 186) * days spent with previous team = cap hit for the team that traded him.
Believe that's how the NHL does it. But they also do a bunch of other complicated shit too.
Our goal is for everything to be calculated in Excel, hopefully automatically updated daily, and posted to the site. We're making great progress on an Excel spreadsheet to embed to the site that will calculate formula contracts.
Should make everything easier for everybody, especially if we can get it to self-update from the roster pages.
We're doing pro-ration all year. So, the pro-rated cost of acquiring a player would be the # of days left in the season x his daily salary.
Case in point, I believe last season had 186 days. So (Salary / 186) * days left in season = pro-rated salary and the acquiring team's cap hit on that player. (Salary / 186) * days spent with previous team = cap hit for the team that traded him.
Believe that's how the NHL does it. But they also do a bunch of other complicated shit too.
Our goal is for everything to be calculated in Excel, hopefully automatically updated daily, and posted to the site. We're making great progress on an Excel spreadsheet to embed to the site that will calculate formula contracts.
Should make everything easier for everybody, especially if we can get it to self-update from the roster pages.
Adam Burke
Former Commissioner, Current Jackets GM and Owner of Eastside's Hockey Elite Collide
Former Commissioner, Current Jackets GM and Owner of Eastside's Hockey Elite Collide
Re: Gaw to be New EHEC Chief Financial Analyst
Well, mostly everybody.Commissioner (CBJ) wrote:Should make everything easier for everybody, especially if we can get it to self-update from the roster pages.
- SharksGM
- Site Admin
- Posts: 8501
- Joined: Tue Sep 22, 2009 9:21 pm
Re: Gaw to be New EHEC Chief Financial Analyst
I think it's a little easier to do it by games played than days in the season, otherwise teams can do chintzy shit like send down players on two-way deals on off days to 'save' cap space (and not have them actually report to the AHL). Although with manual roster movement I assume the simmers would create some kind of rule for this to avoid being driven mad by repeated demotions and promotions. I'm not sure which way the NHL does it, actually.
- Virtual Jarmo
- Posts: 8716
- Joined: Fri Sep 18, 2009 5:43 pm
- Location: Cleveland, OH
- Contact:
Re: Gaw to be New EHEC Chief Financial Analyst
It's not like we're individually counting each day.SharksGM wrote:I think it's a little easier to do it by games played than days in the season, otherwise teams can do chintzy shit like send down players on two-way deals on off days to 'save' cap space (and not have them actually report to the AHL). Although with manual roster movement I assume the simmers would create some kind of rule for this to avoid being driven mad by repeated demotions and promotions. I'm not sure which way the NHL does it, actually.
If you traded me Komisarek (4.5M) on the 40th day of the 186-day season, your cap hit from him is 967,742 ((4.5M/186) * 40)) and mine is 3,532,258 ((4.5M/186) * 146). Rounding to the nearest dollar amount.
This way, it's also fairly distributed if a player is traded a second time during the season.
The NHL also allows you to go over the cap in the second half by however much you were under at the season's midpoint. That's much easier to work around than the way we're going to do pro-ration.
Adam Burke
Former Commissioner, Current Jackets GM and Owner of Eastside's Hockey Elite Collide
Former Commissioner, Current Jackets GM and Owner of Eastside's Hockey Elite Collide
- SharksGM
- Site Admin
- Posts: 8501
- Joined: Tue Sep 22, 2009 9:21 pm
Re: Gaw to be New EHEC Chief Financial Analyst
The NHL does actually count every day, though. Or every game at least. Although the cap isn't really 'hard' because you can go over for at least one season and it will just reduce your cap for the next.
How are NHL/AHL movements going to be handled, then?
How are NHL/AHL movements going to be handled, then?
- Virtual Jarmo
- Posts: 8716
- Joined: Fri Sep 18, 2009 5:43 pm
- Location: Cleveland, OH
- Contact:
Re: Gaw to be New EHEC Chief Financial Analyst
Same way it currently does. When guy's on the NHL roster, full cap hit. If it's a pro-rated cap hit, then the full pro-rated cap hit.SharksGM wrote:How are NHL/AHL movements going to be handled, then?
Adam Burke
Former Commissioner, Current Jackets GM and Owner of Eastside's Hockey Elite Collide
Former Commissioner, Current Jackets GM and Owner of Eastside's Hockey Elite Collide