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 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 | 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.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 81,900,000$ | 81,900,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 102,429,147$ | 102,429,147$ |
2 | Atlanta Supra | 7000 | 6000 | 3000 | 5000 | 2000 | 120 | 70 | 40 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 84,075,000$ | 84,075,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 94,008,140$ | 94,008,140$ |
3 | Boston Bruins | 7000 | 6000 | 3000 | 5000 | 2000 | 105 | 75 | 45 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 77,680,000$ | 77,680,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 120,061,731$ | 120,061,731$ |
4 | Calgary Red Bull | 7000 | 6000 | 3000 | 5000 | 2000 | 85 | 62 | 30 | 20 | 140 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 77,150,000$ | 77,150,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 28,555,927$ | 28,555,927$ |
5 | Chicago Blackhawks | 7000 | 6000 | 3000 | 5000 | 2000 | 180 | 88 | 47 | 35 | 275 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 81,950,000$ | 81,950,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 101,088,583$ | 101,088,583$ |
6 | Cleveland Bulldogs | 7000 | 6000 | 3000 | 5000 | 2000 | 90 | 60 | 35 | 20 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 74,800,000$ | 74,800,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 92,745,610$ | 92,745,610$ |
7 | Colorado Zipper | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 77,775,000$ | 77,775,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 30,487,345$ | 30,487,345$ |
8 | Dallas Storm | 6500 | 5500 | 2500 | 4000 | 1500 | 150 | 90 | 52 | 40 | 270 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 75,600,000$ | 75,600,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 60,838,298$ | 60,838,298$ |
9 | Detroit Red Wings | 7000 | 6000 | 3000 | 5000 | 2000 | 130 | 90 | 50 | 30 | 210 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 56,400,000$ | 56,400,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 104,493,558$ | 104,493,558$ |
10 | Edmonton Oilers | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 65 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 31,500,000$ | 31,500,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 114,544,118$ | 114,544,118$ |
11 | Halifax Thunder | 7000 | 6000 | 3000 | 5000 | 2000 | 125 | 75 | 40 | 30 | 205 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 60,775,000$ | 60,775,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 32,232,387$ | 32,232,387$ |
12 | Hamilton Tigers | 6500 | 5500 | 3000 | 4500 | 1500 | 115 | 70 | 40 | 28 | 205 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 21000 | 100 | 89,980,000$ | 89,980,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 86,851,380$ | 86,851,380$ |
13 | Houston Supernova | 6500 | 5000 | 2500 | 4500 | 1500 | 114 | 78 | 46 | 31 | 240 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 86,900,000$ | 86,900,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 19,333,607$ | 19,333,607$ |
14 | London Spartiates | 6000 | 5000 | 2250 | 4000 | 1250 | 100 | 70 | 60 | 40 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18500 | 100 | 69,500,000$ | 69,500,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 60,158,701$ | 60,158,701$ |
15 | Los Angeles Kings | 6500 | 5500 | 2500 | 4500 | 1500 | 109 | 72 | 45 | 31 | 221 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20500 | 100 | 40,750,000$ | 40,750,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 118,250,997$ | 118,250,997$ |
16 | Miami Heat | 6000 | 5000 | 2500 | 4000 | 1000 | 115 | 75 | 48 | 35 | 240 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18500 | 100 | 39,325,000$ | 39,325,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 87,712,621$ | 87,712,621$ |
17 | Moncton Wildcats | 7000 | 5250 | 4000 | 5000 | 1750 | 105 | 75 | 45 | 25 | 178 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 40,450,000$ | 40,450,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 57,716,308$ | 57,716,308$ |
18 | Montreal Canadiens | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 80 | 50 | 30 | 130 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 78,900,000$ | 78,900,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 22,029,897$ | 22,029,897$ |
19 | New York Rangers | 6000 | 5250 | 2250 | 4000 | 1500 | 126 | 75 | 51 | 33 | 235 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 46,775,000$ | 46,775,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 94,036,106$ | 94,036,106$ |
20 | Nunavut Mystery | 6000 | 5000 | 2250 | 4000 | 1250 | 130 | 80 | 55 | 40 | 240 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18500 | 100 | 34,325,000$ | 34,325,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 89,121,332$ | 89,121,332$ |
21 | Ottawa Lumberjacks | 7000 | 6000 | 3000 | 5000 | 2000 | 125 | 90 | 55 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 87,600,000$ | 87,600,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 95,759,473$ | 95,759,473$ |
22 | Quebec Nordiques | 7000 | 6000 | 3000 | 5000 | 2000 | 95 | 70 | 52 | 30 | 190 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 84,850,000$ | 84,850,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 97,898,075$ | 97,898,075$ |
23 | Regina Pats | 7000 | 6000 | 3000 | 5000 | 2000 | 140 | 90 | 50 | 40 | 220 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 85,350,000$ | 85,350,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 77,128,366$ | 77,128,366$ |
24 | San Jose Rhinos | 7000 | 6000 | 3000 | 5000 | 2000 | 91 | 56 | 35 | 19 | 181 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 83,000,000$ | 83,000,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 10,121,539$ | 10,121,539$ |
25 | Seattle Kraken | 7000 | 6000 | 3000 | 5000 | 2000 | 110 | 70 | 40 | 25 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 84,600,000$ | 84,600,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 92,142,217$ | 92,142,217$ |
26 | St-Johns Desperados | 7000 | 6000 | 3000 | 5000 | 2000 | 95 | 57 | 32 | 20 | 190 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 85,850,000$ | 85,850,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 70,079,695$ | 70,079,695$ |
27 | St-Louis Blues | 7000 | 6000 | 3000 | 5000 | 2000 | 90 | 60 | 35 | 25 | 190 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 81,051,100$ | 81,051,100$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 31,439,512$ | 31,439,512$ |
28 | Toronto Maple Leafs | 6500 | 5500 | 3000 | 5000 | 1500 | 175 | 85 | 70 | 55 | 300 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 21500 | 100 | 56,150,000$ | 56,150,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 66,897,012$ | 66,897,012$ |
29 | Vancouver Knights | 7000 | 6000 | 3000 | 5000 | 2000 | 145 | 115 | 90 | 75 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 86,300,000$ | 86,300,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 98,606,077$ | 98,606,077$ |
30 | Washington Budweiser | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 75 | 55 | 31 | 190 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 89,300,000$ | 89,300,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 22,836,201$ | 22,836,201$ |
31 | Winnipeg Jets | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23000 | 100 | 69,325,000$ | 69,325,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 69,011,926$ | 69,011,926$ |