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 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 | Estimated Season Salary Cap | Over Minimum Salary Cap of 60,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
1 | Bikers | 4000 | 4000 | 4000 | 4000 | 1100 | 99 | 69 | 44 | 32 | 165 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17100 | 100 | 67,052,509$ | 56,552,509$ | 0$ | 0$ | 0$ | 0$ | 16 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -78,308,783$ | -78,308,783$ |
2 | Blue Jackets | 4000 | 4000 | 4000 | 4000 | 1000 | 104 | 79 | 54 | 39 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 76,724,125$ | 76,724,125$ | 0$ | 0$ | 0$ | 0$ | 14 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -47,990,747$ | -47,990,747$ |
3 | Braves | 4000 | 4000 | 4000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 58,431,782$ | 58,431,782$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | 10,000,000$ | 10,000,000$ |
4 | Bulldogs | 4000 | 4000 | 4000 | 4900 | 1000 | 90 | 67 | 47 | 35 | 191 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17900 | 100 | 49,219,524$ | 49,219,524$ | 0$ | 0$ | 0$ | 0$ | 11 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -15,979,239$ | -15,979,239$ |
5 | Chiefs | 4000 | 4000 | 4000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 41,044,999$ | 33,506,999$ | 0$ | 0$ | 0$ | 0$ | 11 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -12,374,291$ | -12,374,291$ |
6 | Dogbones | 4100 | 4100 | 4000 | 4000 | 1030 | 100 | 73 | 53 | 34 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17230 | 100 | 83,190,500$ | 68,815,500$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -17,649,851$ | -17,649,851$ |
7 | Fighting Irish | 4000 | 4000 | 4100 | 4100 | 1000 | 110 | 80 | 55 | 40 | 210 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17200 | 100 | 40,400,000$ | 40,400,000$ | 0$ | 0$ | 0$ | 0$ | 11 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -91,330,079$ | -91,330,079$ |
8 | Flash | 4200 | 4100 | 4000 | 4000 | 1000 | 100 | 75 | 50 | 35 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17300 | 100 | 48,878,002$ | 32,128,002$ | 0$ | 0$ | 0$ | 0$ | 11 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -19,271,885$ | -19,271,885$ |
9 | Gongshow | 4000 | 4000 | 4000 | 4000 | 1000 | 100 | 72 | 50 | 35 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 56,024,000$ | 56,024,000$ | 0$ | 0$ | 0$ | 0$ | 11 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -78,046,103$ | -78,046,103$ |
10 | Icedogs | 4500 | 4500 | 4500 | 4700 | 1050 | 126 | 101 | 76 | 59 | 225 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19250 | 100 | 50,943,500$ | 50,943,500$ | 0$ | 0$ | 0$ | 0$ | 12 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | 6,327,491$ | 6,327,491$ |
11 | Kraken | 4000 | 4000 | 4000 | 4000 | 1000 | 100 | 65 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 69,463,857$ | 69,463,857$ | 0$ | 0$ | 0$ | 0$ | 14 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | 1,528,475$ | 1,528,475$ |
12 | LumberJacks | 4000 | 4000 | 4000 | 4000 | 1000 | 100 | 75 | 50 | 35 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 53,218,857$ | 53,218,857$ | 0$ | 0$ | 0$ | 0$ | 11 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -43,175,525$ | -43,175,525$ |
13 | Mariners | 4000 | 4000 | 4000 | 4000 | 1000 | 100 | 70 | 48 | 35 | 198 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 51,747,000$ | 51,747,000$ | 0$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | 14,243,601$ | 14,243,601$ |
14 | Nordiques | 4100 | 4100 | 4100 | 4100 | 1000 | 101 | 71 | 48 | 36 | 199 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17400 | 100 | 53,716,666$ | 53,716,666$ | 0$ | 0$ | 0$ | 0$ | 13 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -24,953,968$ | -24,953,968$ |
15 | Oilers | 4300 | 4200 | 4200 | 4200 | 1010 | 105 | 75 | 55 | 35 | 205 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17910 | 100 | 57,538,832$ | 57,538,832$ | 0$ | 0$ | 0$ | 0$ | 10 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -6,388,500$ | -6,388,500$ |
16 | Penguins | 4000 | 4000 | 4000 | 4000 | 1000 | 115 | 84 | 59 | 45 | 215 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 37,620,000$ | 28,920,000$ | 0$ | 0$ | 0$ | 0$ | 11 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -4,458,873$ | -4,458,873$ |
17 | Pirates | 4000 | 4000 | 4000 | 4000 | 1000 | 95 | 75 | 50 | 35 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 45,733,333$ | 45,733,332$ | 0$ | 0$ | 0$ | 0$ | 9 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -24,041,819$ | -24,041,819$ |
18 | Roadrunners | 4200 | 4000 | 4200 | 4000 | 1010 | 95 | 60 | 41 | 30 | 195 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17410 | 100 | 58,871,834$ | 58,871,834$ | 0$ | 0$ | 0$ | 0$ | 14 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -41,645,652$ | -41,645,652$ |
19 | Sens | 4200 | 4200 | 4200 | 4700 | 1130 | 100 | 75 | 50 | 35 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18430 | 100 | 49,788,501$ | 41,513,501$ | 0$ | 0$ | 0$ | 0$ | 14 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -18,754,385$ | -18,754,385$ |
20 | Stallions | 4000 | 4000 | 4000 | 4000 | 1000 | 100 | 72 | 50 | 32 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 53,962,000$ | 45,962,000$ | 0$ | 0$ | 0$ | 0$ | 11 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -10,959,871$ | -10,959,871$ |
21 | Thunder | 4000 | 4000 | 4000 | 4000 | 1000 | 125 | 77 | 55 | 35 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 48,825,000$ | 48,825,000$ | 0$ | 0$ | 0$ | 0$ | 10 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | 29,809,595$ | 29,809,595$ |
22 | Whalers | 4000 | 4000 | 4000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 71,231,667$ | 71,231,667$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | 10,000,000$ | 10,000,000$ |
23 | Wolf | 4200 | 4000 | 4000 | 4000 | 1000 | 95 | 60 | 41 | 30 | 195 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17200 | 100 | 62,596,500$ | 62,596,500$ | 0$ | 0$ | 0$ | 0$ | 13 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -8,947,826$ | -8,947,826$ |
24 | Wolverines | 4000 | 4000 | 4000 | 4000 | 1000 | 90 | 75 | 51 | 35 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17000 | 100 | 68,622,999$ | 64,372,999$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -60,000,000$ | 85,000,000$ | 85,000,000$ | -12,020,788$ | -12,020,788$ |