| 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 49,360,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Anaheim | 6000 | 5000 | 3000 | 3000 | 1500 | 175 | 90 | 65 | 40 | 325 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 77,329,167$ | 77,329,167$ | -3,500,000$ | 0$ | 0$ | 0$ | 26 | 3 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 184,563,438$ | 184,563,438$ |
| 2 | Boston | 6105 | 5180 | 2035 | 4070 | 1110 | 180 | 100 | 99 | 98 | 350 | 9751 | 8228 | 3082 | 4042 | 2030 | 79.86% | 79.42% | 75.72% | 49.66% | 91.44% | 39 | 13567 - 73.33% | 2,593,314$ | 5,186,628$ | 18500 | 100 | 70,470,836$ | 69,831,947$ | 2,246,823$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 195,074,045$ | 195,074,045$ |
| 3 | Buffalo | 7500 | 6000 | 2500 | 4000 | 2000 | 125 | 75 | 50 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 64,863,335$ | 64,577,621$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 167,660,105$ | 167,660,105$ |
| 4 | Calgary | 6500 | 5250 | 2250 | 4000 | 1500 | 200 | 100 | 100 | 100 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19500 | 100 | 66,257,502$ | 66,400,359$ | -1,190,476$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 307,804,710$ | 307,804,710$ |
| 5 | Caroline | 6000 | 5000 | 2000 | 4000 | 1000 | 140 | 82 | 64 | 42 | 299 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 2,398,500$ | 4,797,000$ | 18000 | 100 | 68,887,169$ | 70,601,455$ | 307,334$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 183,346,315$ | 183,346,315$ |
| 6 | Chicago | 7000 | 6000 | 2500 | 5000 | 1500 | 200 | 100 | 99 | 98 | 400 | 8732 | 8393 | 3283 | 4147 | 1817 | 62.37% | 69.94% | 65.66% | 41.47% | 60.57% | 39 | 13186 - 59.94% | 2,628,550$ | 5,257,100$ | 22000 | 100 | 71,995,000$ | 72,995,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 470,010,769$ | 470,010,769$ |
| 7 | Colorado | 6000 | 5000 | 2500 | 4000 | 1000 | 160 | 100 | 65 | 40 | 300 | 10006 | 8188 | 5000 | 8000 | 2000 | 83.38% | 81.88% | 100.00% | 100.00% | 100.00% | 39 | 16597 - 89.71% | 2,382,094$ | 4,764,188$ | 18500 | 100 | 70,464,446$ | 70,607,303$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 289,099,703$ | 289,099,703$ |
| 8 | Columbus | 6700 | 5800 | 3000 | 5000 | 1500 | 135 | 70 | 50 | 35 | 260 | 12963 | 11600 | 5801 | 9470 | 2796 | 96.74% | 100.00% | 96.68% | 94.70% | 93.20% | 39 | 21315 - 96.89% | 2,541,802$ | 5,083,604$ | 22000 | 100 | 71,460,621$ | 71,679,668$ | -1,696,429$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 300,929,658$ | 300,929,658$ |
| 9 | Dallas | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 67 | 65 | 27 | 275 | 6000 | 5000 | 2000 | 4000 | 1000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 40 | 18000 - 100.00% | 1,999,400$ | 1,999,400$ | 18000 | 100 | 66,444,947$ | 66,444,947$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 130,694,743$ | 130,694,743$ |
| 10 | Detroit | 7500 | 6000 | 2000 | 5000 | 1500 | 150 | 100 | 99 | 98 | 400 | 10710 | 8240 | 3207 | 4393 | 1798 | 71.40% | 68.67% | 80.18% | 43.93% | 59.93% | 39 | 14174 - 64.43% | 2,533,510$ | 5,067,019$ | 22000 | 100 | 67,487,548$ | 67,558,977$ | 429$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 353,233,774$ | 353,233,774$ |
| 11 | Edmonton | 6000 | 5000 | 2500 | 4000 | 1750 | 180 | 100 | 50 | 20 | 400 | 9277 | 7951 | 5000 | 8000 | 1692 | 77.31% | 79.51% | 100.00% | 100.00% | 48.34% | 39 | 15960 - 82.91% | 2,308,644$ | 4,617,288$ | 19250 | 100 | 73,735,000$ | 73,985,000$ | 0$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 192,051,145$ | 192,051,145$ |
| 12 | Hartford | 7000 | 5000 | 2500 | 4000 | 1500 | 110 | 87 | 68 | 55 | 215 | 6981 | 4268 | 2395 | 3481 | 1487 | 99.73% | 85.36% | 95.80% | 87.03% | 99.13% | 40 | 18612 - 93.06% | 2,357,220$ | 2,357,220$ | 20000 | 100 | 70,527,502$ | 71,444,169$ | 689,270$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 244,959,689$ | 244,959,689$ |
| 13 | Islanders | 6500 | 5000 | 2000 | 4000 | 1000 | 110 | 75 | 50 | 37 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 67,538,206$ | 67,399,634$ | -2,380,952$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 173,664,053$ | 173,664,053$ |
| 14 | Kansas City | 240 | 6000 | 3000 | 4000 | 1500 | 185 | 100 | 60 | 55 | 399 | 240 | 3920 | 2868 | 3205 | 945 | 100.00% | 65.33% | 95.60% | 80.13% | 63.00% | 40 | 11178 - 75.83% | 1,510,353$ | 1,510,353$ | 14740 | 100 | 68,345,000$ | 68,345,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 217,951,796$ | 217,951,796$ |
| 15 | LA Kings | 6000 | 5000 | 3500 | 4000 | 1500 | 120 | 70 | 30 | 25 | 160 | 6000 | 5000 | 3033 | 4000 | 1420 | 100.00% | 100.00% | 86.66% | 100.00% | 94.67% | 40 | 19453 - 97.27% | 1,934,647$ | 1,934,647$ | 20000 | 100 | 63,780,000$ | 64,565,714$ | -440,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 234,227,172$ | 234,227,172$ |
| 16 | Las Vegas | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 8888 | 7770 | 3237 | 4185 | 1808 | 74.07% | 77.70% | 80.93% | 52.31% | 90.40% | 39 | 12944 - 71.91% | 2,605,456$ | 5,210,911$ | 18000 | 100 | 66,477,168$ | 67,977,168$ | -1,033,333$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 162,831,830$ | 162,831,830$ |
| 17 | Minnesota | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 56,623,335$ | 57,290,002$ | 3,500,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 76,787,262$ | 76,787,262$ |
| 18 | Montreal | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 76 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 57,751,927$ | 57,753,032$ | 1,896,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 273,198,411$ | 273,198,411$ |
| 19 | Nashville | 6700 | 5800 | 3200 | 4500 | 1800 | 120 | 80 | 60 | 40 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 46,206,669$ | 46,206,669$ | 16,197,889$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 259,173,218$ | 259,173,218$ |
| 20 | Ottawa | 7500 | 6000 | 2000 | 5000 | 1500 | 175 | 100 | 99 | 95 | 400 | 4635 | 4088 | 1728 | 2079 | 945 | 61.80% | 68.13% | 86.40% | 41.58% | 63.00% | 40 | 13475 - 61.25% | 2,556,453$ | 2,556,453$ | 22000 | 100 | 78,142,333$ | 78,142,333$ | 0$ | 0$ | 0$ | 0$ | 34 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 329,689,627$ | 329,689,627$ |
| 21 | Philadelphie | 7000 | 5000 | 2500 | 3837 | 1200 | 110 | 80 | 60 | 50 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19537 | 100 | 52,207,058$ | 52,207,058$ | -1,041,667$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 187,162,899$ | 187,162,899$ |
| 22 | Pittsburgh | 6100 | 5150 | 2650 | 4300 | 1050 | 144 | 84 | 59 | 36 | 316 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19250 | 100 | 77,644,167$ | 77,144,167$ | -1,604,167$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 278,587,355$ | 278,587,355$ |
| 23 | Quebec | 7000 | 4000 | 3000 | 3500 | 1000 | 200 | 100 | 75 | 50 | 400 | 4450 | 4000 | 1956 | 3500 | 856 | 63.57% | 100.00% | 65.20% | 100.00% | 85.60% | 40 | 14762 - 79.79% | 2,540,330$ | 2,540,330$ | 18500 | 100 | 71,414,501$ | 71,414,501$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 167,448,530$ | 167,448,530$ |
| 24 | Rangers | 6000 | 6000 | 2500 | 4000 | 1000 | 130 | 60 | 40 | 30 | 260 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19500 | 100 | 58,676,391$ | 58,841,206$ | 4,571,429$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 172,499,533$ | 172,499,533$ |
| 25 | San Jose | 6600 | 5600 | 2650 | 5000 | 1000 | 130 | 80 | 55 | 40 | 344 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20850 | 100 | 53,579,500$ | 52,722,357$ | 1,234,740$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 218,209,424$ | 218,209,424$ |
| 26 | Seattle | 6000 | 5000 | 2500 | 4000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 78,786,111$ | 77,571,825$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 54,576,058$ | 54,576,058$ |
| 27 | St-Louis | 6500 | 5500 | 3500 | 3000 | 1500 | 200 | 100 | 99 | 75 | 395 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 67,451,988$ | 65,651,988$ | 1,033,333$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 411,753,152$ | 411,753,152$ |
| 28 | Tampa Bay | 6000 | 5000 | 2500 | 4000 | 1000 | 125 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 63,680,000$ | 63,680,000$ | -595,833$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 259,725,107$ | 259,725,107$ |
| 29 | Toronto | 6000 | 5000 | 2500 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 4001 | 4285 | 1724 | 2236 | 866 | 66.68% | 85.70% | 68.96% | 55.90% | 86.60% | 40 | 13112 - 70.88% | 2,554,375$ | 2,554,375$ | 18500 | 100 | 69,301,667$ | 68,956,429$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 98,446,345$ | 98,446,345$ |
| 30 | Vancouver | 5000 | 7000 | 4000 | 4000 | 2000 | 120 | 70 | 50 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 70,535,838$ | 71,035,838$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 145,402,145$ | 145,402,145$ |
| 31 | Washington | 6000 | 5000 | 2500 | 4000 | 1000 | 130 | 85 | 40 | 30 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 71,521,461$ | 71,521,461$ | 0$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 162,276,138$ | 162,276,138$ |
| 32 | Winnipeg | 6500 | 5500 | 2500 | 4000 | 1500 | 105 | 75 | 60 | 50 | 200 | 6500 | 5500 | 2500 | 4000 | 1476 | 100.00% | 100.00% | 100.00% | 100.00% | 98.40% | 40 | 19976 - 99.88% | 2,262,260$ | 2,262,260$ | 20000 | 100 | 75,773,449$ | 75,973,449$ | 0$ | 0$ | 0$ | 0$ | 33 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 150,060,836$ | 150,060,836$ |
