| 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 | 45781 | 38441 | 15567 | 30748 | 7659 | 95.38% | 96.10% | 97.29% | 96.09% | 95.74% | 32 | 17275 - 95.97% | 1,487,222$ | 11,897,775$ | 18000 | 100 | 63,620,000$ | 63,620,000$ | 0$ | 12,803,610$ | 372,047$ | 12,522,906$ | 23 | 0 | 6,250,875$ | 47,591,100$ | 139 | 380,819$ | 52,933,841$ | 55,181,326$ | 64,237,439$ | 25,237,439$ | 121,689,184$ | 57,451,745$ | 49,189,184$ | 47,584,649$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 39427 | 33251 | 13234 | 26818 | 6770 | 93.87% | 95.00% | 94.53% | 95.78% | 96.71% | 33 | 17071 - 94.84% | 1,471,699$ | 10,301,896$ | 18000 | 100 | 70,750,000$ | 70,750,000$ | 0$ | 13,531,298$ | 413,743$ | 13,250,594$ | 21 | 0 | 9,455,154$ | 48,566,081$ | 139 | 422,515$ | 58,729,585$ | 60,701,426$ | 70,760,871$ | 31,760,871$ | 89,428,569$ | 18,667,698$ | 16,928,569$ | 10,517,740$ |
| 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$ | 12,727,636$ | 381,433$ | 12,446,932$ | 23 | 1 | 7,379,362$ | 46,990,888$ | 139 | 409,211$ | 56,880,329$ | 58,775,176$ | 65,466,119$ | 26,466,119$ | 96,950,030$ | 31,483,911$ | 24,450,030$ | 18,539,761$ |
| 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$ | 13,729,538$ | 423,392$ | 13,542,402$ | 21 | 0 | 10,390,761$ | 47,956,612$ | 139 | 429,240$ | 59,664,360$ | 61,806,492$ | 72,393,890$ | 33,393,890$ | 86,346,048$ | 13,952,158$ | 13,846,048$ | 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$ | 13,414,327$ | 377,047$ | 12,981,577$ | 21 | 1 | 8,256,474$ | 47,313,296$ | 139 | 423,830$ | 58,912,370$ | 60,957,232$ | 65,391,110$ | 26,391,110$ | 87,937,528$ | 22,546,418$ | 15,437,528$ | 7,642,366$ |
| 6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 40471 | 33978 | 13659 | 26871 | 6899 | 96.36% | 97.08% | 97.56% | 95.97% | 98.56% | 33 | 17411 - 96.73% | 1,504,504$ | 10,531,527$ | 18000 | 100 | 66,650,000$ | 66,650,000$ | 0$ | 12,794,740$ | 389,766$ | 12,607,607$ | 20 | 1 | 4,192,581$ | 49,648,627$ | 139 | 395,614$ | 54,990,346$ | 57,170,975$ | 66,785,081$ | 27,785,081$ | 83,567,311$ | 16,782,230$ | 11,067,311$ | 9,302,667$ |
| 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$ | 13,612,872$ | 423,977$ | 13,444,456$ | 21 | 0 | 9,396,760$ | 47,898,924$ | 139 | 429,240$ | 59,664,360$ | 61,654,559$ | 72,377,259$ | 33,377,259$ | 87,319,935$ | 14,942,676$ | 14,819,935$ | 6,675,548$ |
| 8 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 45216 | 38387 | 15356 | 30344 | 7659 | 94.20% | 95.97% | 95.98% | 94.83% | 95.74% | 32 | 17120 - 95.11% | 1,475,601$ | 11,804,807$ | 18000 | 100 | 63,650,000$ | 63,650,000$ | 0$ | 12,098,240$ | 372,222$ | 11,911,104$ | 22 | 0 | 4,221,778$ | 47,219,228$ | 139 | 378,070$ | 52,551,730$ | 54,689,889$ | 63,649,962$ | 24,649,962$ | 99,255,700$ | 35,605,738$ | 26,755,700$ | 24,809,591$ |
| 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$ | 13,784,788$ | 415,789$ | 13,327,187$ | 20 | 0 | 8,578,042$ | 48,381,976$ | 139 | 427,485$ | 59,420,415$ | 61,595,016$ | 71,121,858$ | 32,121,858$ | 85,559,929$ | 14,438,071$ | 13,059,929$ | 5,705,068$ |
| 10 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 46686 | 39233 | 15416 | 30568 | 7686 | 97.26% | 98.08% | 96.35% | 95.53% | 96.08% | 32 | 17449 - 96.94% | 1,507,333$ | 12,058,660$ | 18000 | 100 | 68,750,000$ | 68,750,000$ | 0$ | 13,239,776$ | 402,047$ | 12,865,504$ | 21 | 0 | 7,203,980$ | 48,234,640$ | 139 | 413,743$ | 57,510,277$ | 59,922,025$ | 68,750,037$ | 29,750,037$ | 87,860,287$ | 19,110,250$ | 15,360,287$ | 9,603,450$ |
| 11 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 40242 | 33070 | 13504 | 27268 | 6622 | 95.81% | 94.49% | 96.46% | 97.39% | 94.60% | 33 | 17244 - 95.80% | 1,482,136$ | 10,374,955$ | 18000 | 100 | 70,300,000$ | 70,300,000$ | 0$ | 13,909,359$ | 411,111$ | 13,036,545$ | 21 | 0 | 24,616,632$ | 48,910,502$ | 139 | 419,883$ | 58,363,737$ | 60,418,737$ | 70,180,974$ | 31,180,974$ | 72,963,597$ | 2,782,623$ | 463,597$ | -5,285,407$ |
| 12 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 40474 | 33604 | 13593 | 27230 | 6751 | 96.37% | 96.01% | 97.09% | 97.25% | 96.44% | 33 | 17379 - 96.55% | 1,496,725$ | 10,477,073$ | 18000 | 100 | 69,450,000$ | 69,450,000$ | 0$ | 13,259,640$ | 406,140$ | 12,978,936$ | 20 | 0 | 7,467,053$ | 49,391,916$ | 139 | 414,912$ | 57,672,768$ | 60,096,572$ | 69,432,396$ | 30,432,396$ | 82,451,880$ | 13,019,484$ | 9,951,880$ | 5,199,646$ |
| 13 | Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 40195 | 33908 | 13585 | 27479 | 6630 | 95.70% | 96.88% | 97.04% | 98.14% | 94.71% | 33 | 17400 - 96.66% | 1,492,836$ | 10,449,855$ | 18000 | 100 | 72,450,000$ | 72,450,000$ | 0$ | 13,507,906$ | 423,684$ | 13,358,179$ | 21 | 1 | 8,636,536$ | 49,263,602$ | 139 | 428,363$ | 59,542,457$ | 61,897,350$ | 72,250,255$ | 33,250,255$ | 89,639,406$ | 17,389,151$ | 17,139,406$ | 10,153,354$ |
| 14 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 40140 | 33427 | 13213 | 26609 | 6833 | 95.57% | 95.51% | 94.38% | 95.03% | 97.61% | 33 | 17175 - 95.41% | 1,486,339$ | 10,404,372$ | 18000 | 100 | 54,150,000$ | 54,150,000$ | 0$ | 10,616,372$ | 316,667$ | 10,242,100$ | 22 | 1 | 0$ | 49,049,182$ | 139 | 328,363$ | 45,642,457$ | 47,480,586$ | 54,258,813$ | 15,258,813$ | 85,401,795$ | 31,142,982$ | 12,901,795$ | 20,168,359$ |
| 15 | Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 46725 | 38279 | 15210 | 30189 | 7607 | 97.34% | 95.70% | 95.06% | 94.34% | 95.09% | 32 | 17251 - 95.84% | 1,493,203$ | 11,945,624$ | 18000 | 100 | 67,450,000$ | 67,450,000$ | 0$ | 12,917,843$ | 394,444$ | 12,450,003$ | 21 | 0 | 5,888,311$ | 47,782,496$ | 139 | 409,064$ | 56,859,896$ | 58,691,997$ | 67,277,719$ | 28,277,719$ | 86,399,207$ | 19,121,488$ | 13,899,207$ | 8,524,638$ |
| 16 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 38815 | 32810 | 13137 | 26846 | 6781 | 92.42% | 93.74% | 93.84% | 95.88% | 96.87% | 33 | 16913 - 93.96% | 1,456,436$ | 10,195,050$ | 18000 | 100 | 69,750,000$ | 69,750,000$ | 0$ | 13,222,864$ | 407,895$ | 13,098,248$ | 20 | 0 | 7,788,721$ | 48,062,379$ | 139 | 411,789$ | 57,238,671$ | 59,419,300$ | 69,795,653$ | 30,795,653$ | 121,184,407$ | 51,388,754$ | 48,684,407$ | 42,767,746$ |
| 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$ | 13,445,600$ | 415,497$ | 13,295,904$ | 22 | 0 | 8,548,845$ | 47,608,020$ | 139 | 420,175$ | 58,404,325$ | 60,974,034$ | 71,049,987$ | 32,049,987$ | 96,744,780$ | 25,694,793$ | 24,244,780$ | 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$ | 13,370,161$ | 400,439$ | 12,715,216$ | 20 | 0 | 6,370,663$ | 47,651,216$ | 139 | 420,906$ | 58,505,934$ | 60,621,762$ | 68,376,237$ | 29,376,237$ | 86,603,718$ | 18,227,481$ | 14,103,718$ | 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$ | 13,181,438$ | 406,725$ | 12,994,302$ | 21 | 0 | 7,247,775$ | 47,729,780$ | 139 | 412,573$ | 57,347,647$ | 59,090,561$ | 69,529,077$ | 30,529,077$ | 112,079,391$ | 42,550,314$ | 39,579,391$ | 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$ | 13,256,719$ | 403,801$ | 12,929,247$ | 21 | 0 | 7,759,424$ | 48,128,648$ | 139 | 414,035$ | 57,550,865$ | 60,150,988$ | 69,057,586$ | 30,057,586$ | 80,761,986$ | 11,704,400$ | 8,261,986$ | 1,881,453$ |
| 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$ | 12,761,394$ | 387,719$ | 12,480,690$ | 21 | 0 | 6,297,570$ | 46,991,848$ | 139 | 396,491$ | 55,112,249$ | 57,219,994$ | 66,373,631$ | 27,373,631$ | 133,301,816$ | 66,928,185$ | 60,801,816$ | 56,310,954$ |
| 22 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 39716 | 34209 | 13416 | 26908 | 6624 | 94.56% | 97.74% | 95.83% | 96.10% | 94.63% | 33 | 17268 - 95.93% | 1,484,306$ | 10,390,145$ | 18000 | 100 | 67,900,000$ | 67,900,000$ | 0$ | 13,389,182$ | 397,076$ | 13,014,910$ | 21 | 1 | 7,584,042$ | 48,982,112$ | 139 | 408,772$ | 56,819,308$ | 59,691,102$ | 68,208,474$ | 29,208,474$ | 83,067,145$ | 14,858,671$ | 10,567,145$ | 5,473,691$ |
| 23 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 41256 | 33565 | 13649 | 27302 | 6759 | 98.23% | 95.90% | 97.49% | 97.51% | 96.56% | 33 | 17504 - 97.25% | 1,510,109$ | 10,570,766$ | 18000 | 100 | 73,220,000$ | 73,220,000$ | 0$ | 13,819,531$ | 428,187$ | 13,632,396$ | 21 | 0 | 12,789,324$ | 49,833,611$ | 139 | 434,035$ | 60,330,865$ | 62,898,656$ | 73,150,389$ | 34,150,389$ | 85,020,813$ | 11,870,424$ | 12,520,813$ | 4,908,460$ |
| 24 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 46626 | 38481 | 15292 | 31268 | 7947 | 97.14% | 96.20% | 95.58% | 97.71% | 99.34% | 32 | 17452 - 96.95% | 1,508,712$ | 12,069,698$ | 18000 | 100 | 65,850,000$ | 65,850,000$ | 0$ | 11,616,968$ | 385,088$ | 11,336,264$ | 24 | 0 | 1,985,202$ | 48,278,792$ | 139 | 393,860$ | 54,746,540$ | 57,527,092$ | 64,863,496$ | 25,863,496$ | 84,823,122$ | 19,959,626$ | 12,323,122$ | 8,936,023$ |
| 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$ | 13,434,176$ | 414,263$ | 13,256,416$ | 21 | 0 | 8,425,457$ | 46,763,096$ | 139 | 419,818$ | 58,354,702$ | 60,470,530$ | 70,838,973$ | 31,838,973$ | 87,916,007$ | 17,077,034$ | 15,416,007$ | 7,488,839$ |
| 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$ | 13,252,624$ | 401,462$ | 13,018,704$ | 23 | 0 | 7,759,424$ | 46,448,864$ | 139 | 408,772$ | 56,819,308$ | 59,092,823$ | 68,821,922$ | 29,821,922$ | 87,805,406$ | 18,983,484$ | 15,305,406$ | 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