| 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 70,600,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Blackhawks | 6000 | 5000 | 5000 | 5000 | 1000 | 100 | 50 | 30 | 15 | 180 | 152373 | 176386 | 146779 | 163567 | 37000 | 68.64% | 95.34% | 79.34% | 88.41% | 100.00% | 4 | 18273 - 83.06% | 1,513,094$ | 55,984,476$ | 22000 | 100 | 87,457,860$ | 87,457,860$ | 0$ | 84,234,528$ | 87,457,860$ | 82,486,628$ | 21 | 1 | 0$ | 6,052,376$ | 15 | 751,747$ | 11,276,205$ | 11,276,205$ | 87,457,860$ | 16,857,860$ | 95,500,000$ | 8,042,140$ | 73,682,606$ | 68,458,777$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 185000 | 148000 | 148673 | 148000 | 37000 | 100.00% | 100.00% | 96.96% | 100.00% | 100.00% | 4 | 18018 - 99.31% | 1,282,213$ | 47,441,886$ | 18144 | 100 | 91,155,000$ | 91,155,000$ | 0$ | 81,940,727$ | 91,155,000$ | 79,789,455$ | 22 | 0 | 0$ | 5,128,853$ | 15 | 791,218$ | 11,868,270$ | 11,868,270$ | 91,155,000$ | 20,555,000$ | 95,500,000$ | 4,345,000$ | -75,265,752$ | -82,005,169$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 121364 | 92500 | 74000 | 74000 | 18530 | 54.67% | 50.00% | 50.00% | 50.00% | 50.08% | 4 | 10281 - 51.40% | 1,658,128$ | 61,350,754$ | 20000 | 100 | 67,550,084$ | 67,550,084$ | 5,937,500$ | 64,326,575$ | 67,550,084$ | 62,578,674$ | 24 | 0 | 0$ | 6,632,514$ | 15 | 584,454$ | 8,766,810$ | 8,766,810$ | 73,487,584$ | 2,887,584$ | 95,500,000$ | 22,012,416$ | 215,980,101$ | 213,845,805$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 203983 | 170409 | 156191 | 169912 | 36000 | 80.95% | 78.89% | 72.31% | 94.40% | 100.00% | 5 | 20458 - 81.83% | 1,486,906$ | 53,528,598$ | 25000 | 100 | 82,946,061$ | 82,946,061$ | 0$ | 75,855,470$ | 82,946,061$ | 73,233,630$ | 23 | 0 | 0$ | 7,434,528$ | 15 | 722,236$ | 10,833,540$ | 10,833,540$ | 82,946,061$ | 12,346,061$ | 95,500,000$ | 12,553,939$ | 49,672,796$ | 46,273,784$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 82 | 50 | 36 | 15 | 178 | 200930 | 170807 | 114288 | 147528 | 37000 | 90.51% | 92.33% | 96.74% | 99.68% | 100.00% | 4 | 18123 - 94.43% | 1,547,660$ | 57,263,423$ | 19193 | 100 | 71,860,000$ | 71,860,000$ | 620,046$ | 66,929,150$ | 71,860,000$ | 65,369,480$ | 24 | 0 | 0$ | 6,190,640$ | 15 | 620,672$ | 9,310,080$ | 9,310,080$ | 72,480,046$ | 1,880,046$ | 95,500,000$ | 23,019,954$ | 101,453,435$ | 98,333,995$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 207850 | 173218 | 149992 | 160422 | 37999 | 93.63% | 93.63% | 85.34% | 96.35% | 100.00% | 4 | 19716 - 92.66% | 1,562,508$ | 57,812,779$ | 21277 | 100 | 94,258,750$ | 94,258,750$ | 0$ | 81,976,131$ | 94,258,750$ | 81,312,242$ | 23 | 0 | 0$ | 6,250,030$ | 15 | 808,897$ | 12,133,455$ | 12,133,455$ | 94,258,750$ | 23,658,750$ | 95,500,000$ | 1,241,250$ | 82,673,262$ | 76,789,837$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 58 | 36 | 16 | 130 | 184898 | 148000 | 109083 | 121581 | 37000 | 99.94% | 100.00% | 92.89% | 82.15% | 100.00% | 4 | 16231 - 94.51% | 1,421,467$ | 52,594,272$ | 17174 | 100 | 90,379,881$ | 90,379,881$ | 0$ | 77,925,939$ | 90,379,881$ | 77,052,011$ | 25 | 0 | 0$ | 5,685,867$ | 15 | 767,898$ | 11,518,470$ | 11,518,470$ | 90,379,881$ | 19,779,881$ | 95,500,000$ | 5,120,119$ | -16,970,830$ | -22,803,433$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 206568 | 176290 | 143614 | 160749 | 43347 | 93.05% | 95.29% | 68.48% | 72.41% | 78.10% | 4 | 19745 - 81.70% | 1,552,888$ | 57,456,851$ | 24168 | 100 | 79,833,420$ | 79,833,420$ | 0$ | 75,883,681$ | 79,833,420$ | 75,446,685$ | 22 | 1 | 0$ | 6,211,551$ | 15 | 675,071$ | 10,126,065$ | 10,126,065$ | 79,833,420$ | 9,233,420$ | 95,500,000$ | 15,666,580$ | 132,266,828$ | 128,352,314$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 86 | 59 | 37 | 21 | 200 | 189736 | 160801 | 109683 | 116916 | 35745 | 93.24% | 96.58% | 98.81% | 90.28% | 96.61% | 4 | 16564 - 94.65% | 1,580,857$ | 58,491,698$ | 17500 | 100 | 88,795,807$ | 88,795,807$ | 0$ | 75,954,897$ | 88,795,807$ | 75,080,956$ | 22 | 0 | 0$ | 6,323,427$ | 15 | 754,587$ | 11,318,805$ | 11,318,805$ | 88,795,807$ | 18,195,807$ | 95,500,000$ | 6,704,193$ | 105,647,096$ | 100,651,718$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 150793 | 142215 | 109342 | 101268 | 23169 | 89.08% | 87.85% | 87.17% | 81.10% | 78.27% | 4 | 14237 - 86.21% | 1,508,858$ | 55,827,738$ | 16515 | 100 | 94,451,857$ | 94,451,857$ | 662,250$ | 83,325,175$ | 94,451,857$ | 81,577,276$ | 23 | 0 | 0$ | 6,035,431$ | 15 | 810,520$ | 12,157,800$ | 12,157,800$ | 95,114,107$ | 24,514,107$ | 95,500,000$ | 385,893$ | 220,290,470$ | 214,168,101$ |
| 11 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 158903 | 119139 | 141770 | 121848 | 42291 | 81.03% | 74.88% | 89.11% | 74.54% | 87.92% | 4 | 15782 - 80.45% | 1,528,233$ | 56,544,625$ | 19618 | 100 | 91,225,000$ | 91,225,000$ | -2,437,500$ | 79,990,910$ | 91,225,000$ | 77,369,025$ | 23 | 0 | 0$ | 6,112,932$ | 15 | 791,807$ | 11,877,105$ | 11,877,105$ | 88,787,500$ | 18,187,500$ | 95,500,000$ | 6,712,500$ | -3,998,302$ | -9,762,475$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 87 | 58 | 18 | 10 | 205 | 207694 | 162214 | 160381 | 172776 | 33895 | 93.56% | 87.68% | 86.69% | 77.83% | 91.61% | 4 | 19918 - 86.60% | 1,552,176$ | 57,430,520$ | 23000 | 100 | 83,909,999$ | 83,909,999$ | 3,500,000$ | 75,599,945$ | 83,909,999$ | 73,852,018$ | 23 | 0 | 0$ | 6,208,705$ | 15 | 721,933$ | 10,828,995$ | 10,828,995$ | 87,409,999$ | 16,809,999$ | 95,500,000$ | 8,090,001$ | 135,858,663$ | 131,238,373$ |
| 13 | Mammoth | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 148000 | 140612 | 129404 | 111000 | 44005 | 100.00% | 95.01% | 99.93% | 100.00% | 69.96% | 4 | 15487 - 95.60% | 1,278,163$ | 47,292,021$ | 16200 | 100 | 99,888,333$ | 99,888,333$ | -4,500,000$ | 84,532,717$ | 99,888,333$ | 81,910,866$ | 22 | 0 | 0$ | 5,112,651$ | 15 | 864,608$ | 12,969,120$ | 12,969,120$ | 95,388,333$ | 24,788,333$ | 95,500,000$ | 111,667$ | 225,117,613$ | 217,261,144$ |
| 14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 70 | 45 | 30 | 25 | 165 | 205541 | 176248 | 129413 | 153715 | 41557 | 85.46% | 85.06% | 99.93% | 86.55% | 80.23% | 4 | 19094 - 87.59% | 1,456,473$ | 53,889,501$ | 21800 | 100 | 75,188,333$ | 75,188,333$ | 0$ | 70,260,431$ | 75,188,333$ | 69,663,791$ | 21 | 0 | 0$ | 5,825,892$ | 15 | 644,440$ | 9,666,600$ | 9,666,600$ | 75,188,333$ | 4,588,333$ | 95,500,000$ | 20,311,667$ | 29,835,097$ | 25,994,389$ |
| 15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 169656 | 170660 | 93003 | 124175 | 34738 | 76.42% | 92.25% | 96.68% | 83.90% | 93.89% | 4 | 16006 - 86.06% | 1,541,207$ | 57,024,647$ | 18600 | 100 | 61,066,667$ | 61,066,667$ | 11,000,000$ | 61,206,944$ | 61,066,667$ | 57,711,104$ | 25 | 0 | 0$ | 6,164,827$ | 15 | 546,779$ | 8,201,685$ | 8,201,685$ | 72,066,667$ | 1,466,667$ | 95,500,000$ | 23,433,333$ | 30,680,361$ | 28,643,503$ |
| 16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 38 | 14 | 200 | 208834 | 175052 | 115860 | 167332 | 35037 | 94.07% | 94.62% | 96.35% | 90.45% | 94.69% | 4 | 18976 - 93.71% | 1,577,753$ | 58,376,859$ | 20250 | 100 | 100,175,000$ | 100,175,000$ | -4,750,000$ | 88,273,285$ | 100,175,000$ | 86,088,443$ | 23 | 0 | 0$ | 6,311,012$ | 15 | 862,815$ | 12,942,225$ | 12,942,225$ | 95,425,000$ | 24,825,000$ | 95,500,000$ | 75,000$ | 95,495,620$ | 88,864,407$ |
| 17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 150750 | 138198 | 139150 | 122454 | 46250 | 64.16% | 67.91% | 86.46% | 82.74% | 50.00% | 4 | 16130 - 71.06% | 1,608,242$ | 59,504,953$ | 22700 | 100 | 95,206,191$ | 95,206,191$ | 0$ | 84,295,342$ | 95,206,191$ | 82,547,442$ | 21 | 0 | 0$ | 6,432,968$ | 15 | 816,859$ | 12,252,885$ | 12,252,885$ | 95,206,191$ | 24,606,191$ | 95,500,000$ | 293,809$ | 32,580,523$ | 26,760,606$ |
| 18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 70 | 56 | 25 | 12 | 85 | 219528 | 172828 | 152454 | 172069 | 49729 | 84.76% | 93.42% | 91.56% | 93.01% | 89.60% | 4 | 20719 - 90.08% | 1,415,438$ | 52,371,220$ | 23000 | 100 | 100,499,999$ | 100,499,999$ | -8,750,000$ | 87,028,836$ | 100,499,999$ | 83,969,992$ | 21 | 0 | 0$ | 5,661,754$ | 15 | 873,950$ | 13,109,250$ | 13,109,250$ | 91,749,999$ | 21,149,999$ | 95,500,000$ | 3,750,001$ | 128,526,154$ | 121,078,658$ |
| 19 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 81 | 43 | 42 | 17 | 190 | 203268 | 175297 | 95160 | 143903 | 36000 | 94.11% | 97.39% | 99.67% | 99.93% | 100.00% | 5 | 18156 - 97.34% | 1,583,745$ | 57,014,814$ | 18652 | 100 | 87,043,000$ | 87,043,000$ | 0$ | 76,870,372$ | 87,043,000$ | 75,378,324$ | 26 | 0 | 0$ | 7,918,724$ | 15 | 747,000$ | 11,205,000$ | 11,205,000$ | 87,043,000$ | 16,443,000$ | 95,500,000$ | 8,457,000$ | -16,549,798$ | -19,836,074$ |
| 20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 120540 | 92500 | 74000 | 74000 | 18541 | 54.30% | 50.00% | 50.00% | 50.00% | 50.11% | 4 | 10259 - 51.29% | 1,654,158$ | 61,203,837$ | 20000 | 100 | 95,164,280$ | 95,164,280$ | 0$ | 82,798,210$ | 95,164,280$ | 80,176,366$ | 23 | 0 | 0$ | 6,616,631$ | 15 | 824,910$ | 12,373,650$ | 12,373,650$ | 95,164,280$ | 24,564,280$ | 95,500,000$ | 335,720$ | 400,932$ | -5,356,087$ |