| 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 | 128083 | 105743 | 41985 | 83040 | 16278 | 97.03% | 96.13% | 95.42% | 94.36% | 73.99% | 19 | 17051 - 94.73% | 1,179,725$ | 25,953,955$ | 18000 | 100 | 38,100,000$ | 38,100,000$ | 0$ | 20,143,414$ | 38,100,000$ | 19,883,056$ | 21 | 0 | 0$ | 22,414,779$ | 105 | 176,256$ | 18,506,880$ | 19,432,728$ | 39,975,000$ | 39,975,000$ | 58,000,000$ | 18,025,000$ | 46,842,502$ | 49,824,553$ |
| 2 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 121858 | 103951 | 41269 | 80699 | 16252 | 92.32% | 94.50% | 93.79% | 91.70% | 73.87% | 19 | 16547 - 91.93% | 1,142,507$ | 25,135,150$ | 18000 | 100 | 34,417,000$ | 34,417,000$ | 0$ | 17,892,840$ | 34,417,000$ | 17,632,578$ | 22 | 0 | 0$ | 21,707,630$ | 105 | 159,438$ | 16,740,990$ | 17,350,830$ | 35,580,200$ | 35,580,200$ | 58,000,000$ | 22,419,800$ | 84,291,416$ | 88,648,216$ |
| 3 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 124738 | 106145 | 41170 | 84136 | 17041 | 94.50% | 96.50% | 93.57% | 95.61% | 77.46% | 19 | 16965 - 94.25% | 1,172,502$ | 25,795,050$ | 18000 | 100 | 51,725,000$ | 51,725,000$ | 0$ | 27,893,353$ | 51,725,000$ | 27,633,080$ | 20 | 0 | 0$ | 22,277,543$ | 105 | 238,470$ | 25,039,350$ | 25,754,328$ | 53,175,000$ | 53,175,000$ | 58,000,000$ | 4,825,000$ | 29,799,711$ | 26,322,926$ |
| 4 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 127703 | 103455 | 41171 | 82849 | 16818 | 96.74% | 94.05% | 93.57% | 94.15% | 76.45% | 19 | 16909 - 93.94% | 1,175,155$ | 25,853,410$ | 18000 | 100 | 49,875,000$ | 49,875,000$ | 2,415,000$ | 25,472,592$ | 49,875,000$ | 25,212,319$ | 21 | 0 | 0$ | 22,327,945$ | 105 | 230,023$ | 24,152,415$ | 24,665,763$ | 53,190,000$ | 53,190,000$ | 58,000,000$ | 4,810,000$ | 39,611,761$ | 37,273,943$ |
| 5 | Colorado Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 129740 | 111016 | 43842 | 87951 | 17506 | 94.01% | 96.54% | 95.31% | 95.60% | 76.11% | 18 | 16959 - 94.22% | 1,168,235$ | 26,869,405$ | 18000 | 100 | 47,099,999$ | 46,599,998$ | 0$ | 27,708,467$ | 46,599,998$ | 27,187,939$ | 22 | 0 | 0$ | 21,028,230$ | 105 | 217,352$ | 22,821,960$ | 23,291,286$ | 47,329,998$ | 47,329,998$ | 58,000,000$ | 10,670,002$ | 37,619,421$ | 35,356,365$ |
| 6 | Dallas Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 127078 | 103837 | 41632 | 84050 | 16978 | 96.27% | 94.40% | 94.62% | 95.51% | 77.17% | 19 | 16981 - 94.34% | 1,176,909$ | 25,891,990$ | 18000 | 100 | 54,000,000$ | 54,000,000$ | 0$ | 26,369,831$ | 54,000,000$ | 26,109,569$ | 21 | 0 | 0$ | 22,361,264$ | 105 | 248,858$ | 26,130,090$ | 26,798,340$ | 55,322,500$ | 55,322,500$ | 58,000,000$ | 2,677,500$ | 47,339,189$ | 42,902,113$ |
| 7 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 126145 | 105416 | 41766 | 83380 | 16862 | 95.56% | 95.83% | 94.92% | 94.75% | 76.65% | 19 | 16980 - 94.34% | 1,175,371$ | 25,858,170$ | 18000 | 100 | 51,750,000$ | 51,750,000$ | 0$ | 29,043,380$ | 51,750,000$ | 28,783,090$ | 19 | 1 | 0$ | 22,332,056$ | 105 | 238,584$ | 25,051,320$ | 25,564,668$ | 52,650,000$ | 52,650,000$ | 58,000,000$ | 5,350,000$ | 50,460,678$ | 47,228,066$ |
| 8 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 65 | 40 | 25 | 175 | 128026 | 85932 | 32872 | 83973 | 21017 | 96.99% | 78.12% | 74.71% | 95.42% | 95.53% | 19 | 15992 - 88.84% | 1,100,005$ | 24,200,100$ | 18000 | 100 | 54,500,000$ | 54,500,000$ | 0$ | 27,893,856$ | 54,500,000$ | 27,633,584$ | 21 | 0 | 0$ | 20,900,086$ | 105 | 251,142$ | 26,369,910$ | 26,868,606$ | 55,360,000$ | 55,360,000$ | 58,000,000$ | 2,640,000$ | 31,102,040$ | 25,133,520$ |
| 9 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 126539 | 104001 | 41700 | 84762 | 16441 | 95.86% | 94.55% | 94.77% | 96.32% | 74.73% | 19 | 16975 - 94.30% | 1,170,941$ | 25,760,710$ | 18000 | 100 | 32,750,000$ | 32,750,000$ | 1,925,000$ | 20,304,135$ | 32,750,000$ | 20,043,807$ | 21 | 0 | 0$ | 22,247,886$ | 105 | 151,826$ | 15,941,730$ | 16,994,034$ | 37,045,000$ | 37,045,000$ | 58,000,000$ | 20,955,000$ | 76,359,305$ | 81,613,157$ |
| 10 | Minnesota Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 129588 | 108724 | 43026 | 87943 | 17581 | 93.90% | 94.54% | 93.53% | 95.59% | 76.44% | 18 | 16820 - 93.44% | 1,160,997$ | 26,702,925$ | 18000 | 100 | 45,750,000$ | 45,750,000$ | 0$ | 23,634,699$ | 45,750,000$ | 23,374,437$ | 23 | 0 | 0$ | 20,897,941$ | 105 | 211,187$ | 22,174,635$ | 22,779,657$ | 46,900,000$ | 46,900,000$ | 58,000,000$ | 11,100,000$ | 50,559,170$ | 48,677,454$ |
| 11 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 124082 | 104189 | 41579 | 84713 | 16404 | 94.00% | 94.72% | 94.50% | 96.26% | 74.56% | 19 | 16862 - 93.68% | 1,159,701$ | 25,513,430$ | 18000 | 100 | 38,200,000$ | 38,200,000$ | 0$ | 19,957,962$ | 38,200,000$ | 19,697,700$ | 21 | 0 | 0$ | 22,034,326$ | 105 | 176,712$ | 18,554,760$ | 19,278,912$ | 39,675,000$ | 39,675,000$ | 58,000,000$ | 18,325,000$ | 54,482,649$ | 57,238,063$ |
| 12 | Nashville Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 120915 | 102944 | 41746 | 81369 | 16267 | 91.60% | 93.59% | 94.88% | 92.46% | 73.94% | 19 | 16511 - 91.73% | 1,137,131$ | 25,016,875$ | 18000 | 100 | 35,900,000$ | 35,400,000$ | 0$ | 20,404,567$ | 35,400,000$ | 19,884,031$ | 22 | 0 | 0$ | 21,605,483$ | 105 | 166,210$ | 17,452,050$ | 17,892,072$ | 36,100,000$ | 36,100,000$ | 58,000,000$ | 21,900,000$ | 43,019,495$ | 46,732,906$ |
| 13 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 68 | 45 | 28 | 210 | 104798 | 79357 | 28514 | 65182 | 15739 | 79.39% | 72.14% | 64.80% | 74.07% | 71.54% | 19 | 13345 - 74.14% | 1,036,976$ | 22,813,482$ | 18000 | 100 | 56,650,000$ | 56,550,000$ | 0$ | 23,605,715$ | 56,550,000$ | 23,293,402$ | 22 | 0 | 0$ | 19,702,553$ | 105 | 260,959$ | 27,400,695$ | 28,071,717$ | 57,680,000$ | 57,680,000$ | 58,000,000$ | 320,000$ | 49,744,979$ | 41,375,815$ |
| 14 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 126875 | 103597 | 41912 | 83345 | 16433 | 96.12% | 94.18% | 95.25% | 94.71% | 74.70% | 19 | 16916 - 93.98% | 1,170,021$ | 25,740,465$ | 18000 | 100 | 50,100,000$ | 50,100,000$ | 0$ | 25,837,433$ | 50,100,000$ | 25,577,171$ | 21 | 0 | 0$ | 22,230,402$ | 105 | 231,050$ | 24,260,250$ | 24,865,272$ | 51,200,000$ | 51,200,000$ | 58,000,000$ | 6,800,000$ | 43,995,381$ | 41,360,511$ |
| 15 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 30 | 220 | 98744 | 85636 | 32404 | 62858 | 15285 | 74.81% | 77.85% | 73.65% | 71.43% | 69.48% | 19 | 13406 - 74.48% | 1,044,217$ | 22,972,780$ | 18000 | 100 | 50,999,999$ | 50,999,999$ | 2,100,000$ | 24,762,592$ | 50,999,999$ | 24,502,282$ | 22 | 0 | 0$ | 19,840,128$ | 105 | 235,160$ | 24,691,800$ | 25,421,496$ | 54,589,999$ | 54,589,999$ | 58,000,000$ | 3,410,001$ | 57,304,503$ | 51,723,135$ |
| 16 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 126951 | 104425 | 42774 | 84221 | 16887 | 96.18% | 94.93% | 97.21% | 95.71% | 76.76% | 19 | 17057 - 94.76% | 1,179,119$ | 25,940,615$ | 18000 | 100 | 51,000,000$ | 51,000,000$ | 175,000$ | 28,410,925$ | 51,000,000$ | 28,150,654$ | 21 | 1 | 0$ | 22,403,258$ | 105 | 235,160$ | 24,691,800$ | 25,206,996$ | 52,080,000$ | 52,080,000$ | 58,000,000$ | 5,920,000$ | 71,916,906$ | 69,113,168$ |
| 17 | Seattle Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 128043 | 106893 | 42125 | 84677 | 16867 | 97.00% | 97.18% | 95.74% | 96.22% | 76.67% | 19 | 17209 - 95.61% | 1,190,117$ | 26,182,580$ | 18000 | 100 | 49,000,000$ | 49,000,000$ | 0$ | 22,997,251$ | 49,000,000$ | 22,736,987$ | 22 | 1 | 0$ | 22,612,228$ | 105 | 226,027$ | 23,732,835$ | 24,479,031$ | 50,535,000$ | 50,535,000$ | 58,000,000$ | 7,465,000$ | 41,713,925$ | 39,847,122$ |
| 18 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 126405 | 104243 | 41998 | 83322 | 16623 | 95.76% | 94.77% | 95.45% | 94.68% | 75.56% | 19 | 16936 - 94.09% | 1,171,485$ | 25,772,660$ | 18000 | 100 | 53,000,000$ | 53,000,000$ | 0$ | 27,877,867$ | 53,000,000$ | 27,617,591$ | 22 | 0 | 0$ | 22,258,206$ | 105 | 244,292$ | 25,650,660$ | 26,218,986$ | 54,050,000$ | 54,050,000$ | 58,000,000$ | 3,950,000$ | 34,901,923$ | 30,941,143$ |
| 19 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 45 | 25 | 20 | 190 | 135495 | 111444 | 44694 | 89656 | 21639 | 98.18% | 96.91% | 97.16% | 97.45% | 94.08% | 18 | 17519 - 97.33% | 994,629$ | 22,876,460$ | 18000 | 100 | 48,425,000$ | 48,425,000$ | 0$ | 28,646,823$ | 48,425,000$ | 28,386,494$ | 21 | 0 | 0$ | 17,903,317$ | 105 | 223,402$ | 23,457,210$ | 23,988,906$ | 49,375,000$ | 49,375,000$ | 58,000,000$ | 8,625,000$ | 21,063,803$ | 14,978,214$ |
| 20 | Utah Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 120 | 70 | 50 | 25 | 54771 | 46358 | 18316 | 36612 | 22000 | 41.49% | 42.14% | 41.63% | 41.60% | 100.00% | 19 | 8094 - 44.96% | 917,267$ | 20,179,880$ | 18000 | 100 | 34,350,000$ | 34,350,000$ | 0$ | 22,257,513$ | 34,350,000$ | 21,997,248$ | 22 | 0 | 0$ | 17,428,078$ | 105 | 159,132$ | 16,708,860$ | 17,368,860$ | 35,600,000$ | 35,600,000$ | 58,000,000$ | 22,400,000$ | 23,870,965$ | 23,930,183$ |
| 21 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 130894 | 110596 | 43773 | 88510 | 17318 | 94.85% | 96.17% | 95.16% | 96.21% | 75.30% | 18 | 17004 - 94.47% | 1,171,025$ | 26,933,565$ | 18000 | 100 | 53,950,000$ | 53,950,000$ | 350,000$ | 28,193,142$ | 53,950,000$ | 27,932,880$ | 22 | 0 | 0$ | 21,078,442$ | 105 | 248,630$ | 26,106,150$ | 26,665,302$ | 55,325,000$ | 55,325,000$ | 58,000,000$ | 2,675,000$ | 74,663,859$ | 69,076,999$ |
| 22 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 126028 | 105346 | 43045 | 85292 | 16816 | 91.32% | 91.61% | 93.58% | 92.71% | 73.11% | 18 | 16371 - 90.95% | 1,127,202$ | 25,925,635$ | 18000 | 100 | 38,150,000$ | 38,150,000$ | 0$ | 20,624,210$ | 38,150,000$ | 20,363,948$ | 22 | 0 | 0$ | 20,289,627$ | 105 | 176,484$ | 18,530,820$ | 19,626,222$ | 40,637,500$ | 40,637,500$ | 58,000,000$ | 17,362,500$ | 43,608,569$ | 44,271,974$ |
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