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 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 58,800,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 47 | 35 | 160 | 22006 | 16485 | 5962 | 9981 | 4000 | 91.69% | 82.43% | 74.53% | 62.38% | 100.00% | 37 | 14609 - 81.16% | 1,722,477$ | 6,889,908$ | 18000 | 100 | 79,020,416$ | 45,375,418$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 23,524,110$ | 23,524,110$ |
2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 27517 | 24957 | 10000 | 20000 | 4292 | 91.72% | 99.83% | 100.00% | 100.00% | 85.84% | 36 | 17353 - 96.41% | 1,745,541$ | 8,727,705$ | 18000 | 100 | 72,599,795$ | 33,141,795$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 62,970,039$ | 62,970,039$ |
3 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 80,733,333$ | 59,350,000$ | 5,175,000$ | 0$ | 0$ | 0$ | 21 | 2 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 41,281,676$ | 41,281,676$ |
4 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 64,075,667$ | 32,350,667$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 10,077,426$ | 10,077,426$ |
5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 145 | 69 | 50 | 39 | 197 | 21640 | 22467 | 8218 | 12710 | 4707 | 72.13% | 89.87% | 82.18% | 63.55% | 94.14% | 36 | 13948 - 77.49% | 1,943,524$ | 9,717,619$ | 18000 | 100 | 76,413,998$ | 49,366,498$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 54,752,244$ | 54,752,244$ |
6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 55 | 30 | 20 | 175 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 69,829,168$ | 51,537,501$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 19,965,716$ | 19,965,716$ |
7 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 42 | 25 | 195 | 10567 | 7866 | 3322 | 6811 | 1725 | 88.06% | 78.66% | 83.05% | 85.14% | 86.25% | 39 | 15146 - 84.14% | 1,678,853$ | 3,357,706$ | 18000 | 100 | 74,287,857$ | 39,528,334$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 7,551,460$ | 7,551,460$ |
8 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 17207 | 15000 | 6000 | 12000 | 2580 | 95.59% | 100.00% | 100.00% | 100.00% | 86.00% | 38 | 17596 - 97.75% | 1,781,394$ | 5,344,183$ | 18000 | 100 | 77,468,833$ | 51,650,976$ | -1,857,143$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 36,710,959$ | 36,710,959$ |
9 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 74,432,498$ | 47,540,832$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 25,695,331$ | 25,695,331$ |
10 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 16773 | 15000 | 6000 | 12000 | 2746 | 93.18% | 100.00% | 100.00% | 100.00% | 91.53% | 38 | 17506 - 97.26% | 1,776,328$ | 5,328,985$ | 18000 | 100 | 73,129,394$ | 36,625,834$ | 3,000,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 90,837,895$ | 90,837,895$ |
11 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 54 | 33 | 22 | 165 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 79,759,583$ | 28,051,250$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 23,663,855$ | 23,663,855$ |
12 | Golden Seals | 6000 | 5000 | 2000 | 4000 | 1000 | 60 | 35 | 16 | 10 | 100 | 42000 | 35000 | 14000 | 28000 | 7000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 18000 - 100.00% | 1,053,430$ | 7,374,010$ | 18000 | 100 | 77,235,833$ | 43,255,833$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 2,035,648$ | 2,035,648$ |
13 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 10381 | 10000 | 4000 | 8000 | 1766 | 86.51% | 100.00% | 100.00% | 100.00% | 88.30% | 39 | 17074 - 94.85% | 1,707,019$ | 3,414,037$ | 18000 | 100 | 73,690,833$ | 38,715,833$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 76,211,389$ | 76,211,389$ |
14 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 60 | 45 | 27 | 210 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 61,203,461$ | 39,180,777$ | 1,857,143$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 64,946,536$ | 64,946,536$ |
15 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 50 | 30 | 10 | 160 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 1,564,500$ | 4,693,500$ | 18000 | 100 | 80,168,476$ | 43,730,476$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 22,459,526$ | 22,459,526$ |
16 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 75 | 55 | 40 | 150 | 54000 | 40529 | 13983 | 25456 | 9000 | 100.00% | 90.06% | 77.68% | 70.71% | 100.00% | 32 | 15885 - 88.25% | 1,782,533$ | 16,042,800$ | 18000 | 100 | 77,642,333$ | 28,242,333$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 52,384,684$ | 52,384,684$ |
17 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 45 | 22 | 225 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 61,966,721$ | 38,123,887$ | 7,625,000$ | 0$ | 0$ | 0$ | 23 | 1 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 23,321,041$ | 23,321,041$ |
18 | Maroons | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 69,756,499$ | 46,981,499$ | 5,000,000$ | 0$ | 0$ | 0$ | 23 | 1 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 54,167,312$ | 54,167,312$ |
19 | Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 50 | 25 | 10 | 160 | 60000 | 50000 | 20000 | 40000 | 10000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 31 | 18000 - 100.00% | 1,460,200$ | 14,602,000$ | 18000 | 100 | 76,544,999$ | 50,291,666$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 61,274,115$ | 61,274,115$ |
20 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 65 | 38 | 23 | 190 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 75,672,500$ | 66,672,500$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | -5,272,286$ | -5,272,286$ |
21 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 40175 | 35000 | 14000 | 28000 | 6610 | 95.65% | 100.00% | 100.00% | 100.00% | 94.43% | 34 | 17684 - 98.24% | 1,807,051$ | 12,649,355$ | 18000 | 100 | 79,790,000$ | 43,640,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 44,775,855$ | 44,775,855$ |
22 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 60 | 35 | 20 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 72,769,166$ | 52,376,166$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 27,215,591$ | 27,215,591$ |
23 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 21068 | 20000 | 8000 | 16000 | 3521 | 87.78% | 100.00% | 100.00% | 100.00% | 88.03% | 37 | 17147 - 95.26% | 1,717,598$ | 6,870,390$ | 18000 | 100 | 76,106,666$ | 40,706,666$ | 2,000,000$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 50,120,206$ | 50,120,206$ |
24 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 70 | 45 | 25 | 200 | 18812 | 16804 | 6675 | 14624 | 3760 | 78.38% | 84.02% | 83.44% | 91.40% | 94.00% | 37 | 15169 - 84.27% | 1,807,257$ | 7,229,026$ | 18000 | 100 | 79,746,666$ | 64,354,999$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 8,151,750$ | 8,151,750$ |
25 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 62 | 55 | 30 | 186 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 69,155,000$ | 47,880,000$ | 3,737,500$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 37,591,617$ | 37,591,617$ |
26 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 55 | 33 | 18 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 69,894,167$ | 53,923,667$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 20,037,747$ | 20,037,747$ |
27 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 45994 | 40000 | 16000 | 32000 | 7593 | 95.82% | 100.00% | 100.00% | 100.00% | 94.91% | 33 | 17698 - 98.32% | 1,809,978$ | 14,479,820$ | 18000 | 100 | 79,556,429$ | 59,185,000$ | 400,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 56,268,489$ | 56,268,489$ |
28 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 75 | 45 | 30 | 220 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 59,885,833$ | 52,353,277$ | 4,000,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 12,165,928$ | 12,165,928$ |
29 | Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 65 | 45 | 35 | 125 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 76,641,665$ | 47,366,665$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 2,070,688$ | 2,070,688$ |
30 | Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 58196 | 50000 | 20000 | 40000 | 9462 | 96.99% | 100.00% | 100.00% | 100.00% | 94.62% | 31 | 17766 - 98.70% | 1,819,588$ | 18,195,880$ | 18000 | 100 | 81,576,795$ | 62,718,462$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 80,500,000$ | 80,500,000$ | 12,126,763$ | 12,126,763$ |