| 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 52,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Boston Bruins | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 96950 | 82915 | 48135 | 83456 | 21219 | 98.93% | 98.71% | 99.66% | 99.35% | 97.78% | 27 | 23763 - 99.01% | 2,166,346$ | 30,328,849$ | 24000 | 110 | 62,000,000$ | 62,000,000$ | 0$ | 19,681,767$ | 480,620$ | 19,300,385$ | 20 | 0 | 0$ | 58,491,352$ | 88 | 489,922$ | 43,113,136$ | 44,942,740$ | 61,594,945$ | 9,594,945$ | 75,000,000$ | 13,405,055$ | 80,844,677$ | 98,697,711$ |
| 2 | Buffalo Sabres | 7050 | 6400 | 3750 | 6100 | 1700 | 150 | 100 | 70 | 50 | 250 | 98300 | 87095 | 51374 | 84901 | 22606 | 99.59% | 97.20% | 97.86% | 99.42% | 94.98% | 27 | 24591 - 98.36% | 2,243,225$ | 31,405,146$ | 25000 | 110 | 73,550,000$ | 73,550,000$ | 0$ | 24,176,343$ | 570,155$ | 23,381,797$ | 20 | 0 | 0$ | 60,567,067$ | 88 | 589,535$ | 51,879,080$ | 53,743,276$ | 73,555,437$ | 21,555,437$ | 75,000,000$ | 1,444,563$ | 109,268,526$ | 120,391,809$ |
| 3 | Calgary Flames | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 97659 | 83611 | 48132 | 83481 | 21412 | 99.65% | 99.54% | 99.65% | 99.38% | 98.67% | 27 | 23878 - 99.49% | 2,180,022$ | 30,520,303$ | 24000 | 110 | 73,900,000$ | 73,900,000$ | 0$ | 23,484,505$ | 572,868$ | 23,166,678$ | 21 | 0 | 0$ | 58,860,584$ | 88 | 580,620$ | 51,094,560$ | 53,481,040$ | 73,579,062$ | 21,579,062$ | 75,000,000$ | 1,420,938$ | 91,250,079$ | 100,943,518$ |
| 4 | Chicago Blackhawks | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 88380 | 75176 | 42250 | 75295 | 17550 | 99.98% | 99.70% | 100.00% | 99.86% | 100.00% | 28 | 22973 - 99.88% | 2,084,746$ | 27,101,698$ | 23000 | 110 | 69,250,000$ | 69,250,000$ | 0$ | 23,228,301$ | 536,822$ | 22,910,470$ | 21 | 1 | 0$ | 58,372,888$ | 88 | 544,574$ | 47,922,512$ | 50,208,712$ | 70,150,806$ | 18,150,806$ | 75,000,000$ | 4,849,194$ | 81,767,454$ | 94,255,288$ |
| 5 | Detroit Red Wings | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 88400 | 75303 | 42250 | 75391 | 17550 | 100.00% | 99.87% | 100.00% | 99.99% | 100.00% | 28 | 22992 - 99.96% | 2,086,086$ | 27,119,123$ | 23000 | 110 | 68,850,000$ | 68,850,000$ | 0$ | 23,318,215$ | 533,721$ | 23,016,291$ | 21 | 1 | 0$ | 58,410,419$ | 88 | 541,085$ | 47,615,480$ | 49,860,096$ | 69,983,739$ | 17,983,739$ | 75,000,000$ | 5,016,261$ | 48,240,315$ | 61,110,961$ |
| 6 | Edmonton Oilers | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 88400 | 75400 | 42250 | 75400 | 17550 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 28 | 23000 - 100.00% | 2,086,750$ | 27,127,750$ | 23000 | 110 | 75,000,000$ | 75,000,000$ | 0$ | 24,091,461$ | 581,395$ | 23,773,630$ | 20 | 0 | 0$ | 58,429,000$ | 88 | 589,147$ | 51,844,936$ | 55,134,120$ | 74,936,390$ | 22,936,390$ | 75,000,000$ | 63,610$ | 69,700,579$ | 77,314,042$ |
| 7 | Hartford Whalers | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 97834 | 83718 | 48223 | 83717 | 21629 | 99.83% | 99.66% | 99.84% | 99.66% | 99.67% | 27 | 23937 - 99.74% | 2,186,662$ | 30,613,268$ | 24000 | 110 | 73,300,000$ | 73,300,000$ | 0$ | 23,710,095$ | 568,217$ | 23,296,897$ | 20 | 0 | 0$ | 59,039,874$ | 88 | 578,295$ | 50,889,960$ | 53,856,132$ | 73,299,993$ | 21,299,993$ | 75,000,000$ | 1,700,007$ | 62,881,267$ | 72,390,794$ |
| 8 | Los Angeles Kings | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 88185 | 75311 | 42250 | 75322 | 17550 | 99.76% | 99.88% | 100.00% | 99.90% | 100.00% | 28 | 22971 - 99.87% | 2,083,804$ | 27,089,457$ | 23000 | 110 | 73,850,000$ | 73,850,000$ | 0$ | 23,775,597$ | 572,481$ | 23,457,765$ | 20 | 0 | 0$ | 58,346,523$ | 88 | 580,233$ | 51,060,504$ | 53,785,912$ | 73,836,093$ | 21,836,093$ | 75,000,000$ | 1,163,907$ | 96,260,826$ | 105,153,650$ |
| 9 | Montreal Canadiens | 10400 | 6800 | 5250 | 6700 | 1900 | 150 | 100 | 70 | 50 | 250 | 108160 | 82162 | 54600 | 80180 | 20382 | 80.00% | 92.94% | 80.00% | 92.06% | 82.52% | 28 | 26576 - 85.59% | 2,443,207$ | 31,761,695$ | 31050 | 110 | 68,550,000$ | 68,550,000$ | 0$ | 23,907,366$ | 531,395$ | 23,589,534$ | 19 | 1 | 0$ | 68,409,805$ | 88 | 539,147$ | 47,444,936$ | 50,415,892$ | 70,352,294$ | 18,352,294$ | 75,000,000$ | 4,647,706$ | 186,332,054$ | 208,660,162$ |
| 10 | New York Rangers | 7800 | 7400 | 5000 | 7600 | 2200 | 150 | 100 | 70 | 50 | 250 | 98064 | 84686 | 52072 | 82119 | 22880 | 96.71% | 88.03% | 80.11% | 83.12% | 80.00% | 28 | 26140 - 87.13% | 2,396,293$ | 31,151,811$ | 30000 | 110 | 73,325,000$ | 73,325,000$ | 0$ | 23,883,716$ | 568,411$ | 23,573,838$ | 22 | 0 | 0$ | 67,096,208$ | 88 | 575,969$ | 50,685,272$ | 53,331,100$ | 73,594,006$ | 21,594,006$ | 75,000,000$ | 1,405,994$ | 164,637,378$ | 182,717,251$ |
| 11 | Ottawa Senators | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 95122 | 81126 | 45500 | 80798 | 18900 | 99.92% | 99.91% | 100.00% | 99.50% | 100.00% | 27 | 22960 - 99.83% | 2,084,370$ | 29,181,180$ | 23000 | 110 | 72,650,000$ | 72,650,000$ | 0$ | 23,902,329$ | 563,178$ | 22,948,833$ | 21 | 0 | 0$ | 56,277,990$ | 88 | 586,434$ | 51,606,192$ | 54,264,164$ | 72,508,497$ | 20,508,497$ | 75,000,000$ | 2,491,503$ | 34,995,269$ | 41,350,782$ |
| 12 | Philadelphia Flyers | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 88400 | 75400 | 42250 | 75381 | 17550 | 100.00% | 100.00% | 100.00% | 99.97% | 100.00% | 28 | 22999 - 99.99% | 2,086,688$ | 27,126,942$ | 23000 | 110 | 72,900,000$ | 72,900,000$ | 0$ | 23,496,893$ | 565,116$ | 23,083,731$ | 24 | 0 | 0$ | 58,427,260$ | 88 | 575,194$ | 50,617,072$ | 52,827,188$ | 72,813,939$ | 20,813,939$ | 75,000,000$ | 2,186,061$ | 82,452,444$ | 92,227,833$ |
| 13 | Pittsburgh Penguins | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 88400 | 75366 | 42250 | 75400 | 17550 | 100.00% | 99.95% | 100.00% | 100.00% | 100.00% | 28 | 22997 - 99.99% | 2,086,528$ | 27,124,860$ | 23000 | 110 | 68,450,000$ | 68,450,000$ | 0$ | 22,936,058$ | 530,620$ | 22,650,001$ | 21 | 1 | 0$ | 58,422,775$ | 88 | 537,597$ | 47,308,536$ | 49,964,760$ | 69,344,561$ | 17,344,561$ | 75,000,000$ | 5,655,439$ | 54,015,225$ | 66,784,138$ |
| 14 | Quebec Nordiques | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 97902 | 83433 | 48216 | 83706 | 21346 | 99.90% | 99.33% | 99.83% | 99.65% | 98.37% | 27 | 23900 - 99.58% | 2,181,192$ | 30,536,692$ | 24000 | 110 | 67,300,000$ | 67,300,000$ | 0$ | 21,707,737$ | 521,705$ | 21,389,905$ | 21 | 0 | 0$ | 58,892,192$ | 88 | 529,457$ | 46,592,216$ | 49,033,988$ | 67,299,945$ | 15,299,945$ | 75,000,000$ | 7,700,055$ | 69,456,355$ | 83,640,924$ |
| 15 | San Jose Sharks | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 90202 | 77605 | 44470 | 77532 | 20024 | 99.12% | 99.49% | 99.15% | 99.40% | 99.37% | 28 | 23833 - 99.31% | 2,176,412$ | 28,293,355$ | 24000 | 110 | 74,850,000$ | 74,850,000$ | 0$ | 24,089,526$ | 580,233$ | 23,581,002$ | 20 | 0 | 0$ | 60,939,534$ | 88 | 592,636$ | 52,151,968$ | 54,808,192$ | 74,641,506$ | 22,641,506$ | 75,000,000$ | 358,494$ | 59,747,055$ | 70,188,812$ |
| 16 | St.Louis Blues | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 90437 | 76922 | 44606 | 77603 | 19869 | 99.38% | 98.62% | 99.46% | 99.49% | 98.61% | 28 | 23803 - 99.18% | 2,172,572$ | 28,243,433$ | 24000 | 110 | 60,100,000$ | 60,100,000$ | 0$ | 22,634,483$ | 465,891$ | 22,348,461$ | 23 | 2 | 0$ | 60,832,010$ | 88 | 472,868$ | 41,612,384$ | 44,621,428$ | 63,346,869$ | 11,346,869$ | 75,000,000$ | 11,653,131$ | 129,962,947$ | 150,456,346$ |
| 17 | Toronto Maple Leafs | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 88341 | 75385 | 42250 | 75135 | 17550 | 99.93% | 99.98% | 100.00% | 99.65% | 100.00% | 28 | 22974 - 99.89% | 2,085,207$ | 27,107,689$ | 23000 | 110 | 74,150,000$ | 74,150,000$ | 0$ | 23,902,323$ | 574,806$ | 23,266,659$ | 24 | 0 | 0$ | 58,385,792$ | 88 | 590,310$ | 51,947,280$ | 54,370,100$ | 73,849,587$ | 21,849,587$ | 75,000,000$ | 1,150,413$ | 44,937,055$ | 53,272,490$ |
| 18 | Vancouver Canucks | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 90600 | 77521 | 44773 | 77297 | 19955 | 99.56% | 99.39% | 99.83% | 99.10% | 99.03% | 28 | 23857 - 99.41% | 2,179,257$ | 28,330,339$ | 24000 | 110 | 72,550,000$ | 72,550,000$ | 0$ | 23,749,226$ | 562,403$ | 23,113,562$ | 20 | 0 | 0$ | 61,019,192$ | 88 | 577,907$ | 50,855,816$ | 53,498,240$ | 72,605,026$ | 20,605,026$ | 75,000,000$ | 2,394,974$ | 83,729,308$ | 95,567,103$ |
| 19 | Washington Capitals | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 90444 | 77524 | 44752 | 77531 | 20061 | 99.39% | 99.39% | 99.78% | 99.40% | 99.56% | 28 | 23870 - 99.46% | 2,180,148$ | 28,341,926$ | 24000 | 110 | 74,450,000$ | 74,450,000$ | 0$ | 23,311,232$ | 577,132$ | 22,898,066$ | 22 | 0 | 0$ | 61,044,148$ | 88 | 587,209$ | 51,674,392$ | 53,739,240$ | 73,685,682$ | 21,685,682$ | 75,000,000$ | 1,314,318$ | 122,499,417$ | 133,974,387$ |
| 20 | Winnipeg Jets | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 90404 | 77530 | 44769 | 77470 | 19751 | 99.35% | 99.40% | 99.82% | 99.32% | 98.02% | 28 | 23840 - 99.33% | 2,174,606$ | 28,269,878$ | 24000 | 110 | 72,150,000$ | 72,150,000$ | 0$ | 22,813,577$ | 559,302$ | 22,432,156$ | 21 | 0 | 0$ | 60,888,968$ | 88 | 568,605$ | 50,037,240$ | 52,337,240$ | 71,650,732$ | 19,650,732$ | 75,000,000$ | 3,349,268$ | 76,542,716$ | 89,402,394$ |