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 44,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
1 | Avalanche | 8000 | 4000 | 5000 | 2000 | 1000 | 120 | 75 | 55 | 40 | 225 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 150 | 68,100,000$ | 68,100,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 14,804,516$ | 14,804,516$ |
2 | Blackhawks | 8000 | 4000 | 5000 | 2000 | 1000 | 105 | 62 | 42 | 32 | 208 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 126 | 73,400,000$ | 73,400,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 37,642,009$ | 37,642,009$ |
3 | Blue Jackets | 8000 | 4000 | 5000 | 2000 | 1000 | 101 | 60 | 40 | 30 | 203 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 106 | 59,500,000$ | 59,500,000$ | 1,000,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 17,321,811$ | 17,321,811$ |
4 | Blues | 8000 | 4000 | 5000 | 2000 | 1000 | 102 | 60 | 42 | 31 | 205 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 121 | 71,700,000$ | 71,700,000$ | 805,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 45,101,538$ | 45,101,538$ |
5 | Bruins | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 41 | 31 | 205 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 125 | 76,300,000$ | 76,300,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 17,672,020$ | 17,672,020$ |
6 | Canadiens | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 59 | 40 | 30 | 202 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 111 | 55,200,000$ | 55,200,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 29,481,146$ | 29,481,146$ |
7 | Canucks | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 116 | 59,400,000$ | 59,400,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 11,972,773$ | 11,972,773$ |
8 | Capitals | 8000 | 4000 | 5000 | 2000 | 1000 | 102 | 62 | 41 | 31 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 116 | 62,200,000$ | 62,200,000$ | 3,000,000$ | 0$ | 0$ | 0$ | 16 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 13,138,807$ | 13,138,807$ |
9 | Coyotes | 8000 | 4000 | 5000 | 2000 | 1000 | 101 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 116 | 62,200,000$ | 62,200,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 38,771,096$ | 38,771,096$ |
10 | Devils | 8000 | 4000 | 5000 | 2000 | 1000 | 104 | 64 | 44 | 32 | 206 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 124 | 65,700,000$ | 65,700,000$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 48,378,802$ | 48,378,802$ |
11 | Ducks | 8000 | 4000 | 5000 | 2000 | 1000 | 110 | 65 | 45 | 35 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 111 | 50,600,000$ | 50,600,000$ | 6,700,000$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 25,519,374$ | 25,519,374$ |
12 | Flames | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 101 | 40,800,000$ | 40,800,000$ | 8,500,000$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 7,938,337$ | 7,938,337$ |
13 | Flyers | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 202 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 140 | 72,300,000$ | 72,300,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 26,955,034$ | 26,955,034$ |
14 | Golden Knights | 8000 | 4000 | 5000 | 2000 | 1000 | 105 | 60 | 45 | 30 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 122 | 68,300,000$ | 68,300,000$ | 735,000$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 20,774,874$ | 20,774,874$ |
15 | Hurricanes | 8000 | 4000 | 5000 | 2000 | 1000 | 96 | 56 | 41 | 29 | 195 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 39,700,000$ | 39,700,000$ | 9,950,000$ | 0$ | 0$ | 0$ | 16 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 47,439,821$ | 47,439,821$ |
16 | Islanders | 8000 | 4000 | 5000 | 2000 | 1000 | 105 | 63 | 44 | 31 | 206 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 110 | 39,200,000$ | 39,200,000$ | 7,900,000$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 23,136,507$ | 23,136,507$ |
17 | Jets | 8000 | 4000 | 5000 | 2000 | 1000 | 112 | 67 | 47 | 37 | 213 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 147 | 65,600,000$ | 65,600,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 48,389,711$ | 48,389,711$ |
18 | Kings | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 205 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 112 | 70,000,000$ | 70,000,000$ | 1,000,000$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 21,841,623$ | 21,841,623$ |
19 | Kraken | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 90 | 37,100,000$ | 37,100,000$ | 4,800,000$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 40,351,727$ | 40,351,727$ |
20 | Lightning | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 93 | 33,300,000$ | 33,300,000$ | 6,000,000$ | 0$ | 0$ | 0$ | 14 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 23,801,736$ | 23,801,736$ |
21 | Maple Leafs | 8000 | 4000 | 5000 | 2000 | 1000 | 101 | 60 | 40 | 30 | 203 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 123 | 68,300,000$ | 68,300,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 12,098,212$ | 12,098,212$ |
22 | Oilers | 8000 | 4000 | 5000 | 2000 | 1000 | 120 | 68 | 48 | 40 | 240 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 128 | 64,600,000$ | 64,600,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 23,075,155$ | 23,075,155$ |
23 | Panthers | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 129 | 74,100,000$ | 74,100,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 17,419,016$ | 17,419,016$ |
24 | Penguins | 8000 | 4000 | 5000 | 2000 | 1000 | 102 | 62 | 42 | 32 | 202 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 104 | 66,800,000$ | 66,800,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 10,000,000$ | 10,000,000$ |
25 | Predators | 8000 | 4000 | 5000 | 2000 | 1000 | 90 | 55 | 45 | 35 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 98 | 42,400,000$ | 42,400,000$ | 4,000,000$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 10,000,000$ | 10,000,000$ |
26 | Rangers | 8000 | 4000 | 5000 | 2000 | 1000 | 115 | 69 | 48 | 37 | 230 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 144 | 61,900,000$ | 61,900,000$ | 120,000$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 23,937,237$ | 23,937,237$ |
27 | Red Wings | 8000 | 4000 | 5000 | 2000 | 1000 | 99 | 43 | 41 | 29 | 196 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 114 | 43,100,000$ | 43,100,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 40,258,731$ | 40,258,731$ |
28 | Sabres | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 31 | 205 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 105 | 71,500,000$ | 71,500,000$ | 1,000,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 10,598,992$ | 10,598,992$ |
29 | Senators | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 35 | 30 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 107 | 49,400,000$ | 49,400,000$ | 7,300,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 31,655,445$ | 31,655,445$ |
30 | Sharks | 8000 | 4000 | 5000 | 2000 | 1000 | 115 | 63 | 44 | 31 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 142 | 67,100,000$ | 67,100,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 22,651,543$ | 22,651,543$ |
31 | Stars | 8000 | 4000 | 5000 | 2000 | 1000 | 102 | 62 | 39 | 30 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 108 | 64,500,000$ | 64,500,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 5,547,647$ | 5,547,647$ |
32 | Wild | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 90 | 28,200,000$ | 28,200,000$ | 13,825,000$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 9,810,092$ | 9,810,092$ |