| 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 | 114364 | 94654 | 37546 | 76838 | 18581 | 79.42% | 78.88% | 78.22% | 80.04% | 77.42% | 14 | 14249 - 79.16% | 1,059,273$ | 25,422,556$ | 18000 | 100 | 3,891,177$ | 3,891,177$ | 99,645$ | 2,497,963$ | 3,891,177$ | 2,373,539$ | 23 | 0 | 5,505,297$ | 14,829,824$ | 51 | 30,305$ | 1,545,555$ | 1,630,215$ | 4,015,329$ | 4,015,329$ | 5,500,000$ | 1,484,671$ | 195,064,980$ | 209,272,297$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 122931 | 101354 | 40409 | 80660 | 19600 | 81.95% | 81.08% | 80.82% | 80.66% | 78.40% | 13 | 14598 - 81.10% | 1,081,642$ | 27,041,046$ | 18000 | 100 | 3,766,620$ | 3,766,620$ | 163,807$ | 2,478,941$ | 3,766,620$ | 2,354,534$ | 27 | 0 | 5,448,282$ | 14,061,344$ | 51 | 29,382$ | 1,498,482$ | 1,590,537$ | 3,910,340$ | 3,910,340$ | 5,500,000$ | 1,589,660$ | 135,993,964$ | 149,077,011$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 118410 | 99143 | 39368 | 77529 | 18793 | 82.23% | 82.62% | 82.02% | 80.76% | 78.30% | 14 | 14718 - 81.77% | 1,086,026$ | 26,064,629$ | 18000 | 100 | 3,536,130$ | 3,536,130$ | 76,960$ | 2,295,305$ | 3,536,130$ | 2,170,885$ | 26 | 0 | 4,897,335$ | 15,204,367$ | 51 | 27,675$ | 1,411,425$ | 1,507,866$ | 3,691,358$ | 3,691,358$ | 5,500,000$ | 1,808,642$ | 157,016,968$ | 171,371,669$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 112000 | 93055 | 36441 | 72690 | 18026 | 81.16% | 80.92% | 79.22% | 79.01% | 78.37% | 15 | 14444 - 80.24% | 1,076,147$ | 24,751,389$ | 18000 | 100 | 4,276,623$ | 4,276,623$ | 152,796$ | 2,809,636$ | 4,276,623$ | 2,685,170$ | 25 | 0 | 6,440,190$ | 16,142,210$ | 51 | 33,160$ | 1,691,160$ | 1,781,583$ | 4,416,023$ | 4,416,023$ | 5,500,000$ | 1,083,977$ | 193,588,082$ | 208,648,120$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 106857 | 87334 | 35035 | 70047 | 17114 | 80.95% | 79.39% | 79.63% | 79.60% | 77.79% | 16 | 14381 - 79.90% | 1,069,009$ | 23,518,194$ | 18000 | 100 | 2,873,720$ | 2,873,720$ | 147,585$ | 1,906,974$ | 2,873,720$ | 1,782,524$ | 22 | 0 | 3,732,252$ | 17,104,141$ | 51 | 22,768$ | 1,161,168$ | 1,256,385$ | 3,025,720$ | 3,025,720$ | 5,500,000$ | 2,474,280$ | 163,316,478$ | 179,915,157$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 109099 | 89818 | 36764 | 71630 | 17919 | 79.06% | 78.10% | 79.92% | 77.86% | 77.91% | 15 | 14140 - 78.56% | 1,058,734$ | 24,350,880$ | 18000 | 100 | 3,772,933$ | 3,772,933$ | 103,023$ | 2,597,230$ | 3,772,933$ | 2,472,803$ | 36 | 0 | 5,803,089$ | 15,881,009$ | 51 | 29,429$ | 1,500,879$ | 1,595,739$ | 3,924,033$ | 3,924,033$ | 5,500,000$ | 1,575,967$ | 175,421,643$ | 190,402,065$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 108928 | 90919 | 36722 | 71891 | 18269 | 78.93% | 79.06% | 79.83% | 78.14% | 79.43% | 15 | 14206 - 78.92% | 1,070,142$ | 24,613,263$ | 18000 | 100 | 3,548,240$ | 3,548,240$ | 49,987$ | 2,306,696$ | 3,548,240$ | 2,182,245$ | 22 | 0 | 4,931,415$ | 16,052,128$ | 51 | 27,765$ | 1,416,015$ | 1,503,633$ | 3,680,140$ | 3,680,140$ | 5,500,000$ | 1,819,860$ | 148,587,976$ | 164,227,106$ |
| 8 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 119409 | 99318 | 40108 | 79732 | 19804 | 79.61% | 79.45% | 80.22% | 79.73% | 79.22% | 13 | 14335 - 79.64% | 1,073,463$ | 26,836,587$ | 18000 | 100 | 2,102,560$ | 2,102,560$ | 79,666$ | 1,478,373$ | 2,102,560$ | 1,353,950$ | 20 | 0 | 2,446,530$ | 13,955,025$ | 51 | 17,056$ | 869,856$ | 955,434$ | 2,229,060$ | 2,229,060$ | 5,500,000$ | 3,270,940$ | 197,958,733$ | 211,893,701$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 98972 | 83684 | 32407 | 66602 | 16175 | 78.55% | 79.70% | 77.16% | 79.29% | 77.02% | 17 | 14183 - 78.79% | 1,054,105$ | 22,136,208$ | 18000 | 100 | 3,902,417$ | 3,902,417$ | 123,918$ | 2,498,171$ | 3,902,417$ | 2,373,719$ | 22 | 0 | 5,505,837$ | 17,919,787$ | 51 | 30,388$ | 1,549,788$ | 1,652,706$ | 4,074,848$ | 4,074,848$ | 5,500,000$ | 1,425,152$ | 135,051,056$ | 152,557,507$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 104227 | 88156 | 34296 | 70200 | 16788 | 78.96% | 80.14% | 77.95% | 79.77% | 76.31% | 16 | 14258 - 79.21% | 1,052,791$ | 23,161,399$ | 18000 | 100 | 4,286,303$ | 4,286,303$ | 168,160$ | 2,605,899$ | 4,286,303$ | 2,481,427$ | 24 | 0 | 5,828,961$ | 16,844,654$ | 51 | 33,232$ | 1,694,832$ | 1,780,512$ | 4,413,135$ | 4,413,135$ | 5,500,000$ | 1,086,865$ | 120,653,820$ | 136,880,625$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 110553 | 90260 | 36133 | 73548 | 17885 | 80.11% | 78.49% | 78.55% | 79.94% | 77.76% | 15 | 14277 - 79.32% | 1,063,357$ | 24,457,200$ | 18000 | 100 | 3,461,760$ | 3,461,760$ | 93,729$ | 2,318,861$ | 3,461,760$ | 2,194,421$ | 22 | 0 | 4,967,943$ | 15,950,348$ | 51 | 27,124$ | 1,383,324$ | 1,462,884$ | 3,572,360$ | 3,572,360$ | 5,500,000$ | 1,927,640$ | 156,769,152$ | 172,325,060$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 114000 | 95000 | 38000 | 76000 | 19000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 19 | 18000 - 100.00% | 323,000$ | 6,137,000$ | 18000 | 100 | 3,323,854$ | 3,323,854$ | 122,753$ | 2,196,578$ | 3,323,854$ | 2,072,090$ | 22 | 0 | 4,600,950$ | 6,137,000$ | 51 | 26,103$ | 1,331,253$ | 1,424,328$ | 3,470,254$ | 3,470,254$ | 5,500,000$ | 2,029,746$ | 135,681,343$ | 140,587,815$ |
CCCP
Jets
Mooseheads
Nordiques
Thunder
Tigers
Americans
Brass
Bulls
Gibsons
Scouts
Whalers