| 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 | Anaheim Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 160022 | 130321 | 52644 | 104489 | 21289 | 95.25% | 93.09% | 94.01% | 93.29% | 76.03% | 10 | 16742 - 93.01% | 1,161,929$ | 32,534,025$ | 18000 | 100 | 35,500,000$ | 35,500,000$ | 0$ | 25,988,654$ | 35,500,000$ | 25,648,431$ | 23 | 0 | 0$ | 12,781,224$ | 56 | 210,526$ | 11,789,456$ | 12,320,876$ | 36,550,000$ | 36,550,000$ | 58,000,000$ | 21,450,000$ | 40,015,028$ | 40,475,376$ |
| 2 | Boston Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 159989 | 135412 | 53564 | 106037 | 21178 | 95.23% | 96.72% | 95.65% | 94.68% | 75.64% | 10 | 17006 - 94.48% | 1,174,460$ | 32,884,885$ | 18000 | 100 | 44,500,000$ | 44,500,000$ | 0$ | 30,635,921$ | 44,500,000$ | 30,295,777$ | 20 | 0 | 0$ | 12,919,062$ | 56 | 263,158$ | 14,736,848$ | 15,319,688$ | 45,700,000$ | 45,700,000$ | 58,000,000$ | 12,300,000$ | 41,501,129$ | 39,100,503$ |
| 3 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 154813 | 125745 | 51857 | 102103 | 20453 | 92.15% | 89.82% | 92.60% | 91.16% | 73.05% | 10 | 16249 - 90.27% | 1,124,435$ | 31,484,170$ | 18000 | 100 | 24,500,000$ | 24,500,000$ | 0$ | 21,233,467$ | 24,500,000$ | 20,893,307$ | 20 | 0 | 0$ | 12,368,781$ | 56 | 146,199$ | 8,187,144$ | 8,831,724$ | 25,880,000$ | 25,880,000$ | 58,000,000$ | 32,120,000$ | 75,379,493$ | 78,916,550$ |
| 4 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 153605 | 127831 | 50861 | 102294 | 20673 | 94.82% | 94.69% | 94.19% | 94.72% | 76.57% | 11 | 16862 - 93.68% | 1,166,757$ | 31,502,445$ | 18000 | 100 | 55,050,000$ | 54,883,333$ | 0$ | 38,468,070$ | 54,883,333$ | 38,014,441$ | 20 | 1 | 0$ | 14,001,087$ | 56 | 324,854$ | 18,191,824$ | 18,603,244$ | 55,583,333$ | 55,583,333$ | 58,000,000$ | 2,416,667$ | 30,996,264$ | 26,394,107$ |
| 5 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 153745 | 126908 | 50689 | 100242 | 21055 | 94.90% | 94.01% | 93.87% | 92.82% | 77.98% | 12 | 16764 - 93.14% | 1,165,931$ | 31,480,145$ | 18000 | 100 | 54,400,000$ | 54,400,000$ | 1,750,000$ | 36,695,018$ | 54,400,000$ | 36,354,768$ | 21 | 0 | 0$ | 13,991,176$ | 56 | 321,053$ | 17,978,968$ | 18,458,968$ | 57,050,000$ | 57,050,000$ | 58,000,000$ | 950,000$ | 34,233,513$ | 29,765,721$ |
| 6 | Colorado Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 156061 | 128753 | 52396 | 103915 | 21071 | 96.33% | 95.37% | 97.03% | 96.22% | 78.04% | 11 | 17118 - 95.10% | 1,184,341$ | 31,977,215$ | 18000 | 100 | 55,249,999$ | 55,249,998$ | 0$ | 37,932,571$ | 55,249,998$ | 37,592,321$ | 23 | 0 | 0$ | 14,212,096$ | 56 | 326,023$ | 18,257,288$ | 18,677,288$ | 55,974,998$ | 55,974,998$ | 58,000,000$ | 2,025,002$ | 40,857,904$ | 36,392,712$ |
| 7 | Dallas Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 149761 | 123236 | 49321 | 100521 | 20063 | 96.00% | 94.80% | 94.85% | 96.65% | 77.17% | 12 | 17035 - 94.64% | 1,177,774$ | 30,622,120$ | 18000 | 100 | 53,750,000$ | 53,750,000$ | 0$ | 36,911,935$ | 53,750,000$ | 36,571,685$ | 20 | 0 | 0$ | 15,311,060$ | 56 | 317,251$ | 17,766,056$ | 18,254,636$ | 54,675,000$ | 54,675,000$ | 58,000,000$ | 3,325,000$ | 50,708,778$ | 47,765,202$ |
| 8 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 153564 | 127759 | 51955 | 103453 | 21010 | 94.79% | 94.64% | 96.21% | 95.79% | 77.81% | 12 | 16953 - 94.19% | 1,171,433$ | 31,628,690$ | 18000 | 100 | 54,450,000$ | 54,450,000$ | 0$ | 37,463,944$ | 54,450,000$ | 37,123,773$ | 20 | 1 | 0$ | 14,057,196$ | 56 | 321,345$ | 17,995,320$ | 18,646,740$ | 55,850,000$ | 55,850,000$ | 58,000,000$ | 2,150,000$ | 49,247,889$ | 44,658,345$ |
| 9 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 25 | 200 | 111562 | 107154 | 41262 | 106340 | 21582 | 66.41% | 76.54% | 73.68% | 94.95% | 77.08% | 10 | 13854 - 76.96% | 1,049,878$ | 29,396,575$ | 18000 | 100 | 53,500,000$ | 53,500,000$ | 0$ | 36,278,812$ | 53,500,000$ | 35,938,605$ | 20 | 0 | 0$ | 11,548,654$ | 56 | 315,789$ | 17,684,184$ | 18,201,924$ | 54,510,000$ | 54,510,000$ | 58,000,000$ | 3,490,000$ | 42,923,019$ | 36,269,749$ |
| 10 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 147594 | 123115 | 50109 | 100279 | 19780 | 94.61% | 94.70% | 96.36% | 96.42% | 76.08% | 13 | 16957 - 94.20% | 1,167,811$ | 30,363,090$ | 18000 | 100 | 35,500,000$ | 35,500,000$ | 875,000$ | 24,318,818$ | 35,500,000$ | 23,978,610$ | 22 | 0 | 0$ | 15,181,545$ | 56 | 210,526$ | 11,789,456$ | 12,560,876$ | 38,125,000$ | 38,125,000$ | 58,000,000$ | 19,875,000$ | 70,442,008$ | 73,062,677$ |
| 11 | Minnesota Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 155471 | 127460 | 51260 | 101545 | 20600 | 95.97% | 94.41% | 94.93% | 94.02% | 76.30% | 12 | 16901 - 93.90% | 1,172,127$ | 31,647,425$ | 18000 | 100 | 46,250,000$ | 46,250,000$ | 0$ | 31,208,292$ | 46,250,000$ | 30,868,109$ | 23 | 0 | 0$ | 14,065,522$ | 56 | 273,392$ | 15,309,952$ | 15,978,532$ | 47,700,000$ | 47,700,000$ | 58,000,000$ | 10,300,000$ | 51,506,844$ | 49,593,834$ |
| 12 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 151640 | 125537 | 50442 | 103575 | 20107 | 93.60% | 92.99% | 93.41% | 95.90% | 74.47% | 11 | 16715 - 92.86% | 1,150,832$ | 31,072,465$ | 18000 | 100 | 39,499,999$ | 39,499,999$ | 0$ | 26,612,637$ | 39,499,999$ | 26,272,403$ | 23 | 0 | 0$ | 13,809,984$ | 56 | 233,918$ | 13,099,408$ | 13,596,568$ | 40,449,999$ | 40,449,999$ | 58,000,000$ | 17,550,001$ | 49,327,071$ | 49,540,487$ |
| 13 | Nashville Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 159686 | 132705 | 52647 | 106526 | 20924 | 95.05% | 94.79% | 94.01% | 95.11% | 74.73% | 11 | 16875 - 93.75% | 1,165,053$ | 32,621,495$ | 18000 | 100 | 54,000,000$ | 54,000,000$ | 0$ | 37,200,363$ | 54,000,000$ | 36,860,187$ | 22 | 0 | 0$ | 12,815,587$ | 56 | 318,713$ | 17,847,928$ | 18,378,508$ | 55,047,500$ | 55,047,500$ | 58,000,000$ | 2,952,500$ | 42,204,355$ | 36,641,434$ |
| 14 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 68 | 45 | 28 | 210 | 151453 | 100329 | 36014 | 81767 | 20099 | 90.15% | 71.66% | 64.31% | 73.01% | 71.78% | 10 | 13917 - 77.31% | 1,101,994$ | 30,855,833$ | 18000 | 100 | 39,500,000$ | 39,500,000$ | 0$ | 32,781,836$ | 39,500,000$ | 32,441,677$ | 23 | 0 | 0$ | 12,121,934$ | 56 | 233,918$ | 13,099,408$ | 13,699,408$ | 40,750,000$ | 40,750,000$ | 58,000,000$ | 17,250,000$ | 52,400,691$ | 50,823,217$ |
| 15 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 157072 | 132184 | 53616 | 103948 | 21014 | 93.50% | 94.42% | 95.74% | 92.81% | 75.05% | 10 | 16708 - 92.82% | 1,154,154$ | 32,316,300$ | 18000 | 100 | 54,250,000$ | 54,250,000$ | 0$ | 36,867,469$ | 54,250,000$ | 36,527,322$ | 20 | 0 | 0$ | 12,695,689$ | 56 | 320,175$ | 17,929,800$ | 18,444,060$ | 55,250,000$ | 55,250,000$ | 58,000,000$ | 2,750,000$ | 46,760,629$ | 41,012,258$ |
| 16 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 30 | 220 | 127225 | 107760 | 41324 | 79875 | 19865 | 78.53% | 79.82% | 76.53% | 73.96% | 73.57% | 12 | 13928 - 77.38% | 1,084,865$ | 29,291,360$ | 18000 | 100 | 50,700,000$ | 50,700,000$ | 4,025,000$ | 31,917,187$ | 50,700,000$ | 31,576,937$ | 22 | 0 | 0$ | 13,018,382$ | 56 | 299,415$ | 16,767,240$ | 17,384,400$ | 56,025,000$ | 56,025,000$ | 58,000,000$ | 1,975,000$ | 54,285,895$ | 49,919,877$ |
| 17 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 160218 | 133375 | 53810 | 108287 | 21770 | 95.37% | 95.27% | 96.09% | 96.68% | 77.75% | 10 | 17052 - 94.73% | 1,177,458$ | 32,968,825$ | 18000 | 100 | 54,750,000$ | 54,750,000$ | 0$ | 37,426,649$ | 54,750,000$ | 37,086,428$ | 21 | 0 | 0$ | 12,952,038$ | 56 | 323,099$ | 18,093,544$ | 18,762,124$ | 56,200,000$ | 56,200,000$ | 58,000,000$ | 1,800,000$ | 72,047,068$ | 66,236,982$ |
| 18 | Seattle Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 155705 | 127135 | 51515 | 102531 | 20342 | 96.11% | 94.17% | 95.40% | 94.94% | 75.34% | 11 | 16934 - 94.08% | 1,171,604$ | 31,633,300$ | 18000 | 100 | 53,400,000$ | 53,400,000$ | 0$ | 36,231,482$ | 53,400,000$ | 35,891,255$ | 20 | 0 | 0$ | 14,059,244$ | 56 | 315,205$ | 17,651,480$ | 18,131,480$ | 54,300,000$ | 54,300,000$ | 58,000,000$ | 3,700,000$ | 44,630,259$ | 40,558,023$ |
| 19 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 153478 | 129117 | 51273 | 101838 | 20546 | 94.74% | 95.64% | 94.95% | 94.29% | 76.10% | 11 | 16898 - 93.88% | 1,168,316$ | 31,544,525$ | 18000 | 100 | 56,750,000$ | 56,750,000$ | 0$ | 37,148,388$ | 56,750,000$ | 36,808,204$ | 23 | 0 | 0$ | 14,019,789$ | 56 | 334,795$ | 18,748,520$ | 19,194,260$ | 57,550,000$ | 57,550,000$ | 58,000,000$ | 450,000$ | 41,008,927$ | 35,834,456$ |
| 20 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 50 | 30 | 20 | 180 | 163258 | 135713 | 54451 | 109350 | 26644 | 97.18% | 96.94% | 97.23% | 97.63% | 95.16% | 11 | 17479 - 97.11% | 1,016,526$ | 28,462,740$ | 18000 | 100 | 54,500,000$ | 54,500,000$ | 0$ | 35,726,935$ | 54,500,000$ | 35,386,784$ | 21 | 0 | 0$ | 11,181,791$ | 56 | 321,637$ | 18,011,672$ | 18,714,512$ | 56,050,000$ | 56,050,000$ | 58,000,000$ | 1,950,000$ | 34,503,567$ | 26,970,846$ |
| 21 | Utah Hockey Club | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 120 | 70 | 50 | 25 | 66525 | 55916 | 22152 | 44608 | 26939 | 41.06% | 41.42% | 41.02% | 41.30% | 99.77% | 11 | 8005 - 44.47% | 906,275$ | 24,469,435$ | 18000 | 100 | 43,350,000$ | 43,350,000$ | 0$ | 27,499,045$ | 43,350,000$ | 27,158,820$ | 23 | 0 | 0$ | 10,875,304$ | 56 | 256,433$ | 14,360,248$ | 17,865,988$ | 53,075,000$ | 53,075,000$ | 58,000,000$ | 4,925,000$ | 34,143,196$ | 27,152,512$ |
| 22 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 162329 | 134977 | 53751 | 105465 | 21507 | 96.62% | 96.41% | 95.98% | 94.17% | 76.81% | 11 | 17072 - 94.85% | 1,183,958$ | 33,150,830$ | 18000 | 100 | 54,750,000$ | 54,750,000$ | 0$ | 37,287,547$ | 54,750,000$ | 36,947,394$ | 21 | 0 | 0$ | 13,023,540$ | 56 | 323,099$ | 18,093,544$ | 18,736,384$ | 56,125,000$ | 56,125,000$ | 58,000,000$ | 1,875,000$ | 69,829,915$ | 64,117,071$ |
Admirals
Americiens
Broncos
Bruins
Butter Knives
Fighting Pandas
Firebirds
Lynx
Marlies
Roadrunners
Wombats
Aces
Barons
Barracuda
Canucks
Griffins
Ice Bats
Lions
Nordiks
Punishers
Tomahawks
Wranglers