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 33,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 89 | 55 | 33 | 23 | 172 | 235641 | 196481 | 78874 | 159274 | 39453 | 98.18% | 98.24% | 98.59% | 99.55% | 98.63% | 0 | 17743 - 98.57% | 1,288,879$ | 51,555,147$ | 18000 | 100 | 52,975,000$ | 49,200,000$ | 0$ | 53,948,250$ | 264,875$ | 53,273,250$ | 20 | 0 | 2,758,140$ | 0$ | 0 | 267,875$ | 0$ | 0$ | 53,273,250$ | 20,273,250$ | 90,366,741$ | 37,093,491$ | 34,366,741$ | 34,366,741$ |
2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 97 | 65 | 40 | 25 | 180 | 233996 | 194400 | 78152 | 156542 | 38752 | 97.50% | 97.20% | 97.69% | 97.84% | 96.88% | 0 | 17546 - 97.48% | 1,418,772$ | 56,750,892$ | 18000 | 100 | 55,075,000$ | 52,225,000$ | 0$ | 55,454,625$ | 275,375$ | 54,004,625$ | 22 | 0 | 13,327,426$ | 0$ | 0 | 280,375$ | 0$ | 0$ | 54,004,625$ | 21,004,625$ | 58,543,042$ | 4,538,417$ | 2,543,042$ | 2,543,042$ |
3 | Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 75 | 45 | 30 | 215 | 186008 | 146621 | 62751 | 129776 | 29523 | 77.50% | 73.31% | 78.44% | 81.11% | 73.81% | 0 | 13867 - 77.04% | 1,306,745$ | 52,269,815$ | 18000 | 100 | 48,050,000$ | 52,300,000$ | 0$ | 48,386,250$ | 240,250$ | 47,161,250$ | 22 | 0 | 0$ | 0$ | 0 | 245,250$ | 0$ | 0$ | 47,161,250$ | 14,161,250$ | 69,652,124$ | 22,490,874$ | 13,652,124$ | 13,652,124$ |
4 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 75 | 50 | 35 | 225 | 192777 | 151387 | 60295 | 124826 | 30464 | 80.32% | 75.69% | 75.37% | 78.02% | 76.16% | 0 | 13994 - 77.74% | 1,334,333$ | 53,373,311$ | 18000 | 102 | 52,500,000$ | 57,680,000$ | 0$ | 54,287,000$ | 262,500$ | 53,637,000$ | 22 | 0 | 4,954,704$ | 0$ | 0 | 265,750$ | 0$ | 0$ | 53,637,000$ | 20,637,000$ | 91,305,921$ | 37,668,921$ | 35,305,921$ | 35,305,921$ |
5 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 124 | 75 | 44 | 29 | 219 | 177084 | 150509 | 64966 | 156884 | 29584 | 73.79% | 75.25% | 81.21% | 98.05% | 73.96% | 0 | 14476 - 80.42% | 1,355,092$ | 54,203,672$ | 18000 | 100 | 50,970,000$ | 49,820,000$ | 0$ | 48,621,600$ | 254,850$ | 47,721,600$ | 22 | 0 | 0$ | 0$ | 0 | 258,600$ | 0$ | 0$ | 47,721,600$ | 14,721,600$ | 74,459,280$ | 26,737,680$ | 18,459,280$ | 18,459,280$ |
6 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 102 | 66 | 42 | 28 | 182 | 228908 | 187160 | 75014 | 147192 | 38004 | 95.38% | 93.58% | 93.77% | 92.00% | 95.01% | 0 | 16907 - 93.93% | 1,432,499$ | 57,299,951$ | 18000 | 100 | 54,760,000$ | 51,935,000$ | 0$ | 55,643,250$ | 273,800$ | 53,343,250$ | 22 | 0 | 3,358,326$ | 0$ | 0 | 283,800$ | 0$ | 0$ | 53,343,250$ | 20,343,250$ | 65,657,710$ | 12,314,460$ | 9,657,710$ | 9,657,710$ |
7 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 83 | 49 | 34 | 17 | 98 | 234701 | 195900 | 77976 | 159216 | 40000 | 97.79% | 97.95% | 97.47% | 99.51% | 100.00% | 0 | 17695 - 98.30% | 1,102,768$ | 44,110,712$ | 18000 | 100 | 41,550,000$ | 40,145,000$ | 0$ | 46,141,450$ | 207,750$ | 42,853,950$ | 23 | 0 | 0$ | 0$ | 0 | 223,250$ | 0$ | 0$ | 42,853,950$ | 9,853,950$ | 61,650,598$ | 18,796,648$ | 5,650,598$ | 5,650,598$ |
8 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 102 | 52 | 42 | 26 | 193 | 231343 | 197838 | 77546 | 156321 | 33314 | 96.39% | 98.92% | 96.93% | 97.70% | 83.29% | 0 | 17409 - 96.72% | 1,369,519$ | 54,780,756$ | 18000 | 100 | 53,100,000$ | 52,900,000$ | 0$ | 54,527,250$ | 265,500$ | 53,679,750$ | 21 | 0 | 4,150,326$ | 0$ | 0 | 269,250$ | 0$ | 0$ | 53,679,750$ | 20,679,750$ | 64,500,292$ | 10,820,542$ | 8,500,292$ | 8,500,292$ |
9 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 65 | 40 | 28 | 180 | 233269 | 196224 | 78110 | 137106 | 39149 | 97.20% | 98.11% | 97.64% | 85.69% | 97.87% | 0 | 17096 - 94.98% | 1,479,541$ | 59,181,620$ | 18000 | 100 | 52,650,000$ | 51,400,000$ | 0$ | 54,474,000$ | 263,250$ | 52,331,500$ | 21 | 0 | 2,355,954$ | 0$ | 0 | 273,250$ | 0$ | 0$ | 52,331,500$ | 19,331,500$ | 76,193,157$ | 23,861,657$ | 20,193,157$ | 20,193,157$ |
10 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 111 | 71 | 46 | 31 | 196 | 191942 | 153931 | 61874 | 127164 | 32367 | 79.98% | 76.97% | 77.34% | 79.48% | 80.92% | 0 | 14182 - 78.79% | 1,304,298$ | 52,171,917$ | 18000 | 100 | 53,070,000$ | 51,350,000$ | 0$ | 53,372,750$ | 261,100$ | 50,972,250$ | 21 | 1 | 1,545,390$ | 0$ | 0 | 275,350$ | 0$ | 0$ | 50,972,250$ | 17,972,250$ | 85,237,278$ | 34,265,028$ | 29,237,278$ | 29,237,278$ |
11 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 40 | 250 | 172626 | 143076 | 56360 | 99417 | 25739 | 71.93% | 71.54% | 70.45% | 62.14% | 64.35% | 0 | 12430 - 69.06% | 1,309,228$ | 52,369,138$ | 18000 | 100 | 54,950,000$ | 52,350,000$ | 0$ | 57,575,000$ | 274,750$ | 54,610,000$ | 22 | 0 | 23,651,609$ | 0$ | 0 | 287,250$ | 0$ | 0$ | 54,610,000$ | 21,610,000$ | 62,606,851$ | 7,996,851$ | 6,606,851$ | 6,606,851$ |
12 | Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 93 | 59 | 39 | 27 | 160 | 235868 | 197324 | 78419 | 156833 | 39171 | 98.28% | 98.66% | 98.02% | 98.02% | 97.93% | 0 | 17690 - 98.28% | 1,355,218$ | 54,208,739$ | 18000 | 100 | 54,995,000$ | 54,595,000$ | 0$ | 54,714,625$ | 257,475$ | 52,654,625$ | 21 | 1 | 4,756,704$ | 0$ | 0 | 284,975$ | 0$ | 0$ | 52,654,625$ | 19,654,625$ | 75,674,709$ | 23,020,084$ | 19,674,709$ | 19,674,709$ |
13 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 65 | 45 | 35 | 200 | 187315 | 192452 | 63171 | 113075 | 32474 | 78.05% | 96.23% | 78.96% | 70.67% | 81.19% | 0 | 14712 - 81.73% | 1,366,387$ | 54,655,489$ | 18000 | 100 | 56,000,000$ | 51,600,000$ | 0$ | 58,409,750$ | 270,000$ | 54,024,750$ | 22 | 1 | 4,397,826$ | 0$ | 0 | 300,000$ | 0$ | 0$ | 54,024,750$ | 21,024,750$ | 78,246,207$ | 24,221,457$ | 22,246,207$ | 22,246,207$ |
14 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 65 | 42 | 24 | 182 | 231347 | 194139 | 74411 | 157131 | 38153 | 96.39% | 97.07% | 93.01% | 98.21% | 95.38% | 0 | 17380 - 96.55% | 1,460,478$ | 58,419,102$ | 18000 | 100 | 54,725,000$ | 49,175,000$ | 0$ | 56,467,125$ | 273,625$ | 53,969,000$ | 20 | 0 | 3,345,954$ | 0$ | 0 | 284,625$ | 0$ | 0$ | 53,969,000$ | 20,969,000$ | 59,807,665$ | 5,838,665$ | 3,807,665$ | 3,807,665$ |
15 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 30 | 20 | 175 | 230284 | 192440 | 78216 | 156241 | 38613 | 95.95% | 96.22% | 97.77% | 97.65% | 96.53% | 0 | 17395 - 96.64% | 1,345,597$ | 53,823,884$ | 18000 | 100 | 53,550,000$ | 45,350,000$ | 0$ | 55,391,050$ | 267,750$ | 53,128,550$ | 20 | 0 | 3,461,346$ | 0$ | 0 | 277,750$ | 0$ | 0$ | 53,128,550$ | 20,128,550$ | 62,562,477$ | 9,433,927$ | 6,562,477$ | 6,562,477$ |
16 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 64 | 44 | 40 | 215 | 184242 | 194354 | 64241 | 99153 | 29870 | 76.77% | 97.18% | 80.30% | 61.97% | 74.68% | 0 | 14297 - 79.43% | 1,346,686$ | 53,867,447$ | 18000 | 100 | 49,000,000$ | 47,050,000$ | 0$ | 52,493,800$ | 245,000$ | 50,993,800$ | 22 | 0 | 199,980$ | 0$ | 0 | 252,500$ | 0$ | 0$ | 50,993,800$ | 17,993,800$ | 72,084,069$ | 21,090,269$ | 16,084,069$ | 16,084,069$ |
17 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 70 | 46 | 30 | 180 | 196880 | 156574 | 62022 | 133621 | 38987 | 82.03% | 78.29% | 77.53% | 83.51% | 97.47% | 0 | 14702 - 81.68% | 1,336,768$ | 53,470,722$ | 18000 | 100 | 54,025,000$ | 49,225,000$ | 0$ | 54,484,500$ | 270,125$ | 53,609,500$ | 20 | 0 | 3,191,265$ | 0$ | 0 | 274,125$ | 0$ | 0$ | 53,609,500$ | 20,609,500$ | 105,200,813$ | 51,591,313$ | 49,200,813$ | 49,200,813$ |
18 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 70 | 46 | 30 | 180 | 196293 | 157001 | 62456 | 132593 | 39056 | 81.79% | 78.50% | 78.07% | 82.87% | 97.64% | 0 | 14685 - 81.58% | 1,335,815$ | 53,432,619$ | 18000 | 100 | 54,875,000$ | 47,300,000$ | 0$ | 56,145,650$ | 274,375$ | 53,983,150$ | 23 | 0 | 4,800,015$ | 0$ | 0 | 276,875$ | 0$ | 0$ | 53,983,150$ | 20,983,150$ | 59,522,486$ | 5,539,336$ | 3,522,486$ | 3,522,486$ |
19 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 70 | 45 | 35 | 195 | 177699 | 158152 | 65545 | 114880 | 32953 | 74.04% | 79.08% | 81.93% | 71.80% | 82.38% | 0 | 13731 - 76.28% | 1,307,758$ | 52,310,332$ | 18000 | 100 | 55,400,000$ | 47,800,000$ | 0$ | 58,323,250$ | 277,000$ | 54,373,250$ | 20 | 0 | 34,203,023$ | 0$ | 0 | 294,500$ | 0$ | 0$ | 54,373,250$ | 21,373,250$ | 65,953,218$ | 11,579,968$ | 9,953,218$ | 9,953,218$ |
20 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 70 | 45 | 35 | 200 | 179024 | 155805 | 62937 | 112020 | 31465 | 74.59% | 77.90% | 78.67% | 70.01% | 78.66% | 0 | 13531 - 75.17% | 1,306,259$ | 52,250,363$ | 18000 | 100 | 57,150,000$ | 50,100,000$ | 0$ | 55,541,000$ | 285,750$ | 52,941,000$ | 23 | 0 | 25,385,112$ | 0$ | 0 | 295,750$ | 0$ | 0$ | 52,941,000$ | 19,941,000$ | 89,884,496$ | 36,943,496$ | 33,884,496$ | 33,884,496$ |
21 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 65 | 45 | 30 | 199 | 204490 | 159948 | 62069 | 123267 | 31801 | 85.20% | 79.97% | 77.59% | 77.04% | 79.50% | 0 | 14539 - 80.77% | 1,341,818$ | 53,672,726$ | 18000 | 100 | 56,275,000$ | 52,225,000$ | 0$ | 56,960,825$ | 271,375$ | 54,960,825$ | 20 | 1 | 11,280,794$ | 0$ | 0 | 291,375$ | 0$ | 0$ | 54,960,825$ | 21,960,825$ | 62,222,383$ | 7,261,558$ | 6,222,383$ | 6,222,383$ |
22 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 60 | 35 | 25 | 180 | 232676 | 193855 | 78421 | 154587 | 38467 | 96.95% | 96.93% | 98.03% | 96.62% | 96.17% | 0 | 17450 - 96.95% | 1,358,983$ | 54,359,338$ | 18000 | 100 | 45,250,000$ | 41,250,000$ | 0$ | 51,255,000$ | 226,250$ | 49,755,000$ | 21 | 0 | 437,826$ | 0$ | 0 | 233,750$ | 0$ | 0$ | 49,755,000$ | 16,755,000$ | 76,980,765$ | 27,225,765$ | 20,980,765$ | 20,980,765$ |
23 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 107 | 71 | 48 | 33 | 190 | 231197 | 154379 | 58781 | 118470 | 38023 | 96.33% | 77.19% | 73.48% | 74.04% | 95.06% | 0 | 15021 - 83.45% | 1,427,563$ | 57,102,512$ | 18000 | 100 | 51,350,000$ | 53,200,000$ | 0$ | 55,272,000$ | 256,750$ | 53,072,000$ | 22 | 0 | 2,665,326$ | 0$ | 0 | 267,750$ | 0$ | 0$ | 53,072,000$ | 20,072,000$ | 103,920,592$ | 50,848,592$ | 47,920,592$ | 47,920,592$ |
24 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 103 | 68 | 43 | 28 | 180 | 232396 | 161057 | 66812 | 153936 | 38603 | 96.83% | 80.53% | 83.52% | 96.21% | 96.51% | 0 | 16320 - 90.67% | 1,409,334$ | 56,373,379$ | 18000 | 100 | 53,450,000$ | 54,500,000$ | 0$ | 53,716,325$ | 267,250$ | 52,716,325$ | 22 | 0 | 6,551,078$ | 0$ | 0 | 272,250$ | 0$ | 0$ | 52,716,325$ | 19,716,325$ | 69,458,525$ | 16,742,200$ | 13,458,525$ | 13,458,525$ |
25 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 75 | 50 | 30 | 210 | 179949 | 147423 | 55800 | 131065 | 30134 | 74.98% | 73.71% | 69.75% | 81.92% | 75.34% | 0 | 13609 - 75.61% | 1,288,027$ | 51,521,094$ | 18000 | 100 | 55,649,999$ | 52,699,999$ | 0$ | 55,973,550$ | 267,250$ | 55,119,800$ | 21 | 1 | 6,180,322$ | 0$ | 0 | 282,050$ | 0$ | 0$ | 55,119,800$ | 22,119,800$ | 63,829,778$ | 8,709,978$ | 7,829,778$ | 7,829,778$ |
26 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 70 | 45 | 35 | 215 | 191426 | 173003 | 71872 | 122222 | 29898 | 79.76% | 86.50% | 89.84% | 76.39% | 74.75% | 0 | 14711 - 81.73% | 1,369,573$ | 54,782,924$ | 18000 | 100 | 52,400,000$ | 51,150,000$ | 0$ | 53,662,125$ | 262,000$ | 52,230,875$ | 22 | 0 | 2,046,576$ | 0$ | 0 | 267,750$ | 0$ | 0$ | 52,230,875$ | 19,230,875$ | 87,212,206$ | 34,981,331$ | 31,212,206$ | 31,212,206$ |