| 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 0$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 29438 | 24555 | 9863 | 19805 | 4928 | 98.13% | 98.22% | 98.63% | 99.03% | 98.56% | 33 | 17718 - 98.43% | 317,488$ | 1,587,438$ | 18000 | 100 | 3,606,400$ | 3,606,400$ | 137,407$ | 602,731$ | 3,606,400$ | 582,931$ | 24 | 0 | 1,114,203$ | 10,477,091$ | 167 | 18,632$ | 3,111,544$ | 3,443,818$ | 3,606,400$ | 3,606,400$ | 5,000,000$ | 1,393,600$ | 107,693,476$ | 115,212,904$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 34879 | 29491 | 11725 | 22894 | 5840 | 96.89% | 98.30% | 97.71% | 95.39% | 97.33% | 32 | 17472 - 97.06% | 314,260$ | 1,885,562$ | 18000 | 100 | 3,512,000$ | 3,512,000$ | 282,932$ | 599,835$ | 3,512,000$ | 580,035$ | 23 | 0 | 1,105,515$ | 10,056,331$ | 167 | 18,160$ | 3,032,720$ | 3,588,880$ | 3,512,000$ | 3,512,000$ | 5,000,000$ | 1,488,000$ | 103,968,843$ | 110,752,097$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 34858 | 29548 | 11872 | 23584 | 5688 | 96.83% | 98.49% | 98.93% | 98.27% | 94.80% | 32 | 17592 - 97.73% | 313,738$ | 1,882,428$ | 18000 | 100 | 2,788,000$ | 2,788,000$ | 354,408$ | 472,020$ | 2,788,000$ | 452,220$ | 25 | 0 | 722,070$ | 10,039,616$ | 167 | 14,540$ | 2,428,180$ | 2,779,730$ | 2,788,000$ | 2,788,000$ | 5,000,000$ | 2,212,000$ | 98,317,015$ | 105,892,522$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 35040 | 29442 | 11577 | 23615 | 5962 | 97.33% | 98.14% | 96.48% | 98.40% | 99.37% | 32 | 17606 - 97.81% | 316,144$ | 1,896,865$ | 18000 | 100 | 3,462,045$ | 3,462,045$ | 175,381$ | 591,930$ | 3,462,045$ | 572,130$ | 21 | 0 | 1,081,800$ | 10,116,613$ | 167 | 17,910$ | 2,990,970$ | 3,419,940$ | 3,462,045$ | 3,462,045$ | 5,000,000$ | 1,537,955$ | 99,577,462$ | 106,591,154$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 35446 | 29000 | 11684 | 23742 | 5812 | 98.46% | 96.67% | 97.37% | 98.93% | 96.87% | 32 | 17614 - 97.86% | 315,584$ | 1,893,503$ | 18000 | 100 | 4,645,005$ | 4,645,005$ | 146,251$ | 787,025$ | 4,645,005$ | 767,225$ | 25 | 0 | 1,667,085$ | 10,098,683$ | 167 | 23,825$ | 3,978,775$ | 4,335,855$ | 4,645,005$ | 4,645,005$ | 5,000,000$ | 354,995$ | 81,940,881$ | 88,017,154$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 40 | 30 | 20 | 10 | 75 | 19380 | 14589 | 4606 | 9331 | 3580 | 64.60% | 58.36% | 46.06% | 46.66% | 71.60% | 33 | 10297 - 57.21% | 283,356$ | 1,416,780$ | 18000 | 100 | 2,485,000$ | 2,485,000$ | 110,208$ | 434,325$ | 2,485,000$ | 414,525$ | 24 | 0 | 608,985$ | 9,350,748$ | 167 | 13,025$ | 2,175,175$ | 2,654,389$ | 2,485,000$ | 2,485,000$ | 5,000,000$ | 2,515,000$ | 101,962,055$ | 108,942,762$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 34957 | 29141 | 11877 | 23834 | 5846 | 97.10% | 97.14% | 98.98% | 99.31% | 97.43% | 32 | 17609 - 97.83% | 314,533$ | 1,887,195$ | 18000 | 100 | 2,760,000$ | 2,760,000$ | 0$ | 438,900$ | 2,760,000$ | 419,100$ | 24 | 0 | 622,710$ | 10,065,040$ | 167 | 14,400$ | 2,404,800$ | 2,800,906$ | 2,760,000$ | 2,760,000$ | 5,000,000$ | 2,240,000$ | 38,663,071$ | 46,430,922$ |
| 8 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 34991 | 29511 | 11768 | 23537 | 5784 | 97.20% | 98.37% | 98.07% | 98.07% | 96.40% | 32 | 17599 - 97.77% | 314,834$ | 1,889,002$ | 18000 | 100 | 2,772,000$ | 2,772,000$ | 178,706$ | 486,840$ | 2,772,000$ | 467,040$ | 24 | 0 | 766,530$ | 10,074,677$ | 167 | 14,460$ | 2,414,820$ | 2,775,218$ | 2,772,000$ | 2,772,000$ | 5,000,000$ | 2,228,000$ | 92,882,364$ | 100,686,058$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 29035 | 24817 | 9870 | 19406 | 4937 | 96.78% | 99.27% | 98.70% | 97.03% | 98.74% | 33 | 17613 - 97.85% | 316,088$ | 1,580,440$ | 18000 | 100 | 2,940,000$ | 2,940,000$ | 0$ | 495,000$ | 2,940,000$ | 485,100$ | 23 | 0 | 820,710$ | 10,430,904$ | 167 | 15,000$ | 2,505,000$ | 2,798,090$ | 2,940,000$ | 2,940,000$ | 5,000,000$ | 2,060,000$ | 39,972,780$ | 48,085,941$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 35217 | 28434 | 11672 | 23456 | 5918 | 97.83% | 94.78% | 97.27% | 97.73% | 98.63% | 32 | 17450 - 96.94% | 313,688$ | 1,882,129$ | 18000 | 100 | 4,497,640$ | 4,497,640$ | 307,582$ | 768,804$ | 4,497,640$ | 749,004$ | 22 | 0 | 1,612,422$ | 10,038,021$ | 167 | 23,088$ | 3,855,696$ | 4,504,286$ | 4,497,640$ | 4,497,640$ | 5,000,000$ | 502,360$ | 68,304,302$ | 74,332,794$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 29485 | 24376 | 9793 | 19613 | 4943 | 98.28% | 97.50% | 97.93% | 98.07% | 98.86% | 33 | 17642 - 98.01% | 316,990$ | 1,584,949$ | 18000 | 100 | 3,503,000$ | 3,503,000$ | 110,123$ | 622,095$ | 3,503,000$ | 602,295$ | 23 | 0 | 1,172,295$ | 10,460,663$ | 167 | 18,115$ | 3,025,205$ | 3,557,823$ | 3,503,000$ | 3,503,000$ | 5,000,000$ | 1,497,000$ | 72,854,563$ | 80,266,720$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 35054 | 29128 | 11495 | 23643 | 5735 | 97.37% | 97.09% | 95.79% | 98.51% | 95.58% | 32 | 17509 - 97.27% | 313,288$ | 1,879,729$ | 18000 | 100 | 1,000,000$ | 1,000,000$ | 148,083$ | 191,675$ | 1,000,000$ | 171,875$ | 21 | 0 | 18,735$ | 10,025,221$ | 167 | 5,600$ | 935,200$ | 1,282,484$ | 1,000,000$ | 1,000,000$ | 5,000,000$ | 4,000,000$ | 120,113,272$ | 129,171,257$ |
Bulldogs
Mooseheads
Nordiques
Raiders
Thunder
Tigers
Americans
Brass
Bulls
Fighting Saints
Ice Flyers
Wings