| 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 |
| Capacité | Prix des billets | Assistance | Assistance PCT | Revenu | Dépenses | Estimation | Total de l’équipe estimé | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Équipe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Matchs à domicile restants | Assistance moyenne - % | Revenu moyen par match | Revenu annuel à ce jour | Capacité | Popularité de l’équipe | Salaire total des joueurs | Plafond Salariale total des joueurs | Valeur du plafond salarial spécial | Dépenses annuelles à ce jour | Plafond salarial par jour | Plafond salarial à ce jour | Joueurs Inclus dans le plafond salarial | Joueurs exclut du plafond Salarial | Taxe de luxe totale | Revenus de la saison estimés | Jours restants de la saison | Dépenses par jour | Dépenses de la saison estimées | Dépenses de la saison estimées | Cap Salarial de la Saison estimé | Au dessus du plancher salarial of 0$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Boston Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 151356 | 125743 | 49701 | 98273 | 19470 | 97.02% | 96.73% | 95.58% | 94.49% | 74.88% | 15 | 17098 - 94.99% | 1,183,482$ | 30,770,540$ | 18000 | 100 | 38,100,000$ | 38,100,000$ | 0$ | 24,373,558$ | 38,100,000$ | 24,058,408$ | 21 | 0 | 0$ | 17,752,235$ | 81 | 176,256$ | 14,276,736$ | 14,865,912$ | 40,125,000$ | 40,125,000$ | 58,000,000$ | 17,875,000$ | 47,092,271$ | 49,978,594$ |
| 2 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 144971 | 123207 | 48585 | 96032 | 19158 | 92.93% | 94.77% | 93.43% | 92.34% | 73.68% | 15 | 16614 - 92.30% | 1,147,015$ | 29,822,395$ | 18000 | 100 | 34,417,000$ | 34,417,000$ | 0$ | 21,719,352$ | 34,417,000$ | 21,404,298$ | 22 | 0 | 0$ | 17,205,228$ | 81 | 159,438$ | 12,914,478$ | 13,302,558$ | 35,580,200$ | 35,580,200$ | 58,000,000$ | 22,419,800$ | 84,930,389$ | 88,833,059$ |
| 3 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 148280 | 125303 | 49004 | 99668 | 20175 | 95.05% | 96.39% | 94.24% | 95.83% | 77.60% | 15 | 17017 - 94.54% | 1,176,462$ | 30,588,020$ | 18000 | 100 | 53,725,000$ | 53,725,000$ | 0$ | 33,618,917$ | 53,725,000$ | 33,303,852$ | 20 | 0 | 0$ | 17,646,935$ | 81 | 247,603$ | 20,055,843$ | 20,429,181$ | 54,825,000$ | 54,825,000$ | 58,000,000$ | 3,175,000$ | 28,609,069$ | 25,826,823$ |
| 4 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 156198 | 126194 | 51055 | 101989 | 20495 | 96.42% | 93.48% | 94.55% | 94.43% | 75.91% | 14 | 16886 - 93.81% | 1,171,374$ | 31,627,090$ | 18000 | 100 | 50,375,000$ | 50,375,000$ | 2,415,000$ | 30,848,163$ | 50,375,000$ | 30,533,098$ | 22 | 0 | 0$ | 16,399,232$ | 81 | 232,306$ | 18,816,786$ | 19,131,786$ | 53,640,000$ | 53,640,000$ | 58,000,000$ | 4,360,000$ | 39,825,144$ | 37,092,590$ |
| 5 | Colorado Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 153070 | 129586 | 51202 | 103050 | 20518 | 94.49% | 95.99% | 94.82% | 95.42% | 75.99% | 14 | 16942 - 94.12% | 1,168,670$ | 31,554,080$ | 18000 | 100 | 47,099,999$ | 47,099,999$ | 0$ | 32,924,915$ | 47,099,999$ | 32,308,477$ | 22 | 0 | 0$ | 16,361,375$ | 81 | 217,352$ | 17,605,512$ | 17,904,174$ | 47,879,999$ | 47,879,999$ | 58,000,000$ | 10,120,001$ | 36,916,984$ | 35,374,185$ |
| 6 | Dallas Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 150422 | 122536 | 49279 | 98749 | 19933 | 96.42% | 94.26% | 94.77% | 94.95% | 76.67% | 15 | 16958 - 94.21% | 1,175,940$ | 30,574,450$ | 18000 | 100 | 54,000,000$ | 54,000,000$ | 0$ | 32,324,159$ | 54,000,000$ | 32,009,105$ | 21 | 0 | 0$ | 17,639,106$ | 81 | 248,858$ | 20,157,498$ | 20,582,748$ | 55,322,500$ | 55,322,500$ | 58,000,000$ | 2,677,500$ | 45,824,321$ | 42,880,679$ |
| 7 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 148831 | 124502 | 49515 | 98189 | 19960 | 95.40% | 95.77% | 95.22% | 94.41% | 76.77% | 15 | 16961 - 94.23% | 1,174,345$ | 30,532,970$ | 18000 | 100 | 56,250,000$ | 56,250,000$ | 0$ | 35,089,042$ | 56,250,000$ | 34,773,949$ | 21 | 0 | 0$ | 17,615,175$ | 81 | 259,132$ | 20,989,692$ | 21,304,692$ | 57,100,000$ | 57,100,000$ | 58,000,000$ | 900,000$ | 48,912,040$ | 45,222,523$ |
| 8 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 65 | 40 | 25 | 175 | 151260 | 102186 | 38751 | 99609 | 24866 | 96.96% | 78.60% | 74.52% | 95.78% | 95.64% | 15 | 16026 - 89.03% | 1,101,819$ | 28,647,305$ | 18000 | 100 | 56,500,000$ | 56,500,000$ | 0$ | 33,939,528$ | 56,500,000$ | 33,624,442$ | 22 | 0 | 0$ | 16,527,291$ | 81 | 260,274$ | 21,082,194$ | 21,387,870$ | 57,310,000$ | 57,310,000$ | 58,000,000$ | 690,000$ | 29,322,785$ | 24,462,206$ |
| 9 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 147949 | 122943 | 49160 | 100103 | 19414 | 94.84% | 94.57% | 94.54% | 96.25% | 74.67% | 15 | 16907 - 93.93% | 1,164,518$ | 30,277,455$ | 18000 | 100 | 33,250,000$ | 33,250,000$ | 1,925,000$ | 24,002,775$ | 33,250,000$ | 23,687,631$ | 21 | 0 | 0$ | 17,467,762$ | 81 | 154,110$ | 12,482,910$ | 12,930,924$ | 36,595,000$ | 36,595,000$ | 58,000,000$ | 21,405,000$ | 76,921,402$ | 81,458,240$ |
| 10 | Minnesota Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 153262 | 127872 | 50651 | 103285 | 20651 | 94.61% | 94.72% | 93.80% | 95.63% | 76.49% | 14 | 16879 - 93.77% | 1,166,060$ | 31,483,630$ | 18000 | 100 | 45,250,000$ | 45,250,000$ | 0$ | 28,652,961$ | 45,250,000$ | 28,337,907$ | 22 | 0 | 0$ | 16,324,845$ | 81 | 208,904$ | 16,921,224$ | 17,317,872$ | 46,450,000$ | 46,450,000$ | 58,000,000$ | 11,550,000$ | 50,095,511$ | 49,102,484$ |
| 11 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 152597 | 128074 | 51120 | 104068 | 20307 | 94.20% | 94.87% | 94.67% | 96.36% | 75.21% | 14 | 16895 - 93.86% | 1,162,831$ | 31,396,440$ | 18000 | 100 | 38,200,000$ | 38,200,000$ | 0$ | 24,199,050$ | 38,200,000$ | 23,883,996$ | 21 | 0 | 0$ | 16,279,636$ | 81 | 176,712$ | 14,313,672$ | 14,774,496$ | 39,675,000$ | 39,675,000$ | 58,000,000$ | 18,325,000$ | 55,861,243$ | 57,366,383$ |
| 12 | Nashville Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 147877 | 126188 | 50916 | 99178 | 20076 | 91.28% | 93.47% | 94.29% | 91.83% | 74.36% | 14 | 16453 - 91.41% | 1,134,655$ | 30,635,690$ | 18000 | 100 | 35,900,000$ | 35,900,000$ | 0$ | 24,393,607$ | 35,900,000$ | 23,777,185$ | 22 | 0 | 0$ | 15,885,173$ | 81 | 166,210$ | 13,463,010$ | 13,743,024$ | 36,600,000$ | 36,600,000$ | 58,000,000$ | 21,400,000$ | 44,489,262$ | 46,631,411$ |
| 13 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 68 | 45 | 28 | 210 | 127831 | 98399 | 35306 | 80278 | 19210 | 78.91% | 72.89% | 65.38% | 74.33% | 71.15% | 14 | 13371 - 74.28% | 1,036,446$ | 27,984,041$ | 18000 | 100 | 56,650,000$ | 56,650,000$ | 0$ | 29,868,731$ | 56,650,000$ | 29,493,400$ | 22 | 0 | 0$ | 14,510,243$ | 81 | 260,959$ | 21,137,679$ | 21,564,693$ | 57,980,000$ | 57,980,000$ | 58,000,000$ | 20,000$ | 48,408,514$ | 41,354,064$ |
| 14 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 150814 | 122543 | 49385 | 98935 | 19591 | 96.68% | 94.26% | 94.97% | 95.13% | 75.35% | 15 | 16972 - 94.29% | 1,175,155$ | 30,554,030$ | 18000 | 100 | 50,100,000$ | 50,100,000$ | 0$ | 31,355,237$ | 50,100,000$ | 31,040,183$ | 21 | 0 | 0$ | 17,627,325$ | 81 | 231,050$ | 18,715,050$ | 19,100,064$ | 51,250,000$ | 51,250,000$ | 58,000,000$ | 6,750,000$ | 43,071,134$ | 41,598,395$ |
| 15 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 30 | 220 | 117355 | 100319 | 38786 | 74906 | 18151 | 75.23% | 77.17% | 74.59% | 72.03% | 69.81% | 15 | 13443 - 74.68% | 1,046,986$ | 27,221,625$ | 18000 | 100 | 50,999,999$ | 50,999,999$ | 2,100,000$ | 30,406,432$ | 50,999,999$ | 30,091,330$ | 22 | 0 | 0$ | 15,704,784$ | 81 | 235,160$ | 19,047,960$ | 19,512,312$ | 54,589,999$ | 54,589,999$ | 58,000,000$ | 3,410,001$ | 55,644,164$ | 51,836,636$ |
| 16 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 153938 | 127687 | 52404 | 103725 | 20796 | 95.02% | 94.58% | 97.04% | 96.04% | 77.02% | 14 | 16983 - 94.35% | 1,171,907$ | 31,641,485$ | 18000 | 100 | 56,500,000$ | 56,500,000$ | 175,000$ | 34,205,449$ | 51,000,000$ | 33,739,702$ | 21 | 1 | 0$ | 16,406,696$ | 81 | 260,274$ | 21,082,194$ | 21,410,046$ | 52,080,000$ | 52,080,000$ | 58,000,000$ | 5,920,000$ | 71,640,078$ | 66,636,728$ |
| 17 | Seattle Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 155799 | 130640 | 52066 | 104147 | 20690 | 96.17% | 96.77% | 96.42% | 96.43% | 76.63% | 14 | 17161 - 95.34% | 1,184,529$ | 31,982,285$ | 18000 | 100 | 51,500,000$ | 51,500,000$ | 0$ | 28,730,128$ | 51,500,000$ | 28,415,072$ | 22 | 0 | 0$ | 16,583,407$ | 81 | 237,443$ | 19,232,883$ | 19,707,735$ | 53,035,000$ | 53,035,000$ | 58,000,000$ | 4,965,000$ | 41,509,409$ | 38,385,081$ |
| 18 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 155360 | 127074 | 51794 | 102427 | 20368 | 95.90% | 94.13% | 95.91% | 94.84% | 75.44% | 14 | 16927 - 94.04% | 1,170,648$ | 31,607,505$ | 18000 | 100 | 53,000,000$ | 53,000,000$ | 0$ | 33,740,875$ | 53,000,000$ | 33,425,807$ | 22 | 0 | 0$ | 16,389,077$ | 81 | 244,292$ | 19,787,652$ | 20,149,314$ | 54,050,000$ | 54,050,000$ | 58,000,000$ | 3,950,000$ | 34,667,096$ | 30,906,859$ |
| 19 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 45 | 25 | 20 | 190 | 157202 | 130830 | 52125 | 105118 | 25339 | 97.04% | 96.91% | 96.53% | 97.33% | 93.85% | 14 | 17430 - 96.83% | 988,274$ | 26,683,405$ | 18000 | 100 | 48,425,000$ | 48,425,000$ | 0$ | 34,008,471$ | 48,425,000$ | 33,693,350$ | 21 | 0 | 0$ | 13,835,840$ | 81 | 223,402$ | 18,095,562$ | 18,433,914$ | 49,375,000$ | 49,375,000$ | 58,000,000$ | 8,625,000$ | 19,315,756$ | 14,717,682$ |
| 20 | Utah Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 120 | 70 | 50 | 25 | 64945 | 54501 | 21641 | 43415 | 26000 | 41.63% | 41.92% | 41.62% | 41.75% | 100.00% | 15 | 8096 - 44.98% | 917,875$ | 23,864,740$ | 18000 | 100 | 34,350,000$ | 34,350,000$ | 0$ | 26,076,681$ | 34,350,000$ | 25,761,624$ | 22 | 0 | 0$ | 13,768,119$ | 81 | 159,132$ | 12,889,692$ | 13,309,692$ | 35,650,000$ | 35,650,000$ | 58,000,000$ | 22,350,000$ | 23,496,657$ | 23,955,084$ |
| 21 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 153985 | 129503 | 51000 | 103687 | 20352 | 95.05% | 95.93% | 94.44% | 96.01% | 75.38% | 14 | 16982 - 94.35% | 1,170,972$ | 31,616,255$ | 18000 | 100 | 53,950,000$ | 53,950,000$ | 350,000$ | 34,160,262$ | 53,950,000$ | 33,845,208$ | 22 | 0 | 0$ | 16,393,614$ | 81 | 248,630$ | 20,139,030$ | 20,494,854$ | 55,325,000$ | 55,325,000$ | 58,000,000$ | 2,675,000$ | 73,176,101$ | 69,074,861$ |
| 22 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 147874 | 123876 | 50339 | 99466 | 19727 | 91.28% | 91.76% | 93.22% | 92.10% | 73.06% | 14 | 16344 - 90.80% | 1,126,440$ | 30,413,875$ | 18000 | 100 | 40,650,000$ | 40,650,000$ | 0$ | 25,021,925$ | 40,650,000$ | 24,706,865$ | 24 | 0 | 0$ | 15,770,157$ | 81 | 187,900$ | 15,219,900$ | 15,893,664$ | 43,037,500$ | 43,037,500$ | 58,000,000$ | 14,962,500$ | 43,310,201$ | 43,186,694$ |