| 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 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 80,200,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Blackhawks | 3000 | 4000 | 5000 | 6000 | 2000 | 161 | 110 | 90 | 65 | 271 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 151 | 78,776,217$ | 78,776,218$ | 0$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 72,372,762$ | 72,372,762$ |
| 2 | BlueJackets | 3000 | 4000 | 5000 | 6000 | 2000 | 135 | 110 | 85 | 40 | 240 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 117 | 109,941,740$ | 109,941,742$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 126,017,307$ | 126,017,307$ |
| 3 | Blues | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 150 | 70,448,455$ | 70,448,455$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 124,713,308$ | 124,713,308$ |
| 4 | Bruins | 3000 | 4000 | 5000 | 6000 | 2000 | 170 | 110 | 90 | 60 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 164 | 93,746,342$ | 93,746,342$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 178,105,589$ | 178,105,589$ |
| 5 | Canadiens | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 85 | 60 | 270 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 178 | 76,300,492$ | 76,300,492$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 251,473,364$ | 251,473,364$ |
| 6 | Canucks | 3000 | 4000 | 5000 | 6000 | 2000 | 110 | 70 | 45 | 35 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 110 | 95,093,700$ | 95,093,701$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 27,593,750$ | 27,593,750$ |
| 7 | Capitals | 3750 | 5000 | 6250 | 7500 | 2500 | 137 | 94 | 74 | 49 | 246 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 123 | 72,858,484$ | 72,858,483$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 338,323,507$ | 338,323,507$ |
| 8 | Ducks | 3750 | 5000 | 6250 | 7500 | 2500 | 161 | 108 | 83 | 58 | 271 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 162 | 79,312,327$ | 79,312,327$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 471,302,247$ | 471,302,247$ |
| 9 | Flames | 3750 | 5000 | 6250 | 7500 | 2500 | 145 | 110 | 85 | 55 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 200 | 110,961,725$ | 110,961,726$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 363,863,368$ | 363,863,368$ |
| 10 | Flyers | 3300 | 4400 | 5500 | 6600 | 2200 | 148 | 85 | 60 | 38 | 270 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 145 | 101,304,337$ | 101,304,336$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 155,031,678$ | 155,031,678$ |
| 11 | GoldenKnights | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 75 | 50 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 185 | 105,124,931$ | 105,124,931$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 377,174,846$ | 377,174,846$ |
| 12 | Hurricanes | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 80 | 55 | 270 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 145 | 82,310,000$ | 82,310,002$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 335,525,502$ | 335,525,502$ |
| 13 | Islanders | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 107 | 89 | 58 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 142 | 83,263,567$ | 83,263,567$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 300,202,006$ | 300,202,006$ |
| 14 | Jets | 3750 | 5000 | 6250 | 7500 | 2500 | 96 | 65 | 50 | 21 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 118 | 81,737,587$ | 81,737,586$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 30,528,982$ | 30,528,982$ |
| 15 | Kraken | 3750 | 5000 | 6250 | 7500 | 2500 | 165 | 110 | 87 | 57 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 110 | 82,394,358$ | 82,394,358$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 94,574,616$ | 94,574,616$ |
| 16 | Lightning | 2700 | 3600 | 4500 | 5400 | 1800 | 170 | 110 | 90 | 65 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 127 | 88,820,069$ | 88,820,069$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 56,879,324$ | 56,879,324$ |
| 17 | Maple Leafs | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 85 | 60 | 270 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 200 | 105,765,498$ | 105,765,501$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 427,326,806$ | 427,326,806$ |
| 18 | Oilers | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 190 | 102,790,485$ | 102,790,485$ | 3,000,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 360,579,029$ | 360,579,029$ |
| 19 | Pantheres | 3750 | 5000 | 6250 | 7500 | 2500 | 150 | 90 | 70 | 55 | 270 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 200 | 109,381,421$ | 109,381,420$ | 704,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 236,136,647$ | 236,136,647$ |
| 20 | Pengouins | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 195 | 68,888,721$ | 68,888,721$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 629,060,710$ | 629,060,710$ |
| 21 | Predateurs | 3750 | 5000 | 6250 | 7500 | 2500 | 151 | 100 | 81 | 51 | 270 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 200 | 102,772,091$ | 102,772,089$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 313,050,762$ | 313,050,762$ |
| 22 | Rangers | 3750 | 5000 | 6250 | 7500 | 2500 | 100 | 65 | 45 | 18 | 195 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 200 | 69,711,709$ | 69,711,710$ | 0$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 284,138,022$ | 284,138,022$ |
| 23 | Red Wings | 3188 | 4250 | 5312 | 6375 | 2125 | 170 | 110 | 80 | 56 | 280 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21250 | 127 | 91,256,671$ | 91,256,670$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 228,083,910$ | 228,083,910$ |
| 24 | Sabres | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 110 | 95,287,286$ | 95,287,286$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 189,431,684$ | 189,431,684$ |
| 25 | Sharks | 3000 | 4000 | 5000 | 6000 | 2000 | 150 | 98 | 70 | 50 | 265 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 122 | 72,962,343$ | 72,962,344$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 155,500,182$ | 155,500,182$ |
| 26 | Stars | 3750 | 5000 | 6250 | 7500 | 2500 | 155 | 100 | 78 | 55 | 265 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 120 | 84,360,058$ | 84,360,060$ | 700,000$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 153,534,121$ | 153,534,121$ |
| 27 | Utah HC | 6500 | 5500 | 2500 | 4250 | 1250 | 105 | 31 | 30 | 28 | 205 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 118 | 64,061,356$ | 64,061,355$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 1,524,464$ | 1,524,464$ |
| 28 | Wild | 3750 | 5000 | 6250 | 7500 | 2500 | 150 | 100 | 85 | 50 | 270 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 197 | 82,239,744$ | 82,239,744$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -80,200,000$ | 108,500,000$ | 108,500,000$ | 290,017,969$ | 290,017,969$ |
Comets 
Firebirds
Phantoms 
Wild
Wolf Pack
Griffins
IceHogs
Rocket
Silver Knights
Thunderbirds