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 | 28582 | 24126 | 9627 | 19435 | 4916 | 95.27% | 96.50% | 96.27% | 97.18% | 98.32% | 26 | 17337 - 96.32% | 661,607$ | 3,308,034$ | 18000 | 100 | 53,238,500$ | 0$ | 0$ | 8,398,672$ | 516,879$ | 8,270,064$ | 20 | 0 | 0$ | 17,201,777$ | 87 | 524,917$ | 45,667,779$ | 47,593,839$ | 53,238,537$ | 18,238,537$ | 75,000,000$ | 21,761,463$ | 44,395,746$ | 14,003,684$ |
2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 28779 | 24833 | 9743 | 19867 | 4966 | 95.93% | 99.33% | 97.43% | 99.34% | 99.32% | 26 | 17638 - 97.99% | 670,937$ | 3,354,683$ | 18000 | 100 | 64,543,703$ | 0$ | 0$ | 10,455,682$ | 626,638$ | 10,114,555$ | 20 | 0 | 0$ | 17,444,352$ | 87 | 647,958$ | 56,372,346$ | 58,301,286$ | 64,632,061$ | 29,632,061$ | 75,000,000$ | 10,367,939$ | 42,384,617$ | 1,527,683$ |
3 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 29296 | 24390 | 9859 | 19694 | 4814 | 97.65% | 97.56% | 98.59% | 98.47% | 96.28% | 26 | 17611 - 97.84% | 670,422$ | 3,352,110$ | 18000 | 100 | 65,062,143$ | 0$ | 0$ | 10,299,949$ | 631,671$ | 10,100,493$ | 20 | 0 | 0$ | 17,430,972$ | 87 | 644,137$ | 56,039,919$ | 58,757,859$ | 65,055,870$ | 30,055,870$ | 75,000,000$ | 9,944,130$ | 42,345,339$ | 1,018,452$ |
4 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 23379 | 18858 | 7798 | 15516 | 3953 | 97.41% | 94.29% | 97.48% | 96.98% | 98.83% | 27 | 17376 - 96.53% | 665,944$ | 2,663,777$ | 18000 | 100 | 68,595,718$ | 0$ | 0$ | 10,948,304$ | 665,978$ | 10,655,648$ | 20 | 0 | 0$ | 17,980,495$ | 87 | 684,269$ | 59,531,403$ | 62,122,503$ | 68,595,734$ | 33,595,734$ | 75,000,000$ | 6,404,266$ | 41,024,513$ | -3,117,495$ |
5 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 23731 | 19470 | 7688 | 15889 | 3978 | 98.88% | 97.35% | 96.10% | 99.31% | 99.45% | 27 | 17689 - 98.27% | 677,017$ | 2,708,069$ | 18000 | 100 | 73,483,333$ | 0$ | 0$ | 11,602,371$ | 713,430$ | 11,307,843$ | 22 | 0 | 0$ | 18,279,466$ | 87 | 731,838$ | 63,669,906$ | 66,037,926$ | 73,376,253$ | 38,376,253$ | 75,000,000$ | 1,623,747$ | 40,459,722$ | -7,298,738$ |
6 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 22945 | 19696 | 7869 | 15907 | 3918 | 95.60% | 98.48% | 98.36% | 99.42% | 97.95% | 27 | 17584 - 97.69% | 667,345$ | 2,669,378$ | 18000 | 100 | 62,816,590$ | 0$ | 0$ | 9,766,328$ | 609,870$ | 9,657,592$ | 20 | 0 | 0$ | 18,018,302$ | 87 | 616,666$ | 53,649,942$ | 57,258,582$ | 62,716,282$ | 27,716,282$ | 75,000,000$ | 12,283,718$ | 41,975,580$ | 2,735,300$ |
7 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 23475 | 19327 | 7786 | 15352 | 3920 | 97.81% | 96.64% | 97.33% | 95.95% | 98.00% | 27 | 17465 - 97.03% | 669,717$ | 2,678,868$ | 18000 | 100 | 67,122,263$ | 0$ | 0$ | 10,698,912$ | 651,672$ | 10,426,752$ | 21 | 0 | 0$ | 18,082,359$ | 87 | 668,682$ | 58,175,334$ | 60,216,474$ | 67,122,216$ | 32,122,216$ | 75,000,000$ | 7,877,784$ | 41,435,652$ | -698,463$ |
8 | Hurricanes | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 23559 | 18594 | 7928 | 15980 | 3927 | 98.16% | 92.97% | 99.10% | 99.88% | 98.18% | 27 | 17497 - 97.21% | 667,428$ | 2,669,711$ | 18000 | 100 | 59,180,000$ | 0$ | 0$ | 9,472,624$ | 574,563$ | 9,193,008$ | 20 | 0 | 0$ | 18,020,549$ | 87 | 592,039$ | 51,507,393$ | 54,602,613$ | 59,179,989$ | 24,179,989$ | 75,000,000$ | 15,820,011$ | 42,371,695$ | 5,789,631$ |
9 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 29170 | 23994 | 9764 | 19724 | 4936 | 97.23% | 95.98% | 97.64% | 98.62% | 98.72% | 26 | 17518 - 97.32% | 668,807$ | 3,344,033$ | 18000 | 100 | 64,984,416$ | 0$ | 0$ | 10,411,552$ | 630,917$ | 10,094,672$ | 20 | 0 | 0$ | 17,388,972$ | 87 | 650,722$ | 56,612,814$ | 59,472,054$ | 64,984,451$ | 29,984,451$ | 75,000,000$ | 10,015,549$ | 42,170,017$ | 86,935$ |
10 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 70 | 45 | 30 | 300 | 18870 | 14097 | 5600 | 9603 | 2381 | 78.63% | 70.49% | 70.00% | 60.02% | 59.53% | 27 | 12638 - 70.21% | 593,571$ | 2,374,284$ | 18000 | 100 | 59,583,333$ | 0$ | 0$ | 9,613,568$ | 578,479$ | 9,255,664$ | 20 | 0 | 0$ | 16,026,417$ | 87 | 600,848$ | 52,273,776$ | 56,346,696$ | 59,583,337$ | 24,583,337$ | 75,000,000$ | 15,416,663$ | 41,674,604$ | 1,354,325$ |
11 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 29225 | 23852 | 9913 | 19389 | 4802 | 97.42% | 95.41% | 99.13% | 96.95% | 96.04% | 26 | 17436 - 96.87% | 665,363$ | 3,326,815$ | 18000 | 100 | 69,658,712$ | 0$ | 0$ | 11,167,488$ | 676,298$ | 10,820,768$ | 21 | 0 | 0$ | 17,299,438$ | 87 | 697,968$ | 60,723,216$ | 63,588,456$ | 69,658,694$ | 34,658,694$ | 75,000,000$ | 5,341,306$ | 41,395,263$ | -4,893,755$ |
12 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 23012 | 19732 | 7699 | 15501 | 3826 | 95.88% | 98.66% | 96.24% | 96.88% | 95.65% | 27 | 17443 - 96.90% | 664,098$ | 2,656,392$ | 18000 | 100 | 62,001,667$ | 0$ | 0$ | 9,874,398$ | 601,958$ | 9,626,468$ | 20 | 0 | 0$ | 17,930,646$ | 87 | 617,453$ | 53,718,411$ | 56,809,131$ | 61,996,814$ | 26,996,814$ | 75,000,000$ | 13,003,186$ | 41,957,142$ | 3,078,657$ |