2019-20 Financials

[SharksGM]

Code: Select all

TEAM  TEAMID  GP  TODAY     TODATE    PENALTIES LTIR      PROJECTED OVER_CAP CONTR  MAXCAP    CAPSPACE
ANA   1     81    59950000  59942469  1264000   2750000   59942560    N      48     64660000   4710000
CBS   2     81    59434000  58866024  800000    437000    58872951    N      50     151852000  92418000
BOS   3     81    56818000  53554172  0         0         53593975    N      49     582112000  525294000
BUF   4     81    50395000  57951666  2610000   4430000   57859512    N      48     225915000  175520000
CGY   5     81    58020000  57968888  600000    0         57969512    N      49     224520000  166500000
CAR   6     81    59700000  59823209  0         0         59821707    N      50     74320000   14620000
CHI   7     81    61550000  59713580  300000    0         59735975    N      50     83200000   21650000
COL   8     81    60000000  56712592  2840000   9400000   56752682    N      50     326280000  266280000
WPG   9     81    59010000  58574691  0         0         58580000    N      48     175450000  116440000
DAL   10    81    58790000  59819506  1200000   0         59806951    N      50     74620000   15830000

Code: Select all

TEAM  TEAMID  GP  TODAY     TODATE    PENALTIES LTIR      PROJECTED OVER_CAP CONTR  MAXCAP    CAPSPACE
DET   11    81    56870000  56539135  0         0         56543170    N      48     340330000  283460000
EDM   12    81    62293000  59761160  503000    0         59792036    N      49     79346000   17053000
FLA   13    81    60052000  59971111  0         1400000   59972097    N      45     62340000   2288000
LA    14    81    60000000  59931604  0         6710000   59932439    N      46     65540000   5540000
MIN   15    81    60000000  59995370  514000    6380000   59995426    N      45     60375000   375000
MTL   16    81    60630000  59750617  0         2880000   59761341    N      50     80200000   19570000
NYI   17    81    55544000  55334617  0         0         55337170    N      50     437896000  382352000
NYR   18    81    59052000  58355950  0         0         58364439    N      47     193168000  134116000
NAS   19    81    62880000  59877358  0         0         59913975    N      50     69934000   7054000
NJ    20    81    58768000  58464049  1312000   118000    58467756    N      46     184412000  125644000

Code: Select all

TEAM  TEAMID  GP  TODAY     TODATE    PENALTIES LTIR      PROJECTED OVER_CAP CONTR  MAXCAP    CAPSPACE
OTT   21    81    61669000  59885160  0         0         59906914    N      50     69302000   7633000
PHI   22    81    60360000  59869135  0         0         59875121    N      45     70600000   10240000
ARI   23    81    56184000  56184000  0         0         56184000    N      47     369096000  312912000
PIT   24    81    58700000  56289135  0         10000     56318536    N      50     360580000  301880000
SJ    25    81    60550000  59915185  300000    5040000   59922926    N      50     66870000   6320000
STL   26    81    60080000  59966419  0         0         59967804    N      50     62720000   2640000
TB    27    81    66064000  59452888  0         0         59533512    N      48     104316000  38252000
TOR   28    81    58210000  59294691  980000    0         59281463    N      48     117130000  58920000
VAN   29    81    59896000  59922419  600000    0         59922097    N      48     66284000   6388000
WSH   30    81    60000000  59990518  1584000   5880000   59990634    N      50     60768000   768000

TBD:

LTIR:

