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% | 2 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 40,087,500$ | 23,900,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 11 | 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 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 22000 | 100 | 59,795,000$ | 6,650,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 1 | 0$ | 0$ | 11 | 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 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 86,017,501$ | 22,750,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 11 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 154,025,592$ | 154,025,592$ |
4 | Blues | 8000 | 7000 | 4000 | 4000 | 2000 | 99 | 78 | 65 | 50 | 199 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 91,425,000$ | 9,890,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 11 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 281,712,152$ | 281,712,152$ |
5 | Bruins | 7000 | 6000 | 3000 | 7000 | 2000 | 100 | 60 | 35 | 20 | 150 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 89,900,001$ | 24,475,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 11 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 74,505,125$ | 74,505,125$ |
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% | 2 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 71,225,001$ | 22,150,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 11 | 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 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 92,900,000$ | 25,150,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 1 | 0$ | 0$ | 11 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 336,624,557$ | 336,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% | 3 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 84,078,000$ | 11,575,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 11 | 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% | 4 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 69,450,000$ | 35,300,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 11 | 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% | 4 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 88,375,000$ | 30,350,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 11 | 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% | 4 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 85,253,000$ | 29,950,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 11 | 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% | 2 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 62,828,000$ | 34,620,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 11 | 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 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 54,645,001$ | 16,925,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 11 | 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 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 80,925,001$ | 21,075,001$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 11 | 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 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 3 | 0 - 0.00% | 0$ | 0$ | 24000 | 100 | 95,850,000$ | 34,425,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 11 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 207,678,589$ | 207,678,589$ |
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% | 1 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 103,890,000$ | 38,900,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 11 | 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% | 2 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 68,235,000$ | 29,600,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 11 | 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 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 3 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 76,010,001$ | 23,625,000$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 11 | 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% | 3 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 50,997,500$ | 16,000,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 11 | 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% | 3 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 61,425,001$ | 34,500,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 11 | 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 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 95,165,000$ | 30,025,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 11 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 164,961,812$ | 164,961,812$ |
22 | Panthers | 7999 | 6000 | 4001 | 5000 | 2000 | 150 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 91,825,000$ | 27,250,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 11 | 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% | 3 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 81,850,001$ | 39,700,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 11 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 65,197,566$ | 65,197,566$ |
24 | Predators | 8000 | 7000 | 3000 | 5000 | 2000 | 105 | 75 | 60 | 30 | 150 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 73,350,001$ | 23,350,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 1 | 0$ | 0$ | 11 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 128,417,764$ | 128,417,764$ |
25 | Rangers | 8000 | 7000 | 4000 | 4000 | 2000 | 150 | 110 | 80 | 55 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 74,750,001$ | 22,750,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 11 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 96,816,517$ | 96,816,517$ |
26 | RedWings | 8000 | 6000 | 5000 | 4000 | 2000 | 135 | 105 | 75 | 60 | 210 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 84,648,001$ | 14,223,001$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 11 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 188,689,915$ | 188,689,915$ |
27 | Sabres | 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% | 3 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 91,725,000$ | 21,350,000$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 11 | 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% | 3 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 81,974,601$ | 22,850,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 11 | 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 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 80,772,500$ | 17,325,000$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 11 | 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% | 4 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 77,470,001$ | 18,600,000$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 11 | 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% | 2 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 76,453,000$ | 21,325,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 11 | 0$ | 0$ | 0$ | 0$ | -5,000,000$ | 85,000,000$ | 85,000,000$ | 6,193,993$ | 6,193,993$ |