| 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 70,900,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Avalanche | 6007 | 5000 | 2000 | 4000 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18007 | 115 | 108,457,857$ | 108,457,857$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 815,303,688$ | 815,303,688$ |
| 2 | Blackhawks | 6275 | 5000 | 4000 | 5000 | 2000 | 250 | 150 | 100 | 75 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22275 | 110 | 93,663,333$ | 93,663,333$ | -5,800,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 108,464,636$ | 108,464,636$ |
| 3 | Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1144 | 105 | 90 | 75 | 38 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18144 | 100 | 82,089,790$ | 82,089,790$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 935,636,656$ | 935,636,656$ |
| 4 | Blues | 6000 | 5000 | 3000 | 4000 | 1150 | 160 | 115 | 80 | 50 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19150 | 95 | 64,187,500$ | 64,187,500$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 810,386,429$ | 810,386,429$ |
| 5 | Bruins | 6000 | 5060 | 1615 | 3700 | 1190 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 17565 | 150 | 73,628,333$ | 73,628,333$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 452,378,681$ | 452,378,681$ |
| 6 | Canadiens | 6004 | 5010 | 3050 | 4400 | 2809 | 110 | 85 | 65 | 40 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21273 | 125 | 97,275,000$ | 97,275,000$ | -3,000,000$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 447,754,392$ | 447,754,392$ |
| 7 | Canucks | 6000 | 5000 | 2810 | 4000 | 1000 | 125 | 100 | 70 | 45 | 190 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18810 | 100 | 102,067,857$ | 102,067,857$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 14,580,099$ | 14,580,099$ |
| 8 | Capitals | 6000 | 5000 | 2277 | 4000 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18277 | 120 | 109,475,333$ | 109,475,333$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 818,916,881$ | 818,916,881$ |
| 9 | Devils | 6000 | 5000 | 2000 | 3625 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 17625 | 105 | 98,850,000$ | 98,850,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 77,903,810$ | 77,903,810$ |
| 10 | Ducks | 6000 | 5000 | 2000 | 3174 | 1000 | 200 | 150 | 100 | 65 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 17174 | 95 | 76,210,674$ | 76,210,674$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 26,985,826$ | 26,985,826$ |
| 11 | Flames | 6000 | 5289 | 3000 | 4000 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19289 | 110 | 80,168,333$ | 80,168,333$ | 5,800,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 4,853,607$ | 4,853,607$ |
| 12 | Flyers | 6000 | 5519 | 3000 | 4000 | 1000 | 140 | 112 | 75 | 55 | 235 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19519 | 105 | 66,845,833$ | 66,845,833$ | 3,000,000$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 896,942,555$ | 896,942,555$ |
| 13 | Golden Knights | 5368 | 5000 | 2000 | 4000 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 17368 | 115 | 92,396,898$ | 92,396,898$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 502,631,830$ | 502,631,830$ |
| 14 | Hurricanes | 6000 | 5000 | 2680 | 4000 | 1000 | 115 | 95 | 70 | 45 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18680 | 90 | 63,625,834$ | 63,625,834$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 1,172,866$ | 1,172,866$ |
| 15 | Islanders | 6000 | 5000 | 2000 | 1795 | 1000 | 100 | 85 | 70 | 50 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 15795 | 105 | 80,650,920$ | 80,650,920$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 925,918,353$ | 925,918,353$ |
| 16 | Jets | 6000 | 5000 | 2545 | 4000 | 1000 | 138 | 117 | 88 | 51 | 236 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18545 | 115 | 69,344,167$ | 69,344,167$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 929,340,700$ | 929,340,700$ |
| 17 | Kings | 9 | 5000 | 2118 | 4000 | 1000 | 120 | 71 | 70 | 40 | 225 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 12127 | 115 | 96,319,166$ | 96,319,166$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 980,333,585$ | 980,333,585$ |
| 18 | Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 67,772,381$ | 67,772,381$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 991,410,779$ | 991,410,779$ |
| 19 | Lightning | 6250 | 5250 | 3000 | 4000 | 1000 | 110 | 100 | 65 | 52 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19500 | 115 | 93,540,000$ | 93,540,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 900,185,733$ | 900,185,733$ |
| 20 | Mammoth | 6000 | 5000 | 2000 | 3799 | 1000 | 100 | 80 | 55 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 17799 | 70 | 95,325,143$ | 95,325,143$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 999,942,416$ | 999,942,416$ |
| 21 | Maple Leafs | 6000 | 5000 | 2046 | 4600 | 1173 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18819 | 145 | 85,659,524$ | 85,659,524$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 961,779,191$ | 961,779,191$ |
| 22 | Oilers | 5000 | 5000 | 2000 | 3838 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 16838 | 105 | 64,756,667$ | 64,756,667$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 908,696,754$ | 908,696,754$ |
| 23 | Panthers | 6250 | 5000 | 3000 | 4000 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19250 | 80 | 66,373,690$ | 66,373,690$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 931,273,856$ | 931,273,856$ |
| 24 | Penguins | 6000 | 5000 | 3387 | 3000 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18387 | 135 | 87,287,857$ | 87,287,857$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 17,967,271$ | 17,967,271$ |
| 25 | Predators | 6000 | 5000 | 2000 | 3113 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 17113 | 125 | 88,759,000$ | 88,759,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 447,069,655$ | 447,069,655$ |
| 26 | Rangers | 6000 | 5000 | 2000 | 4000 | 1200 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18200 | 115 | 70,578,334$ | 70,578,334$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 454,850,895$ | 454,850,895$ |
| 27 | Red Wings | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 115 | 93,382,857$ | 93,382,857$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 438,764,447$ | 438,764,447$ |
| 28 | Sabres | 6000 | 5000 | 2000 | 4000 | 1690 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18690 | 65 | 95,425,000$ | 95,425,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 456,635,225$ | 456,635,225$ |
| 29 | Senators | 6000 | 5000 | 3000 | 4153 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19153 | 70 | 84,432,500$ | 84,432,500$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 809,491,794$ | 809,491,794$ |
| 30 | Sharks | 6000 | 5000 | 2000 | 3562 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 17562 | 105 | 72,089,524$ | 72,089,524$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | -788,554$ | -788,554$ |
| 31 | Stars | 6000 | 5000 | 2532 | 4000 | 1000 | 125 | 100 | 75 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18532 | 85 | 93,345,084$ | 93,345,084$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 940,411,546$ | 940,411,546$ |
| 32 | Wild | 6000 | 5000 | 2000 | 4000 | 1064 | 125 | 100 | 76 | 48 | 206 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18064 | 120 | 91,465,122$ | 91,465,122$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,900,000$ | 95,500,000$ | 95,500,000$ | 501,431,841$ | 501,431,841$ |