ANA: Morrow (2.75, ANA@59.95)
BUF: Rankin (3.125, BUF@59.685), Carlsson (1.305, BUF@58.155)
CBS: Lindell (0.16, CBS@58.26), Hanzal (0.034, CBS@59.434), Greene (0.234, CBS@59.434)
CGY: Lucic (4.4, CGY@58.72)
COL: Frolik (6.4, COL>60), Cotton (3, COL>60)
FLA: Musil (1.4, FLA>60)
LA: Stastny (6.71, LA@58.55)
MIN: Whitney (2.1, MIN>60), Yakupov (4.28M, MIN>60)
NJ: Markstrom (0.118, NJ@59.018)
OTT: Kane (5.96, OTT>60)
PHI: Couturier (5.88, PHI>60)
PIT: Forsling (0.01, PIT@59.33)
SJ: Ladd (5.04M, SJ>60)
WSH: Burns (5.88, WSH@59.92)

Coming off soon: Lucic

[SharksGM]

I didn't process Michalek's buyout, so Anaheim's numbers are off. Everyone else should be accurate.

Those of you near the contract limit may want to talk to Bern.

[Vik (Habs)]

Code: Select all

TEAM  GP   TODAY        TO DATE      PENALTIES    LTIR         PROJECTED    MAX           SPACE       CONTRACTS
ANA   81   59950000     59936914     1264000      2750000      59937074     65109966      5159966     48
CBJ   81   59434000     58866025     800000       1862000      58872952     151851975     92417975    50
BOS   81   56818000     53554173     0            0            53593976     582111987     525293987   49
BUF   81   50395000     57904753     2610000      3125000      57813171     229715007     179320007   48
CGY   81   58020000     57968889     600000       0            57969512     224519991     166499991   49
CAR   81   59700000     59815309     0            0            59813903     74959970      15259970    50
CHI   81   60750000     59688395     300000       800000       59701341     85240005      24490005    50
COL   81   60000000     56662247     2840000      9400000      56702951     330357993     270357993   50
WPG   81   59010000     58574691     0            0            58580000     175450029     116440029   48
DAL   81   58790000     59816420     1200000      0            59803903     74869980      16079980    50

Code: Select all

DET   81   56870000     56531728     0            0            56535853     340930032     284060032   48
EDM   81   62293000     59771037     503000       0            59801793     78546003      16253003    49
FLA   81   60000000     59965975     0            2500000      59966390     62756024      2756024     45
L.A   81   60000000     59931605     0            6710000      59932439     65539995      5539995     46
MIN   81   60000000     59982222     514000       6380000      59982439     61440018      1440018     45
MTL   81   63510000     59892840     0            0            59936952     68679959      5169959     50
NYI   81   55544000     55334617     0            0            55337170     437896023     382352023   50
NYR   81   59052000     58355951     0            0            58364439     193167969     134115969   47
NSH   81   62880000     59875506     0            0            59912146     70084013      7204013     50
N.J   81   58768000     58471457     1312000      3378000      58475073     183811983     125043983   46

Code: Select all

OTT   81   61669000     59920617     0            0            59941939     66430023      4761023     50
PHI   81   60360000     59869136     0            0            59875122     70599984      10239984    45
ARI   81   56184000     56184000     0            0            56184000     369096000     312912000   47
PIT   81   58700000     56289136     0            10000        56318537     360579984     301879984   50
S.J   81   60550000     59912099     300000       5040000      59919878     67119980      6569980     50
STL   81   60080000     59966420     0            0            59967805     62719980      2639980     50
T.B   81   66064000     59452889     0            0            59533512     104315991     38251991    48
TOR   81   58210000     59294691     980000       0            59281463     117130029     58920029    48
VAN   81   59896000     59933481     600000       0            59933024     65388039      5492039     48
WSH   81   60000000     59990519     1584000      5880000      59990635     60767961      767961      50

[Vik (Habs)]

Differences:
BUF = 130k
Comes from buyout penalties. Should be 2.61M for Shattenkirk (3.48 * 75%).

COL = 2.36M
I assume part of it is timing on Elias Lindholm (2.04M). Don't know about the other 320k. Just added them up manual and got 53.65M.
Edit - just realized it's probably all Nikolaj Ehlers' AHL salary.

NYR = 1.25M
Easiest explanation I can see is you're missing Eric Roy and Eric Comrie's AHL salaries.

