| 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 56,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | ANAHEIM Ducks | 6000 | 5000 | 2000 | 5000 | 1000 | 195 | 190 | 185 | 180 | 225 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 65,644,286$ | 65,644,286$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 177,768,640$ | 177,768,640$ |
| 2 | ARIZONA Coyotes | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 55 | 45 | 30 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 71,291,667$ | 71,291,667$ | 0$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 168,068,105$ | 168,068,105$ |
| 3 | BOSTON Bruins | 6000 | 5000 | 2000 | 5000 | 1000 | 95 | 70 | 55 | 40 | 190 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 60,925,000$ | 60,925,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 82,381,242$ | 82,381,242$ |
| 4 | CALGARY Flames | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 57 | 34 | 19 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 94,200,000$ | 94,200,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 29,148,171$ | 29,148,171$ |
| 5 | CHICAGO Blackhawks | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 68 | 42 | 27 | 210 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 73,856,666$ | 73,856,666$ | 0$ | 0$ | 0$ | 0$ | 32 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 86,005,311$ | 86,005,311$ |
| 6 | COLORADO Avalanche | 6000 | 5000 | 2000 | 5000 | 1000 | 175 | 170 | 165 | 125 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 85,145,000$ | 85,145,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 72,863,367$ | 72,863,367$ |
| 7 | COLUMBUS Blue Jackets | 6000 | 5000 | 2000 | 5000 | 1000 | 195 | 190 | 185 | 180 | 225 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 76,015,000$ | 76,015,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 200,124,571$ | 200,124,571$ |
| 8 | DETROIT Red Wings | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 60 | 40 | 34 | 210 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 84,695,000$ | 84,695,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 99,128,140$ | 99,128,140$ |
| 9 | EDMONTON Oilers | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 105 | 97 | 80 | 220 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 89,345,000$ | 89,345,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 90,553,582$ | 90,553,582$ |
| 10 | MINNESOTA Wild | 6000 | 5000 | 2000 | 5000 | 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$ | 19000 | 100 | 71,760,000$ | 71,760,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 28,150,673$ | 28,150,673$ |
| 11 | MONTREAL Canadiens | 6000 | 5000 | 2000 | 5000 | 1000 | 96 | 69 | 49 | 36 | 193 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 82,490,000$ | 82,490,000$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 75,923,087$ | 75,923,087$ |
| 12 | NASHVILLE Predators | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 50 | 32 | 25 | 187 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 76,885,000$ | 76,885,000$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 28,229,533$ | 28,229,533$ |
| 13 | NEW YORK Islanders | 6000 | 5000 | 2000 | 5000 | 1000 | 150 | 135 | 120 | 100 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 84,470,000$ | 84,470,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 125,237,404$ | 125,237,404$ |
| 14 | NEW YORK Rangers | 6000 | 5000 | 2000 | 5000 | 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$ | 19000 | 100 | 79,565,000$ | 79,565,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 35,463,078$ | 35,463,078$ |
| 15 | OTTAWA Senators | 6000 | 5000 | 2000 | 5000 | 1000 | 95 | 55 | 35 | 25 | 190 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 71,000,000$ | 71,000,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 2,372,242$ | 2,372,242$ |
| 16 | PHILADELPHIA Flyers | 6000 | 5000 | 2000 | 5000 | 1000 | 225 | 220 | 215 | 210 | 280 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 84,855,000$ | 84,855,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 85,789,660$ | 85,789,660$ |
| 17 | PITTSBURGH Penguins | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 56 | 31 | 16 | 194 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 52,115,000$ | 52,115,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 51,302,002$ | 51,302,002$ |
| 18 | QUEBEC Nordiques | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 63 | 37 | 33 | 240 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 70,955,000$ | 70,955,000$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 47,045,979$ | 47,045,979$ |
| 19 | SEATTLE Totems | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 56 | 33 | 27 | 195 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 90,125,000$ | 89,700,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 26,363,207$ | 26,363,207$ |
| 20 | ST-LOUIS Blues | 6000 | 5000 | 2000 | 5000 | 1000 | 140 | 120 | 95 | 70 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 90,075,000$ | 90,075,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 66,664,348$ | 66,664,348$ |
| 21 | TAMPA BAY Lightning | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 70 | 55 | 40 | 190 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 53,485,000$ | 53,485,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 63,391,780$ | 63,391,780$ |
| 22 | TORONTO Maple Leafs | 6000 | 5000 | 2000 | 5000 | 1000 | 115 | 95 | 80 | 65 | 205 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 79,345,000$ | 79,345,000$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 128,802,691$ | 128,802,691$ |
| 23 | VANCOUVER Canucks | 6000 | 5000 | 2000 | 5000 | 1000 | 120 | 75 | 60 | 40 | 210 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 85,795,000$ | 85,795,000$ | 0$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 85,792,689$ | 85,792,689$ |
| 24 | VEGAS Golden Knights | 6000 | 5000 | 2000 | 5000 | 1000 | 215 | 210 | 205 | 200 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 58,750,000$ | 58,325,000$ | 0$ | 0$ | 0$ | 0$ | 34 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 125,486,186$ | 125,486,186$ |
| 25 | WASHINGTON Capitals | 6000 | 5000 | 2000 | 5000 | 1000 | 96 | 84 | 53 | 45 | 210 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 89,966,000$ | 89,966,000$ | 0$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 41,844,734$ | 41,844,734$ |
| 26 | WINNIPEG Jets | 6000 | 5000 | 2000 | 5000 | 1000 | 145 | 110 | 90 | 89 | 275 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 83,457,858$ | 83,457,858$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -56,000,000$ | 89,500,000$ | 89,500,000$ | 63,855,200$ | 63,855,200$ |