| 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 | 123282 | 102861 | 40939 | 83143 | 20184 | 79.03% | 79.12% | 78.73% | 79.95% | 77.63% | 12 | 14247 - 79.15% | 1,059,827$ | 27,555,494$ | 18000 | 100 | 3,891,177$ | 3,891,177$ | 99,645$ | 2,619,183$ | 3,891,177$ | 2,488,835$ | 23 | 0 | 5,774,265$ | 12,717,920$ | 47 | 30,305$ | 1,424,335$ | 1,502,355$ | 4,015,329$ | 4,015,329$ | 5,500,000$ | 1,484,671$ | 196,941,901$ | 209,019,763$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 128037 | 105572 | 42137 | 83721 | 20401 | 82.08% | 81.21% | 81.03% | 80.50% | 78.47% | 12 | 14610 - 81.17% | 1,082,791$ | 28,152,557$ | 18000 | 100 | 3,766,620$ | 3,766,620$ | 163,807$ | 2,596,469$ | 3,766,620$ | 2,466,138$ | 27 | 0 | 5,706,174$ | 12,993,488$ | 47 | 29,382$ | 1,380,954$ | 1,465,789$ | 3,910,340$ | 3,910,340$ | 5,500,000$ | 1,589,660$ | 136,772,993$ | 148,867,250$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 123647 | 103003 | 40921 | 80887 | 19527 | 82.43% | 82.40% | 81.84% | 80.89% | 78.11% | 13 | 14719 - 81.77% | 1,085,086$ | 27,127,150$ | 18000 | 100 | 3,474,863$ | 3,474,863$ | 76,960$ | 2,405,097$ | 3,474,863$ | 2,274,753$ | 25 | 0 | 5,132,019$ | 14,106,118$ | 47 | 27,221$ | 1,279,387$ | 1,369,580$ | 3,633,991$ | 3,633,991$ | 5,500,000$ | 1,866,009$ | 157,771,585$ | 171,117,841$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 116481 | 97414 | 38173 | 76161 | 18875 | 80.89% | 81.18% | 79.53% | 79.33% | 78.65% | 14 | 14463 - 80.35% | 1,077,780$ | 25,866,721$ | 18000 | 100 | 4,276,623$ | 4,276,623$ | 152,796$ | 2,942,276$ | 4,276,623$ | 2,811,886$ | 25 | 0 | 6,743,418$ | 15,088,921$ | 47 | 33,160$ | 1,558,520$ | 1,641,851$ | 4,416,023$ | 4,416,023$ | 5,500,000$ | 1,083,977$ | 194,310,162$ | 208,411,812$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 116938 | 95540 | 38339 | 76334 | 18684 | 81.21% | 79.62% | 79.87% | 79.51% | 77.85% | 14 | 14410 - 80.05% | 1,070,901$ | 25,701,619$ | 18000 | 100 | 2,903,720$ | 2,903,720$ | 147,585$ | 1,998,269$ | 2,903,720$ | 1,867,894$ | 23 | 0 | 3,911,442$ | 14,992,611$ | 47 | 22,991$ | 1,080,577$ | 1,167,245$ | 3,052,720$ | 3,052,720$ | 5,500,000$ | 2,447,280$ | 165,315,243$ | 179,797,319$ |
| 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,714,946$ | 3,772,933$ | 2,584,595$ | 36 | 0 | 6,061,545$ | 15,881,009$ | 47 | 29,429$ | 1,383,163$ | 1,470,583$ | 3,924,033$ | 3,924,033$ | 5,500,000$ | 1,575,967$ | 175,038,031$ | 190,143,609$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 113449 | 95175 | 38146 | 74880 | 19017 | 78.78% | 79.31% | 79.47% | 78.00% | 79.24% | 14 | 14194 - 78.86% | 1,068,597$ | 25,646,332$ | 18000 | 100 | 3,548,240$ | 3,548,240$ | 49,987$ | 2,417,756$ | 3,548,240$ | 2,287,377$ | 22 | 0 | 5,169,891$ | 14,960,360$ | 47 | 27,765$ | 1,304,955$ | 1,385,701$ | 3,680,140$ | 3,680,140$ | 5,500,000$ | 1,819,860$ | 149,337,720$ | 163,930,523$ |
| 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,546,597$ | 2,102,560$ | 1,416,250$ | 20 | 0 | 2,556,510$ | 13,955,025$ | 47 | 17,056$ | 801,632$ | 880,498$ | 2,229,060$ | 2,229,060$ | 5,500,000$ | 3,270,940$ | 197,773,817$ | 211,783,721$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 104182 | 87781 | 33954 | 70004 | 16960 | 78.93% | 79.80% | 77.17% | 79.55% | 77.09% | 16 | 14222 - 79.01% | 1,056,372$ | 23,240,188$ | 18000 | 100 | 3,902,417$ | 3,902,417$ | 123,918$ | 2,619,723$ | 3,902,417$ | 2,489,347$ | 22 | 0 | 5,775,801$ | 16,901,955$ | 47 | 30,388$ | 1,428,236$ | 1,523,082$ | 4,074,848$ | 4,074,848$ | 5,500,000$ | 1,425,152$ | 135,827,860$ | 152,372,841$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 113847 | 95889 | 37322 | 76545 | 18368 | 79.06% | 79.91% | 77.75% | 79.73% | 76.53% | 14 | 14249 - 79.16% | 1,053,984$ | 25,295,605$ | 18000 | 100 | 4,225,890$ | 4,225,890$ | 168,160$ | 2,739,373$ | 4,225,890$ | 2,608,975$ | 25 | 0 | 6,134,685$ | 14,755,770$ | 47 | 32,784$ | 1,540,848$ | 1,615,061$ | 4,339,090$ | 4,339,090$ | 5,500,000$ | 1,160,910$ | 122,487,362$ | 136,645,153$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 120500 | 98478 | 39305 | 79264 | 19483 | 80.33% | 78.78% | 78.61% | 79.26% | 77.93% | 13 | 14281 - 79.34% | 1,065,495$ | 26,637,370$ | 18000 | 100 | 3,461,760$ | 3,461,760$ | 93,729$ | 2,427,357$ | 3,461,760$ | 2,296,993$ | 22 | 0 | 5,198,739$ | 13,851,432$ | 47 | 27,124$ | 1,274,828$ | 1,348,148$ | 3,572,360$ | 3,572,360$ | 5,500,000$ | 1,927,640$ | 158,743,845$ | 172,171,864$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 132000 | 110000 | 44000 | 88000 | 22000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 16 | 18000 - 100.00% | 323,000$ | 7,106,000$ | 18000 | 100 | 3,323,854$ | 3,323,854$ | 122,753$ | 2,300,990$ | 3,323,854$ | 2,170,574$ | 22 | 0 | 4,819,482$ | 5,168,000$ | 47 | 26,103$ | 1,226,841$ | 1,312,616$ | 3,470,254$ | 3,470,254$ | 5,500,000$ | 2,029,746$ | 136,350,699$ | 140,369,283$ |
CCCP
Jets
Mooseheads
Nordiques
Thunder
Tigers
Americans
Brass
Bulls
Gibsons
Scouts
Whalers