| 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 | 156963 | 130533 | 51809 | 106222 | 25368 | 79.27% | 79.11% | 78.50% | 80.47% | 76.87% | 5 | 14270 - 79.28% | 1,056,153$ | 34,853,045$ | 18000 | 100 | 4,226,697$ | 4,226,697$ | 99,645$ | 3,521,969$ | 4,226,697$ | 3,350,141$ | 23 | 0 | 7,819,743$ | 5,280,764$ | 19 | 32,790$ | 623,010$ | 654,702$ | 4,351,849$ | 4,351,849$ | 5,500,000$ | 1,148,151$ | 201,743,838$ | 206,728,657$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 161513 | 133633 | 53490 | 104666 | 25927 | 81.57% | 80.99% | 81.05% | 79.29% | 78.57% | 5 | 14522 - 80.68% | 1,080,231$ | 35,647,634$ | 18000 | 100 | 3,766,620$ | 3,766,620$ | 163,807$ | 3,421,158$ | 3,766,620$ | 3,249,358$ | 27 | 0 | 7,517,394$ | 5,401,157$ | 19 | 29,382$ | 558,258$ | 592,553$ | 3,910,340$ | 3,910,340$ | 5,500,000$ | 1,589,660$ | 141,909,182$ | 146,953,378$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 156737 | 132772 | 52331 | 103773 | 25051 | 81.63% | 82.98% | 81.77% | 81.07% | 78.28% | 6 | 14708 - 81.71% | 1,084,481$ | 34,703,387$ | 18000 | 100 | 3,638,863$ | 3,638,863$ | 76,960$ | 3,199,630$ | 3,638,863$ | 3,027,814$ | 27 | 0 | 6,852,762$ | 6,506,885$ | 19 | 28,436$ | 540,284$ | 574,427$ | 3,781,491$ | 3,781,491$ | 5,500,000$ | 1,718,509$ | 162,828,274$ | 169,041,019$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 156632 | 130022 | 51220 | 101577 | 25268 | 81.58% | 81.26% | 80.03% | 79.36% | 78.96% | 6 | 14522 - 80.68% | 1,082,891$ | 34,652,496$ | 18000 | 100 | 4,661,623$ | 4,661,623$ | 152,796$ | 3,906,792$ | 4,661,623$ | 3,734,925$ | 27 | 0 | 8,974,095$ | 6,497,343$ | 19 | 36,012$ | 684,228$ | 717,991$ | 4,801,523$ | 4,801,523$ | 5,500,000$ | 698,477$ | 200,172,089$ | 206,231,788$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 165402 | 135053 | 54955 | 108844 | 26737 | 81.08% | 79.44% | 80.82% | 80.03% | 78.64% | 4 | 14441 - 80.23% | 1,075,902$ | 36,580,666$ | 18000 | 100 | 2,873,720$ | 2,873,720$ | 147,585$ | 2,654,335$ | 2,873,720$ | 2,482,483$ | 22 | 0 | 5,216,769$ | 4,303,608$ | 19 | 22,768$ | 432,592$ | 468,692$ | 3,030,220$ | 3,030,220$ | 5,500,000$ | 2,469,780$ | 174,622,677$ | 178,642,740$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 156861 | 127885 | 52284 | 103494 | 25589 | 79.22% | 77.51% | 79.22% | 78.40% | 77.54% | 5 | 14125 - 78.47% | 1,055,777$ | 34,840,627$ | 18000 | 100 | 3,897,893$ | 3,897,893$ | 103,023$ | 3,566,504$ | 3,897,893$ | 3,394,665$ | 36 | 0 | 7,953,315$ | 5,278,883$ | 19 | 30,355$ | 576,745$ | 610,109$ | 4,034,893$ | 4,034,893$ | 5,500,000$ | 1,465,107$ | 183,198,693$ | 188,099,184$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 155276 | 130315 | 52844 | 103930 | 25849 | 78.42% | 78.98% | 80.07% | 78.73% | 78.33% | 5 | 14188 - 78.82% | 1,061,524$ | 35,030,302$ | 18000 | 100 | 3,529,240$ | 3,529,240$ | 49,987$ | 3,193,010$ | 3,529,240$ | 3,021,145$ | 23 | 0 | 6,832,755$ | 5,307,622$ | 19 | 27,624$ | 524,856$ | 556,776$ | 3,656,040$ | 3,656,040$ | 5,500,000$ | 1,843,960$ | 156,894,310$ | 162,009,388$ |
| 8 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 156909 | 131238 | 52631 | 104393 | 26022 | 79.25% | 79.54% | 79.74% | 79.09% | 78.85% | 5 | 14279 - 79.33% | 1,069,284$ | 35,286,360$ | 18000 | 100 | 2,222,560$ | 2,222,560$ | 79,666$ | 2,032,611$ | 2,222,560$ | 1,860,786$ | 21 | 0 | 3,351,678$ | 5,346,418$ | 19 | 17,945$ | 340,955$ | 372,419$ | 2,346,060$ | 2,346,060$ | 5,500,000$ | 3,153,940$ | 205,454,126$ | 210,785,296$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 152696 | 129379 | 49922 | 102823 | 24756 | 79.53% | 80.86% | 78.00% | 80.33% | 77.36% | 6 | 14362 - 79.79% | 1,063,623$ | 34,035,928$ | 18000 | 100 | 3,992,417$ | 3,992,417$ | 123,918$ | 3,486,747$ | 3,992,417$ | 3,314,887$ | 23 | 0 | 7,713,981$ | 6,381,736$ | 19 | 31,055$ | 590,045$ | 624,701$ | 4,138,661$ | 4,138,661$ | 5,500,000$ | 1,361,339$ | 143,685,121$ | 149,883,921$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 157900 | 131852 | 51531 | 106017 | 25430 | 79.75% | 79.91% | 78.08% | 80.32% | 77.06% | 5 | 14325 - 79.58% | 1,060,539$ | 34,997,788$ | 18000 | 100 | 3,866,410$ | 3,866,410$ | 168,160$ | 3,593,215$ | 3,866,410$ | 3,421,331$ | 24 | 0 | 8,033,313$ | 5,302,695$ | 19 | 30,122$ | 572,318$ | 603,307$ | 3,986,610$ | 3,986,610$ | 5,500,000$ | 1,513,390$ | 129,624,792$ | 134,687,276$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 157333 | 129880 | 51855 | 104301 | 25583 | 79.46% | 78.72% | 78.57% | 79.02% | 77.52% | 5 | 14211 - 78.95% | 1,059,226$ | 34,954,462$ | 18000 | 100 | 3,457,760$ | 3,457,760$ | 93,729$ | 3,176,551$ | 3,457,760$ | 3,004,705$ | 23 | 0 | 6,783,435$ | 5,296,131$ | 19 | 27,095$ | 514,805$ | 543,229$ | 3,559,760$ | 3,559,760$ | 5,500,000$ | 1,940,240$ | 165,256,268$ | 170,365,472$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 186000 | 155000 | 62000 | 124000 | 31000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 7 | 18000 - 100.00% | 323,000$ | 10,013,000$ | 18000 | 100 | 3,323,854$ | 3,323,854$ | 122,753$ | 3,041,752$ | 3,323,854$ | 2,869,844$ | 22 | 0 | 6,378,852$ | 2,261,000$ | 19 | 26,103$ | 495,957$ | 530,632$ | 3,470,254$ | 3,470,254$ | 5,500,000$ | 2,029,746$ | 136,999,253$ | 138,801,021$ |
CCCP
Jets
Mooseheads
Nordiques
Thunder
Tigers
Americans
Brass
Bulls
Gibsons
Scouts
Whalers