| 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 79,400,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 | 18000 | 24000 | 30000 | 36000 | 12000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 20000 - 100.00% | 2,950,400$ | 17,702,400$ | 20000 | 141 | 101,744,502$ | 95,744,503$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 66,340,344$ | 66,340,344$ |
| 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 | 118 | 109,435,863$ | 109,435,865$ | -3,000,000$ | 0$ | 0$ | 0$ | 23 | 0 | 1,481,440$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 136,182,682$ | 136,182,682$ |
| 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 | 151 | 79,476,158$ | 79,476,158$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 139,665,964$ | 139,665,964$ |
| 4 | Bruins | 3000 | 4000 | 5000 | 6000 | 2000 | 170 | 110 | 90 | 60 | 285 | 9000 | 12000 | 15000 | 18000 | 6000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 20000 - 100.00% | 2,982,400$ | 8,947,200$ | 20000 | 160 | 112,139,758$ | 112,139,757$ | -5,000,000$ | 0$ | 0$ | 0$ | 23 | 0 | 6,672,480$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 190,346,214$ | 190,346,214$ |
| 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 | 183 | 94,430,232$ | 93,680,232$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 255,557,739$ | 255,557,739$ |
| 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 | 113 | 100,891,000$ | 100,891,001$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,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 | 125 | 96,549,734$ | 96,549,733$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,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 | 164 | 85,107,965$ | 85,107,965$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 488,015,622$ | 488,015,622$ |
| 9 | Flames | 3750 | 5000 | 6250 | 7500 | 2500 | 145 | 110 | 85 | 55 | 285 | 18750 | 25000 | 31250 | 37500 | 12500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 25000 - 100.00% | 3,520,000$ | 17,600,000$ | 25000 | 196 | 114,626,693$ | 114,626,694$ | -5,140,000$ | 0$ | 0$ | 0$ | 20 | 0 | 7,334,406$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 358,575,307$ | 358,575,307$ |
| 10 | Flyers | 3300 | 4400 | 5500 | 6600 | 2200 | 148 | 85 | 60 | 38 | 270 | 16500 | 22000 | 27500 | 33000 | 11000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 22000 - 100.00% | 2,607,616$ | 13,038,080$ | 22000 | 138 | 101,550,002$ | 101,028,562$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 159,773,133$ | 159,773,133$ |
| 11 | GoldenKnights | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 75 | 50 | 285 | 15000 | 20000 | 25000 | 30000 | 10000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 25000 - 100.00% | 3,512,000$ | 14,048,000$ | 25000 | 178 | 110,063,844$ | 110,063,844$ | -5,000,000$ | 0$ | 0$ | 0$ | 22 | 0 | 3,251,526$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 397,111,721$ | 397,111,721$ |
| 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 | 149 | 90,156,942$ | 90,156,944$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 346,205,970$ | 346,205,970$ |
| 13 | Islanders | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 107 | 89 | 58 | 285 | 7500 | 10000 | 12346 | 14842 | 4981 | 100.00% | 100.00% | 98.77% | 98.95% | 99.62% | 39 | 24835 - 99.34% | 3,615,498$ | 7,230,995$ | 25000 | 134 | 104,723,567$ | 104,723,567$ | 5,000,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 300,202,006$ | 300,202,006$ |
| 14 | Jets | 3750 | 5000 | 6250 | 7500 | 2500 | 96 | 65 | 50 | 21 | 200 | 7500 | 10000 | 12500 | 15000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 25000 - 100.00% | 2,118,400$ | 4,236,800$ | 25000 | 114 | 103,618,762$ | 103,618,761$ | -5,375,000$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 30,528,982$ | 30,528,982$ |
| 15 | Kings | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 7500 | 10000 | 12500 | 15000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 25000 - 100.00% | 3,776,000$ | 7,552,000$ | 25000 | 167 | 100,375,943$ | 100,375,943$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 236,003,184$ | 236,003,184$ |
| 16 | Lightning | 2700 | 3600 | 4500 | 5400 | 1800 | 170 | 110 | 90 | 65 | 285 | 5400 | 7200 | 9000 | 10800 | 3600 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 2,718,720$ | 5,437,440$ | 18000 | 124 | 110,277,784$ | 110,277,784$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 399,322$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 61,105,399$ | 61,105,399$ |
| 17 | Maple Leafs | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 85 | 60 | 270 | 7500 | 10000 | 12500 | 15000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 25000 - 100.00% | 3,592,000$ | 7,184,000$ | 25000 | 199 | 94,974,595$ | 94,974,598$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 436,645,073$ | 436,645,073$ |
| 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 | 194 | 103,984,235$ | 103,984,235$ | 3,000,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 364,647,779$ | 364,647,779$ |
| 19 | Pantheres | 3750 | 5000 | 6250 | 7500 | 2500 | 150 | 90 | 70 | 55 | 270 | 18750 | 25000 | 31250 | 37500 | 12500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 25000 - 100.00% | 3,248,000$ | 16,240,000$ | 25000 | 200 | 106,002,600$ | 106,002,599$ | 704,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 243,294,912$ | 243,294,912$ |
| 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 | 200 | 76,075,171$ | 76,075,171$ | 5,000,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 629,060,710$ | 629,060,710$ |
| 21 | Predateurs | 3750 | 5000 | 6250 | 7500 | 2500 | 151 | 100 | 81 | 51 | 270 | 11250 | 15000 | 18750 | 22500 | 7500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 25000 - 100.00% | 3,366,400$ | 10,099,200$ | 25000 | 200 | 112,982,754$ | 112,982,752$ | 3,000,000$ | 0$ | 0$ | 0$ | 21 | 0 | 2,200,170$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 327,901,699$ | 327,901,699$ |
| 22 | Rangers | 3750 | 5000 | 6250 | 7500 | 2500 | 100 | 65 | 45 | 18 | 195 | 26250 | 35000 | 43750 | 52500 | 17500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 25000 - 100.00% | 2,052,800$ | 14,369,600$ | 25000 | 200 | 98,855,885$ | 97,057,893$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 273,874,022$ | 273,874,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 | 131 | 96,729,996$ | 96,729,995$ | 5,140,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 228,756,610$ | 228,756,610$ |
| 24 | Senateurs | 3750 | 5000 | 6250 | 7500 | 2500 | 165 | 110 | 87 | 57 | 285 | 22500 | 29892 | 36834 | 44511 | 14894 | 100.00% | 99.64% | 98.22% | 98.91% | 99.29% | 35 | 24772 - 99.09% | 3,623,914$ | 21,743,482$ | 25000 | 126 | 93,437,512$ | 93,437,512$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 138,085,741$ | 138,085,741$ |
| 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 | 127 | 83,152,468$ | 83,152,469$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 171,368,307$ | 171,368,307$ |
| 26 | Stars | 3750 | 5000 | 6250 | 7500 | 2500 | 155 | 100 | 78 | 55 | 265 | 18553 | 24867 | 30763 | 35819 | 12466 | 98.95% | 99.47% | 98.44% | 95.52% | 99.73% | 36 | 24494 - 97.97% | 3,337,079$ | 16,685,394$ | 25000 | 114 | 98,607,108$ | 98,607,110$ | 1,500,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 164,356,996$ | 164,356,996$ |
| 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 | 110 | 74,167,343$ | 74,167,343$ | 5,375,000$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 1,524,464$ | 1,524,464$ |
| 28 | Wild | 3750 | 5000 | 6250 | 7500 | 2500 | 150 | 100 | 85 | 50 | 270 | 11250 | 15000 | 18750 | 22500 | 7500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 25000 - 100.00% | 3,384,000$ | 10,152,000$ | 25000 | 192 | 107,658,494$ | 107,658,494$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -79,400,000$ | 107,500,000$ | 107,500,000$ | 289,920,219$ | 289,920,219$ |