| 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 |
| Arena 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 | Arena 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 56,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | ANAHEIM Ducks | 6000 | 5000 | 2000 | 5000 | 1000 | 195 | 190 | 185 | 180 | 225 | 64619 | 44365 | 16025 | 40000 | 15783 | 53.85% | 44.37% | 40.06% | 40.00% | 78.92% | 21 | 9040 - 47.58% | 2,345,345$ | 46,906,904$ | 19000 | 100 | 74,889,286$ | 76,089,286$ | 0$ | 35,753,876$ | 74,889,286$ | 35,198,222$ | 20 | 0 | 0$ | 49,252,249$ | 66 | 613,526$ | 40,492,716$ | 41,141,112$ | 74,889,286$ | 18,889,286$ | 88,000,000$ | 13,110,714$ | 184,041,362$ | 192,152,499$ |
| 2 | ARIZONA Coyotes | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 55 | 45 | 30 | 180 | 119810 | 100000 | 40000 | 100000 | 19913 | 99.84% | 100.00% | 100.00% | 100.00% | 99.57% | 21 | 18986 - 99.93% | 1,665,039$ | 33,300,774$ | 19000 | 100 | 63,741,667$ | 63,741,667$ | 0$ | 29,756,932$ | 63,741,667$ | 29,374,318$ | 20 | 0 | 0$ | 34,965,813$ | 66 | 520,642$ | 34,362,372$ | 35,834,128$ | 63,741,667$ | 7,741,667$ | 88,000,000$ | 24,258,333$ | 168,249,032$ | 167,380,717$ |
| 3 | BOSTON Bruins | 6000 | 5000 | 2000 | 5000 | 1000 | 95 | 70 | 55 | 40 | 190 | 119751 | 99951 | 40000 | 100000 | 19872 | 99.79% | 99.95% | 100.00% | 100.00% | 99.36% | 21 | 18979 - 99.89% | 1,913,530$ | 38,270,601$ | 19000 | 100 | 74,620,000$ | 74,620,000$ | 0$ | 35,098,874$ | 74,620,000$ | 34,902,892$ | 23 | 0 | 0$ | 40,184,131$ | 66 | 605,153$ | 39,940,098$ | 41,051,696$ | 74,620,000$ | 18,620,000$ | 88,000,000$ | 13,380,000$ | 94,098,675$ | 93,231,110$ |
| 4 | CALGARY Flames | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 57 | 34 | 19 | 200 | 119782 | 100000 | 40000 | 100000 | 19824 | 99.82% | 100.00% | 100.00% | 100.00% | 99.12% | 21 | 18980 - 99.90% | 1,632,441$ | 32,648,816$ | 19000 | 100 | 87,475,000$ | 87,475,000$ | 0$ | 41,319,334$ | 87,475,000$ | 40,921,799$ | 20 | 0 | 0$ | 34,281,257$ | 66 | 712,298$ | 47,011,668$ | 47,809,918$ | 87,475,000$ | 31,475,000$ | 88,000,000$ | 525,000$ | 66,232,789$ | 52,704,128$ |
| 5 | CHICAGO Blackhawks | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 68 | 42 | 27 | 210 | 119777 | 100000 | 40000 | 100000 | 17946 | 99.81% | 100.00% | 100.00% | 100.00% | 89.73% | 21 | 18886 - 99.40% | 1,772,534$ | 35,450,684$ | 19000 | 100 | 60,306,666$ | 56,631,666$ | 0$ | 27,765,178$ | 60,306,666$ | 26,926,498$ | 23 | 0 | 0$ | 37,223,218$ | 66 | 500,804$ | 33,053,064$ | 33,897,814$ | 60,306,666$ | 4,306,666$ | 88,000,000$ | 27,693,334$ | 76,533,555$ | 79,858,959$ |
| 6 | COLORADO Avalanche | 6000 | 5000 | 2000 | 5000 | 1000 | 175 | 170 | 165 | 125 | 200 | 73684 | 49035 | 16658 | 46379 | 19751 | 61.40% | 49.04% | 41.65% | 46.38% | 98.76% | 21 | 10275 - 54.08% | 2,276,559$ | 45,531,171$ | 19000 | 100 | 81,820,000$ | 82,153,334$ | 0$ | 38,409,151$ | 81,820,000$ | 38,011,565$ | 23 | 0 | 0$ | 47,807,730$ | 66 | 666,694$ | 44,001,804$ | 44,783,500$ | 81,820,000$ | 25,820,000$ | 88,000,000$ | 6,180,000$ | 65,919,889$ | 68,944,119$ |
| 7 | COLUMBUS Blue Jackets | 6000 | 5000 | 2000 | 5000 | 1000 | 195 | 190 | 185 | 180 | 225 | 64565 | 43090 | 16001 | 40000 | 15933 | 53.80% | 43.09% | 40.00% | 40.00% | 79.67% | 21 | 8979 - 47.26% | 2,330,261$ | 46,605,220$ | 19000 | 100 | 72,715,000$ | 72,715,000$ | 0$ | 34,471,198$ | 72,715,000$ | 34,011,838$ | 22 | 0 | 0$ | 48,935,481$ | 66 | 594,331$ | 39,225,846$ | 40,202,594$ | 72,715,000$ | 16,715,000$ | 88,000,000$ | 15,285,000$ | 201,181,270$ | 209,914,157$ |
| 8 | DETROIT Red Wings | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 60 | 40 | 34 | 210 | 119530 | 100000 | 40000 | 100000 | 17070 | 99.61% | 100.00% | 100.00% | 100.00% | 85.35% | 21 | 18830 - 99.11% | 1,791,295$ | 35,825,890$ | 19000 | 100 | 78,495,000$ | 78,495,000$ | 0$ | 36,703,535$ | 78,495,000$ | 36,376,123$ | 20 | 0 | 0$ | 37,617,184$ | 66 | 638,669$ | 42,152,154$ | 43,222,956$ | 78,495,000$ | 22,495,000$ | 88,000,000$ | 9,505,000$ | 99,842,028$ | 94,236,256$ |
| 9 | EDMONTON Oilers | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 105 | 97 | 80 | 220 | 97741 | 75673 | 27165 | 67922 | 15754 | 81.45% | 75.67% | 67.91% | 67.92% | 78.77% | 21 | 14213 - 74.80% | 2,238,377$ | 44,767,546$ | 19000 | 100 | 81,735,000$ | 79,735,000$ | 0$ | 37,896,061$ | 81,735,000$ | 37,428,297$ | 23 | 0 | 0$ | 47,005,923$ | 66 | 667,218$ | 44,036,388$ | 44,694,084$ | 81,735,000$ | 25,735,000$ | 88,000,000$ | 6,265,000$ | 103,254,715$ | 105,566,554$ |
| 10 | MINNESOTA Wild | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 60 | 40 | 30 | 200 | 119640 | 100000 | 40000 | 100000 | 19969 | 99.70% | 100.00% | 100.00% | 100.00% | 99.85% | 21 | 18980 - 99.90% | 1,792,652$ | 35,853,030$ | 19000 | 100 | 65,865,000$ | 65,865,000$ | 0$ | 31,023,075$ | 65,865,000$ | 30,672,243$ | 21 | 0 | 0$ | 37,645,682$ | 66 | 537,218$ | 35,456,388$ | 36,604,938$ | 65,865,000$ | 9,865,000$ | 88,000,000$ | 22,135,000$ | 48,275,585$ | 49,316,329$ |
| 11 | MONTREAL Canadiens | 6000 | 5000 | 2000 | 5000 | 1000 | 96 | 69 | 49 | 36 | 193 | 120000 | 99982 | 40000 | 100000 | 19854 | 100.00% | 99.98% | 100.00% | 100.00% | 99.27% | 21 | 18992 - 99.96% | 1,877,214$ | 37,544,282$ | 19000 | 100 | 72,640,000$ | 72,506,000$ | 0$ | 34,352,912$ | 72,640,000$ | 33,996,910$ | 20 | 0 | 0$ | 39,421,496$ | 66 | 591,944$ | 39,068,304$ | 40,415,006$ | 72,640,000$ | 16,640,000$ | 88,000,000$ | 15,360,000$ | 105,801,751$ | 104,808,241$ |
| 12 | NASHVILLE Predators | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 50 | 32 | 25 | 187 | 119949 | 100000 | 40000 | 100000 | 19899 | 99.96% | 100.00% | 100.00% | 100.00% | 99.50% | 21 | 18992 - 99.96% | 1,572,515$ | 31,450,305$ | 19000 | 100 | 56,075,000$ | 56,075,000$ | 0$ | 28,264,084$ | 56,075,000$ | 27,494,192$ | 24 | 0 | 0$ | 33,022,820$ | 66 | 465,492$ | 30,722,472$ | 31,980,576$ | 56,075,000$ | 75,000$ | 88,000,000$ | 31,925,000$ | 39,713,395$ | 40,755,639$ |
| 13 | NEW YORK Islanders | 6000 | 5000 | 2000 | 5000 | 1000 | 150 | 135 | 120 | 100 | 200 | 87399 | 63650 | 22586 | 58512 | 19883 | 72.83% | 63.65% | 56.47% | 58.51% | 99.42% | 21 | 12602 - 66.32% | 2,311,249$ | 46,224,970$ | 19000 | 100 | 74,375,000$ | 71,375,000$ | 0$ | 35,451,733$ | 74,375,000$ | 34,853,934$ | 21 | 0 | 0$ | 48,536,218$ | 66 | 610,105$ | 40,266,930$ | 41,566,078$ | 74,375,000$ | 18,375,000$ | 88,000,000$ | 13,625,000$ | 131,985,398$ | 138,955,538$ |
| 14 | NEW YORK Rangers | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 60 | 35 | 20 | 200 | 119501 | 100000 | 40000 | 100000 | 19641 | 99.58% | 100.00% | 100.00% | 100.00% | 98.21% | 21 | 18957 - 99.77% | 1,706,285$ | 34,125,705$ | 19000 | 100 | 78,415,000$ | 77,765,000$ | 0$ | 38,173,987$ | 78,415,000$ | 37,618,311$ | 20 | 0 | 0$ | 35,831,990$ | 66 | 641,960$ | 42,369,360$ | 43,191,108$ | 78,415,000$ | 22,415,000$ | 88,000,000$ | 9,585,000$ | 50,360,646$ | 43,001,528$ |
| 15 | OTTAWA Senators | 6000 | 5000 | 2000 | 5000 | 1000 | 95 | 55 | 35 | 25 | 190 | 113795 | 95000 | 38000 | 95000 | 18898 | 99.82% | 100.00% | 100.00% | 100.00% | 99.46% | 22 | 18984 - 99.91% | 1,657,739$ | 31,497,047$ | 19000 | 100 | 83,750,000$ | 83,750,000$ | 0$ | 39,629,039$ | 83,750,000$ | 39,161,283$ | 23 | 0 | 0$ | 36,470,265$ | 66 | 683,468$ | 45,108,888$ | 46,462,844$ | 83,750,000$ | 27,750,000$ | 88,000,000$ | 4,250,000$ | 16,417,607$ | 6,425,028$ |
| 16 | PHILADELPHIA Flyers | 6000 | 5000 | 2000 | 5000 | 1000 | 225 | 220 | 215 | 210 | 280 | 56218 | 40134 | 16000 | 40000 | 12827 | 46.85% | 40.13% | 40.00% | 40.00% | 64.14% | 21 | 8259 - 43.47% | 2,491,431$ | 49,828,623$ | 19000 | 100 | 82,380,000$ | 80,630,000$ | 0$ | 40,092,049$ | 82,380,000$ | 39,470,873$ | 20 | 0 | 0$ | 52,320,054$ | 66 | 675,065$ | 44,554,290$ | 45,751,634$ | 82,380,000$ | 26,380,000$ | 88,000,000$ | 5,620,000$ | 75,050,331$ | 81,618,751$ |
| 17 | PITTSBURGH Penguins | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 56 | 31 | 16 | 194 | 119956 | 100000 | 40000 | 100000 | 19797 | 99.96% | 100.00% | 100.00% | 100.00% | 98.99% | 21 | 18988 - 99.94% | 1,590,063$ | 31,801,251$ | 19000 | 100 | 59,125,000$ | 59,125,000$ | 0$ | 27,637,611$ | 59,125,000$ | 27,344,362$ | 23 | 0 | 0$ | 33,391,314$ | 66 | 481,871$ | 31,803,486$ | 32,901,630$ | 59,125,000$ | 3,125,000$ | 88,000,000$ | 28,875,000$ | 59,471,853$ | 59,961,537$ |
| 18 | QUEBEC Nordiques | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 63 | 37 | 33 | 240 | 119900 | 100000 | 40000 | 100000 | 15077 | 99.92% | 100.00% | 100.00% | 100.00% | 75.39% | 21 | 18749 - 98.68% | 1,752,913$ | 35,058,258$ | 19000 | 100 | 85,305,000$ | 85,305,000$ | 0$ | 41,434,616$ | 85,305,000$ | 40,499,134$ | 21 | 0 | 0$ | 36,811,171$ | 66 | 704,073$ | 46,468,818$ | 47,042,318$ | 85,305,000$ | 29,305,000$ | 88,000,000$ | 2,695,000$ | 51,198,180$ | 40,967,033$ |
| 19 | SEATTLE Totems | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 56 | 33 | 27 | 195 | 119863 | 100000 | 40000 | 100000 | 19745 | 99.89% | 100.00% | 100.00% | 100.00% | 98.73% | 21 | 18980 - 99.90% | 1,669,774$ | 33,395,486$ | 19000 | 100 | 84,860,000$ | 86,360,000$ | 0$ | 40,719,960$ | 84,860,000$ | 40,468,785$ | 21 | 0 | 0$ | 35,065,260$ | 66 | 688,685$ | 45,453,210$ | 46,204,960$ | 84,860,000$ | 28,860,000$ | 88,000,000$ | 3,140,000$ | 42,376,609$ | 31,236,909$ |
| 20 | ST-LOUIS Blues | 6000 | 5000 | 2000 | 5000 | 1000 | 140 | 120 | 95 | 70 | 200 | 93494 | 71947 | 29520 | 81472 | 19880 | 77.91% | 71.95% | 73.80% | 81.47% | 99.40% | 21 | 14816 - 77.98% | 2,259,538$ | 45,190,764$ | 19000 | 100 | 85,625,000$ | 84,750,000$ | 0$ | 39,832,502$ | 85,625,000$ | 39,018,646$ | 20 | 0 | 0$ | 47,450,302$ | 66 | 704,556$ | 46,500,696$ | 46,996,076$ | 85,625,000$ | 29,625,000$ | 88,000,000$ | 2,375,000$ | 71,589,367$ | 72,043,593$ |
| 21 | TAMPA BAY Lightning | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 70 | 55 | 40 | 190 | 119809 | 99939 | 40000 | 100000 | 19881 | 99.84% | 99.94% | 100.00% | 100.00% | 99.41% | 21 | 18981 - 99.90% | 1,873,525$ | 37,470,503$ | 19000 | 100 | 64,495,000$ | 64,495,000$ | 0$ | 29,263,225$ | 64,495,000$ | 28,866,577$ | 23 | 0 | 0$ | 39,344,028$ | 66 | 526,960$ | 34,779,360$ | 35,966,908$ | 64,495,000$ | 8,495,000$ | 88,000,000$ | 23,505,000$ | 71,279,386$ | 74,656,506$ |
| 22 | TORONTO Maple Leafs | 6000 | 5000 | 2000 | 5000 | 1000 | 115 | 95 | 80 | 65 | 205 | 118952 | 97435 | 35960 | 97522 | 19798 | 99.13% | 97.44% | 89.90% | 97.52% | 98.99% | 21 | 18483 - 97.28% | 2,444,183$ | 48,883,668$ | 19000 | 100 | 67,870,000$ | 67,870,000$ | 0$ | 32,293,654$ | 67,870,000$ | 31,681,860$ | 22 | 0 | 0$ | 51,327,851$ | 66 | 557,887$ | 36,820,542$ | 38,210,892$ | 67,870,000$ | 11,870,000$ | 88,000,000$ | 20,130,000$ | 98,762,329$ | 111,879,288$ |
| 23 | VANCOUVER Canucks | 6000 | 5000 | 2000 | 5000 | 1000 | 120 | 75 | 60 | 40 | 210 | 118302 | 99758 | 39998 | 100000 | 17412 | 98.59% | 99.76% | 100.00% | 100.00% | 87.06% | 21 | 18774 - 98.81% | 2,142,078$ | 42,841,561$ | 19000 | 100 | 66,990,000$ | 66,565,000$ | 0$ | 30,676,204$ | 66,990,000$ | 30,325,409$ | 23 | 0 | 0$ | 44,983,639$ | 66 | 546,290$ | 36,055,140$ | 37,314,112$ | 66,990,000$ | 10,990,000$ | 88,000,000$ | 21,010,000$ | 71,527,016$ | 79,196,543$ |
| 24 | VEGAS Golden Knights | 6000 | 5000 | 2000 | 5000 | 1000 | 215 | 210 | 205 | 200 | 250 | 59421 | 40985 | 16000 | 40000 | 14504 | 49.52% | 40.99% | 40.00% | 40.00% | 72.52% | 21 | 8546 - 44.98% | 2,449,465$ | 48,989,293$ | 19000 | 100 | 60,525,000$ | 60,525,000$ | 0$ | 29,139,616$ | 60,525,000$ | 28,433,814$ | 22 | 0 | 0$ | 51,438,758$ | 66 | 500,274$ | 33,018,084$ | 34,240,538$ | 60,525,000$ | 4,525,000$ | 88,000,000$ | 27,475,000$ | 108,067,199$ | 125,265,419$ |
| 25 | WASHINGTON Capitals | 6000 | 5000 | 2000 | 5000 | 1000 | 93 | 80 | 49 | 40 | 203 | 119772 | 100000 | 40000 | 100000 | 19839 | 99.81% | 100.00% | 100.00% | 100.00% | 99.20% | 21 | 18981 - 99.90% | 1,966,013$ | 39,320,251$ | 19000 | 100 | 71,500,000$ | 71,500,000$ | 0$ | 33,911,266$ | 71,500,000$ | 33,443,554$ | 20 | 0 | 0$ | 41,286,264$ | 66 | 584,677$ | 38,588,682$ | 39,448,746$ | 71,500,000$ | 15,500,000$ | 88,000,000$ | 16,500,000$ | 56,005,018$ | 57,842,536$ |
| 26 | WINNIPEG Jets | 6000 | 5000 | 2000 | 5000 | 1000 | 130 | 90 | 70 | 69 | 245 | 117255 | 99765 | 39915 | 98971 | 16661 | 97.71% | 99.77% | 99.79% | 98.97% | 83.31% | 21 | 18628 - 98.04% | 2,213,281$ | 44,265,614$ | 19000 | 100 | 80,440,358$ | 80,440,358$ | 0$ | 37,810,987$ | 80,440,358$ | 37,105,162$ | 21 | 0 | 0$ | 46,478,895$ | 66 | 660,882$ | 43,618,212$ | 43,867,266$ | 80,440,358$ | 24,440,358$ | 88,000,000$ | 7,559,642$ | 73,397,970$ | 76,009,599$ |