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 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 35,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 86058 | 72334 | 29330 | 58054 | 14726 | 95.62% | 96.45% | 97.77% | 96.76% | 98.17% | 16 | 17367 - 96.48% | 662,885$ | 9,943,270$ | 18000 | 100 | 53,238,500$ | 53,238,500$ | 0$ | 24,671,099$ | 516,879$ | 24,293,313$ | 20 | 0 | 0$ | 10,606,155$ | 56 | 524,917$ | 29,395,352$ | 30,326,281$ | 53,238,537$ | 18,238,537$ | 75,000,000$ | 21,761,463$ | 33,763,424$ | 14,043,298$ |
2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 81361 | 68632 | 27499 | 55404 | 13757 | 96.86% | 98.05% | 98.21% | 98.94% | 98.26% | 17 | 17618 - 97.88% | 670,842$ | 9,391,781$ | 18000 | 100 | 69,843,703$ | 69,843,703$ | 0$ | 32,086,090$ | 678,094$ | 31,084,013$ | 20 | 0 | 0$ | 11,404,306$ | 56 | 699,415$ | 39,167,240$ | 40,099,561$ | 69,057,277$ | 34,057,277$ | 75,000,000$ | 5,942,723$ | 25,794,688$ | -2,900,567$ |
3 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 81700 | 67799 | 27786 | 54861 | 13632 | 97.26% | 96.86% | 99.24% | 97.97% | 97.37% | 17 | 17556 - 97.53% | 669,196$ | 9,368,738$ | 18000 | 100 | 70,162,143$ | 70,162,143$ | 0$ | 30,879,846$ | 681,186$ | 30,293,944$ | 21 | 0 | 0$ | 11,376,325$ | 56 | 693,652$ | 38,844,512$ | 40,158,183$ | 68,440,360$ | 33,440,360$ | 75,000,000$ | 6,559,640$ | 26,377,801$ | -2,404,057$ |
4 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 81426 | 67839 | 27296 | 54859 | 13882 | 96.94% | 96.91% | 97.49% | 97.96% | 99.16% | 17 | 17522 - 97.34% | 669,502$ | 9,373,034$ | 18000 | 100 | 64,745,718$ | 64,745,718$ | 0$ | 31,607,246$ | 628,599$ | 30,747,569$ | 21 | 0 | 0$ | 11,381,541$ | 56 | 646,890$ | 36,225,840$ | 37,430,529$ | 65,949,113$ | 30,949,113$ | 75,000,000$ | 9,050,887$ | 25,743,985$ | -305,003$ |
5 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 88083 | 73113 | 29016 | 58534 | 14719 | 97.87% | 97.48% | 96.72% | 97.56% | 98.13% | 16 | 17564 - 97.58% | 671,921$ | 10,078,817$ | 18000 | 100 | 73,483,333$ | 73,483,333$ | 0$ | 34,289,349$ | 713,430$ | 33,424,173$ | 22 | 0 | 0$ | 10,750,738$ | 56 | 731,838$ | 40,982,928$ | 42,127,471$ | 73,376,253$ | 38,376,253$ | 75,000,000$ | 1,623,747$ | 23,920,015$ | -7,456,718$ |
6 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 81768 | 67799 | 27366 | 55698 | 13747 | 97.34% | 96.86% | 97.74% | 99.46% | 98.19% | 17 | 17598 - 97.77% | 670,446$ | 9,386,250$ | 18000 | 100 | 63,641,590$ | 63,641,590$ | 0$ | 27,429,715$ | 617,880$ | 27,110,303$ | 20 | 0 | 0$ | 11,397,589$ | 56 | 624,676$ | 34,981,856$ | 36,809,987$ | 61,711,583$ | 26,711,583$ | 75,000,000$ | 13,288,417$ | 29,100,176$ | 3,687,778$ |
7 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 88326 | 73277 | 28791 | 58436 | 14672 | 98.14% | 97.70% | 95.97% | 97.39% | 97.81% | 16 | 17567 - 97.59% | 672,467$ | 10,087,012$ | 18000 | 100 | 64,576,430$ | 64,576,430$ | 0$ | 31,378,620$ | 626,956$ | 30,579,152$ | 21 | 0 | 0$ | 10,759,479$ | 56 | 643,965$ | 36,062,040$ | 37,145,712$ | 65,688,688$ | 30,688,688$ | 75,000,000$ | 9,311,312$ | 27,102,801$ | 716,568$ |
8 | Hurricanes | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 81922 | 67410 | 27446 | 54158 | 13709 | 97.53% | 96.30% | 98.02% | 96.71% | 97.92% | 17 | 17475 - 97.08% | 668,736$ | 9,362,302$ | 18000 | 100 | 59,180,000$ | 59,180,000$ | 0$ | 27,825,833$ | 574,563$ | 27,004,461$ | 20 | 0 | 0$ | 11,368,510$ | 56 | 592,039$ | 33,154,184$ | 34,650,207$ | 59,179,989$ | 24,179,989$ | 75,000,000$ | 15,820,011$ | 29,111,880$ | 5,830,183$ |
9 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 88740 | 73635 | 29141 | 58978 | 14792 | 98.60% | 98.18% | 97.14% | 98.30% | 98.61% | 16 | 17686 - 98.25% | 676,500$ | 10,147,498$ | 18000 | 100 | 64,984,416$ | 64,984,416$ | 0$ | 30,583,934$ | 630,917$ | 29,653,099$ | 20 | 0 | 0$ | 10,823,998$ | 56 | 650,722$ | 36,440,432$ | 37,822,398$ | 64,984,451$ | 29,984,451$ | 75,000,000$ | 10,015,549$ | 27,323,826$ | 325,426$ |
10 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 70 | 45 | 30 | 300 | 65835 | 50840 | 18892 | 33701 | 8331 | 78.38% | 72.63% | 67.47% | 60.18% | 59.51% | 17 | 12686 - 70.48% | 595,615$ | 8,338,616$ | 18000 | 100 | 59,583,333$ | 59,583,333$ | 0$ | 28,239,856$ | 578,479$ | 27,188,513$ | 20 | 0 | 0$ | 10,125,462$ | 56 | 600,848$ | 33,647,488$ | 35,616,066$ | 59,583,337$ | 24,583,337$ | 75,000,000$ | 15,416,663$ | 26,908,306$ | 1,417,702$ |
11 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 87160 | 73666 | 29661 | 58771 | 14691 | 96.84% | 98.22% | 98.87% | 97.95% | 97.94% | 16 | 17597 - 97.76% | 670,550$ | 10,058,243$ | 18000 | 100 | 69,658,712$ | 69,658,712$ | 0$ | 32,804,496$ | 676,298$ | 31,786,006$ | 21 | 0 | 0$ | 10,728,793$ | 56 | 697,968$ | 39,086,208$ | 40,471,074$ | 69,658,694$ | 34,658,694$ | 75,000,000$ | 5,341,306$ | 25,009,309$ | -4,732,972$ |
12 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 81911 | 68282 | 27275 | 54336 | 13808 | 97.51% | 97.55% | 97.41% | 97.03% | 98.63% | 17 | 17544 - 97.47% | 671,431$ | 9,400,030$ | 18000 | 100 | 62,001,667$ | 62,001,667$ | 0$ | 29,015,441$ | 601,958$ | 28,287,166$ | 20 | 0 | 0$ | 11,414,322$ | 56 | 617,453$ | 34,577,368$ | 36,071,216$ | 61,996,814$ | 26,996,814$ | 75,000,000$ | 13,003,186$ | 27,962,865$ | 3,305,971$ |