| 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 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 35,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 | 63145 | 51274 | 20790 | 40558 | 10470 | 95.67% | 93.23% | 94.50% | 92.18% | 95.18% | 29 | 16931 - 94.06% | 1,382,775$ | 15,210,520$ | 18000 | 100 | 59,415,000$ | 52,665,000$ | 0$ | 17,382,561$ | 300,076$ | 17,139,516$ | 22 | 1 | 0$ | 40,100,462$ | 143 | 304,495$ | 43,542,785$ | 45,478,599$ | 60,050,384$ | 25,050,384$ | 118,985,495$ | 58,935,111$ | 52,985,495$ | 52,532,208$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 64708 | 52850 | 20902 | 42971 | 10537 | 98.04% | 96.09% | 95.01% | 97.66% | 95.79% | 29 | 17452 - 96.95% | 1,417,118$ | 15,588,303$ | 18000 | 100 | 62,950,000$ | 42,271,000$ | 0$ | 17,955,801$ | 317,929$ | 17,539,139$ | 20 | 0 | 0$ | 41,096,435$ | 143 | 325,505$ | 46,547,215$ | 48,629,029$ | 63,002,986$ | 28,002,986$ | 66,778,870$ | 3,775,884$ | 778,870$ | -1,671,893$ |
| 3 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 67929 | 58081 | 22528 | 46011 | 11715 | 94.35% | 96.80% | 93.87% | 95.86% | 97.63% | 28 | 17189 - 95.49% | 1,395,287$ | 16,743,443$ | 18000 | 100 | 60,975,000$ | 47,270,000$ | 0$ | 17,672,832$ | 307,955$ | 17,464,539$ | 20 | 0 | 0$ | 39,068,034$ | 143 | 311,742$ | 44,579,106$ | 46,400,456$ | 61,502,104$ | 26,502,104$ | 87,096,649$ | 25,594,545$ | 21,096,649$ | 18,830,356$ |
| 4 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63574 | 52537 | 20947 | 42483 | 10579 | 96.32% | 95.52% | 95.21% | 96.55% | 96.17% | 29 | 17284 - 96.02% | 1,403,067$ | 15,433,738$ | 18000 | 100 | 61,900,000$ | 46,770,000$ | 0$ | 17,425,831$ | 312,626$ | 17,217,491$ | 20 | 0 | 0$ | 40,688,946$ | 143 | 316,414$ | 45,247,202$ | 46,659,606$ | 61,923,009$ | 26,923,009$ | 95,522,675$ | 33,599,666$ | 29,522,675$ | 28,583,594$ |
| 5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62882 | 52940 | 21002 | 43168 | 10714 | 95.28% | 96.25% | 95.46% | 98.11% | 97.40% | 29 | 17337 - 96.32% | 1,403,175$ | 15,434,920$ | 18000 | 100 | 65,175,000$ | 51,925,000$ | 0$ | 18,304,688$ | 329,167$ | 17,749,133$ | 20 | 0 | 0$ | 40,692,062$ | 143 | 339,268$ | 48,515,324$ | 50,492,894$ | 64,820,014$ | 29,820,014$ | 80,073,520$ | 15,253,506$ | 14,073,520$ | 9,407,388$ |
| 6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 68957 | 57533 | 23406 | 46736 | 11440 | 95.77% | 95.89% | 97.53% | 97.37% | 95.33% | 28 | 17339 - 96.33% | 1,401,399$ | 16,816,783$ | 18000 | 100 | 65,900,000$ | 61,745,000$ | 0$ | 18,643,190$ | 332,828$ | 18,087,635$ | 21 | 0 | 1,833,216$ | 39,239,160$ | 143 | 342,929$ | 49,038,847$ | 50,927,065$ | 65,682,039$ | 30,682,039$ | 67,369,611$ | 1,687,572$ | 1,369,611$ | -5,191,041$ |
| 7 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63800 | 51773 | 21113 | 42661 | 10838 | 96.67% | 94.13% | 95.97% | 96.96% | 98.53% | 29 | 17290 - 96.05% | 1,407,125$ | 15,478,378$ | 18000 | 100 | 64,250,000$ | 55,500,000$ | 0$ | 18,305,054$ | 324,495$ | 18,055,036$ | 20 | 1 | 2,883,413$ | 40,806,633$ | 143 | 329,040$ | 47,052,720$ | 48,943,128$ | 64,457,821$ | 29,457,821$ | 67,560,455$ | 3,102,634$ | 1,560,455$ | -1,426,476$ |
| 8 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 61291 | 53710 | 20968 | 43106 | 10361 | 92.87% | 97.65% | 95.31% | 97.97% | 94.19% | 29 | 17221 - 95.67% | 1,383,704$ | 15,220,745$ | 18000 | 100 | 61,900,000$ | 52,650,000$ | 0$ | 17,301,272$ | 292,424$ | 16,882,061$ | 20 | 2 | 0$ | 40,127,419$ | 143 | 317,677$ | 45,427,811$ | 47,078,487$ | 58,698,693$ | 23,698,693$ | 85,368,393$ | 26,669,700$ | 19,368,393$ | 17,514,847$ |
| 9 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63449 | 53489 | 21729 | 43584 | 10710 | 96.13% | 97.25% | 98.77% | 99.05% | 97.36% | 29 | 17542 - 97.46% | 1,416,210$ | 15,578,309$ | 18000 | 100 | 64,425,000$ | 46,700,000$ | 0$ | 18,447,106$ | 325,379$ | 17,891,551$ | 24 | 0 | 0$ | 41,070,087$ | 143 | 335,480$ | 47,973,640$ | 50,186,854$ | 64,420,748$ | 29,420,748$ | 107,277,394$ | 42,856,646$ | 41,277,394$ | 37,236,059$ |
| 10 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 64135 | 52759 | 21125 | 42429 | 10573 | 97.17% | 95.93% | 96.02% | 96.43% | 96.12% | 29 | 17366 - 96.48% | 1,410,709$ | 15,517,800$ | 18000 | 100 | 56,600,000$ | 48,900,000$ | 0$ | 16,446,975$ | 285,859$ | 15,752,544$ | 20 | 0 | 0$ | 40,910,564$ | 143 | 298,485$ | 42,683,355$ | 44,368,487$ | 56,630,381$ | 21,630,381$ | 69,488,774$ | 12,858,393$ | 3,488,774$ | 5,165,053$ |
| 11 | Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 64754 | 52882 | 21442 | 42340 | 10619 | 98.11% | 96.15% | 97.46% | 96.23% | 96.54% | 29 | 17458 - 96.99% | 1,419,841$ | 15,618,253$ | 18000 | 100 | 64,545,000$ | 47,450,000$ | 0$ | 18,289,766$ | 325,985$ | 17,706,937$ | 22 | 0 | 386,361$ | 41,175,394$ | 143 | 336,086$ | 48,060,298$ | 49,656,516$ | 64,322,792$ | 29,322,792$ | 103,786,217$ | 39,463,425$ | 37,786,217$ | 34,408,599$ |
| 12 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63254 | 53464 | 21617 | 42316 | 10625 | 95.84% | 97.21% | 98.26% | 96.17% | 96.59% | 29 | 17389 - 96.60% | 1,408,513$ | 15,493,645$ | 18000 | 100 | 52,195,000$ | 43,325,000$ | 0$ | 14,902,877$ | 263,611$ | 14,347,322$ | 24 | 1 | 0$ | 40,846,882$ | 143 | 273,712$ | 39,140,816$ | 40,924,060$ | 52,043,695$ | 17,043,695$ | 74,554,786$ | 22,511,091$ | 8,554,786$ | 13,520,262$ |
| 13 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 65363 | 53059 | 21226 | 42637 | 10632 | 99.03% | 96.47% | 96.48% | 96.90% | 96.65% | 29 | 17538 - 97.43% | 1,427,576$ | 15,703,335$ | 18000 | 100 | 65,050,000$ | 51,225,000$ | 0$ | 18,713,269$ | 328,535$ | 18,088,253$ | 20 | 0 | 1,717,127$ | 41,399,701$ | 143 | 339,899$ | 48,605,557$ | 51,721,635$ | 65,068,758$ | 30,068,758$ | 68,617,998$ | 3,549,240$ | 2,617,998$ | -2,624,821$ |
| 14 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62964 | 53379 | 21458 | 41871 | 10518 | 95.40% | 97.05% | 97.54% | 95.16% | 95.62% | 29 | 17290 - 96.06% | 1,400,966$ | 15,410,627$ | 18000 | 100 | 61,445,000$ | 48,645,000$ | 0$ | 17,969,136$ | 310,328$ | 17,552,475$ | 22 | 0 | 2,015,691$ | 40,628,017$ | 143 | 317,904$ | 45,460,272$ | 47,359,732$ | 61,929,379$ | 26,929,379$ | 71,433,481$ | 9,504,102$ | 5,433,481$ | 3,638,396$ |
| 15 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63589 | 53531 | 21363 | 43109 | 10386 | 96.35% | 97.33% | 97.10% | 97.98% | 94.42% | 29 | 17453 - 96.96% | 1,408,582$ | 15,494,400$ | 18000 | 100 | 50,195,000$ | 28,695,000$ | 0$ | 14,838,517$ | 253,510$ | 14,421,855$ | 22 | 0 | 0$ | 40,848,873$ | 143 | 261,086$ | 37,335,298$ | 38,831,652$ | 50,673,785$ | 15,673,785$ | 76,017,591$ | 25,343,806$ | 10,017,591$ | 17,121,678$ |
| 16 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63947 | 53126 | 21641 | 42255 | 10559 | 96.89% | 96.59% | 98.37% | 96.03% | 95.99% | 29 | 17412 - 96.73% | 1,412,186$ | 15,534,051$ | 18000 | 100 | 64,595,000$ | 51,745,000$ | 0$ | 18,516,283$ | 326,237$ | 17,919,057$ | 22 | 0 | 0$ | 40,953,407$ | 143 | 337,096$ | 48,204,728$ | 50,351,512$ | 64,570,948$ | 29,570,948$ | 112,200,656$ | 47,629,708$ | 46,200,656$ | 41,919,535$ |
| 17 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63062 | 53948 | 21186 | 42030 | 10611 | 95.55% | 98.09% | 96.30% | 95.52% | 96.46% | 29 | 17349 - 96.38% | 1,406,925$ | 15,476,171$ | 18000 | 100 | 64,300,000$ | 48,100,000$ | 0$ | 18,161,855$ | 324,747$ | 17,762,370$ | 20 | 1 | 1,171,583$ | 40,800,814$ | 143 | 328,788$ | 47,016,684$ | 49,005,058$ | 64,201,191$ | 29,201,191$ | 73,637,852$ | 9,436,661$ | 7,637,852$ | 4,581,403$ |
| 18 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62495 | 52075 | 20815 | 42805 | 10596 | 94.69% | 94.68% | 94.61% | 97.28% | 96.33% | 29 | 17162 - 95.35% | 1,389,603$ | 15,285,628$ | 18000 | 100 | 53,800,000$ | 47,100,000$ | 0$ | 14,465,648$ | 271,717$ | 13,394,946$ | 20 | 0 | 0$ | 40,298,474$ | 143 | 289,394$ | 41,383,342$ | 43,949,292$ | 52,250,477$ | 17,250,477$ | 86,349,828$ | 34,099,351$ | 20,349,828$ | 21,768,661$ |
| 19 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63879 | 52190 | 21022 | 42452 | 10725 | 96.79% | 94.89% | 95.55% | 96.48% | 97.50% | 29 | 17297 - 96.09% | 1,407,325$ | 15,480,576$ | 18000 | 100 | 62,649,999$ | 55,095,000$ | 0$ | 17,525,507$ | 308,838$ | 16,932,072$ | 20 | 1 | 0$ | 40,812,428$ | 143 | 326,515$ | 46,691,645$ | 48,273,263$ | 61,095,906$ | 26,095,906$ | 97,389,701$ | 36,293,795$ | 31,389,701$ | 29,100,104$ |
| 20 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62390 | 53087 | 21195 | 41320 | 10481 | 94.53% | 96.52% | 96.34% | 93.91% | 95.28% | 29 | 17134 - 95.19% | 1,389,957$ | 15,289,532$ | 18000 | 100 | 64,925,000$ | 57,125,000$ | 0$ | 18,424,997$ | 327,904$ | 17,536,109$ | 21 | 0 | 734,628$ | 40,308,766$ | 143 | 338,005$ | 48,334,715$ | 50,613,337$ | 64,426,381$ | 29,426,381$ | 69,669,807$ | 5,243,426$ | 3,669,807$ | -1,478,140$ |
| 21 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62788 | 53313 | 21270 | 42556 | 10667 | 95.13% | 96.93% | 96.68% | 96.72% | 96.97% | 29 | 17327 - 96.26% | 1,402,930$ | 15,432,229$ | 18000 | 100 | 51,500,000$ | 42,225,000$ | 0$ | 14,455,065$ | 260,101$ | 14,177,279$ | 23 | 0 | 0$ | 40,684,967$ | 143 | 265,152$ | 37,916,736$ | 39,667,276$ | 51,371,722$ | 16,371,722$ | 112,440,972$ | 61,069,250$ | 46,440,972$ | 52,499,496$ |
| 22 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 61276 | 52826 | 21349 | 42527 | 10526 | 92.84% | 96.05% | 97.04% | 96.65% | 95.69% | 29 | 17137 - 95.20% | 1,381,333$ | 15,194,662$ | 18000 | 100 | 61,050,000$ | 53,250,000$ | 0$ | 18,031,428$ | 308,333$ | 17,134,964$ | 23 | 0 | 3,294,873$ | 40,058,654$ | 143 | 318,434$ | 45,536,062$ | 47,776,870$ | 61,226,583$ | 26,226,583$ | 86,774,733$ | 25,548,150$ | 20,774,733$ | 18,150,997$ |
| 23 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 69512 | 58818 | 22911 | 46881 | 11621 | 96.54% | 98.03% | 95.46% | 97.67% | 96.84% | 28 | 17479 - 97.10% | 1,416,262$ | 16,995,149$ | 18000 | 100 | 65,650,000$ | 50,700,000$ | 0$ | 18,549,484$ | 331,566$ | 17,630,313$ | 20 | 0 | 19,463,644$ | 39,655,348$ | 143 | 339,141$ | 48,497,163$ | 50,370,489$ | 65,044,251$ | 30,044,251$ | 65,032,320$ | -11,931$ | -967,680$ | -6,629,811$ |
| 24 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62069 | 51913 | 21720 | 42250 | 10723 | 94.04% | 94.39% | 98.73% | 96.02% | 97.48% | 29 | 17152 - 95.29% | 1,388,649$ | 15,275,139$ | 18000 | 100 | 64,200,000$ | 50,950,000$ | 0$ | 17,872,079$ | 324,242$ | 17,455,442$ | 24 | 0 | 0$ | 40,270,821$ | 143 | 331,818$ | 47,449,974$ | 49,572,814$ | 63,822,048$ | 28,822,048$ | 67,519,420$ | 3,697,372$ | 1,519,420$ | -2,711,322$ |
| 25 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 70629 | 58077 | 23253 | 45681 | 11709 | 98.10% | 96.80% | 96.89% | 95.17% | 97.58% | 28 | 17446 - 96.92% | 1,422,665$ | 17,071,979$ | 18000 | 100 | 60,150,000$ | 49,645,000$ | 0$ | 16,958,315$ | 303,788$ | 16,708,340$ | 23 | 0 | 0$ | 39,834,618$ | 143 | 308,333$ | 44,091,619$ | 46,019,695$ | 60,150,024$ | 25,150,024$ | 73,810,925$ | 13,660,901$ | 7,810,925$ | 6,548,197$ |
| 26 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62274 | 53731 | 21522 | 41648 | 10715 | 94.35% | 97.69% | 97.83% | 94.65% | 97.41% | 29 | 17263 - 95.90% | 1,399,731$ | 15,397,040$ | 18000 | 100 | 63,025,000$ | 49,075,000$ | 0$ | 17,742,914$ | 304,419$ | 17,284,587$ | 20 | 1 | 0$ | 40,592,196$ | 143 | 324,621$ | 46,420,803$ | 48,329,023$ | 60,816,504$ | 25,816,504$ | 84,951,895$ | 24,135,391$ | 18,951,895$ | 16,259,304$ |
Admirals
Americans
Barracuda
Condors
Griffins
Heat
Icehogs
Marlies
Moose
Phantoms
Reign
Rocket
Senators
Bears
Comets
Crunch
Devils
Eagles
Little Stars
Penguins
Punishers
Rampage
Sound Tigers
Thunderbirds
Wolfpack
Wolves