| 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 52,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Anaheim Icehawks | 7000 | 6000 | 3000 | 5000 | 2000 | 110 | 70 | 35 | 28 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 65,975,000$ | 65,975,000$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 202,276,529$ | 202,276,529$ |
| 2 | Atlanta Supra | 7000 | 6000 | 3000 | 5000 | 2000 | 120 | 70 | 40 | 25 | 200 | 56000 | 48000 | 24000 | 40000 | 15875 | 100.00% | 100.00% | 100.00% | 100.00% | 99.22% | 33 | 22984 - 99.93% | 2,472,438$ | 19,779,500$ | 23000 | 100 | 90,335,000$ | 90,335,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 105,033,782$ | 105,033,782$ |
| 3 | Boston Bruins | 7000 | 6000 | 3000 | 5000 | 2000 | 110 | 80 | 50 | 30 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 67,825,000$ | 67,825,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 177,795,632$ | 177,795,632$ |
| 4 | Calgary Red Bull | 7000 | 6000 | 3000 | 5000 | 2000 | 110 | 75 | 50 | 35 | 195 | 76949 | 65930 | 33000 | 53116 | 21748 | 99.93% | 99.89% | 100.00% | 96.57% | 98.85% | 30 | 22795 - 99.11% | 2,500,827$ | 27,509,092$ | 23000 | 100 | 89,550,000$ | 89,550,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 44,184,994$ | 44,184,994$ |
| 5 | Chicago Blackhawks | 7000 | 6000 | 3000 | 5000 | 2000 | 180 | 88 | 47 | 35 | 275 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 87,475,000$ | 87,475,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 51,139,168$ | 51,139,168$ |
| 6 | Cleveland Bulldogs | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 45 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 69,150,000$ | 69,150,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 124,455,452$ | 124,455,452$ |
| 7 | Colorado Zipper | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 60,560,000$ | 60,560,000$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 93,342,349$ | 93,342,349$ |
| 8 | Dallas Storm | 6500 | 5500 | 2500 | 4000 | 1500 | 150 | 90 | 52 | 40 | 270 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 62,075,000$ | 62,075,000$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 129,394,170$ | 129,394,170$ |
| 9 | Detroit Red Wings | 7000 | 6000 | 3000 | 5000 | 2000 | 130 | 90 | 50 | 30 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 90,200,000$ | 90,200,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 125,957,457$ | 125,957,457$ |
| 10 | Edmonton Oilers | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 65 | 35 | 20 | 200 | 14000 | 12000 | 6000 | 10000 | 3711 | 100.00% | 100.00% | 100.00% | 100.00% | 92.78% | 39 | 22856 - 99.37% | 2,165,930$ | 4,331,860$ | 23000 | 100 | 85,800,000$ | 85,800,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 141,666,536$ | 141,666,536$ |
| 11 | Halifax Thunder | 7000 | 6000 | 3000 | 5000 | 2000 | 250 | 175 | 150 | 100 | 325 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 91,225,000$ | 91,225,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 62,650,785$ | 62,650,785$ |
| 12 | Hamilton Tigers | 6500 | 5500 | 3000 | 4500 | 1500 | 100 | 80 | 60 | 40 | 200 | 13000 | 11000 | 5066 | 7943 | 3000 | 100.00% | 100.00% | 84.43% | 88.26% | 100.00% | 39 | 20005 - 95.26% | 2,211,092$ | 4,422,184$ | 21000 | 100 | 88,150,000$ | 88,150,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 97,874,992$ | 97,874,992$ |
| 13 | Houston Supernova | 6500 | 5000 | 2500 | 4500 | 1500 | 114 | 78 | 46 | 31 | 240 | 39000 | 30000 | 15000 | 27000 | 9000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 20000 - 100.00% | 2,269,150$ | 13,614,900$ | 20000 | 100 | 88,650,000$ | 88,650,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 100,919,755$ | 100,919,755$ |
| 14 | London Spartiates | 7000 | 6000 | 3000 | 5000 | 2000 | 150 | 80 | 70 | 50 | 200 | 16242 | 17366 | 6223 | 10601 | 5747 | 77.34% | 96.48% | 69.14% | 70.67% | 95.78% | 38 | 18726 - 81.42% | 2,574,277$ | 7,722,832$ | 23000 | 100 | 87,750,000$ | 87,750,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 66,064,226$ | 66,064,226$ |
| 15 | Los Angeles Kings | 7000 | 6000 | 3000 | 5000 | 2000 | 102 | 60 | 37 | 27 | 166 | 21000 | 18000 | 9000 | 15000 | 5730 | 100.00% | 100.00% | 100.00% | 100.00% | 95.50% | 38 | 22910 - 99.61% | 2,128,178$ | 6,384,534$ | 23000 | 100 | 88,575,000$ | 88,575,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 109,441,084$ | 109,441,084$ |
| 16 | Miami Heat | 6000 | 5000 | 2500 | 4000 | 1000 | 145 | 105 | 65 | 53 | 282 | 83000 | 68688 | 34704 | 54752 | 14000 | 98.81% | 98.13% | 99.15% | 97.77% | 100.00% | 27 | 18225 - 98.51% | 2,502,130$ | 35,029,822$ | 18500 | 100 | 91,625,000$ | 91,625,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 114,089,839$ | 114,089,839$ |
| 17 | Moncton Wildcats | 7000 | 5250 | 4000 | 5000 | 1750 | 105 | 75 | 45 | 25 | 178 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 88,775,000$ | 88,775,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 129,662,351$ | 129,662,351$ |
| 18 | Montreal Canadiens | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 77 | 48 | 30 | 130 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 85,850,000$ | 85,850,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 42,867,656$ | 42,867,656$ |
| 19 | New York Rangers | 6000 | 5250 | 2250 | 4000 | 1500 | 126 | 75 | 51 | 33 | 235 | 17953 | 15750 | 6750 | 12000 | 4470 | 99.74% | 100.00% | 100.00% | 100.00% | 99.33% | 38 | 18974 - 99.86% | 2,268,079$ | 6,804,236$ | 19000 | 100 | 87,600,000$ | 87,600,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 158,064,199$ | 158,064,199$ |
| 20 | Nunavut Mystery | 6000 | 5000 | 2250 | 4000 | 1250 | 175 | 100 | 75 | 60 | 300 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 76,975,000$ | 76,975,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 141,786,225$ | 141,786,225$ |
| 21 | Ottawa Lumberjacks | 7000 | 6000 | 3000 | 5000 | 2000 | 125 | 90 | 55 | 25 | 200 | 46230 | 36091 | 20240 | 35000 | 13831 | 94.35% | 85.93% | 96.38% | 100.00% | 98.79% | 34 | 21627 - 94.03% | 2,559,392$ | 17,915,741$ | 23000 | 100 | 92,491,667$ | 92,491,667$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 117,236,194$ | 117,236,194$ |
| 22 | Quebec Nordiques | 7000 | 6000 | 3000 | 5000 | 2000 | 95 | 68 | 50 | 30 | 190 | 42000 | 36000 | 17895 | 29927 | 11992 | 100.00% | 100.00% | 99.42% | 99.76% | 99.93% | 35 | 22969 - 99.87% | 2,276,959$ | 13,661,752$ | 23000 | 100 | 87,775,000$ | 87,775,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 84,923,585$ | 84,923,585$ |
| 23 | Regina Pats | 7000 | 6000 | 3000 | 5000 | 2000 | 140 | 90 | 50 | 40 | 220 | 11631 | 9104 | 5779 | 8021 | 3147 | 83.08% | 75.87% | 96.32% | 80.21% | 78.68% | 39 | 18841 - 81.92% | 2,437,390$ | 4,874,779$ | 23000 | 100 | 88,150,000$ | 88,150,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 48,343,460$ | 48,343,460$ |
| 24 | San Jose Rhinos | 7000 | 6000 | 3000 | 5000 | 2000 | 145 | 115 | 90 | 75 | 250 | 21336 | 15744 | 6689 | 9566 | 6039 | 76.20% | 65.60% | 55.74% | 47.83% | 75.49% | 37 | 14844 - 64.54% | 2,513,384$ | 10,053,537$ | 23000 | 100 | 89,425,000$ | 89,425,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 36,644,448$ | 36,644,448$ |
| 25 | Seattle Kraken | 7000 | 6000 | 3000 | 5000 | 2000 | 110 | 75 | 50 | 35 | 200 | 19697 | 16551 | 7801 | 13040 | 5305 | 93.80% | 91.95% | 86.68% | 86.93% | 88.42% | 38 | 20798 - 90.43% | 2,467,062$ | 7,401,187$ | 23000 | 100 | 92,650,000$ | 92,650,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 70,272,174$ | 70,272,174$ |
| 26 | St-Johns Desperados | 7000 | 6000 | 3000 | 5000 | 2000 | 85 | 55 | 30 | 25 | 160 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 65,700,000$ | 65,700,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 95,972,028$ | 95,972,028$ |
| 27 | St-Louis Blues | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 65 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 88,725,000$ | 88,725,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 31,825,483$ | 31,825,483$ |
| 28 | Toronto Maple Leafs | 6500 | 5500 | 3000 | 5000 | 1500 | 125 | 80 | 65 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21500 | 100 | 59,120,000$ | 59,120,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 106,924,085$ | 106,924,085$ |
| 29 | Vancouver Knights | 7000 | 6000 | 3000 | 5000 | 2000 | 145 | 115 | 90 | 75 | 250 | 58295 | 42580 | 19200 | 27892 | 16092 | 83.28% | 70.97% | 64.00% | 55.78% | 80.46% | 31 | 16406 - 71.33% | 2,755,009$ | 27,550,087$ | 23000 | 100 | 89,250,000$ | 89,250,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 86,384,981$ | 86,384,981$ |
| 30 | Washington Budweiser | 7000 | 6000 | 3000 | 5000 | 2000 | 130 | 100 | 75 | 55 | 230 | 38021 | 27646 | 13040 | 20311 | 10333 | 90.53% | 76.79% | 72.44% | 67.70% | 86.11% | 35 | 18225 - 79.24% | 2,638,789$ | 15,832,733$ | 23000 | 100 | 90,000,000$ | 90,000,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 55,861,442$ | 55,861,442$ |
| 31 | Winnipeg Jets | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 66,550,000$ | 66,550,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 91,000,000$ | 91,000,000$ | 92,223,325$ | 92,223,325$ |