| 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 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 79,400,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Blackhawks | 3000 | 4000 | 5000 | 6000 | 2000 | 161 | 110 | 90 | 65 | 271 | 102000 | 136000 | 170000 | 203601 | 68000 | 100.00% | 100.00% | 100.00% | 99.80% | 100.00% | 7 | 19988 - 99.94% | 2,744,548$ | 93,314,643$ | 20000 | 141 | 101,744,502$ | 101,744,503$ | 0$ | 83,959,471$ | 820,520$ | 80,700,286$ | 23 | 0 | 0$ | 19,211,838$ | 24 | 846,407$ | 20,313,768$ | 20,951,184$ | 100,392,766$ | 20,992,766$ | 107,500,000$ | 7,107,234$ | 47,669,798$ | 46,605,473$ |
| 2 | BlueJackets | 3000 | 4000 | 5000 | 6000 | 2000 | 135 | 110 | 85 | 40 | 240 | 102000 | 133676 | 165423 | 204000 | 68000 | 100.00% | 98.29% | 97.31% | 100.00% | 100.00% | 7 | 19797 - 98.99% | 2,522,929$ | 85,779,602$ | 20000 | 118 | 108,235,863$ | 108,235,865$ | -3,000,000$ | 90,872,980$ | 872,870$ | 87,647,180$ | 22 | 0 | 1,454,496$ | 17,660,506$ | 24 | 905,128$ | 21,723,072$ | 22,361,808$ | 105,596,060$ | 26,196,060$ | 107,500,000$ | 1,903,940$ | 138,072,575$ | 134,139,641$ |
| 3 | Blues | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 125440 | 167116 | 199655 | 225104 | 82776 | 98.38% | 98.30% | 93.96% | 88.28% | 97.38% | 7 | 23532 - 94.13% | 3,610,331$ | 122,751,270$ | 25000 | 151 | 79,476,158$ | 79,476,158$ | 0$ | 74,907,108$ | 640,937$ | 72,790,408$ | 22 | 0 | 0$ | 25,272,320$ | 24 | 653,034$ | 15,672,816$ | 16,196,088$ | 88,172,896$ | 8,772,896$ | 107,500,000$ | 19,327,104$ | 129,628,841$ | 139,379,725$ |
| 4 | Bruins | 3000 | 4000 | 5000 | 6000 | 2000 | 170 | 110 | 90 | 60 | 285 | 99000 | 132000 | 165000 | 198000 | 66000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 8 | 20000 - 100.00% | 2,982,400$ | 98,419,200$ | 20000 | 160 | 111,339,758$ | 111,339,757$ | -5,000,000$ | 94,467,500$ | 897,901$ | 89,790,100$ | 22 | 0 | 5,343,000$ | 23,859,200$ | 24 | 944,675$ | 22,672,200$ | 23,125,512$ | 106,339,724$ | 26,939,724$ | 107,500,000$ | 1,160,276$ | 181,146,708$ | 182,751,614$ |
| 5 | Canadiens | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 85 | 60 | 270 | 127500 | 170000 | 212500 | 255000 | 85000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 7 | 25000 - 100.00% | 3,592,000$ | 122,128,000$ | 25000 | 183 | 94,430,232$ | 93,680,232$ | 0$ | 79,475,380$ | 755,486$ | 73,467,323$ | 25 | 0 | 0$ | 25,144,000$ | 24 | 815,566$ | 19,573,584$ | 20,249,688$ | 91,598,987$ | 12,198,987$ | 107,500,000$ | 15,901,013$ | 249,760,250$ | 255,334,522$ |
| 6 | Canucks | 3000 | 4000 | 5000 | 6000 | 2000 | 110 | 70 | 45 | 35 | 210 | 102000 | 136000 | 170000 | 204000 | 68000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 7 | 20000 - 100.00% | 1,875,200$ | 63,756,800$ | 20000 | 113 | 100,891,000$ | 100,891,001$ | 0$ | 81,281,546$ | 813,637$ | 79,668,646$ | 23 | 0 | 0$ | 13,126,400$ | 24 | 829,766$ | 19,914,384$ | 20,316,120$ | 99,195,934$ | 19,795,934$ | 107,500,000$ | 8,304,066$ | 34,101,100$ | 27,566,659$ |
| 7 | Capitals | 3750 | 5000 | 6250 | 7500 | 2500 | 137 | 94 | 74 | 49 | 246 | 127500 | 170000 | 212369 | 254935 | 84976 | 100.00% | 100.00% | 99.94% | 99.97% | 99.97% | 7 | 24994 - 99.97% | 3,108,093$ | 105,675,157$ | 25000 | 125 | 96,549,734$ | 96,549,733$ | 0$ | 80,347,556$ | 778,627$ | 78,336,713$ | 22 | 0 | 0$ | 21,756,650$ | 24 | 794,756$ | 19,074,144$ | 19,584,600$ | 97,023,761$ | 17,623,761$ | 107,500,000$ | 10,476,239$ | 335,543,499$ | 338,304,198$ |
| 8 | Ducks | 3750 | 5000 | 6250 | 7500 | 2500 | 161 | 108 | 83 | 58 | 271 | 127500 | 169939 | 212032 | 252960 | 85000 | 100.00% | 99.96% | 99.78% | 99.20% | 100.00% | 7 | 24924 - 99.70% | 3,545,835$ | 120,558,397$ | 25000 | 164 | 85,107,965$ | 83,565,965$ | 0$ | 69,312,631$ | 673,919$ | 67,039,893$ | 20 | 1 | 0$ | 24,820,846$ | 24 | 705,709$ | 16,937,016$ | 17,519,232$ | 83,213,949$ | 3,813,949$ | 107,500,000$ | 24,286,051$ | 479,463,798$ | 487,445,079$ |
| 9 | Flames | 3750 | 5000 | 6250 | 7500 | 2500 | 145 | 110 | 85 | 55 | 285 | 127500 | 170000 | 212500 | 255000 | 85000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 7 | 25000 - 100.00% | 3,520,000$ | 119,680,000$ | 25000 | 196 | 114,126,692$ | 114,126,693$ | -5,140,000$ | 93,406,371$ | 920,377$ | 89,374,083$ | 20 | 1 | 4,510,966$ | 24,640,000$ | 24 | 960,699$ | 23,056,776$ | 23,619,600$ | 106,323,131$ | 26,923,131$ | 107,500,000$ | 1,176,869$ | 341,546,894$ | 343,328,459$ |
| 10 | Flyers | 3300 | 4400 | 5500 | 6600 | 2200 | 148 | 85 | 60 | 38 | 270 | 108900 | 145200 | 181500 | 217800 | 72600 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 8 | 22000 - 100.00% | 2,607,616$ | 86,051,328$ | 22000 | 138 | 101,550,002$ | 101,550,000$ | 0$ | 83,241,292$ | 818,952$ | 80,243,385$ | 22 | 0 | 0$ | 20,860,928$ | 24 | 844,758$ | 20,274,192$ | 20,864,592$ | 99,898,233$ | 20,498,233$ | 107,500,000$ | 7,601,767$ | 145,363,374$ | 146,127,632$ |
| 11 | GoldenKnights | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 75 | 50 | 285 | 127500 | 170000 | 212500 | 255000 | 85000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 7 | 25000 - 100.00% | 3,512,000$ | 119,408,000$ | 25000 | 178 | 108,604,644$ | 108,604,644$ | -5,000,000$ | 92,958,700$ | 875,844$ | 88,361,907$ | 21 | 0 | 2,486,614$ | 24,584,000$ | 24 | 921,812$ | 22,123,488$ | 22,544,352$ | 104,382,163$ | 24,982,163$ | 107,500,000$ | 3,117,837$ | 381,133,818$ | 383,797,100$ |
| 12 | Hurricanes | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 80 | 55 | 270 | 123331 | 160663 | 203044 | 243238 | 82006 | 99.66% | 97.37% | 98.45% | 98.28% | 99.40% | 8 | 24615 - 98.46% | 3,458,681$ | 114,136,472$ | 25000 | 149 | 87,364,942$ | 87,364,944$ | 0$ | 78,988,608$ | 704,556$ | 74,312,456$ | 22 | 0 | 0$ | 27,669,448$ | 24 | 748,911$ | 17,973,864$ | 18,420,720$ | 91,221,800$ | 11,821,800$ | 107,500,000$ | 16,278,200$ | 336,965,011$ | 346,994,120$ |
| 13 | Islanders | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 107 | 89 | 58 | 285 | 117363 | 152913 | 171252 | 213346 | 73379 | 94.84% | 92.67% | 83.03% | 86.20% | 88.94% | 8 | 22068 - 88.27% | 3,245,315$ | 107,095,401$ | 25000 | 134 | 104,723,567$ | 104,723,567$ | 5,000,000$ | 82,034,783$ | 844,545$ | 79,180,907$ | 24 | 0 | 0$ | 25,962,521$ | 24 | 868,738$ | 20,849,712$ | 21,512,544$ | 104,449,987$ | 25,049,987$ | 107,500,000$ | 3,050,013$ | 287,218,641$ | 292,441,175$ |
| 14 | Jets | 3750 | 5000 | 6250 | 7500 | 2500 | 96 | 65 | 50 | 21 | 200 | 127500 | 170000 | 212348 | 255000 | 84303 | 100.00% | 100.00% | 99.93% | 100.00% | 99.18% | 7 | 24975 - 99.90% | 2,112,866$ | 71,837,440$ | 25000 | 114 | 105,415,075$ | 105,415,074$ | -5,375,000$ | 88,347,456$ | 850,122$ | 84,097,430$ | 22 | 0 | 0$ | 14,790,061$ | 24 | 890,444$ | 21,370,656$ | 21,722,064$ | 99,125,358$ | 19,725,358$ | 107,500,000$ | 8,374,642$ | 32,485,874$ | 26,233,177$ |
| 15 | Kings | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 127500 | 170000 | 212469 | 251290 | 85000 | 100.00% | 100.00% | 99.99% | 98.55% | 100.00% | 7 | 24890 - 99.56% | 3,765,640$ | 128,031,757$ | 25000 | 167 | 100,375,943$ | 100,375,943$ | 0$ | 85,556,390$ | 809,483$ | 80,959,591$ | 21 | 0 | 0$ | 26,359,479$ | 24 | 855,451$ | 20,530,824$ | 21,079,896$ | 100,387,183$ | 20,987,183$ | 107,500,000$ | 7,112,817$ | 222,022,616$ | 227,933,857$ |
| 16 | Lightning | 2700 | 3600 | 4500 | 5400 | 1800 | 170 | 110 | 90 | 65 | 285 | 91800 | 122400 | 152495 | 180410 | 61200 | 100.00% | 100.00% | 99.67% | 98.26% | 100.00% | 7 | 17891 - 99.40% | 2,709,203$ | 92,112,894$ | 18000 | 124 | 110,277,784$ | 110,277,784$ | 0$ | 85,660,063$ | 889,337$ | 80,858,143$ | 24 | 0 | 72,604$ | 18,964,419$ | 24 | 929,660$ | 22,311,840$ | 22,757,304$ | 102,202,231$ | 22,802,231$ | 107,500,000$ | 5,297,769$ | 57,718,394$ | 54,607,512$ |
| 17 | Maple Leafs | 3750 | 5000 | 6250 | 7500 | 2500 | 160 | 110 | 85 | 60 | 270 | 127500 | 170000 | 212500 | 255000 | 85000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 7 | 25000 - 100.00% | 3,592,000$ | 122,128,000$ | 25000 | 199 | 94,974,595$ | 94,974,598$ | 0$ | 79,268,359$ | 765,924$ | 76,485,205$ | 23 | 0 | 0$ | 25,144,000$ | 24 | 790,118$ | 18,962,832$ | 19,586,592$ | 94,867,381$ | 15,467,381$ | 107,500,000$ | 12,632,619$ | 422,397,856$ | 428,632,142$ |
| 18 | Oilers | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 127500 | 170000 | 212500 | 254651 | 85000 | 100.00% | 100.00% | 100.00% | 99.86% | 100.00% | 7 | 24990 - 99.96% | 3,775,146$ | 128,354,963$ | 25000 | 194 | 102,884,235$ | 98,634,235$ | 3,000,000$ | 87,600,800$ | 795,437$ | 82,655,257$ | 22 | 1 | 0$ | 26,426,022$ | 24 | 874,066$ | 20,977,584$ | 21,671,664$ | 104,745,745$ | 25,345,745$ | 107,500,000$ | 2,754,255$ | 359,254,388$ | 364,683,081$ |
| 19 | Pantheres | 3750 | 5000 | 6250 | 7500 | 2500 | 150 | 90 | 70 | 55 | 270 | 127500 | 170000 | 212500 | 255000 | 85000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 7 | 25000 - 100.00% | 3,248,000$ | 110,432,000$ | 25000 | 200 | 106,002,600$ | 106,002,599$ | 704,000$ | 90,274,278$ | 854,860$ | 85,274,278$ | 23 | 0 | 0$ | 22,736,000$ | 24 | 904,860$ | 21,716,640$ | 22,181,736$ | 106,494,918$ | 27,094,918$ | 107,500,000$ | 1,005,082$ | 225,821,251$ | 227,032,074$ |
| 20 | Pengouins | 3750 | 5000 | 6250 | 7500 | 2500 | 170 | 110 | 90 | 65 | 285 | 123750 | 165000 | 206250 | 247500 | 82500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 8 | 25000 - 100.00% | 3,776,000$ | 124,608,000$ | 25000 | 200 | 76,075,171$ | 76,075,171$ | 5,000,000$ | 66,737,524$ | 613,509$ | 62,662,895$ | 21 | 0 | 0$ | 30,208,000$ | 24 | 651,413$ | 15,633,912$ | 16,188,600$ | 82,387,111$ | 2,987,111$ | 107,500,000$ | 25,112,889$ | 613,921,806$ | 628,704,948$ |
| 21 | Predateurs | 3750 | 5000 | 6250 | 7500 | 2500 | 151 | 100 | 81 | 51 | 270 | 123750 | 165000 | 206250 | 247500 | 82500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 8 | 25000 - 100.00% | 3,366,400$ | 111,091,200$ | 25000 | 200 | 112,982,754$ | 112,982,752$ | 3,000,000$ | 87,316,437$ | 911,151$ | 82,497,674$ | 21 | 0 | 281,850$ | 26,931,200$ | 24 | 944,216$ | 22,661,184$ | 23,112,264$ | 107,365,298$ | 27,965,298$ | 107,500,000$ | 134,702$ | 315,127,237$ | 319,702,164$ |
| 22 | Rangers | 3750 | 5000 | 6250 | 7500 | 2500 | 100 | 65 | 45 | 18 | 195 | 127500 | 170000 | 212500 | 255000 | 85000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 7 | 25000 - 100.00% | 2,052,800$ | 69,795,200$ | 25000 | 200 | 97,605,885$ | 97,605,886$ | 0$ | 82,914,390$ | 787,144$ | 78,317,630$ | 21 | 0 | 0$ | 14,369,600$ | 24 | 830,289$ | 19,926,936$ | 20,714,328$ | 97,209,086$ | 17,809,086$ | 107,500,000$ | 10,290,914$ | 265,119,919$ | 259,441,282$ |
| 23 | Red Wings | 3188 | 4250 | 5312 | 6375 | 2125 | 170 | 110 | 80 | 56 | 280 | 107774 | 143975 | 180344 | 215487 | 72002 | 99.43% | 99.64% | 99.85% | 99.42% | 99.66% | 7 | 21164 - 99.60% | 3,041,746$ | 103,419,360$ | 21250 | 131 | 96,729,996$ | 96,729,995$ | 5,140,000$ | 85,979,254$ | 780,081$ | 81,145,329$ | 24 | 0 | 0$ | 21,292,221$ | 24 | 824,435$ | 19,786,440$ | 20,196,912$ | 105,007,273$ | 25,607,273$ | 107,500,000$ | 2,492,727$ | 227,119,881$ | 228,965,442$ |
| 24 | Senateurs | 3750 | 5000 | 6250 | 7500 | 2500 | 165 | 110 | 87 | 57 | 285 | 113931 | 145830 | 177141 | 221663 | 74647 | 89.36% | 85.78% | 83.36% | 86.93% | 87.82% | 7 | 21565 - 86.26% | 3,149,892$ | 107,096,337$ | 25000 | 126 | 93,437,512$ | 93,437,512$ | 0$ | 78,540,801$ | 753,528$ | 74,008,532$ | 22 | 0 | 0$ | 22,049,246$ | 24 | 797,883$ | 19,149,192$ | 19,714,560$ | 92,093,204$ | 12,693,204$ | 107,500,000$ | 15,406,796$ | 112,243,457$ | 115,244,606$ |
| 25 | Sharks | 3000 | 4000 | 5000 | 6000 | 2000 | 150 | 98 | 70 | 50 | 265 | 102000 | 136000 | 170000 | 204000 | 68000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 7 | 20000 - 100.00% | 2,588,160$ | 87,997,440$ | 20000 | 127 | 83,152,468$ | 83,152,469$ | 0$ | 70,266,598$ | 670,584$ | 65,931,918$ | 25 | 0 | 0$ | 18,117,120$ | 24 | 710,907$ | 17,061,768$ | 17,562,336$ | 82,025,934$ | 2,625,934$ | 107,500,000$ | 25,474,066$ | 169,776,701$ | 171,110,358$ |
| 26 | Stars | 3750 | 5000 | 6250 | 7500 | 2500 | 155 | 100 | 78 | 55 | 265 | 108954 | 143232 | 176469 | 205665 | 72798 | 85.45% | 84.25% | 83.04% | 80.65% | 85.64% | 7 | 20798 - 83.19% | 2,842,563$ | 96,647,152$ | 25000 | 114 | 98,607,108$ | 98,607,110$ | 1,500,000$ | 83,345,289$ | 795,219$ | 79,947,475$ | 22 | 0 | 0$ | 19,897,943$ | 24 | 827,477$ | 19,859,448$ | 20,362,128$ | 100,532,731$ | 21,132,731$ | 107,500,000$ | 6,967,269$ | 146,799,320$ | 147,019,871$ |
| 27 | Utah HC | 6500 | 5500 | 2500 | 4250 | 1250 | 105 | 31 | 30 | 28 | 205 | 136641 | 184165 | 85000 | 144500 | 42500 | 61.83% | 98.48% | 100.00% | 100.00% | 100.00% | 7 | 17435 - 87.18% | 1,331,385$ | 45,267,097$ | 20000 | 110 | 74,167,343$ | 74,167,343$ | 5,375,000$ | 61,791,222$ | 598,124$ | 60,077,517$ | 25 | 0 | 0$ | 9,319,696$ | 24 | 614,253$ | 14,742,072$ | 15,295,944$ | 79,807,493$ | 407,493$ | 107,500,000$ | 27,692,507$ | 6,835,581$ | 1,522,054$ |
| 28 | Wild | 3750 | 5000 | 6250 | 7500 | 2500 | 150 | 100 | 85 | 50 | 270 | 127500 | 170000 | 212500 | 255000 | 85000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 7 | 25000 - 100.00% | 3,384,000$ | 115,056,000$ | 25000 | 192 | 107,658,494$ | 107,658,494$ | 0$ | 88,247,991$ | 868,214$ | 86,154,281$ | 22 | 0 | 0$ | 23,688,000$ | 24 | 888,375$ | 21,321,000$ | 21,774,384$ | 106,991,417$ | 27,591,417$ | 107,500,000$ | 508,583$ | 276,526,955$ | 279,095,813$ |