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 | Current Bank Account | Projected Bank Account |
1 | Blackhawks | 3000 | 3000 | 4317 | 6000 | 1000 | 12 | 7 | 5 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 17317 | 100 | 2,190,000$ | 2,162,084$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 18,175$ | 2,290,050$ | 2,290,050$ | 5,000,000$ | 2,709,950$ |
2 | Blues | 3000 | 3000 | 5000 | 8000 | 1000 | 11 | 7 | 5 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 2,130,000$ | 2,086,250$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 17,778$ | 2,240,028$ | 2,271,504$ | 5,000,000$ | 2,728,496$ |
3 | Bruins | 2448 | 3000 | 3000 | 5000 | 1000 | 9 | 8 | 6 | 5 | 30 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 14448 | 100 | 1,835,000$ | 1,951,667$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 16,151$ | 2,035,026$ | 2,042,508$ | 5,000,000$ | 2,957,492$ |
4 | Bulls | 6000 | 5000 | 2000 | 4000 | 1000 | 11 | 8 | 5 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,010,000$ | 1,925,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 16,905$ | 2,130,030$ | 2,138,028$ | 5,000,000$ | 2,861,972$ |
5 | Canadiens | 1209 | 3200 | 5000 | 7500 | 1050 | 10 | 7 | 5 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 17959 | 100 | 2,225,000$ | 2,342,500$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 19,444$ | 2,449,944$ | 2,464,908$ | 5,000,000$ | 2,535,092$ |
6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 12 | 7 | 5 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,050,000$ | 2,003,333$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 18,056$ | 2,275,056$ | 2,283,054$ | 5,000,000$ | 2,716,946$ |
7 | Capitals | 6000 | 5000 | 3000 | 4500 | 1000 | 10 | 7 | 5 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 19500 | 100 | 2,170,000$ | 2,118,750$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 18,214$ | 2,294,964$ | 2,311,734$ | 5,000,000$ | 2,688,266$ |
8 | Flames | 4616 | 3772 | 1890 | 4000 | 1000 | 12 | 9 | 6 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 15278 | 100 | 1,899,000$ | 1,951,500$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 16,063$ | 2,023,938$ | 2,032,968$ | 5,000,000$ | 2,967,032$ |
9 | Flyers | 5380 | 5000 | 2000 | 4000 | 1000 | 11 | 8 | 5 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 17380 | 100 | 2,305,000$ | 2,403,375$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 18,968$ | 2,389,968$ | 2,397,966$ | 5,000,000$ | 2,602,034$ |
10 | Islanders | 5000 | 5000 | 2000 | 3297 | 1000 | 12 | 9 | 5 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 16297 | 100 | 2,175,000$ | 2,320,833$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 19,643$ | 2,475,018$ | 2,475,018$ | 5,000,000$ | 2,524,982$ |
11 | Jets | 3393 | 4000 | 3000 | 4000 | 1000 | 10 | 7 | 6 | 3 | 25 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 15393 | 100 | 2,140,000$ | 2,165,833$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 17,698$ | 2,229,948$ | 2,237,430$ | 5,000,000$ | 2,762,570$ |
12 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 10 | 7 | 5 | 4 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,070,000$ | 2,218,750$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 17,183$ | 2,165,058$ | 2,165,058$ | 5,000,000$ | 2,834,942$ |
13 | Maple Leafs | 757 | 3000 | 5000 | 7000 | 550 | 12 | 8 | 6 | 4 | 22 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 16307 | 100 | 2,095,000$ | 2,094,583$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 17,817$ | 2,244,942$ | 2,252,940$ | 5,000,000$ | 2,747,060$ |
14 | Nordiques | 3600 | 4000 | 2000 | 4576 | 1000 | 10 | 8 | 6 | 4 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 15176 | 100 | 1,970,000$ | 1,994,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 17,222$ | 2,169,972$ | 2,177,454$ | 5,000,000$ | 2,822,546$ |
15 | North Stars | 5000 | 4000 | 2000 | 3000 | 1000 | 10 | 9 | 6 | 4 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 15000 | 100 | 2,035,000$ | 2,098,750$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 16,905$ | 2,130,030$ | 2,152,992$ | 5,000,000$ | 2,847,008$ |
16 | Oilers | 1049 | 2500 | 5000 | 8500 | 50 | 12 | 8 | 4 | 3 | 22 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 17099 | 100 | 2,050,000$ | 2,070,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 17,262$ | 2,175,012$ | 2,175,012$ | 5,000,000$ | 2,824,988$ |
17 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 12 | 7 | 5 | 4 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,153,000$ | 2,257,167$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 18,675$ | 2,353,050$ | 2,360,016$ | 5,000,000$ | 2,639,984$ |
18 | Racers | 6000 | 5000 | 2000 | 4000 | 1000 | 12 | 6 | 5 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,095,000$ | 2,090,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 17,421$ | 2,195,046$ | 2,195,046$ | 5,000,000$ | 2,804,954$ |
19 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 12 | 8 | 5 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,191,000$ | 2,319,917$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 18,976$ | 2,390,976$ | 2,398,974$ | 5,000,000$ | 2,601,026$ |
20 | Red Wings | 3000 | 4000 | 2000 | 6700 | 1000 | 11 | 8 | 4 | 3 | 25 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 16700 | 100 | 2,125,000$ | 2,121,667$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 17,857$ | 2,249,982$ | 2,249,982$ | 5,000,000$ | 2,750,018$ |
21 | Rockies | 6000 | 5000 | 2000 | 4000 | 1000 | 11 | 8 | 5 | 3 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 1,970,000$ | 1,890,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 16,429$ | 2,070,054$ | 2,100,498$ | 5,000,000$ | 2,899,502$ |
22 | Sabres | 5000 | 4000 | 2284 | 4000 | 1000 | 9 | 7 | 6 | 4 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 16284 | 100 | 2,170,000$ | 2,251,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 18,095$ | 2,279,970$ | 2,279,970$ | 5,000,000$ | 2,720,030$ |
23 | Stingers | 6000 | 5000 | 2000 | 4000 | 1000 | 9 | 7 | 6 | 4 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 1,815,000$ | 1,815,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 15,595$ | 1,964,970$ | 1,964,970$ | 5,000,000$ | 3,035,030$ |
24 | Whalers | 5000 | 4000 | 2000 | 3635 | 1000 | 11 | 8 | 6 | 4 | 20 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 15635 | 100 | 2,210,000$ | 2,161,500$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 126 | 18,730$ | 2,359,980$ | 2,359,980$ | 5,000,000$ | 2,640,020$ |