| 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 Average Salaries | 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 50,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 23831 | 20000 | 8000 | 16000 | 4000 | 99.30% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 17958 - 99.77% | 1,582,219$ | 6,328,875$ | 18000 | 100 | 80,227,776$ | 74,186,109$ | 0$ | 8,676,901$ | 80,227,776$ | 8,467,224$ | 23 | 0 | 0$ | 58,542,094$ | 111 | 663,127$ | 73,607,097$ | 77,111,478$ | 80,227,776$ | 30,227,776$ | 83,500,000$ | 3,272,224$ | 7,568,017$ | -11,001,367$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 175 | 100 | 75 | 50 | 350 | 23254 | 19215 | 8000 | 15613 | 3824 | 96.89% | 96.08% | 100.00% | 97.58% | 95.60% | 37 | 17477 - 97.09% | 2,721,875$ | 10,887,500$ | 18000 | 100 | 82,638,000$ | 71,679,667$ | 0$ | 8,722,128$ | 82,638,000$ | 8,591,075$ | 20 | 0 | 0$ | 100,709,375$ | 111 | 676,516$ | 75,093,276$ | 80,165,754$ | 82,638,000$ | 32,638,000$ | 83,500,000$ | 862,000$ | 13,599,857$ | 34,143,478$ |
| 3 | Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 70 | 45 | 35 | 300 | 23419 | 19980 | 8000 | 16000 | 4000 | 97.58% | 99.90% | 100.00% | 100.00% | 100.00% | 37 | 17850 - 99.17% | 1,977,775$ | 7,911,100$ | 18000 | 100 | 72,225,557$ | 70,611,667$ | 0$ | 7,905,846$ | 72,225,557$ | 7,486,487$ | 21 | 1 | 0$ | 73,177,675$ | 111 | 614,722$ | 68,234,142$ | 71,841,420$ | 72,225,557$ | 22,225,557$ | 83,500,000$ | 11,274,443$ | 10,302,730$ | 11,638,985$ |
| 4 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 50 | 25 | 180 | 23493 | 20000 | 8000 | 16000 | 4000 | 97.89% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 17873 - 99.30% | 1,892,695$ | 7,570,781$ | 18000 | 100 | 79,743,458$ | 78,036,665$ | 0$ | 8,549,720$ | 79,743,458$ | 8,261,406$ | 21 | 0 | 0$ | 70,029,724$ | 111 | 665,270$ | 73,844,970$ | 78,041,769$ | 79,743,458$ | 29,743,458$ | 83,500,000$ | 3,756,542$ | 36,707,105$ | 28,695,060$ |
| 5 | Bruins | 6500 | 5500 | 2500 | 4500 | 2000 | 301 | 278 | 230 | 100 | 500 | 11706 | 8800 | 4000 | 7346 | 3200 | 45.02% | 40.00% | 40.00% | 40.81% | 40.00% | 37 | 8763 - 41.73% | 2,882,658$ | 11,530,632$ | 21000 | 100 | 84,195,832$ | 78,634,999$ | 0$ | 8,836,100$ | 84,195,832$ | 8,731,256$ | 22 | 0 | 0$ | 106,658,346$ | 111 | 687,063$ | 76,263,993$ | 80,948,193$ | 84,195,832$ | 34,195,832$ | 83,500,000$ | -695,832$ | 30,551,106$ | 56,261,259$ |
| 6 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 350 | 300 | 250 | 100 | 500 | 12180 | 10000 | 4000 | 8613 | 3116 | 40.60% | 40.00% | 40.00% | 43.07% | 62.32% | 36 | 7582 - 42.12% | 2,670,575$ | 13,352,875$ | 18000 | 100 | 77,015,125$ | 66,965,125$ | 0$ | 8,598,356$ | 77,015,125$ | 8,074,170$ | 21 | 0 | 0$ | 96,140,700$ | 111 | 661,412$ | 73,416,732$ | 77,236,020$ | 77,015,125$ | 27,015,125$ | 83,500,000$ | 6,484,875$ | 38,035,473$ | 56,940,153$ |
| 7 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 80 | 70 | 50 | 300 | 23755 | 19913 | 8000 | 15487 | 4000 | 98.98% | 99.57% | 100.00% | 96.79% | 100.00% | 37 | 17789 - 98.83% | 2,106,450$ | 8,425,800$ | 18000 | 100 | 66,943,105$ | 66,943,056$ | 0$ | 7,211,779$ | 66,943,105$ | 7,106,936$ | 19 | 1 | 0$ | 77,938,650$ | 111 | 547,928$ | 60,820,008$ | 64,131,915$ | 66,943,105$ | 16,943,105$ | 83,500,000$ | 16,556,895$ | 15,827,140$ | 29,633,875$ |
| 8 | Flames | 6250 | 5250 | 2500 | 4500 | 1500 | 155 | 125 | 75 | 65 | 300 | 24673 | 18585 | 9048 | 10504 | 4894 | 98.69% | 88.50% | 90.48% | 58.36% | 81.57% | 37 | 16926 - 84.63% | 2,805,313$ | 11,221,250$ | 20000 | 100 | 55,414,166$ | 49,720,000$ | 0$ | 6,202,698$ | 55,414,166$ | 5,678,499$ | 20 | 0 | 0$ | 103,796,562$ | 111 | 487,211$ | 54,080,421$ | 57,804,249$ | 55,414,166$ | 5,414,166$ | 83,500,000$ | 28,085,834$ | 43,215,078$ | 89,207,391$ |
| 9 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 240 | 160 | 90 | 70 | 500 | 14699 | 12174 | 8000 | 9961 | 2558 | 61.25% | 60.87% | 100.00% | 62.26% | 63.95% | 37 | 11848 - 65.82% | 2,553,710$ | 10,214,838$ | 18000 | 100 | 67,619,751$ | 66,876,001$ | 0$ | 7,260,541$ | 66,719,751$ | 6,956,505$ | 22 | 1 | 0$ | 94,487,252$ | 111 | 561,450$ | 62,320,950$ | 65,145,900$ | 66,719,751$ | 16,719,751$ | 83,500,000$ | 16,780,249$ | 20,699,698$ | 50,041,050$ |
| 10 | Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 130 | 80 | 60 | 30 | 220 | 24000 | 19981 | 8000 | 16000 | 4000 | 100.00% | 99.91% | 100.00% | 100.00% | 100.00% | 37 | 17995 - 99.97% | 2,049,525$ | 8,198,100$ | 18000 | 100 | 79,542,500$ | 71,292,500$ | 0$ | 8,653,645$ | 79,542,500$ | 8,339,136$ | 21 | 0 | 0$ | 75,832,425$ | 111 | 665,665$ | 73,888,815$ | 77,687,568$ | 79,542,500$ | 29,542,500$ | 83,500,000$ | 3,957,500$ | 7,389,951$ | 5,534,808$ |
| 11 | Islanders | 6500 | 5500 | 2500 | 4000 | 1500 | 350 | 300 | 250 | 100 | 500 | 10485 | 8800 | 4000 | 6739 | 2528 | 40.33% | 40.00% | 40.00% | 42.12% | 42.13% | 37 | 8138 - 40.69% | 2,889,891$ | 11,559,563$ | 20000 | 100 | 79,415,833$ | 73,222,083$ | 0$ | 8,246,012$ | 79,415,833$ | 8,062,543$ | 21 | 0 | 0$ | 106,925,958$ | 111 | 654,563$ | 72,656,493$ | 87,592,764$ | 79,415,833$ | 29,415,833$ | 83,500,000$ | 4,084,167$ | 19,825,819$ | 39,159,013$ |
| 12 | Jets | 6200 | 5000 | 2000 | 4000 | 1800 | 180 | 125 | 95 | 50 | 225 | 22732 | 18955 | 7226 | 14423 | 5157 | 91.66% | 94.78% | 90.33% | 90.14% | 71.63% | 37 | 17123 - 90.12% | 2,784,300$ | 11,137,201$ | 19000 | 100 | 81,873,811$ | 74,673,809$ | 0$ | 8,678,702$ | 81,873,811$ | 8,453,306$ | 20 | 1 | 0$ | 103,019,109$ | 111 | 677,611$ | 75,214,821$ | 80,899,131$ | 81,873,811$ | 31,873,811$ | 83,500,000$ | 1,626,189$ | 8,647,370$ | 30,767,348$ |
| 13 | Kings | 6500 | 5500 | 2500 | 4500 | 1000 | 200 | 100 | 50 | 40 | 270 | 13698 | 14687 | 7066 | 12663 | 3000 | 70.25% | 89.01% | 94.21% | 93.80% | 100.00% | 38 | 17038 - 85.19% | 2,449,217$ | 7,347,650$ | 20000 | 100 | 80,834,761$ | 71,334,761$ | 0$ | 8,515,800$ | 80,834,761$ | 8,384,747$ | 21 | 0 | 0$ | 93,070,233$ | 111 | 661,974$ | 73,479,114$ | 79,106,925$ | 80,834,761$ | 30,834,761$ | 83,500,000$ | 2,665,239$ | 10,835,509$ | 24,798,817$ |
| 14 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 100 | 80 | 40 | 275 | 23375 | 19883 | 8000 | 15975 | 4000 | 97.40% | 99.42% | 100.00% | 99.84% | 100.00% | 37 | 17808 - 98.93% | 2,460,485$ | 9,841,938$ | 18000 | 100 | 79,209,167$ | 79,659,167$ | 0$ | 8,411,441$ | 79,209,167$ | 8,254,191$ | 21 | 0 | 0$ | 91,037,926$ | 111 | 650,880$ | 72,247,680$ | 75,671,697$ | 79,209,167$ | 29,209,167$ | 83,500,000$ | 4,290,833$ | 30,004,065$ | 45,370,294$ |
| 15 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 125 | 75 | 50 | 500 | 17119 | 18661 | 8000 | 15697 | 2488 | 71.33% | 93.31% | 100.00% | 98.11% | 62.20% | 37 | 15491 - 86.06% | 2,620,399$ | 10,481,594$ | 18000 | 100 | 79,614,173$ | 62,034,507$ | 0$ | 9,037,173$ | 79,614,173$ | 8,381,930$ | 20 | 1 | 0$ | 96,954,744$ | 111 | 692,453$ | 76,862,283$ | 83,964,396$ | 79,614,173$ | 29,614,173$ | 83,500,000$ | 3,885,827$ | 5,521,345$ | 18,511,693$ |
| 16 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 70 | 45 | 35 | 220 | 23829 | 20000 | 8000 | 15925 | 4000 | 99.29% | 100.00% | 100.00% | 99.53% | 100.00% | 37 | 17939 - 99.66% | 1,818,302$ | 7,273,207$ | 18000 | 100 | 79,406,333$ | 78,356,333$ | 0$ | 8,644,749$ | 79,406,333$ | 8,330,236$ | 21 | 0 | 0$ | 67,277,165$ | 111 | 664,567$ | 73,766,937$ | 76,175,970$ | 79,406,333$ | 29,406,333$ | 83,500,000$ | 4,093,667$ | 20,162,780$ | 11,263,975$ |
| 17 | Penguins | 4000 | 4500 | 5500 | 7000 | 3000 | 120 | 100 | 65 | 25 | 150 | 16000 | 18000 | 18700 | 23800 | 10200 | 100.00% | 100.00% | 85.00% | 85.00% | 85.00% | 37 | 21675 - 90.31% | 2,206,406$ | 8,825,624$ | 24000 | 100 | 81,814,864$ | 74,162,626$ | 0$ | 8,586,670$ | 81,814,864$ | 8,357,634$ | 22 | 0 | 0$ | 81,637,022$ | 111 | 669,878$ | 74,356,458$ | 81,820,875$ | 81,814,864$ | 31,814,864$ | 83,500,000$ | 1,685,136$ | 22,376,941$ | 22,193,088$ |
| 18 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 120 | 100 | 50 | 300 | 23242 | 18317 | 6700 | 15551 | 4000 | 96.84% | 91.59% | 83.75% | 97.19% | 100.00% | 37 | 16953 - 94.18% | 2,603,715$ | 10,414,861$ | 18000 | 100 | 78,376,254$ | 74,901,254$ | 0$ | 8,019,130$ | 78,376,254$ | 7,856,630$ | 23 | 0 | 0$ | 96,337,464$ | 111 | 644,567$ | 71,546,937$ | 75,739,074$ | 78,376,254$ | 28,376,254$ | 83,500,000$ | 5,123,746$ | 38,437,849$ | 59,036,239$ |
| 19 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 154 | 82 | 65 | 44 | 306 | 17321 | 14869 | 6000 | 12000 | 3000 | 96.23% | 99.13% | 100.00% | 100.00% | 100.00% | 38 | 17730 - 98.50% | 2,384,455$ | 7,153,365$ | 18000 | 100 | 79,220,833$ | 76,233,333$ | 0$ | 8,452,785$ | 79,220,833$ | 8,368,922$ | 21 | 0 | 0$ | 90,609,290$ | 111 | 645,329$ | 71,631,519$ | 78,005,916$ | 79,220,833$ | 29,220,833$ | 83,500,000$ | 4,279,167$ | 15,617,103$ | 28,220,477$ |
| 20 | Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 160 | 78 | 45 | 35 | 260 | 22617 | 19771 | 8000 | 15982 | 4000 | 94.24% | 98.86% | 100.00% | 99.89% | 100.00% | 37 | 17593 - 97.74% | 2,225,071$ | 8,900,284$ | 18000 | 100 | 73,781,389$ | 68,918,889$ | 0$ | 7,965,190$ | 73,781,389$ | 7,771,233$ | 22 | 0 | 0$ | 82,327,627$ | 111 | 609,931$ | 67,702,341$ | 70,086,399$ | 73,781,389$ | 23,781,389$ | 83,500,000$ | 9,718,611$ | 25,756,652$ | 37,997,880$ |
| 21 | Sharks | 6000 | 5000 | 3000 | 4000 | 2000 | 90 | 75 | 60 | 50 | 150 | 24000 | 19807 | 9565 | 15547 | 5442 | 100.00% | 99.04% | 79.71% | 97.17% | 68.03% | 37 | 18590 - 92.95% | 1,816,586$ | 7,266,344$ | 20000 | 100 | 66,862,503$ | 59,462,503$ | 0$ | 7,273,083$ | 66,862,503$ | 6,911,391$ | 19 | 1 | 0$ | 67,213,682$ | 111 | 567,036$ | 62,940,996$ | 66,853,746$ | 66,862,503$ | 16,862,503$ | 83,500,000$ | 16,637,497$ | 3,114,245$ | 3,474,181$ |
| 22 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 300 | 200 | 150 | 100 | 500 | 15173 | 12438 | 5811 | 8772 | 3209 | 50.58% | 49.75% | 58.11% | 43.86% | 64.18% | 36 | 9081 - 50.45% | 2,598,212$ | 12,991,062$ | 18000 | 100 | 71,288,462$ | 73,113,462$ | 0$ | 7,840,729$ | 71,288,462$ | 7,473,791$ | 20 | 0 | 0$ | 93,535,646$ | 111 | 603,133$ | 66,947,763$ | 69,384,546$ | 71,288,462$ | 21,288,462$ | 83,500,000$ | 12,211,538$ | 19,865,944$ | 44,017,044$ |