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 40,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
1 | Anaheim Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 77055 | 66498 | 26346 | 51924 | 13338 | 91.73% | 95.00% | 94.09% | 92.72% | 95.27% | 27 | 16797 - 93.32% | 1,764,925$ | 24,708,954$ | 18000 | 100 | 122,188,690$ | 122,188,690$ | 0$ | 44,818,600$ | 122,188,690$ | 44,454,983$ | 23 | 0 | 0$ | 47,652,983$ | 77 | 1,018,088$ | 78,392,776$ | 83,520,212$ | 122,188,690$ | 82,188,690$ | 132,000,000$ | 9,811,310$ | 77,440,124$ | 41,572,895$ |
2 | Atlanta Thrashers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 90000 | 75000 | 30000 | 60000 | 15000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 26 | 18000 - 100.00% | 1,892,300$ | 28,384,500$ | 18000 | 100 | 128,075,000$ | 128,075,000$ | 0$ | 46,936,384$ | 128,075,000$ | 46,572,724$ | 25 | 0 | 0$ | 49,199,800$ | 77 | 1,066,736$ | 82,138,672$ | 86,046,464$ | 128,075,000$ | 88,075,000$ | 132,000,000$ | 3,925,000$ | 36,429,728$ | -416,936$ |
3 | California Golden Seals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 83795 | 69021 | 28263 | 57800 | 14203 | 93.11% | 92.03% | 94.21% | 96.33% | 94.69% | 26 | 16872 - 93.73% | 1,767,693$ | 26,515,392$ | 18000 | 100 | 90,819,167$ | 90,806,667$ | 0$ | 34,672,117$ | 90,819,167$ | 34,308,501$ | 21 | 0 | 0$ | 45,960,013$ | 77 | 758,836$ | 58,430,372$ | 61,945,416$ | 90,819,167$ | 50,819,167$ | 132,000,000$ | 41,180,833$ | 90,178,026$ | 74,192,623$ |
4 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 84225 | 70732 | 27793 | 57634 | 14312 | 93.58% | 94.31% | 92.64% | 96.06% | 95.41% | 26 | 16980 - 94.33% | 1,782,281$ | 26,734,213$ | 18000 | 100 | 51,265,001$ | 51,265,001$ | 0$ | 19,005,448$ | 51,265,001$ | 18,641,832$ | 22 | 0 | 0$ | 46,339,303$ | 77 | 431,942$ | 33,259,534$ | 42,098,710$ | 51,265,001$ | 11,265,001$ | 132,000,000$ | 80,734,999$ | 103,501,333$ | 107,741,926$ |
5 | Cincinnati Cyclones | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 82702 | 70139 | 27713 | 57761 | 14351 | 91.89% | 93.52% | 92.38% | 96.27% | 95.67% | 26 | 16844 - 93.58% | 1,764,430$ | 26,466,453$ | 18000 | 100 | 97,966,666$ | 97,066,666$ | 0$ | 35,853,772$ | 97,966,666$ | 35,581,059$ | 22 | 0 | 0$ | 45,875,185$ | 77 | 815,840$ | 62,819,680$ | 65,842,340$ | 97,966,666$ | 57,966,666$ | 132,000,000$ | 34,033,334$ | 89,163,949$ | 69,196,794$ |
6 | Columbus Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 85939 | 70833 | 28222 | 57218 | 14245 | 95.49% | 94.44% | 94.07% | 95.36% | 94.97% | 26 | 17097 - 94.98% | 1,799,036$ | 26,985,540$ | 18000 | 100 | 127,130,357$ | 127,130,357$ | 0$ | 46,592,876$ | 127,130,357$ | 46,229,216$ | 23 | 0 | 0$ | 46,774,936$ | 77 | 1,058,929$ | 81,537,533$ | 85,996,037$ | 127,130,357$ | 87,130,357$ | 132,000,000$ | 4,869,643$ | 78,260,336$ | 39,039,235$ |
7 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 70 | 45 | 30 | 300 | 58428 | 53765 | 20016 | 42652 | 8329 | 64.92% | 71.69% | 66.72% | 71.09% | 55.53% | 26 | 12213 - 67.85% | 1,564,106$ | 23,461,584$ | 18000 | 100 | 150,941,667$ | 150,941,667$ | 0$ | 55,251,504$ | 150,941,667$ | 54,887,888$ | 25 | 0 | 0$ | 40,666,746$ | 77 | 1,255,716$ | 96,690,132$ | 100,347,776$ | 150,941,667$ | 110,941,667$ | 132,000,000$ | -18,941,667$ | 66,460,772$ | 6,779,742$ |
8 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 85061 | 69887 | 28131 | 57381 | 14169 | 94.51% | 93.18% | 93.77% | 95.64% | 94.46% | 26 | 16975 - 94.31% | 1,783,255$ | 26,748,822$ | 18000 | 100 | 122,114,666$ | 122,114,666$ | 0$ | 43,695,403$ | 122,114,666$ | 43,331,784$ | 24 | 0 | 0$ | 46,364,625$ | 77 | 1,017,477$ | 78,345,729$ | 81,003,977$ | 122,114,666$ | 82,114,666$ | 132,000,000$ | 9,885,334$ | 81,686,553$ | 47,047,201$ |
9 | Kansas City Scouts | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 84337 | 68370 | 28303 | 55785 | 14078 | 93.71% | 91.16% | 94.34% | 92.98% | 93.85% | 26 | 16725 - 92.92% | 1,761,848$ | 26,427,727$ | 18000 | 100 | 74,176,025$ | 74,176,025$ | 0$ | 28,734,447$ | 74,176,025$ | 28,370,831$ | 21 | 0 | 0$ | 45,808,060$ | 77 | 621,289$ | 47,839,253$ | 51,152,633$ | 74,176,025$ | 34,176,025$ | 132,000,000$ | 57,823,975$ | 96,232,973$ | 90,888,400$ |
10 | New Jersey Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 140 | 90 | 60 | 52 | 275 | 51689 | 41604 | 14260 | 24959 | 8968 | 57.43% | 55.47% | 47.53% | 41.60% | 59.79% | 26 | 9432 - 52.40% | 1,549,648$ | 23,244,726$ | 18000 | 100 | 111,889,501$ | 111,889,501$ | 0$ | 41,050,724$ | 111,889,501$ | 40,687,108$ | 22 | 0 | 0$ | 40,290,858$ | 77 | 932,971$ | 71,838,767$ | 75,001,635$ | 111,889,501$ | 71,889,501$ | 132,000,000$ | 20,110,499$ | 80,681,326$ | 45,970,549$ |
11 | Pittsburgh Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 82500 | 68918 | 28071 | 57450 | 13515 | 91.67% | 91.89% | 93.57% | 95.75% | 90.10% | 26 | 16697 - 92.76% | 1,739,010$ | 26,085,152$ | 18000 | 100 | 54,584,584$ | 54,709,584$ | 0$ | 20,553,082$ | 54,584,584$ | 20,189,431$ | 22 | 0 | 0$ | 45,214,263$ | 77 | 459,377$ | 35,372,029$ | 37,393,545$ | 54,584,584$ | 14,584,584$ | 132,000,000$ | 77,415,416$ | 104,588,898$ | 112,409,616$ |
12 | San Jose Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 78635 | 65356 | 26355 | 53138 | 12765 | 93.61% | 93.37% | 94.13% | 94.89% | 91.18% | 27 | 16875 - 93.75% | 1,765,515$ | 24,717,215$ | 18000 | 100 | 105,316,111$ | 105,316,111$ | 0$ | 36,019,906$ | 105,316,111$ | 35,656,286$ | 23 | 0 | 0$ | 47,668,915$ | 77 | 878,646$ | 67,655,742$ | 71,138,494$ | 105,316,111$ | 65,316,111$ | 132,000,000$ | 26,683,889$ | 86,917,674$ | 63,448,095$ |
13 | Savannah Ghost Pirates | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 70 | 45 | 35 | 210 | 96000 | 80000 | 32000 | 64000 | 16000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 25 | 18000 - 100.00% | 2,160,500$ | 34,568,000$ | 18000 | 100 | 102,754,166$ | 102,754,166$ | 0$ | 37,282,494$ | 102,754,166$ | 36,918,869$ | 24 | 0 | 0$ | 54,012,500$ | 77 | 857,472$ | 66,025,344$ | 69,750,884$ | 102,754,166$ | 62,754,166$ | 132,000,000$ | 29,245,834$ | 45,928,523$ | 30,190,139$ |
14 | Seattle Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 82071 | 68003 | 27584 | 55246 | 13689 | 91.19% | 90.67% | 91.95% | 92.08% | 91.26% | 26 | 16440 - 91.33% | 1,725,586$ | 25,883,788$ | 18000 | 100 | 106,127,501$ | 106,127,501$ | 0$ | 40,541,798$ | 106,127,501$ | 40,178,143$ | 23 | 0 | 0$ | 44,865,233$ | 77 | 885,351$ | 68,172,027$ | 71,505,739$ | 106,127,501$ | 66,127,501$ | 132,000,000$ | 25,872,499$ | 83,769,447$ | 57,128,941$ |
15 | St Louis Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 79633 | 65780 | 26566 | 53651 | 13084 | 94.80% | 93.97% | 94.88% | 95.81% | 93.46% | 27 | 17051 - 94.73% | 1,787,786$ | 25,028,997$ | 18000 | 100 | 126,915,833$ | 126,915,833$ | 0$ | 46,022,351$ | 126,915,833$ | 45,658,698$ | 23 | 0 | 0$ | 48,270,208$ | 77 | 1,057,156$ | 81,401,012$ | 84,194,868$ | 126,915,833$ | 86,915,833$ | 132,000,000$ | 5,084,167$ | 77,626,634$ | 41,701,974$ |
16 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 84031 | 69811 | 27974 | 56968 | 14127 | 93.37% | 93.08% | 93.25% | 94.95% | 94.18% | 26 | 16861 - 93.67% | 1,770,165$ | 26,552,470$ | 18000 | 100 | 134,849,357$ | 134,849,357$ | 0$ | 50,486,022$ | 134,849,357$ | 50,122,374$ | 22 | 0 | 0$ | 46,024,281$ | 77 | 1,122,722$ | 86,449,594$ | 89,113,914$ | 134,849,357$ | 94,849,357$ | 132,000,000$ | -2,849,357$ | 74,711,548$ | 31,621,915$ |
17 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 77186 | 65808 | 26587 | 52337 | 12925 | 91.89% | 94.01% | 94.95% | 93.46% | 92.32% | 27 | 16775 - 93.19% | 1,755,119$ | 24,571,664$ | 18000 | 100 | 96,404,309$ | 96,404,309$ | 0$ | 35,201,914$ | 96,404,309$ | 34,838,287$ | 22 | 0 | 0$ | 47,388,209$ | 77 | 804,994$ | 61,984,538$ | 64,682,990$ | 96,404,309$ | 56,404,309$ | 132,000,000$ | 35,595,691$ | 88,059,804$ | 70,765,023$ |
18 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 84220 | 70132 | 28692 | 57120 | 13974 | 93.58% | 93.51% | 95.64% | 95.20% | 93.16% | 26 | 16943 - 94.13% | 1,773,789$ | 26,606,841$ | 18000 | 100 | 124,486,190$ | 124,486,190$ | 0$ | 45,306,440$ | 124,486,190$ | 44,942,787$ | 22 | 0 | 0$ | 46,118,524$ | 77 | 1,037,076$ | 79,854,852$ | 83,559,048$ | 124,486,190$ | 84,486,190$ | 132,000,000$ | 7,513,810$ | 79,499,920$ | 42,059,396$ |