| Priority | Type | Description |
|---|---|---|
| 1 | | or OR | Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar |
| 2 | && or AND | Logical "and". Filter the column for content that matches text from either side of the operator. |
| 3 | /\d/ | Add any regex to the query to use in the query ("mig" flags can be included /\w/mig) |
| 4 | < <= >= > | Find alphabetical or numerical values less than or greater than or equal to the filtered query |
| 5 | ! or != | Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter. |
| 6 | " or = | To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query |
| 7 | - or to | Find a range of values. Make sure there is a space before and after the dash (or the word "to") |
| 8 | ? | Wildcard for a single, non-space character. |
| 8 | * | Wildcard for zero or more non-space characters. |
| 9 | ~ | Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query |
| 10 | text | Any text entered in the filter will match text found within the column |
| Arena Capacity | Ticket Price | Attendance | Attendance PCT | Income | Expenses | Estimate | Team Total Estimate | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Team | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Arena Capacity | Team Popularity | Players Total Salaries | Players Total Salaries Cap | Special Salary Cap Value | Year To Date Expenses | Salary Cap Per Days | Salary Cap To Date | Players In Salary Cap | Players Out of Salary Cap | Luxury Taxe Total | Estimated Season Revenue | Remaining Season Days | Expenses Per Days | Estimated Season Expenses | Estimated Season Expenses | Estimated Season Salary Cap | Over Minimum Salary Cap of 76,900,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Blackhawks | 6000 | 5000 | 5000 | 5000 | 1000 | 100 | 50 | 30 | 15 | 180 | 24569 | 29204 | 24387 | 24718 | 6000 | 68.25% | 97.35% | 81.29% | 82.39% | 100.00% | 36 | 18146 - 82.48% | 1,514,704$ | 9,088,226$ | 22000 | 100 | 98,475,000$ | 98,475,000$ | 2,250,000$ | 13,883,853$ | 98,475,000$ | 13,607,993$ | 22 | 0 | 0$ | 54,529,356$ | 125 | 692,931$ | 86,616,375$ | 86,616,375$ | 100,725,000$ | 23,825,000$ | 104,000,000$ | 3,275,000$ | 76,359,733$ | 44,272,714$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 30000 | 24000 | 23816 | 24000 | 6000 | 100.00% | 100.00% | 95.79% | 100.00% | 100.00% | 36 | 17969 - 99.04% | 1,280,029$ | 7,680,176$ | 18144 | 100 | 103,005,000$ | 103,005,000$ | 0$ | 14,121,380$ | 103,005,000$ | 13,707,580$ | 23 | 0 | 0$ | 46,081,056$ | 125 | 731,069$ | 91,383,625$ | 91,383,625$ | 103,005,000$ | 26,105,000$ | 104,000,000$ | 995,000$ | -74,888,236$ | -120,190,805$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 20361 | 15000 | 12000 | 12000 | 3023 | 56.56% | 50.00% | 50.00% | 50.00% | 50.38% | 36 | 10397 - 51.99% | 1,681,049$ | 10,086,294$ | 20000 | 100 | 73,801,750$ | 73,801,750$ | 3,437,500$ | 10,585,932$ | 73,801,750$ | 10,310,072$ | 24 | 1 | 0$ | 60,517,764$ | 125 | 522,771$ | 65,346,375$ | 65,346,375$ | 77,239,250$ | 339,250$ | 104,000,000$ | 26,760,750$ | 214,030,261$ | 209,201,650$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 34550 | 28563 | 26786 | 28086 | 6000 | 82.26% | 79.34% | 74.41% | 93.62% | 100.00% | 36 | 20664 - 82.66% | 1,502,587$ | 9,015,521$ | 25000 | 100 | 83,661,728$ | 83,661,728$ | 0$ | 12,385,752$ | 83,661,728$ | 11,971,958$ | 22 | 0 | 0$ | 54,093,126$ | 125 | 597,667$ | 74,708,375$ | 74,708,375$ | 83,661,728$ | 6,761,728$ | 104,000,000$ | 20,338,272$ | 58,391,396$ | 37,776,147$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 82 | 50 | 36 | 15 | 178 | 34743 | 28213 | 19158 | 24000 | 6000 | 96.51% | 94.04% | 100.00% | 100.00% | 100.00% | 36 | 18686 - 97.36% | 1,583,688$ | 9,502,125$ | 19193 | 100 | 88,308,334$ | 88,308,334$ | 620,046$ | 12,544,941$ | 88,308,334$ | 12,269,081$ | 25 | 0 | 0$ | 57,012,750$ | 125 | 622,816$ | 77,852,000$ | 77,852,000$ | 88,928,380$ | 12,028,380$ | 104,000,000$ | 15,071,620$ | 115,574,993$ | 94,735,743$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 33973 | 29391 | 24354 | 25636 | 6162 | 94.37% | 97.97% | 85.45% | 94.95% | 100.00% | 36 | 19919 - 93.62% | 1,584,478$ | 9,506,869$ | 21277 | 100 | 103,218,333$ | 103,218,333$ | 0$ | 14,383,562$ | 103,218,333$ | 14,107,701$ | 21 | 0 | 0$ | 57,041,214$ | 125 | 725,644$ | 90,705,500$ | 90,705,500$ | 103,218,333$ | 26,318,333$ | 104,000,000$ | 781,667$ | 95,323,749$ | 61,659,463$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 58 | 36 | 16 | 130 | 30000 | 24000 | 19044 | 24000 | 6000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 17174 - 100.00% | 1,438,243$ | 8,629,458$ | 17174 | 100 | 105,053,589$ | 105,053,589$ | 0$ | 14,136,007$ | 105,053,589$ | 13,970,490$ | 23 | 0 | 0$ | 51,776,748$ | 125 | 732,783$ | 91,597,875$ | 91,597,875$ | 105,053,589$ | 28,153,589$ | 104,000,000$ | -1,053,589$ | -13,178,148$ | -52,999,275$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 34020 | 27173 | 24348 | 26223 | 6978 | 94.50% | 90.58% | 71.59% | 72.84% | 77.53% | 36 | 19790 - 81.89% | 1,552,266$ | 9,313,595$ | 24168 | 100 | 103,738,778$ | 103,738,778$ | 0$ | 14,243,490$ | 103,738,778$ | 14,105,567$ | 21 | 0 | 0$ | 55,881,570$ | 125 | 722,336$ | 90,292,000$ | 90,292,000$ | 103,738,778$ | 26,838,778$ | 104,000,000$ | 261,222$ | 138,379,189$ | 103,968,759$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 90 | 60 | 40 | 20 | 225 | 28277 | 24146 | 17496 | 20360 | 5208 | 85.69% | 89.43% | 97.20% | 96.95% | 86.80% | 36 | 15915 - 90.94% | 1,543,497$ | 9,260,983$ | 17500 | 100 | 102,914,974$ | 102,914,974$ | 0$ | 14,697,104$ | 102,914,974$ | 14,283,304$ | 22 | 0 | 0$ | 55,565,898$ | 125 | 730,448$ | 91,306,000$ | 91,306,000$ | 102,914,974$ | 26,014,974$ | 104,000,000$ | 1,085,026$ | 130,593,393$ | 94,853,291$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 25185 | 23676 | 17215 | 15802 | 3807 | 91.75% | 90.19% | 84.64% | 78.03% | 79.31% | 36 | 14281 - 86.47% | 1,530,928$ | 9,185,568$ | 16515 | 100 | 102,920,857$ | 102,920,857$ | 249,750$ | 14,544,253$ | 102,920,857$ | 14,268,393$ | 23 | 0 | 0$ | 55,113,408$ | 125 | 723,592$ | 90,449,000$ | 90,449,000$ | 103,170,607$ | 26,270,607$ | 104,000,000$ | 829,393$ | 227,180,322$ | 191,844,730$ |
| 11 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 25911 | 19568 | 23153 | 19897 | 6975 | 81.48% | 75.84% | 89.74% | 75.06% | 89.42% | 36 | 15917 - 81.14% | 1,543,196$ | 9,259,173$ | 19618 | 100 | 94,975,000$ | 94,975,000$ | -2,437,500$ | 14,020,351$ | 94,975,000$ | 13,606,551$ | 22 | 1 | 0$ | 55,555,038$ | 125 | 675,690$ | 84,461,250$ | 84,461,250$ | 92,537,500$ | 15,637,500$ | 104,000,000$ | 11,462,500$ | -3,837,863$ | -32,744,075$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 100 | 65 | 30 | 10 | 220 | 24477 | 21446 | 25302 | 28921 | 5088 | 67.99% | 71.49% | 84.34% | 80.34% | 84.80% | 36 | 17539 - 76.26% | 1,492,315$ | 8,953,887$ | 23000 | 100 | 95,150,100$ | 95,150,100$ | 5,750,000$ | 13,396,779$ | 95,150,100$ | 13,120,913$ | 22 | 0 | 0$ | 53,723,322$ | 125 | 670,001$ | 83,750,125$ | 83,750,125$ | 100,900,100$ | 24,000,100$ | 104,000,000$ | 3,099,900$ | 143,798,624$ | 113,771,821$ |
| 13 | Mammoth | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 24000 | 22962 | 20971 | 18000 | 6945 | 100.00% | 95.68% | 99.86% | 100.00% | 68.09% | 36 | 15480 - 95.55% | 1,273,318$ | 7,639,910$ | 16200 | 100 | 104,405,000$ | 104,405,000$ | -1,000,000$ | 14,697,238$ | 104,405,000$ | 14,283,448$ | 21 | 0 | 0$ | 45,839,460$ | 125 | 740,724$ | 92,590,500$ | 92,590,500$ | 103,405,000$ | 26,505,000$ | 104,000,000$ | 595,000$ | 230,993,721$ | 184,242,681$ |
| 14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 70 | 45 | 30 | 25 | 165 | 32462 | 29750 | 21000 | 15492 | 6975 | 83.24% | 88.54% | 100.00% | 53.79% | 83.04% | 36 | 17613 - 80.79% | 1,435,184$ | 8,611,104$ | 21800 | 100 | 102,917,917$ | 102,917,917$ | -3,000,000$ | 14,007,992$ | 102,917,917$ | 13,801,092$ | 25 | 0 | 0$ | 51,666,624$ | 125 | 720,124$ | 90,015,500$ | 90,015,500$ | 99,917,917$ | 23,017,917$ | 104,000,000$ | 4,082,083$ | 30,319,881$ | -8,028,995$ |
| 15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 27282 | 27765 | 15600 | 19691 | 6000 | 75.78% | 92.55% | 100.00% | 82.05% | 100.00% | 36 | 16056 - 86.32% | 1,559,105$ | 9,354,630$ | 18600 | 100 | 65,868,333$ | 65,868,333$ | 17,750,000$ | 9,261,664$ | 65,868,333$ | 8,709,942$ | 23 | 1 | 0$ | 56,127,780$ | 125 | 481,851$ | 60,231,375$ | 60,231,375$ | 83,618,333$ | 6,718,333$ | 104,000,000$ | 20,381,667$ | 42,563,629$ | 38,460,034$ |
| 16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 38 | 14 | 200 | 33905 | 29232 | 19189 | 26729 | 6000 | 94.18% | 97.44% | 98.41% | 89.10% | 100.00% | 36 | 19176 - 94.70% | 1,608,551$ | 9,651,308$ | 20250 | 100 | 103,156,666$ | 103,156,666$ | -11,000,000$ | 14,818,358$ | 103,156,666$ | 14,542,498$ | 20 | 1 | 0$ | 57,907,848$ | 125 | 725,218$ | 90,652,250$ | 90,652,250$ | 92,156,666$ | 15,256,666$ | 104,000,000$ | 11,843,334$ | 132,647,083$ | 99,902,681$ |
| 17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 23291 | 23703 | 22914 | 20186 | 7500 | 61.13% | 71.83% | 87.79% | 84.11% | 50.00% | 36 | 16266 - 71.65% | 1,603,486$ | 9,620,915$ | 22700 | 100 | 111,433,274$ | 111,433,274$ | -9,750,000$ | 15,539,074$ | 111,433,274$ | 15,401,135$ | 24 | 0 | 0$ | 57,725,490$ | 125 | 775,402$ | 96,925,250$ | 96,925,250$ | 101,683,274$ | 24,783,274$ | 104,000,000$ | 2,316,726$ | 28,815,003$ | -10,384,757$ |
| 18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 65 | 55 | 25 | 10 | 85 | 35729 | 25477 | 25051 | 28020 | 7790 | 85.07% | 84.92% | 92.78% | 93.40% | 86.56% | 36 | 20345 - 88.45% | 1,375,960$ | 8,255,762$ | 23000 | 100 | 105,008,749$ | 105,008,749$ | -2,000,000$ | 14,876,256$ | 105,008,749$ | 14,393,496$ | 22 | 0 | 0$ | 49,534,572$ | 125 | 748,336$ | 93,542,000$ | 93,542,000$ | 103,008,749$ | 26,108,749$ | 104,000,000$ | 991,251$ | 147,621,907$ | 103,614,479$ |
| 19 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 81 | 43 | 42 | 17 | 190 | 34469 | 28931 | 15894 | 23833 | 6000 | 95.75% | 96.44% | 99.89% | 99.30% | 100.00% | 36 | 18188 - 97.51% | 1,551,768$ | 9,310,609$ | 18652 | 100 | 102,950,000$ | 102,950,000$ | 0$ | 14,618,625$ | 102,950,000$ | 14,363,445$ | 22 | 0 | 0$ | 55,863,654$ | 125 | 722,759$ | 90,344,875$ | 90,344,875$ | 102,950,000$ | 26,050,000$ | 104,000,000$ | 1,050,000$ | -6,259,914$ | -40,741,135$ |
| 20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 19324 | 15000 | 12000 | 12000 | 3019 | 53.68% | 50.00% | 50.00% | 50.00% | 50.32% | 36 | 10224 - 51.12% | 1,648,461$ | 9,890,768$ | 20000 | 100 | 96,314,280$ | 96,314,280$ | 0$ | 13,691,625$ | 96,314,280$ | 13,277,825$ | 20 | 1 | 0$ | 59,344,608$ | 125 | 684,926$ | 85,615,750$ | 85,615,750$ | 96,314,280$ | 19,414,280$ | 104,000,000$ | 7,685,720$ | 14,017,159$ | -12,253,983$ |