| 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 37,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 75206 | 61641 | 24937 | 51384 | 12757 | 96.42% | 94.83% | 95.91% | 98.82% | 98.13% | 27 | 17379 - 96.55% | 1,497,288$ | 19,464,750$ | 18000 | 100 | 62,775,000$ | 60,375,000$ | 0$ | 18,720,900$ | 304,733$ | 18,283,980$ | 22 | 0 | 0$ | 40,426,788$ | 146 | 312,015$ | 45,554,190$ | 47,569,596$ | 62,774,998$ | 25,774,998$ | 114,563,986$ | 51,788,988$ | 45,563,986$ | 43,301,550$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 68660 | 57237 | 22906 | 45649 | 11464 | 95.36% | 95.40% | 95.44% | 95.10% | 95.53% | 28 | 17160 - 95.33% | 1,480,730$ | 17,768,763$ | 18000 | 100 | 67,250,000$ | 50,220,000$ | 0$ | 19,797,079$ | 326,456$ | 19,360,189$ | 21 | 0 | 262,174$ | 41,460,447$ | 146 | 333,738$ | 48,725,748$ | 50,521,906$ | 67,022,765$ | 30,022,765$ | 72,465,629$ | 5,442,864$ | 3,465,629$ | -665,816$ |
| 3 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 75300 | 62888 | 25277 | 50402 | 12624 | 96.54% | 96.75% | 97.22% | 96.93% | 97.11% | 27 | 17422 - 96.79% | 1,502,086$ | 19,527,114$ | 18000 | 100 | 66,865,000$ | 61,470,000$ | 0$ | 19,805,340$ | 324,587$ | 19,586,880$ | 22 | 0 | 339,960$ | 40,556,314$ | 146 | 328,228$ | 47,921,288$ | 49,600,722$ | 66,976,582$ | 29,976,582$ | 79,196,086$ | 12,219,504$ | 10,196,086$ | 6,255,404$ |
| 4 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 75590 | 63322 | 24676 | 50892 | 12560 | 96.91% | 97.42% | 94.91% | 97.87% | 96.62% | 27 | 17465 - 97.03% | 1,505,380$ | 19,569,941$ | 18000 | 100 | 68,350,000$ | 67,750,000$ | 0$ | 19,790,065$ | 325,971$ | 19,313,105$ | 21 | 1 | 1,965,805$ | 40,645,262$ | 146 | 335,437$ | 48,973,802$ | 50,309,454$ | 66,904,871$ | 29,904,871$ | 102,305,822$ | 35,400,951$ | 33,305,822$ | 28,748,286$ |
| 5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 69856 | 58162 | 23041 | 46293 | 11463 | 97.02% | 96.94% | 96.00% | 96.44% | 95.53% | 28 | 17401 - 96.67% | 1,500,747$ | 18,008,964$ | 18000 | 100 | 66,875,000$ | 54,225,000$ | 0$ | 19,082,517$ | 324,636$ | 18,281,562$ | 22 | 0 | 0$ | 42,020,916$ | 146 | 331,917$ | 48,459,882$ | 50,433,540$ | 65,678,418$ | 28,678,418$ | 76,947,205$ | 11,268,787$ | 7,947,205$ | 4,631,966$ |
| 6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 68395 | 59199 | 23041 | 46111 | 11617 | 94.99% | 98.67% | 96.00% | 96.06% | 96.81% | 28 | 17364 - 96.46% | 1,496,131$ | 17,953,569$ | 18000 | 100 | 62,250,000$ | 48,250,000$ | 0$ | 18,851,953$ | 302,184$ | 18,560,676$ | 21 | 1 | 373,763$ | 41,891,661$ | 146 | 307,039$ | 44,827,694$ | 46,725,666$ | 62,679,540$ | 25,679,540$ | 74,681,917$ | 12,002,377$ | 5,681,917$ | 5,887,856$ |
| 7 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 73791 | 62445 | 25262 | 50996 | 12479 | 94.60% | 96.07% | 97.16% | 98.07% | 95.99% | 27 | 17306 - 96.14% | 1,484,952$ | 19,304,372$ | 18000 | 100 | 68,650,000$ | 68,400,000$ | 0$ | 20,250,959$ | 333,252$ | 19,988,819$ | 20 | 0 | 19,525,524$ | 40,093,696$ | 146 | 337,621$ | 49,292,666$ | 51,183,680$ | 68,643,611$ | 31,643,611$ | 76,227,020$ | 7,583,409$ | 7,227,020$ | 1,073,513$ |
| 8 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 68571 | 56806 | 23225 | 46454 | 11700 | 95.24% | 94.68% | 96.77% | 96.78% | 97.50% | 28 | 17230 - 95.72% | 1,485,047$ | 17,820,560$ | 18000 | 100 | 66,200,000$ | 60,950,000$ | 0$ | 20,051,435$ | 321,359$ | 19,760,188$ | 21 | 0 | 1,203,278$ | 41,581,307$ | 146 | 326,214$ | 47,627,244$ | 49,170,216$ | 66,678,602$ | 29,678,602$ | 96,629,320$ | 29,950,718$ | 27,629,320$ | 25,226,824$ |
| 9 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 69326 | 58008 | 22649 | 45673 | 11544 | 96.29% | 96.68% | 94.37% | 95.15% | 96.20% | 28 | 17267 - 95.93% | 1,492,902$ | 17,914,824$ | 18000 | 100 | 67,750,000$ | 55,675,000$ | 0$ | 20,133,512$ | 328,883$ | 19,550,972$ | 23 | 0 | 0$ | 41,801,256$ | 146 | 338,592$ | 49,434,432$ | 51,662,838$ | 67,567,890$ | 30,567,890$ | 90,172,712$ | 22,604,822$ | 21,172,712$ | 16,318,412$ |
| 10 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 74256 | 63614 | 25388 | 50450 | 12394 | 95.20% | 97.87% | 97.65% | 97.02% | 95.34% | 27 | 17392 - 96.62% | 1,493,797$ | 19,419,358$ | 18000 | 100 | 68,295,000$ | 57,795,000$ | 0$ | 20,401,487$ | 321,820$ | 19,799,529$ | 21 | 1 | 8,437,871$ | 40,332,513$ | 146 | 341,238$ | 49,820,748$ | 51,982,414$ | 66,785,249$ | 29,785,249$ | 102,786,815$ | 36,001,566$ | 33,786,815$ | 27,067,366$ |
| 11 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 74706 | 62329 | 25218 | 51219 | 12544 | 95.78% | 95.89% | 96.99% | 98.50% | 96.49% | 27 | 17386 - 96.59% | 1,493,914$ | 19,420,877$ | 18000 | 100 | 64,700,000$ | 59,700,000$ | 0$ | 19,800,487$ | 314,078$ | 19,072,327$ | 20 | 0 | 0$ | 40,335,668$ | 146 | 326,214$ | 47,627,244$ | 49,560,432$ | 64,927,715$ | 27,927,715$ | 84,728,009$ | 19,800,294$ | 15,728,009$ | 11,528,928$ |
| 12 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 69673 | 57992 | 23259 | 45997 | 11648 | 96.77% | 96.65% | 96.91% | 95.83% | 97.07% | 28 | 17381 - 96.56% | 1,501,383$ | 18,016,599$ | 18000 | 100 | 64,800,000$ | 60,650,000$ | 0$ | 18,713,579$ | 314,563$ | 18,131,072$ | 22 | 0 | 0$ | 42,038,731$ | 146 | 324,272$ | 47,343,712$ | 49,210,160$ | 64,057,270$ | 27,057,270$ | 90,761,746$ | 26,704,476$ | 21,761,746$ | 19,662,760$ |
| 13 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 75141 | 62173 | 24855 | 49781 | 12353 | 96.33% | 95.65% | 95.60% | 95.73% | 95.02% | 27 | 17254 - 95.86% | 1,488,316$ | 19,348,107$ | 18000 | 100 | 68,050,000$ | 59,925,000$ | 0$ | 20,473,063$ | 330,340$ | 19,817,716$ | 20 | 0 | 18,459,755$ | 40,184,530$ | 146 | 341,262$ | 49,824,252$ | 52,033,346$ | 68,047,356$ | 31,047,356$ | 78,603,678$ | 10,556,322$ | 9,603,678$ | 2,690,998$ |
| 14 | Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 70484 | 58003 | 23305 | 46766 | 11599 | 97.89% | 96.67% | 97.10% | 97.43% | 96.66% | 28 | 17513 - 97.29% | 1,510,677$ | 18,128,129$ | 18000 | 100 | 68,300,000$ | 63,400,000$ | 0$ | 20,407,051$ | 331,553$ | 20,174,018$ | 21 | 0 | 38,388,241$ | 42,298,968$ | 146 | 335,437$ | 48,973,802$ | 50,843,658$ | 68,580,756$ | 31,580,756$ | 72,707,487$ | 4,126,731$ | 3,707,487$ | -13,958$ |
| 15 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 75938 | 63691 | 25584 | 49785 | 12484 | 97.36% | 97.99% | 98.40% | 95.74% | 96.03% | 27 | 17499 - 97.21% | 1,509,674$ | 19,625,762$ | 18000 | 100 | 67,250,000$ | 54,995,000$ | 0$ | 19,595,529$ | 326,456$ | 19,012,990$ | 23 | 0 | 191,681$ | 40,761,198$ | 146 | 336,165$ | 49,080,090$ | 50,704,002$ | 66,675,566$ | 29,675,566$ | 84,894,524$ | 18,218,958$ | 15,894,524$ | 10,841,675$ |
| 16 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 75593 | 62811 | 25232 | 50346 | 12405 | 96.91% | 96.63% | 97.05% | 96.82% | 95.42% | 27 | 17414 - 96.75% | 1,500,018$ | 19,500,239$ | 18000 | 100 | 65,150,000$ | 54,750,000$ | 0$ | 19,393,260$ | 316,262$ | 19,199,280$ | 20 | 0 | 0$ | 40,500,496$ | 146 | 319,495$ | 46,646,270$ | 48,465,148$ | 65,373,532$ | 28,373,532$ | 109,608,323$ | 44,234,791$ | 40,608,323$ | 37,511,284$ |
| 17 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 68591 | 58702 | 23254 | 46185 | 11803 | 95.27% | 97.84% | 96.89% | 96.22% | 98.36% | 28 | 17378 - 96.54% | 1,499,269$ | 17,991,231$ | 18000 | 100 | 68,525,000$ | 51,471,000$ | 0$ | 20,191,740$ | 332,646$ | 19,958,760$ | 22 | 0 | 15,874,440$ | 41,979,539$ | 146 | 336,529$ | 49,133,234$ | 51,133,162$ | 68,525,076$ | 31,525,076$ | 72,536,659$ | 4,011,583$ | 3,536,659$ | -619,256$ |
| 18 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 75553 | 61825 | 25389 | 49467 | 12522 | 96.86% | 95.12% | 97.65% | 95.13% | 96.32% | 27 | 17289 - 96.05% | 1,493,852$ | 19,420,074$ | 18000 | 100 | 63,525,000$ | 54,750,000$ | 0$ | 20,555,341$ | 308,374$ | 19,464,929$ | 21 | 0 | 776,726$ | 40,334,000$ | 146 | 325,364$ | 47,503,144$ | 49,190,246$ | 64,487,533$ | 27,487,533$ | 82,297,873$ | 17,810,340$ | 13,297,873$ | 9,292,898$ |
| 19 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 76286 | 62015 | 24828 | 51217 | 12413 | 97.80% | 95.41% | 95.49% | 98.49% | 95.48% | 27 | 17443 - 96.91% | 1,502,243$ | 19,529,164$ | 18000 | 100 | 62,300,000$ | 50,895,000$ | 0$ | 17,817,962$ | 302,427$ | 17,439,330$ | 21 | 0 | 0$ | 40,560,571$ | 146 | 307,282$ | 44,863,172$ | 46,483,534$ | 61,593,672$ | 24,593,672$ | 102,480,348$ | 40,886,676$ | 33,480,348$ | 32,550,905$ |
| 20 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 70663 | 57556 | 23425 | 46166 | 11722 | 98.14% | 95.93% | 97.60% | 96.18% | 97.68% | 28 | 17461 - 97.01% | 1,510,487$ | 18,125,840$ | 18000 | 100 | 66,825,000$ | 66,300,000$ | 0$ | 20,075,002$ | 324,393$ | 19,725,479$ | 21 | 1 | 0$ | 42,293,627$ | 146 | 330,218$ | 48,211,828$ | 50,500,016$ | 67,086,857$ | 30,086,857$ | 74,685,365$ | 7,598,508$ | 5,685,365$ | 2,347,562$ |
| 21 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 67706 | 58098 | 22537 | 46007 | 11507 | 94.04% | 96.83% | 93.90% | 95.85% | 95.89% | 28 | 17155 - 95.30% | 1,477,803$ | 17,733,633$ | 18000 | 100 | 57,500,000$ | 50,775,000$ | 0$ | 17,038,860$ | 279,126$ | 16,747,560$ | 23 | 0 | 0$ | 41,378,477$ | 146 | 283,981$ | 41,461,226$ | 43,225,718$ | 57,499,956$ | 20,499,956$ | 128,738,470$ | 71,238,514$ | 59,738,470$ | 62,861,115$ |
| 22 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 68390 | 58723 | 23201 | 45942 | 11480 | 94.99% | 97.87% | 96.67% | 95.71% | 95.67% | 28 | 17311 - 96.17% | 1,490,391$ | 17,884,696$ | 18000 | 100 | 66,025,000$ | 59,325,000$ | 0$ | 19,813,080$ | 320,510$ | 19,230,600$ | 22 | 0 | 0$ | 41,730,957$ | 146 | 330,218$ | 48,211,828$ | 50,849,620$ | 66,025,060$ | 29,025,060$ | 84,393,091$ | 18,368,031$ | 15,393,091$ | 11,186,211$ |
| 23 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 74534 | 62955 | 25020 | 49595 | 12549 | 95.56% | 96.85% | 96.23% | 95.38% | 96.53% | 27 | 17281 - 96.01% | 1,491,347$ | 19,387,505$ | 18000 | 100 | 67,900,000$ | 54,650,000$ | 0$ | 19,785,419$ | 329,612$ | 19,530,589$ | 22 | 0 | 276,672$ | 40,266,357$ | 146 | 333,859$ | 48,743,414$ | 50,486,748$ | 67,653,941$ | 30,653,941$ | 86,847,648$ | 19,193,707$ | 17,847,648$ | 12,571,551$ |
| 24 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 76458 | 63711 | 24967 | 50863 | 12597 | 98.02% | 98.02% | 96.03% | 97.81% | 96.90% | 27 | 17584 - 97.69% | 1,517,075$ | 19,721,969$ | 18000 | 100 | 56,175,000$ | 52,225,000$ | 0$ | 16,757,653$ | 272,694$ | 16,320,751$ | 23 | 0 | 0$ | 40,961,013$ | 146 | 279,976$ | 40,876,496$ | 42,881,678$ | 56,134,075$ | 19,134,075$ | 75,061,400$ | 18,927,325$ | 6,061,400$ | 9,144,321$ |
| 25 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 74025 | 62375 | 25372 | 50999 | 12830 | 94.90% | 95.96% | 97.58% | 98.08% | 98.69% | 27 | 17354 - 96.41% | 1,493,195$ | 19,411,539$ | 18000 | 100 | 66,638,888$ | 45,883,888$ | 0$ | 19,608,208$ | 313,781$ | 19,282,980$ | 21 | 1 | 0$ | 40,316,273$ | 146 | 328,101$ | 47,902,746$ | 49,722,050$ | 65,095,006$ | 28,095,006$ | 75,897,444$ | 10,802,438$ | 6,897,444$ | 2,632,402$ |
| 26 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 74248 | 62997 | 24884 | 49995 | 12397 | 95.19% | 96.92% | 95.71% | 96.14% | 95.36% | 27 | 17271 - 95.95% | 1,486,968$ | 19,330,579$ | 18000 | 100 | 65,125,000$ | 59,670,000$ | 0$ | 19,183,509$ | 316,141$ | 18,353,409$ | 22 | 0 | 0$ | 40,148,126$ | 146 | 322,209$ | 47,042,514$ | 48,893,058$ | 64,509,995$ | 27,509,995$ | 81,629,204$ | 17,119,209$ | 12,629,204$ | 8,709,426$ |
Admirals
Americans
Barracuda
Condors
Griffins
Gulls
Icehogs
Marlies
Moose
Phantoms
Rockets
Senators
Wranglers
Bears
Canucks
Checkers
Comets
Crunch
Eagles
Firebirds
Islander
Little Stars
Penguins
Punishers
Thunderbirds
Wolfpack