| 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 | 86671 | 71281 | 28753 | 58945 | 14605 | 96.30% | 95.04% | 95.84% | 98.24% | 97.37% | 25 | 17350 - 96.39% | 1,494,712$ | 22,420,676$ | 18000 | 100 | 62,775,000$ | 60,375,000$ | 0$ | 22,465,080$ | 304,733$ | 21,940,776$ | 22 | 0 | 0$ | 37,367,793$ | 134 | 312,015$ | 41,810,010$ | 43,655,100$ | 62,774,998$ | 25,774,998$ | 114,116,230$ | 51,341,232$ | 45,116,230$ | 43,166,260$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 85717 | 71597 | 28726 | 57649 | 14464 | 95.24% | 95.46% | 95.75% | 96.08% | 96.43% | 25 | 17210 - 95.61% | 1,483,868$ | 22,258,018$ | 18000 | 100 | 67,250,000$ | 50,220,000$ | 0$ | 23,801,935$ | 326,456$ | 23,277,661$ | 21 | 0 | 262,174$ | 37,096,697$ | 134 | 333,738$ | 44,720,892$ | 46,365,262$ | 67,022,765$ | 30,022,765$ | 73,325,718$ | 6,302,953$ | 4,325,718$ | -542,279$ |
| 3 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 87300 | 72557 | 29277 | 58130 | 14520 | 97.00% | 96.74% | 97.59% | 96.88% | 96.80% | 25 | 17452 - 96.96% | 1,504,811$ | 22,572,164$ | 18000 | 100 | 62,365,000$ | 56,970,000$ | 0$ | 23,571,746$ | 302,743$ | 23,309,598$ | 21 | 1 | 339,960$ | 37,620,273$ | 134 | 306,383$ | 41,055,322$ | 42,652,372$ | 63,877,160$ | 26,877,160$ | 78,866,448$ | 14,989,288$ | 9,866,448$ | 9,427,438$ |
| 4 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 87590 | 72866 | 28407 | 58556 | 14458 | 97.32% | 97.15% | 94.69% | 97.59% | 96.39% | 25 | 17458 - 96.99% | 1,506,054$ | 22,590,807$ | 18000 | 100 | 68,350,000$ | 67,750,000$ | 0$ | 23,815,309$ | 331,796$ | 23,277,182$ | 22 | 0 | 4,120,789$ | 37,651,345$ | 134 | 335,437$ | 44,948,558$ | 46,171,338$ | 67,737,846$ | 30,737,846$ | 99,547,898$ | 31,810,052$ | 30,547,898$ | 26,532,700$ |
| 5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 81856 | 67949 | 26947 | 54141 | 13425 | 97.45% | 97.07% | 96.24% | 96.68% | 95.89% | 26 | 17451 - 96.95% | 1,505,608$ | 21,078,510$ | 18000 | 100 | 64,150,000$ | 50,000,000$ | 0$ | 22,923,781$ | 311,408$ | 22,035,447$ | 21 | 0 | 0$ | 39,145,804$ | 134 | 318,689$ | 42,704,326$ | 44,586,726$ | 63,764,119$ | 26,764,119$ | 76,545,872$ | 12,781,753$ | 7,545,872$ | 6,703,381$ |
| 6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 79704 | 69199 | 26947 | 53592 | 13484 | 94.89% | 98.86% | 96.24% | 95.70% | 96.31% | 26 | 17352 - 96.40% | 1,494,735$ | 20,926,284$ | 18000 | 100 | 69,250,000$ | 55,250,000$ | 0$ | 22,706,321$ | 302,184$ | 22,186,884$ | 21 | 1 | 3,455,953$ | 38,863,099$ | 134 | 341,019$ | 45,696,546$ | 47,389,146$ | 62,679,540$ | 25,679,540$ | 70,897,457$ | 8,217,917$ | 1,897,457$ | -1,991,978$ |
| 7 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 85293 | 71652 | 28881 | 58316 | 14447 | 94.77% | 95.54% | 96.27% | 97.19% | 96.31% | 25 | 17239 - 95.77% | 1,482,661$ | 22,239,919$ | 18000 | 100 | 68,650,000$ | 68,400,000$ | 0$ | 24,302,411$ | 333,252$ | 23,987,843$ | 20 | 0 | 23,427,528$ | 37,066,532$ | 134 | 337,621$ | 45,241,214$ | 46,972,424$ | 68,643,611$ | 31,643,611$ | 71,575,987$ | 2,932,376$ | 2,575,987$ | -2,926,050$ |
| 8 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 80070 | 66654 | 27174 | 54454 | 13700 | 95.32% | 95.22% | 97.05% | 97.24% | 97.86% | 26 | 17289 - 96.05% | 1,489,526$ | 20,853,363$ | 18000 | 100 | 66,200,000$ | 60,950,000$ | 0$ | 23,966,003$ | 321,359$ | 23,616,496$ | 21 | 0 | 1,203,278$ | 38,727,674$ | 134 | 326,214$ | 43,712,676$ | 45,157,496$ | 66,678,602$ | 29,678,602$ | 96,151,704$ | 29,473,102$ | 27,151,704$ | 25,367,447$ |
| 9 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 85462 | 72877 | 28245 | 56983 | 14262 | 94.96% | 97.17% | 94.15% | 94.97% | 95.08% | 25 | 17189 - 95.49% | 1,482,678$ | 22,240,170$ | 18000 | 100 | 67,750,000$ | 55,675,000$ | 0$ | 24,196,616$ | 328,883$ | 23,497,568$ | 23 | 0 | 0$ | 37,066,950$ | 134 | 338,592$ | 45,371,328$ | 47,379,308$ | 67,567,890$ | 30,567,890$ | 90,784,036$ | 23,216,146$ | 21,784,036$ | 15,992,872$ |
| 10 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 85785 | 73055 | 29388 | 57713 | 14313 | 95.32% | 97.41% | 97.96% | 96.19% | 95.42% | 25 | 17350 - 96.39% | 1,492,076$ | 22,381,137$ | 18000 | 100 | 68,295,000$ | 57,795,000$ | 0$ | 24,496,343$ | 331,529$ | 23,690,496$ | 22 | 0 | 10,272,491$ | 37,301,895$ | 134 | 341,238$ | 45,725,892$ | 47,704,882$ | 68,115,382$ | 31,115,382$ | 99,995,016$ | 31,879,634$ | 30,995,016$ | 25,182,190$ |
| 11 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 86706 | 72206 | 29131 | 58868 | 14447 | 96.34% | 96.27% | 97.10% | 98.11% | 96.31% | 25 | 17424 - 96.80% | 1,498,504$ | 22,477,553$ | 18000 | 100 | 64,700,000$ | 59,700,000$ | 0$ | 23,715,055$ | 314,078$ | 22,841,263$ | 20 | 0 | 0$ | 37,462,588$ | 134 | 326,214$ | 43,712,676$ | 45,540,346$ | 64,927,715$ | 27,927,715$ | 84,249,194$ | 19,321,479$ | 15,249,194$ | 11,668,251$ |
| 12 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 81142 | 67462 | 27226 | 53702 | 13612 | 96.60% | 96.37% | 97.24% | 95.90% | 97.23% | 26 | 17367 - 96.49% | 1,499,850$ | 20,997,893$ | 18000 | 100 | 64,800,000$ | 60,650,000$ | 0$ | 22,595,134$ | 304,854$ | 21,857,283$ | 21 | 1 | 0$ | 38,996,087$ | 134 | 324,272$ | 43,452,448$ | 45,161,168$ | 62,707,719$ | 25,707,719$ | 90,216,788$ | 27,509,069$ | 21,216,788$ | 19,577,677$ |
| 13 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 87122 | 71862 | 28628 | 57512 | 14211 | 96.80% | 95.82% | 95.43% | 95.85% | 94.74% | 25 | 17289 - 96.05% | 1,491,567$ | 22,373,504$ | 18000 | 100 | 68,050,000$ | 59,925,000$ | 0$ | 24,568,207$ | 330,340$ | 23,781,796$ | 20 | 0 | 18,867,719$ | 37,289,173$ | 134 | 341,262$ | 45,729,108$ | 47,722,528$ | 68,047,356$ | 31,047,356$ | 77,261,734$ | 9,214,378$ | 8,261,734$ | 2,353,079$ |
| 14 | Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 87642 | 72488 | 28966 | 58539 | 14315 | 97.38% | 96.65% | 96.55% | 97.57% | 95.43% | 25 | 17463 - 97.02% | 1,503,906$ | 22,558,595$ | 18000 | 100 | 68,800,000$ | 65,400,000$ | 0$ | 24,444,430$ | 333,981$ | 24,164,794$ | 21 | 0 | 41,465,529$ | 37,597,658$ | 134 | 337,864$ | 45,273,776$ | 46,844,046$ | 68,918,248$ | 31,918,248$ | 70,387,128$ | 1,468,880$ | 1,387,128$ | -3,548,447$ |
| 15 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 81232 | 68691 | 27526 | 53785 | 13484 | 96.70% | 98.13% | 98.31% | 96.04% | 96.31% | 26 | 17480 - 97.11% | 1,506,743$ | 21,094,404$ | 18000 | 100 | 67,250,000$ | 54,995,000$ | 0$ | 23,629,509$ | 326,456$ | 22,930,462$ | 23 | 0 | 191,681$ | 39,175,322$ | 134 | 336,165$ | 45,046,110$ | 46,532,790$ | 66,675,566$ | 29,675,566$ | 82,550,980$ | 15,875,414$ | 13,550,980$ | 10,752,280$ |
| 16 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 81505 | 67811 | 27125 | 54293 | 13405 | 97.03% | 96.87% | 96.88% | 96.95% | 95.75% | 26 | 17439 - 96.88% | 1,502,562$ | 21,035,869$ | 18000 | 100 | 66,050,000$ | 55,650,000$ | 0$ | 23,241,764$ | 320,631$ | 22,746,854$ | 21 | 0 | 0$ | 39,066,614$ | 134 | 323,864$ | 43,397,776$ | 45,005,096$ | 65,711,408$ | 28,711,408$ | 107,500,747$ | 41,789,339$ | 38,500,747$ | 37,094,028$ |
| 17 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 86463 | 73701 | 29115 | 58066 | 14751 | 96.07% | 98.27% | 97.05% | 96.78% | 98.34% | 25 | 17473 - 97.07% | 1,507,431$ | 22,611,471$ | 18000 | 100 | 68,525,000$ | 51,471,000$ | 0$ | 24,230,088$ | 332,646$ | 23,950,512$ | 22 | 0 | 19,049,328$ | 37,685,785$ | 134 | 336,529$ | 45,094,886$ | 46,925,806$ | 68,525,076$ | 31,525,076$ | 70,136,233$ | 1,611,157$ | 1,136,233$ | -3,454,518$ |
| 18 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 87074 | 71580 | 29312 | 56972 | 14469 | 96.75% | 95.44% | 97.71% | 94.95% | 96.46% | 25 | 17294 - 96.08% | 1,494,497$ | 22,417,457$ | 18000 | 100 | 63,525,000$ | 54,750,000$ | 0$ | 24,459,709$ | 308,374$ | 23,165,417$ | 21 | 0 | 776,726$ | 37,362,428$ | 134 | 325,364$ | 43,598,776$ | 45,152,926$ | 64,487,533$ | 27,487,533$ | 81,577,656$ | 17,090,123$ | 12,577,656$ | 9,260,829$ |
| 19 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 87777 | 71703 | 28828 | 58934 | 14380 | 97.53% | 95.60% | 96.09% | 98.22% | 95.87% | 25 | 17441 - 96.90% | 1,502,211$ | 22,533,160$ | 18000 | 100 | 62,300,000$ | 50,895,000$ | 0$ | 21,447,092$ | 283,010$ | 20,835,450$ | 20 | 1 | 0$ | 37,555,267$ | 134 | 307,282$ | 41,175,788$ | 42,659,218$ | 58,758,790$ | 21,758,790$ | 102,253,813$ | 43,495,023$ | 33,253,813$ | 32,609,214$ |
| 20 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 88009 | 72200 | 29323 | 58145 | 14682 | 97.79% | 96.27% | 97.74% | 96.91% | 97.88% | 25 | 17491 - 97.17% | 1,510,990$ | 22,664,856$ | 18000 | 100 | 69,675,000$ | 69,150,000$ | 0$ | 24,137,140$ | 329,490$ | 23,682,757$ | 21 | 1 | 3,579,643$ | 37,774,760$ | 134 | 344,053$ | 46,103,102$ | 48,284,762$ | 67,834,417$ | 30,834,417$ | 71,728,386$ | 3,893,969$ | 2,728,386$ | -3,267,897$ |
| 21 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 84112 | 72138 | 28017 | 57343 | 14358 | 93.46% | 96.18% | 93.39% | 95.57% | 95.72% | 25 | 17065 - 94.80% | 1,469,963$ | 22,049,444$ | 18000 | 100 | 57,500,000$ | 50,775,000$ | 0$ | 20,378,669$ | 269,417$ | 20,009,691$ | 22 | 1 | 0$ | 36,749,073$ | 134 | 283,981$ | 38,053,454$ | 39,636,594$ | 56,111,569$ | 19,111,569$ | 130,109,899$ | 73,998,330$ | 61,109,899$ | 62,730,934$ |
| 22 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 79988 | 68448 | 27137 | 53493 | 13480 | 95.22% | 97.78% | 96.92% | 95.52% | 96.29% | 26 | 17325 - 96.25% | 1,493,064$ | 20,902,894$ | 18000 | 100 | 66,025,000$ | 59,325,000$ | 0$ | 23,775,696$ | 320,510$ | 23,076,720$ | 22 | 0 | 0$ | 38,819,660$ | 134 | 330,218$ | 44,249,212$ | 46,664,092$ | 66,025,060$ | 29,025,060$ | 83,750,415$ | 17,725,355$ | 14,750,415$ | 11,288,823$ |
| 23 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 85909 | 71997 | 28703 | 57380 | 14536 | 95.45% | 96.00% | 95.68% | 95.63% | 96.91% | 25 | 17235 - 95.75% | 1,487,901$ | 22,318,521$ | 18000 | 100 | 67,900,000$ | 54,650,000$ | 0$ | 23,791,727$ | 329,612$ | 23,485,933$ | 22 | 0 | 276,672$ | 37,197,535$ | 134 | 333,859$ | 44,737,106$ | 46,333,116$ | 67,653,941$ | 30,653,941$ | 86,147,030$ | 18,493,089$ | 17,147,030$ | 12,413,084$ |
| 24 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 87920 | 73332 | 28967 | 58113 | 14471 | 97.69% | 97.78% | 96.56% | 96.86% | 96.47% | 25 | 17520 - 97.33% | 1,511,982$ | 22,679,735$ | 18000 | 100 | 55,175,000$ | 52,325,000$ | 0$ | 20,117,363$ | 267,840$ | 19,593,081$ | 22 | 1 | 0$ | 37,799,558$ | 134 | 275,121$ | 36,866,214$ | 38,689,074$ | 55,483,641$ | 18,483,641$ | 75,024,857$ | 19,541,216$ | 6,024,857$ | 9,597,456$ |
| 25 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 86025 | 71830 | 29372 | 58398 | 14768 | 95.58% | 95.77% | 97.91% | 97.33% | 98.45% | 25 | 17360 - 96.44% | 1,495,845$ | 22,437,673$ | 18000 | 100 | 66,638,888$ | 45,883,888$ | 0$ | 23,545,420$ | 323,490$ | 23,087,188$ | 22 | 0 | 0$ | 37,396,122$ | 134 | 328,101$ | 43,965,534$ | 45,631,094$ | 66,434,848$ | 29,434,848$ | 75,370,117$ | 8,935,269$ | 6,370,117$ | 2,754,656$ |
| 26 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 85215 | 72488 | 28633 | 57907 | 14386 | 94.68% | 96.65% | 95.44% | 96.51% | 95.91% | 25 | 17242 - 95.79% | 1,483,913$ | 22,258,697$ | 18000 | 100 | 64,150,000$ | 58,695,000$ | 0$ | 23,031,085$ | 311,408$ | 22,128,169$ | 21 | 0 | 0$ | 37,097,828$ | 134 | 317,476$ | 42,541,784$ | 44,298,734$ | 63,856,841$ | 26,856,841$ | 80,912,840$ | 17,055,999$ | 11,912,840$ | 9,223,552$ |
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