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 15,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
1 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 38 | 25 | 200 | 213868 | 173158 | 67278 | 157208 | 34519 | 86.94% | 84.47% | 82.05% | 95.86% | 84.19% | 0 | 15757 - 87.54% | 891,183$ | 36,538,503$ | 18000 | 100 | 32,821,000$ | 32,821,000$ | 0$ | 32,130,985$ | 32,821,000$ | 32,130,985$ | 21 | 0 | 0$ | 0$ | 1 | 242,434$ | 242,434$ | 258,396$ | 35,141,800$ | 20,141,800$ | 40,000,000$ | 4,858,200$ | 9,541,026$ | 9,282,630$ |
2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 130 | 100 | 50 | 41 | 225 | 161755 | 114089 | 51488 | 89335 | 29237 | 65.75% | 55.65% | 62.79% | 54.47% | 71.31% | 0 | 10876 - 60.42% | 846,074$ | 34,689,035$ | 18000 | 100 | 30,987,000$ | 30,987,000$ | 0$ | 27,980,017$ | 30,987,000$ | 27,980,017$ | 25 | 0 | 0$ | 0$ | 1 | 228,949$ | 228,949$ | 236,391$ | 32,149,050$ | 17,149,050$ | 40,000,000$ | 7,850,950$ | 17,148,307$ | 16,911,916$ |
3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 236967 | 193586 | 78332 | 154599 | 38611 | 96.33% | 94.43% | 95.53% | 94.27% | 94.17% | 0 | 17124 - 95.13% | 908,061$ | 37,230,491$ | 18000 | 100 | 27,431,000$ | 27,431,000$ | 0$ | 29,463,463$ | 27,431,000$ | 29,463,463$ | 22 | 0 | 0$ | 0$ | 1 | 202,801$ | 202,801$ | 210,897$ | 28,682,000$ | 13,682,000$ | 40,000,000$ | 11,318,000$ | 17,529,262$ | 17,318,365$ |
4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 231333 | 197607 | 78963 | 155251 | 38099 | 94.04% | 96.39% | 96.30% | 94.67% | 92.92% | 0 | 17104 - 95.02% | 900,997$ | 36,940,876$ | 18000 | 100 | 19,732,800$ | 19,732,800$ | 0$ | 20,622,380$ | 19,732,800$ | 20,622,380$ | 21 | 1 | 0$ | 0$ | 1 | 146,197$ | 146,197$ | 159,752$ | 21,726,300$ | 6,726,300$ | 40,000,000$ | 18,273,700$ | 35,489,894$ | 35,330,142$ |
5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 65 | 38 | 28 | 205 | 227590 | 196580 | 77955 | 152399 | 35155 | 92.52% | 95.89% | 95.07% | 92.93% | 85.74% | 0 | 16821 - 93.45% | 933,875$ | 38,288,873$ | 18000 | 100 | 23,858,000$ | 23,858,000$ | 0$ | 23,778,122$ | 23,858,000$ | 23,778,122$ | 22 | 0 | 0$ | 0$ | 1 | 176,529$ | 176,529$ | 185,159$ | 25,181,700$ | 10,181,700$ | 40,000,000$ | 14,818,300$ | 31,135,229$ | 30,950,070$ |
6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 235762 | 196962 | 78797 | 157267 | 38679 | 95.84% | 96.08% | 96.09% | 95.89% | 94.34% | 0 | 17255 - 95.86% | 911,328$ | 37,364,468$ | 18000 | 100 | 19,458,000$ | 19,458,000$ | 0$ | 20,268,541$ | 19,458,000$ | 20,268,541$ | 21 | 0 | 0$ | 0$ | 1 | 144,176$ | 144,176$ | 154,213$ | 20,973,000$ | 5,973,000$ | 40,000,000$ | 19,027,000$ | 33,197,130$ | 33,042,917$ |
7 | Mighty Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 236783 | 197256 | 76952 | 158076 | 38573 | 96.25% | 96.22% | 93.84% | 96.39% | 94.08% | 0 | 17260 - 95.89% | 912,320$ | 37,405,111$ | 18000 | 100 | 25,593,000$ | 25,593,000$ | 0$ | 25,152,682$ | 25,593,000$ | 25,152,682$ | 24 | 0 | 0$ | 0$ | 1 | 189,287$ | 189,287$ | 198,693$ | 27,022,200$ | 12,022,200$ | 40,000,000$ | 12,977,800$ | 21,300,502$ | 21,101,809$ |
8 | Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 30 | 20 | 200 | 238060 | 199657 | 81052 | 161854 | 39719 | 96.77% | 97.39% | 98.84% | 98.69% | 96.88% | 0 | 17569 - 97.61% | 903,619$ | 37,048,392$ | 18000 | 100 | 29,283,000$ | 29,283,000$ | 0$ | 27,942,487$ | 29,283,000$ | 27,942,487$ | 22 | 0 | 0$ | 0$ | 1 | 216,419$ | 216,419$ | 229,968$ | 31,275,700$ | 16,275,700$ | 40,000,000$ | 8,724,300$ | 22,615,281$ | 22,385,313$ |
9 | Northstars | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 60 | 35 | 25 | 200 | 194037 | 197381 | 78787 | 156579 | 38677 | 78.88% | 96.28% | 96.08% | 95.48% | 94.33% | 0 | 16231 - 90.17% | 870,628$ | 35,695,762$ | 18000 | 100 | 31,891,500$ | 31,891,500$ | 0$ | 31,812,045$ | 31,891,500$ | 31,812,045$ | 21 | 0 | 0$ | 0$ | 1 | 235,599$ | 235,599$ | 244,389$ | 33,237,000$ | 18,237,000$ | 40,000,000$ | 6,763,000$ | 20,134,414$ | 19,890,025$ |
10 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 67 | 41 | 27 | 205 | 232784 | 198496 | 67710 | 156076 | 36146 | 94.63% | 96.83% | 82.57% | 95.17% | 88.16% | 0 | 16859 - 93.66% | 938,509$ | 38,478,878$ | 18000 | 100 | 25,750,000$ | 25,750,000$ | 0$ | 25,320,276$ | 25,750,000$ | 25,320,276$ | 24 | 0 | 0$ | 0$ | 1 | 190,441$ | 190,441$ | 203,952$ | 27,737,450$ | 12,737,450$ | 40,000,000$ | 12,262,550$ | 31,435,049$ | 31,231,097$ |
11 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 235862 | 197553 | 78711 | 157565 | 39517 | 95.88% | 96.37% | 95.99% | 96.08% | 96.38% | 0 | 17298 - 96.10% | 915,307$ | 37,527,592$ | 18000 | 100 | 27,641,000$ | 27,641,000$ | 0$ | 27,102,118$ | 27,641,000$ | 27,102,118$ | 22 | 0 | 0$ | 0$ | 1 | 204,346$ | 204,346$ | 212,521$ | 28,902,800$ | 13,902,800$ | 40,000,000$ | 11,097,200$ | 28,352,596$ | 28,140,075$ |
12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 120 | 70 | 50 | 250 | 140028 | 94261 | 36576 | 72746 | 26299 | 56.92% | 45.98% | 44.60% | 44.36% | 64.14% | 0 | 9022 - 50.12% | 824,778$ | 33,815,918$ | 18000 | 100 | 22,963,000$ | 22,963,000$ | 0$ | 22,354,101$ | 22,963,000$ | 22,354,101$ | 23 | 0 | 0$ | 0$ | 1 | 169,949$ | 169,949$ | 186,270$ | 25,332,700$ | 10,332,700$ | 40,000,000$ | 14,667,300$ | 24,740,824$ | 24,554,554$ |
13 | Rockies | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 231192 | 194323 | 79082 | 154040 | 38193 | 93.98% | 94.79% | 96.44% | 93.93% | 93.15% | 0 | 16996 - 94.42% | 897,001$ | 36,777,037$ | 18000 | 100 | 22,969,000$ | 22,969,000$ | 0$ | 22,303,062$ | 22,969,000$ | 22,303,062$ | 23 | 0 | 0$ | 0$ | 1 | 169,993$ | 169,993$ | 179,810$ | 24,454,080$ | 9,454,080$ | 40,000,000$ | 15,545,920$ | 29,096,782$ | 28,916,972$ |
14 | Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 121 | 100 | 50 | 35 | 180 | 178697 | 118478 | 52083 | 107319 | 39330 | 72.64% | 57.79% | 63.52% | 65.44% | 95.93% | 0 | 12095 - 67.20% | 862,604$ | 35,366,773$ | 18000 | 100 | 32,165,000$ | 32,165,000$ | 0$ | 31,246,949$ | 32,165,000$ | 31,246,949$ | 25 | 0 | 0$ | 0$ | 1 | 237,610$ | 237,610$ | 248,765$ | 33,832,100$ | 18,832,100$ | 40,000,000$ | 6,167,900$ | 25,299,116$ | 25,050,351$ |