| 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 | 42301 | 37150 | 14428 | 28891 | 6994 | 78.34% | 82.56% | 80.16% | 80.25% | 77.71% | 29 | 14418 - 80.10% | 1,065,922$ | 9,593,300$ | 18000 | 100 | 4,155,943$ | 4,155,943$ | 94,869$ | 1,047,636$ | 4,155,943$ | 995,709$ | 25 | 0 | 1,948,707$ | 30,911,744$ | 154 | 20,942$ | 3,225,068$ | 3,382,748$ | 4,272,043$ | 4,272,043$ | 5,500,000$ | 1,227,957$ | 199,644,787$ | 229,148,931$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 42677 | 35241 | 14608 | 28831 | 7025 | 79.03% | 78.31% | 81.16% | 80.09% | 78.06% | 29 | 14265 - 79.25% | 1,062,163$ | 9,559,469$ | 18000 | 100 | 4,248,700$ | 4,248,700$ | 114,024$ | 1,154,952$ | 4,248,700$ | 1,103,004$ | 28 | 0 | 2,270,592$ | 30,802,733$ | 154 | 21,388$ | 3,293,752$ | 3,468,952$ | 4,388,720$ | 4,388,720$ | 5,500,000$ | 1,111,280$ | 159,432,016$ | 188,079,916$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 49404 | 38628 | 16024 | 31845 | 7792 | 82.34% | 77.26% | 80.12% | 79.61% | 77.92% | 28 | 14369 - 79.83% | 1,070,857$ | 10,708,570$ | 18000 | 100 | 3,460,290$ | 3,460,290$ | 81,381$ | 987,171$ | 3,460,290$ | 935,223$ | 26 | 0 | 1,767,249$ | 29,983,996$ | 154 | 17,598$ | 2,710,092$ | 2,853,464$ | 3,556,618$ | 3,556,618$ | 5,500,000$ | 1,943,382$ | 182,341,779$ | 210,837,702$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 46816 | 40315 | 16022 | 32278 | 7880 | 78.03% | 80.63% | 80.11% | 80.70% | 78.80% | 28 | 14331 - 79.62% | 1,067,870$ | 10,678,696$ | 18000 | 100 | 4,437,260$ | 4,437,260$ | 139,635$ | 1,203,930$ | 4,437,260$ | 1,151,982$ | 27 | 0 | 2,417,526$ | 29,900,349$ | 154 | 22,295$ | 3,433,430$ | 3,575,488$ | 4,531,788$ | 4,531,788$ | 5,500,000$ | 968,212$ | 215,639,176$ | 243,298,047$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 43846 | 35111 | 14901 | 28245 | 6967 | 81.20% | 78.02% | 82.78% | 78.46% | 77.41% | 29 | 14341 - 79.67% | 1,065,445$ | 9,589,002$ | 18000 | 100 | 2,777,600$ | 2,777,600$ | 124,801$ | 798,624$ | 2,777,600$ | 746,715$ | 24 | 0 | 1,201,725$ | 30,897,895$ | 154 | 14,315$ | 2,204,510$ | 2,359,416$ | 2,889,752$ | 2,889,752$ | 5,500,000$ | 2,610,248$ | 193,062,746$ | 222,951,871$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 48625 | 41989 | 15687 | 32462 | 7726 | 81.04% | 83.98% | 78.44% | 81.16% | 77.26% | 28 | 14649 - 81.38% | 1,076,157$ | 10,761,573$ | 18000 | 100 | 4,284,800$ | 4,284,800$ | 79,206$ | 1,164,348$ | 4,284,800$ | 1,112,400$ | 36 | 0 | 2,298,780$ | 30,132,404$ | 154 | 21,562$ | 3,320,548$ | 3,502,464$ | 4,434,000$ | 4,434,000$ | 5,500,000$ | 1,066,000$ | 191,692,981$ | 219,686,034$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 48499 | 40970 | 16003 | 31288 | 7777 | 80.83% | 81.94% | 80.02% | 78.22% | 77.77% | 28 | 14454 - 80.30% | 1,073,085$ | 10,730,848$ | 18000 | 100 | 4,445,360$ | 4,445,360$ | 39,159$ | 1,205,982$ | 4,445,360$ | 1,154,088$ | 27 | 0 | 2,423,844$ | 30,046,374$ | 154 | 22,333$ | 3,439,282$ | 3,577,398$ | 4,534,460$ | 4,534,460$ | 5,500,000$ | 965,540$ | 176,474,435$ | 204,991,820$ |
| 8 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 46822 | 39626 | 16430 | 31172 | 7632 | 78.04% | 79.25% | 82.15% | 77.93% | 76.32% | 28 | 14168 - 78.71% | 1,048,330$ | 10,483,297$ | 18000 | 100 | 2,768,000$ | 2,768,000$ | 65,084$ | 650,169$ | 2,768,000$ | 598,257$ | 22 | 0 | 756,351$ | 29,353,232$ | 154 | 14,269$ | 2,197,426$ | 2,357,880$ | 2,887,800$ | 2,887,800$ | 5,500,000$ | 2,612,200$ | 211,056,885$ | 240,082,962$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 48970 | 39725 | 15442 | 30842 | 7796 | 81.62% | 79.45% | 77.21% | 77.11% | 77.96% | 28 | 14278 - 79.32% | 1,069,818$ | 10,698,183$ | 18000 | 100 | 3,957,807$ | 3,957,807$ | 101,296$ | 1,115,877$ | 3,957,807$ | 1,063,962$ | 26 | 0 | 2,153,466$ | 29,954,912$ | 154 | 19,989$ | 3,078,306$ | 3,225,328$ | 4,059,207$ | 4,059,207$ | 5,500,000$ | 1,440,793$ | 165,273,909$ | 194,055,655$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 49948 | 40060 | 16295 | 31547 | 7789 | 83.25% | 80.12% | 81.48% | 78.87% | 77.89% | 28 | 14564 - 80.91% | 1,080,405$ | 10,804,045$ | 18000 | 100 | 3,862,110$ | 3,862,110$ | 136,085$ | 1,054,566$ | 3,862,110$ | 1,002,672$ | 27 | 0 | 1,969,596$ | 30,251,326$ | 154 | 19,529$ | 3,007,466$ | 3,151,276$ | 3,959,110$ | 3,959,110$ | 5,500,000$ | 1,540,890$ | 154,505,192$ | 183,575,025$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 47157 | 39807 | 15735 | 31220 | 7778 | 78.60% | 79.61% | 78.68% | 78.05% | 77.78% | 28 | 14170 - 78.72% | 1,058,851$ | 10,588,513$ | 18000 | 100 | 3,625,440$ | 3,625,440$ | 107,835$ | 993,168$ | 3,625,440$ | 941,220$ | 24 | 0 | 1,785,240$ | 29,647,836$ | 154 | 18,392$ | 2,832,368$ | 2,979,828$ | 3,727,340$ | 3,727,340$ | 5,500,000$ | 1,772,660$ | 178,412,984$ | 207,153,477$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 60000 | 50000 | 20000 | 40000 | 10000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 28 | 18000 - 100.00% | 323,000$ | 3,230,000$ | 18000 | 100 | 3,158,124$ | 3,158,124$ | 90,029$ | 870,868$ | 3,158,124$ | 818,922$ | 27 | 0 | 1,418,346$ | 9,044,000$ | 154 | 16,145$ | 2,486,330$ | 2,638,462$ | 3,266,424$ | 3,266,424$ | 5,500,000$ | 2,233,576$ | 150,901,899$ | 157,603,237$ |
CCCP
Jets
Mooseheads
Nordiques
Thunder
Tigers
Americans
Brass
Bulls
Gibsons
Scouts
Whalers