| 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 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 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 | 232274 | 191012 | 76985 | 155336 | 38656 | 96.78% | 95.51% | 96.23% | 97.09% | 96.64% | 0 | 17357 - 96.43% | 1,496,981$ | 59,879,256$ | 18000 | 100 | 59,500,000$ | 59,500,000$ | 0$ | 63,036,742$ | 288,835$ | 61,543,932$ | 23 | 0 | 0$ | 0$ | 1 | 296,117$ | 296,117$ | 296,117$ | 61,832,767$ | 24,832,767$ | 113,612,635$ | 51,779,868$ | 44,612,635$ | 44,316,518$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 230650 | 192249 | 76651 | 153932 | 38509 | 96.10% | 96.12% | 95.81% | 96.21% | 96.27% | 0 | 17300 - 96.11% | 1,492,362$ | 59,694,462$ | 18000 | 100 | 68,000,000$ | 68,000,000$ | 0$ | 68,692,480$ | 330,097$ | 67,199,756$ | 20 | 0 | 8,432,462$ | 0$ | 1 | 337,379$ | 337,379$ | 337,379$ | 67,529,853$ | 30,529,853$ | 72,469,710$ | 4,939,857$ | 3,469,710$ | 3,132,331$ |
| 3 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 234599 | 193736 | 78333 | 155615 | 38871 | 97.75% | 96.87% | 97.92% | 97.26% | 97.18% | 0 | 17529 - 97.38% | 1,512,175$ | 60,486,998$ | 18000 | 100 | 65,315,000$ | 65,315,000$ | 0$ | 66,214,440$ | 317,063$ | 65,468,054$ | 21 | 1 | 339,960$ | 0$ | 1 | 320,704$ | 320,704$ | 320,704$ | 65,785,117$ | 28,785,117$ | 77,082,059$ | 11,296,942$ | 8,082,059$ | 7,761,355$ |
| 4 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 229496 | 191566 | 75746 | 153279 | 38539 | 95.62% | 95.78% | 94.68% | 95.80% | 96.35% | 0 | 17216 - 95.64% | 1,486,238$ | 59,449,513$ | 18000 | 100 | 68,450,000$ | 68,450,000$ | 0$ | 68,439,335$ | 332,282$ | 67,307,769$ | 21 | 0 | 35,602,837$ | 0$ | 1 | 335,922$ | 335,922$ | 335,922$ | 67,640,051$ | 30,640,051$ | 69,435,517$ | 1,795,466$ | 435,517$ | 99,595$ |
| 5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 229420 | 193847 | 77150 | 152567 | 38635 | 95.59% | 96.92% | 96.44% | 95.35% | 96.59% | 0 | 17290 - 96.06% | 1,492,162$ | 59,686,492$ | 18000 | 100 | 65,625,000$ | 65,625,000$ | 0$ | 65,492,817$ | 318,568$ | 63,490,427$ | 24 | 0 | 0$ | 0$ | 1 | 325,850$ | 325,850$ | 325,850$ | 63,808,995$ | 26,808,995$ | 79,096,500$ | 15,287,505$ | 10,096,500$ | 9,770,650$ |
| 6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 228842 | 193798 | 76641 | 153487 | 38507 | 95.35% | 96.90% | 95.80% | 95.93% | 96.27% | 0 | 17282 - 96.01% | 1,489,874$ | 59,594,966$ | 18000 | 100 | 65,700,000$ | 65,700,000$ | 0$ | 66,271,354$ | 318,932$ | 64,429,108$ | 20 | 0 | 40,955,311$ | 0$ | 1 | 323,786$ | 323,786$ | 323,786$ | 64,748,040$ | 27,748,040$ | 73,158,544$ | 8,410,504$ | 4,158,544$ | 3,834,758$ |
| 7 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 217512 | 191485 | 76881 | 155219 | 38939 | 90.63% | 95.74% | 96.10% | 97.01% | 97.35% | 0 | 17001 - 94.45% | 1,456,899$ | 58,275,975$ | 18000 | 100 | 68,650,000$ | 68,650,000$ | 0$ | 69,189,987$ | 333,252$ | 68,294,342$ | 20 | 0 | 68,466,164$ | 0$ | 1 | 337,621$ | 337,621$ | 337,621$ | 68,627,594$ | 31,627,594$ | 68,359,676$ | -267,918$ | -640,324$ | -977,945$ |
| 8 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 230566 | 191026 | 76174 | 155881 | 38843 | 96.07% | 95.51% | 95.22% | 97.43% | 97.11% | 0 | 17312 - 96.18% | 1,492,712$ | 59,708,473$ | 18000 | 100 | 67,900,000$ | 67,900,000$ | 0$ | 67,447,578$ | 329,612$ | 66,146,601$ | 22 | 0 | 1,407,158$ | 0$ | 1 | 334,466$ | 334,466$ | 334,466$ | 66,476,213$ | 29,476,213$ | 90,589,183$ | 24,112,970$ | 21,589,183$ | 21,254,717$ |
| 9 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 227859 | 191044 | 75799 | 150251 | 38078 | 94.94% | 95.52% | 94.75% | 93.91% | 95.20% | 0 | 17076 - 94.87% | 1,475,279$ | 59,011,177$ | 18000 | 100 | 65,950,000$ | 65,950,000$ | 0$ | 67,336,090$ | 305,583$ | 65,229,294$ | 23 | 1 | 5,615,740$ | 0$ | 1 | 329,854$ | 329,854$ | 329,854$ | 65,534,877$ | 28,534,877$ | 79,821,559$ | 14,286,682$ | 10,821,559$ | 10,491,705$ |
| 10 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 230170 | 194926 | 78099 | 153035 | 38658 | 95.90% | 97.46% | 97.62% | 95.65% | 96.65% | 0 | 17372 - 96.51% | 1,498,117$ | 59,924,695$ | 18000 | 100 | 68,295,000$ | 68,295,000$ | 0$ | 69,565,461$ | 331,529$ | 67,104,237$ | 22 | 0 | 28,618,691$ | 0$ | 1 | 341,238$ | 341,238$ | 341,238$ | 67,435,766$ | 30,435,766$ | 76,791,895$ | 9,356,129$ | 7,791,895$ | 7,450,657$ |
| 11 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 232550 | 193881 | 78178 | 154147 | 38803 | 96.90% | 96.94% | 97.72% | 96.34% | 97.01% | 0 | 17439 - 96.88% | 1,504,741$ | 60,189,620$ | 18000 | 100 | 68,750,000$ | 68,750,000$ | 0$ | 69,008,037$ | 333,738$ | 66,520,157$ | 20 | 0 | 24,944,929$ | 0$ | 1 | 345,874$ | 345,874$ | 345,874$ | 66,853,895$ | 29,853,895$ | 70,365,242$ | 3,511,347$ | 1,365,242$ | 1,019,368$ |
| 12 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 231525 | 193517 | 77515 | 154235 | 38744 | 96.47% | 96.76% | 96.89% | 96.40% | 96.86% | 0 | 17388 - 96.60% | 1,500,035$ | 60,001,409$ | 18000 | 100 | 66,975,000$ | 66,975,000$ | 0$ | 66,592,590$ | 310,558$ | 64,369,267$ | 22 | 1 | 0$ | 0$ | 1 | 334,830$ | 334,830$ | 334,830$ | 64,679,825$ | 27,679,825$ | 88,114,290$ | 23,434,465$ | 19,114,290$ | 18,779,460$ |
| 13 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 232386 | 191946 | 76916 | 153504 | 38536 | 96.83% | 95.97% | 96.15% | 95.94% | 96.34% | 0 | 17332 - 96.29% | 1,496,834$ | 59,873,349$ | 18000 | 100 | 65,225,000$ | 65,225,000$ | 0$ | 68,779,623$ | 316,626$ | 66,540,535$ | 21 | 0 | 24,498,159$ | 0$ | 1 | 327,549$ | 327,549$ | 327,549$ | 66,857,161$ | 29,857,161$ | 73,361,953$ | 6,504,792$ | 4,361,953$ | 4,034,404$ |
| 14 | Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 229524 | 192506 | 76407 | 153711 | 37765 | 95.64% | 96.25% | 95.51% | 96.07% | 94.41% | 0 | 17248 - 95.82% | 1,484,892$ | 59,395,693$ | 18000 | 100 | 65,800,000$ | 65,800,000$ | 0$ | 68,293,711$ | 319,417$ | 67,424,713$ | 21 | 0 | 51,737,202$ | 0$ | 1 | 323,301$ | 323,301$ | 323,301$ | 67,744,130$ | 30,744,130$ | 73,728,619$ | 5,984,489$ | 4,728,619$ | 4,405,318$ |
| 15 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 229158 | 192003 | 77042 | 153441 | 38514 | 95.48% | 96.00% | 96.30% | 95.90% | 96.29% | 0 | 17254 - 95.86% | 1,487,632$ | 59,505,278$ | 18000 | 100 | 60,250,000$ | 60,250,000$ | 0$ | 66,211,032$ | 292,476$ | 64,220,779$ | 24 | 1 | 191,681$ | 0$ | 1 | 302,184$ | 302,184$ | 302,184$ | 64,513,255$ | 27,513,255$ | 81,438,243$ | 16,924,988$ | 12,438,243$ | 12,136,059$ |
| 16 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 231337 | 192372 | 77993 | 154552 | 38263 | 96.39% | 96.19% | 97.49% | 96.60% | 95.66% | 0 | 17363 - 96.46% | 1,495,248$ | 59,809,913$ | 18000 | 100 | 65,150,000$ | 65,150,000$ | 0$ | 65,821,979$ | 316,262$ | 64,897,080$ | 20 | 0 | 0$ | 0$ | 1 | 319,495$ | 319,495$ | 319,495$ | 65,213,342$ | 28,213,342$ | 106,490,152$ | 41,276,810$ | 37,490,152$ | 37,170,657$ |
| 17 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 229192 | 194583 | 77320 | 153900 | 39036 | 95.50% | 97.29% | 96.65% | 96.19% | 97.59% | 0 | 17351 - 96.39% | 1,496,639$ | 59,865,557$ | 18000 | 100 | 67,375,000$ | 67,375,000$ | 0$ | 68,348,202$ | 327,063$ | 67,552,086$ | 21 | 0 | 21,959,642$ | 0$ | 1 | 330,947$ | 330,947$ | 330,947$ | 67,879,149$ | 30,879,149$ | 73,181,234$ | 5,302,085$ | 4,181,234$ | 3,850,287$ |
| 18 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 227871 | 190912 | 77318 | 153283 | 38543 | 94.95% | 95.46% | 96.65% | 95.80% | 96.36% | 0 | 17198 - 95.55% | 1,482,084$ | 59,283,362$ | 18000 | 100 | 68,425,000$ | 68,425,000$ | 0$ | 69,749,411$ | 320,024$ | 65,972,100$ | 21 | 1 | 4,322,369$ | 0$ | 1 | 349,150$ | 349,150$ | 349,150$ | 66,292,124$ | 29,292,124$ | 72,587,910$ | 6,295,786$ | 3,587,910$ | 3,238,760$ |
| 19 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 231408 | 194085 | 76843 | 156935 | 38736 | 96.42% | 97.04% | 96.05% | 98.08% | 96.84% | 0 | 17450 - 96.95% | 1,502,352$ | 60,094,082$ | 18000 | 100 | 57,500,000$ | 57,500,000$ | 0$ | 62,560,559$ | 279,126$ | 61,264,476$ | 20 | 1 | 0$ | 0$ | 1 | 283,981$ | 283,981$ | 283,981$ | 61,543,602$ | 24,543,602$ | 101,354,937$ | 39,811,335$ | 32,354,937$ | 32,070,956$ |
| 20 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 234102 | 194090 | 78559 | 155140 | 39126 | 97.54% | 97.05% | 98.20% | 96.96% | 97.82% | 0 | 17525 - 97.36% | 1,512,775$ | 60,511,003$ | 18000 | 100 | 68,700,000$ | 68,700,000$ | 0$ | 69,326,653$ | 333,495$ | 68,036,379$ | 21 | 0 | 56,053,191$ | 0$ | 1 | 339,320$ | 339,320$ | 339,320$ | 68,369,874$ | 31,369,874$ | 72,167,974$ | 3,798,100$ | 3,167,974$ | 2,828,654$ |
| 21 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 227905 | 190364 | 75687 | 150752 | 37733 | 94.96% | 95.18% | 94.61% | 94.22% | 94.33% | 0 | 17061 - 94.78% | 1,472,363$ | 58,894,514$ | 18000 | 100 | 60,000,000$ | 60,000,000$ | 0$ | 59,318,048$ | 291,262$ | 58,087,352$ | 23 | 0 | 0$ | 0$ | 1 | 296,117$ | 296,117$ | 296,117$ | 58,378,614$ | 21,378,614$ | 130,945,910$ | 72,567,296$ | 61,945,910$ | 61,649,793$ |
| 22 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 229314 | 194960 | 77450 | 153237 | 38539 | 95.55% | 97.48% | 96.81% | 95.77% | 96.35% | 0 | 17338 - 96.32% | 1,494,468$ | 59,778,735$ | 18000 | 100 | 66,150,000$ | 66,150,000$ | 0$ | 67,007,004$ | 321,117$ | 64,943,957$ | 23 | 0 | 0$ | 0$ | 1 | 330,825$ | 330,825$ | 330,825$ | 65,265,074$ | 28,265,074$ | 81,590,089$ | 16,325,015$ | 12,590,089$ | 12,259,264$ |
| 23 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 231051 | 194679 | 76861 | 154971 | 38620 | 96.27% | 97.34% | 96.08% | 96.86% | 96.55% | 0 | 17405 - 96.69% | 1,500,181$ | 60,007,233$ | 18000 | 100 | 68,700,000$ | 68,700,000$ | 0$ | 68,275,843$ | 333,495$ | 67,041,031$ | 21 | 0 | 28,176,182$ | 0$ | 1 | 337,743$ | 337,743$ | 337,743$ | 67,374,526$ | 30,374,526$ | 70,566,055$ | 3,191,529$ | 1,566,055$ | 1,228,312$ |
| 24 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 231821 | 195490 | 77405 | 153978 | 38554 | 96.59% | 97.75% | 96.76% | 96.24% | 96.39% | 0 | 17431 - 96.84% | 1,503,416$ | 60,136,651$ | 18000 | 100 | 63,550,000$ | 63,550,000$ | 0$ | 61,147,711$ | 308,495$ | 59,400,148$ | 22 | 0 | 0$ | 0$ | 1 | 315,777$ | 315,777$ | 315,777$ | 59,708,643$ | 22,708,643$ | 74,026,574$ | 14,317,931$ | 5,026,574$ | 4,710,797$ |
| 25 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 230163 | 194027 | 77723 | 155823 | 39323 | 95.90% | 97.01% | 97.15% | 97.39% | 98.31% | 0 | 17426 - 96.81% | 1,502,084$ | 60,083,361$ | 18000 | 100 | 67,938,888$ | 67,938,888$ | 0$ | 66,565,738$ | 329,800$ | 65,130,071$ | 24 | 0 | 539,644$ | 0$ | 1 | 334,412$ | 334,412$ | 334,412$ | 65,459,871$ | 28,459,871$ | 72,393,820$ | 6,933,949$ | 3,393,820$ | 3,059,408$ |
| 26 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 230453 | 189001 | 76423 | 154441 | 38421 | 96.02% | 94.50% | 95.53% | 96.53% | 96.05% | 0 | 17218 - 95.66% | 1,484,929$ | 59,397,177$ | 18000 | 100 | 65,125,000$ | 65,125,000$ | 0$ | 65,420,316$ | 316,141$ | 63,710,356$ | 22 | 0 | 0$ | 0$ | 1 | 322,209$ | 322,209$ | 322,209$ | 64,026,497$ | 27,026,497$ | 78,383,887$ | 14,357,390$ | 9,383,887$ | 9,061,678$ |