| 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 39,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 51122 | 43298 | 17547 | 34748 | 8563 | 94.67% | 96.22% | 97.48% | 96.52% | 95.14% | 31 | 17253 - 95.85% | 1,482,220$ | 13,339,979$ | 18000 | 100 | 63,620,000$ | 63,620,000$ | 0$ | 13,565,248$ | 372,047$ | 13,267,000$ | 23 | 0 | 6,250,875$ | 45,948,817$ | 137 | 380,819$ | 52,172,203$ | 54,386,878$ | 64,237,439$ | 25,237,439$ | 122,524,796$ | 58,287,357$ | 50,024,796$ | 47,416,927$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 45427 | 38251 | 15181 | 30497 | 7714 | 94.64% | 95.63% | 94.88% | 95.30% | 96.43% | 32 | 17134 - 95.19% | 1,478,501$ | 11,828,004$ | 18000 | 100 | 70,750,000$ | 70,750,000$ | 0$ | 14,376,328$ | 413,743$ | 14,078,080$ | 21 | 0 | 9,455,154$ | 47,312,016$ | 137 | 422,515$ | 57,884,555$ | 59,827,610$ | 70,760,871$ | 31,760,871$ | 90,080,861$ | 19,319,990$ | 17,580,861$ | 10,789,783$ |
| 3 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 45655 | 37430 | 15268 | 29523 | 7667 | 95.11% | 93.58% | 95.43% | 92.26% | 95.84% | 32 | 16943 - 94.13% | 1,468,465$ | 11,747,722$ | 18000 | 100 | 69,225,000$ | 69,225,000$ | 0$ | 13,546,058$ | 381,433$ | 13,209,798$ | 23 | 1 | 7,379,362$ | 46,990,888$ | 137 | 409,211$ | 56,061,907$ | 57,929,092$ | 65,466,119$ | 26,466,119$ | 96,285,554$ | 30,819,435$ | 23,785,554$ | 18,557,798$ |
| 4 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 45827 | 39505 | 15461 | 30282 | 7752 | 95.47% | 98.76% | 96.63% | 94.63% | 96.90% | 32 | 17353 - 96.41% | 1,498,644$ | 11,989,153$ | 18000 | 100 | 72,400,000$ | 72,400,000$ | 0$ | 14,588,018$ | 423,392$ | 14,389,186$ | 21 | 0 | 10,390,761$ | 47,956,612$ | 137 | 429,240$ | 58,805,880$ | 60,916,740$ | 72,393,890$ | 33,393,890$ | 85,456,296$ | 13,062,406$ | 12,956,296$ | 5,684,856$ |
| 5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 45336 | 38597 | 15022 | 30481 | 7674 | 94.45% | 96.49% | 93.89% | 95.25% | 95.93% | 32 | 17139 - 95.22% | 1,478,541$ | 11,828,324$ | 18000 | 100 | 70,975,000$ | 70,975,000$ | 0$ | 14,261,987$ | 377,047$ | 13,735,671$ | 21 | 1 | 8,256,474$ | 47,313,296$ | 137 | 423,830$ | 58,064,710$ | 60,079,720$ | 65,391,110$ | 26,391,110$ | 87,223,984$ | 21,832,874$ | 14,723,984$ | 7,576,028$ |
| 6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 45815 | 38978 | 15567 | 30871 | 7818 | 95.45% | 97.45% | 97.29% | 96.47% | 97.73% | 32 | 17381 - 96.56% | 1,498,216$ | 11,985,725$ | 18000 | 100 | 66,050,000$ | 66,050,000$ | 0$ | 13,585,091$ | 386,257$ | 13,386,262$ | 20 | 1 | 4,192,581$ | 47,942,900$ | 137 | 392,105$ | 53,718,385$ | 55,915,105$ | 66,303,471$ | 27,303,471$ | 84,199,235$ | 17,895,764$ | 11,699,235$ | 9,484,734$ |
| 7 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 46214 | 38462 | 15392 | 30713 | 7810 | 96.28% | 96.16% | 96.20% | 95.98% | 97.63% | 32 | 17324 - 96.24% | 1,496,841$ | 11,974,731$ | 18000 | 100 | 72,500,000$ | 72,500,000$ | 0$ | 14,471,352$ | 423,977$ | 14,292,410$ | 21 | 0 | 9,396,760$ | 47,898,924$ | 137 | 429,240$ | 58,805,880$ | 60,767,025$ | 72,377,259$ | 33,377,259$ | 86,432,401$ | 14,055,142$ | 13,932,401$ | 6,675,548$ |
| 8 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 50619 | 42912 | 17356 | 34344 | 8659 | 93.74% | 95.36% | 96.42% | 95.40% | 96.21% | 31 | 17099 - 94.99% | 1,472,268$ | 13,250,415$ | 18000 | 100 | 63,650,000$ | 63,650,000$ | 0$ | 12,854,380$ | 372,222$ | 12,655,548$ | 22 | 0 | 4,221,778$ | 45,640,318$ | 137 | 378,070$ | 51,795,590$ | 53,902,535$ | 63,649,962$ | 24,649,962$ | 99,913,954$ | 36,263,992$ | 27,413,954$ | 24,676,289$ |
| 9 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 46480 | 39201 | 15235 | 31225 | 7898 | 96.83% | 98.00% | 95.22% | 97.58% | 98.73% | 32 | 17505 - 97.25% | 1,511,937$ | 12,095,494$ | 18000 | 100 | 71,100,000$ | 71,100,000$ | 0$ | 14,639,758$ | 415,789$ | 14,158,765$ | 20 | 0 | 8,578,042$ | 48,381,976$ | 137 | 427,485$ | 58,565,445$ | 60,708,300$ | 71,121,858$ | 32,121,858$ | 84,847,145$ | 13,725,287$ | 12,347,145$ | 5,687,125$ |
| 10 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 52686 | 43662 | 17416 | 34276 | 8571 | 97.57% | 97.03% | 96.76% | 95.21% | 95.23% | 31 | 17401 - 96.67% | 1,503,186$ | 13,528,670$ | 18000 | 100 | 68,750,000$ | 68,750,000$ | 0$ | 14,067,262$ | 402,047$ | 13,669,598$ | 21 | 0 | 7,203,980$ | 46,598,752$ | 137 | 413,743$ | 56,682,791$ | 59,059,331$ | 68,750,037$ | 29,750,037$ | 88,631,623$ | 19,881,586$ | 16,131,623$ | 9,359,104$ |
| 11 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 46242 | 37592 | 15504 | 31268 | 7533 | 96.34% | 93.98% | 96.90% | 97.71% | 94.16% | 32 | 17267 - 95.93% | 1,483,563$ | 11,868,506$ | 18000 | 100 | 70,300,000$ | 70,300,000$ | 0$ | 14,749,125$ | 411,111$ | 13,858,767$ | 21 | 0 | 24,616,632$ | 47,474,024$ | 137 | 419,883$ | 57,523,971$ | 59,548,971$ | 70,180,974$ | 31,180,974$ | 73,587,382$ | 3,406,408$ | 1,087,382$ | -5,228,334$ |
| 12 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 46128 | 38514 | 15570 | 30904 | 7632 | 96.10% | 96.29% | 97.31% | 96.58% | 95.40% | 32 | 17344 - 96.35% | 1,492,858$ | 11,942,863$ | 18000 | 100 | 65,350,000$ | 65,350,000$ | 0$ | 14,036,249$ | 382,164$ | 13,738,001$ | 21 | 0 | 7,467,053$ | 47,771,452$ | 137 | 390,936$ | 53,558,232$ | 55,874,832$ | 66,094,469$ | 27,094,469$ | 83,273,443$ | 17,178,974$ | 10,773,443$ | 8,389,539$ |
| 13 | Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 46086 | 38908 | 15585 | 30991 | 7630 | 96.01% | 97.27% | 97.41% | 96.85% | 95.38% | 32 | 17400 - 96.67% | 1,496,623$ | 11,972,984$ | 18000 | 100 | 72,450,000$ | 72,450,000$ | 0$ | 14,364,632$ | 423,684$ | 14,205,547$ | 21 | 1 | 8,636,536$ | 47,891,936$ | 137 | 428,363$ | 58,685,731$ | 61,006,246$ | 72,250,255$ | 33,250,255$ | 90,271,431$ | 18,021,176$ | 17,771,431$ | 10,304,817$ |
| 14 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 46002 | 38406 | 15126 | 30081 | 7717 | 95.84% | 96.02% | 94.54% | 94.00% | 96.46% | 32 | 17167 - 95.37% | 1,486,302$ | 11,890,414$ | 18000 | 100 | 54,150,000$ | 54,150,000$ | 0$ | 11,273,098$ | 316,667$ | 10,875,434$ | 22 | 1 | 0$ | 47,561,656$ | 137 | 328,363$ | 44,985,731$ | 46,797,026$ | 54,258,813$ | 15,258,813$ | 86,204,277$ | 31,945,464$ | 13,704,277$ | 20,166,875$ |
| 15 | Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 52541 | 43279 | 16991 | 34189 | 8607 | 97.30% | 96.18% | 94.39% | 94.97% | 95.63% | 31 | 17290 - 96.05% | 1,496,321$ | 13,466,890$ | 18000 | 100 | 67,450,000$ | 67,450,000$ | 0$ | 13,735,971$ | 394,444$ | 13,238,891$ | 21 | 0 | 5,888,311$ | 46,385,954$ | 137 | 409,064$ | 56,041,768$ | 57,847,123$ | 67,277,719$ | 28,277,719$ | 87,075,599$ | 19,797,880$ | 14,575,599$ | 8,649,362$ |
| 16 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 44159 | 37357 | 15137 | 30364 | 7715 | 92.00% | 93.39% | 94.61% | 94.89% | 96.44% | 32 | 16842 - 93.56% | 1,450,479$ | 11,603,834$ | 18000 | 100 | 69,750,000$ | 69,750,000$ | 0$ | 14,046,442$ | 407,895$ | 13,914,038$ | 20 | 0 | 7,788,721$ | 46,415,336$ | 137 | 411,789$ | 56,415,093$ | 58,563,888$ | 69,795,653$ | 30,795,653$ | 121,737,779$ | 51,942,126$ | 49,237,779$ | 42,529,487$ |
| 17 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 45067 | 38947 | 15177 | 31390 | 7839 | 93.89% | 97.37% | 94.86% | 98.09% | 97.99% | 32 | 17303 - 96.13% | 1,487,751$ | 11,902,005$ | 18000 | 100 | 71,050,000$ | 71,050,000$ | 0$ | 14,285,950$ | 415,497$ | 14,126,898$ | 22 | 0 | 8,548,845$ | 47,608,020$ | 137 | 420,175$ | 57,563,975$ | 60,096,170$ | 71,049,987$ | 32,049,987$ | 95,866,916$ | 24,816,929$ | 23,366,916$ | 16,380,934$ |
| 18 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 46760 | 37843 | 14891 | 30577 | 7605 | 97.42% | 94.61% | 93.07% | 95.55% | 95.06% | 32 | 17210 - 95.61% | 1,489,101$ | 11,912,804$ | 18000 | 100 | 68,475,000$ | 68,475,000$ | 0$ | 14,211,973$ | 400,439$ | 13,516,094$ | 20 | 0 | 6,370,663$ | 47,651,216$ | 137 | 420,906$ | 57,664,122$ | 59,749,062$ | 68,376,237$ | 29,376,237$ | 85,731,018$ | 17,354,781$ | 13,231,018$ | 6,634,120$ |
| 19 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 45146 | 39006 | 15637 | 31598 | 7788 | 94.05% | 97.52% | 97.73% | 98.74% | 97.35% | 32 | 17397 - 96.65% | 1,491,556$ | 11,932,445$ | 18000 | 100 | 69,550,000$ | 69,550,000$ | 0$ | 14,006,584$ | 406,725$ | 13,807,752$ | 21 | 0 | 7,247,775$ | 47,729,780$ | 137 | 412,573$ | 56,522,501$ | 58,239,971$ | 69,529,077$ | 30,529,077$ | 111,228,801$ | 41,699,724$ | 38,728,801$ | 33,992,386$ |
| 20 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 46407 | 38694 | 15619 | 30437 | 7878 | 96.68% | 96.74% | 97.62% | 95.12% | 98.48% | 32 | 17379 - 96.55% | 1,504,020$ | 12,032,162$ | 18000 | 100 | 69,050,000$ | 69,050,000$ | 0$ | 14,084,789$ | 403,801$ | 13,736,849$ | 21 | 0 | 7,759,424$ | 48,128,648$ | 137 | 414,035$ | 56,722,795$ | 59,284,960$ | 69,057,586$ | 30,057,586$ | 80,075,456$ | 11,017,870$ | 7,575,456$ | 1,924,124$ |
| 21 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 44961 | 38834 | 14684 | 30446 | 7502 | 93.67% | 97.09% | 91.78% | 95.14% | 93.78% | 32 | 17053 - 94.74% | 1,468,495$ | 11,747,962$ | 18000 | 100 | 66,300,000$ | 66,300,000$ | 0$ | 13,554,376$ | 387,719$ | 13,256,128$ | 21 | 0 | 6,297,570$ | 46,991,848$ | 137 | 396,491$ | 54,319,267$ | 56,396,242$ | 66,373,631$ | 27,373,631$ | 132,478,064$ | 66,104,433$ | 59,978,064$ | 56,310,954$ |
| 22 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 45175 | 38893 | 15282 | 30474 | 7624 | 94.11% | 97.23% | 95.51% | 95.23% | 95.30% | 32 | 17181 - 95.45% | 1,479,232$ | 11,833,855$ | 18000 | 100 | 67,900,000$ | 67,900,000$ | 0$ | 14,206,726$ | 397,076$ | 13,809,062$ | 21 | 1 | 7,584,042$ | 47,335,420$ | 137 | 408,772$ | 56,001,764$ | 58,831,634$ | 68,208,474$ | 29,208,474$ | 83,651,387$ | 15,442,913$ | 11,151,387$ | 5,270,709$ |
| 23 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 47206 | 38444 | 15438 | 31196 | 7684 | 98.35% | 96.11% | 96.49% | 97.49% | 96.05% | 32 | 17496 - 97.20% | 1,509,645$ | 12,077,162$ | 18000 | 100 | 73,220,000$ | 73,220,000$ | 0$ | 14,687,601$ | 428,187$ | 14,488,770$ | 21 | 0 | 13,132,490$ | 48,308,648$ | 137 | 434,035$ | 59,462,795$ | 61,993,100$ | 73,150,389$ | 34,150,389$ | 85,278,487$ | 12,128,098$ | 12,778,487$ | 4,546,727$ |
| 24 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 52626 | 43481 | 17129 | 35268 | 8947 | 97.46% | 96.62% | 95.16% | 97.97% | 99.41% | 31 | 17495 - 97.19% | 1,512,744$ | 13,614,700$ | 18000 | 100 | 65,850,000$ | 65,850,000$ | 0$ | 12,404,688$ | 385,088$ | 12,106,440$ | 24 | 0 | 1,985,202$ | 46,895,078$ | 137 | 393,860$ | 53,958,820$ | 56,698,780$ | 64,863,496$ | 25,863,496$ | 85,714,332$ | 20,850,836$ | 13,214,332$ | 9,081,850$ |
| 25 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 44547 | 38552 | 15542 | 29989 | 7456 | 92.81% | 96.38% | 97.14% | 93.72% | 93.20% | 32 | 17011 - 94.50% | 1,461,347$ | 11,690,774$ | 18000 | 100 | 70,838,888$ | 70,838,888$ | 0$ | 14,273,812$ | 414,263$ | 14,084,942$ | 21 | 0 | 8,425,457$ | 46,763,096$ | 137 | 419,818$ | 57,515,066$ | 59,600,006$ | 70,838,973$ | 31,838,973$ | 87,231,606$ | 16,392,633$ | 14,731,606$ | 7,543,656$ |
| 26 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 44663 | 36909 | 14902 | 29939 | 7767 | 93.05% | 92.27% | 93.14% | 93.56% | 97.09% | 32 | 16773 - 93.18% | 1,451,527$ | 11,612,216$ | 18000 | 100 | 68,650,000$ | 68,650,000$ | 0$ | 14,070,168$ | 401,462$ | 13,821,628$ | 23 | 0 | 7,759,424$ | 46,448,864$ | 137 | 408,772$ | 56,001,764$ | 58,242,089$ | 68,821,922$ | 29,821,922$ | 86,954,672$ | 18,132,750$ | 14,454,672$ | 8,252,487$ |
Admirals
Americans
Bears
Canucks
Condors
Icehogs
Islander
Little Stars
Moose
Punishers
Roadrunners
Senators
Thunderbirds
Barracuda
Checkers
Comets
Crunch
Eagles
Firebirds
Griffins
Gulls
Marlies
Penguins
Rockets
Wolfpack
Wranglers