| 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 | 42064 | 32874 | 14038 | 26932 | 6829 | 77.90% | 73.05% | 77.99% | 74.81% | 75.88% | 32 | 13637 - 75.76% | 967,697$ | 8,709,270$ | 18000 | 100 | 22,605,000$ | 22,605,000$ | 0$ | 4,192,854$ | 22,605,000$ | 4,192,854$ | 20 | 0 | 0$ | 30,966,293$ | 101 | 182,298$ | 18,412,098$ | 18,755,998$ | 22,605,000$ | 12,605,000$ | 23,000,000$ | 395,000$ | 238,539,260$ | 250,749,555$ |
| 2 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 36957 | 30149 | 11736 | 23608 | 5973 | 76.99% | 75.37% | 73.35% | 73.78% | 74.66% | 33 | 13553 - 75.29% | 962,525$ | 7,700,200$ | 18000 | 100 | 20,370,000$ | 20,370,000$ | 0$ | 3,778,302$ | 20,370,000$ | 3,778,302$ | 21 | 0 | 0$ | 31,763,325$ | 101 | 164,274$ | 16,591,674$ | 17,144,574$ | 20,370,000$ | 10,370,000$ | 23,000,000$ | 2,630,000$ | 272,203,474$ | 286,822,225$ |
| 3 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 41458 | 33996 | 13633 | 26654 | 6829 | 76.77% | 75.55% | 75.74% | 74.04% | 75.88% | 32 | 13619 - 75.66% | 966,096$ | 8,694,865$ | 18000 | 100 | 22,272,500$ | 22,272,500$ | 0$ | 4,103,972$ | 22,272,500$ | 4,103,972$ | 23 | 0 | 0$ | 30,915,076$ | 101 | 179,617$ | 18,141,317$ | 18,667,717$ | 22,272,500$ | 12,272,500$ | 23,000,000$ | 727,500$ | 260,889,309$ | 273,136,668$ |
| 4 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 45 | 25 | 15 | 160 | 47820 | 38446 | 15483 | 31547 | 7722 | 99.63% | 96.12% | 96.77% | 98.58% | 96.53% | 33 | 17627 - 97.93% | 956,434$ | 7,651,470$ | 18000 | 100 | 21,135,000$ | 21,135,000$ | 0$ | 3,920,212$ | 21,135,000$ | 3,920,212$ | 23 | 0 | 0$ | 31,562,314$ | 101 | 170,444$ | 17,214,844$ | 18,066,844$ | 21,135,000$ | 11,135,000$ | 23,000,000$ | 1,865,000$ | 212,268,529$ | 225,763,999$ |
| 5 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 91 | 51 | 30 | 18 | 174 | 46545 | 38221 | 15092 | 31460 | 7518 | 96.97% | 95.55% | 94.33% | 98.31% | 93.98% | 33 | 17355 - 96.41% | 1,041,865$ | 8,334,922$ | 18000 | 100 | 21,935,000$ | 21,935,000$ | 0$ | 4,068,585$ | 21,935,000$ | 4,068,585$ | 22 | 0 | 0$ | 34,381,553$ | 101 | 176,895$ | 17,866,395$ | 18,770,695$ | 21,935,000$ | 11,935,000$ | 23,000,000$ | 1,065,000$ | 278,952,342$ | 294,563,200$ |
| 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,243,868$ | 22,880,000$ | 4,243,868$ | 22 | 0 | 0$ | 34,949,768$ | 101 | 184,516$ | 18,636,116$ | 19,414,016$ | 22,880,000$ | 12,880,000$ | 23,000,000$ | 120,000$ | 288,543,309$ | 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,142,099$ | 16,940,000$ | 3,142,099$ | 22 | 0 | 0$ | 31,606,864$ | 101 | 136,613$ | 13,797,913$ | 14,135,813$ | 16,940,000$ | 6,940,000$ | 23,000,000$ | 6,060,000$ | 228,854,805$ | 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,984,400$ | 21,695,000$ | 3,984,400$ | 21 | 0 | 0$ | 31,835,224$ | 101 | 174,960$ | 17,670,960$ | 18,565,660$ | 21,695,000$ | 11,695,000$ | 23,000,000$ | 1,305,000$ | 261,549,214$ | 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$ | 4,160,401$ | 22,430,000$ | 4,160,401$ | 20 | 0 | 0$ | 32,177,269$ | 101 | 180,887$ | 18,269,587$ | 19,078,887$ | 22,430,000$ | 12,430,000$ | 23,000,000$ | 570,000$ | 248,731,074$ | 261,829,456$ |
| 10 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 55 | 35 | 25 | 180 | 49182 | 43365 | 13723 | 26283 | 8590 | 91.08% | 96.37% | 76.24% | 73.01% | 95.44% | 32 | 15683 - 87.13% | 1,082,327$ | 9,740,945$ | 18000 | 100 | 20,790,000$ | 20,790,000$ | 0$ | 3,902,979$ | 20,790,000$ | 3,902,979$ | 20 | 0 | 0$ | 34,634,471$ | 101 | 167,661$ | 16,933,761$ | 17,705,961$ | 20,790,000$ | 10,790,000$ | 23,000,000$ | 2,210,000$ | 277,178,083$ | 294,106,593$ |
| 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,951,491$ | 21,655,000$ | 3,951,491$ | 21 | 0 | 0$ | 31,279,648$ | 101 | 174,637$ | 17,638,337$ | 18,127,937$ | 21,655,000$ | 11,655,000$ | 23,000,000$ | 1,345,000$ | 232,776,657$ | 245,928,368$ |
| 12 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 40 | 25 | 15 | 130 | 46872 | 38724 | 15711 | 31308 | 7717 | 97.65% | 96.81% | 98.19% | 97.84% | 96.46% | 33 | 17542 - 97.45% | 866,246$ | 6,929,965$ | 18000 | 100 | 14,263,000$ | 14,263,000$ | 0$ | 2,629,346$ | 14,263,000$ | 2,629,346$ | 21 | 0 | 0$ | 28,586,106$ | 101 | 115,024$ | 11,617,424$ | 12,103,024$ | 14,263,000$ | 4,263,000$ | 23,000,000$ | 8,737,000$ | 223,724,792$ | 240,207,874$ |
| 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,539,953$ | 19,085,000$ | 3,539,953$ | 21 | 0 | 0$ | 32,065,502$ | 101 | 153,911$ | 15,545,011$ | 15,897,611$ | 19,085,000$ | 9,085,000$ | 23,000,000$ | 3,915,000$ | 238,748,983$ | 254,916,874$ |
| 14 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 41643 | 33708 | 13019 | 27624 | 6700 | 77.12% | 74.91% | 72.33% | 76.73% | 74.44% | 32 | 13633 - 75.74% | 963,672$ | 8,673,045$ | 18000 | 100 | 20,275,000$ | 20,275,000$ | 0$ | 3,760,684$ | 20,275,000$ | 3,760,684$ | 22 | 0 | 0$ | 30,837,493$ | 101 | 163,508$ | 16,514,308$ | 17,077,508$ | 20,275,000$ | 10,275,000$ | 23,000,000$ | 2,725,000$ | 14,782,825$ | 28,542,810$ |
| 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$ | 4,069,137$ | 21,938,000$ | 4,069,137$ | 21 | 0 | 0$ | 28,999,620$ | 101 | 176,919$ | 17,868,819$ | 18,572,619$ | 21,938,000$ | 11,938,000$ | 23,000,000$ | 1,062,000$ | 225,226,134$ | 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,367,453$ | 18,155,000$ | 3,367,453$ | 20 | 0 | 0$ | 32,944,033$ | 101 | 146,411$ | 14,787,511$ | 15,560,211$ | 18,155,000$ | 8,155,000$ | 23,000,000$ | 4,845,000$ | 242,750,456$ | 260,134,278$ |
| 17 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 41480 | 33233 | 13381 | 26473 | 6862 | 76.81% | 73.85% | 74.34% | 73.54% | 76.24% | 32 | 13492 - 74.96% | 960,504$ | 8,644,540$ | 18000 | 100 | 17,680,000$ | 17,680,000$ | 0$ | 3,279,363$ | 17,680,000$ | 3,279,363$ | 20 | 0 | 0$ | 30,736,142$ | 101 | 142,581$ | 14,400,681$ | 14,959,281$ | 17,680,000$ | 7,680,000$ | 23,000,000$ | 5,320,000$ | 233,942,299$ | 249,719,160$ |
| 18 | San Jose Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 41505 | 33038 | 13819 | 28431 | 6793 | 76.86% | 73.42% | 76.77% | 78.98% | 75.48% | 32 | 13732 - 76.29% | 965,091$ | 8,685,820$ | 18000 | 100 | 19,770,000$ | 19,770,000$ | 0$ | 3,732,737$ | 19,770,000$ | 3,732,737$ | 21 | 0 | 0$ | 30,882,916$ | 101 | 159,435$ | 16,102,935$ | 17,241,035$ | 19,770,000$ | 9,770,000$ | 23,000,000$ | 3,230,000$ | 48,938,750$ | 62,580,631$ |
| 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 | 22,410,000$ | 22,410,000$ | 0$ | 4,022,828$ | 22,410,000$ | 4,022,828$ | 21 | 0 | 0$ | 31,132,344$ | 101 | 180,726$ | 18,253,326$ | 19,231,126$ | 22,410,000$ | 12,410,000$ | 23,000,000$ | 590,000$ | 252,108,873$ | 264,010,091$ |
| 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,960,525$ | 20,935,000$ | 3,960,525$ | 21 | 0 | 0$ | 31,528,344$ | 101 | 168,831$ | 17,051,931$ | 17,905,531$ | 20,935,000$ | 10,935,000$ | 23,000,000$ | 2,065,000$ | 13,994,194$ | 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$ | 4,007,939$ | 21,475,000$ | 4,007,939$ | 21 | 0 | 0$ | 35,189,600$ | 101 | 173,185$ | 17,491,685$ | 17,978,085$ | 21,475,000$ | 11,475,000$ | 23,000,000$ | 1,525,000$ | 267,601,451$ | 284,812,966$ |
| 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,811,698$ | 20,550,000$ | 3,811,698$ | 21 | 0 | 0$ | 31,573,472$ | 101 | 165,726$ | 16,738,326$ | 17,218,826$ | 20,550,000$ | 10,550,000$ | 23,000,000$ | 2,450,000$ | 240,660,608$ | 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,978,632$ | 21,450,000$ | 3,978,632$ | 20 | 0 | 0$ | 31,913,042$ | 101 | 172,984$ | 17,471,384$ | 18,337,684$ | 21,450,000$ | 11,450,000$ | 23,000,000$ | 1,550,000$ | 270,172,146$ | 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,407,260$ | 18,350,000$ | 3,407,260$ | 20 | 0 | 0$ | 31,645,226$ | 101 | 147,984$ | 14,946,384$ | 15,769,984$ | 18,350,000$ | 8,350,000$ | 23,000,000$ | 4,650,000$ | 250,986,081$ | 266,861,323$ |