| 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 | 93000 | 124000 | 155000 | 185742 | 62000 | 100.00% | 100.00% | 100.00% | 99.86% | 100.00% | 10 | 19992 - 99.96% | 2,725,006$ | 84,475,174$ | 20000 | 141 | 100,869,502$ | 100,869,503$ | 0$ | 76,348,864$ | 813,464$ | 73,357,942$ | 22 | 1 | 0$ | 27,250,056$ | 33 | 839,351$ | 27,698,583$ | 28,575,030$ | 100,202,254$ | 20,802,254$ | 107,500,000$ | 7,297,746$ | 46,374,659$ | 46,008,835$ |
| 2 | BlueJackets | 3000 | 4000 | 5000 | 6000 | 2000 | 135 | 110 | 85 | 40 | 240 | 93000 | 121974 | 150943 | 186000 | 62000 | 100.00% | 98.37% | 97.38% | 100.00% | 100.00% | 10 | 19804 - 99.02% | 2,523,759$ | 78,236,536$ | 20000 | 118 | 108,235,863$ | 108,235,865$ | -3,000,000$ | 82,726,828$ | 872,870$ | 79,791,350$ | 22 | 0 | 1,424,184$ | 25,237,592$ | 33 | 905,128$ | 29,869,224$ | 30,747,486$ | 105,596,060$ | 26,196,060$ | 107,500,000$ | 1,903,940$ | 138,603,190$ | 134,186,768$ |
| 3 | Blues | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 118346 | 158098 | 188102 | 211490 | 78176 | 98.62% | 98.81% | 94.05% | 88.12% | 97.72% | 9 | 23569 - 94.28% | 3,618,632$ | 115,796,210$ | 25000 | 151 | 90,576,158$ | 90,576,158$ | 0$ | 68,665,287$ | 730,453$ | 66,657,460$ | 22 | 0 | 0$ | 32,567,684$ | 33 | 742,550$ | 24,504,150$ | 25,220,250$ | 90,762,409$ | 11,362,409$ | 107,500,000$ | 16,737,591$ | 128,916,334$ | 137,130,413$ |
| 4 | Bruins | 3000 | 4000 | 5000 | 6000 | 2000 | 170 | 110 | 90 | 60 | 285 | 93000 | 124000 | 155000 | 186000 | 62000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 10 | 20000 - 100.00% | 2,982,400$ | 92,454,400$ | 20000 | 160 | 111,339,758$ | 111,339,757$ | -5,000,000$ | 85,965,425$ | 897,901$ | 81,708,991$ | 22 | 0 | 4,862,130$ | 29,824,000$ | 33 | 944,675$ | 31,174,275$ | 31,797,579$ | 106,339,724$ | 26,939,724$ | 107,500,000$ | 1,160,276$ | 184,105,075$ | 183,216,659$ |
| 5 | Canadiens | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 85 | 60 | 270 | 112500 | 150000 | 187500 | 225000 | 75000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 11 | 25000 - 100.00% | 3,592,000$ | 107,760,000$ | 25000 | 183 | 94,430,232$ | 93,680,232$ | 0$ | 72,135,286$ | 755,486$ | 66,667,949$ | 25 | 0 | 0$ | 39,512,000$ | 33 | 815,566$ | 26,913,678$ | 27,843,321$ | 91,598,987$ | 12,198,987$ | 107,500,000$ | 15,901,013$ | 242,588,385$ | 255,322,291$ |
| 6 | Canucks | 3000 | 4000 | 5000 | 6000 | 2000 | 110 | 70 | 45 | 35 | 210 | 93000 | 124000 | 155000 | 186000 | 62000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 10 | 20000 - 100.00% | 1,875,200$ | 58,131,200$ | 20000 | 113 | 100,891,000$ | 100,891,001$ | 0$ | 73,813,652$ | 813,637$ | 72,345,913$ | 23 | 0 | 0$ | 18,752,000$ | 33 | 829,766$ | 27,382,278$ | 27,934,665$ | 99,195,934$ | 19,795,934$ | 107,500,000$ | 8,304,066$ | 35,818,850$ | 27,574,116$ |
| 7 | Capitals | 3750 | 5000 | 6250 | 7500 | 2500 | 137 | 94 | 74 | 49 | 246 | 116250 | 155000 | 193619 | 232435 | 77500 | 100.00% | 100.00% | 99.93% | 99.97% | 100.00% | 10 | 24994 - 99.97% | 3,108,268$ | 96,356,314$ | 25000 | 125 | 99,001,674$ | 99,001,673$ | 0$ | 73,036,560$ | 798,401$ | 71,170,878$ | 22 | 0 | 0$ | 31,082,682$ | 33 | 814,530$ | 26,879,490$ | 27,581,367$ | 97,518,111$ | 18,118,111$ | 107,500,000$ | 9,981,889$ | 333,477,913$ | 337,821,161$ |
| 8 | Ducks | 3750 | 5000 | 6250 | 7500 | 2500 | 161 | 108 | 83 | 58 | 271 | 116250 | 154939 | 193282 | 230587 | 77500 | 100.00% | 99.96% | 99.76% | 99.18% | 100.00% | 10 | 24921 - 99.68% | 3,545,543$ | 109,911,825$ | 25000 | 164 | 85,107,965$ | 85,107,965$ | 0$ | 63,023,425$ | 686,355$ | 60,937,314$ | 21 | 0 | 0$ | 35,455,427$ | 33 | 705,709$ | 23,288,397$ | 24,088,944$ | 83,587,029$ | 4,187,029$ | 107,500,000$ | 23,912,971$ | 475,048,773$ | 487,391,688$ |
| 9 | Flames | 3750 | 5000 | 6250 | 7500 | 2500 | 145 | 110 | 85 | 55 | 285 | 120000 | 160000 | 200000 | 240000 | 80000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 9 | 25000 - 100.00% | 3,520,000$ | 112,640,000$ | 25000 | 196 | 114,626,693$ | 114,626,694$ | -5,140,000$ | 84,764,113$ | 924,409$ | 81,094,723$ | 20 | 0 | 3,633,594$ | 31,680,000$ | 33 | 964,731$ | 31,836,123$ | 32,663,235$ | 106,460,220$ | 27,060,220$ | 107,500,000$ | 1,039,780$ | 344,023,086$ | 344,017,699$ |
| 10 | Flyers | 3300 | 4400 | 5500 | 6600 | 2200 | 148 | 85 | 60 | 38 | 270 | 102300 | 136400 | 170500 | 204600 | 68200 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 10 | 22000 - 100.00% | 2,607,616$ | 80,836,096$ | 22000 | 138 | 95,550,002$ | 95,550,000$ | 0$ | 75,703,785$ | 770,565$ | 72,938,135$ | 21 | 0 | 0$ | 26,076,160$ | 33 | 796,371$ | 26,280,243$ | 27,111,414$ | 98,366,780$ | 18,966,780$ | 107,500,000$ | 9,133,220$ | 147,713,712$ | 147,637,187$ |
| 11 | GoldenKnights | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 75 | 50 | 285 | 116250 | 155000 | 193750 | 232500 | 77500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 10 | 25000 - 100.00% | 3,512,000$ | 108,872,000$ | 25000 | 178 | 108,604,644$ | 108,604,644$ | -5,000,000$ | 84,662,392$ | 875,844$ | 80,479,311$ | 21 | 0 | 2,402,770$ | 35,120,000$ | 33 | 921,812$ | 30,419,796$ | 30,998,484$ | 104,382,163$ | 24,982,163$ | 107,500,000$ | 3,117,837$ | 378,867,212$ | 383,880,186$ |
| 12 | Hurricanes | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 80 | 55 | 270 | 115831 | 151134 | 191018 | 228238 | 77006 | 99.64% | 97.51% | 98.59% | 98.17% | 99.36% | 10 | 24620 - 98.48% | 3,459,462$ | 107,243,327$ | 25000 | 149 | 92,978,742$ | 89,885,407$ | 0$ | 72,069,335$ | 724,882$ | 67,842,855$ | 20 | 2 | 0$ | 34,594,622$ | 33 | 794,183$ | 26,208,039$ | 26,845,962$ | 91,763,961$ | 12,363,961$ | 107,500,000$ | 15,736,039$ | 336,970,432$ | 345,695,784$ |
| 13 | Islanders | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 107 | 89 | 58 | 285 | 110359 | 144109 | 160011 | 200623 | 68615 | 94.93% | 92.97% | 82.59% | 86.29% | 88.54% | 10 | 22055 - 88.22% | 3,241,682$ | 100,492,148$ | 25000 | 134 | 100,717,804$ | 100,717,804$ | 5,000,000$ | 74,345,357$ | 812,240$ | 71,709,222$ | 25 | 0 | 0$ | 32,416,822$ | 33 | 836,434$ | 27,602,322$ | 28,447,452$ | 103,513,142$ | 24,113,142$ | 107,500,000$ | 3,986,858$ | 288,351,397$ | 293,286,203$ |
| 14 | Jets | 3750 | 5000 | 6250 | 7500 | 2500 | 96 | 65 | 50 | 21 | 200 | 116250 | 155000 | 193598 | 232500 | 76842 | 100.00% | 100.00% | 99.92% | 100.00% | 99.15% | 10 | 24974 - 99.90% | 2,112,652$ | 65,492,224$ | 25000 | 114 | 105,415,075$ | 105,415,074$ | -5,375,000$ | 80,333,460$ | 850,122$ | 76,446,332$ | 22 | 0 | 0$ | 21,126,524$ | 33 | 890,444$ | 29,384,652$ | 29,849,886$ | 99,125,358$ | 19,725,358$ | 107,500,000$ | 8,374,642$ | 33,983,032$ | 26,227,377$ |
| 15 | Kings | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 116250 | 155000 | 193719 | 228790 | 77500 | 100.00% | 100.00% | 99.98% | 98.40% | 100.00% | 10 | 24879 - 99.52% | 3,764,637$ | 116,703,757$ | 25000 | 167 | 100,375,943$ | 100,375,943$ | 0$ | 77,857,331$ | 809,483$ | 73,674,244$ | 21 | 0 | 0$ | 37,646,373$ | 33 | 855,451$ | 28,229,883$ | 28,984,857$ | 100,387,183$ | 20,987,183$ | 107,500,000$ | 7,112,817$ | 218,329,821$ | 227,894,013$ |
| 16 | Lightning | 2700 | 3600 | 4500 | 5400 | 1800 | 170 | 110 | 90 | 65 | 285 | 86400 | 115200 | 143495 | 169610 | 57600 | 100.00% | 100.00% | 99.65% | 98.15% | 100.00% | 9 | 17885 - 99.36% | 2,708,608$ | 86,675,454$ | 18000 | 124 | 103,777,784$ | 103,777,784$ | 0$ | 77,660,063$ | 836,918$ | 73,221,043$ | 23 | 0 | 0$ | 24,377,471$ | 33 | 877,240$ | 28,948,920$ | 29,582,718$ | 100,839,337$ | 21,439,337$ | 107,500,000$ | 6,660,663$ | 60,333,244$ | 56,005,696$ |
| 17 | Maple Leafs | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 85 | 60 | 270 | 116250 | 155000 | 193750 | 232500 | 77500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 10 | 25000 - 100.00% | 3,592,000$ | 111,352,000$ | 25000 | 199 | 94,974,595$ | 94,974,598$ | 0$ | 72,157,297$ | 765,924$ | 69,591,889$ | 23 | 0 | 0$ | 35,920,000$ | 33 | 790,118$ | 26,073,894$ | 26,931,564$ | 94,867,381$ | 15,467,381$ | 107,500,000$ | 12,632,619$ | 418,674,544$ | 428,629,240$ |
| 18 | Oilers | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 116250 | 155000 | 193750 | 232151 | 77500 | 100.00% | 100.00% | 100.00% | 99.85% | 100.00% | 10 | 24989 - 99.95% | 3,775,063$ | 117,026,963$ | 25000 | 194 | 102,884,235$ | 102,884,235$ | 3,000,000$ | 79,768,480$ | 829,712$ | 75,256,399$ | 23 | 0 | 0$ | 37,750,633$ | 33 | 874,066$ | 28,844,178$ | 29,798,538$ | 105,636,895$ | 26,236,895$ | 107,500,000$ | 1,863,105$ | 355,738,962$ | 364,657,287$ |
| 19 | Pantheres | 3750 | 5000 | 6250 | 7500 | 2500 | 150 | 90 | 70 | 55 | 270 | 116250 | 155000 | 193750 | 232500 | 77500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 10 | 25000 - 100.00% | 3,248,000$ | 100,688,000$ | 25000 | 200 | 106,002,600$ | 106,002,599$ | 704,000$ | 82,130,538$ | 854,860$ | 77,580,538$ | 23 | 0 | 0$ | 32,480,000$ | 33 | 904,860$ | 29,860,380$ | 30,499,887$ | 106,494,918$ | 27,094,918$ | 107,500,000$ | 1,005,082$ | 224,102,152$ | 227,016,378$ |
| 20 | Pengouins | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 112500 | 150000 | 187500 | 225000 | 75000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 11 | 25000 - 100.00% | 3,776,000$ | 113,280,000$ | 25000 | 200 | 77,457,571$ | 77,457,571$ | 5,000,000$ | 60,874,807$ | 624,658$ | 57,141,314$ | 22 | 0 | 0$ | 41,536,000$ | 33 | 662,561$ | 21,864,513$ | 22,590,414$ | 82,755,028$ | 3,355,028$ | 107,500,000$ | 24,744,972$ | 608,370,270$ | 628,363,120$ |
| 21 | Predateurs | 3750 | 5000 | 6250 | 7500 | 2500 | 151 | 100 | 81 | 51 | 270 | 116250 | 155000 | 193750 | 232500 | 77500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 10 | 25000 - 100.00% | 3,366,400$ | 104,358,400$ | 25000 | 200 | 106,580,814$ | 96,943,312$ | 3,000,000$ | 79,072,250$ | 781,801$ | 74,861,952$ | 20 | 1 | 0$ | 33,664,000$ | 33 | 892,587$ | 29,455,371$ | 30,075,606$ | 103,661,385$ | 24,261,385$ | 107,500,000$ | 3,838,615$ | 316,897,429$ | 321,429,778$ |
| 22 | Rangers | 3750 | 5000 | 6250 | 7500 | 2500 | 100 | 65 | 45 | 18 | 195 | 116250 | 155000 | 193750 | 232500 | 77500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 10 | 25000 - 100.00% | 2,052,800$ | 63,636,800$ | 25000 | 200 | 97,605,885$ | 97,605,886$ | 0$ | 75,441,789$ | 787,144$ | 71,233,334$ | 21 | 0 | 0$ | 20,528,000$ | 33 | 830,289$ | 27,399,537$ | 28,458,243$ | 97,209,086$ | 17,809,086$ | 107,500,000$ | 10,290,914$ | 266,439,075$ | 259,460,466$ |
| 23 | Red Wings | 3188 | 4250 | 5312 | 6375 | 2125 | 170 | 110 | 80 | 56 | 280 | 98210 | 131381 | 164408 | 196555 | 65654 | 99.37% | 99.72% | 99.84% | 99.46% | 99.66% | 10 | 21168 - 99.61% | 3,041,967$ | 94,300,982$ | 21250 | 131 | 100,679,996$ | 98,653,995$ | 5,140,000$ | 78,463,774$ | 795,597$ | 74,045,376$ | 23 | 1 | 0$ | 30,419,672$ | 33 | 856,290$ | 28,257,570$ | 28,779,366$ | 105,440,077$ | 26,040,077$ | 107,500,000$ | 2,059,923$ | 225,352,645$ | 228,065,795$ |
| 24 | Senateurs | 3750 | 5000 | 6250 | 7500 | 2500 | 165 | 110 | 87 | 57 | 285 | 104303 | 133129 | 161803 | 202896 | 68077 | 89.72% | 85.89% | 83.51% | 87.27% | 87.84% | 10 | 21620 - 86.48% | 3,154,858$ | 97,800,586$ | 25000 | 126 | 94,861,887$ | 94,861,887$ | 0$ | 71,348,367$ | 765,015$ | 67,215,293$ | 23 | 0 | 0$ | 31,548,576$ | 33 | 809,370$ | 26,709,210$ | 27,448,674$ | 92,460,788$ | 13,060,788$ | 107,500,000$ | 15,039,212$ | 110,067,759$ | 115,120,519$ |
| 25 | Sharks | 3000 | 4000 | 5000 | 6000 | 2000 | 150 | 98 | 70 | 50 | 265 | 90000 | 120000 | 150000 | 180000 | 60000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 11 | 20000 - 100.00% | 2,588,160$ | 77,644,800$ | 20000 | 127 | 83,152,468$ | 83,152,469$ | 0$ | 63,868,435$ | 670,584$ | 59,896,662$ | 25 | 0 | 0$ | 28,469,760$ | 33 | 710,907$ | 23,459,931$ | 24,148,212$ | 82,025,934$ | 2,625,934$ | 107,500,000$ | 25,474,066$ | 165,561,821$ | 171,106,195$ |
| 26 | Stars | 3750 | 5000 | 6250 | 7500 | 2500 | 155 | 100 | 78 | 55 | 265 | 98784 | 130014 | 161653 | 187822 | 66695 | 84.98% | 83.88% | 83.43% | 80.78% | 86.06% | 10 | 20805 - 83.22% | 2,842,968$ | 88,132,006$ | 25000 | 114 | 98,607,108$ | 95,941,270$ | 1,500,000$ | 75,897,996$ | 773,720$ | 72,812,003$ | 21 | 1 | 0$ | 28,429,679$ | 33 | 827,477$ | 27,306,741$ | 27,997,926$ | 99,844,763$ | 20,444,763$ | 107,500,000$ | 7,655,237$ | 145,624,262$ | 147,033,482$ |
| 27 | Utah HC | 6500 | 5500 | 2500 | 4250 | 1250 | 105 | 31 | 30 | 28 | 205 | 125186 | 168707 | 77500 | 131750 | 38750 | 62.13% | 98.95% | 100.00% | 100.00% | 100.00% | 10 | 17480 - 87.40% | 1,335,007$ | 41,385,211$ | 20000 | 110 | 74,167,343$ | 74,167,343$ | 5,375,000$ | 56,262,945$ | 598,124$ | 54,694,401$ | 25 | 0 | 0$ | 13,350,068$ | 33 | 614,253$ | 20,270,349$ | 21,031,923$ | 79,807,493$ | 407,493$ | 107,500,000$ | 27,692,507$ | 8,415,002$ | 1,682,908$ |
| 28 | Wild | 3750 | 5000 | 6250 | 7500 | 2500 | 150 | 100 | 85 | 50 | 270 | 116250 | 155000 | 193750 | 232500 | 77500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 10 | 25000 - 100.00% | 3,384,000$ | 104,904,000$ | 25000 | 192 | 107,658,494$ | 107,658,494$ | 0$ | 80,252,616$ | 868,214$ | 78,340,355$ | 22 | 0 | 0$ | 33,840,000$ | 33 | 888,375$ | 29,316,375$ | 29,939,778$ | 106,991,417$ | 27,591,417$ | 107,500,000$ | 508,583$ | 274,260,364$ | 279,096,915$ |