| 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 48,800,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.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18500 | 100 | 59,462,502$ | 59,462,502$ | 0$ | 0$ | 0$ | 0$ | 26 | 3 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 165,648,249$ | 165,648,249$ |
| 2 | Boston | 6105 | 5180 | 2035 | 4070 | 1110 | 180 | 100 | 99 | 98 | 350 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18500 | 100 | 65,843,836$ | 65,843,836$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 168,034,052$ | 168,034,052$ |
| 3 | Buffalo | 7500 | 6000 | 2500 | 4000 | 2000 | 125 | 75 | 50 | 30 | 200 | 12946 | 11302 | 5000 | 8000 | 2900 | 86.31% | 94.18% | 100.00% | 100.00% | 72.50% | 39 | 20074 - 91.25% | 1,767,950$ | 3,535,900$ | 22000 | 100 | 71,250,001$ | 70,964,287$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 145,115,699$ | 145,115,699$ |
| 4 | Calgary | 6500 | 5250 | 2250 | 4000 | 1500 | 200 | 100 | 100 | 100 | 400 | 27662 | 25453 | 10677 | 14120 | 5970 | 70.93% | 80.80% | 79.09% | 58.83% | 66.33% | 35 | 13980 - 71.69% | 2,157,567$ | 12,945,400$ | 19500 | 100 | 62,731,541$ | 62,731,541$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 281,049,167$ | 281,049,167$ |
| 5 | Caroline | 6000 | 5000 | 2000 | 4000 | 1000 | 140 | 82 | 64 | 42 | 299 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 1,845,000$ | 5,535,000$ | 18000 | 100 | 77,362,169$ | 78,076,455$ | -458,982$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 146,671,840$ | 146,671,840$ |
| 6 | Chicago | 7000 | 6000 | 2500 | 5000 | 1500 | 200 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 22000 | 100 | 58,445,000$ | 59,445,000$ | 3,333,333$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 440,283,578$ | 440,283,578$ |
| 7 | Colorado | 6000 | 5000 | 2500 | 4000 | 1000 | 160 | 100 | 65 | 40 | 300 | 15646 | 12446 | 7500 | 12000 | 3000 | 86.92% | 82.97% | 100.00% | 100.00% | 100.00% | 38 | 16864 - 91.16% | 1,871,820$ | 5,615,460$ | 18500 | 100 | 76,785,279$ | 76,394,803$ | -2,100,000$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 261,235,711$ | 261,235,711$ |
| 8 | Columbus | 6700 | 5800 | 3000 | 5000 | 1500 | 135 | 70 | 50 | 35 | 260 | 79831 | 69324 | 35749 | 59323 | 17374 | 99.29% | 99.60% | 99.30% | 98.87% | 96.52% | 29 | 21800 - 99.09% | 2,000,905$ | 24,010,860$ | 22000 | 100 | 68,365,304$ | 68,584,351$ | -1,696,429$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 271,732,471$ | 271,732,471$ |
| 9 | Dallas | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 67 | 65 | 27 | 275 | 24000 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 1,538,000$ | 6,152,000$ | 18000 | 100 | 68,425,838$ | 68,425,838$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 111,664,592$ | 111,664,592$ |
| 10 | Detroit | 7500 | 6000 | 2000 | 5000 | 1500 | 150 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 22000 | 100 | 67,245,001$ | 66,716,430$ | 429$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 322,153,182$ | 322,153,182$ |
| 11 | Edmonton | 6000 | 5000 | 2500 | 4000 | 1750 | 180 | 100 | 50 | 20 | 400 | 14366 | 12615 | 7500 | 12000 | 2857 | 79.81% | 84.10% | 100.00% | 100.00% | 54.42% | 38 | 16446 - 85.43% | 1,868,393$ | 5,605,180$ | 19250 | 100 | 73,071,778$ | 72,571,778$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 176,042,791$ | 176,042,791$ |
| 12 | Hartford | 7000 | 5000 | 2500 | 4000 | 1500 | 110 | 87 | 68 | 55 | 215 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 59,355,000$ | 59,355,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 223,727,712$ | 223,727,712$ |
| 13 | Islanders | 6500 | 5000 | 2000 | 4000 | 1000 | 110 | 75 | 50 | 37 | 400 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18500 | 100 | 70,045,833$ | 70,032,261$ | -4,571,429$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 156,700,765$ | 156,700,765$ |
| 14 | Kansas City | 240 | 6000 | 3000 | 4000 | 1500 | 185 | 100 | 60 | 55 | 399 | 2160 | 41162 | 25957 | 34340 | 9359 | 100.00% | 76.23% | 96.14% | 95.39% | 69.33% | 32 | 12553 - 85.16% | 1,299,573$ | 11,696,161$ | 14740 | 100 | 72,155,625$ | 72,155,625$ | -1,360,000$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 226,941,817$ | 226,941,817$ |
| 15 | LA Kings | 6000 | 5000 | 3500 | 4000 | 1500 | 120 | 70 | 30 | 25 | 160 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 66,011,667$ | 68,011,667$ | 560,000$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 222,928,657$ | 222,928,657$ |
| 16 | Las Vegas | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 13268 | 12162 | 4971 | 6736 | 2576 | 73.71% | 81.08% | 82.85% | 56.13% | 85.87% | 38 | 13238 - 73.54% | 2,017,486$ | 6,052,457$ | 18000 | 100 | 68,055,000$ | 67,055,000$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 130,530,788$ | 130,530,788$ |
| 17 | Minnesota | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 54,220,002$ | 54,220,002$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 65,610,306$ | 65,610,306$ |
| 18 | Montreal | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 76 | 400 | 33303 | 31856 | 12617 | 20467 | 6683 | 79.29% | 91.02% | 90.12% | 73.10% | 95.47% | 34 | 14989 - 83.27% | 2,189,139$ | 15,323,975$ | 18000 | 100 | 62,012,277$ | 61,309,896$ | 2,076,180$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 242,258,847$ | 242,258,847$ |
| 19 | Nashville | 6700 | 5800 | 3200 | 4500 | 1800 | 120 | 80 | 60 | 40 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 22000 | 100 | 44,776,669$ | 44,776,669$ | 11,356,556$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 228,752,078$ | 228,752,078$ |
| 20 | Ottawa | 7500 | 6000 | 2000 | 5000 | 1500 | 175 | 100 | 99 | 95 | 400 | 29344 | 26688 | 10718 | 14598 | 5970 | 65.21% | 74.13% | 89.32% | 48.66% | 66.33% | 35 | 14553 - 66.15% | 2,106,649$ | 12,639,892$ | 22000 | 100 | 68,086,112$ | 68,586,112$ | 2,100,000$ | 0$ | 0$ | 0$ | 30 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 305,554,325$ | 305,554,325$ |
| 21 | Philadelphie | 7000 | 5000 | 2500 | 3837 | 1200 | 110 | 80 | 60 | 50 | 150 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19537 | 100 | 63,687,294$ | 61,521,262$ | -1,326,500$ | 0$ | 0$ | 0$ | 28 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 163,439,479$ | 163,439,479$ |
| 22 | Pittsburgh | 6100 | 5150 | 2650 | 4300 | 1050 | 144 | 84 | 59 | 36 | 316 | 12200 | 10300 | 5140 | 8600 | 2100 | 100.00% | 100.00% | 96.98% | 100.00% | 100.00% | 39 | 19170 - 99.58% | 1,949,230$ | 3,898,460$ | 19250 | 100 | 75,755,000$ | 76,421,667$ | -3,333,333$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 251,303,036$ | 251,303,036$ |
| 23 | Quebec | 7000 | 4000 | 3000 | 3500 | 1000 | 200 | 100 | 75 | 50 | 400 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18500 | 100 | 70,259,167$ | 70,305,000$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 141,174,967$ | 141,174,967$ |
| 24 | Rangers | 6000 | 6000 | 2500 | 4000 | 1000 | 130 | 60 | 40 | 30 | 260 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19500 | 100 | 55,194,680$ | 55,759,495$ | 4,571,429$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 150,263,328$ | 150,263,328$ |
| 25 | San Jose | 6600 | 5600 | 2650 | 5000 | 1000 | 95 | 65 | 35 | 22 | 300 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20850 | 100 | 62,708,112$ | 62,158,112$ | 1,666,500$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 194,938,286$ | 194,938,286$ |
| 26 | Seattle | 6000 | 5000 | 2500 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18500 | 100 | 54,138,870$ | 54,781,727$ | 0$ | 0$ | 0$ | 0$ | 23 | 2 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 47,576,410$ | 47,576,410$ |
| 27 | St-Louis | 6500 | 5500 | 3500 | 3000 | 1500 | 200 | 100 | 99 | 75 | 395 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 49,015,502$ | 49,932,169$ | 766,316$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 388,324,463$ | 388,324,463$ |
| 28 | Tampa Bay | 6000 | 5000 | 2500 | 4000 | 1000 | 125 | 80 | 50 | 35 | 250 | 24000 | 20000 | 10000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18500 - 100.00% | 1,665,000$ | 6,660,000$ | 18500 | 100 | 68,014,167$ | 67,514,167$ | 0$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 241,205,892$ | 241,205,892$ |
| 29 | Toronto | 6000 | 5000 | 2500 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18500 | 100 | 57,169,154$ | 56,740,583$ | 1,018,421$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 65,544,125$ | 65,544,125$ |
| 30 | Vancouver | 5000 | 7000 | 4000 | 4000 | 2000 | 150 | 100 | 99 | 98 | 400 | 80000 | 77311 | 32234 | 44904 | 17934 | 100.00% | 69.03% | 50.37% | 70.16% | 56.04% | 25 | 15774 - 71.70% | 2,156,029$ | 34,496,458$ | 22000 | 100 | 75,580,838$ | 77,297,505$ | -1,018,421$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 133,935,698$ | 133,935,698$ |
| 31 | Washington | 6000 | 5000 | 2500 | 4000 | 1000 | 130 | 85 | 40 | 30 | 220 | 42000 | 35000 | 17500 | 28000 | 7000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 18500 - 100.00% | 1,645,000$ | 11,515,000$ | 18500 | 100 | 69,570,673$ | 69,570,673$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 145,312,234$ | 145,312,234$ |
| 32 | Winnipeg | 6500 | 5500 | 2500 | 4000 | 1500 | 100 | 70 | 55 | 45 | 195 | 45500 | 38353 | 17500 | 28000 | 10382 | 100.00% | 99.62% | 100.00% | 100.00% | 98.88% | 34 | 19962 - 99.81% | 1,640,243$ | 11,481,700$ | 20000 | 100 | 69,523,116$ | 68,951,687$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -48,800,000$ | 66,000,000$ | 66,000,000$ | 133,495,715$ | 133,495,715$ |
