| 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 |
| 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 | 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 10,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Boston Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 37413 | 29232 | 12641 | 23976 | 6044 | 77.94% | 73.08% | 79.01% | 74.93% | 75.55% | 33 | 13663 - 75.91% | 968,232$ | 7,745,855$ | 18000 | 100 | 22,605,000$ | 22,605,000$ | 0$ | 4,010,556$ | 22,605,000$ | 4,010,556$ | 20 | 0 | 0$ | 31,951,652$ | 102 | 182,298$ | 18,594,396$ | 18,941,735$ | 22,605,000$ | 12,605,000$ | 23,000,000$ | 395,000$ | 237,761,582$ | 250,771,499$ |
| 2 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 32760 | 26536 | 10243 | 20908 | 5290 | 78.00% | 75.82% | 73.16% | 74.67% | 75.57% | 34 | 13677 - 75.98% | 972,481$ | 6,807,365$ | 18000 | 100 | 20,370,000$ | 20,370,000$ | 0$ | 3,614,028$ | 20,370,000$ | 3,614,028$ | 21 | 0 | 0$ | 33,064,344$ | 102 | 164,274$ | 16,755,948$ | 17,314,377$ | 20,370,000$ | 10,370,000$ | 23,000,000$ | 2,630,000$ | 271,480,442$ | 287,230,409$ |
| 3 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 37190 | 30141 | 11991 | 23490 | 6139 | 77.48% | 75.35% | 74.94% | 73.41% | 76.74% | 33 | 13619 - 75.66% | 970,274$ | 7,762,195$ | 18000 | 100 | 22,272,500$ | 22,272,500$ | 0$ | 3,924,355$ | 22,272,500$ | 3,924,355$ | 23 | 0 | 0$ | 32,019,054$ | 102 | 179,617$ | 18,320,934$ | 18,852,598$ | 22,272,500$ | 12,272,500$ | 23,000,000$ | 727,500$ | 260,141,520$ | 273,307,976$ |
| 4 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 45 | 25 | 15 | 160 | 41888 | 33446 | 13640 | 27547 | 6722 | 99.73% | 95.56% | 97.43% | 98.38% | 96.03% | 34 | 17606 - 97.81% | 955,119$ | 6,685,835$ | 18000 | 100 | 21,135,000$ | 21,135,000$ | 0$ | 3,749,768$ | 21,135,000$ | 3,749,768$ | 23 | 0 | 0$ | 32,474,056$ | 102 | 170,444$ | 17,385,288$ | 18,245,808$ | 21,135,000$ | 11,135,000$ | 23,000,000$ | 1,865,000$ | 211,481,858$ | 225,710,106$ |
| 5 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 91 | 51 | 30 | 18 | 174 | 41212 | 33221 | 13092 | 27586 | 6641 | 98.12% | 94.92% | 93.51% | 98.52% | 94.87% | 34 | 17393 - 96.63% | 1,044,613$ | 7,312,289$ | 18000 | 100 | 21,935,000$ | 21,935,000$ | 0$ | 3,891,690$ | 21,935,000$ | 3,891,690$ | 22 | 0 | 0$ | 35,516,832$ | 102 | 176,895$ | 18,043,290$ | 18,956,633$ | 21,935,000$ | 11,935,000$ | 23,000,000$ | 1,065,000$ | 278,115,647$ | 294,675,846$ |
| 6 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 58 | 35 | 28 | 155 | 45899 | 31817 | 12517 | 21255 | 7959 | 95.62% | 79.54% | 78.23% | 66.42% | 99.49% | 33 | 14931 - 82.95% | 1,059,084$ | 8,472,671$ | 18000 | 100 | 22,880,000$ | 22,880,000$ | 0$ | 4,059,352$ | 22,880,000$ | 4,059,352$ | 22 | 0 | 0$ | 34,949,768$ | 102 | 184,516$ | 18,820,632$ | 19,606,311$ | 22,880,000$ | 12,880,000$ | 23,000,000$ | 120,000$ | 288,735,604$ | 304,079,061$ |
| 7 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 36433 | 29820 | 11722 | 24260 | 6065 | 75.90% | 74.55% | 73.26% | 75.81% | 75.81% | 33 | 13538 - 75.21% | 957,784$ | 7,662,270$ | 18000 | 100 | 16,940,000$ | 16,940,000$ | 0$ | 3,005,486$ | 16,940,000$ | 3,005,486$ | 22 | 0 | 0$ | 31,606,864$ | 102 | 136,613$ | 13,934,526$ | 14,275,805$ | 16,940,000$ | 6,940,000$ | 23,000,000$ | 6,060,000$ | 228,994,797$ | 246,325,856$ |
| 8 | Los Angeles Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 36886 | 29402 | 12231 | 24537 | 6117 | 76.85% | 73.51% | 76.44% | 76.68% | 76.46% | 33 | 13647 - 75.81% | 964,704$ | 7,717,630$ | 18000 | 100 | 21,695,000$ | 21,695,000$ | 0$ | 3,809,440$ | 21,695,000$ | 3,809,440$ | 21 | 0 | 0$ | 31,835,224$ | 102 | 174,960$ | 17,845,920$ | 18,749,567$ | 21,695,000$ | 11,695,000$ | 23,000,000$ | 1,305,000$ | 261,733,121$ | 274,818,778$ |
| 9 | Minnesota North Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 36737 | 31321 | 11739 | 23805 | 6208 | 76.54% | 78.30% | 73.37% | 74.39% | 77.60% | 33 | 13726 - 76.26% | 975,069$ | 7,800,550$ | 18000 | 100 | 22,430,000$ | 22,430,000$ | 0$ | 3,979,514$ | 22,430,000$ | 3,979,514$ | 20 | 0 | 0$ | 32,177,269$ | 102 | 180,887$ | 18,450,474$ | 19,267,867$ | 22,430,000$ | 12,430,000$ | 23,000,000$ | 570,000$ | 248,920,054$ | 261,829,456$ |
| 10 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 55 | 35 | 25 | 180 | 43996 | 38633 | 12084 | 23251 | 7590 | 91.66% | 96.58% | 75.53% | 72.66% | 94.88% | 33 | 15694 - 87.19% | 1,084,356$ | 8,674,850$ | 18000 | 100 | 20,790,000$ | 20,790,000$ | 0$ | 3,735,318$ | 20,790,000$ | 3,735,318$ | 20 | 0 | 0$ | 35,783,756$ | 102 | 167,661$ | 17,101,422$ | 17,881,344$ | 20,790,000$ | 10,790,000$ | 23,000,000$ | 2,210,000$ | 276,287,371$ | 294,189,783$ |
| 11 | New Jersey Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 199 | 35757 | 30402 | 12140 | 24360 | 5775 | 74.49% | 76.01% | 75.88% | 76.13% | 72.19% | 33 | 13554 - 75.30% | 947,868$ | 7,582,945$ | 18000 | 100 | 21,655,000$ | 21,655,000$ | 0$ | 3,776,854$ | 21,655,000$ | 3,776,854$ | 21 | 0 | 0$ | 31,279,648$ | 102 | 174,637$ | 17,812,974$ | 18,307,470$ | 21,655,000$ | 11,655,000$ | 23,000,000$ | 1,345,000$ | 232,956,190$ | 245,928,368$ |
| 12 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 40 | 25 | 15 | 130 | 40872 | 33881 | 13711 | 27533 | 6765 | 97.31% | 96.80% | 97.94% | 98.33% | 96.64% | 34 | 17537 - 97.43% | 865,123$ | 6,055,860$ | 18000 | 100 | 14,263,000$ | 14,263,000$ | 0$ | 2,514,322$ | 14,263,000$ | 2,514,322$ | 21 | 0 | 0$ | 29,414,177$ | 102 | 115,024$ | 11,732,448$ | 12,222,904$ | 14,263,000$ | 4,263,000$ | 23,000,000$ | 8,737,000$ | 222,970,567$ | 240,161,840$ |
| 13 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 65 | 45 | 30 | 250 | 29225 | 28686 | 9562 | 19990 | 4903 | 60.89% | 71.72% | 59.76% | 62.47% | 61.29% | 33 | 11546 - 64.14% | 971,682$ | 7,773,455$ | 18000 | 100 | 19,085,000$ | 19,085,000$ | 0$ | 3,386,042$ | 19,085,000$ | 3,386,042$ | 21 | 0 | 0$ | 32,065,502$ | 102 | 153,911$ | 15,698,922$ | 16,055,048$ | 19,085,000$ | 9,085,000$ | 23,000,000$ | 3,915,000$ | 238,906,420$ | 254,916,874$ |
| 14 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 37077 | 29897 | 11645 | 24596 | 5932 | 77.24% | 74.74% | 72.78% | 76.86% | 74.15% | 33 | 13643 - 75.80% | 963,799$ | 7,710,395$ | 18000 | 100 | 20,275,000$ | 20,275,000$ | 0$ | 3,597,176$ | 20,275,000$ | 3,597,176$ | 22 | 0 | 0$ | 31,805,379$ | 102 | 163,508$ | 16,677,816$ | 17,246,648$ | 20,275,000$ | 10,275,000$ | 23,000,000$ | 2,725,000$ | 13,989,315$ | 28,548,046$ |
| 15 | Philadelphia Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 70 | 45 | 20 | 18 | 140 | 47447 | 39105 | 15839 | 30272 | 7768 | 98.85% | 97.76% | 98.99% | 94.60% | 97.10% | 33 | 17554 - 97.52% | 878,776$ | 7,030,211$ | 18000 | 100 | 21,938,000$ | 21,938,000$ | 0$ | 3,892,218$ | 21,938,000$ | 3,892,218$ | 21 | 0 | 0$ | 28,999,620$ | 102 | 176,919$ | 18,045,738$ | 18,756,576$ | 21,938,000$ | 11,938,000$ | 23,000,000$ | 1,062,000$ | 225,410,091$ | 235,653,135$ |
| 16 | Pittsburgh Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 32337 | 27192 | 10545 | 21044 | 5111 | 76.99% | 77.69% | 75.32% | 75.16% | 73.01% | 34 | 13747 - 76.37% | 968,942$ | 6,782,595$ | 18000 | 100 | 18,155,000$ | 18,155,000$ | 0$ | 3,221,042$ | 18,155,000$ | 3,221,042$ | 20 | 0 | 0$ | 32,944,033$ | 102 | 146,411$ | 14,933,922$ | 15,714,349$ | 18,155,000$ | 8,155,000$ | 23,000,000$ | 4,845,000$ | 242,904,594$ | 260,134,278$ |
| 17 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 37015 | 29635 | 11948 | 23513 | 6178 | 77.11% | 74.09% | 74.68% | 73.48% | 77.23% | 33 | 13536 - 75.20% | 965,151$ | 7,721,205$ | 18000 | 100 | 17,680,000$ | 17,680,000$ | 0$ | 3,136,782$ | 17,680,000$ | 3,136,782$ | 20 | 0 | 0$ | 31,849,971$ | 102 | 142,581$ | 14,543,262$ | 15,107,448$ | 17,680,000$ | 7,680,000$ | 23,000,000$ | 5,320,000$ | 233,167,131$ | 249,909,654$ |
| 18 | San Jose Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 36537 | 29048 | 12196 | 25184 | 6011 | 76.12% | 72.62% | 76.23% | 78.70% | 75.14% | 33 | 13622 - 75.68% | 956,905$ | 7,655,240$ | 18000 | 100 | 19,770,000$ | 19,770,000$ | 0$ | 3,573,302$ | 19,770,000$ | 3,573,302$ | 21 | 0 | 0$ | 31,577,865$ | 102 | 159,435$ | 16,262,370$ | 17,411,851$ | 19,770,000$ | 9,770,000$ | 23,000,000$ | 3,230,000$ | 48,078,986$ | 62,245,000$ |
| 19 | St-Louis Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 34918 | 30176 | 12450 | 23501 | 6108 | 72.75% | 75.44% | 77.81% | 73.44% | 76.35% | 33 | 13394 - 74.41% | 943,404$ | 7,547,235$ | 18000 | 100 | 21,610,000$ | 21,610,000$ | 0$ | 3,842,102$ | 21,610,000$ | 3,842,102$ | 20 | 1 | 0$ | 31,132,344$ | 102 | 174,274$ | 17,775,948$ | 18,644,548$ | 21,610,000$ | 11,610,000$ | 23,000,000$ | 1,390,000$ | 252,299,377$ | 264,787,173$ |
| 20 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 35974 | 30123 | 12423 | 24682 | 5933 | 74.95% | 75.31% | 77.64% | 77.13% | 74.16% | 33 | 13642 - 75.79% | 955,404$ | 7,643,235$ | 18000 | 100 | 20,935,000$ | 20,935,000$ | 0$ | 3,791,694$ | 20,935,000$ | 3,791,694$ | 21 | 0 | 0$ | 31,528,344$ | 102 | 168,831$ | 17,220,762$ | 18,082,898$ | 20,935,000$ | 10,935,000$ | 23,000,000$ | 2,065,000$ | 14,171,561$ | 27,617,007$ |
| 21 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 93 | 53 | 29 | 20 | 175 | 44962 | 37556 | 15197 | 30257 | 7503 | 93.67% | 93.89% | 94.98% | 94.55% | 93.79% | 33 | 16934 - 94.08% | 1,066,352$ | 8,530,812$ | 18000 | 100 | 21,475,000$ | 21,475,000$ | 0$ | 3,834,754$ | 21,475,000$ | 3,834,754$ | 21 | 0 | 0$ | 35,189,600$ | 102 | 173,185$ | 17,664,870$ | 18,205,422$ | 21,475,000$ | 11,475,000$ | 23,000,000$ | 1,525,000$ | 267,779,500$ | 284,763,678$ |
| 22 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 36911 | 29312 | 12113 | 23400 | 5977 | 76.90% | 73.28% | 75.71% | 73.13% | 74.71% | 33 | 13464 - 74.80% | 956,772$ | 7,654,175$ | 18000 | 100 | 20,550,000$ | 20,550,000$ | 0$ | 3,645,972$ | 20,550,000$ | 3,645,972$ | 21 | 0 | 0$ | 31,573,472$ | 102 | 165,726$ | 16,904,052$ | 17,389,357$ | 20,550,000$ | 10,550,000$ | 23,000,000$ | 2,450,000$ | 240,831,139$ | 255,015,254$ |
| 23 | Washington Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 36951 | 30049 | 11998 | 24493 | 6031 | 76.98% | 75.12% | 74.99% | 76.54% | 75.39% | 33 | 13690 - 76.06% | 967,062$ | 7,736,495$ | 18000 | 100 | 21,450,000$ | 21,450,000$ | 0$ | 3,805,648$ | 21,450,000$ | 3,805,648$ | 20 | 0 | 0$ | 31,913,042$ | 102 | 172,984$ | 17,644,368$ | 18,519,331$ | 21,450,000$ | 11,450,000$ | 23,000,000$ | 1,550,000$ | 270,353,793$ | 283,747,504$ |
| 24 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 35587 | 30726 | 12321 | 23931 | 6199 | 74.14% | 76.82% | 77.01% | 74.78% | 77.49% | 33 | 13596 - 75.53% | 958,946$ | 7,671,570$ | 18000 | 100 | 18,350,000$ | 18,350,000$ | 0$ | 3,259,276$ | 18,350,000$ | 3,259,276$ | 20 | 0 | 0$ | 31,645,226$ | 102 | 147,984$ | 15,094,368$ | 15,926,204$ | 18,350,000$ | 8,350,000$ | 23,000,000$ | 4,650,000$ | 251,142,301$ | 266,861,323$ |