| 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 | 75 | 50 | 30 | 20 | 750 | 14177 | 11385 | 4544 | 8215 | 1977 | 78.76% | 75.90% | 75.73% | 68.46% | 65.90% | 35 | 13433 - 74.63% | 967,837$ | 2,903,511$ | 18000 | 100 | 2,945,067$ | 2,945,067$ | 170,034$ | 0$ | 0$ | 0$ | 20 | 0 | 4,921,806$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 170,201,659$ | 170,201,659$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18000 - 100.00% | 323,000$ | 646,000$ | 18000 | 100 | 2,416,000$ | 2,416,000$ | 220,110$ | 0$ | 0$ | 0$ | 21 | 0 | 5,865,069$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 100,385,623$ | 100,385,623$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 30000 | 25000 | 10000 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 33 | 18000 - 100.00% | 323,000$ | 1,615,000$ | 18000 | 100 | 3,073,600$ | 3,073,600$ | 72,907$ | 0$ | 0$ | 0$ | 25 | 0 | 4,704,117$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 129,960,608$ | 129,960,608$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 29981 | 26487 | 10089 | 19350 | 4466 | 83.28% | 88.29% | 84.08% | 80.63% | 74.43% | 32 | 15062 - 83.68% | 1,078,380$ | 6,470,281$ | 18000 | 100 | 3,356,326$ | 3,356,326$ | 151,533$ | 0$ | 0$ | 0$ | 23 | 0 | 5,746,317$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 158,816,112$ | 158,816,112$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 38 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 4,631,200$ | 4,631,200$ | 146,461$ | 0$ | 0$ | 0$ | 23 | 0 | 9,535,968$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 131,053,573$ | 131,053,573$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 29239 | 24597 | 9580 | 18531 | 4161 | 81.22% | 81.99% | 79.83% | 77.21% | 69.35% | 32 | 14351 - 79.73% | 1,020,219$ | 6,121,313$ | 18000 | 100 | 3,091,466$ | 3,091,466$ | 118,963$ | 0$ | 0$ | 0$ | 25 | 0 | 5,385,894$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 144,870,487$ | 144,870,487$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 13876 | 10746 | 4434 | 8464 | 1947 | 77.09% | 71.64% | 73.90% | 70.53% | 64.90% | 35 | 13156 - 73.09% | 946,489$ | 2,839,467$ | 18000 | 100 | 4,400,400$ | 4,400,400$ | 73,079$ | 0$ | 0$ | 0$ | 24 | 0 | 8,968,206$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 106,947,340$ | 106,947,340$ |
| 8 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 35825 | 29807 | 11645 | 21527 | 5159 | 85.30% | 85.16% | 83.18% | 76.88% | 73.70% | 31 | 14852 - 82.51% | 1,071,773$ | 7,502,409$ | 18000 | 100 | 2,500,699$ | 2,500,699$ | 112,300$ | 0$ | 0$ | 0$ | 21 | 0 | 3,528,468$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 168,677,988$ | 168,677,988$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18000 - 100.00% | 323,000$ | 646,000$ | 18000 | 100 | 2,928,734$ | 2,928,734$ | 68,724$ | 0$ | 0$ | 0$ | 24 | 0 | 4,811,985$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 93,781,756$ | 93,781,756$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 38 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 3,105,267$ | 3,105,267$ | 161,688$ | 0$ | 0$ | 0$ | 21 | 0 | 5,004,090$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 92,816,555$ | 92,816,555$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 38 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 4,280,600$ | 4,280,600$ | 115,510$ | 0$ | 0$ | 0$ | 25 | 0 | 8,260,938$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 124,760,157$ | 124,760,157$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 38 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 3,104,919$ | 3,104,919$ | 88,741$ | 0$ | 0$ | 0$ | 24 | 0 | 5,767,596$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | 0$ | 7,500,000$ | 7,500,000$ | 132,110,736$ | 132,110,736$ |
CCCP
Mooseheads
Nordiques
Thunder
Tigers
Whalers
Americans
Brass
Bulls
Fighting Saints
Ice Flyers
Wings