| 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 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 | 75 | 50 | 30 | 20 | 750 | 29360 | 23830 | 9377 | 19250 | 4640 | 81.56% | 79.43% | 78.14% | 80.21% | 77.33% | 32 | 14410 - 80.05% | 1,068,140$ | 6,408,837$ | 18000 | 100 | 3,826,527$ | 3,826,527$ | 99,645$ | 638,843$ | 3,826,527$ | 606,246$ | 25 | 0 | 1,395,678$ | 34,180,464$ | 113 | 29,826$ | 3,370,338$ | 3,542,324$ | 3,931,979$ | 3,931,979$ | 5,500,000$ | 1,568,021$ | 180,823,370$ | 213,766,081$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 24895 | 19636 | 8190 | 15781 | 3914 | 82.98% | 78.54% | 81.90% | 78.91% | 78.28% | 33 | 14483 - 80.46% | 1,078,777$ | 5,393,884$ | 18000 | 100 | 3,766,620$ | 3,766,620$ | 163,807$ | 646,404$ | 3,766,620$ | 613,822$ | 27 | 0 | 1,418,406$ | 35,599,634$ | 113 | 29,382$ | 3,320,166$ | 3,515,769$ | 3,900,340$ | 3,900,340$ | 5,500,000$ | 1,599,660$ | 119,386,214$ | 153,019,000$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 28606 | 24872 | 9625 | 18917 | 4668 | 79.46% | 82.91% | 80.21% | 78.82% | 77.80% | 32 | 14448 - 80.27% | 1,070,595$ | 6,423,570$ | 18000 | 100 | 3,536,130$ | 3,536,130$ | 76,960$ | 579,084$ | 3,536,130$ | 546,490$ | 26 | 0 | 1,216,410$ | 34,259,040$ | 113 | 27,675$ | 3,127,275$ | 3,340,054$ | 3,690,358$ | 3,690,358$ | 5,500,000$ | 1,809,642$ | 142,545,025$ | 174,999,088$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 28206 | 24102 | 9462 | 19120 | 4844 | 78.35% | 80.34% | 78.85% | 79.67% | 80.73% | 32 | 14289 - 79.38% | 1,079,473$ | 6,476,839$ | 18000 | 100 | 4,329,873$ | 4,329,873$ | 152,796$ | 738,210$ | 4,329,873$ | 705,606$ | 22 | 0 | 1,693,758$ | 34,543,141$ | 113 | 33,555$ | 3,791,715$ | 3,990,482$ | 4,467,373$ | 4,467,373$ | 5,500,000$ | 1,032,627$ | 181,517,975$ | 213,576,885$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 19791 | 16224 | 6175 | 13511 | 2995 | 82.46% | 81.12% | 77.19% | 84.44% | 74.88% | 34 | 14674 - 81.52% | 1,061,915$ | 4,247,658$ | 18000 | 100 | 2,775,440$ | 2,775,440$ | 147,585$ | 487,771$ | 2,775,440$ | 455,184$ | 21 | 0 | 942,492$ | 36,105,093$ | 113 | 22,040$ | 2,490,520$ | 2,699,683$ | 2,925,268$ | 2,925,268$ | 5,500,000$ | 2,574,732$ | 147,783,545$ | 182,790,015$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 29673 | 22612 | 9270 | 18753 | 4676 | 82.43% | 75.37% | 77.25% | 78.14% | 77.93% | 32 | 14164 - 78.69% | 1,064,800$ | 6,388,799$ | 18000 | 100 | 4,125,613$ | 4,125,613$ | 103,023$ | 698,464$ | 4,125,613$ | 665,877$ | 35 | 0 | 1,574,571$ | 34,073,595$ | 113 | 32,042$ | 3,620,746$ | 3,843,243$ | 4,291,413$ | 4,291,413$ | 5,500,000$ | 1,208,587$ | 162,909,625$ | 194,585,470$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 28631 | 23818 | 9733 | 18990 | 4734 | 79.53% | 79.39% | 81.11% | 79.13% | 78.90% | 32 | 14318 - 79.54% | 1,071,073$ | 6,426,438$ | 18000 | 100 | 3,463,240$ | 3,463,240$ | 49,987$ | 601,067$ | 3,463,240$ | 568,468$ | 22 | 0 | 1,282,344$ | 34,274,336$ | 113 | 27,135$ | 3,066,255$ | 3,262,875$ | 3,598,140$ | 3,598,140$ | 5,500,000$ | 1,901,860$ | 134,693,934$ | 168,034,899$ |
| 8 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 23104 | 19923 | 8061 | 16093 | 3939 | 77.01% | 79.69% | 80.61% | 80.47% | 78.78% | 33 | 14224 - 79.02% | 1,061,971$ | 5,309,856$ | 18000 | 100 | 2,332,560$ | 2,332,560$ | 79,666$ | 388,901$ | 2,332,560$ | 356,308$ | 23 | 0 | 645,864$ | 35,045,050$ | 113 | 18,760$ | 2,119,880$ | 2,290,171$ | 2,436,060$ | 2,436,060$ | 5,500,000$ | 3,063,940$ | 177,992,082$ | 213,175,207$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 27536 | 23323 | 8980 | 19103 | 4478 | 76.49% | 77.74% | 74.83% | 79.60% | 74.63% | 32 | 13903 - 77.24% | 1,025,852$ | 6,155,113$ | 18000 | 100 | 3,717,417$ | 3,717,417$ | 123,918$ | 649,735$ | 3,717,417$ | 617,131$ | 22 | 0 | 1,428,333$ | 32,827,269$ | 113 | 29,018$ | 3,279,034$ | 3,507,068$ | 3,889,848$ | 3,889,848$ | 5,500,000$ | 1,610,152$ | 124,032,379$ | 155,711,775$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 18404 | 17018 | 6013 | 12967 | 3025 | 76.68% | 85.09% | 75.16% | 81.04% | 75.63% | 34 | 14357 - 79.76% | 1,049,682$ | 4,198,728$ | 18000 | 100 | 3,763,450$ | 3,763,450$ | 168,160$ | 645,898$ | 3,763,450$ | 613,294$ | 24 | 0 | 1,416,822$ | 35,689,188$ | 113 | 29,359$ | 3,317,567$ | 3,507,407$ | 3,890,282$ | 3,890,282$ | 5,500,000$ | 1,609,718$ | 108,203,436$ | 142,904,643$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 24700 | 18994 | 7863 | 16280 | 3885 | 82.33% | 75.98% | 78.63% | 81.40% | 77.70% | 33 | 14344 - 79.69% | 1,067,165$ | 5,335,824$ | 18000 | 100 | 3,575,333$ | 3,575,333$ | 93,729$ | 618,125$ | 3,575,333$ | 585,534$ | 20 | 0 | 1,333,542$ | 35,216,438$ | 113 | 27,965$ | 3,160,045$ | 3,345,930$ | 3,697,433$ | 3,697,433$ | 5,500,000$ | 1,802,567$ | 141,801,892$ | 176,033,873$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 42000 | 35000 | 14000 | 28000 | 7000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 31 | 18000 - 100.00% | 323,000$ | 2,261,000$ | 18000 | 100 | 3,323,854$ | 3,323,854$ | 122,753$ | 578,192$ | 3,323,854$ | 545,588$ | 22 | 0 | 1,213,704$ | 10,013,000$ | 113 | 26,103$ | 2,949,639$ | 3,155,864$ | 3,470,254$ | 3,470,254$ | 5,500,000$ | 2,029,746$ | 136,801,725$ | 143,975,061$ |
CCCP
Jets
Mooseheads
Nordiques
Thunder
Tigers
Americans
Brass
Bulls
Gibsons
Scouts
Whalers