| 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 | 161868 | 134416 | 53298 | 109242 | 26103 | 79.35% | 79.07% | 78.38% | 80.33% | 76.77% | 4 | 14263 - 79.24% | 1,055,548$ | 35,888,638$ | 18000 | 100 | 4,226,697$ | 4,226,697$ | 99,645$ | 3,718,709$ | 4,226,697$ | 3,537,995$ | 23 | 0 | 8,267,925$ | 4,222,193$ | 13 | 32,790$ | 426,270$ | 447,954$ | 4,351,849$ | 4,351,849$ | 5,500,000$ | 1,148,151$ | 202,200,873$ | 206,262,661$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 171160 | 141769 | 56655 | 111048 | 27419 | 81.50% | 81.01% | 80.94% | 79.32% | 78.34% | 3 | 14516 - 80.64% | 1,078,536$ | 37,748,762$ | 18000 | 100 | 3,766,620$ | 3,766,620$ | 163,807$ | 3,597,450$ | 3,766,620$ | 3,416,764$ | 27 | 0 | 7,904,232$ | 3,235,608$ | 13 | 29,382$ | 381,966$ | 405,431$ | 3,910,340$ | 3,910,340$ | 5,500,000$ | 1,589,660$ | 143,529,263$ | 146,500,681$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 161290 | 136472 | 53850 | 107015 | 25860 | 81.46% | 82.71% | 81.59% | 81.07% | 78.36% | 5 | 14681 - 81.56% | 1,083,651$ | 35,760,477$ | 18000 | 100 | 3,668,863$ | 3,668,863$ | 76,960$ | 3,371,134$ | 3,668,863$ | 3,190,432$ | 28 | 0 | 7,225,236$ | 5,418,254$ | 13 | 28,658$ | 372,554$ | 395,629$ | 3,808,491$ | 3,808,491$ | 5,500,000$ | 1,691,509$ | 163,380,043$ | 168,636,640$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 165823 | 137899 | 54391 | 107742 | 26875 | 81.29% | 81.12% | 79.99% | 79.22% | 79.04% | 4 | 14492 - 80.51% | 1,081,862$ | 36,783,322$ | 18000 | 100 | 4,661,623$ | 4,661,623$ | 152,796$ | 4,122,864$ | 4,661,623$ | 3,942,111$ | 27 | 0 | 9,480,273$ | 4,327,450$ | 13 | 36,012$ | 468,156$ | 491,257$ | 4,801,523$ | 4,801,523$ | 5,500,000$ | 698,477$ | 201,664,846$ | 205,688,101$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 175264 | 143524 | 58027 | 114845 | 28347 | 81.14% | 79.74% | 80.59% | 79.75% | 78.74% | 2 | 14445 - 80.25% | 1,077,114$ | 38,776,114$ | 18000 | 100 | 2,873,720$ | 2,873,720$ | 147,585$ | 2,790,943$ | 2,873,720$ | 2,610,205$ | 22 | 0 | 5,484,555$ | 2,154,229$ | 13 | 22,768$ | 295,984$ | 320,684$ | 3,030,220$ | 3,030,220$ | 5,500,000$ | 2,469,780$ | 176,492,915$ | 178,418,923$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 161214 | 131650 | 53729 | 106596 | 26424 | 79.03% | 77.44% | 79.01% | 78.38% | 77.72% | 4 | 14106 - 78.37% | 1,055,883$ | 35,900,037$ | 18000 | 100 | 3,897,893$ | 3,897,893$ | 103,023$ | 3,748,634$ | 3,897,893$ | 3,567,903$ | 36 | 0 | 8,357,649$ | 4,223,534$ | 13 | 30,355$ | 394,615$ | 417,443$ | 4,034,893$ | 4,034,893$ | 5,500,000$ | 1,465,107$ | 183,704,334$ | 187,695,433$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 165278 | 138650 | 56044 | 110284 | 27364 | 78.70% | 79.23% | 80.06% | 78.77% | 78.18% | 3 | 14218 - 78.99% | 1,062,217$ | 37,177,598$ | 18000 | 100 | 3,529,240$ | 3,529,240$ | 49,987$ | 3,358,754$ | 3,529,240$ | 3,178,003$ | 23 | 0 | 7,187,949$ | 3,186,651$ | 13 | 27,624$ | 359,112$ | 380,952$ | 3,656,040$ | 3,656,040$ | 5,500,000$ | 1,843,960$ | 158,653,558$ | 161,677,563$ |
| 8 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 170485 | 142568 | 57069 | 114089 | 28191 | 78.93% | 79.20% | 79.26% | 79.23% | 78.31% | 2 | 14233 - 79.07% | 1,063,725$ | 38,294,093$ | 18000 | 100 | 2,222,560$ | 2,222,560$ | 79,666$ | 2,140,281$ | 2,222,560$ | 1,959,564$ | 21 | 0 | 3,532,632$ | 2,127,450$ | 13 | 17,945$ | 233,285$ | 254,813$ | 2,346,060$ | 2,346,060$ | 5,500,000$ | 3,153,940$ | 208,379,454$ | 210,395,062$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 162803 | 137301 | 52982 | 109149 | 26436 | 79.81% | 80.77% | 77.91% | 80.26% | 77.75% | 4 | 14373 - 79.85% | 1,066,868$ | 36,273,506$ | 18000 | 100 | 3,992,417$ | 3,992,417$ | 123,918$ | 3,673,077$ | 3,992,417$ | 3,492,325$ | 23 | 0 | 8,130,915$ | 4,267,471$ | 13 | 31,055$ | 403,715$ | 427,427$ | 4,138,661$ | 4,138,661$ | 5,500,000$ | 1,361,339$ | 145,454,530$ | 149,588,941$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 163063 | 136127 | 52994 | 109379 | 26192 | 79.93% | 80.07% | 77.93% | 80.43% | 77.04% | 4 | 14346 - 79.70% | 1,061,437$ | 36,088,852$ | 18000 | 100 | 4,041,410$ | 4,041,410$ | 168,160$ | 3,781,723$ | 4,041,410$ | 3,600,947$ | 25 | 0 | 8,456,781$ | 4,245,747$ | 13 | 31,418$ | 408,434$ | 427,947$ | 4,144,110$ | 4,144,110$ | 5,500,000$ | 1,355,890$ | 130,163,452$ | 134,271,253$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 161986 | 134064 | 53544 | 107498 | 26330 | 79.40% | 78.86% | 78.74% | 79.04% | 77.44% | 4 | 14218 - 78.99% | 1,058,898$ | 36,002,542$ | 18000 | 100 | 3,341,760$ | 3,341,760$ | 93,729$ | 3,333,961$ | 3,341,760$ | 3,153,229$ | 21 | 0 | 7,113,627$ | 4,235,593$ | 13 | 26,235$ | 341,055$ | 361,621$ | 3,455,360$ | 3,455,360$ | 5,500,000$ | 2,044,640$ | 165,877,481$ | 170,036,373$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 204000 | 170000 | 68000 | 136000 | 34000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 4 | 18000 - 100.00% | 323,000$ | 10,982,000$ | 18000 | 100 | 3,323,854$ | 3,323,854$ | 122,753$ | 3,198,370$ | 3,323,854$ | 3,017,570$ | 22 | 0 | 6,706,650$ | 1,292,000$ | 13 | 26,103$ | 339,339$ | 363,064$ | 3,470,254$ | 3,470,254$ | 5,500,000$ | 2,029,746$ | 137,503,487$ | 138,473,223$ |
CCCP
Jets
Mooseheads
Nordiques
Thunder
Tigers
Americans
Brass
Bulls
Gibsons
Scouts
Whalers