Filter Tips
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 |
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 | Capacity | Team Popularity | Players Total Salaries | Players Total Average Salaries | 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 5,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
1 | Avalanche | 8500 | 5000 | 4500 | 5000 | 2000 | 100 | 80 | 48 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 43,975,000$ | 33,500,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 271,220,612$ | 271,220,612$ |
2 | Blackhawks | 8000 | 5000 | 4000 | 3000 | 2000 | 120 | 80 | 50 | 35 | 150 | 22565 | 15000 | 12000 | 9000 | 6000 | 94.02% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 21522 - 97.83% | 1,907,600$ | 5,722,800$ | 22000 | 100 | 91,376,001$ | 33,101,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 114,131,310$ | 114,131,310$ |
3 | BlueJacket | 8000 | 7000 | 4000 | 2000 | 2000 | 105 | 85 | 60 | 50 | 180 | 24000 | 17538 | 11561 | 6000 | 6000 | 100.00% | 83.51% | 96.34% | 100.00% | 100.00% | 38 | 21700 - 94.35% | 2,028,130$ | 6,084,390$ | 23000 | 100 | 85,648,001$ | 54,173,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 149,855,467$ | 149,855,467$ |
4 | Blues | 8000 | 7000 | 4000 | 4000 | 2000 | 99 | 78 | 65 | 50 | 199 | 16000 | 13214 | 6873 | 6539 | 3587 | 100.00% | 94.39% | 85.91% | 81.74% | 89.68% | 39 | 23107 - 92.43% | 2,051,100$ | 4,102,200$ | 25000 | 100 | 83,775,001$ | 37,515,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 270,831,213$ | 270,831,213$ |
5 | Bruins | 7000 | 6000 | 3000 | 7000 | 2000 | 100 | 60 | 35 | 20 | 150 | 21000 | 18000 | 9000 | 15891 | 6000 | 100.00% | 100.00% | 100.00% | 75.67% | 100.00% | 38 | 23297 - 93.19% | 1,570,940$ | 4,712,820$ | 25000 | 100 | 82,095,001$ | 24,020,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 65,004,245$ | 65,004,245$ |
6 | Canadiens | 9000 | 6500 | 4500 | 3000 | 2000 | 130 | 100 | 75 | 55 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 82,850,001$ | 51,400,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 85,272,926$ | 85,272,926$ |
7 | Canucks | 10000 | 7000 | 4000 | 2000 | 2000 | 100 | 80 | 50 | 45 | 175 | 18800 | 13491 | 8000 | 4000 | 4000 | 94.00% | 96.36% | 100.00% | 100.00% | 100.00% | 39 | 24146 - 96.58% | 2,119,640$ | 4,239,280$ | 25000 | 100 | 81,125,001$ | 27,100,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 314,624,557$ | 314,624,557$ |
8 | Capitals | 10000 | 7500 | 3275 | 2275 | 1950 | 150 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 79,078,001$ | 30,675,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 14,411,434$ | 14,411,434$ |
9 | Coyotes | 8000 | 7000 | 4000 | 4000 | 2000 | 95 | 80 | 65 | 35 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 64,250,000$ | 25,000,000$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 210,510,491$ | 210,510,491$ |
10 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 65 | 35 | 22 | 230 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 60,697,501$ | 44,347,500$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 16,494,594$ | 16,494,594$ |
11 | Ducks | 10000 | 6000 | 4000 | 3000 | 2000 | 120 | 75 | 50 | 30 | 230 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 84,710,501$ | 49,132,500$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 81,712,425$ | 81,712,425$ |
12 | Flames | 8000 | 6000 | 5000 | 4000 | 2000 | 95 | 75 | 30 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 73,955,001$ | 53,300,000$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 238,868,733$ | 238,868,733$ |
13 | Flyers | 9000 | 7000 | 4000 | 3000 | 2000 | 150 | 100 | 75 | 50 | 200 | 11986 | 9875 | 6275 | 6000 | 3721 | 66.59% | 70.54% | 78.44% | 100.00% | 93.03% | 39 | 18929 - 75.71% | 2,150,113$ | 4,300,225$ | 25000 | 100 | 60,876,501$ | 37,226,500$ | 0$ | 0$ | 0$ | 0$ | 23 | 1 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 260,522,658$ | 260,522,658$ |
14 | GoldenKnights | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 80 | 50 | 40 | 200 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 1,460,000$ | 2,920,000$ | 18000 | 100 | 85,000,001$ | 43,150,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | -95,362,800$ | -95,362,800$ |
15 | Hurricanes | 8500 | 5000 | 3500 | 5000 | 2000 | 90 | 75 | 60 | 40 | 150 | 25500 | 15000 | 10500 | 14858 | 6000 | 100.00% | 100.00% | 100.00% | 99.05% | 100.00% | 38 | 23953 - 99.80% | 1,848,107$ | 5,544,320$ | 24000 | 100 | 80,594,251$ | 33,494,250$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 189,190,629$ | 189,190,629$ |
16 | Islanders | 7000 | 6000 | 5000 | 5000 | 2000 | 150 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 80,407,501$ | 40,032,500$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | -27,733,346$ | -27,733,346$ |
17 | Jets | 8250 | 6750 | 3750 | 4250 | 2000 | 100 | 65 | 51 | 35 | 205 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 63,238,201$ | 47,262,200$ | 0$ | 0$ | 0$ | 0$ | 22 | 2 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 199,038,307$ | 199,038,307$ |
18 | Kings | 10000 | 5000 | 3000 | 5000 | 2000 | 100 | 80 | 50 | 40 | 200 | 19960 | 10000 | 6000 | 9854 | 3876 | 99.80% | 100.00% | 100.00% | 98.54% | 96.90% | 39 | 24845 - 99.38% | 2,132,680$ | 4,265,360$ | 25000 | 100 | 84,800,001$ | 37,200,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 79,105,072$ | 79,105,072$ |
19 | Lightning | 10000 | 6000 | 3000 | 4000 | 2000 | 95 | 70 | 60 | 40 | 150 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 57,376,870$ | 30,026,870$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 218,004,043$ | 218,004,043$ |
20 | MapleLeafs | 7000 | 6000 | 5000 | 5000 | 2000 | 150 | 95 | 70 | 60 | 170 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 61,625,000$ | 45,592,500$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 253,657,681$ | 253,657,681$ |
21 | Oilers | 8000 | 6000 | 5000 | 4000 | 2000 | 100 | 75 | 50 | 35 | 175 | 16000 | 12000 | 8914 | 8000 | 4000 | 100.00% | 100.00% | 89.14% | 100.00% | 100.00% | 39 | 24457 - 97.83% | 1,962,850$ | 3,925,700$ | 25000 | 100 | 85,250,001$ | 42,725,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 160,981,812$ | 160,981,812$ |
22 | Panthers | 7999 | 6000 | 4001 | 5000 | 2000 | 150 | 100 | 75 | 50 | 200 | 11731 | 9589 | 6393 | 6697 | 3515 | 73.33% | 79.91% | 79.89% | 66.97% | 87.88% | 39 | 18963 - 75.85% | 2,117,938$ | 4,235,875$ | 25000 | 100 | 83,925,001$ | 43,300,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 40,009,055$ | 40,009,055$ |
23 | Penguins | 8500 | 5000 | 3500 | 4000 | 2000 | 125 | 75 | 55 | 30 | 225 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 80,600,001$ | 40,652,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 65,197,567$ | 65,197,567$ |
24 | Predators | 8000 | 7000 | 3000 | 5000 | 2000 | 105 | 75 | 60 | 30 | 150 | 32000 | 27116 | 12000 | 19276 | 8000 | 100.00% | 96.84% | 100.00% | 96.38% | 100.00% | 37 | 24598 - 98.39% | 1,972,995$ | 7,891,980$ | 25000 | 100 | 83,800,000$ | 47,049,999$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 124,428,394$ | 124,428,394$ |
25 | Rangers | 8000 | 7000 | 4000 | 4000 | 2000 | 150 | 110 | 80 | 55 | 250 | 12801 | 8966 | 6264 | 6218 | 2837 | 80.01% | 64.04% | 78.30% | 77.73% | 70.93% | 39 | 18543 - 74.17% | 2,229,385$ | 4,458,770$ | 25000 | 100 | 83,631,001$ | 46,730,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 1 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 96,816,516$ | 96,816,516$ |
26 | RedWings | 8000 | 6000 | 5000 | 4000 | 2000 | 135 | 105 | 75 | 60 | 210 | 27817 | 18984 | 12756 | 12038 | 6978 | 86.93% | 79.10% | 63.78% | 75.24% | 87.23% | 37 | 19643 - 78.57% | 2,223,244$ | 8,892,975$ | 25000 | 100 | 84,545,001$ | 40,804,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 183,729,625$ | 183,729,625$ |
27 | Sabres | 7000 | 6000 | 5000 | 5000 | 2000 | 150 | 100 | 75 | 50 | 200 | 18249 | 14239 | 9313 | 10157 | 5379 | 86.90% | 79.11% | 62.09% | 67.71% | 89.65% | 38 | 19112 - 76.45% | 2,147,792$ | 6,443,375$ | 25000 | 100 | 84,195,001$ | 32,970,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 136,867,025$ | 136,867,025$ |
28 | Senators | 8000 | 6000 | 5000 | 4000 | 2000 | 125 | 100 | 76 | 60 | 225 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 77,918,001$ | 30,018,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 152,111,776$ | 152,111,776$ |
29 | Sharks | 6005 | 5995 | 5000 | 6000 | 2000 | 100 | 80 | 60 | 50 | 200 | 12010 | 11990 | 7238 | 6569 | 3383 | 100.00% | 100.00% | 72.38% | 54.74% | 84.58% | 39 | 20595 - 82.38% | 1,799,765$ | 3,599,530$ | 25000 | 100 | 75,493,130$ | 43,061,129$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 36,824,086$ | 36,824,086$ |
30 | Stars | 10000 | 5000 | 5000 | 3000 | 2000 | 150 | 75 | 50 | 25 | 300 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 85,042,501$ | 29,417,500$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 87,515,342$ | 87,515,342$ |
31 | Wild | 7500 | 6000 | 4500 | 5000 | 2000 | 88 | 53 | 38 | 27 | 130 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 49,325,000$ | 15,475,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 13 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 6,193,993$ | 6,193,993$ |