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 63,000,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 | 16821 | 12652 | 4877 | 7966 | 3000 | 93.45% | 84.35% | 81.28% | 66.38% | 100.00% | 38 | 15105 - 83.92% | 1,766,032$ | 5,298,096$ | 18000 | 100 | 84,283,333$ | 62,991,668$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 9,888,463$ | 9,888,463$ |
2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 52809 | 45000 | 18000 | 36000 | 8490 | 97.79% | 100.00% | 100.00% | 100.00% | 94.33% | 32 | 17811 - 98.95% | 1,825,896$ | 16,433,061$ | 18000 | 100 | 77,780,128$ | 57,755,128$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 68,795,297$ | 68,795,297$ |
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 | 75,275,833$ | 51,060,833$ | 1,675,000$ | 0$ | 0$ | 0$ | 23 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 40,699,712$ | 40,699,712$ |
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 | 70,721,666$ | 50,764,999$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 5,845,717$ | 5,845,717$ |
5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 165 | 99 | 79 | 39 | 224 | 55015 | 47667 | 16289 | 36331 | 11246 | 76.41% | 79.45% | 67.87% | 75.69% | 93.72% | 29 | 13879 - 77.11% | 2,361,570$ | 28,338,834$ | 18000 | 100 | 79,633,831$ | 43,542,808$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 64,579,665$ | 64,579,665$ |
6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 55 | 30 | 20 | 175 | 72000 | 60000 | 24000 | 48000 | 12000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 29 | 18000 - 100.00% | 1,728,400$ | 20,740,800$ | 18000 | 100 | 83,319,001$ | 72,352,334$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 28,608,772$ | 28,608,772$ |
7 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 42 | 25 | 195 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 81,655,773$ | 76,489,107$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 16,279,431$ | 16,279,431$ |
8 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 46369 | 40000 | 16000 | 32000 | 7607 | 96.60% | 100.00% | 100.00% | 100.00% | 95.09% | 33 | 17747 - 98.59% | 1,817,483$ | 14,539,867$ | 18000 | 100 | 80,747,083$ | 54,497,083$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 35,964,791$ | 35,964,791$ |
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 | 76,414,998$ | 48,098,332$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 17,287,429$ | 17,287,429$ |
10 | Flames | 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 | 83,372,727$ | 43,294,167$ | 0$ | 0$ | 0$ | 0$ | 20 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 74,419,777$ | 74,419,777$ |
11 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 54 | 33 | 22 | 165 | 24000 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 1,726,910$ | 6,907,640$ | 18000 | 100 | 81,687,083$ | 37,512,083$ | 275,000$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 18,852,675$ | 18,852,675$ |
12 | Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 65 | 45 | 35 | 125 | 24000 | 19469 | 6654 | 10881 | 4000 | 100.00% | 97.35% | 83.18% | 68.01% | 100.00% | 37 | 16251 - 90.28% | 1,581,542$ | 6,326,167$ | 18000 | 100 | 82,816,666$ | 70,691,666$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 16,527,807$ | 16,527,807$ |
13 | Golden Seals | 6000 | 5000 | 2000 | 4000 | 1000 | 60 | 35 | 16 | 10 | 100 | 36000 | 30000 | 12000 | 24000 | 6000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 18000 - 100.00% | 1,053,430$ | 6,320,580$ | 18000 | 100 | 79,761,666$ | 68,061,666$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 33,524,227$ | 33,524,227$ |
14 | Islanders | 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 | 77,414,999$ | 57,398,749$ | 1,000,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 63,171,189$ | 63,171,189$ |
15 | 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 | 69,649,642$ | 68,621,253$ | 1,857,143$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 62,334,730$ | 62,334,730$ |
16 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 50 | 30 | 10 | 160 | 30000 | 25000 | 10000 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18000 - 100.00% | 1,564,500$ | 7,822,500$ | 18000 | 100 | 83,745,143$ | 62,732,143$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 11,055,393$ | 11,055,393$ |
17 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 75 | 55 | 40 | 150 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 80,272,333$ | 43,122,333$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 36,402,748$ | 36,402,748$ |
18 | 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 | 75,627,555$ | 47,934,721$ | 4,500,000$ | 0$ | 0$ | 0$ | 20 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 18,886,978$ | 18,886,978$ |
19 | Maroons | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 11167 | 9995 | 4000 | 7991 | 1713 | 93.06% | 99.95% | 100.00% | 99.89% | 85.65% | 39 | 17433 - 96.85% | 1,757,321$ | 3,514,642$ | 18000 | 100 | 77,176,424$ | 62,181,424$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 47,372,953$ | 47,372,953$ |
20 | Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 50 | 25 | 10 | 160 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 76,859,000$ | 44,350,667$ | 2,850,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 52,338,915$ | 52,338,915$ |
21 | 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 | 83,050,833$ | 69,150,833$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 12,206,239$ | 12,206,239$ |
22 | Panthers | 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,286,333$ | 54,786,333$ | 4,250,000$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 41,546,950$ | 41,546,950$ |
23 | 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 | 81,245,665$ | 70,995,665$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 13,293,095$ | 13,293,095$ |
24 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 10633 | 10000 | 4000 | 8000 | 1787 | 88.61% | 100.00% | 100.00% | 100.00% | 89.35% | 39 | 17210 - 95.61% | 1,728,922$ | 3,457,843$ | 18000 | 100 | 81,398,333$ | 77,251,666$ | 0$ | 0$ | 0$ | 0$ | 23 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 40,837,154$ | 40,837,154$ |
25 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 130 | 85 | 50 | 25 | 250 | 13263 | 11483 | 4610 | 10552 | 2205 | 73.68% | 76.55% | 76.83% | 87.93% | 73.50% | 38 | 14038 - 77.99% | 1,860,412$ | 5,581,235$ | 18000 | 100 | 81,858,397$ | 65,241,730$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 30,192,844$ | 30,192,844$ |
26 | 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 | 75,889,522$ | 65,764,522$ | 2,800,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 27,784,422$ | 27,784,422$ |
27 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 55 | 33 | 18 | 180 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 1,688,170$ | 3,376,340$ | 18000 | 100 | 75,925,000$ | 61,892,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 14,905,698$ | 14,905,698$ |
28 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 46849 | 40000 | 16000 | 32000 | 7361 | 97.60% | 100.00% | 100.00% | 100.00% | 92.01% | 33 | 17776 - 98.76% | 1,817,260$ | 14,538,079$ | 18000 | 100 | 82,779,762$ | 77,779,762$ | 400,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 53,863,228$ | 53,863,228$ |
29 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 75 | 45 | 30 | 220 | 25884 | 21557 | 8994 | 15398 | 4260 | 86.28% | 86.23% | 89.94% | 76.99% | 85.20% | 36 | 15219 - 84.55% | 1,906,397$ | 9,531,985$ | 18000 | 100 | 81,519,165$ | 65,588,276$ | 3,125,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 33,168,159$ | 33,168,159$ |
30 | Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 21652 | 20000 | 8000 | 16000 | 3671 | 90.22% | 100.00% | 100.00% | 100.00% | 91.78% | 37 | 17331 - 96.28% | 1,750,527$ | 7,002,106$ | 18000 | 100 | 84,109,993$ | 73,034,993$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -63,000,000$ | 85,216,667$ | 85,216,667$ | 31,974,108$ | 31,974,108$ |