NJ = 314k
Joe Colborne buyout should be 704k, not 740k. And best guess on the rest is Marko Dano's AHL salary.

WSH = 450k
Best guess is Nicholas Paul and Brett Pesce's AHL salaries.

[SharksGM]

Oh, I forgot to update the AHL age exemption cutoff.

[SharksGM]

Carolina needs to demote someone expensive (Eiserman, Roy or Sandstrom) for a game, then do something like demote Burke and swap Bouchard and Brizgala.

Florida should be ok (just barely) after the changes I made (not reflected in these numbers as I did them later).

MIN is still way over even after the Miller buyout; Turcotte in the AHL would help.

NYR needs to dump Comrie somehow, or send down Dube for a while, and return two U20 players to juniors.

Arizona needs a farm team and Chicago is nearly all fast-signs.

[Vik (Habs)]

MIN is still way over even after the Miller buyout; Turcotte in the AHL would help.

They already named two different underagers. You must've run your numbers before the Miller buyout (they're still over but not by as much as you're showing). They also still need a callup.

[SharksGM]

CAR, MIN and NYR still over. Take further action or I'll do it for you.

[Vik (Habs)]

CAR, MIN and NYR still over. Take further action or I'll do it for you.

NYR has also had all 4 of their underagers play two games now.

[Dallas Stars GM]

Vik, could you please post our MAX from time to time? If possible.
That would be very helpful .

[Vik (Habs)]

Vik, could you please post our MAX from time to time? If possible.
That would be very helpful .

Been thinking I should add that to the post I always update but then I remember it would require effort on my part. Maybe I'll do it to avoid doing something else requiring effort.

[Dallas Stars GM]

Hmm if it's too time consuming I totally understand.
It's still very nice of you how you inform us the way you do.
Or is there a way how to calculate it ? A way that I could understand ?

[SharksGM]

You could read it directly from the first post, for example.

[Dallas Stars GM]

But if I understand that correctly, the last time it was updated was 6th Oct. Or am I wrong ?

[SensGM]

But if I understand that correctly, the last time it was updated was 6th Oct. Or am I wrong ?

You’re wrong. Look at the GP column.

[Dallas Stars GM]

Oh I see now. Thank you so much

[SharksGM]

I am super special so apparently when I edit posts it doesn't show a timestamp.

[Dallas Stars GM]

Literally timeless

[SharksGM]

Montreal's currently over but that's presumably just to maximize Mathias' LTIR.

Carolina and Nashville are actually over by ~50k each, respectively.

[Vik (Habs)]

Montreal's currently over but that's presumably just to maximize Mathias' LTIR.

Carolina and Nashville are actually over by ~50k each, respectively.

I also have Minnesota as being over by ~150k.

You've got some surprisingly low "TODATE" figures.
Minnesota: I have them as 60,345,000 for their first game, 59,945,000 for each subsequent game = 60,025,000.
Florida: 59,532,000 for every game = 59,532,000.
Ottawa: 58,849,000 for the first game, 58,649,000 for every game since = 58,689,000.
Pittsburgh: 59,330,000 for every game = 59,330,000.

