| 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 Salaries Cap | 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,500,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 42 | 30 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 67,474,000$ | 67,474,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 100,620,999$ | 100,620,999$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 125 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 52,845,168$ | 52,845,168$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 68,062,680$ | 68,062,680$ |
| 3 | Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 62 | 30 | 15 | 170 | 12000 | 9814 | 4000 | 8000 | 2000 | 100.00% | 98.14% | 100.00% | 100.00% | 100.00% | 41 | 17907 - 99.48% | 1,690,009$ | 3,380,017$ | 18000 | 100 | 82,282,000$ | 82,282,000$ | -7,000,000$ | 0$ | 0$ | 0$ | 21 | 0 | 1,267,085$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 94,965,069$ | 94,965,069$ |
| 4 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 91 | 55 | 40 | 18 | 170 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 70,245,998$ | 70,245,998$ | 475,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 240,322,276$ | 240,322,276$ |
| 5 | Bruins | 7000 | 6000 | 3000 | 5000 | 1000 | 69 | 49 | 39 | 29 | 179 | 14000 | 11718 | 5006 | 6691 | 2000 | 100.00% | 97.65% | 83.43% | 66.91% | 100.00% | 41 | 19708 - 89.58% | 1,704,154$ | 3,408,308$ | 22000 | 100 | 73,647,000$ | 73,647,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 11,984$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 83,687,722$ | 83,687,722$ |
| 6 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 58 | 39 | 27 | 135 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 71,177,000$ | 71,177,000$ | 8$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 63,231,976$ | 63,231,976$ |
| 7 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 55 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 61,647,666$ | 61,647,666$ | 0$ | 0$ | 0$ | 0$ | 35 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 18,843,902$ | 18,843,902$ |
| 8 | Capitals | 7000 | 6000 | 3500 | 4000 | 1500 | 70 | 45 | 32 | 22 | 130 | 14000 | 11989 | 4853 | 8000 | 2488 | 100.00% | 99.91% | 69.33% | 100.00% | 82.93% | 41 | 20665 - 93.93% | 1,619,810$ | 3,239,619$ | 22000 | 100 | 76,497,000$ | 76,497,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 103,550$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 110,506,487$ | 110,506,487$ |
| 9 | Coyotes | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 60 | 40 | 20 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 60,430,000$ | 60,430,000$ | 250,000$ | 0$ | 0$ | 0$ | 33 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 68,123,852$ | 68,123,852$ |
| 10 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 75,501,000$ | 75,501,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | -6,735,222$ | -6,735,222$ |
| 11 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 40 | 25 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 74,008,000$ | 74,008,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 108,977,067$ | 108,977,067$ |
| 12 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 60 | 45 | 30 | 120 | 12000 | 10000 | 3692 | 6480 | 2000 | 100.00% | 100.00% | 92.30% | 81.00% | 100.00% | 41 | 17086 - 94.92% | 1,654,303$ | 3,308,605$ | 18000 | 100 | 74,461,167$ | 74,461,167$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 10,510$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 48,897,990$ | 48,897,990$ |
| 13 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 40 | 30 | 20 | 300 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 53,938,667$ | 53,938,667$ | 8,650,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 10,904,810$ | 10,904,810$ |
| 14 | Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 64,941,000$ | 64,941,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 19,961,107$ | 19,961,107$ |
| 15 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 50 | 20 | 125 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 74,731,833$ | 74,731,833$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 95,632,003$ | 95,632,003$ |
| 16 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 99 | 79 | 59 | 39 | 149 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 51,060,332$ | 51,060,332$ | 3,125,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | -1,447,996$ | -1,447,996$ |
| 17 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 50 | 30 | 15 | 140 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 74,859,000$ | 74,859,000$ | -500,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | -2,331,278$ | -2,331,278$ |
| 18 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 60,831,666$ | 60,831,666$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 69,670,426$ | 69,670,426$ |
| 19 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 91 | 60 | 42 | 19 | 145 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 58,032,500$ | 58,032,500$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 105,864,421$ | 105,864,421$ |
| 20 | Oilers | 7000 | 6000 | 3500 | 4000 | 1500 | 85 | 60 | 40 | 20 | 120 | 13284 | 11187 | 4900 | 8000 | 2366 | 94.89% | 93.23% | 70.00% | 100.00% | 78.87% | 41 | 19869 - 90.31% | 1,818,009$ | 3,636,017$ | 22000 | 100 | 74,136,417$ | 74,136,417$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 130,881,020$ | 130,881,020$ |
| 21 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 102 | 62 | 37 | 22 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 59,526,168$ | 59,526,168$ | 0$ | 0$ | 0$ | 0$ | 30 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 51,404,781$ | 51,404,781$ |
| 22 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 65 | 35 | 25 | 225 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 70,495,791$ | 70,495,791$ | 0$ | 0$ | 0$ | 0$ | 38 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 20,128,158$ | 20,128,158$ |
| 23 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 72 | 65 | 35 | 25 | 170 | 12000 | 8589 | 4000 | 7669 | 2000 | 100.00% | 85.89% | 100.00% | 95.86% | 100.00% | 41 | 17129 - 95.16% | 1,560,038$ | 3,120,075$ | 18000 | 100 | 58,138,000$ | 58,138,000$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 17,910,944$ | 17,910,944$ |
| 24 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 102 | 55 | 40 | 25 | 205 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 59,104,000$ | 59,104,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 121,588,862$ | 121,588,862$ |
| 25 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 59,061,000$ | 59,061,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 137,782,298$ | 137,782,298$ |
| 26 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 118 | 95 | 70 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 69,250,667$ | 69,250,667$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 101,750,891$ | 101,750,891$ |
| 27 | Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 55 | 35 | 20 | 180 | 11944 | 10000 | 4000 | 8000 | 2000 | 99.53% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 17972 - 99.84% | 1,702,295$ | 3,404,590$ | 18000 | 100 | 68,229,500$ | 68,229,500$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 141,351,848$ | 141,351,848$ |
| 28 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 75 | 50 | 25 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 82,377,100$ | 82,377,100$ | -5,000,000$ | 0$ | 0$ | 0$ | 22 | 0 | 3,692,376$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 89,867,784$ | 89,867,784$ |
| 29 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 74,220,935$ | 74,220,935$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 100,194,124$ | 100,194,124$ |
| 30 | Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 24 | 212 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 75,234,333$ | 75,234,333$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 69,574,009$ | 69,574,009$ |
| 31 | Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 40 | 25 | 400 | 10574 | 10000 | 3896 | 7557 | 1200 | 88.12% | 100.00% | 97.40% | 94.46% | 60.00% | 41 | 16614 - 92.30% | 1,849,213$ | 3,698,426$ | 18000 | 100 | 76,326,334$ | 76,326,334$ | -1,000,000$ | 0$ | 0$ | 0$ | 21 | 0 | 98,832$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 180,380,404$ | 180,380,404$ |