| 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 | Boston Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 70105 | 57653 | 22992 | 45489 | 8911 | 97.37% | 96.09% | 95.80% | 94.77% | 74.26% | 29 | 17096 - 94.98% | 1,182,819$ | 14,193,825$ | 18000 | 100 | 37,600,000$ | 37,600,000$ | 0$ | 10,264,407$ | 37,600,000$ | 10,129,651$ | 20 | 0 | 0$ | 34,301,744$ | 160 | 173,973$ | 27,835,680$ | 29,230,568$ | 39,025,000$ | 39,025,000$ | 58,000,000$ | 18,975,000$ | 45,557,354$ | 50,628,530$ |
| 2 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 67408 | 56698 | 22442 | 44750 | 8876 | 93.62% | 94.50% | 93.51% | 93.23% | 73.97% | 29 | 16681 - 92.67% | 1,151,842$ | 13,822,100$ | 18000 | 100 | 33,917,000$ | 33,917,000$ | 0$ | 9,272,145$ | 33,917,000$ | 9,137,448$ | 21 | 0 | 0$ | 33,403,408$ | 160 | 157,155$ | 25,144,800$ | 26,296,478$ | 35,130,200$ | 35,130,200$ | 58,000,000$ | 22,869,800$ | 82,118,659$ | 89,225,589$ |
| 3 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62460 | 53331 | 20031 | 42114 | 8517 | 94.64% | 96.97% | 91.05% | 95.71% | 77.43% | 30 | 16950 - 94.17% | 1,173,018$ | 12,903,195$ | 18000 | 100 | 51,725,000$ | 51,725,000$ | 0$ | 14,777,503$ | 51,725,000$ | 14,642,795$ | 20 | 0 | 0$ | 35,190,532$ | 160 | 238,470$ | 38,155,200$ | 39,465,993$ | 53,175,000$ | 53,175,000$ | 58,000,000$ | 4,825,000$ | 30,618,967$ | 26,343,506$ |
| 4 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63915 | 51568 | 20826 | 40588 | 8475 | 96.84% | 93.76% | 94.66% | 92.25% | 77.05% | 30 | 16852 - 93.62% | 1,174,926$ | 12,924,190$ | 18000 | 100 | 49,000,000$ | 49,000,000$ | 2,415,000$ | 13,349,303$ | 49,000,000$ | 13,214,595$ | 20 | 0 | 0$ | 35,247,791$ | 160 | 226,027$ | 36,164,320$ | 37,164,264$ | 52,402,500$ | 52,402,500$ | 58,000,000$ | 5,597,500$ | 39,242,854$ | 37,326,381$ |
| 5 | Colorado Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62267 | 52584 | 21165 | 42074 | 8474 | 94.34% | 95.61% | 96.20% | 95.62% | 77.04% | 30 | 16960 - 94.22% | 1,169,924$ | 12,869,165$ | 18000 | 100 | 53,099,999$ | 52,599,998$ | 0$ | 14,367,135$ | 52,599,998$ | 14,097,741$ | 23 | 0 | 0$ | 35,097,723$ | 160 | 244,749$ | 39,159,840$ | 39,986,633$ | 53,329,998$ | 53,329,998$ | 58,000,000$ | 4,670,002$ | 37,339,108$ | 32,450,198$ |
| 6 | Dallas Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62638 | 52113 | 21049 | 42457 | 8656 | 94.91% | 94.75% | 95.68% | 96.49% | 78.69% | 30 | 16992 - 94.40% | 1,174,538$ | 12,919,920$ | 18000 | 100 | 48,000,000$ | 48,000,000$ | 0$ | 13,066,199$ | 48,000,000$ | 12,931,502$ | 20 | 0 | 0$ | 35,236,145$ | 160 | 221,461$ | 35,433,760$ | 36,658,885$ | 49,322,500$ | 49,322,500$ | 58,000,000$ | 8,677,500$ | 48,227,626$ | 46,804,886$ |
| 7 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62871 | 52367 | 20794 | 41608 | 8238 | 95.26% | 95.21% | 94.52% | 94.56% | 74.89% | 30 | 16898 - 93.88% | 1,167,701$ | 12,844,710$ | 18000 | 100 | 56,750,000$ | 56,750,000$ | 0$ | 15,103,881$ | 56,750,000$ | 14,969,168$ | 21 | 0 | 0$ | 35,031,027$ | 160 | 261,416$ | 41,826,560$ | 42,767,698$ | 57,650,000$ | 57,650,000$ | 58,000,000$ | 350,000$ | 51,814,507$ | 44,077,836$ |
| 8 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 65 | 40 | 25 | 175 | 64313 | 42433 | 16230 | 40942 | 10545 | 97.44% | 77.15% | 73.77% | 93.05% | 95.86% | 30 | 15860 - 88.11% | 1,096,767$ | 12,064,440$ | 18000 | 100 | 53,750,000$ | 53,750,000$ | 0$ | 14,514,851$ | 53,750,000$ | 14,380,154$ | 20 | 0 | 0$ | 32,903,018$ | 160 | 247,717$ | 39,634,720$ | 40,548,996$ | 54,610,000$ | 54,610,000$ | 58,000,000$ | 3,390,000$ | 32,749,567$ | 25,103,589$ |
| 9 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63397 | 52629 | 21278 | 42751 | 8296 | 96.06% | 95.69% | 96.72% | 97.16% | 75.42% | 30 | 17123 - 95.13% | 1,179,104$ | 12,970,145$ | 18000 | 100 | 38,250,000$ | 38,250,000$ | 1,925,000$ | 11,521,257$ | 38,250,000$ | 11,386,508$ | 20 | 0 | 0$ | 35,373,123$ | 160 | 176,941$ | 28,310,560$ | 29,634,784$ | 41,645,000$ | 41,645,000$ | 58,000,000$ | 16,355,000$ | 73,073,448$ | 78,811,787$ |
| 10 | Minnesota Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 68132 | 56712 | 22596 | 46197 | 8886 | 94.63% | 94.52% | 94.15% | 96.24% | 74.05% | 29 | 16877 - 93.76% | 1,161,575$ | 13,938,905$ | 18000 | 100 | 44,750,000$ | 44,750,000$ | 0$ | 12,249,997$ | 44,750,000$ | 12,115,300$ | 21 | 0 | 0$ | 33,685,687$ | 160 | 206,621$ | 33,059,360$ | 34,202,084$ | 45,950,000$ | 45,950,000$ | 58,000,000$ | 12,050,000$ | 49,697,056$ | 49,180,659$ |
| 11 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62245 | 52600 | 20896 | 42907 | 8228 | 94.31% | 95.64% | 94.98% | 97.52% | 74.80% | 30 | 16989 - 94.38% | 1,166,376$ | 12,830,135$ | 18000 | 100 | 37,700,000$ | 37,700,000$ | 0$ | 10,261,632$ | 37,700,000$ | 10,126,935$ | 20 | 0 | 0$ | 34,991,277$ | 160 | 174,429$ | 27,908,640$ | 29,269,890$ | 39,225,000$ | 39,225,000$ | 58,000,000$ | 18,775,000$ | 52,101,924$ | 57,823,311$ |
| 12 | Nashville Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 61130 | 51853 | 21046 | 40627 | 8276 | 92.62% | 94.28% | 95.66% | 92.33% | 75.24% | 30 | 16630 - 92.39% | 1,148,333$ | 12,631,665$ | 18000 | 100 | 38,400,000$ | 37,900,000$ | 0$ | 11,080,363$ | 37,900,000$ | 10,810,966$ | 20 | 1 | 0$ | 34,449,995$ | 160 | 177,626$ | 28,420,160$ | 29,260,384$ | 38,650,000$ | 38,650,000$ | 58,000,000$ | 19,350,000$ | 40,327,667$ | 45,517,278$ |
| 13 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 68 | 45 | 28 | 210 | 52085 | 39635 | 14118 | 32235 | 7807 | 78.92% | 72.06% | 64.17% | 73.26% | 70.97% | 30 | 13262 - 73.68% | 1,031,042$ | 11,341,465$ | 18000 | 100 | 43,575,000$ | 43,475,000$ | 0$ | 11,732,551$ | 43,475,000$ | 11,570,898$ | 23 | 0 | 0$ | 30,931,268$ | 160 | 201,256$ | 32,200,960$ | 33,330,253$ | 44,455,000$ | 44,455,000$ | 58,000,000$ | 13,545,000$ | 50,688,075$ | 48,289,090$ |
| 14 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63528 | 52000 | 20989 | 41952 | 8224 | 96.25% | 94.55% | 95.40% | 95.35% | 74.76% | 30 | 16972 - 94.29% | 1,172,820$ | 12,901,015$ | 18000 | 100 | 50,600,000$ | 50,600,000$ | 0$ | 13,026,948$ | 50,600,000$ | 12,892,251$ | 22 | 0 | 0$ | 35,184,586$ | 160 | 233,333$ | 37,333,280$ | 38,408,849$ | 51,650,000$ | 51,650,000$ | 58,000,000$ | 6,350,000$ | 44,458,091$ | 41,233,828$ |
| 15 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 30 | 220 | 49964 | 43368 | 16214 | 30472 | 7576 | 75.70% | 78.85% | 73.70% | 69.25% | 68.87% | 30 | 13418 - 74.54% | 1,049,491$ | 11,544,400$ | 18000 | 100 | 40,999,999$ | 40,999,999$ | 2,100,000$ | 12,057,102$ | 40,999,999$ | 11,922,357$ | 21 | 0 | 0$ | 31,484,727$ | 160 | 189,498$ | 30,319,680$ | 31,657,456$ | 44,589,999$ | 44,589,999$ | 58,000,000$ | 13,410,001$ | 59,206,327$ | 59,033,598$ |
| 16 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 62742 | 50338 | 21124 | 41303 | 8337 | 95.06% | 91.52% | 96.02% | 93.87% | 75.79% | 30 | 16713 - 92.85% | 1,157,618$ | 12,733,795$ | 18000 | 100 | 56,250,000$ | 56,250,000$ | 175,000$ | 15,295,640$ | 56,250,000$ | 15,160,940$ | 20 | 0 | 0$ | 34,728,532$ | 160 | 259,132$ | 41,461,120$ | 42,472,801$ | 57,430,000$ | 57,430,000$ | 58,000,000$ | 570,000$ | 72,268,841$ | 64,524,572$ |
| 17 | Seattle Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 70112 | 58303 | 22889 | 46621 | 9235 | 97.38% | 97.17% | 95.37% | 97.13% | 76.96% | 29 | 17263 - 95.91% | 1,193,585$ | 14,323,020$ | 18000 | 100 | 41,400,000$ | 41,400,000$ | 0$ | 10,783,563$ | 41,400,000$ | 10,648,866$ | 20 | 0 | 0$ | 34,613,965$ | 160 | 191,324$ | 30,611,840$ | 32,181,452$ | 43,235,000$ | 43,235,000$ | 58,000,000$ | 14,765,000$ | 42,749,015$ | 45,181,528$ |
| 18 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 63225 | 51838 | 20873 | 41648 | 8368 | 95.80% | 94.25% | 94.88% | 94.65% | 76.07% | 30 | 16905 - 93.92% | 1,170,740$ | 12,878,135$ | 18000 | 100 | 52,250,000$ | 52,250,000$ | 0$ | 14,416,682$ | 52,250,000$ | 14,281,971$ | 22 | 1 | 0$ | 35,122,186$ | 160 | 240,868$ | 38,538,880$ | 39,513,656$ | 53,200,000$ | 53,200,000$ | 58,000,000$ | 4,800,000$ | 35,899,129$ | 31,507,659$ |
| 19 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 45 | 25 | 20 | 190 | 70422 | 58816 | 23264 | 46625 | 11552 | 97.81% | 98.03% | 96.93% | 97.14% | 96.27% | 29 | 17557 - 97.54% | 999,122$ | 11,989,460$ | 18000 | 100 | 56,750,000$ | 56,750,000$ | 0$ | 15,409,840$ | 56,750,000$ | 15,275,090$ | 20 | 0 | 0$ | 28,974,528$ | 160 | 261,416$ | 41,826,560$ | 42,868,491$ | 57,800,000$ | 57,800,000$ | 58,000,000$ | 200,000$ | 23,873,777$ | 9,979,814$ |
| 20 | Utah Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 120 | 70 | 50 | 25 | 27116 | 23120 | 9188 | 18565 | 11000 | 41.08% | 42.04% | 41.76% | 42.19% | 100.00% | 30 | 8090 - 44.94% | 913,092$ | 10,044,010$ | 18000 | 100 | 47,850,000$ | 47,850,000$ | 0$ | 12,991,539$ | 47,850,000$ | 12,856,842$ | 21 | 0 | 0$ | 27,392,755$ | 160 | 220,776$ | 35,324,160$ | 36,634,953$ | 49,250,000$ | 49,250,000$ | 58,000,000$ | 8,750,000$ | 23,570,246$ | 14,328,048$ |
| 21 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 68187 | 57352 | 22726 | 45804 | 8928 | 94.70% | 95.59% | 94.69% | 95.43% | 74.40% | 29 | 16916 - 93.98% | 1,165,494$ | 13,985,930$ | 18000 | 100 | 53,450,000$ | 53,450,000$ | 350,000$ | 14,534,473$ | 53,450,000$ | 14,399,776$ | 21 | 0 | 0$ | 33,799,331$ | 160 | 246,347$ | 39,415,520$ | 40,474,270$ | 54,875,000$ | 54,875,000$ | 58,000,000$ | 3,125,000$ | 75,842,799$ | 69,167,860$ |
| 22 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 67542 | 55919 | 22762 | 44767 | 9088 | 93.81% | 93.20% | 94.84% | 93.26% | 75.73% | 29 | 16673 - 92.63% | 1,153,565$ | 13,842,785$ | 18000 | 100 | 39,250,000$ | 39,250,000$ | 0$ | 10,676,943$ | 39,250,000$ | 10,542,246$ | 23 | 0 | 0$ | 33,453,397$ | 160 | 181,507$ | 29,041,120$ | 31,015,719$ | 41,687,500$ | 41,687,500$ | 58,000,000$ | 16,312,500$ | 42,372,755$ | 44,810,433$ |
Admirals
Americiens
Broncos
Bruins
Butter Knives
Fighting Pandas
Firebirds
Lynx
Marlies
Roadrunners
Wombats
Aces
Barons
Barracuda
Canucks
Griffins
Ice Bats
Lions
Nordiks
Quacken
Tomahawks
Wranglers