Only other differences I noticed were Dallas and Vancouver which I assume is based on how we calculated things for the 15th (I didn't include their transactions between the 14th and 16th, presumably you did).

[SharksGM]

Montreal's currently over but that's presumably just to maximize Mathias' LTIR.

Carolina and Nashville are actually over by ~50k each, respectively.

I also have Minnesota as being over by ~150k.

You've got some surprisingly low "TODATE" figures.

Only other differences I noticed were Dallas and Vancouver which I assume is based on how we calculated things for the 15th (I didn't include their transactions between the 14th and 16th, presumably you did).

Oh, apparently something went horribly wrong on the 11th. I went back and fixed that. Incidentally, every team's cap log is in the cap folder in the zip if you want to double check it.

I did use the rosters from the 16th to do cap calculations from the 15th, lacking the actual file, but it looks like VAN did have the same lineup as on the 13th and I'm giving Dallas the benefit of the doubt too since neither Cederholm nor Hawryluk played.

[SharksGM]

CAR and NAS are still over. I demoted Burke and promoted Dahlstrom for CAR to get them under since they have a game tomorrow. NAS has until Sunday to get back under.

[Dallas Stars GM]

Yes. They didn't play yet. I just prepared my roster in advance for tonight's game as I won't be at home today and tomorrow to prepare it.

[Vik (Habs)]

Added max allowable and cap space available to my numbers.

[TorontoGM]

Looking at my cap number gives me anxiety.

[SharksGM]

Nashville's still over, although I'm mostly just bumping the thread so it shows up in active topics again.

[SensGM]

Is there a reason why Nichushkin is not on LTIR?

[SharksGM]

Is there a reason why Nichushkin is not on LTIR?

I didn't get to it because my keyboard broke. Go figure.

[SharksGM]

I retroactively removed DeBrusk from Florida's cap for the last two games since he was up unnecessarily and I don't want to perform cap gymnastics for an orphan team. Just pretend he was sent down on the morning of the 29th.

[SharksGM]

Dallas still over.

[SharksGM]

Dallas still over.

It was time for another bump anyway.

[Dallas Stars GM]

Fixed

[SharksGM]

STL still over.

[SharksGM]

Apparently I'd forgotten to note that Burns is on LTIR (although he was entered), and completely forgot enter Barzal (although he'll be coming off soon and Anaheim hasn't needed the LTIR yet).

[SharksGM]

ANA & VAN still over. Get thee under.

[VancouverCanucksGM]

Stop calling up players and there wont be a problem.

[Jets GM]

Stop calling up players and there wont be a problem.

The only reason a simmer would call up players is because your lines will not work.

[SharksGM]

Everyone is fine and any suggestions otherwise are illusory.

[AvalancheGM]

EHM won't load for me so are the numbers in the first post up to date? Just wondering how much cap I have to work with.

[Edmonton Mike]

EHM won't load for me so are the numbers in the first post up to date? Just wondering how much cap I have to work with.

The GP column is Games Played. That'll tell you right away if it's up to date or not

[Vik (Habs)]

EHM won't load for me so are the numbers in the first post up to date? Just wondering how much cap I have to work with.

I almost always update mine (3rd post) after every sim. They don't match exactly to Dan's but there shouldn't be any major variance. I banked a lot of cap space for the Avs so you shouldn't have any real concerns at this point.

[AvalancheGM]

Thanks for the info and clearing the deck!

[SharksGM]

EHM won't load for me so are the numbers in the first post up to date? Just wondering how much cap I have to work with.

I update after every sim I do, which is at least every other day. There's also a full log for every team in the save file under the cap folder.

[SharksGM]

All-Star break update. TB & DAL need minor adjustments.

[Dallas Stars GM]

TB & DAL need minor adjustments.

Grigorenko is out for month. Put him on LTIR. I should have 5,9 cap space

[SharksGM]

Meaningless bump.

[SharksGM]

Meaningless bump.

[SharksGM]

One more week until none of this matters anymore.

The Bruins have 100M in cap space for their last 5 games. Use it wisely.

[AvalancheGM]

Is there an easy way to figure out our cap situation for next year? It's more complex than other leagues I've been in and it would be nice to know while making off-season moves whether I'm putting my team in cap hell lol.

[SharksGM]

Is there an easy way to figure out our cap situation for next year? It's more complex than other leagues I've been in and it would be nice to know while making off-season moves whether I'm putting my team in cap hell lol.

Make a spreadsheet, add up the 22-23 players you expect to start on your roster, your buyout penalties (you have some for next season), and the penalties from AHL veterans making over 800k. Use Libreoffice or Google Sheets if you don't have Excel.