| 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 | 8333 | 6944 | 2778 | 5556 | 1389 | 66 | 50 | 41 | 22 | 157 | 284972 | 240421 | 104886 | 208743 | 46383 | 83.41% | 84.45% | 92.09% | 91.64% | 81.45% | 0 | 21595 - 86.38% | 1,460,098$ | 59,864,026$ | 25000 | 100 | 54,640,000$ | 53,105,500$ | 5,388,505$ | 65,603,333$ | 283,987$ | 59,589,243$ | 22 | 0 | 0$ | 0$ | 0 | 317,701$ | 0$ | 0$ | 64,977,748$ | 24,977,748$ | 65,000,000$ | 22,252$ | 31,803,907$ | 31,803,907$ |
| 2 | Boston | 8333 | 6944 | 2778 | 5556 | 1389 | 75 | 50 | 45 | 25 | 160 | 274575 | 238931 | 102364 | 211336 | 46052 | 80.37% | 83.92% | 89.87% | 92.77% | 80.87% | 0 | 21299 - 85.20% | 1,479,863$ | 60,674,390$ | 25000 | 100 | 70,100,000$ | 62,401,750$ | 0$ | 71,059,063$ | 333,699$ | 64,449,781$ | 24 | 1 | 0$ | 0$ | 0 | 390,909$ | 0$ | 0$ | 64,449,781$ | 24,449,781$ | 65,000,000$ | 550,219$ | 3,737,267$ | 3,737,267$ |
| 3 | Buffalo | 6000 | 5000 | 2000 | 4000 | 1000 | 87 | 62 | 42 | 32 | 165 | 246000 | 205000 | 82000 | 164000 | 41000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 0 | 18000 - 100.00% | 1,450,800$ | 59,482,800$ | 18000 | 100 | 62,242,550$ | 61,252,550$ | 4,673,500$ | 63,158,604$ | 327,554$ | 60,133,405$ | 22 | 0 | 0$ | 0$ | 0 | 345,682$ | 0$ | 0$ | 64,806,905$ | 24,806,905$ | 65,000,000$ | 193,095$ | 20,822,677$ | 20,822,677$ |
| 4 | Chicago | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 75 | 60 | 45 | 200 | 278567 | 164461 | 67432 | 122739 | 34105 | 81.54% | 57.77% | 59.20% | 53.88% | 59.89% | 0 | 16276 - 65.10% | 1,497,785$ | 61,409,197$ | 25000 | 100 | 64,642,000$ | 60,348,000$ | 2,022,650$ | 67,510,620$ | 322,717$ | 62,117,932$ | 21 | 1 | 0$ | 0$ | 0 | 372,952$ | 0$ | 0$ | 64,140,582$ | 24,140,582$ | 65,000,000$ | 859,418$ | 19,642,576$ | 19,642,576$ |
| 5 | Colorado | 6500 | 5000 | 2000 | 4000 | 1000 | 87 | 56 | 43 | 32 | 175 | 263897 | 205000 | 82000 | 164000 | 41000 | 99.02% | 100.00% | 100.00% | 100.00% | 100.00% | 0 | 18437 - 99.66% | 1,474,772$ | 60,465,647$ | 18500 | 100 | 61,430,000$ | 56,381,000$ | 0$ | 64,292,579$ | 301,503$ | 54,898,699$ | 25 | 0 | 0$ | 0$ | 0 | 352,567$ | 0$ | 0$ | 54,898,699$ | 14,898,699$ | 65,000,000$ | 10,101,301$ | 29,650,281$ | 29,650,281$ |
| 6 | Columbus | 8333 | 6944 | 2778 | 5556 | 1389 | 75 | 52 | 40 | 25 | 160 | 269971 | 242193 | 104035 | 209291 | 44783 | 79.02% | 85.07% | 91.34% | 91.88% | 78.64% | 0 | 21226 - 84.90% | 1,470,257$ | 60,280,531$ | 25000 | 100 | 67,296,000$ | 66,207,000$ | 1,100,000$ | 71,302,914$ | 354,048$ | 63,817,020$ | 22 | 0 | 0$ | 0$ | 0 | 395,166$ | 0$ | 0$ | 64,917,020$ | 24,917,020$ | 65,000,000$ | 82,980$ | -262,305$ | -262,305$ |
| 7 | Dallas | 8333 | 6944 | 2778 | 5556 | 1389 | 100 | 75 | 60 | 45 | 175 | 190085 | 169254 | 69221 | 126427 | 43624 | 55.64% | 59.45% | 60.77% | 55.50% | 76.60% | 0 | 14600 - 58.40% | 1,453,116$ | 59,577,752$ | 25000 | 100 | 60,148,500$ | 61,708,500$ | 922,500$ | 63,479,069$ | 329,992$ | 60,087,481$ | 21 | 0 | 0$ | 0$ | 0 | 340,901$ | 0$ | 0$ | 61,009,981$ | 21,009,981$ | 65,000,000$ | 3,990,019$ | 18,574,204$ | 18,574,204$ |
| 8 | Detroit | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 60 | 45 | 220 | 160561 | 154884 | 68462 | 122323 | 31255 | 65.27% | 75.55% | 83.49% | 74.59% | 76.23% | 0 | 13109 - 72.83% | 1,437,329$ | 58,930,507$ | 18000 | 100 | 71,970,000$ | 67,861,500$ | 0$ | 74,348,332$ | 362,896$ | 64,941,858$ | 24 | 0 | 0$ | 0$ | 0 | 408,930$ | 0$ | 0$ | 64,941,858$ | 24,941,858$ | 65,000,000$ | 58,142$ | 14,045,283$ | 14,045,283$ |
| 9 | Edmonton | 6000 | 5000 | 2720 | 5480 | 1000 | 95 | 65 | 40 | 25 | 190 | 216626 | 185642 | 105081 | 205484 | 37129 | 88.06% | 90.56% | 94.23% | 91.46% | 90.56% | 0 | 18292 - 90.55% | 1,448,615$ | 59,393,214$ | 20200 | 100 | 58,360,000$ | 58,360,000$ | 1,830,000$ | 66,965,879$ | 312,086$ | 62,104,951$ | 22 | 0 | 0$ | 0$ | 0 | 336,150$ | 0$ | 0$ | 63,934,951$ | 23,934,951$ | 65,000,000$ | 1,065,049$ | -1,523,202$ | -1,523,202$ |
| 10 | Floride | 6000 | 5100 | 2778 | 5556 | 1000 | 90 | 75 | 55 | 45 | 200 | 228345 | 163972 | 72627 | 121966 | 34339 | 92.82% | 78.42% | 63.76% | 53.54% | 83.75% | 0 | 15152 - 74.15% | 1,444,625$ | 59,229,626$ | 20434 | 100 | 66,273,000$ | 66,273,000$ | 0$ | 70,169,607$ | 354,401$ | 63,960,115$ | 22 | 0 | 0$ | 0$ | 0 | 385,417$ | 0$ | 0$ | 63,960,115$ | 23,960,115$ | 65,000,000$ | 1,039,885$ | -3,381,979$ | -3,381,979$ |
| 11 | Los Angeles | 6000 | 5000 | 2000 | 4000 | 1000 | 99 | 69 | 59 | 35 | 199 | 201587 | 172121 | 68546 | 157540 | 34301 | 81.95% | 83.96% | 83.59% | 96.06% | 83.66% | 0 | 15466 - 85.92% | 1,430,585$ | 58,653,999$ | 18000 | 100 | 52,625,000$ | 45,497,000$ | 4,415,732$ | 64,238,944$ | 243,299$ | 55,115,404$ | 23 | 0 | 0$ | 0$ | 0 | 304,412$ | 0$ | 0$ | 59,531,136$ | 19,531,136$ | 65,000,000$ | 5,468,864$ | 5,592,085$ | 5,592,085$ |
| 12 | Minnesota | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 60 | 50 | 30 | 175 | 246000 | 205000 | 81568 | 203599 | 41000 | 100.00% | 100.00% | 73.14% | 90.62% | 100.00% | 0 | 18955 - 93.84% | 1,444,138$ | 59,209,644$ | 20200 | 100 | 65,812,500$ | 55,863,000$ | 6,050,133$ | 70,019,946$ | 298,733$ | 58,927,393$ | 26 | 0 | 0$ | 0$ | 0 | 370,655$ | 0$ | 0$ | 64,977,526$ | 24,977,526$ | 65,000,000$ | 22,474$ | -5,649,198$ | -5,649,198$ |
| 13 | Montreal | 6415 | 5870 | 2778 | 5556 | 1145 | 85 | 60 | 45 | 25 | 200 | 249923 | 219301 | 89962 | 184390 | 33189 | 95.02% | 91.12% | 78.98% | 80.95% | 70.70% | 0 | 18945 - 87.05% | 1,527,911$ | 62,644,350$ | 21764 | 100 | 61,210,000$ | 58,537,000$ | 2,355,000$ | 63,454,058$ | 313,032$ | 57,532,768$ | 22 | 0 | 0$ | 0$ | 0 | 341,230$ | 0$ | 0$ | 59,887,768$ | 19,887,768$ | 65,000,000$ | 5,112,232$ | 11,985,892$ | 11,985,892$ |
| 14 | NYIslanders | 6000 | 5000 | 2720 | 5480 | 1000 | 95 | 74 | 40 | 28 | 195 | 207436 | 171588 | 106630 | 205053 | 35149 | 84.32% | 83.70% | 95.62% | 91.26% | 85.73% | 0 | 17704 - 87.64% | 1,446,336$ | 59,299,758$ | 20200 | 100 | 60,192,845$ | 60,192,845$ | 817,500$ | 60,178,489$ | 321,887$ | 57,178,450$ | 20 | 0 | 0$ | 0$ | 0 | 337,930$ | 0$ | 0$ | 57,995,950$ | 17,995,950$ | 65,000,000$ | 7,004,050$ | 14,615,177$ | 14,615,177$ |
| 15 | NYRangers | 7000 | 6000 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 159310 | 154245 | 67086 | 123272 | 31327 | 55.51% | 62.70% | 58.90% | 54.12% | 55.01% | 0 | 13055 - 57.45% | 1,430,663$ | 58,657,191$ | 22723 | 100 | 67,250,000$ | 66,458,000$ | 0$ | 71,222,720$ | 355,390$ | 64,964,660$ | 21 | 0 | 0$ | 0$ | 0 | 382,353$ | 0$ | 0$ | 64,964,660$ | 24,964,660$ | 65,000,000$ | 35,340$ | 876,122$ | 876,122$ |
| 16 | Philadelphie | 7033 | 6944 | 2778 | 5556 | 1389 | 82 | 48 | 40 | 28 | 170 | 272665 | 243187 | 106140 | 205969 | 46483 | 94.56% | 85.42% | 93.19% | 90.42% | 81.62% | 0 | 21328 - 89.99% | 1,523,584$ | 62,466,924$ | 23700 | 100 | 66,017,500$ | 66,017,500$ | 1,560,000$ | 69,024,154$ | 353,035$ | 63,260,798$ | 22 | 0 | 0$ | 0$ | 0 | 381,778$ | 0$ | 0$ | 64,820,798$ | 24,820,798$ | 65,000,000$ | 179,202$ | 8,357,643$ | 8,357,643$ |
| 17 | Pittsburgh | 7360 | 5400 | 2600 | 4800 | 1075 | 77 | 63 | 41 | 32 | 177 | 278487 | 215506 | 103520 | 185657 | 43358 | 92.29% | 97.34% | 97.11% | 94.34% | 98.37% | 0 | 20159 - 94.93% | 1,568,496$ | 64,308,331$ | 21235 | 100 | 65,380,000$ | 50,069,000$ | 3,171,000$ | 65,592,348$ | 267,749$ | 53,285,069$ | 30 | 1 | 0$ | 0$ | 0 | 372,225$ | 0$ | 0$ | 56,456,069$ | 16,456,069$ | 65,000,000$ | 8,543,931$ | 7,739,513$ | 7,739,513$ |
| 18 | San Jose | 8333 | 6944 | 2778 | 5556 | 1000 | 81 | 54 | 42 | 32 | 184 | 273198 | 241008 | 104890 | 201508 | 37117 | 79.96% | 84.65% | 92.09% | 88.46% | 90.53% | 0 | 20920 - 85.00% | 1,549,744$ | 63,539,514$ | 24611 | 100 | 64,179,000$ | 64,179,000$ | 0$ | 65,994,966$ | 343,203$ | 63,994,996$ | 22 | 0 | 0$ | 0$ | 0 | 353,898$ | 0$ | 0$ | 63,994,996$ | 23,994,996$ | 65,000,000$ | 1,005,004$ | 15,431,546$ | 15,431,546$ |
| 19 | Seattle | 7250 | 6000 | 2778 | 4500 | 1050 | 85 | 50 | 40 | 30 | 175 | 270375 | 238043 | 104525 | 176453 | 42814 | 90.96% | 96.77% | 91.77% | 95.64% | 99.45% | 0 | 20298 - 94.07% | 1,534,741$ | 62,924,395$ | 21578 | 100 | 64,458,500$ | 60,794,510$ | 2,291,000$ | 69,287,451$ | 325,104$ | 62,336,095$ | 23 | 0 | 0$ | 0$ | 0 | 360,741$ | 0$ | 0$ | 64,627,095$ | 24,627,095$ | 65,000,000$ | 372,905$ | 137,068$ | 137,068$ |
| 20 | St. Louis | 6400 | 6944 | 2778 | 5556 | 1389 | 88 | 62 | 39 | 30 | 120 | 259523 | 228288 | 105419 | 206395 | 49270 | 98.90% | 80.18% | 92.56% | 90.61% | 86.52% | 0 | 20705 - 89.76% | 1,562,201$ | 64,050,230$ | 23067 | 100 | 67,570,000$ | 62,996,200$ | 1,300,000$ | 70,311,479$ | 336,878$ | 63,434,926$ | 26 | 0 | 0$ | 0$ | 0 | 384,332$ | 0$ | 0$ | 64,734,926$ | 24,734,926$ | 65,000,000$ | 265,074$ | 7,017,347$ | 7,017,347$ |
| 21 | Tampa Bay | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 65 | 50 | 22 | 184 | 246000 | 191106 | 81871 | 217324 | 37230 | 100.00% | 93.22% | 73.41% | 96.73% | 90.80% | 0 | 18867 - 93.40% | 1,404,218$ | 57,572,952$ | 20200 | 100 | 67,290,000$ | 65,904,000$ | 1,200,000$ | 72,671,870$ | 352,428$ | 63,503,012$ | 24 | 0 | 0$ | 0$ | 0 | 383,904$ | 0$ | 0$ | 64,703,012$ | 24,703,012$ | 65,000,000$ | 296,988$ | -4,633,549$ | -4,633,549$ |
| 22 | Vancouver | 8333 | 6944 | 2778 | 5556 | 1289 | 100 | 75 | 60 | 45 | 175 | 198421 | 166641 | 72266 | 131668 | 44296 | 58.08% | 58.53% | 63.45% | 57.80% | 83.82% | 0 | 14958 - 60.07% | 1,455,042$ | 59,656,720$ | 24900 | 100 | 64,525,000$ | 64,525,000$ | 0$ | 68,865,867$ | 345,053$ | 64,423,280$ | 20 | 0 | 0$ | 0$ | 0 | 367,781$ | 0$ | 0$ | 64,423,280$ | 24,423,280$ | 65,000,000$ | 576,720$ | -1,257,930$ | -1,257,930$ |
| 23 | Washington | 7333 | 6944 | 2778 | 5556 | 1089 | 75 | 59 | 36 | 29 | 160 | 279004 | 236037 | 107768 | 202503 | 44272 | 92.80% | 82.91% | 94.62% | 88.90% | 99.16% | 0 | 21209 - 89.49% | 1,512,797$ | 62,024,685$ | 23700 | 100 | 48,651,000$ | 46,720,500$ | 4,070,950$ | 61,148,147$ | 249,842$ | 57,928,604$ | 22 | 0 | 0$ | 0$ | 0 | 268,187$ | 0$ | 0$ | 61,999,554$ | 21,999,554$ | 65,000,000$ | 3,000,446$ | 20,329,954$ | 20,329,954$ |
| 24 | Winnipeg | 6000 | 6000 | 2778 | 4000 | 1389 | 87 | 65 | 54 | 32 | 175 | 246000 | 194956 | 75759 | 164000 | 46508 | 100.00% | 79.25% | 66.51% | 100.00% | 81.67% | 0 | 17737 - 87.95% | 1,508,840$ | 61,862,429$ | 20167 | 100 | 67,875,000$ | 67,875,000$ | 0$ | 67,267,384$ | 362,968$ | 64,974,488$ | 21 | 0 | 0$ | 0$ | 0 | 370,989$ | 0$ | 0$ | 64,974,488$ | 24,974,488$ | 65,000,000$ | 25,512$ | 38,278,549$ | 38,278,549$ |
Bridgeport
Charlotte
Cleveland
Grand Rapids
Hartford
Hershey
Laval
Lehigh Valley
Providence
Rochester
Syracuse
Wilkes-Barre/Scranton
Abbotsford
Bakersfield
Coachella Valley
Eagles
Iowa
Manitoba
Ontario
Rockford
San Diego
San Jose
Springfield
Texas