| 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 Average Salaries | 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 33,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 89 | 55 | 33 | 23 | 172 | 42000 | 35000 | 14000 | 28000 | 7000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 33 | 18000 - 100.00% | 1,309,850$ | 9,168,950$ | 18000 | 100 | 52,975,000$ | 49,200,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 2,758,140$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 99,715,855$ | 99,715,855$ | 43,715,855$ | 43,715,855$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 97 | 65 | 40 | 25 | 180 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 1,457,050$ | 4,371,150$ | 18000 | 100 | 55,075,000$ | 52,225,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 13,327,426$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 62,914,192$ | 62,914,192$ | 6,914,192$ | 6,914,192$ |
| 3 | Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 75 | 45 | 30 | 215 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 48,050,000$ | 52,300,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 69,652,124$ | 69,652,124$ | 13,652,124$ | 13,652,124$ |
| 4 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 75 | 50 | 35 | 225 | 52565 | 43155 | 16978 | 33840 | 8559 | 97.34% | 95.90% | 94.32% | 94.00% | 95.10% | 31 | 17233 - 95.74% | 1,691,864$ | 15,226,777$ | 18000 | 102 | 52,500,000$ | 57,680,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 4,954,704$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 107,183,068$ | 107,183,068$ | 51,183,068$ | 51,183,068$ |
| 5 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 124 | 75 | 44 | 29 | 219 | 16243 | 13603 | 5996 | 12000 | 2527 | 90.24% | 90.69% | 99.93% | 100.00% | 84.23% | 37 | 16790 - 93.28% | 1,609,845$ | 4,829,534$ | 18000 | 100 | 50,970,000$ | 49,820,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 79,532,939$ | 79,532,939$ | 23,532,939$ | 23,532,939$ |
| 6 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 102 | 66 | 42 | 28 | 182 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 54,760,000$ | 51,935,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 3,358,326$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 65,991,610$ | 65,991,610$ | 9,991,610$ | 9,991,610$ |
| 7 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 83 | 49 | 34 | 17 | 98 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 41,550,000$ | 40,145,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 61,709,398$ | 61,709,398$ | 5,709,398$ | 5,709,398$ |
| 8 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 102 | 52 | 42 | 26 | 193 | 12000 | 10000 | 4000 | 8000 | 1766 | 100.00% | 100.00% | 100.00% | 100.00% | 88.30% | 38 | 17883 - 99.35% | 1,414,982$ | 2,829,964$ | 18000 | 100 | 53,100,000$ | 52,900,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 4,150,326$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 67,330,256$ | 67,330,256$ | 11,330,256$ | 11,330,256$ |
| 9 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 65 | 40 | 28 | 180 | 24000 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18000 - 100.00% | 1,526,050$ | 6,104,200$ | 18000 | 100 | 52,650,000$ | 51,400,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 2,355,954$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 82,297,357$ | 82,297,357$ | 26,297,357$ | 26,297,357$ |
| 10 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 111 | 71 | 46 | 31 | 196 | 16602 | 13831 | 5722 | 10902 | 2852 | 92.23% | 92.21% | 95.37% | 90.85% | 95.07% | 37 | 16636 - 92.42% | 1,527,579$ | 4,582,737$ | 18000 | 100 | 52,570,000$ | 50,850,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 1,545,390$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 90,882,762$ | 90,882,762$ | 34,882,762$ | 34,882,762$ |
| 11 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 40 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 54,950,000$ | 52,350,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 23,651,609$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 62,872,881$ | 62,872,881$ | 6,872,881$ | 6,872,881$ |
| 12 | Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 93 | 59 | 39 | 27 | 160 | 60000 | 50000 | 20000 | 40000 | 10000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 30 | 18000 - 100.00% | 1,378,850$ | 13,788,500$ | 18000 | 100 | 53,695,000$ | 53,495,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 4,756,704$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 89,994,593$ | 89,994,593$ | 33,994,593$ | 33,994,593$ |
| 13 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 65 | 45 | 35 | 200 | 20283 | 20000 | 7219 | 12922 | 3618 | 84.51% | 100.00% | 90.24% | 80.76% | 90.45% | 36 | 16011 - 88.95% | 1,475,815$ | 5,903,260$ | 18000 | 100 | 56,000,000$ | 51,450,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 4,397,826$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 84,149,467$ | 84,149,467$ | 28,149,467$ | 28,149,467$ |
| 14 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 65 | 42 | 24 | 182 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 54,725,000$ | 49,175,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 3,345,954$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 59,956,765$ | 59,956,765$ | 3,956,765$ | 3,956,765$ |
| 15 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 30 | 20 | 175 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 53,875,000$ | 45,675,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 3,461,346$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 63,192,477$ | 63,192,477$ | 7,192,477$ | 7,192,477$ |
| 16 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 64 | 44 | 40 | 215 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 49,000,000$ | 47,050,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 199,980$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 72,084,069$ | 72,084,069$ | 16,084,069$ | 16,084,069$ |
| 17 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 70 | 46 | 30 | 180 | 59417 | 48136 | 19414 | 39327 | 10000 | 99.03% | 96.27% | 97.07% | 98.32% | 100.00% | 30 | 17629 - 97.94% | 1,584,498$ | 15,844,980$ | 18000 | 100 | 54,925,000$ | 50,125,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 3,191,265$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 121,045,793$ | 121,045,793$ | 65,045,793$ | 65,045,793$ |
| 18 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 70 | 46 | 30 | 180 | 69991 | 58065 | 23247 | 47215 | 12000 | 97.21% | 96.78% | 96.86% | 98.36% | 100.00% | 28 | 17543 - 97.46% | 1,572,565$ | 18,870,777$ | 18000 | 100 | 54,875,000$ | 47,300,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 4,800,015$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 79,157,453$ | 79,157,453$ | 23,157,453$ | 23,157,453$ |
| 19 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 70 | 45 | 35 | 195 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 55,400,000$ | 47,800,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 34,203,023$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 66,360,513$ | 66,360,513$ | 10,360,513$ | 10,360,513$ |
| 20 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 70 | 45 | 35 | 200 | 10558 | 8936 | 3665 | 6280 | 1726 | 87.98% | 89.36% | 91.63% | 78.50% | 86.30% | 38 | 15583 - 86.57% | 1,507,883$ | 3,015,766$ | 18000 | 100 | 57,150,000$ | 50,100,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 25,385,112$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 92,900,262$ | 92,900,262$ | 36,900,262$ | 36,900,262$ |
| 21 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 108 | 68 | 48 | 32 | 203 | 30000 | 25000 | 9641 | 19125 | 4714 | 100.00% | 100.00% | 96.41% | 95.63% | 94.28% | 35 | 17696 - 98.31% | 1,545,757$ | 7,728,783$ | 18000 | 100 | 56,275,000$ | 52,225,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 11,280,794$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 70,310,140$ | 70,310,140$ | 14,310,140$ | 14,310,140$ |
| 22 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 60 | 35 | 25 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 45,250,000$ | 41,250,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 437,826$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 76,980,765$ | 76,980,765$ | 20,980,765$ | 20,980,765$ |
| 23 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 107 | 71 | 48 | 33 | 190 | 30000 | 23489 | 9170 | 18544 | 5000 | 100.00% | 93.96% | 91.70% | 92.72% | 100.00% | 35 | 17241 - 95.78% | 1,582,361$ | 7,911,805$ | 18000 | 100 | 51,350,000$ | 53,200,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 2,665,326$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 112,012,241$ | 112,012,241$ | 56,012,241$ | 56,012,241$ |
| 24 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 103 | 68 | 43 | 28 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 53,450,000$ | 54,500,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 6,551,078$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 69,458,525$ | 69,458,525$ | 13,458,525$ | 13,458,525$ |
| 25 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 75 | 50 | 30 | 210 | 16017 | 12670 | 4980 | 10633 | 2584 | 88.98% | 84.47% | 83.00% | 88.61% | 86.13% | 37 | 15628 - 86.82% | 1,496,087$ | 4,488,260$ | 18000 | 100 | 55,249,999$ | 52,299,999$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 6,180,322$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 68,583,121$ | 68,583,121$ | 12,583,121$ | 12,583,121$ |
| 26 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 40 | 250 | 34100 | 28212 | 11075 | 20864 | 5336 | 94.72% | 94.04% | 92.29% | 86.93% | 88.93% | 34 | 16598 - 92.21% | 1,691,356$ | 10,148,134$ | 18000 | 100 | 52,400,000$ | 51,150,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 2,046,576$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -33,000,000$ | 97,607,909$ | 97,607,909$ | 41,607,909$ | 41,607,909$ |
Admirals
Barracuda
Bears
Condors
Griffins
IceHogs
Influenza
Monsters
Moose
Phantoms
Reign
Rocket
Sound Tigers
Checkers
Comets
Crunch
Devils
Eagles
Heat
Little Stars
Penguins
Punishers
Rampage
Senators
Thunderbirds
Wolfpack