| 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 65,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Avalanche | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 89,918,465$ | 88,793,466$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 125,646,478$ | 125,646,478$ |
| 2 | Blackhawks | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 71,739,430$ | 70,614,430$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 129,461,808$ | 129,461,808$ |
| 3 | Blue Jackets | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 83,715,689$ | 83,715,689$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 103,665,676$ | 103,665,676$ |
| 4 | Blues | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 90 | 67,626,678$ | 67,626,678$ | 4,438,910$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 98,538,808$ | 98,538,808$ |
| 5 | Bruins | 2000 | 4000 | 5000 | 6000 | 1000 | 100 | 80 | 60 | 40 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 40 | 78,129,650$ | 77,004,650$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 19,146,902$ | 19,146,902$ |
| 6 | Canadiens | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 45 | 72,455,804$ | 72,455,804$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 198,008,852$ | 198,008,852$ |
| 7 | Canucks | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 65 | 93,293,921$ | 87,909,912$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 194,195,142$ | 194,195,142$ |
| 8 | Capitals | 2000 | 4000 | 5000 | 6000 | 1000 | 175 | 120 | 90 | 49 | 275 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 77,621,608$ | 76,496,608$ | 2,250,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 109,219,465$ | 109,219,465$ |
| 9 | Devils | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 87,327,667$ | 87,327,667$ | -4,750,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 105,302,854$ | 105,302,854$ |
| 10 | Ducks | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 15 | 73,896,648$ | 72,771,648$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 137,672,012$ | 137,672,012$ |
| 11 | Flames | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 90 | 69,071,000$ | 69,071,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 40,226,185$ | 40,226,185$ |
| 12 | Flyers | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 95 | 75,751,439$ | 72,376,440$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 64,483,972$ | 64,483,972$ |
| 13 | Golden Knights | 2000 | 4000 | 5000 | 6000 | 1000 | 190 | 130 | 85 | 44 | 283 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 95 | 72,723,250$ | 72,723,250$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 103,131,285$ | 103,131,285$ |
| 14 | Hurricanes | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 135 | 85 | 45 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 75 | 80,397,542$ | 78,147,535$ | 2,368,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 97,468,078$ | 97,468,078$ |
| 15 | Islanders | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 85,206,668$ | 85,206,668$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 82,993,895$ | 82,993,895$ |
| 16 | Jets | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 75,856,966$ | 75,856,966$ | 3,350,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 146,052,769$ | 146,052,769$ |
| 17 | Kings | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 70 | 86,784,956$ | 85,659,956$ | 377,150$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 87,359,239$ | 87,359,239$ |
| 18 | Kraken | 2000 | 4000 | 5000 | 6000 | 1000 | 100 | 80 | 60 | 40 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 95 | 76,206,511$ | 70,045,512$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 68,617,616$ | 68,617,616$ |
| 19 | Lightning | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 69,410,379$ | 68,285,379$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 123,858,766$ | 123,858,766$ |
| 20 | Mammoth | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 88,903,263$ | 88,903,263$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 64,057,200$ | 64,057,200$ |
| 21 | Maple Leafs | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 95 | 86,344,280$ | 85,219,280$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 85,399,558$ | 85,399,558$ |
| 22 | Oilers | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 90 | 88,254,999$ | 88,254,999$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 88,827,774$ | 88,827,774$ |
| 23 | Panthers | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 50 | 71,026,342$ | 69,901,342$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 24,067,500$ | 24,067,500$ |
| 24 | Penguins | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 50 | 83,279,250$ | 81,719,252$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 18,018,980$ | 18,018,980$ |
| 25 | Predators | 2000 | 4000 | 5000 | 6000 | 1000 | 160 | 100 | 40 | 23 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 55 | 80,104,959$ | 76,729,960$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 25,787,540$ | 25,787,540$ |
| 26 | Rangers | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 65 | 69,626,645$ | 67,376,645$ | 2,803,125$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 51,933,640$ | 51,933,640$ |
| 27 | Red Wings | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 50 | 70,605,671$ | 69,480,672$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 32,559,852$ | 32,559,852$ |
| 28 | Sabres | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 76,851,750$ | 76,851,750$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 102,209,002$ | 102,209,002$ |
| 29 | Senators | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 70,894,450$ | 68,644,450$ | 4,750,000$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 81,575,167$ | 81,575,167$ |
| 30 | Sharks | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 89,883,681$ | 88,933,680$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 108,221,274$ | 108,221,274$ |
| 31 | Stars | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 95 | 73,411,499$ | 72,286,499$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 147,864,035$ | 147,864,035$ |
| 32 | Wild | 2000 | 4000 | 5000 | 6000 | 1000 | 195 | 140 | 90 | 49 | 295 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 80 | 84,439,849$ | 84,439,849$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 19,649,465$ | 19,649,465$ |