| 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% | 42 | 0 - 0% | 0$ | 0$ | 20000 | 151 | 108,357,097$ | 108,357,097$ | 0$ | 1,728,570$ | 833,516$ | 1,667,032$ | 25 | 0 | 0$ | 0$ | 128 | 864,285$ | 110,628,480$ | 114,365,952$ | 108,357,080$ | 28,157,080$ | 108,500,000$ | 142,920$ | 62,182,965$ | -52,182,987$ |
| 2 | BlueJackets | 3000 | 4000 | 5000 | 6000 | 2000 | 135 | 110 | 85 | 40 | 240 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 20000 | 117 | 107,477,627$ | 107,477,629$ | 0$ | 1,722,732$ | 826,751$ | 1,653,502$ | 21 | 0 | 0$ | 0$ | 128 | 861,366$ | 110,254,848$ | 113,793,024$ | 107,477,630$ | 27,277,630$ | 108,500,000$ | 1,022,370$ | 122,539,291$ | 8,746,267$ |
| 3 | Blues | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 25000 | 150 | 78,986,606$ | 78,986,606$ | 5,400,000$ | 1,238,256$ | 607,589$ | 1,215,178$ | 21 | 1 | 0$ | 0$ | 128 | 619,128$ | 79,248,384$ | 82,220,800$ | 84,386,570$ | 4,186,570$ | 108,500,000$ | 24,113,430$ | 122,328,608$ | 40,107,808$ |
| 4 | Bruins | 3000 | 4000 | 5000 | 6000 | 2000 | 170 | 110 | 90 | 60 | 285 | 3000 | 4000 | 5000 | 6000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 20000 - 100.00% | 2,982,400$ | 2,982,400$ | 20000 | 164 | 108,265,327$ | 100,861,265$ | 0$ | 1,754,852$ | 775,856$ | 1,551,712$ | 22 | 1 | 0$ | 122,278,400$ | 128 | 877,426$ | 112,310,528$ | 114,355,200$ | 100,861,280$ | 20,661,280$ | 108,500,000$ | 7,638,720$ | 177,847,789$ | 185,770,989$ |
| 5 | Canadiens | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 85 | 60 | 270 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 25000 | 178 | 87,074,505$ | 87,074,506$ | 0$ | 1,442,684$ | 669,804$ | 1,339,608$ | 23 | 0 | 0$ | 0$ | 128 | 721,342$ | 92,331,776$ | 95,756,800$ | 87,074,520$ | 6,874,520$ | 108,500,000$ | 21,425,480$ | 218,977,167$ | 123,220,367$ |
| 6 | Canucks | 3000 | 4000 | 5000 | 6000 | 2000 | 110 | 70 | 45 | 35 | 210 | 3000 | 4000 | 5000 | 6000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 20000 - 100.00% | 1,875,200$ | 1,875,200$ | 20000 | 110 | 101,109,950$ | 101,109,951$ | 0$ | 1,586,306$ | 777,769$ | 1,555,538$ | 22 | 0 | 0$ | 76,883,200$ | 128 | 793,153$ | 101,523,584$ | 104,093,696$ | 101,109,970$ | 20,909,970$ | 108,500,000$ | 7,390,030$ | 20,612,220$ | -6,598,276$ |
| 7 | Capitals | 3750 | 5000 | 6250 | 7500 | 2500 | 137 | 94 | 74 | 49 | 246 | 3750 | 5000 | 6214 | 7500 | 2500 | 100.00% | 100.00% | 99.42% | 100.00% | 100.00% | 41 | 24964 - 99.86% | 3,105,390$ | 3,105,390$ | 25000 | 123 | 84,217,921$ | 84,217,920$ | 5,400,000$ | 1,314,122$ | 647,830$ | 1,295,660$ | 21 | 0 | 0$ | 127,320,990$ | 128 | 657,061$ | 84,103,808$ | 86,503,680$ | 89,617,900$ | 9,417,900$ | 108,500,000$ | 18,882,100$ | 325,105,046$ | 365,922,356$ |
| 8 | Ducks | 3750 | 5000 | 6250 | 7500 | 2500 | 161 | 108 | 83 | 58 | 271 | 3750 | 5000 | 6250 | 7500 | 2500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 25000 - 100.00% | 3,552,000$ | 3,552,000$ | 25000 | 162 | 88,971,514$ | 88,971,514$ | -5,240,000$ | 1,405,716$ | 684,396$ | 1,368,792$ | 22 | 0 | 0$ | 145,632,000$ | 128 | 702,858$ | 89,965,824$ | 93,263,232$ | 83,731,480$ | 3,531,480$ | 108,500,000$ | 24,768,520$ | 459,441,205$ | 511,809,973$ |
| 9 | Flames | 3750 | 5000 | 6250 | 7500 | 2500 | 145 | 110 | 85 | 55 | 285 | 3750 | 5000 | 6250 | 7500 | 2500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 25000 - 100.00% | 3,520,000$ | 3,520,000$ | 25000 | 200 | 110,895,562$ | 110,895,562$ | -5,450,000$ | 1,798,394$ | 853,043$ | 1,706,086$ | 20 | 0 | 0$ | 144,320,000$ | 128 | 899,197$ | 115,097,216$ | 118,234,880$ | 105,445,590$ | 25,245,590$ | 108,500,000$ | 3,054,410$ | 384,624,372$ | 410,709,492$ |
| 10 | Flyers | 3300 | 4400 | 5500 | 6600 | 2200 | 148 | 85 | 60 | 38 | 270 | 3300 | 4400 | 5500 | 6600 | 2200 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 22000 - 100.00% | 2,607,616$ | 2,607,616$ | 22000 | 145 | 100,147,850$ | 100,147,849$ | 0$ | 1,663,012$ | 770,368$ | 1,590,704$ | 22 | 1 | 0$ | 106,912,256$ | 128 | 806,522$ | 103,234,816$ | 106,075,520$ | 100,197,808$ | 19,997,808$ | 108,500,000$ | 8,302,192$ | 150,877,518$ | 151,714,254$ |
| 11 | GoldenKnights | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 75 | 50 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 25000 | 185 | 108,033,156$ | 108,033,156$ | 0$ | 1,749,740$ | 831,024$ | 1,662,048$ | 20 | 0 | 0$ | 0$ | 128 | 874,870$ | 111,983,360$ | 115,084,288$ | 108,033,120$ | 27,833,120$ | 108,500,000$ | 466,880$ | 341,504,432$ | 226,420,144$ |
| 12 | Hurricanes | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 80 | 55 | 270 | 3750 | 4842 | 5865 | 7500 | 2459 | 100.00% | 96.84% | 93.84% | 100.00% | 98.36% | 41 | 24416 - 97.66% | 3,428,160$ | 3,428,160$ | 25000 | 145 | 81,421,313$ | 81,421,315$ | 0$ | 1,337,250$ | 626,318$ | 1,252,636$ | 20 | 0 | 0$ | 140,554,560$ | 128 | 668,625$ | 85,584,000$ | 87,689,472$ | 81,421,340$ | 1,221,340$ | 108,500,000$ | 27,078,660$ | 337,675,836$ | 390,540,924$ |
| 13 | Islanders | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 107 | 89 | 58 | 285 | 3750 | 4444 | 5728 | 7196 | 2500 | 100.00% | 88.88% | 91.65% | 95.95% | 100.00% | 41 | 23618 - 94.47% | 3,475,415$ | 3,475,415$ | 25000 | 142 | 97,492,131$ | 97,492,130$ | 0$ | 1,546,032$ | 749,939$ | 1,499,878$ | 23 | 0 | 0$ | 142,492,015$ | 128 | 773,016$ | 98,946,048$ | 101,977,856$ | 97,492,070$ | 17,292,070$ | 108,500,000$ | 11,007,930$ | 289,461,128$ | 329,975,287$ |
| 14 | Jets | 3750 | 5000 | 6250 | 7500 | 2500 | 96 | 65 | 50 | 21 | 200 | 3750 | 5000 | 6250 | 7500 | 2500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 25000 - 100.00% | 2,118,400$ | 2,118,400$ | 25000 | 118 | 110,336,587$ | 110,336,586$ | -5,425,000$ | 1,774,410$ | 848,743$ | 1,697,486$ | 23 | 0 | 0$ | 86,854,400$ | 128 | 887,205$ | 113,562,240$ | 115,260,416$ | 104,911,590$ | 24,711,590$ | 108,500,000$ | 3,588,410$ | 41,939,536$ | 13,533,520$ |
| 15 | Kraken | 3750 | 5000 | 6250 | 7500 | 2500 | 165 | 110 | 87 | 57 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 25000 | 110 | 75,056,759$ | 75,056,759$ | 5,425,000$ | 1,239,334$ | 577,360$ | 1,154,720$ | 22 | 1 | 0$ | 0$ | 128 | 619,667$ | 79,317,376$ | 82,420,736$ | 80,481,800$ | 281,800$ | 108,500,000$ | 28,018,200$ | 65,508,398$ | -16,912,338$ |
| 16 | Lightning | 2700 | 3600 | 4500 | 5400 | 1800 | 170 | 110 | 90 | 65 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 18000 | 127 | 88,166,859$ | 88,166,859$ | 5,450,000$ | 1,390,460$ | 678,207$ | 1,356,414$ | 23 | 0 | 0$ | 0$ | 128 | 695,230$ | 88,989,440$ | 91,321,984$ | 93,616,910$ | 13,416,910$ | 108,500,000$ | 14,883,090$ | 75,452,418$ | -15,869,566$ |
| 17 | Maple Leafs | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 85 | 60 | 270 | 3750 | 5000 | 6250 | 7500 | 2500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 25000 - 100.00% | 3,592,000$ | 3,592,000$ | 25000 | 200 | 94,895,203$ | 94,895,206$ | 0$ | 1,506,080$ | 729,963$ | 1,459,926$ | 22 | 0 | 0$ | 147,272,000$ | 128 | 753,040$ | 96,389,120$ | 99,413,760$ | 94,895,190$ | 14,695,190$ | 108,500,000$ | 13,604,810$ | 425,093,575$ | 472,951,815$ |
| 18 | Oilers | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 3750 | 5000 | 6250 | 7500 | 2500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 25000 - 100.00% | 3,776,000$ | 3,776,000$ | 25000 | 190 | 105,494,741$ | 105,494,741$ | 3,000,000$ | 1,707,612$ | 811,498$ | 1,622,996$ | 24 | 0 | 0$ | 154,816,000$ | 128 | 853,806$ | 109,287,168$ | 112,957,440$ | 108,494,740$ | 28,294,740$ | 108,500,000$ | 5,260$ | 335,218,346$ | 377,076,906$ |
| 19 | Pantheres | 3750 | 5000 | 6250 | 7500 | 2500 | 150 | 90 | 70 | 55 | 270 | 3750 | 5000 | 6250 | 7500 | 2500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 25000 - 100.00% | 3,248,000$ | 3,248,000$ | 25000 | 200 | 111,532,078$ | 111,532,077$ | -4,536,000$ | 1,811,262$ | 857,939$ | 1,715,878$ | 21 | 0 | 0$ | 133,168,000$ | 128 | 905,631$ | 115,920,768$ | 118,270,464$ | 106,996,070$ | 26,796,070$ | 108,500,000$ | 1,503,930$ | 223,619,421$ | 238,516,957$ |
| 20 | Pengouins | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 25000 | 195 | 86,803,283$ | 86,803,283$ | 0$ | 1,381,588$ | 667,718$ | 1,335,436$ | 25 | 0 | 0$ | 0$ | 128 | 690,794$ | 88,421,632$ | 90,987,136$ | 86,803,340$ | 6,603,340$ | 108,500,000$ | 21,696,660$ | 613,398,411$ | 522,411,275$ |
| 21 | Predateurs | 3750 | 5000 | 6250 | 7500 | 2500 | 151 | 100 | 81 | 51 | 270 | 3750 | 5000 | 6250 | 7500 | 2500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 25000 - 100.00% | 3,366,400$ | 3,366,400$ | 25000 | 200 | 107,948,404$ | 107,948,402$ | 0$ | 1,743,822$ | 830,372$ | 1,680,744$ | 21 | 0 | 0$ | 138,022,400$ | 128 | 861,911$ | 110,324,608$ | 113,464,576$ | 107,968,360$ | 27,768,360$ | 108,500,000$ | 531,640$ | 310,969,721$ | 335,527,545$ |
| 22 | Rangers | 3750 | 5000 | 6250 | 7500 | 2500 | 100 | 65 | 45 | 18 | 195 | 3750 | 5000 | 6250 | 7500 | 2500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 25000 - 100.00% | 2,052,800$ | 2,052,800$ | 25000 | 200 | 96,386,268$ | 96,386,269$ | 0$ | 1,565,174$ | 741,433$ | 1,482,866$ | 22 | 0 | 0$ | 84,164,800$ | 128 | 782,587$ | 100,171,136$ | 104,671,488$ | 96,386,290$ | 16,186,290$ | 108,500,000$ | 12,113,710$ | 243,309,202$ | 222,802,514$ |
| 23 | Red Wings | 3188 | 4250 | 5312 | 6375 | 2125 | 170 | 110 | 80 | 56 | 280 | 3170 | 4250 | 5124 | 6375 | 2032 | 99.44% | 100.00% | 96.46% | 100.00% | 95.62% | 41 | 20951 - 98.59% | 2,998,118$ | 2,998,118$ | 21250 | 127 | 98,856,671$ | 98,456,670$ | 0$ | 1,605,488$ | 757,359$ | 1,514,718$ | 23 | 0 | 0$ | 122,922,838$ | 128 | 802,744$ | 102,751,232$ | 105,089,280$ | 98,456,670$ | 18,256,670$ | 108,500,000$ | 10,043,330$ | 227,741,443$ | 245,575,001$ |
| 24 | Sabres | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 3259 | 3648 | 4292 | 5106 | 2132 | 86.91% | 72.96% | 68.67% | 68.08% | 85.28% | 41 | 18437 - 73.75% | 2,919,808$ | 2,919,808$ | 25000 | 110 | 107,309,697$ | 107,309,698$ | -5,400,000$ | 1,738,610$ | 825,459$ | 1,650,918$ | 21 | 0 | 0$ | 119,712,128$ | 128 | 869,305$ | 111,271,040$ | 114,010,112$ | 101,909,670$ | 21,709,670$ | 108,500,000$ | 6,590,330$ | 144,407,944$ | 150,109,960$ |
| 25 | Sharks | 3000 | 4000 | 5000 | 6000 | 2000 | 150 | 98 | 70 | 50 | 265 | 3000 | 4000 | 5000 | 6000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 20000 - 100.00% | 2,588,160$ | 2,588,160$ | 20000 | 122 | 106,444,981$ | 106,444,982$ | 0$ | 1,714,538$ | 818,808$ | 1,637,616$ | 25 | 1 | 0$ | 106,114,560$ | 128 | 857,269$ | 109,730,432$ | 112,052,864$ | 106,445,040$ | 26,245,040$ | 108,500,000$ | 2,054,960$ | 156,453,222$ | 150,514,918$ |
| 26 | Stars | 3750 | 5000 | 6250 | 7500 | 2500 | 155 | 100 | 78 | 55 | 265 | 3631 | 4599 | 5648 | 6059 | 2081 | 96.83% | 91.98% | 90.37% | 80.79% | 83.24% | 41 | 22018 - 88.07% | 3,005,388$ | 3,005,388$ | 25000 | 120 | 104,755,547$ | 104,755,549$ | 700,000$ | 1,673,162$ | 805,812$ | 1,611,624$ | 23 | 0 | 0$ | 123,220,908$ | 128 | 836,581$ | 107,082,368$ | 109,389,184$ | 105,455,560$ | 25,255,560$ | 108,500,000$ | 3,044,440$ | 154,927,662$ | 168,759,386$ |
| 27 | Utah HC | 6500 | 5500 | 2500 | 4250 | 1250 | 105 | 31 | 30 | 28 | 205 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 20000 | 118 | 103,058,329$ | 103,058,329$ | 5,000,000$ | 1,603,974$ | 792,756$ | 1,585,512$ | 20 | 0 | 0$ | 0$ | 128 | 801,987$ | 102,654,336$ | 105,186,432$ | 108,058,280$ | 27,858,280$ | 108,500,000$ | 441,720$ | 39,630,926$ | -65,555,506$ |
| 28 | Wild | 3750 | 5000 | 6250 | 7500 | 2500 | 150 | 100 | 85 | 50 | 270 | 3750 | 5000 | 6250 | 7500 | 2500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 41 | 25000 - 100.00% | 3,384,000$ | 3,384,000$ | 25000 | 197 | 105,916,904$ | 105,916,904$ | -5,400,000$ | 1,667,952$ | 814,745$ | 1,629,490$ | 21 | 0 | 0$ | 138,744,000$ | 128 | 833,976$ | 106,748,928$ | 109,417,216$ | 100,516,850$ | 20,316,850$ | 108,500,000$ | 7,983,150$ | 243,044,762$ | 272,371,546$ |