I have 1 more player - Dano at 925k. +925k
I have Petan at 900k instead of 725. His AAV was 863,333 last year. +175k
I have Roslovic at 1,106,666 instead of 1,137,500 -30.834k
I have Copp at 1mil instead of 1.1mil -100k
I have Lowry at 3.2 instead of 3.5 -300k
I have Tanev at 900k instead of 925k -25k
I have Morrissey at 3.2mil instead of 5.5 mil -2300k
I have Trouba at 6mil instead of 6.5 -500k
I have Poolman at 1mil instead of 925k +75k
I have Helle at 5.75mil instead of 5.5mil +250k
I have xxx backup goalie at 1.5mil instead of 650k for Brossoit +850k
Difference of -980.834 my estimate should be below yours.
My total is 78,356,998 for 23 players.
Yours is 78,787,499 for 22 players.
The discrepancy is 430.501k. Not huge but, but I don't see where the addition is different.
I think I will try plugging your numbers into my spreadsheet. I am probably making a transcription error here. Like one of my minuses should be a plus or something.
Player | AAV | | | | |
Connor, Kyle | 1,775,000 | Scheifele, Mark | 6,125,000 | Wheeler, Blake | 5,600,000 |
Ehlers, Nikolaj | 6,000,000 | Little, Bryan | 5,291,666 | Laine, Patrik | 3,575,000 |
Perreault, Mathieu | 4,125,000 | Roslovic, Jack | 1,106,666 | Petan, Nicolas | 950,000 |
Copp, Andrew | 1,000,000 | Lowry, Adam | 3,500,000 | Tanev, Brandon | 925,000 |
| | | | | |
Morrissey, Josh | 5,500,000 | Trouba, Jacob | 6,500,000 | | |
Kulikov, Dmitry | 4,333,333 | Byfuglien, Dustin | 7,600,000 | | |
Chiarot, Ben | 1,400,000 | Myers, Tyler | 5,500,000 | | |
Morrow, Joe | 1,000,000 | Poolman, Tucker | 925,000 | | |
| | | | Stuart buyout | 583,333 |
Hellebuyck, Connor | 5,500,000 | | | | |
Brossoit, Laurent | 650,000 | | | Total cap hit: | 79,464,998 |
| | | | Cap Ceiling | 79,500,000 |
[TBODY]
[/TBODY]
The Petan number I had is actually too low, the qualifying offer has to be at least 10% higher I think, so I just rounded it up to 950k from around ~945k.
I've realized that I was looking at Copp's actual salary rather than his AAV, and I don't know whose contract I was adding Roslovic's bonus to, but 1,106,666 is the correct number rather than the 1,137,500 I had.
I also added Stuart's buyout which moves the Jets less than 50k from the cap.
So the differences from my new total are:
Lowry at 3.2m (-300k, 79,164,998),
Morrissey at 3.2m (-2.3m, 76,864,998),
Trouba at 6m (-500k, 76,364,998),
Petan at 900k, (-50k, 76,314,998)
Hellebuyck at 5.75m (+250k, 76,564,998),
Backup at 1.5m, (+850k, 77,414,998),
Poolman at 1m, (+75k, 77,489,998),
Dano at 925k, (+925k, 78,414,998)
Tanev at 900k (-25k, 78,389,998)
78,389,998 should be your cap hit if those are the only differences, for a difference of 1,075,000 from my new total, or 33k difference from your own.
The difference between your listed amount (78,356,998) and my new total (79,464,998) should be 1,108,000.
So a total of -3,175,000 difference on Lowry, Morrissey, Trouba, Petan, and Tanev's contracts, and +2,100,000 from Hellebuyck, Brossoit/backup, Poolman, and Dano.